site_modules

CREATE TABLE IF NOT EXISTS `{PREFIX}site_modules` (
`id` integer NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL DEFAULT '',
`description` varchar(255) NOT NULL DEFAULT '0',
`editor_type` integer NOT NULL DEFAULT '0' COMMENT '0-plain text,1-rich text,2-code editor',
`disabled` tinyint NOT NULL DEFAULT '0',
`category` integer NOT NULL DEFAULT '0' COMMENT 'category id',
`wrap` tinyint NOT NULL DEFAULT '0',
`locked` tinyint NOT NULL default '0',
`icon` varchar(255) NOT NULL DEFAULT '' COMMENT 'url to module icon',
`enable_resource` tinyint NOT NULL DEFAULT '0' COMMENT 'enables the resource file feature',
`resourcefile` varchar(255) NOT NULL DEFAULT '' COMMENT 'a physical link to a resource file',
`createdon` integer NOT NULL DEFAULT '0',
`editedon` integer NOT NULL DEFAULT '0',
`guid` varchar(32) NOT NULL DEFAULT '' COMMENT 'globally unique identifier',
`enable_sharedparams` tinyint NOT NULL DEFAULT '0',
`properties` text,
`modulecode` mediumtext COMMENT 'module boot up code',
PRIMARY KEY(`id`)
) ENGINE=MyISAM COMMENT='Site Modules';