DROP TABLE IF EXISTS cdb_medals;
CREATE TABLE cdb_medals (
medalid smallint(6) unsigned NOT NULL auto_increment,
`name` varchar(50) NOT NULL default '',
available tinyint(1) NOT NULL default '0',
image varchar(30) NOT NULL default '',
`type` tinyint(1) NOT NULL default '0',
displayorder tinyint(3) NOT NULL default '0',
description varchar(255) NOT NULL,
expiration smallint(6) unsigned NOT NULL default '0',
permission mediumtext NOT NULL,
PRIMARY KEY (medalid),
KEY displayorder (displayorder)
) TYPE=MyISAM AUTO_INCREMENT=11 ;
........................ |