1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
| Table Create Table
documents CREATE TABLE `documents` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`description` mediumtext,
`search` varchar(255) NOT NULL,
`link` varchar(255) default NULL,
`active` tinyint(1) default '1',
`category` tinyint(10) unsigned default NULL,
`timestamp` bigint(25) NOT NULL,
`hits` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `active` (`active`),
KEY `category` (`category`),
KEY `timestamp` (`timestamp`),
KEY `hits` (`hits`),
FULLTEXT KEY `search` (`search`)
) ENGINE=MyISAM AUTO_INCREMENT=869047 DEFAULT CHARSET=latin1 |
Partager