rendered paste body-- --------------------------------------------------------
--
-- Table structure for table `access`
--
CREATE TABLE `cs_access` (
`aid` int(11) NOT NULL auto_increment,
`mask` varchar(255) NOT NULL default '',
`type` varchar(255) NOT NULL default '',
`status` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`aid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `actions`
--
CREATE TABLE `cs_actions` (
`aid` varchar(255) NOT NULL default '0',
`type` varchar(32) NOT NULL default '',
`callback` varchar(255) NOT NULL default '',
`parameters` longtext NOT NULL,
`description` varchar(255) NOT NULL default '0',
PRIMARY KEY (`aid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `actions_aid`
--
CREATE TABLE `cs_actions_aid` (
`aid` int(10) unsigned NOT NULL auto_increment,
PRIMARY KEY (`aid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `authmap`
--
CREATE TABLE `cs_authmap` (
`aid` int(10) unsigned NOT NULL auto_increment,
`uid` int(11) NOT NULL default '0',
`authname` varchar(128) NOT NULL default '',
`module` varchar(128) NOT NULL default '',
PRIMARY KEY (`aid`),
UNIQUE KEY `authname` (`authname`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `batch`
--
CREATE TABLE `cs_batch` (
`bid` int(10) unsigned NOT NULL auto_increment,
`token` varchar(64) NOT NULL,
`timestamp` int(11) NOT NULL,
`batch` longtext,
PRIMARY KEY (`bid`),
KEY `token` (`token`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
-- --------------------------------------------------------
--
-- Table structure for table `blocks`
--
CREATE TABLE `cs_blocks` (
`bid` int(11) NOT NULL auto_increment,
`module` varchar(64) NOT NULL default '',
`delta` varchar(32) NOT NULL default '0',
`theme` varchar(64) NOT NULL default '',
`status` tinyint(4) NOT NULL default '0',
`weight` tinyint(4) NOT NULL default '0',
`region` varchar(64) NOT NULL default '',
`custom` tinyint(4) NOT NULL default '0',
`throttle` tinyint(4) NOT NULL default '0',
`visibility` tinyint(4) NOT NULL default '0',
`pages` text NOT NULL,
`title` varchar(64) NOT NULL default '',
`cache` tinyint(4) NOT NULL default '1',
PRIMARY KEY (`bid`),
UNIQUE KEY `tmd` (`theme`,`module`,`delta`),
KEY `list` (`theme`,`status`,`region`,`weight`,`module`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=73 ;
-- --------------------------------------------------------
--
-- Table structure for table `blocks_roles`
--
CREATE TABLE `cs_blocks_roles` (
`module` varchar(64) NOT NULL,
`delta` varchar(32) NOT NULL,
`rid` int(10) unsigned NOT NULL,
PRIMARY KEY (`module`,`delta`,`rid`),
KEY `rid` (`rid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `boxes`
--
CREATE TABLE `cs_boxes` (
`bid` int(10) unsigned NOT NULL auto_increment,
`body` longtext,
`info` varchar(128) NOT NULL default '',
`format` smallint(6) NOT NULL default '0',
PRIMARY KEY (`bid`),
UNIQUE KEY `info` (`info`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `cache`
--
CREATE TABLE `cs_cache` (
`cid` varchar(255) NOT NULL default '',
`data` longblob,
`expire` int(11) NOT NULL default '0',
`created` int(11) NOT NULL default '0',
`headers` text,
`serialized` smallint(6) NOT NULL default '0',
PRIMARY KEY (`cid`),
KEY `expire` (`expire`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `cache_block`
--
CREATE TABLE `cs_cache_block` (
`cid` varchar(255) NOT NULL default '',
`data` longblob,
`expire` int(11) NOT NULL default '0',
`created` int(11) NOT NULL default '0',
`headers` text,
`serialized` smallint(6) NOT NULL default '0',
PRIMARY KEY (`cid`),
KEY `expire` (`expire`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `cache_filter`
--
CREATE TABLE `cs_cache_filter` (
`cid` varchar(255) NOT NULL default '',
`data` longblob,
`expire` int(11) NOT NULL default '0',
`created` int(11) NOT NULL default '0',
`headers` text,
`serialized` smallint(6) NOT NULL default '0',
PRIMARY KEY (`cid`),
KEY `expire` (`expire`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `cache_form`
--
CREATE TABLE `cs_cache_form` (
`cid` varchar(255) NOT NULL default '',
`data` longblob,
`expire` int(11) NOT NULL default '0',
`created` int(11) NOT NULL default '0',
`headers` text,
`serialized` smallint(6) NOT NULL default '0',
PRIMARY KEY (`cid`),
KEY `expire` (`expire`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `cache_menu`
--
CREATE TABLE `cs_cache_menu` (
`cid` varchar(255) NOT NULL default '',
`data` longblob,
`expire` int(11) NOT NULL default '0',
`created` int(11) NOT NULL default '0',
`headers` text,
`serialized` smallint(6) NOT NULL default '0',
PRIMARY KEY (`cid`),
KEY `expire` (`expire`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `cache_page`
--
CREATE TABLE `cs_cache_page` (
`cid` varchar(255) NOT NULL default '',
`data` longblob,
`expire` int(11) NOT NULL default '0',
`created` int(11) NOT NULL default '0',
`headers` text,
`serialized` smallint(6) NOT NULL default '0',
PRIMARY KEY (`cid`),
KEY `expire` (`expire`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `cache_update`
--
CREATE TABLE `cs_cache_update` (
`cid` varchar(255) NOT NULL default '',
`data` longblob,
`expire` int(11) NOT NULL default '0',
`created` int(11) NOT NULL default '0',
`headers` text,
`serialized` smallint(6) NOT NULL default '0',
PRIMARY KEY (`cid`),
KEY `expire` (`expire`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `comments`
--
CREATE TABLE `cs_comments` (
`cid` int(11) NOT NULL auto_increment,
`pid` int(11) NOT NULL default '0',
`nid` int(11) NOT NULL default '0',
`uid` int(11) NOT NULL default '0',
`subject` varchar(64) NOT NULL default '',
`comment` longtext NOT NULL,
`hostname` varchar(128) NOT NULL default '',
`timestamp` int(11) NOT NULL default '0',
`status` tinyint(3) unsigned NOT NULL default '0',
`format` smallint(6) NOT NULL default '0',
`thread` varchar(255) NOT NULL,
`name` varchar(60) default NULL,
`mail` varchar(64) default NULL,
`homepage` varchar(255) default NULL,
PRIMARY KEY (`cid`),
KEY `pid` (`pid`),
KEY `nid` (`nid`),
KEY `status` (`status`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `files`
--
CREATE TABLE `cs_files` (
`fid` int(10) unsigned NOT NULL auto_increment,
`uid` int(10) unsigned NOT NULL default '0',
`filename` varchar(255) NOT NULL default '',
`filepath` varchar(255) NOT NULL default '',
`filemime` varchar(255) NOT NULL default '',
`filesize` int(10) unsigned NOT NULL default '0',
`status` int(11) NOT NULL default '0',
`timestamp` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`fid`),
KEY `uid` (`uid`),
KEY `status` (`status`),
KEY `timestamp` (`timestamp`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `filters`
--
CREATE TABLE `cs_filters` (
`fid` int(11) NOT NULL auto_increment,
`format` int(11) NOT NULL default '0',
`module` varchar(64) NOT NULL default '',
`delta` tinyint(4) NOT NULL default '0',
`weight` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`fid`),
UNIQUE KEY `fmd` (`format`,`module`,`delta`),
KEY `list` (`format`,`weight`,`module`,`delta`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
-- --------------------------------------------------------
--
-- Table structure for table `filter_formats`
--
CREATE TABLE `cs_filter_formats` (
`format` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`roles` varchar(255) NOT NULL default '',
`cache` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`format`),
UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
-- --------------------------------------------------------
--
-- Table structure for table `flood`
--
CREATE TABLE `cs_flood` (
`fid` int(11) NOT NULL auto_increment,
`event` varchar(64) NOT NULL default '',
`hostname` varchar(128) NOT NULL default '',
`timestamp` int(11) NOT NULL default '0',
PRIMARY KEY (`fid`),
KEY `allow` (`event`,`hostname`,`timestamp`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `history`
--
CREATE TABLE `cs_history` (
`uid` int(11) NOT NULL default '0',
`nid` int(11) NOT NULL default '0',
`timestamp` int(11) NOT NULL default '0',
PRIMARY KEY (`uid`,`nid`),
KEY `nid` (`nid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `menu_custom`
--
CREATE TABLE `cs_menu_custom` (
`menu_name` varchar(32) NOT NULL default '',
`title` varchar(255) NOT NULL default '',
`description` text,
PRIMARY KEY (`menu_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `menu_links`
--
CREATE TABLE `cs_menu_links` (
`menu_name` varchar(32) NOT NULL default '',
`mlid` int(10) unsigned NOT NULL auto_increment,
`plid` int(10) unsigned NOT NULL default '0',
`link_path` varchar(255) NOT NULL default '',
`router_path` varchar(255) NOT NULL default '',
`link_title` varchar(255) NOT NULL default '',
`options` text,
`module` varchar(255) NOT NULL default 'system',
`hidden` smallint(6) NOT NULL default '0',
`external` smallint(6) NOT NULL default '0',
`has_children` smallint(6) NOT NULL default '0',
`expanded` smallint(6) NOT NULL default '0',
`weight` int(11) NOT NULL default '0',
`depth` smallint(6) NOT NULL default '0',
`customized` smallint(6) NOT NULL default '0',
`p1` int(10) unsigned NOT NULL default '0',
`p2` int(10) unsigned NOT NULL default '0',
`p3` int(10) unsigned NOT NULL default '0',
`p4` int(10) unsigned NOT NULL default '0',
`p5` int(10) unsigned NOT NULL default '0',
`p6` int(10) unsigned NOT NULL default '0',
`p7` int(10) unsigned NOT NULL default '0',
`p8` int(10) unsigned NOT NULL default '0',
`p9` int(10) unsigned NOT NULL default '0',
`updated` smallint(6) NOT NULL default '0',
PRIMARY KEY (`mlid`),
KEY `path_menu` (`link_path`(128),`menu_name`),
KEY `menu_plid_expand_child` (`menu_name`,`plid`,`expanded`,`has_children`),
KEY `menu_parents` (`menu_name`,`p1`,`p2`,`p3`,`p4`,`p5`,`p6`,`p7`,`p8`,`p9`),
KEY `router_path` (`router_path`(128))
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=159 ;
-- --------------------------------------------------------
--
-- Table structure for table `menu_router`
--
CREATE TABLE `cs_menu_router` (
`path` varchar(255) NOT NULL default '',
`load_functions` varchar(255) NOT NULL default '',
`to_arg_functions` varchar(255) NOT NULL default '',
`access_callback` varchar(255) NOT NULL default '',
`access_arguments` text,
`page_callback` varchar(255) NOT NULL default '',
`page_arguments` text,
`fit` int(11) NOT NULL default '0',
`number_parts` smallint(6) NOT NULL default '0',
`tab_parent` varchar(255) NOT NULL default '',
`tab_root` varchar(255) NOT NULL default '',
`title` varchar(255) NOT NULL default '',
`title_callback` varchar(255) NOT NULL default '',
`title_arguments` varchar(255) NOT NULL default '',
`type` int(11) NOT NULL default '0',
`block_callback` varchar(255) NOT NULL default '',
`description` text NOT NULL,
`position` varchar(255) NOT NULL default '',
`weight` int(11) NOT NULL default '0',
`file` mediumtext,
PRIMARY KEY (`path`),
KEY `fit` (`fit`),
KEY `tab_parent` (`tab_parent`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `node`
--
CREATE TABLE `cs_node` (
`nid` int(10) unsigned NOT NULL auto_increment,
`vid` int(10) unsigned NOT NULL default '0',
`type` varchar(32) NOT NULL default '',
`language` varchar(12) NOT NULL default '',
`title` varchar(255) NOT NULL default '',
`uid` int(11) NOT NULL default '0',
`status` int(11) NOT NULL default '1',
`created` int(11) NOT NULL default '0',
`changed` int(11) NOT NULL default '0',
`comment` int(11) NOT NULL default '0',
`promote` int(11) NOT NULL default '0',
`moderate` int(11) NOT NULL default '0',
`sticky` int(11) NOT NULL default '0',
`tnid` int(10) unsigned NOT NULL default '0',
`translate` int(11) NOT NULL default '0',
PRIMARY KEY (`nid`),
UNIQUE KEY `vid` (`vid`),
KEY `node_changed` (`changed`),
KEY `node_created` (`created`),
KEY `node_moderate` (`moderate`),
KEY `node_promote_status` (`promote`,`status`),
KEY `node_status_type` (`status`,`type`,`nid`),
KEY `node_title_type` (`title`,`type`(4)),
KEY `node_type` (`type`(4)),
KEY `uid` (`uid`),
KEY `tnid` (`tnid`),
KEY `translate` (`translate`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
-- --------------------------------------------------------
--
-- Table structure for table `node_access`
--
CREATE TABLE `cs_node_access` (
`nid` int(10) unsigned NOT NULL default '0',
`gid` int(10) unsigned NOT NULL default '0',
`realm` varchar(255) NOT NULL default '',
`grant_view` tinyint(3) unsigned NOT NULL default '0',
`grant_update` tinyint(3) unsigned NOT NULL default '0',
`grant_delete` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`nid`,`gid`,`realm`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `node_comment_statistics`
--
CREATE TABLE `cs_node_comment_statistics` (
`nid` int(10) unsigned NOT NULL default '0',
`last_comment_timestamp` int(11) NOT NULL default '0',
`last_comment_name` varchar(60) default NULL,
`last_comment_uid` int(11) NOT NULL default '0',
`comment_count` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`nid`),
KEY `node_comment_timestamp` (`last_comment_timestamp`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `node_counter`
--
CREATE TABLE `cs_node_counter` (
`nid` int(11) NOT NULL default '0',
`totalcount` bigint(20) unsigned NOT NULL default '0',
`daycount` mediumint(8) unsigned NOT NULL default '0',
`timestamp` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`nid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `node_revisions`
--
CREATE TABLE `cs_node_revisions` (
`nid` int(10) unsigned NOT NULL default '0',
`vid` int(10) unsigned NOT NULL auto_increment,
`uid` int(11) NOT NULL default '0',
`title` varchar(255) NOT NULL default '',
`body` longtext NOT NULL,
`teaser` longtext NOT NULL,
`log` longtext NOT NULL,
`timestamp` int(11) NOT NULL default '0',
`format` int(11) NOT NULL default '0',
PRIMARY KEY (`vid`),
KEY `nid` (`nid`),
KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
-- --------------------------------------------------------
--
-- Table structure for table `node_type`
--
CREATE TABLE `cs_node_type` (
`type` varchar(32) NOT NULL,
`name` varchar(255) NOT NULL default '',
`module` varchar(255) NOT NULL,
`description` mediumtext NOT NULL,
`help` mediumtext NOT NULL,
`has_title` tinyint(3) unsigned NOT NULL,
`title_label` varchar(255) NOT NULL default '',
`has_body` tinyint(3) unsigned NOT NULL,
`body_label` varchar(255) NOT NULL default '',
`min_word_count` smallint(5) unsigned NOT NULL,
`custom` tinyint(4) NOT NULL default '0',
`modified` tinyint(4) NOT NULL default '0',
`locked` tinyint(4) NOT NULL default '0',
`orig_type` varchar(255) NOT NULL default '',
PRIMARY KEY (`type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `permission`
--
CREATE TABLE `cs_permission` (
`pid` int(11) NOT NULL auto_increment,
`rid` int(10) unsigned NOT NULL default '0',
`perm` longtext,
`tid` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`pid`),
KEY `rid` (`rid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
-- --------------------------------------------------------
--
-- Table structure for table `role`
--
CREATE TABLE `cs_role` (
`rid` int(10) unsigned NOT NULL auto_increment,
`name` varchar(64) NOT NULL default '',
PRIMARY KEY (`rid`),
UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
-- --------------------------------------------------------
--
-- Table structure for table `sessions`
--
CREATE TABLE `cs_sessions` (
`uid` int(10) unsigned NOT NULL,
`sid` varchar(64) NOT NULL default '',
`hostname` varchar(128) NOT NULL default '',
`timestamp` int(11) NOT NULL default '0',
`cache` int(11) NOT NULL default '0',
`session` longtext,
PRIMARY KEY (`sid`),
KEY `timestamp` (`timestamp`),
KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `system`
--
CREATE TABLE `cs_system` (
`filename` varchar(255) NOT NULL default '',
`name` varchar(255) NOT NULL default '',
`type` varchar(255) NOT NULL default '',
`owner` varchar(255) NOT NULL default '',
`status` int(11) NOT NULL default '0',
`throttle` tinyint(4) NOT NULL default '0',
`bootstrap` int(11) NOT NULL default '0',
`schema_version` smallint(6) NOT NULL default '-1',
`weight` int(11) NOT NULL default '0',
`info` text,
PRIMARY KEY (`filename`),
KEY `modules` (`type`(12),`status`,`weight`,`filename`),
KEY `bootstrap` (`type`(12),`status`,`bootstrap`,`weight`,`filename`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `term_data`
--
CREATE TABLE `cs_term_data` (
`tid` int(10) unsigned NOT NULL auto_increment,
`vid` int(10) unsigned NOT NULL default '0',
`name` varchar(255) NOT NULL default '',
`description` longtext,
`weight` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`tid`),
KEY `taxonomy_tree` (`vid`,`weight`,`name`),
KEY `vid_name` (`vid`,`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
-- --------------------------------------------------------
--
-- Table structure for table `term_hierarchy`
--
CREATE TABLE `cs_term_hierarchy` (
`tid` int(10) unsigned NOT NULL default '0',
`parent` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`tid`,`parent`),
KEY `parent` (`parent`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `term_node`
--
CREATE TABLE `cs_term_node` (
`nid` int(10) unsigned NOT NULL default '0',
`vid` int(10) unsigned NOT NULL default '0',
`tid` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`tid`,`vid`),
KEY `vid` (`vid`),
KEY `nid` (`nid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `term_relation`
--
CREATE TABLE `cs_term_relation` (
`trid` int(11) NOT NULL auto_increment,
`tid1` int(10) unsigned NOT NULL default '0',
`tid2` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`trid`),
UNIQUE KEY `tid1_tid2` (`tid1`,`tid2`),
KEY `tid2` (`tid2`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `term_synonym`
--
CREATE TABLE `cs_term_synonym` (
`tsid` int(11) NOT NULL auto_increment,
`tid` int(10) unsigned NOT NULL default '0',
`name` varchar(255) NOT NULL default '',
PRIMARY KEY (`tsid`),
KEY `tid` (`tid`),
KEY `name_tid` (`name`,`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `url_alias`
--
CREATE TABLE `cs_url_alias` (
`pid` int(10) unsigned NOT NULL auto_increment,
`src` varchar(128) NOT NULL default '',
`dst` varchar(128) NOT NULL default '',
`language` varchar(12) NOT NULL default '',
PRIMARY KEY (`pid`),
UNIQUE KEY `dst_language` (`dst`,`language`),
KEY `src` (`src`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE `cs_users` (
`uid` int(10) unsigned NOT NULL auto_increment,
`name` varchar(60) NOT NULL default '',
`pass` varchar(32) NOT NULL default '',
`mail` varchar(64) default '',
`mode` tinyint(4) NOT NULL default '0',
`sort` tinyint(4) default '0',
`threshold` tinyint(4) default '0',
`theme` varchar(255) NOT NULL default '',
`signature` varchar(255) NOT NULL default '',
`created` int(11) NOT NULL default '0',
`access` int(11) NOT NULL default '0',
`login` int(11) NOT NULL default '0',
`status` tinyint(4) NOT NULL default '0',
`timezone` varchar(8) default NULL,
`language` varchar(12) NOT NULL default '',
`picture` varchar(255) NOT NULL default '',
`init` varchar(64) default '',
`data` longtext,
PRIMARY KEY (`uid`),
UNIQUE KEY `name` (`name`),
KEY `access` (`access`),
KEY `created` (`created`),
KEY `mail` (`mail`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
-- --------------------------------------------------------
--
-- Table structure for table `users_roles`
--
CREATE TABLE `cs_users_roles` (
`uid` int(10) unsigned NOT NULL default '0',
`rid` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`uid`,`rid`),
KEY `rid` (`rid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `variable`
--
CREATE TABLE `cs_variable` (
`name` varchar(128) NOT NULL default '',
`value` longtext NOT NULL,
PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `vocabulary`
--
CREATE TABLE `cs_vocabulary` (
`vid` int(10) unsigned NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`description` longtext,
`help` varchar(255) NOT NULL default '',
`relations` tinyint(3) unsigned NOT NULL default '0',
`hierarchy` tinyint(3) unsigned NOT NULL default '0',
`multiple` tinyint(3) unsigned NOT NULL default '0',
`required` tinyint(3) unsigned NOT NULL default '0',
`tags` tinyint(3) unsigned NOT NULL default '0',
`module` varchar(255) NOT NULL default '',
`weight` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`vid`),
KEY `list` (`weight`,`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
-- --------------------------------------------------------
--
-- Table structure for table `vocabulary_node_types`
--
CREATE TABLE `cs_vocabulary_node_types` (
`vid` int(10) unsigned NOT NULL default '0',
`type` varchar(32) NOT NULL default '',
PRIMARY KEY (`type`,`vid`),
KEY `vid` (`vid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `watchdog`
--
CREATE TABLE `cs_watchdog` (
`wid` int(11) NOT NULL auto_increment,
`uid` int(11) NOT NULL default '0',
`type` varchar(16) NOT NULL default '',
`message` longtext NOT NULL,
`variables` longtext NOT NULL,
`severity` tinyint(3) unsigned NOT NULL default '0',
`link` varchar(255) NOT NULL default '',
`location` text NOT NULL,
`referer` varchar(128) NOT NULL default '',
`hostname` varchar(128) NOT NULL default '',
`timestamp` int(11) NOT NULL default '0',
PRIMARY KEY (`wid`),
KEY `type` (`type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=47 ;