DROP TABLE IF EXISTS cdb_pmsearchindex;
CREATE TABLE cdb_pmsearchindex (
searchid int(10) unsigned NOT NULL AUTO_INCREMENT,
keywords varchar(255) NOT NULL DEFAULT '',
searchstring varchar(255) NOT NULL DEFAULT '',
uid mediumint(8) unsigned NOT NULL DEFAULT '0',
dateline int(10) unsigned NOT NULL DEFAULT '0',
expiration int(10) unsigned NOT NULL DEFAULT '0',
pms smallint(6) unsigned NOT NULL DEFAULT '0',
pmids text NOT NULL,
PRIMARY KEY (searchid)
) TYPE=MyISAM AUTO_INCREMENT=1;
DROP TABLE IF EXISTS cdb_polloptions;
CREATE TABLE cdb_polloptions (
polloptionid int(10) unsigned NOT NULL AUTO_INCREMENT,
tid mediumint(8) unsigned NOT NULL DEFAULT '0',
votes mediumint(8) unsigned NOT NULL DEFAULT '0',
displayorder tinyint(3) NOT NULL DEFAULT '0',
polloption varchar(80) NOT NULL DEFAULT '',
voterids mediumtext NOT NULL,
PRIMARY KEY (polloptionid),
KEY tid (tid,displayorder)
) TYPE=MyISAM AUTO_INCREMENT=1; |