[Sommaire] [Imprimer]

   1  CREATE TABLE tblUsers (
   2    id            INTEGER NOT NULL PRIMARY KEY,
   3    name            VARCHAR(128) NOT NULL UNIQUE,
   4    full_name        VARCHAR(128) DEFAULT '',
   5    role          INTEGER NOT NULL DEFAULT 0, /* 0: user, 1: admin */
   6    passwd        VARCHAR(128) NOT NULL,
   7    vcode            VARCHAR(128) DEFAULT '',
   8    email            VARCHAR(128) NOT NULL,
   9    reg_time        INTEGER NOT NULL,
  10    status        INTEGER NOT NULL DEFAULT 0, /* 0: normal, 1: disabled, 2: pending approval */
  11    website        VARCHAR(128) DEFAULT ''
  12  );
  13  
  14  CREATE TABLE tblPosts (
  15    id            INTEGER NOT NULL PRIMARY KEY,
  16    author_id        INTEGER NOT NULL,
  17    create_time    INTEGER NOT NULL,
  18    modify_time    INTEGER DEFAULT 0,
  19    title            VARCHAR(256) NOT NULL,
  20    content        TEXT NOT NULL,
  21    status        INTEGER NOT NULL DEFAULT 0, /* 0: published, 1: draft, 2: pending approval */
  22    comment_count    INTEGER NOT NULL DEFAULT 0
  23  );
  24  
  25  CREATE TABLE tblComments (
  26    id            INTEGER NOT NULL PRIMARY KEY,
  27    post_id        INTEGER NOT NULL,
  28    author_name    VARCHAR(64) NOT NULL,
  29    author_email    VARCHAR(128) NOT NULL,
  30    author_website VARCHAR(128) DEFAULT '',
  31    author_ip        CHAR(16) NOT NULL,
  32    create_time    INTEGER NOT NULL,
  33    status        INTEGER NOT NULL DEFAULT 0, /* 0: published, 1: pending approval */
  34    content        TEXT NOT NULL
  35  );
  36  
  37  CREATE TABLE tblCategories (
  38    id            INTEGER NOT NULL PRIMARY KEY,
  39    name            VARCHAR(128) NOT NULL UNIQUE,
  40    description    TEXT DEFAULT '',
  41    post_count    INTEGER NOT NULL DEFAULT 0
  42  );
  43  
  44  CREATE TABLE tblAttachments (
  45    id            VARCHAR(128) NOT NULL PRIMARY KEY,
  46    post_id        INTEGER NOT NULL,
  47    create_time    INTEGER NOT NULL,
  48    file_name        VARCHAR(128) NOT NULL,
  49    file_size        INTEGER NOT NULL,
  50    mime_type        VARCHAR(32) NOT NULL DEFAULT 'text/html',
  51    download_count INTEGER NOT NULL DEFAULT 0
  52  );
  53  
  54  CREATE TABLE tblPost2Category (
  55    post_id        INTEGER NOT NULL,
  56    category_id    INTEGER NOT NULL,
  57    PRIMARY KEY (post_id, category_id)
  58  );
  59  
  60  INSERT INTO tblUsers (id,name,full_name,role,status,passwd,email,reg_time,website)
  61      VALUES (1,'admin','Prado User',1,0,'4d688da592969d0a56b5accec3ce8554','admin@example.com',1148819681,'http://www.pradosoft.com');
  62  
  63  INSERT INTO tblPosts (id,author_id,create_time,title,content,status)
  64      VALUES (1,1,1148819691,'Welcome to Prado Weblog','Congratulations! You have successfully installed Prado Blog -- a PRADO-driven weblog system. A default administrator account has been created. Please login with <b>admin/prado</b> and update your password as soon as possible.',0);
  65  
  66  INSERT INTO tblCategories (name,description,post_count)
  67      VALUES ('Miscellaneous','This category holds posts on any topic.',1);
  68  
  69  INSERT INTO tblCategories (name,description,post_count)
  70      VALUES ('PRADO','Topics related with the PRADO framework.',0);
  71  
  72  INSERT INTO tblCategories (name,description,post_count)
  73      VALUES ('PHP','Topics related with PHP.',0);
  74  
  75  INSERT INTO tblPost2Category (post_id,category_id)
  76      VALUES (1,1);