Location: PHPKode > projects > Spam free PHP GuestBook > Spam free PHP GuestBook-1.2beta/gb/admin/install/query.txt
CREATE TABLE prefix_admin(id INT NOT NULL AUTO_INCREMENT, user VARCHAR(20) NOT NULL, password CHAR(32) NOT NULL, login CHAR(16) NOT NULL, session VARCHAR(16) NOT NULL, email VARCHAR(110) NOT NULL, PRIMARY KEY(id))
CREATE TABLE prefix_user(id INT NOT NULL AUTO_INCREMENT, user VARCHAR(12) NOT NULL, login VARCHAR(16) NOT NULL, session VARCHAR(16) NOT NULL, password VARCHAR(16) NOT NULL, name VARCHAR(64) NOT NULL, email VARCHAR(110) NOT NULL, website VARCHAR(200) NOT NULL, level INT(2), allowemail CHAR(1) NOT NULL, date BIGINT(20), PRIMARY KEY(id))
CREATE TABLE prefix_comments(id INT NOT NULL AUTO_INCREMENT, pid INT NOT NULL, uid INT NOT NULL, title VARCHAR(100), comment TEXT, autolink CHAR(1) NOT NULL, publish CHAR(1) NOT NULL, date BIGINT(20), PRIMARY KEY(id))
CREATE TABLE prefix_post(id INT NOT NULL AUTO_INCREMENT,  uid INT NOT NULL, title VARCHAR(100), description VARCHAR(255) NOT NULL, keywords VARCHAR(255) NOT NULL, content LONGTEXT, autolink CHAR(1) NOT NULL, locked CHAR(1) NOT NULL, publish CHAR(1) NOT NULL, date BIGINT(20), PRIMARY KEY(id))
CREATE TABLE prefix_settings(id INT NOT NULL AUTO_INCREMENT, sitename VARCHAR(100) NOT NULL, description VARCHAR(255) NOT NULL, keywords VARCHAR(255) NOT NULL, blocksite CHAR(1) NOT NULL, approval CHAR(1) NOT NULL, allowemail CHAR(1) NOT NULL, nofollow CHAR(1) NOT NULL, defaultstyle VARCHAR(55) NOT NULL, postsize INT(6), commentsize INT(6), listcount INT(3), imagecount INT(1), imagewidth INT(3), imageheight INT(3), verifyuser CHAR(1) NOT NULL, PRIMARY KEY(id))
CREATE TABLE prefix_tmpuser(id INT NOT NULL AUTO_INCREMENT, uid INT NOT NULL, email VARCHAR(110) NOT NULL, verify VARCHAR(16) NOT NULL, date BIGINT(20), PRIMARY KEY(id))
INSERT INTO prefix_user (id, user, password, name, email, website, level, allowemail, date) VALUES (1, 'author', '_RANDOM_', 'Archan Ghosal', 'hide@address.com', 'http://ramui.com/', 6, 'Y', _DATE_)
INSERT INTO prefix_post (uid, title, description, keywords, content, autolink, locked, publish, date) VALUES (1, 'PHP GuestBook has been successfully installed!', '', '', '[b]Congratulations![/b] Your PHP guestbook script has been successfully installed. If you''re happy with this script please put few words on my forum. If you have any problem or suggestion bout this script please do not heisted to contact me.\nRegards,\nArchan Ghosal (script author).', 'Y', '', 'Y', _DATE_);
INSERT INTO prefix_post (uid, title, description, keywords, content, autolink, locked, publish, date) VALUES (1, 'Quick start guide for PHP GuestBook', '', '', 'Here is a quick start guide for this PHP guestbook script. After reading this post you can remove it.\nThis script allows only registered users to post a new message or put comments over messages.  So as an administrator your first task is to create a user account by following the link below.\nYour next task is to edit the default settings of this script according to your preference. Log in to your admin control panel; click on the \"settings\" link at the top of your admin panel.[img]gb/settings.gif[/img]\nPlease provide a suitable title, description and keywords for better indexing of search engines. Detail about the script settings are provided at the product documentation page. For any problem you can contact me by clicking the contact icon below.\nRegards,\nArchan Ghosal (script author).', 'Y', '', 'Y', _DATE_)
Return current item: Spam free PHP GuestBook