DROP TABLE IF EXISTS {prefix}bans
CREATE TABLE {prefix}bans (IP tinytext NOT NULL, time int(10) NOT NULL default '0', PRIMARY KEY (IP(30))) TYPE=MyISAM
DROP TABLE IF EXISTS {prefix}censor
CREATE TABLE {prefix}censor (ID mediumint(8) unsigned NOT NULL auto_increment, input tinytext NOT NULL, output tinytext NOT NULL, PRIMARY KEY (ID)) TYPE=MyISAM AUTO_INCREMENT=1
DROP TABLE IF EXISTS `{prefix}messages
CREATE TABLE {prefix}messages (ID mediumint(8) unsigned NOT NULL auto_increment, message text NOT NULL, IP tinytext NOT NULL, time int(10) NOT NULL default '0', PRIMARY KEY (ID)) TYPE=MyISAM AUTO_INCREMENT=1
DROP TABLE IF EXISTS {prefix}settings
CREATE TABLE {prefix}settings (variable tinytext NOT NULL, value text NOT NULL, PRIMARY KEY  (variable(30))) TYPE=MyISAM
INSERT INTO {prefix}settings (variable, value) VALUES ('inputSize', '40');
INSERT INTO {prefix}settings (variable, value) VALUES ('inputLength', '255');
INSERT INTO {prefix}settings (variable, value) VALUES ('inputWait', '1');
INSERT INTO {prefix}settings (variable, value) VALUES ('inputWaitLength', '24');
INSERT INTO {prefix}settings (variable, value) VALUES ('inputHTML', '0');
INSERT INTO {prefix}settings (variable, value) VALUES ('outputShow', '20');
INSERT INTO {prefix}settings (variable, value) VALUES ('outputList', '100');
INSERT INTO {prefix}settings (variable, value) VALUES ('outputSeparator', '***');
INSERT INTO {prefix}settings (variable, value) VALUES ('outputLink', '1');
INSERT INTO {prefix}settings (variable, value) VALUES ('outputShowLinkColor', '#FF0000');
INSERT INTO {prefix}settings (variable, value) VALUES ('outputListLinkColor', '#FF0000');
INSERT INTO {prefix}settings (variable, value) VALUES ('outputLinkTarget', '_blank');
INSERT INTO {prefix}settings (variable, value) VALUES ('outputSeeded', '0');
INSERT INTO {prefix}settings (variable, value) VALUES ('outputSeededMessage', 'PHP Studio - PHP scriptek, letöltések, tanácsok - http://phpstudio.hu');
INSERT INTO {prefix}settings (variable, value) VALUES ('inputCensor', '0');
INSERT INTO {prefix}settings (variable, value) VALUES ('outputCensor', '1');
INSERT INTO {prefix}settings (variable, value) VALUES ('adminPasswd', 'd033e22ae348aeb5660fc2140aec35850c4da997');