1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
| DROP TABLE IF EXISTS `phpbb_chatbox`;
CREATE TABLE `phpbb_chatbox` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(99) NOT NULL default '',
`msg` varchar(255) NOT NULL default '',
`timestamp` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1528 ;
DROP TABLE IF EXISTS `phpbb_chatbox_session`;
CREATE TABLE `phpbb_chatbox_session` (
`username` varchar(99) NOT NULL default '',
`user_id` mediumint(8) unsigned NOT NULL default '0',
`lastactive` int(10) NOT NULL default '0',
`laststatus` varchar(8) NOT NULL default '',
UNIQUE KEY `username` (`username`)
) TYPE=MyISAM; |
Partager