-- MySQL dump 9.11
--
-- Host: localhost    Database: courieradm
-- ------------------------------------------------------
-- Server version	4.0.24_Debian-10sarge1-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 (1,'anonymous',0,'2005-09-30 13:03:43',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 (1,'title','<input type=\"text\" name=\"%n\" value=\"%v\">','dino','2005-09-06 16:40:01',0);
INSERT INTO `cmsdam_publishing_attribute` VALUES (2,'body','<input type=\"text\" name=\"%n\" value=\"%v\">','dino','2005-09-06 16:40:09',0);
INSERT INTO `cmsdam_publishing_attribute` VALUES (3,'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`
--

INSERT INTO `cmsdam_section_templates` VALUES (1,1,'','top.php','top','top','','2005-09-30 13:27:51');
INSERT INTO `cmsdam_section_templates` VALUES (2,1,'it','top.php','top','top','','2005-09-30 13:27:51');
INSERT INTO `cmsdam_section_templates` VALUES (3,2,'','left.php','left','left','','2005-09-30 13:27:51');
INSERT INTO `cmsdam_section_templates` VALUES (4,2,'it','left.php','left','left','','2005-09-30 13:27:51');
INSERT INTO `cmsdam_section_templates` VALUES (5,3,'','home.php','home','home','','2005-09-30 13:27:51');
INSERT INTO `cmsdam_section_templates` VALUES (6,3,'it','home.php','home','home','','2005-09-30 13:27:51');
INSERT INTO `cmsdam_section_templates` VALUES (7,4,'','admin.php','amministrazione','amministrazione','','2005-09-30 13:27:51');
INSERT INTO `cmsdam_section_templates` VALUES (8,4,'it','admin.php','amministrazione','amministrazione','','2005-09-30 13:27:51');
INSERT INTO `cmsdam_section_templates` VALUES (9,5,'','contatti.php','contatti','contatti','','2005-09-30 13:27:51');
INSERT INTO `cmsdam_section_templates` VALUES (10,5,'it','contatti.php','contatti','contatti','','2005-09-30 13:27:51');
INSERT INTO `cmsdam_section_templates` VALUES (11,6,'','mail.php','mail','mail','','2005-09-30 13:27:51');
INSERT INTO `cmsdam_section_templates` VALUES (12,6,'it','mail.php','mail','mail','','2005-09-30 13:27:51');
INSERT INTO `cmsdam_section_templates` VALUES (13,7,'','utenti.php','amministratori','amministratori','','2005-09-30 13:27:51');
INSERT INTO `cmsdam_section_templates` VALUES (14,7,'it','utenti.php','amministratori','amministratori','','2005-09-30 13:27:51');
INSERT INTO `cmsdam_section_templates` VALUES (15,8,'','section_header.php','section_header','section_header','','2005-09-30 13:27:51');
INSERT INTO `cmsdam_section_templates` VALUES (16,8,'it','section_header.php','section_header','section_header','','2005-09-30 13:27:51');
INSERT INTO `cmsdam_section_templates` VALUES (17,9,'','section_bottom.php','section_bottom','section_bottom','','2005-09-30 13:27:51');
INSERT INTO `cmsdam_section_templates` VALUES (18,9,'it','section_bottom.php','section_bottom','section_bottom','','2005-09-30 13:27:51');
INSERT INTO `cmsdam_section_templates` VALUES (19,10,'','mailinglists.php','mailinglists','mailinglists','','2006-01-10 17:16:30');
INSERT INTO `cmsdam_section_templates` VALUES (20,10,'it','mailinglists.php','mailinglists','mailinglists','','2006-01-10 17:16:38');

--
-- 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`
--

INSERT INTO `cmsdam_section_groups` VALUES (1,'*',1,'','2005-09-30 13:27:51');
INSERT INTO `cmsdam_section_groups` VALUES (2,'*',2,'','2005-09-30 13:27:51');
INSERT INTO `cmsdam_section_groups` VALUES (3,'*',3,'','2005-09-30 13:27:51');
INSERT INTO `cmsdam_section_groups` VALUES (10,'mailadmin',4,'dino','2005-09-30 19:07:20');
INSERT INTO `cmsdam_section_groups` VALUES (11,'mailadmin',6,'dino','2005-09-30 19:07:20');
INSERT INTO `cmsdam_section_groups` VALUES (8,'*',8,'','2005-09-30 13:27:51');
INSERT INTO `cmsdam_section_groups` VALUES (9,'*',9,'','2005-09-30 13:27:51');
INSERT INTO `cmsdam_section_groups` VALUES (12,'mailadmin',7,'dino','2005-09-30 19:07:20');
INSERT INTO `cmsdam_section_groups` VALUES (13,'mailadmin',10,'dino','2006-01-10 17:14:32');
INSERT INTO `cmsdam_section_groups` VALUES (14,'listadmin',10,'dino','2006-01-10 17:15:19');

--
-- 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`
--

INSERT INTO `cmsdam_section_search_groups` VALUES (1,1,'*','','2005-09-30 13:27:51');
INSERT INTO `cmsdam_section_search_groups` VALUES (2,2,'*','','2005-09-30 13:27:51');
INSERT INTO `cmsdam_section_search_groups` VALUES (3,0,'*','','2005-09-30 13:27:51');
INSERT INTO `cmsdam_section_search_groups` VALUES (8,8,'*','','2005-09-30 13:27:51');
INSERT INTO `cmsdam_section_search_groups` VALUES (9,9,'*','','2005-09-30 13:27:51');

--
-- 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`
--

INSERT INTO `cmsdam_section_search_users` VALUES (1,1,'anonymous','','2005-09-30 13:27:51');
INSERT INTO `cmsdam_section_search_users` VALUES (2,1,'*','','2005-09-30 13:27:51');
INSERT INTO `cmsdam_section_search_users` VALUES (3,2,'anonymous','','2005-09-30 13:27:51');
INSERT INTO `cmsdam_section_search_users` VALUES (4,2,'*','','2005-09-30 13:27:51');
INSERT INTO `cmsdam_section_search_users` VALUES (5,0,'anonymous','','2005-09-30 13:27:51');
INSERT INTO `cmsdam_section_search_users` VALUES (6,0,'*','','2005-09-30 13:27:51');
INSERT INTO `cmsdam_section_search_users` VALUES (15,8,'anonymous','','2005-09-30 13:27:51');
INSERT INTO `cmsdam_section_search_users` VALUES (16,8,'*','','2005-09-30 13:27:51');
INSERT INTO `cmsdam_section_search_users` VALUES (17,9,'anonymous','','2005-09-30 13:27:51');
INSERT INTO `cmsdam_section_search_users` VALUES (18,9,'*','','2005-09-30 13:27:51');

--
-- 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`
--

INSERT INTO `cmsdam_section_users` VALUES (1,'anonymous',1,'','2005-09-30 13:27:51');
INSERT INTO `cmsdam_section_users` VALUES (2,'*',1,'','2005-09-30 13:27:51');
INSERT INTO `cmsdam_section_users` VALUES (3,'anonymous',2,'','2005-09-30 13:27:51');
INSERT INTO `cmsdam_section_users` VALUES (4,'*',2,'','2005-09-30 13:27:51');
INSERT INTO `cmsdam_section_users` VALUES (5,'anonymous',3,'','2005-09-30 13:27:51');
INSERT INTO `cmsdam_section_users` VALUES (6,'*',3,'','2005-09-30 13:27:51');
INSERT INTO `cmsdam_section_users` VALUES (10,'*',5,'','2005-09-30 13:27:51');
INSERT INTO `cmsdam_section_users` VALUES (15,'anonymous',8,'','2005-09-30 13:27:51');
INSERT INTO `cmsdam_section_users` VALUES (16,'*',8,'','2005-09-30 13:27:51');
INSERT INTO `cmsdam_section_users` VALUES (17,'anonymous',9,'','2005-09-30 13:27:51');
INSERT INTO `cmsdam_section_users` VALUES (18,'*',9,'','2005-09-30 13:27:51');

--
-- 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`
--

INSERT INTO `cmsdam_sections` VALUES (1,'top','','2005-09-30 13:27:51');
INSERT INTO `cmsdam_sections` VALUES (2,'left','','2005-09-30 13:27:51');
INSERT INTO `cmsdam_sections` VALUES (3,'home','','2005-09-30 13:27:51');
INSERT INTO `cmsdam_sections` VALUES (4,'admin','','2005-09-30 13:27:51');
INSERT INTO `cmsdam_sections` VALUES (5,'contatti','','2005-09-30 13:27:51');
INSERT INTO `cmsdam_sections` VALUES (6,'mail','','2005-09-30 13:27:51');
INSERT INTO `cmsdam_sections` VALUES (7,'utenti','','2005-09-30 13:27:51');
INSERT INTO `cmsdam_sections` VALUES (8,'section_header','','2005-09-30 13:27:51');
INSERT INTO `cmsdam_sections` VALUES (9,'section_bottom','','2005-09-30 13:27:51');
INSERT INTO `cmsdam_sections` VALUES (10,'mailinglists','','2006-01-10 17:11:33');

--
-- 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`
--