CREATE TABLE tblUsers ( id INTEGER NOT NULL PRIMARY KEY, name VARCHAR(128) NOT NULL UNIQUE, full_name VARCHAR(128) DEFAULT '', role INTEGER NOT NULL DEFAULT 0, /* 0: user, 1: admin */ passwd VARCHAR(128) NOT NULL, vcode VARCHAR(128) DEFAULT '', email VARCHAR(128) NOT NULL, reg_time INTEGER NOT NULL, status INTEGER NOT NULL DEFAULT 0, /* 0: normal, 1: disabled, 2: pending approval */ website VARCHAR(128) DEFAULT '' ); CREATE TABLE tblPosts ( id INTEGER NOT NULL PRIMARY KEY, author_id INTEGER NOT NULL, create_time INTEGER NOT NULL, modify_time INTEGER DEFAULT 0, title VARCHAR(256) NOT NULL, content TEXT NOT NULL, status INTEGER NOT NULL DEFAULT 0, /* 0: published, 1: draft, 2: pending approval */ comment_count INTEGER NOT NULL DEFAULT 0 ); CREATE TABLE tblComments ( id INTEGER NOT NULL PRIMARY KEY, post_id INTEGER NOT NULL, author_name VARCHAR(64) NOT NULL, author_email VARCHAR(128) NOT NULL, author_website VARCHAR(128) DEFAULT '', author_ip CHAR(16) NOT NULL, create_time INTEGER NOT NULL, status INTEGER NOT NULL DEFAULT 0, /* 0: published, 1: pending approval */ content TEXT NOT NULL ); CREATE TABLE tblCategories ( id INTEGER NOT NULL PRIMARY KEY, name VARCHAR(128) NOT NULL UNIQUE, description TEXT DEFAULT '', post_count INTEGER NOT NULL DEFAULT 0 ); CREATE TABLE tblAttachments ( id VARCHAR(128) NOT NULL PRIMARY KEY, post_id INTEGER NOT NULL, create_time INTEGER NOT NULL, file_name VARCHAR(128) NOT NULL, file_size INTEGER NOT NULL, mime_type VARCHAR(32) NOT NULL DEFAULT 'text/html', download_count INTEGER NOT NULL DEFAULT 0 ); CREATE TABLE tblPost2Category ( post_id INTEGER NOT NULL, category_id INTEGER NOT NULL, PRIMARY KEY (post_id, category_id) ); INSERT INTO tblUsers (id,name,full_name,role,status,passwd,email,reg_time,website) VALUES (1,'admin','Prado User',1,0,'4d688da592969d0a56b5accec3ce8554','admin@example.com',1438819691,'https://github.com/pradosoft/prado'); INSERT INTO tblPosts (id,author_id,create_time,title,content,status) VALUES (1,1,1438819691,'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 admin/prado and update your password as soon as possible.',0); INSERT INTO tblCategories (name,description,post_count) VALUES ('Miscellaneous','This category holds posts on any topic.',1); INSERT INTO tblCategories (name,description,post_count) VALUES ('PRADO','Topics related with the PRADO framework.',0); INSERT INTO tblCategories (name,description,post_count) VALUES ('PHP','Topics related with PHP.',0); INSERT INTO tblPost2Category (post_id,category_id) VALUES (1,1);