Location: PHPKode > scripts > Ramui web hosting directory script > Ramui web hosting directory script/gb/admin/install/query.txt
CREATE TABLE prefix_admin (id int(11) unsigned NOT NULL AUTO_INCREMENT, user varchar(20) NOT NULL, password char(32) NOT NULL, login char(16) DEFAULT NULL, session varchar(16) NOT NULL, email varchar(110) DEFAULT NULL, PRIMARY KEY (id)) ENGINE=MyISAM  DEFAULT CHARSET=latin1
CREATE TABLE prefix_comments (id int(11) unsigned NOT NULL AUTO_INCREMENT, pid int(11) NOT NULL, uid int(11) NOT NULL, title varchar(100) DEFAULT NULL, comment text, autolink char(1) DEFAULT NULL, publish char(1) NOT NULL, updated bigint(20) NOT NULL, date bigint(20) DEFAULT NULL, PRIMARY KEY (id)) ENGINE=MyISAM  DEFAULT CHARSET=latin1
CREATE TABLE prefix_inbox (id int(11) unsigned NOT NULL AUTO_INCREMENT, name varchar(64) NOT NULL, subject varchar(120) NOT NULL, email varchar(120) NOT NULL, message text NOT NULL, new tinyint(1) NOT NULL, date bigint(20) NOT NULL, PRIMARY KEY (id)) ENGINE=MyISAM  DEFAULT CHARSET=latin1
CREATE TABLE prefix_mailsettings (id int(11) unsigned NOT NULL AUTO_INCREMENT, messagesize int(4) NOT NULL, defaultfrom varchar(120) NOT NULL, replyto varchar(120) NOT NULL, response text NOT NULL, autoresponder tinyint(1) NOT NULL, PRIMARY KEY (id)) ENGINE=MyISAM  DEFAULT CHARSET=latin1
CREATE TABLE prefix_post (id int(11) unsigned NOT NULL AUTO_INCREMENT, url varchar(200) NOT NULL, afflink varchar(255) NOT NULL, uid int(11) NOT NULL, title varchar(100) DEFAULT NULL, description varchar(255) DEFAULT NULL, keywords varchar(255) DEFAULT NULL, content text, autolink tinyint(1) NOT NULL, locked char(1) NOT NULL, publish char(1) DEFAULT NULL, view int(4) NOT NULL, bw decimal(5,2) NOT NULL, usd decimal(5,2) NOT NULL DEFAULT 0.00, space decimal(5,2) NOT NULL, uptime decimal(4,2) NOT NULL, noofdomain tinyint(2) NOT NULL, freedomain tinyint(1) NOT NULL, server tinyint(1) NOT NULL, date bigint(20) DEFAULT NULL, updated bigint(20) DEFAULT NULL, PRIMARY KEY (id)) ENGINE=MyISAM  DEFAULT CHARSET=latin1
CREATE TABLE prefix_report (id int(11) unsigned NOT NULL AUTO_INCREMENT, name varchar(64) NOT NULL, subject varchar(120) NOT NULL, email varchar(120) NOT NULL, pid int(11) NOT NULL, cid int(11) NOT NULL, message text NOT NULL, new tinyint(1) NOT NULL, date bigint(20) NOT NULL, PRIMARY KEY (id)) ENGINE=MyISAM  DEFAULT CHARSET=latin1
CREATE TABLE prefix_search (id int(11) unsigned NOT NULL AUTO_INCREMENT, pid int(11) NOT NULL, cid int(11) NOT NULL, uid int(11) NOT NULL, title varchar(100) NOT NULL, keywords varchar(255) NOT NULL, description varchar(255) NOT NULL, url varchar(200) NOT NULL, body text NOT NULL, publish char(1) NOT NULL, PRIMARY KEY (id), FULLTEXT KEY score (title,keywords,description,url,body)) ENGINE=MyISAM  DEFAULT CHARSET=latin1
CREATE TABLE prefix_searchkey (id int(10) unsigned NOT NULL AUTO_INCREMENT, keywords varchar(100) NOT NULL, hit int(5) NOT NULL, date bigint(20) NOT NULL, PRIMARY KEY (id)) ENGINE=MyISAM  DEFAULT CHARSET=latin1
CREATE TABLE prefix_settings (id int(11) unsigned NOT NULL AUTO_INCREMENT, sitename varchar(100) DEFAULT NULL, description varchar(255) DEFAULT NULL, keywords varchar(255) DEFAULT NULL, blocksite tinyint(1) NOT NULL, approval char(1) DEFAULT NULL, allowemail tinyint(1) NOT NULL, nofollow char(1) NOT NULL, defaultstyle varchar(55) DEFAULT NULL, postsize int(6) DEFAULT NULL, commentsize int(6) DEFAULT NULL, listcount int(3) DEFAULT NULL, commentcount int(2) NOT NULL, verifyuser tinyint(1) NOT NULL, allowedit tinyint(1) NOT NULL, afflink tinyint(1) NOT NULL, PRIMARY KEY (id)) ENGINE=MyISAM  DEFAULT CHARSET=latin1
CREATE TABLE prefix_tmpuser (id int(10) unsigned NOT NULL AUTO_INCREMENT, uid int(11) NOT NULL, email varchar(110) DEFAULT NULL, verify varchar(16) NOT NULL, action tinyint(1) NOT NULL, date bigint(20) DEFAULT NULL, PRIMARY KEY (id)) ENGINE=MyISAM  DEFAULT CHARSET=latin1
CREATE TABLE prefix_user (id int(11) unsigned NOT NULL AUTO_INCREMENT, user varchar(12) NOT NULL, login varchar(16) NOT NULL, session varchar(16) NOT NULL, password char(32) NOT NULL, name varchar(64) NOT NULL, email varchar(110) DEFAULT NULL, website varchar(200) DEFAULT NULL, level int(2) NOT NULL, allowemail char(1) NOT NULL, date bigint(20) DEFAULT NULL, PRIMARY KEY (id)) ENGINE=MyISAM  DEFAULT CHARSET=latin1
INSERT INTO prefix_mailsettings (messagesize, defaultfrom, replyto, response, autoresponder) VALUES (1250, 'hide@address.com', '__EMAIL__', 'Dear %%SENDER%%,\n\nWe receive your message. We will contact you shortly.\n\nRegards,\nClient Support\n_______________________________________________\n**Please note that this is a system-generated e-mail; please do not reply.\n\n%%SENDER%% wrote:\n%%MESSAGE%%', 0)
INSERT INTO prefix_settings (sitename, description, keywords, defaultstyle, postsize, commentsize, listcount, commentcount, allowedit, allowemail, approval, nofollow) VALUES ('Web hosting directory', 'ramui web hosting directory script is a featureful and an easy to use PHP MySql directory script.', 'webhosting,directory,directory script,PHP,webhosting directory script', 'simple', 5000, 1000, 50, 10, 1, 1, 'A', 'Y')
INSERT INTO prefix_searchkey (keywords, hit) VALUES ('free web hosting',98), ('top web hosting',97), ('web hosting affordable',96), ('cheap web hosting',95), ('cheapest web hosting',94), ('budget web hosting',93), ('best web hosting',92), ('web hosting domain',91), ('business web hosting',88), ('web hosting resellers',84), ('web hosting uk',82), ('resell web hosting',79), ('php web hosting',73), ('unlimited web hosting',71), ('ecommerce web hosting',70), ('dedicated web hosting',68), ('web hosting for small business',63)
Return current item: Ramui web hosting directory script