mirror of
https://github.com/e107inc/e107.git
synced 2025-07-26 01:11:28 +02:00
11 lines
372 B
PHP
11 lines
372 B
PHP
CREATE TABLE chatbox (
|
|
cb_id int(10) unsigned NOT NULL auto_increment,
|
|
cb_nick varchar(30) NOT NULL default '',
|
|
cb_message text NOT NULL,
|
|
cb_datestamp int(10) unsigned NOT NULL default '0',
|
|
cb_blocked tinyint(3) unsigned NOT NULL default '0',
|
|
cb_ip varchar(45) NOT NULL default '',
|
|
FULLTEXT (cb_nick),
|
|
FULLTEXT (cb_message),
|
|
PRIMARY KEY (cb_id)
|
|
) ENGINE=MyISAM; |