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=utf8 COLLATE=utf8_bin
CREATE TABLE prefix_category (id int(2) unsigned NOT NULL AUTO_INCREMENT, title VARCHAR(100) NOT NULL, position int(2) NOT NULL, icon VARCHAR(200) NOT NULL, PRIMARY KEY (id)) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin
CREATE TABLE prefix_filesettings (id int(2) unsigned NOT NULL AUTO_INCREMENT, size int(4) unsigned NOT NULL, height int(3) unsigned NOT NULL, width int(3) unsigned NOT NULL, fpp int(2) NOT NULL, extensions varchar(300) NOT NULL, PRIMARY KEY (id)) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin
CREATE TABLE prefix_forum (id int(5) unsigned NOT NULL AUTO_INCREMENT, parent int(5) NOT NULL, cid int(2) NOT NULL, title VARCHAR(100) NOT NULL, icon VARCHAR(200) NOT NULL, sdescription varchar(300) DEFAULT NULL, description varchar(300) NOT NULL, keywords varchar(300) NOT NULL, locked char(1) NOT NULL, position int(2) NOT NULL, PRIMARY KEY (id)) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin
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=utf8 COLLATE=utf8_bin
CREATE TABLE prefix_mailsettings (id int(2) 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=utf8 COLLATE=utf8_bin
CREATE TABLE prefix_page (id int(11) unsigned NOT NULL AUTO_INCREMENT, pagename varchar(110) NOT NULL, title varchar(100) NOT NULL, description varchar(300) NOT NULL, keywords varchar(300) NOT NULL, content text, publish char(1) NOT NULL, date bigint(20) DEFAULT NULL, updated bigint(20) DEFAULT NULL, PRIMARY KEY (id)) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin
CREATE TABLE prefix_post (id int(11) unsigned NOT NULL AUTO_INCREMENT, uid int(11) NOT NULL, fid int(5) NOT NULL, pid int(11) NOT NULL, title varchar(100) NOT NULL, description varchar(300) NOT NULL, keywords varchar(300) NOT NULL, content text, autolink tinyint(1) NOT NULL, locked char(1) NOT NULL, publish char(1) NOT NULL, view int(5) NOT NULL, date bigint(20) DEFAULT NULL, updated bigint(20) DEFAULT NULL, PRIMARY KEY (id)) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin
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, message text NOT NULL, new tinyint(1) NOT NULL, date bigint(20) NOT NULL, PRIMARY KEY (id)) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin
CREATE TABLE prefix_search (id int(11) unsigned NOT NULL AUTO_INCREMENT, pageid int(11) NOT NULL, pid int(11) NOT NULL, cid int(11) NOT NULL, uid int(11) NOT NULL, title varchar(100) NOT NULL, keywords varchar(300) NOT NULL, description varchar(300) NOT NULL, body text NOT NULL, publish char(1) NOT NULL, PRIMARY KEY (id), FULLTEXT KEY score (title,keywords,description,body)) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin
CREATE TABLE prefix_settings (id int(2) unsigned NOT NULL AUTO_INCREMENT, sitename varchar(100) NOT NULL, description varchar(300) NOT NULL, keywords varchar(300) NOT NULL, defaultpage int(5), blocksite tinyint(1) NOT NULL, quickreply tinyint(1) NOT NULL, approval char(1) NOT NULL, allowemail tinyint(1) NOT NULL, nofollow char(1) NOT NULL, defaultstyle varchar(55) NOT NULL, postsize int(6) NOT NULL, listcount int(3) NOT NULL, commentcount int(2) NOT NULL, verifyuser tinyint(1) NOT NULL, allowedit tinyint(1) NOT NULL, linkperpost tinyint(2) NOT NULL, linkpersign tinyint(2) NOT NULL, allowsign tinyint(1) NOT NULL, signbefore tinyint(2) NOT NULL, allowfile tinyint(1) NOT NULL, fileaccess char(1) NOT NULL, blockreg tinyint(1) NOT NULL, blockspam tinyint(1) NOT NULL, userstyle char(1) NOT NULL, PRIMARY KEY (id)) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin
CREATE TABLE prefix_tmpuser (id int(11) unsigned NOT NULL AUTO_INCREMENT, uid int(11) NOT NULL, email varchar(110) NOT NULL, verify varchar(16) NOT NULL, action tinyint(1) NOT NULL, date bigint(20) DEFAULT NULL, PRIMARY KEY (id)) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin
CREATE TABLE prefix_upload (id int(11) unsigned NOT NULL AUTO_INCREMENT, uid int(11) NOT NULL, pid int(11) NOT NULL, pname varchar(64) NOT NULL, type varchar(200) NOT NULL, name varchar(64) NOT NULL, compressed tinyint(1) NOT NULL, filesize int(8) NOT NULL, download int(5) NOT NULL, date bigint(20) DEFAULT NULL, PRIMARY KEY (id)) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin
CREATE TABLE prefix_user (id int(11) unsigned NOT NULL AUTO_INCREMENT, user varchar(20) NOT NULL, session varchar(16) NOT NULL, ip varchar(16) NOT NULL, password char(32) NOT NULL, name varchar(64) NOT NULL, email varchar(110) NOT NULL, signature varchar(300) DEFAULT NULL, autolink tinyint(1) NOT NULL, level CHAR(1) NOT NULL, allowemail char(1) NOT NULL, date bigint(20) DEFAULT NULL, edittime bigint(20) NOT NULL, PRIMARY KEY (id)) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin
CREATE TABLE prefix_profile (id int(11) unsigned NOT NULL AUTO_INCREMENT, uid int(11) unsigned NOT NULL, website varchar(200) NOT NULL, facebook varchar(64) NOT NULL, twitter varchar(32) NOT NULL, profile text NOT NULL, autolink tinyint(1) NOT NULL, image varchar(32) NOT NULL, imagetype varchar(200) NOT NULL, PRIMARY KEY (id)) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin
CREATE TABLE prefix_usersettings (id int(2) unsigned NOT NULL AUTO_INCREMENT, profilesize int(4) NOT NULL, linkperpost int(2) unsigned NOT NULL, nofollow char(1) NOT NULL, allowwebsite tinyint(1) NOT NULL, allowfacebook tinyint(1) NOT NULL, allowtwitter tinyint(1) NOT NULL, allowimage tinyint(1) NOT NULL, imagesize int(3) NOT NULL, PRIMARY KEY (id)) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin
CREATE TABLE prefix_feed (id int(2) unsigned NOT NULL AUTO_INCREMENT, title varchar(100) NOT NULL, description varchar(300) NOT NULL, image varchar(64) NOT NULL, alt char(100) NOT NULL, items int(2) NOT NULL, descriptionlength int(3) NOT NULL, noimage tinyint(1) NOT NULL, PRIMARY KEY (id)) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin
CREATE TABLE prefix_visitors (id int(11) unsigned NOT NULL AUTO_INCREMENT, uid int(11) NOT NULL, fid int(5) NOT NULL, ip VARCHAR(32) NOT NULL, lastintime bigint(20) DEFAULT NULL, PRIMARY KEY (id)) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin
INSERT INTO prefix_usersettings(profilesize, linkperpost, nofollow, allowwebsite, allowfacebook, allowtwitter, allowimage, imagesize) VALUES (500, 2, 'Y', 1, 1, 1, 1, 100)
INSERT INTO prefix_feed (title, description, image, alt, items, descriptionlength, noimage) VALUES ('Ramui forum script', 'Ramui Forum Script is a free PHP forum script for website', 'rss.gif', 'Ramui forum script', 10, 300, 0)
INSERT INTO prefix_settings (sitename, description, keywords, defaultpage, defaultstyle, postsize, listcount, commentcount, allowedit, allowemail, approval, nofollow, linkperpost, linkpersign, signbefore, allowsign, allowfile, fileaccess, blockreg, blockspam, quickreply, userstyle) VALUES ('Ramui forum script', 'ramui forum script is a free PHP forum script for website', 'free forum script for website,free php forum script,script for forum,simple forum script', 0, 'WhiteSmoke', 5000, 50, 10, 1, 1, 'A', 'Y', 6, 3, 0, 1, 1, 'I', 0, 0, 1, 'R')
INSERT INTO prefix_filesettings (size, height, width, fpp, extensions) VALUES (200, 400, 600, 3, 'gif,jpg,jpeg,zip,txt')
INSERT INTO prefix_mailsettings (messagesize, defaultfrom, replyto, response, autoresponder) VALUES (1250, 'noreply@__SELFURL__', '__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_user (id, user, password, name, email, level, date) VALUES (1, 'admin', '25d55ad283aa400af464c76d713c07ad', 'Demo User', 'contact@ramui.com', 'C', __DATE__)
INSERT INTO prefix_category (id, title, position) VALUES (1, 'Ramui Forum Script', 1)
INSERT INTO prefix_forum (id, cid, title, icon, description, sdescription, keywords, position) VALUES (1, 1, 'About this script', 'star.gif', 'Ramui forum script is a free easy to use PHP forum script', 'This is short description', 'php forum script, free forum script, ramui forum script', 4), (2, 1, 'Report bugs', 'help.gif', 'Any bugs found please report here', 'This is short description', '', 3), (3, 0, 'Message you like', 'ball.png', 'Text message you like please post here', 'This is short description', '', 2), (4, 0, 'Welcome to __SELFURL__', '', 'New user post your welcome message here', 'This is short description', '', 1)
INSERT INTO prefix_upload (id, uid, pid, pname, type, name, compressed, filesize, download, date) VALUES (1, 1, 5, 'dhlbwnqLtyp1FzC5TfckRvu9e38MPX7x', 'image/jpeg', 'sample.jpg', 0, 19987, 0, __DATE__)
INSERT INTO prefix_post (id, uid, fid, pid, title, description, keywords, content, autolink, locked, publish, view, date, updated) VALUES (1, 1, 1, 0, 'Quick start guide', 'Here is a quick start guide to handle Ramui forum script', '', 'Congratulations! You have successfully install Ramui forum script. Here is a quick start guide that how to manage this script to suite you best.\n\nThis script allows only registered user to submit a new post or put comment over a post. I have already created a registered user of name: [i]admin[/i] and password: [i]12345678[/i]. You can [url=gb/user/index.php]login[/url] with the following details:\n\n[b]User[/b]: [i]admin[/i]\n[b]Password[/b]: [i]12345678[/i]\n\n and change this password with your own. Or alternatively you can delete this user name from your [url=gb/admin/index.php][b]script control pane[/b][/url] and create a new user name of your choice.\n\nInside the script control panel the settings page is the most important. You can control the entire behavior of your forum from here. So please be careful before choosing data on this page.\nFor more information please visit: [url]http://ramui.com/forum-script/quick-start-guide.html[/url]', 0, '', 'Y', 0, __DATE__, __DATE__),(2, 1, 3, 0, 'I like this script', 'Ramui forum script is an easy to use forum script and most importantly it is free of cost', '', 'Ramui forum script is an easy to use forum script and most importantly it is free of cost. The default template is looking very professional. I really like this script.', 0, '', 'Y', 0, __DATE__, __DATE__),(3, 1, 4, 0, 'Hi guys. I am new to the forum', 'Hi Guys, I was super bored yesterday and was googling for sites like these and came to your site', '', 'Hi Guys,\nI was super bored yesterday and was googling for sites like these and came to your site. Bad luck my friends came to my place and i couldnt register immediately. So I bookmarkes the site and as you can see I have registered here and posting like a champ', 0, '', 'Y', 0, __DATE__, __DATE__),(4, 1, 0, 1, 'How to add icon', '', '', 'Ramui Forum Script version - 3 allow Script administrator to add icon to Category and Forum. To add a new icon,\n[ol][li]Login to the script control panel.[/li]\n[li]From the front panel click the link Forum. Here you see all the list of all categories and forums under their respective category.[/li]\n[li]Click the item you want to edit.[/li]\n[li]Here you can add your preferred icon or upload a icon file from your computer.[/li]\n[li]Recommended size of icon image is 14x14 or 16x16, and required format is png or gif.[/li]\n[li]Please do not forget to save your change after editing.[/li]\n[/ol]', 0, '', 'Y', 0, __DATE__, __DATE__),(5, 1, 0, 1, 'How to add file', '', '', 'Ramui forum script version - 3 allows you to add image or other files with post or comment. The limiting values, i.e.\n[ol][li]Accepted file types,[/li]\n[li]Number of files per post,[/li]\n[li]Max. file size,[/li]\n[li]Image height and width[/li]\n[/ol]\ncan be set from script control panel. Here is an example image I add below.\n[file]sample.jpg[/file]', 0, '', 'Y', 0, __DATE__, __DATE__)
INSERT INTO prefix_page (pagename, title, description, keywords, content, publish, date, updated) VALUES ('about', 'About __SELFURL__', '', '', '<h1>About __SELFURL__</h1>\r\n<p>This is an example about page of your website. Here you can write about your organization, the topic of this website; what types of information viewers can expect from this site. If you are an individual you can write few lines of text about yourself. Please login to your control panel to edit this page.</p>', 'Y', __DATE__, __DATE__), ('terms-of-use', 'Terms of use', 'Terms of use of our website. If you continue to browse and use this website you are agreeing to comply with and be bound by the following terms and conditions of use.', 'Turms,following terms,our website,notice', '<h1>Terms of Use</h1>\r\n<p>Welcome to our website. If you continue to browse and use this website you are agreeing to comply with and be bound by the following terms and conditions of use.</p>\r\n<p>The term \"us\", \"we\" or \"our\" refer to the owner of the website. The term \"you\" refers to the user or viewer of our website.<br>\r\nWe reserve the right to amend the terms and conditions of use and the content of the website without prior notification.<br>\r\nThe use of this website is subject to the following terms of use:</p>\r\n<ul>\r\n<li>The content of the pages of this website is for your general information and use only. It is subject to change without notice.</li>\r\n<li>Neither we nor any third parties provide any warranty or guarantee as to the ccuracy, timeliness, performance, completeness or suitability of the information and materials found or offered on this website for any particular purpose. You acknowledge that such  information and materials may contain inaccuracies or errors and we expressly exclude liability for any such inaccuracies or errors to the fullest extent permitted by law.</li>\r\n<li>Your use of any information or materials on this website is entirely at your own risk, for which we shall not be liable. It shall be your own responsibility to ensure that any products, services or information available through this website meet your specific\r\nrequirements.</li>\r\n<li>This website contains material which is owned by or licensed to us. This material includes, but is not limited to, the design, layout, look, appearance and graphics. Reproduction is prohibited other than in accordance with the copyright notice, which forms part of these terms and conditions.</li>\r\n<li>All trademarks reproduced in this website, which are not the property of, or licensed to us, are acknowledged on the website. </li>\r\n<li>Unauthorized use of this website may give to a claim for damages and/or be a criminal offence.</li>\r\n<li>From time to time this website may also include links to other websites. These links are provided for your convenience to provide further information. We do not endorse other third parties website(s). We have no responsibility for the content of the linked third\r\nparties\' website(s).</li>\r\n<li>You may not create a link to this website from another website or document without our prior written consent.</li>\r\n<li>Your use of this website and any dispute arising out of such use of the website is subject to the laws of India.</li>\r\n</ul>', 'Y', __DATE__, __DATE__)
INSERT INTO prefix_search (id, pageid, pid, cid, uid, title, keywords, description, body, publish) VALUES (1, 1, 0, 0, 0, 'About localhost', '', '', 'About localhost\nThis is an example about page of your website. Here you can write about your organization, the topic of this website; what types of information viewers can expect from this site. If you are an individual you can write few lines of text about yourself. Please login to your control panel to edit this page.', 'Y'),(2, 2, 0, 0, 0, 'Terms of use', 'Turms,following terms,our website,notice', 'Terms of use of our website. If you continue to browse and use this website you are agreeing to comply with and be bound by the following terms and conditions of use.', 'Terms of Use\nWelcome to our website. If you continue to browse and use this website you are agreeing to comply with and be bound by the following terms and conditions of use.\nThe term "us", "we" or "our" refer to the owner of the website. The term "you" refers to the user or viewer of our website.\nWe reserve the right to amend the terms and conditions of use and the content of the website without prior notification.\nThe use of this website is subject to the following terms of use:\n\nThe content of the pages of this website is for your general information and use only. It is subject to change without notice.\nNeither we nor any third parties provide any warranty or guarantee as to the ccuracy, timeliness, performance, completeness or suitability of the information and materials found or offered on this website for any particular purpose. You acknowledge that such  information and materials may contain inaccuracies or errors and we expressly exclude liability for any such inaccuracies or errors to the fullest extent permitted by law.\nYour use of any information or materials on this website is entirely at your own risk, for which we shall not be liable. It shall be your own responsibility to ensure that any products, services or information available through this website meet your specific\nrequirements.\nThis website contains material which is owned by or licensed to us. This material includes, but is not limited to, the design, layout, look, appearance and graphics. Reproduction is prohibited other than in accordance with the copyright notice, which forms part of these terms and conditions.\nAll trademarks reproduced in this website, which are not the property of, or licensed to us, are acknowledged on the website. \nUnauthorized use of this website may give to a claim for damages and/or be a criminal offence.\nFrom time to time this website may also include links to other websites. These links are provided for your convenience to provide further information. We do not endorse other third parties website(s). We have no responsibility for the content of the linked third\nparties'' website(s).\nYou may not create a link to this website from another website or document without our prior written consent.\nYour use of this website and any dispute arising out of such use of the website is subject to the laws of India.\n', 'Y'),(3, 0, 1, 0, 1, 'Quick start guide', '', 'Here is a quick start guide to handle Ramui forum script', 'Congratulations! You have successfully install Ramui forum script. Here is a quick start guide that how to manage this script to suite you best.\r\n\r\nThis script allows only registered user to submit a new post or put comment over a post. I have already created a registered user of name: admin and password: 12345678. You can login with the following details:\r\n\r\nUser: admin\r\nPassword: 12345678\r\n\r\n and change this password with your own. Or alternatively you can delete this user name from your script control pane and create a new user name of your choice.\r\n\r\nInside the script control panel the settings page is the most important. You can control the entire behavior of your forum from here. So please be careful before choosing data on this page.\r\nFor more information please visit: http://ramui.com/forum-script/quick-start-guide.html', 'Y'),(4, 0, 2, 0, 1, 'I like this script', '', 'Ramui forum script is an easy to use forum script and most importantly it is free of cost', 'Ramui forum script is an easy to use forum script and most importantly it is free of cost. The default template is looking very professional. I really like this script.', 'Y'),(5, 0, 3, 0, 1, 'Hi guys. I am new to the forum', '', 'Hi Guys, I was super bored yesterday and was googling for sites like these and came to your site', 'Hi Guys,\r\nI was super bored yesterday and was googling for sites like these and came to your site. Bad luck my friends came to my place and i couldnt register immediately. So I bookmarkes the site and as you can see I have registered here and posting like a champ', 'Y'),(6, 0, 0, 4, 1, 'How to add icon', '', '', 'Ramui Forum Script version - 3 allow Script administrator to add icon to Category and Forum. To add a new icon,\r\nLogin to the script control panel.\r\nFrom the front panel click the link Forum. Here you see all the list of all categories and forums under their respective category.\r\nClick the item you want to edit.\r\nHere you can add your preferred icon or upload a icon file from your computer.\r\nRecommended size of icon image is 14x14 or 16x16, and required format is png or gif.\r\nPlease do not forget to save your change after editing.\r\n', 'Y'),(7, 0, 0, 5, 1, 'How to add file', '', '', 'Ramui forum script version - 3 allows you to add image or other files with post or comment. The limiting values, i.e.\r\nAccepted file types,\r\nNumber of files per post,\r\nMax. file size,\r\nImage height and width\r\n\r\ncan be set from script control panel. Here is an example image I add below.\r\nsample.jpg', 'Y');