phpBB.de

Code: Alles auswählen

#-----[ SQL ]---------------------------------------------
#
# PLEASE NOTE:  Do not manually execute these SQL statements because they have been written
# in such a way so as to be in accord with EasyMod's SQL-syntax; if you do not have 
# EasyMod v0.1.13 then run the phpBBChatSpot_db_install.php file to create the necessary
# tables.
#
CREATE TABLE `chatspot_messages` (
	`message_id` int(11) unsigned NOT NULL auto_increment,
	`room_id` int(11) NOT NULL default '0',
	`username` varchar(25) NOT NULL default '',
	`msg` text NOT NULL,
	`msg_type` tinyint(1) unsigned NOT NULL default '0',
	`timestamp` int(11) unsigned NOT NULL default '0',
	`to_user_id` mediumint(8) unsigned NOT NULL default '0',
	`from_user_id` mediumint(8) unsigned NOT NULL default '0',
	PRIMARY KEY  (`message_id`)
) TYPE=MyISAM;

CREATE TABLE `chatspot_rooms` (
	`room_id` mediumint(11) NOT NULL auto_increment,
	`room_name` varchar(20) NOT NULL default '',
	`room_type` tinyint(1) unsigned NOT NULL default '0',
	`room_access` mediumint(8) unsigned NOT NULL default '0',
	`room_password` varchar(20) default NULL,
	`room_creator_id` mediumint(8) unsigned NOT NULL default '0',
	PRIMARY KEY  (`room_id`)
) TYPE=MyISAM;

INSERT INTO `chatspot_rooms` VALUES ('1', 'Lobby', '1', '0', NULL, '0');

CREATE TABLE `chatspot_sessions` (
  `user_id` mediumint(8) unsigned NOT NULL default '0',
  `username` varchar(25) NOT NULL default '',
  `room_id` mediumint(11) NOT NULL default '0',
  `last_active` int(11) NOT NULL default '0',
  `last_status` tinyint(1) unsigned NOT NULL default '1'
) TYPE=MyISAM;