CREATE TABLE `action_track` (
  `id` int(11) NOT NULL auto_increment,
  `user_id` int(11) unsigned NOT NULL default '0',
  `asset_name` varchar(255) NOT NULL default '',
  `action` varchar(255) NOT NULL default '',
  `asset_id` int(11) unsigned NOT NULL default '0',
  `timestamp` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Table structure for table `body_image`
--

CREATE TABLE `body_image` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `cms_headline` varchar(255) NOT NULL default '',
  `small_image` varchar(255) NOT NULL default '',
  `large_image` varchar(255) NOT NULL default '',
  `alt` varchar(255) NOT NULL default 'default',
  `align` varchar(255) NOT NULL default 'default',
  `link` varchar(255) NOT NULL default '',
  `popout` tinyint(1) NOT NULL default '0',
  `description` text NOT NULL,
  `cms_active` tinyint(1) NOT NULL default '1',
  `cms_deleted` tinyint(1) NOT NULL default '0',
  `cms_draft` tinyint(1) NOT NULL default '0',
  `cms_created` datetime NOT NULL default '0000-00-00 00:00:00',
  `cms_modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `cms_modified_by_user` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `cms_active` (`cms_active`),
  KEY `cms_deleted` (`cms_deleted`)
) ENGINE=InnoDB;

-- --------------------------------------------------------

--
-- Table structure for table `cms_asset_info`
--

CREATE TABLE `cms_asset_info` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `asset` varchar(255) NOT NULL default '',
  `asset_name` varchar(255) NOT NULL default '',
  `cms_created` datetime NOT NULL default '0000-00-00 00:00:00',
  `cms_modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `cms_modified_by_user` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `object` (`asset`)
) ENGINE=InnoDB;

-- --------------------------------------------------------
INSERT INTO `cms_asset_info` VALUES
(1, 'text', 'Text', NOW(), NOW(), 1),
(2, 'media_element', 'Media Element', NOW(), NOW(), 1),
(3, 'code_caller', 'Code Caller', NOW(), NOW(), 1),
(4, 'body_image', 'Body Image', NOW(), NOW(), 1),
(5, 'redirect', 'Redirect', NOW(), NOW(), 1);


--
-- Table structure for table `cms_asset_template`
--

CREATE TABLE `cms_asset_template` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `asset` varchar(255) NOT NULL default '',
  `template_filename` varchar(255) NOT NULL default '',
  `page_template_container_id` int(11) NOT NULL default '0',
  `cms_created` datetime NOT NULL default '0000-00-00 00:00:00',
  `cms_modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `cms_modified_by_user` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB;

-- --------------------------------------------------------
INSERT INTO `cms_asset_template` VALUES
(1, 'text', 'default', 1, NOW(), NOW(), 1),
(2, 'media_element', 'default', 1, NOW(), NOW(), 1),
(3, 'code_caller', 'default', 1, NOW(), NOW(), 1),
(4, 'body_image', 'default', 1, NOW(), NOW(), 1),
(5, 'text', 'default', 3, NOW(), NOW(), 1),
(6, 'media_element', 'default', 3, NOW(), NOW(), 1),
(7, 'code_caller', 'default', 3, NOW(), NOW(), 1),
(8, 'body_image', 'default', 3, NOW(), NOW(), 1);


--
-- Table structure for table `cms_audit_trail`
--

CREATE TABLE `cms_audit_trail` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `user_id` int(11) unsigned NOT NULL default '0',
  `asset` varchar(255) NOT NULL default '',
  `asset_id` int(11) unsigned NOT NULL default '0',
  `workflow_id` int(11) unsigned NOT NULL default '0',
  `workflow_group_id` int(11) unsigned NOT NULL default '0',
  `page_id` int(10) unsigned NOT NULL default '0',
  `page_content_id` int(11) unsigned NOT NULL default '0',
  `action_taken` int(10) unsigned NOT NULL default '0',
  `ip` varchar(255) NOT NULL default '',
  `cms_created` datetime NOT NULL default '0000-00-00 00:00:00',
  `cms_modified_by_user` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB;

-- --------------------------------------------------------

--
-- Table structure for table `cms_drafts`
--

CREATE TABLE `cms_drafts` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `asset` varchar(255) NOT NULL default '',
  `asset_id` int(11) unsigned NOT NULL default '0',
  `version_id` int(11) NOT NULL default '0',
  `draft` longtext NOT NULL,
  `cms_created` datetime NOT NULL default '0000-00-00 00:00:00',
  `cms_modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `cms_modified_by_user` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `object` (`asset`),
  KEY `object_id` (`asset_id`)
) ENGINE=InnoDB;

-- --------------------------------------------------------

--
-- Table structure for table `cms_nterchange_versions`
--

CREATE TABLE `cms_nterchange_versions` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `asset` varchar(255) NOT NULL default '',
  `asset_id` int(11) unsigned NOT NULL default '0',
  `version` longtext NOT NULL,
  `cms_deleted` tinyint(1) NOT NULL default '0',
  `cms_created` datetime NOT NULL default '0000-00-00 00:00:00',
  `cms_modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `cms_modified_by_user` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `object` (`asset`),
  KEY `object_id` (`asset_id`)
) ENGINE=InnoDB;

-- --------------------------------------------------------

--
-- Table structure for table `cms_settings`
--

CREATE TABLE `cms_settings` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `user_id` int(11) NOT NULL default '0',
  `setting` int(10) NOT NULL default '0',
  `value` tinyint(1) NOT NULL default '0',
  `cms_created` datetime NOT NULL default '0000-00-00 00:00:00',
  `cms_modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `cms_modified_by_user` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB;

-- --------------------------------------------------------

--
-- Table structure for table `code_caller`
--

CREATE TABLE `code_caller` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `cms_headline` varchar(255) NOT NULL default '',
  `content` text,
  `dynamic` tinyint(1) NOT NULL default '0',
  `cms_active` tinyint(1) NOT NULL default '1',
  `cms_deleted` tinyint(1) NOT NULL default '0',
  `cms_draft` tinyint(1) NOT NULL default '0',
  `cms_created` datetime NOT NULL default '0000-00-00 00:00:00',
  `cms_modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `cms_modified_by_user` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB;

-- --------------------------------------------------------
INSERT INTO `code_caller` VALUES
(1, 'Sitemap', '{call controller=page action=sitemap}', 1, 1, 0, 0, NOW(), NOW(), 0),
(2, 'Search', '{call controller=search action=search}', 1, 1, 0, 0, NOW(), NOW(), 0);

--
-- Table structure for table `html_header`
--

CREATE TABLE `html_header` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `cms_headline` varchar(255) NOT NULL default '',
  `content` text,
  `cms_active` tinyint(1) NOT NULL default '1',
  `cms_deleted` tinyint(1) NOT NULL default '0',
  `cms_created` datetime NOT NULL default '0000-00-00 00:00:00',
  `cms_modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `cms_modified_by_user` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB;

-- --------------------------------------------------------

--
-- Table structure for table `media_element`
--

CREATE TABLE `media_element` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `cms_headline` varchar(255) NOT NULL default '',
  `media_file` varchar(255) NOT NULL default '',
  `link_title` varchar(255) NOT NULL default '',
  `cms_active` tinyint(1) NOT NULL default '1',
  `cms_deleted` tinyint(1) NOT NULL default '0',
  `cms_draft` tinyint(1) NOT NULL default '0',
  `cms_created` datetime NOT NULL default '0000-00-00 00:00:00',
  `cms_modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `cms_modified_by_user` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `cms_active` (`cms_active`),
  KEY `cms_deleted` (`cms_deleted`)
) ENGINE=InnoDB;

-- --------------------------------------------------------


--
-- Table structure for table `page`
--

CREATE TABLE `page` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `parent_id` int(11) unsigned,
  `path` varchar(255) NOT NULL default '',
  `title` varchar(255) NOT NULL default '',
  `filename` varchar(64) NOT NULL default '',
  `page_template_id` int(11) unsigned NOT NULL default '0',
  `visible` tinyint(1) NOT NULL default '1',
  `active` tinyint(1) NOT NULL default '1',
  `printable` tinyint(1) NOT NULL default '1',
  `cache_lifetime` int(11) NOT NULL default '0',
  `client_cache_lifetime` int(11) NOT NULL default '3600',
  `secure_page` tinyint(1) NOT NULL default '0',
  `permissions_id` int(11) unsigned NOT NULL default '0',
  `sort_order` int(3) NOT NULL default '0',
  `external_url` varchar(255) NOT NULL default '',
  `external_url_popout` tinyint(1) NOT NULL default '0',
  `workflow_group_id` int(11) unsigned NOT NULL default '0',
  `workflow_recursive` tinyint(1) NOT NULL default '1',
  `disclaimer_required` tinyint(1) NOT NULL default '0',
  `disclaimer_recursive` tinyint(1) NOT NULL default '0',
  `meta_keywords` varchar(255) NOT NULL default '',
  `meta_description` varchar(255) NOT NULL default '',
  `cms_deleted` tinyint(1) NOT NULL default '0',
  `cms_created` datetime NOT NULL default '0000-00-00 00:00:00',
  `cms_modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `cms_modified_by_user` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB;

-- --------------------------------------------------------
INSERT INTO `page` VALUES
	(1, NULL, '',         'Home',      'home',      2, 1, 1, 1, -1, 3600, 0, 0, 0,  '', '', 0, 0, 0, 0, '', '', 0, NOW(), NOW(), 0),
	(2,    1, '/sitemap', 'Sitemap',   'sitemap',   1, 1, 1, 1, -1, 3600, 0, 0, 97, '', '', 0, 0, 0, 0, '', '', 0, NOW(), NOW(), 0),
	(3,    1, '/search',  'Search',    'search',    1, 1, 1, 1, -1, 3600, 0, 0, 98, '', '', 0, 0, 0, 0, '', '', 0, NOW(), NOW(), 0),
	(4,    1, '/404',     '404 Error', '404_error', 1, 0, 1, 1, -1, 3600, 0, 0, 99, '', '', 0, 0, 0, 0, '', '', 0, NOW(), NOW(), 0);

--
-- Table structure for table `page_content`
--

CREATE TABLE `page_content` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `page_id` int(11) unsigned NOT NULL default '0',
  `page_template_container_id` int(11) unsigned NOT NULL default '0',
  `content_asset` varchar(255) NOT NULL default '',
  `content_asset_id` int(11) unsigned NOT NULL default '0',
  `content_order` tinyint(3) NOT NULL default '0',
  `timed_start` datetime default NULL,
  `timed_end` datetime default NULL,
  `cms_workflow` int(1) NOT NULL default '0',
  `cms_created` datetime NOT NULL default '0000-00-00 00:00:00',
  `cms_modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `cms_modified_by_user` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB;

-- --------------------------------------------------------
INSERT INTO `page_content` VALUES
(1, 2, 1, 'code_caller', 1, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, NOW(), NOW(), 0),
(2, 3, 1, 'code_caller', 2, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, NOW(), NOW(), 0);

--
-- Table structure for table `page_mirror`
--

CREATE TABLE `page_mirror` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `cms_headline` varchar(255) NOT NULL default '',
  `page_id` int(11) unsigned NOT NULL,
  `cms_active` tinyint(1) NOT NULL default '1',
  `cms_deleted` tinyint(1) NOT NULL default '0',
  `cms_draft` tinyint(1) NOT NULL default '0',
  `cms_created` datetime NOT NULL default '0000-00-00 00:00:00',
  `cms_modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `cms_modified_by_user` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `cms_active` (`cms_active`),
  KEY `cms_deleted` (`cms_deleted`)
) ENGINE=InnoDB;

--
-- Table structure for table `page_template`
--

CREATE TABLE `page_template` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `template_name` varchar(255) NOT NULL default '',
  `template_filename` varchar(255) NOT NULL default '',
  `cms_created` datetime NOT NULL default '0000-00-00 00:00:00',
  `cms_modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `cms_modified_by_user` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB;

-- --------------------------------------------------------
INSERT INTO `page_template` VALUES
	(1, 'Main', 'default', NOW(), NOW(), 0),
	(2, 'Home', 'home', NOW(), NOW(), 0);

--
-- Table structure for table `page_template_containers`
--

CREATE TABLE `page_template_containers` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `page_template_id` int(11) NOT NULL default '0',
  `container_name` varchar(255) NOT NULL default '',
  `container_var` varchar(255) NOT NULL default '',
  `cms_created` datetime NOT NULL default '0000-00-00 00:00:00',
  `cms_modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `cms_modified_by_user` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB;

-- --------------------------------------------------------
INSERT INTO `page_template_containers` VALUES
	(1, 1, 'Main Content', 'MAIN_CONTENT', NOW(), NOW(), 0),
	(2, 1, 'Sidebar', 'SIDEBAR', NOW(), NOW(), 0),
	(3, 2, 'Main Content', 'MAIN_CONTENT', NOW(), NOW(), 0),
	(4, 2, 'Sidebar', 'SIDEBAR', NOW(), NOW(), 0);

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `cms_headline` varchar(255) NOT NULL default '',
  `type` varchar(255) NOT NULL default '',
  `group_id` int(11) unsigned NOT NULL default '0',
  `cms_active` tinyint(1) NOT NULL default '1',
  `cms_deleted` tinyint(1) NOT NULL default '0',
  `cms_created` datetime NOT NULL default '0000-00-00 00:00:00',
  `cms_modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `cms_modified_by_user` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB;

-- --------------------------------------------------------

--
-- Table structure for table `permissions_group`
--

CREATE TABLE `permissions_group` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `cms_headline` varchar(255) NOT NULL default '',
  `group_name` varchar(255) NOT NULL default '',
  `cms_active` tinyint(1) NOT NULL default '1',
  `cms_deleted` tinyint(1) NOT NULL default '0',
  `cms_created` datetime NOT NULL default '0000-00-00 00:00:00',
  `cms_modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `cms_modified_by_user` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB;

-- --------------------------------------------------------

--
-- Table structure for table `permissions_user_group`
--

CREATE TABLE `permissions_user_group` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `cms_headline` varchar(255) NOT NULL default '',
  `group_id` int(11) unsigned NOT NULL default '0',
  `user_id` int(11) unsigned NOT NULL default '0',
  `cms_active` tinyint(1) NOT NULL default '1',
  `cms_deleted` tinyint(1) NOT NULL default '0',
  `cms_created` datetime NOT NULL default '0000-00-00 00:00:00',
  `cms_modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `cms_modified_by_user` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB;

-- --------------------------------------------------------

--
-- Table structure for table `redirect`
--

CREATE TABLE `redirect` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `cms_headline` varchar(255) NOT NULL default '',
  `url` varchar(255) NOT NULL default '',
  `redirect` varchar(255) NOT NULL default '',
  `regex` tinyint(1) NOT NULL default '0',
  `count` int(11) unsigned NOT NULL default '0',
  `cms_active` tinyint(1) NOT NULL default '1',
  `cms_deleted` tinyint(1) NOT NULL default '0',
  `cms_created` datetime NOT NULL default '0000-00-00 00:00:00',
  `cms_modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `cms_modified_by_user` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB;

-- --------------------------------------------------------

--
-- Table structure for table `smarty_cache`
--

CREATE TABLE `smarty_cache` (
  `cache_id` char(32) NOT NULL,
  `cache_contents` mediumtext NOT NULL,
  PRIMARY KEY  (`cache_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `text`
--

CREATE TABLE `text` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `cms_headline` varchar(255) NOT NULL default '',
  `content` text,
  `cms_active` tinyint(1) NOT NULL default '1',
  `cms_deleted` tinyint(1) NOT NULL default '0',
  `cms_draft` tinyint(1) NOT NULL default '0',
  `cms_created` datetime NOT NULL default '0000-00-00 00:00:00',
  `cms_modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `cms_modified_by_user` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB;

-- --------------------------------------------------------

--
-- Table structure for table `whats_new`
--

CREATE TABLE `whats_new` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `cms_headline` varchar(255) NOT NULL default '',
  `date_submitted` date default NULL,
  `summary` varchar(255) NOT NULL default '',
  `content` varchar(255) NOT NULL default '',
  `link` varchar(255) NOT NULL default '',
  `cms_active` tinyint(1) NOT NULL default '1',
  `cms_deleted` tinyint(1) NOT NULL default '0',
  `cms_draft` tinyint(1) NOT NULL default '0',
  `cms_created` datetime NOT NULL default '0000-00-00 00:00:00',
  `cms_modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `cms_modified_by_user` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB;

-- --------------------------------------------------------

--
-- Table structure for table `workflow`
--

CREATE TABLE `workflow` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `page_id` int(11) unsigned NOT NULL default '0',
  `page_content_id` int(11) unsigned NOT NULL default '0',
  `workflow_group_id` int(11) unsigned NOT NULL default '0',
  `asset` varchar(255) NOT NULL default '',
  `asset_id` int(11) unsigned NOT NULL default '0',
  `action` int(3) NOT NULL default '0',
  `draft` longtext NOT NULL,
  `submitted` tinyint(1) NOT NULL default '0',
  `approved` tinyint(1) NOT NULL default '0',
  `comments` text NOT NULL,
  `timed_start` datetime default NULL,
  `timed_end` datetime default NULL,
  `parent_workflow` int(11) unsigned NOT NULL default '0',
  `completed` tinyint(1) NOT NULL default '0',
  `cms_created` datetime NOT NULL default '0000-00-00 00:00:00',
  `cms_modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `cms_modified_by_user` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `object` (`asset`),
  KEY `object_id` (`asset_id`)
) ENGINE=InnoDB;

-- --------------------------------------------------------

--
-- Table structure for table `workflow_group`
--

CREATE TABLE `workflow_group` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `workflow_title` varchar(255) NOT NULL default '',
  `cms_created` datetime NOT NULL default '0000-00-00 00:00:00',
  `cms_modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `cms_modified_by_user` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB;

-- --------------------------------------------------------

--
-- Table structure for table `workflow_users`
--

CREATE TABLE `workflow_users` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `workflow_group_id` int(11) unsigned NOT NULL default '0',
  `user_id` int(11) unsigned NOT NULL default '0',
  `role` int(3) NOT NULL default '0',
  `cms_created` datetime NOT NULL default '0000-00-00 00:00:00',
  `cms_modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `cms_modified_by_user` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB;

-- --------------------------------------------------------

--
-- Table structure for table `test_sample`
--

CREATE TABLE `test_sample` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `cms_headline` varchar(255) NOT NULL default '',
  `varchar` varchar(255) NOT NULL,
  `text` text,
  `blob` blob NOT NULL,
  `tinyint` tinyint(1) NOT NULL,
  `int` int(11) NOT NULL,
  `float` float NOT NULL,
  `datetime` datetime NOT NULL,
  `date` date NOT NULL,
  `time` time NOT NULL,
  `year` year(4) NOT NULL,
  `cms_active` tinyint(1) NOT NULL default '1',
  `cms_deleted` tinyint(1) NOT NULL default '0',
  `cms_draft` tinyint(1) NOT NULL default '0',
  `cms_created` datetime NOT NULL default '0000-00-00 00:00:00',
  `cms_modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `cms_modified_by_user` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB;
