CREATE TABLE `php121_blocks` (
`b_id` int(10) NOT NULL auto_increment,
`b_user` int(10) NOT NULL default '0',
`b_block` int(10) NOT NULL default '0',
PRIMARY KEY (`b_id`)
) TYPE=MyISAM ;
CREATE TABLE `php121_config` (
`config_name` varchar(255) NOT NULL default '',
`config_value` varchar(255) NOT NULL default '',
PRIMARY KEY (`config_name`)
) TYPE=MyISAM;
INSERT INTO `php121_config` VALUES ('server_timezone', '0');
INSERT INTO `php121_config` VALUES ('default_language', 'English');
INSERT INTO `php121_config` VALUES ('auto_email_transcript', '0');
INSERT INTO `php121_config` VALUES ('user_can_create_account', '1');
INSERT INTO `php121_config` VALUES ('user_can_delete_account', '1');
CREATE TABLE `php121_requests` (
`r_id` int(11) NOT NULL auto_increment,
`roomid` int(11) default NULL,
`r_to` int(11) NOT NULL default '0',
`r_from` int(11) NOT NULL default '0',
`r_time` int(11) NOT NULL default '0',
`r_result` tinyint(1) NOT NULL default '0',
`r_update_time` int(11) NOT NULL default '0',
`r_type` int(1) NOT NULL default '0',
PRIMARY KEY (`r_id`)
) TYPE=MyISAM ;
CREATE TABLE `php121_control` (
`id` int(1) NOT NULL default '1',
`CL_LastModified` int(11) NOT NULL default '0',
`CL_UpdateKey` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
INSERT INTO `php121_control` VALUES (1, 1, 1);
INSERT INTO `php121_control` VALUES (2, 1, 1);
CREATE TABLE `php121_messages` (
`msgid` int(11) NOT NULL auto_increment,
`roomid` int(11) NOT NULL default '0',
`username` varchar(25) NOT NULL default '',
`timestamp` int(11) NOT NULL default '0',
`servernotice` int(1) NOT NULL default '0',
`message` longtext NOT NULL,
PRIMARY KEY (`msgid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
CREATE TABLE `php121_rooms` (
`roomid` int(11) NOT NULL default '0',
`uname` varchar(25) NOT NULL default '',
`joined` int(11) NOT NULL default '0',
`lastping` int(11) NOT NULL default '0',
`timedout` int(1) NOT NULL default '0',
PRIMARY KEY (`roomid`,`uname`)
) TYPE=MyISAM;
CREATE TABLE `php121_smilies` (
`id` smallint(5) NOT NULL auto_increment,
`code` varchar(50) NOT NULL default '',
`filename` varchar(100) NOT NULL default '',
`description` varchar(75) NOT NULL default '',
`pack` varchar(50) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=44 ;
INSERT INTO `php121_smilies` VALUES (1, ':D', 'icon_biggrin.gif', 'Very Happy', 'phpbb');
INSERT INTO `php121_smilies` VALUES (2, ':)', 'icon_smile.gif', 'Smile', 'phpbb');
INSERT INTO `php121_smilies` VALUES (3, ':smile:', 'icon_smile.gif', 'Smile', 'phpbb');
INSERT INTO `php121_smilies` VALUES (4, ':(', 'icon_sad.gif', 'Sad', 'phpbb');
INSERT INTO `php121_smilies` VALUES (5, ':-(', 'icon_sad.gif', 'Sad', 'phpbb');
INSERT INTO `php121_smilies` VALUES (6, ':sad:', 'icon_sad.gif', 'Sad', 'phpbb');
INSERT INTO `php121_smilies` VALUES (7, ':o', 'icon_surprised.gif', 'Surprised', 'phpbb');
INSERT INTO `php121_smilies` VALUES (8, ':-o', 'icon_surprised.gif', 'Surprised', 'phpbb');
INSERT INTO `php121_smilies` VALUES (9, ':eek:', 'icon_surprised.gif', 'Surprised', 'phpbb');
INSERT INTO `php121_smilies` VALUES (10, '8O', 'icon_eek.gif', 'Shocked', 'phpbb');
INSERT INTO `php121_smilies` VALUES (11, '8-O', 'icon_eek.gif', 'Shocked', 'phpbb');
INSERT INTO `php121_smilies` VALUES (12, ':shock:', 'icon_eek.gif', 'Shocked', 'phpbb');
INSERT INTO `php121_smilies` VALUES (13, ':?', 'icon_confused.gif', 'Confused', 'phpbb');
INSERT INTO `php121_smilies` VALUES (14, ':-?', 'icon_confused.gif', 'Confused', 'phpbb');
INSERT INTO `php121_smilies` VALUES (15, ':???:', 'icon_confused.gif', 'Confused', 'phpbb');
INSERT INTO `php121_smilies` VALUES (16, '8)', 'icon_cool.gif', 'Cool', 'phpbb');
INSERT INTO `php121_smilies` VALUES (17, '8-)', 'icon_cool.gif', 'Cool', 'phpbb');
INSERT INTO `php121_smilies` VALUES (18, ':cool:', 'icon_cool.gif', 'Cool', 'phpbb');
INSERT INTO `php121_smilies` VALUES (19, ':lol:', 'icon_lol.gif', 'Laughing', 'phpbb');
INSERT INTO `php121_smilies` VALUES (20, ':x', 'icon_mad.gif', 'Mad', 'phpbb');
INSERT INTO `php121_smilies` VALUES (21, ':-x', 'icon_mad.gif', 'Mad', 'phpbb');
INSERT INTO `php121_smilies` VALUES (22, ':mad:', 'icon_mad.gif', 'Mad', 'phpbb');
INSERT INTO `php121_smilies` VALUES (23, ':P', 'icon_razz.gif', 'Razz', 'phpbb');
INSERT INTO `php121_smilies` VALUES (24, ':-P', 'icon_razz.gif', 'Razz', 'phpbb');
INSERT INTO `php121_smilies` VALUES (25, ':razz:', 'icon_razz.gif', 'Razz', 'phpbb');
INSERT INTO `php121_smilies` VALUES (26, ':oops:', 'icon_redface.gif', 'Embarassed', 'phpbb');
INSERT INTO `php121_smilies` VALUES (27, ':cry:', 'icon_cry.gif', 'Crying or Very sad', 'phpbb');
INSERT INTO `php121_smilies` VALUES (28, ':evil:', 'icon_evil.gif', 'Evil or Very Mad', 'phpbb');
INSERT INTO `php121_smilies` VALUES (29, ':twisted:', 'icon_twisted.gif', 'Twisted Evil', 'phpbb');
INSERT INTO `php121_smilies` VALUES (30, ':roll:', 'icon_rolleyes.gif', 'Rolling Eyes', 'phpbb');
INSERT INTO `php121_smilies` VALUES (31, ':wink:', 'icon_wink.gif', 'Wink', 'phpbb');
INSERT INTO `php121_smilies` VALUES (32, ';)', 'icon_wink.gif', 'Wink', 'phpbb');
INSERT INTO `php121_smilies` VALUES (33, ':!:', 'icon_exclaim.gif', 'Exclamation', 'phpbb');
INSERT INTO `php121_smilies` VALUES (34, ':?:', 'icon_question.gif', 'Question', 'phpbb');
INSERT INTO `php121_smilies` VALUES (35, ':idea:', 'icon_idea.gif', 'Idea', 'phpbb');
INSERT INTO `php121_smilies` VALUES (36, ':arrow:', 'icon_arrow.gif', 'Arrow', 'phpbb');
INSERT INTO `php121_smilies` VALUES (37, ':|', 'icon_neutral.gif', 'Neutral', 'phpbb');
INSERT INTO `php121_smilies` VALUES (38, ':-|', 'icon_neutral.gif', 'Neutral', 'phpbb');
INSERT INTO `php121_smilies` VALUES (39, ':neutral:', 'icon_neutral.gif', 'Neutral', 'phpbb');
INSERT INTO `php121_smilies` VALUES (40, ':mrgreen:', 'icon_mrgreen.gif', 'Mr. Green', 'phpbb');
INSERT INTO `php121_smilies` VALUES (41, ':^_^:', 'aiwebs_004.gif', 'Smile (Japanese)', 'phpbb');
INSERT INTO `php121_smilies` VALUES (42, ':wave:', 'wavey.gif', '', 'phpbb');
INSERT INTO `php121_smilies` VALUES (43, ':samurai:', 'samurai.gif', '', 'phpbb');
CREATE TABLE `imbuddylist` (
`id` int(20) NOT NULL auto_increment,
`userid` int(32) NOT NULL default '0',
`buddyid` int(32) NOT NULL default '0',
`buddygroup` int(32) NOT NULL default '0',
`buddycomment` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
CREATE TABLE `imbuddylist_config` (
`config_name` varchar(255) NOT NULL default '',
`defaulttheme` varchar(255) NOT NULL default '',
`group_allonline_opened` int(1) NOT NULL default '1',
`group_onlinebuddies_opened` int(1) NOT NULL default '1',
`group_offlinebuddies_opened` int(1) NOT NULL default '0',
`profile_enabled` int(1) NOT NULL default '1',
`buddylist_enabled` int(1) NOT NULL default '1',
`awaymsg_enabled` int(1) NOT NULL default '1',
`showonline_enabled` int(1) NOT NULL default '1',
`usersearch_enabled` int(1) NOT NULL default '1',
`profilecomments_enabled` int(1) NOT NULL default '1',
`profileavatars_enabled` int(1) NOT NULL default '1',
`buddycomments_enabled` int(1) NOT NULL default '1',
`offlinemessages_enabled` int(1) NOT NULL default '1',
`debugmode_enabled` int(1) NOT NULL default '0',
`adminscontrolusersettings` int(1) NOT NULL default '0',
`chatlogsaving_enabled` int(1) NOT NULL default '1',
`staffsupportsystem_enabled` int(1) NOT NULL default '1',
`usersautoacceptchatrequests` int(1) NOT NULL default '0',
PRIMARY KEY (`config_name`)
) TYPE=MyISAM;
INSERT INTO `imbuddylist_config` VALUES ('imbuddylist', '', 1, 1, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 1, 1, 0);
CREATE TABLE `imbuddylist_groups` (
`id` int(20) NOT NULL auto_increment,
`userid` int(32) NOT NULL default '0',
`group` varchar(21) NOT NULL default '',
`opened` int(1) NOT NULL default '1',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
CREATE TABLE `imbuddylist_profilecomments` (
`comment_id` int(20) NOT NULL auto_increment,
`profile_id` int(20) NOT NULL default '0',
`poster_id` int(20) NOT NULL default '0',
`timestamp` int(11) NOT NULL default '0',
PRIMARY KEY (`comment_id`),
KEY `profile_id` (`profile_id`),
KEY `poster_id` (`poster_id`),
KEY `timestamp` (`timestamp`)
) TYPE=MyISAM;
CREATE TABLE `imbuddylist_profilecomments_text` (
`comment_id` int(20) NOT NULL auto_increment,
`comment_text` text,
PRIMARY KEY (`comment_id`)
) TYPE=MyISAM;
CREATE TABLE `imbuddylist_staffbuddies` (
`id` int(20) NOT NULL auto_increment,
`userid` varchar(45) NOT NULL default '1',
`buddyid` varchar(45) NOT NULL default '',
`buddygroup` varchar(45) NOT NULL default '',
`displayname` varchar(40) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
CREATE TABLE `imbuddylist_staffgroups` (
`id` int(20) NOT NULL auto_increment,
`userid` varchar(45) NOT NULL default '1',
`group` varchar(45) NOT NULL default '',
`opened` int(1) NOT NULL default '1',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
CREATE TABLE `php121_offlinemessages` (
`offlineim_id` INT(20) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`receiver_id` INT(20) NOT NULL ,
`sender_id` INT(20) NOT NULL ,
`timestamp` INT(11) NOT NULL ,
`subject` varchar(50) NOT NULL default '',
`unread` int(1) NOT NULL default '1',
INDEX ( `receiver_id` )
) TYPE = MYISAM ;
CREATE TABLE `php121_offlinemessages_text` (
`offlineim_id` INT( 20 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`offlineim_text` TEXT NULL
) TYPE = MYISAM ;
CREATE TABLE `php121_chatlogs` (
`id` int(99) NOT NULL auto_increment,
`room_id` int(99) NOT NULL default '0',
`timestamp` int(11) NOT NULL default '0',
`usernames` text NOT NULL,
`textlog` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM ;