-- MySQL dump 9.11
--
-- Host: localhost    Database: courieradm
-- ------------------------------------------------------
-- Server version	4.0.24_Debian-10-log

--
-- Table structure for table `cmsdam_comment`
--

CREATE TABLE `cmsdam_comment` (
  `id` int(11) NOT NULL auto_increment,
  `comment_text` text NOT NULL,
  `cmsdam_users_id` int(11) NOT NULL default '0',
  `comment_section` varchar(255) default NULL,
  `comment_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `ip` varchar(15) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

--
-- Dumping data for table `cmsdam_comment`
--


--
-- Table structure for table `cmsdam_groups`
--

CREATE TABLE `cmsdam_groups` (
  `id` int(11) NOT NULL auto_increment,
  `group_name` varchar(250) NOT NULL default '',
  `group_type` int(11) NOT NULL default '0',
  `group_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `cmsdam_users_id` int(11) NOT NULL default '0',
  `ip` varchar(15) NOT NULL default '0000-00-00 00:0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

--
-- Dumping data for table `cmsdam_groups`
--

INSERT INTO `cmsdam_groups` VALUES (NULL,'anonymous',0,NOW(),1,'127.0.0.1');
-- Table structure for table `cmsdam_publishing_attribute`
--

CREATE TABLE `cmsdam_publishing_attribute` (
  `id` int(11) NOT NULL auto_increment,
  `attribute` varchar(255) NOT NULL default '',
  `text_publish` varchar(255) NOT NULL default '',
  `c_user` varchar(255) default NULL,
  `c_date` datetime default NULL,
  `type` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `attribute` (`attribute`)
) TYPE=MyISAM;

--
-- Dumping data for table `cmsdam_publishing_attribute`
--
INSERT INTO `cmsdam_publishing_attribute` VALUES (NULL,'title','<input type=\"text\" name=\"%n\" value=\"%v\">','dino','2005-09-06 16:40:01',0);
INSERT INTO `cmsdam_publishing_attribute` VALUES (NULL,'body','<input type=\"text\" name=\"%n\" value=\"%v\">','dino','2005-09-06 16:40:09',0);
INSERT INTO `cmsdam_publishing_attribute` VALUES (NULL,'file','<input type=\"file\" name=\"%n\">','dino','2005-09-13 18:17:47',1);

--
-- Table structure for table `cmsdam_publishing_attrsectrel`
--

CREATE TABLE `cmsdam_publishing_attrsectrel` (
  `id` int(11) NOT NULL auto_increment,
  `section_id` int(11) NOT NULL default '0',
  `attribute_id` int(11) NOT NULL default '0',
  `c_user` varchar(255) default NULL,
  `c_date` datetime default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

--
-- Dumping data for table `cmsdam_publishing_attrsectrel`
--

--
-- Table structure for table `cmsdam_publishing_attrtypes`
--

CREATE TABLE `cmsdam_publishing_attrtypes` (
  `id` int(11) NOT NULL default '0',
  `type` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

--
-- Dumping data for table `cmsdam_publishing_attrtypes`
--

INSERT INTO `cmsdam_publishing_attrtypes` VALUES (0,'text');
INSERT INTO `cmsdam_publishing_attrtypes` VALUES (1,'file');

--
-- Table structure for table `cmsdam_publishing_sections`
--

CREATE TABLE `cmsdam_publishing_sections` (
  `id` int(11) NOT NULL auto_increment,
  `section_id` int(11) NOT NULL default '0',
  `c_user` varchar(255) default NULL,
  `c_date` datetime default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

--
-- Dumping data for table `cmsdam_publishing_sections`
--

--
-- Table structure for table `cmsdam_publishing_sections_values`
--

CREATE TABLE `cmsdam_publishing_sections_values` (
  `id` int(11) NOT NULL auto_increment,
  `attrsectrel_id` int(11) NOT NULL default '0',
  `history` int(11) NOT NULL default '0',
  `text_value` text,
  `c_user` varchar(255) default NULL,
  `c_date` datetime default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

--
-- Dumping data for table `cmsdam_publishing_sections_values`
--

--
-- Table structure for table `cmsdam_publishing_sections_versions`
--

CREATE TABLE `cmsdam_publishing_sections_versions` (
  `id` int(11) NOT NULL auto_increment,
  `section_id` int(11) NOT NULL default '0',
  `history_level` int(11) default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `section_id` (`section_id`)
) TYPE=MyISAM;

--
-- Dumping data for table `cmsdam_publishing_sections_versions`
--

--
-- Table structure for table `cmsdam_section_templates`
--

CREATE TABLE `cmsdam_section_templates` (
  `id` int(11) NOT NULL auto_increment,
  `section_id` int(11) NOT NULL default '0',
  `language` char(2) default NULL,
  `template_file` varchar(255) NOT NULL default '',
  `short_description` varchar(255) NOT NULL default '',
  `long_description` varchar(255) NOT NULL default '',
  `c_user` varchar(255) NOT NULL default '',
  `c_date` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

--
-- Dumping data for table `cmsdam_section_templates`
--

--
-- Table structure for table `cmsdam_section_groups`
--

CREATE TABLE `cmsdam_section_groups` (
  `id` int(11) NOT NULL auto_increment,
  `group_name` varchar(255) NOT NULL default '',
  `section_id` int(11) NOT NULL default '0',
  `c_user` varchar(255) NOT NULL default '',
  `c_date` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

--
-- Dumping data for table `cmsdam_section_groups`
--

--
-- Table structure for table `cmsdam_section_search_groups`
--

CREATE TABLE `cmsdam_section_search_groups` (
  `id` int(11) NOT NULL auto_increment,
  `section_id` int(11) NOT NULL default '0',
  `group_name` varchar(255) NOT NULL default '',
  `c_user` varchar(255) NOT NULL default '',
  `c_date` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

--
-- Dumping data for table `cmsdam_section_search_groups`
--

--
-- Table structure for table `cmsdam_section_search_users`
--

CREATE TABLE `cmsdam_section_search_users` (
  `id` int(11) NOT NULL auto_increment,
  `section_id` int(11) NOT NULL default '0',
  `user_name` varchar(255) NOT NULL default '',
  `c_user` varchar(255) NOT NULL default '',
  `c_date` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

--
-- Dumping data for table `cmsdam_section_search_users`
--

--
-- Table structure for table `cmsdam_section_users`
--

CREATE TABLE `cmsdam_section_users` (
  `id` int(11) NOT NULL auto_increment,
  `user_name` varchar(255) NOT NULL default '',
  `section_id` int(11) NOT NULL default '0',
  `c_user` varchar(255) NOT NULL default '',
  `c_date` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

--
-- Dumping data for table `cmsdam_section_users`
--

--
-- Table structure for table `cmsdam_sections`
--

CREATE TABLE `cmsdam_sections` (
  `id` int(11) NOT NULL auto_increment,
  `section_name` varchar(255) NOT NULL default '',
  `c_user` varchar(255) NOT NULL default '',
  `c_date` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `section_name` (`section_name`)
) TYPE=MyISAM;

--
-- Dumping data for table `cmsdam_sections`
--

--
-- Table structure for table `cmsdam_users`
--

CREATE TABLE `cmsdam_users` (
  `id` int(11) NOT NULL auto_increment,
  `user_name` varchar(250) NOT NULL default '',
  `user_type` int(11) NOT NULL default '0',
  `user_email` varchar(250) default NULL,
  `user_password` varchar(250) NOT NULL default '',
  `user_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `ip` varchar(15) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

--
-- Dumping data for table `cmsdam_users`
--