USE [% mambo %];

CREATE TABLE `[% table_prefix %]_containers` ( 
  `id` int(11) NOT NULL auto_increment, 
  `parentid` int(11) NOT NULL default '0', 
  `ordering` int(11) NOT NULL default '0', 
  `published` smallint(6) NOT NULL default '0', 
  `childcount` int(11) NOT NULL default '0', 
  `name` varchar(100) NOT NULL default '', 
  `title` varchar(100) NOT NULL default '', 
  `windowtitle` varchar(50) NOT NULL default '', 
  `keywords` varchar(255) NOT NULL default '', 
  `icon` varchar(25) NOT NULL default '', 
  `description` text NOT NULL, 
  PRIMARY KEY  (`id`) 
); 

CREATE TABLE `[% table_prefix %]_parameters` ( 
  `id` int(11) NOT NULL auto_increment, 
  `param_name` varchar(50) NOT NULL default '', 
  `param_file` varchar(50) NOT NULL default '', 
  `param_version` varchar(50) NOT NULL default '', 
  `params` text NOT NULL, 
  PRIMARY KEY  (`id`), 
  KEY `names` (`param_name`, `param_version`) 
) TYPE=MyISAM; 
