-- MySQL dump 10.9
--
-- Host: localhost Database: cmsdam
-- ------------------------------------------------------
-- Server version 4.1.15-Debian_1-log
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `cmsdam_dbcontainer`
--
DROP TABLE IF EXISTS `cmsdam_dbcontainer`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `cmsdam_dbcontainer` (
`id` int(11) NOT NULL auto_increment,
`file_name` varchar(255) NOT NULL,
`key_name` varchar(255) NOT NULL,
`key_value` blob,
`mod_date` datetime NOT NULL,
`owner` varchar(255) NOT NULL,
`type` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `cmsdam_dbcontainer`
--
LOCK TABLES `cmsdam_dbcontainer` WRITE;
/*!40000 ALTER TABLE `cmsdam_dbcontainer` DISABLE KEYS */;
/*!40000 ALTER TABLE `cmsdam_dbcontainer` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `cmsdam_comment`
--
DROP TABLE IF EXISTS `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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `cmsdam_comment`
--
/*!40000 ALTER TABLE `cmsdam_comment` DISABLE KEYS */;
LOCK TABLES `cmsdam_comment` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `cmsdam_comment` ENABLE KEYS */;
--
-- Table structure for table `cmsdam_groups`
--
DROP TABLE IF EXISTS `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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `cmsdam_groups`
--
/*!40000 ALTER TABLE `cmsdam_groups` DISABLE KEYS */;
LOCK TABLES `cmsdam_groups` WRITE;
INSERT INTO `cmsdam_groups` VALUES (12,'anonymous',0,'2004-04-29 22:21:25',1,'127.0.0.2'),(49,'cazzaroni',1,'2004-05-12 23:43:57',3,'127.0.0.2'),(57,'tutti',1,'2004-05-13 00:20:14',3,'127.0.0.2'),(61,'tutti',1,'2004-05-14 23:47:54',7,'127.0.0.2'),(51,'cazzaroni',1,'2004-05-13 00:15:20',6,'127.0.0.2'),(56,'tutti',1,'2004-05-13 00:20:09',2,'127.0.0.2'),(55,'tutti',1,'2004-05-13 00:20:03',1,'127.0.0.2'),(58,'tutti',1,'2004-05-13 00:20:19',4,'127.0.0.2'),(59,'tutti',1,'2004-05-13 00:20:28',6,'127.0.0.2'),(60,'tutti',1,'2004-05-13 00:20:33',5,'127.0.0.2'),(65,'peppino',1,'2004-05-28 20:54:07',3,'127.0.0.2');
UNLOCK TABLES;
/*!40000 ALTER TABLE `cmsdam_groups` ENABLE KEYS */;
--
-- Table structure for table `cmsdam_publishing_attribute`
--
DROP TABLE IF EXISTS `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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `cmsdam_publishing_attribute`
--
/*!40000 ALTER TABLE `cmsdam_publishing_attribute` DISABLE KEYS */;
LOCK TABLES `cmsdam_publishing_attribute` WRITE;
INSERT INTO `cmsdam_publishing_attribute` VALUES (3,'title','','dino','2005-09-06 16:40:01',0),(4,'body','','dino','2005-09-06 16:40:09',0),(10,'image','','dino','2005-09-13 18:17:17',1),(11,'file','','dino','2005-09-13 18:17:47',1);
UNLOCK TABLES;
/*!40000 ALTER TABLE `cmsdam_publishing_attribute` ENABLE KEYS */;
--
-- Table structure for table `cmsdam_publishing_attrsectrel`
--
DROP TABLE IF EXISTS `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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `cmsdam_publishing_attrsectrel`
--
/*!40000 ALTER TABLE `cmsdam_publishing_attrsectrel` DISABLE KEYS */;
LOCK TABLES `cmsdam_publishing_attrsectrel` WRITE;
INSERT INTO `cmsdam_publishing_attrsectrel` VALUES (1,1,3,'dino','2005-09-13 11:29:03'),(2,1,4,'dino','2005-09-13 11:29:10'),(3,6,3,'dino','2005-09-14 14:46:00'),(4,6,10,'dino','2005-09-14 14:46:20'),(5,29,3,'dino','2005-09-14 15:57:14'),(6,29,4,'dino','2005-09-14 15:57:20'),(10,29,10,'','2005-09-16 15:58:14');
UNLOCK TABLES;
/*!40000 ALTER TABLE `cmsdam_publishing_attrsectrel` ENABLE KEYS */;
--
-- Table structure for table `cmsdam_publishing_attrtypes`
--
DROP TABLE IF EXISTS `cmsdam_publishing_attrtypes`;
CREATE TABLE `cmsdam_publishing_attrtypes` (
`id` int(11) NOT NULL default '0',
`type` varchar(100) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `cmsdam_publishing_attrtypes`
--
/*!40000 ALTER TABLE `cmsdam_publishing_attrtypes` DISABLE KEYS */;
LOCK TABLES `cmsdam_publishing_attrtypes` WRITE;
INSERT INTO `cmsdam_publishing_attrtypes` VALUES (0,'text'),(1,'file');
UNLOCK TABLES;
/*!40000 ALTER TABLE `cmsdam_publishing_attrtypes` ENABLE KEYS */;
--
-- Table structure for table `cmsdam_publishing_sections`
--
DROP TABLE IF EXISTS `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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `cmsdam_publishing_sections`
--
/*!40000 ALTER TABLE `cmsdam_publishing_sections` DISABLE KEYS */;
LOCK TABLES `cmsdam_publishing_sections` WRITE;
INSERT INTO `cmsdam_publishing_sections` VALUES (1,9,'dino','2005-09-06 16:31:31'),(8,29,'dino','2006-02-09 18:51:18');
UNLOCK TABLES;
/*!40000 ALTER TABLE `cmsdam_publishing_sections` ENABLE KEYS */;
--
-- Table structure for table `cmsdam_publishing_sections_values`
--
DROP TABLE IF EXISTS `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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `cmsdam_publishing_sections_values`
--
/*!40000 ALTER TABLE `cmsdam_publishing_sections_values` DISABLE KEYS */;
LOCK TABLES `cmsdam_publishing_sections_values` WRITE;
INSERT INTO `cmsdam_publishing_sections_values` VALUES (1,5,1,'ciao','dino','2005-09-20 11:48:29'),(2,6,1,'ciao a te','dino','2005-09-20 11:48:42'),(3,10,1,'filethis?','dino','2005-09-20 11:48:57'),(4,5,2,'Ciao2','dino','2005-09-20 16:21:59'),(5,6,2,'Ciao a te 2','dino','2005-09-20 16:22:06'),(6,10,2,'This is a file. 2','dino','2005-09-20 16:22:17'),(7,10,3,'ciao3','dino','2005-09-20 18:23:02'),(8,5,4,'ciao3','dino','2005-09-20 18:24:00'),(9,5,5,'ciao3','dino','2005-09-20 18:25:41'),(10,10,5,'ciao3','dino','2005-09-20 18:26:11'),(11,6,5,'ciao3','dino','2005-09-20 18:26:29'),(12,6,6,'ciao3','dino','2005-09-20 18:26:42'),(13,5,6,'ciao3','dino','2005-09-20 18:26:54'),(14,10,6,'ciao3','dino','2005-09-20 18:27:14'),(15,10,7,'ciao3','dino','2005-09-20 18:28:46'),(16,5,7,'ciao3','dino','2005-09-20 18:29:08'),(17,6,7,'ciao3','dino','2005-09-20 18:29:16'),(18,6,8,'ciao3','dino','2005-09-20 18:29:22'),(19,6,9,'ciao3','dino','2005-09-20 18:30:57'),(20,6,10,'ciao3','dino','2005-09-20 18:31:15'),(21,6,11,'ciao3','dino','2005-09-20 18:32:01'),(22,6,12,'ciao3','dino','2005-09-20 18:32:19'),(23,6,13,'ciao3','dino','2005-09-20 18:32:21'),(24,6,14,'ciao3','dino','2005-09-20 18:32:22'),(25,6,15,'ciao3','dino','2005-09-20 18:33:23'),(26,6,16,'ciao3','dino','2005-09-20 18:35:29'),(27,6,17,'ciao3','dino','2005-09-20 18:39:45'),(28,10,17,'ciao3','dino','2005-09-20 18:40:27'),(29,5,17,'ciao3','dino','2005-09-20 18:40:34'),(30,5,18,'ciao3','dino','2005-09-20 18:40:38'),(31,5,19,'ciao3','dino','2005-09-20 18:42:37'),(32,5,20,'ciao3','dino','2005-09-20 19:05:59'),(33,5,21,'ciao3','dino','2005-10-03 14:41:18'),(34,5,22,'ciao3','dino','2005-10-17 16:17:31'),(35,5,23,'ciao3','dino','2005-10-17 16:40:07'),(36,5,24,'ciao3','dino','2005-10-17 16:40:09'),(37,5,25,'ciao3','dino','2005-10-17 16:40:14'),(38,5,26,'ciao3','dino','2005-10-17 16:40:16'),(39,5,27,'ciao3','dino','2005-10-17 16:40:17'),(40,5,28,'ciao3','dino','2005-10-17 16:40:19'),(41,5,29,'ciao3','dino','2005-10-17 16:40:21'),(42,5,30,'ciao3','dino','2005-10-17 16:40:26'),(43,5,31,'ciao3','dino','2005-10-17 16:40:29'),(44,5,32,'ciao3','dino','2005-10-17 16:40:32'),(45,5,33,'ciao3','dino','2005-10-17 16:40:34'),(46,5,34,'ciao3','dino','2005-10-17 16:40:38'),(47,5,35,'ciao3','dino','2005-10-17 16:40:39'),(48,5,36,'ciao3','dino','2005-10-17 16:40:41'),(49,5,37,'ciao3','dino','2005-10-17 16:40:42'),(50,5,38,'ciao3','dino','2005-10-17 16:40:43'),(51,5,39,'ciao3','dino','2005-10-17 16:41:18'),(52,5,40,'ciao3','dino','2005-10-17 16:47:42'),(53,5,41,'ciao3','dino','2005-10-17 17:16:23'),(54,5,42,'ciao3','dino','2005-10-17 18:00:19'),(55,5,43,'ciao3','dino','2005-10-17 18:00:24'),(56,5,44,'ciao3','dino','2005-10-17 18:01:34'),(57,5,45,'ciao3','dino','2005-10-17 18:02:01'),(58,5,46,'ciao3','dino','2005-10-17 18:02:03'),(59,5,47,'ciao3','dino','2005-10-17 18:02:05'),(60,5,48,'ciao3','dino','2005-10-17 18:02:06'),(61,5,49,'ciao3','dino','2005-10-17 18:02:07'),(62,5,50,'ciao3','dino','2005-10-17 18:05:51'),(63,5,51,'ciao3','dino','2005-10-17 18:15:32'),(64,5,52,'ciao3','dino','2005-10-17 18:15:36'),(65,5,53,'ciao3','dino','2005-10-17 18:15:37'),(66,5,54,'ciao3','dino','2005-10-17 18:15:38'),(67,5,55,'ciao3','dino','2005-10-17 18:15:39'),(68,5,56,'ciao3','dino','2005-10-17 18:15:40'),(69,5,57,'ciao3','dino','2005-10-17 18:15:41'),(70,5,58,'ciao3','dino','2005-10-17 18:15:42'),(71,5,59,'ciao3','dino','2005-10-17 18:15:43'),(72,5,60,'ciao3','dino','2005-10-17 18:15:44'),(73,5,61,'ciao3','dino','2005-10-17 18:15:45'),(74,5,62,'ciao3','dino','2005-10-17 18:15:46'),(75,5,63,'ciao3','dino','2005-10-17 18:15:46'),(76,5,64,'ciao3','dino','2005-10-17 18:15:47'),(77,5,65,'ciao3','dino','2005-10-17 18:15:47'),(78,5,66,'ciao3','dino','2005-10-17 18:15:47'),(79,5,67,'ciao3','dino','2005-10-17 18:15:47'),(80,5,68,'ciao3','dino','2005-10-17 18:15:48'),(81,5,69,'ciao3','dino','2005-10-17 18:15:48'),(82,5,70,'ciao3','dino','2005-10-17 18:15:48'),(83,5,71,'ciao3','dino','2005-10-17 18:15:49'),(84,5,72,'ciao3','dino','2005-10-17 18:15:50'),(85,5,73,'ciao3','dino','2005-10-17 18:15:51'),(86,5,74,'ciao3','dino','2005-10-17 18:19:21');
UNLOCK TABLES;
/*!40000 ALTER TABLE `cmsdam_publishing_sections_values` ENABLE KEYS */;
--
-- Table structure for table `cmsdam_publishing_sections_versions`
--
DROP TABLE IF EXISTS `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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `cmsdam_publishing_sections_versions`
--
/*!40000 ALTER TABLE `cmsdam_publishing_sections_versions` DISABLE KEYS */;
LOCK TABLES `cmsdam_publishing_sections_versions` WRITE;
INSERT INTO `cmsdam_publishing_sections_versions` VALUES (1,28,10),(3,29,100);
UNLOCK TABLES;
/*!40000 ALTER TABLE `cmsdam_publishing_sections_versions` ENABLE KEYS */;
--
-- Table structure for table `cmsdam_section_groups`
--
DROP TABLE IF EXISTS `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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `cmsdam_section_groups`
--
/*!40000 ALTER TABLE `cmsdam_section_groups` DISABLE KEYS */;
LOCK TABLES `cmsdam_section_groups` WRITE;
INSERT INTO `cmsdam_section_groups` VALUES (1,'Group1',1,'dino','2005-08-14 21:21:47'),(2,'Group1',5,'dino','2005-08-16 12:28:30'),(3,'Group1',6,'dino','2005-08-16 12:37:05'),(4,'Group1',7,'dino','2005-08-16 12:41:08'),(5,'Group1',9,'dino','2005-08-16 12:49:42'),(6,'Group1',10,'dino','2005-08-16 12:53:22'),(7,'Group1',11,'dino','2005-08-16 12:55:57'),(8,'Group1',13,'dino','2005-08-16 12:58:32'),(9,'Group1',14,'dino','2005-08-16 13:01:17'),(10,'Group1',15,'dino','2005-08-16 13:04:07'),(11,'Group1',17,'dino','2005-08-16 13:07:23'),(12,'Group1',18,'dino','2005-08-16 13:10:09'),(14,'*',28,'','2005-08-23 17:41:34'),(15,'*',29,'','2005-09-13 13:15:53');
UNLOCK TABLES;
/*!40000 ALTER TABLE `cmsdam_section_groups` ENABLE KEYS */;
--
-- Table structure for table `cmsdam_section_search_groups`
--
DROP TABLE IF EXISTS `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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `cmsdam_section_search_groups`
--
/*!40000 ALTER TABLE `cmsdam_section_search_groups` DISABLE KEYS */;
LOCK TABLES `cmsdam_section_search_groups` WRITE;
INSERT INTO `cmsdam_section_search_groups` VALUES (1,1,'*','dino','2005-08-14 21:24:33'),(2,5,'*','dino','2005-08-16 12:32:06'),(3,6,'*','dino','2005-08-16 12:37:43'),(4,7,'*','dino','2005-08-16 12:41:37'),(5,9,'*','dino','2005-08-16 12:50:40'),(6,10,'','dino','2005-08-16 12:53:53'),(7,11,'','dino','2005-08-16 12:56:19'),(8,13,'','dino','2005-08-16 12:59:27'),(9,14,'','dino','2005-08-16 13:01:34'),(10,15,'*','dino','2005-08-16 13:04:27'),(11,17,'*','dino','2005-08-16 13:07:52'),(12,18,'*','dino','2005-08-16 13:10:38'),(14,28,'*','','2005-08-23 17:50:32'),(15,29,'*','','2005-09-13 13:15:53');
UNLOCK TABLES;
/*!40000 ALTER TABLE `cmsdam_section_search_groups` ENABLE KEYS */;
--
-- Table structure for table `cmsdam_section_search_users`
--
DROP TABLE IF EXISTS `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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `cmsdam_section_search_users`
--
/*!40000 ALTER TABLE `cmsdam_section_search_users` DISABLE KEYS */;
LOCK TABLES `cmsdam_section_search_users` WRITE;
INSERT INTO `cmsdam_section_search_users` VALUES (1,1,'anonymous','dino','2005-08-14 21:24:13'),(2,1,'*','dino','2005-08-14 21:24:23'),(5,5,'anonymous','dino','2005-08-16 12:30:42'),(6,5,'*','dino','2005-08-16 12:30:45'),(7,6,'anonymous','dino','2005-08-16 12:37:20'),(8,6,'*','dino','2005-08-16 12:37:31'),(9,7,'anonymous','dino','2005-08-16 12:41:19'),(10,7,'*','dino','2005-08-16 12:41:29'),(11,9,'anonymous','dino','2005-08-16 12:50:03'),(12,9,'*','dino','2005-08-16 12:50:11'),(13,10,'','dino','2005-08-16 12:53:41'),(14,11,'','dino','2005-08-16 12:56:08'),(15,13,'','dino','2005-08-16 12:59:22'),(16,14,'','dino','2005-08-16 13:01:23'),(17,15,'anonymous','dino','2005-08-16 13:04:14'),(18,15,'*','dino','2005-08-16 13:04:21'),(19,17,'anonymous','dino','2005-08-16 13:07:32'),(20,17,'*','dino','2005-08-16 13:07:41'),(21,18,'anonymous','dino','2005-08-16 13:10:20'),(22,18,'*','dino','2005-08-16 13:10:28'),(27,28,'anonymous','','2005-08-23 17:47:27'),(26,28,'*','dino','2005-08-22 18:51:45'),(28,29,'anonymous','','2005-09-13 13:15:53'),(29,29,'*','','2005-09-13 13:15:53');
UNLOCK TABLES;
/*!40000 ALTER TABLE `cmsdam_section_search_users` ENABLE KEYS */;
--
-- Table structure for table `cmsdam_section_templates`
--
DROP TABLE IF EXISTS `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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `cmsdam_section_templates`
--
/*!40000 ALTER TABLE `cmsdam_section_templates` DISABLE KEYS */;
LOCK TABLES `cmsdam_section_templates` WRITE;
INSERT INTO `cmsdam_section_templates` VALUES (1,1,'','home.php','Home','cmsdAm, the simple CMS generation!','dino','2005-08-14 21:19:37'),(2,1,'it','home.php','Inizio','cmsdAm, la generazione dei CMS semplici!','dino','2005-08-14 21:20:08'),(3,5,'','search.php','Search','Search engine','dino','2005-08-16 12:24:21'),(4,5,'it','search.php','Ricerca','Ricerca','dino','2005-08-16 12:25:14'),(5,6,'','mailinglists.php','Mailinglists','cmsdAm mailinglists','dino','2005-08-16 12:35:38'),(6,6,'it','mailinglists.php','Liste mail','Liste mail','dino','2005-08-16 12:36:12'),(7,7,'','downloads.php','Downloads','cmsdAm download area','dino','2005-08-16 12:39:22'),(8,7,'it','downloads.php','Scarica','Scarica','dino','2005-08-16 12:39:44'),(9,9,'','news.php','News','News about cmsdam','dino','2005-08-16 12:48:45'),(10,9,'it','news.php','Notizie','Notizie di cmsdAm','dino','2005-08-16 12:49:06'),(11,10,'','top.php','TOP','TOP','dino','2005-08-16 12:52:47'),(12,10,'it','top.php','TOP','TOP','dino','2005-08-16 12:52:52'),(13,11,'','left.php','LEFT','LEFT','dino','2005-08-16 12:55:20'),(14,11,'it','left.php','LEFT','LEFT','dino','2005-08-16 12:55:25'),(15,13,'','section_header.php','section header','Section header','dino','2005-08-16 12:57:59'),(16,13,'it','section_header.php','section header','Section header','dino','2005-08-16 12:58:04'),(17,14,'','section_bottom.php','section bottom','Section bottom','dino','2005-08-16 13:00:48'),(18,14,'it','section_bottom.php','section bottom','Section bottom','dino','2005-08-16 13:00:54'),(19,15,'','features_list.php','Features','Features List','dino','2005-08-16 13:03:28'),(20,15,'it','features_list.php','Richieste','Lista Richieste','dino','2005-08-16 13:03:42'),(21,17,'','api.php','Api Set','API Documentation','dino','2005-08-16 13:06:47'),(22,17,'it','api.php','Api Set','Documentazione API','dino','2005-08-16 13:06:57'),(23,18,'','faq.php','FAQ','Frequently Asked Questions','dino','2005-08-16 13:09:31'),(24,18,'it','faq.php','FAQ','Domande Frequentemente Richieste','dino','2005-08-16 13:09:45'),(28,28,'it','test_it.php','Short test it','Long test it','dino','2005-08-22 17:49:08'),(29,28,'','test.php','Short test en','Long test en','dino','2005-08-23 17:25:16'),(30,29,'','testpub.php','Short test en','Long test en','dino','2005-09-13 13:15:53');
UNLOCK TABLES;
/*!40000 ALTER TABLE `cmsdam_section_templates` ENABLE KEYS */;
--
-- Table structure for table `cmsdam_section_users`
--
DROP TABLE IF EXISTS `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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `cmsdam_section_users`
--
/*!40000 ALTER TABLE `cmsdam_section_users` DISABLE KEYS */;
LOCK TABLES `cmsdam_section_users` WRITE;
INSERT INTO `cmsdam_section_users` VALUES (1,'anonymous',1,'dino','2005-08-14 21:22:11'),(2,'*',1,'dino','2005-08-14 21:22:15'),(3,'anonymous',5,'dino','2005-08-16 12:27:09'),(4,'*',5,'dino','2005-08-16 12:27:37'),(5,'anonymous',6,'dino','2005-08-16 12:36:39'),(6,'*',6,'dino','2005-08-16 12:36:45'),(7,'anonymous',7,'dino','2005-08-16 12:40:13'),(8,'*',7,'dino','2005-08-16 12:40:25'),(9,'anonymous',9,'dino','2005-08-16 12:49:24'),(10,'*',9,'dino','2005-08-16 12:49:31'),(11,'anonymous',10,'dino','2005-08-16 12:53:05'),(12,'*',10,'dino','2005-08-16 12:53:12'),(13,'anonymous',11,'dino','2005-08-16 12:55:36'),(14,'*',11,'dino','2005-08-16 12:55:46'),(15,'anonymous',13,'dino','2005-08-16 12:58:12'),(16,'*',13,'dino','2005-08-16 12:58:23'),(17,'anonymous',14,'dino','2005-08-16 13:01:05'),(18,'*',14,'dino','2005-08-16 13:01:11'),(19,'anonymous',15,'dino','2005-08-16 13:03:51'),(20,'*',15,'dino','2005-08-16 13:03:58'),(21,'anonymous',17,'dino','2005-08-16 13:07:07'),(22,'*',17,'dino','2005-08-16 13:07:15'),(23,'anonymous',18,'dino','2005-08-16 13:09:55'),(24,'*',18,'dino','2005-08-16 13:10:01'),(25,'anonymous',19,'dino','2005-08-16 16:49:26'),(28,'anonymous',28,'','2005-08-23 17:35:46'),(27,'*',28,'','2005-08-22 18:20:20'),(29,'anonymous',29,'','2005-09-13 13:15:53'),(30,'*',29,'','2005-09-13 13:15:53');
UNLOCK TABLES;
/*!40000 ALTER TABLE `cmsdam_section_users` ENABLE KEYS */;
--
-- Table structure for table `cmsdam_sections`
--
DROP TABLE IF EXISTS `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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `cmsdam_sections`
--
/*!40000 ALTER TABLE `cmsdam_sections` DISABLE KEYS */;
LOCK TABLES `cmsdam_sections` WRITE;
INSERT INTO `cmsdam_sections` VALUES (1,'home','dino','2005-08-14 20:51:48'),(6,'mailinglists','dino','2005-08-16 11:57:09'),(5,'search','dino','2005-08-16 11:57:00'),(7,'downloads','dino','2005-08-16 11:57:18'),(28,'test','dino','2005-08-22 17:49:08'),(9,'news','dino','2005-08-16 11:57:33'),(10,'top','dino','2005-08-16 11:57:40'),(11,'left','dino','2005-08-16 11:57:46'),(13,'section_header','dino','2005-08-16 11:58:39'),(14,'section_bottom','dino','2005-08-16 11:59:02'),(15,'features','dino','2005-08-16 11:59:10'),(17,'api','dino','2005-08-16 11:59:22'),(18,'faq','dino','2005-08-16 11:59:26'),(61,'sezionetest','dino','2006-02-17 12:15:34');
UNLOCK TABLES;
/*!40000 ALTER TABLE `cmsdam_sections` ENABLE KEYS */;
--
-- Table structure for table `cmsdam_users`
--
DROP TABLE IF EXISTS `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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `cmsdam_users`
--
/*!40000 ALTER TABLE `cmsdam_users` DISABLE KEYS */;
LOCK TABLES `cmsdam_users` WRITE;
INSERT INTO `cmsdam_users` VALUES (1,'anonymous',0,'noreply@domain.com','nopass','2004-03-02 23:50:42','127.0.0.1'),(2,'dAm2K',1,'dam2000@users.sourceforge.net','dino','2004-04-27 18:30:20','127.0.0.1'),(3,'dino',1,'your@mail.net','dino','2004-05-12 23:18:45','127.0.0.2');
UNLOCK TABLES;
/*!40000 ALTER TABLE `cmsdam_users` ENABLE KEYS */;
--
-- Table structure for table `test`
--
DROP TABLE IF EXISTS `test`;
CREATE TABLE `test` (
`id` int(11) NOT NULL auto_increment,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `test`
--
/*!40000 ALTER TABLE `test` DISABLE KEYS */;
LOCK TABLES `test` WRITE;
INSERT INTO `test` VALUES (8),(9),(10),(11),(12),(13),(14);
UNLOCK TABLES;
/*!40000 ALTER TABLE `test` ENABLE KEYS */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;