Currently this is the prefix_modules table
CREATE TABLE `xxx__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)),
KEY `isactive` (`isactive`),
KEY `weight` (`weight`),
KEY `hascomments` (`hascomments`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
I think we need to update it too the followng at least:
[code]
CREATE TABLE `xxx__modules` (
`mid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`typal` enum('api','apps','modules','themes') NOT NULL DEFAULT 'modules',
`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',
`hasfeed` tinyint(1) unsigned NOT NULL DEFAULT '0',
`hasrewrite` tinyint(1) unsigned NOT NULL DEFAULT '0',
`categories` int(22) unsigned NOT NULL DEFAULT '0',
`topics` int(22) unsigned NOT NULL DEFAULT '0',
`items` int(22) unsigned NOT NULL DEFAULT '0',
`deleted` int(22) unsigned NOT NULL DEFAULT '0',
`edits` int(22) unsigned NOT NULL DEFAULT '0',
`comments` int(22) 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)),
KEY `isactive` (`isactive`),
KEY `weight` (`weight`),
KEY `hascomments` (`hascomments`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
http://www.ohloh.net/accounts/226400
Follow, Like & Read:-
twitter.com/RegaltyFamily
github.com/Chronolabs-Cooperative
facebook.com/DrAntonyRoberts