CREATE TABLE `f7cph_modules` (
`mid` smallint(5) unsigned NOT NULL auto_increment,
`name` varchar(150) NOT NULL default '',
`version` smallint(5) unsigned NOT NULL default '100',
`last_update` int(10) unsigned NOT NULL default '0',
`weight` smallint(3) unsigned NOT NULL default '0',
`isactive` tinyint(1) unsigned NOT NULL default '0',
`dirname` varchar(25) NOT NULL default '',
`hasmain` tinyint(1) unsigned NOT NULL default '0',
`hasadmin` tinyint(1) unsigned NOT NULL default '0',
`hassearch` tinyint(1) unsigned NOT NULL default '0',
`hasconfig` tinyint(1) unsigned NOT NULL default '0',
`hascomments` tinyint(1) unsigned NOT NULL default '0',
`hasnotification` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`mid`),
KEY `hasmain` (`hasmain`),
KEY `hasadmin` (`hasadmin`),
KEY `hassearch` (`hassearch`),
KEY `hasnotification` (`hasnotification`),
KEY `dirname` (`dirname`),
KEY `name` (`name`(15))
) ENGINE=MyISAM AUTO_INCREMENT=13 ;