-- MySQL dump 9.11
--
-- Host: localhost Database: cmsdam
-- ------------------------------------------------------
-- 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 (12,'anonymous',0,'2004-04-29 22:21:25',1,'127.0.0.2');
INSERT INTO `cmsdam_groups` VALUES (49,'cazzaroni',1,'2004-05-12 23:43:57',3,'127.0.0.2');
INSERT INTO `cmsdam_groups` VALUES (57,'tutti',1,'2004-05-13 00:20:14',3,'127.0.0.2');
INSERT INTO `cmsdam_groups` VALUES (61,'tutti',1,'2004-05-14 23:47:54',7,'127.0.0.2');
INSERT INTO `cmsdam_groups` VALUES (51,'cazzaroni',1,'2004-05-13 00:15:20',6,'127.0.0.2');
INSERT INTO `cmsdam_groups` VALUES (56,'tutti',1,'2004-05-13 00:20:09',2,'127.0.0.2');
INSERT INTO `cmsdam_groups` VALUES (55,'tutti',1,'2004-05-13 00:20:03',1,'127.0.0.2');
INSERT INTO `cmsdam_groups` VALUES (58,'tutti',1,'2004-05-13 00:20:19',4,'127.0.0.2');
INSERT INTO `cmsdam_groups` VALUES (59,'tutti',1,'2004-05-13 00:20:28',6,'127.0.0.2');
INSERT INTO `cmsdam_groups` VALUES (60,'tutti',1,'2004-05-13 00:20:33',5,'127.0.0.2');
INSERT INTO `cmsdam_groups` VALUES (65,'peppino',1,'2004-05-28 20:54:07',3,'127.0.0.2');
--
-- 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_guestbook_badwords`
--
CREATE TABLE `cmsdam_guestbook_badwords` (
`badword` varchar(25) NOT NULL default ''
) TYPE=MyISAM;
--
-- Dumping data for table `cmsdam_guestbook_badwords`
--
INSERT INTO `cmsdam_guestbook_badwords` VALUES ('fuck');
INSERT INTO `cmsdam_guestbook_badwords` VALUES ('schweinehund');
INSERT INTO `cmsdam_guestbook_badwords` VALUES ('fucking');
INSERT INTO `cmsdam_guestbook_badwords` VALUES ('shit');
INSERT INTO `cmsdam_guestbook_badwords` VALUES ('piss');
INSERT INTO `cmsdam_guestbook_badwords` VALUES ('stronzo');
INSERT INTO `cmsdam_guestbook_badwords` VALUES ('stronzi');
INSERT INTO `cmsdam_guestbook_badwords` VALUES ('vaffanculo');
INSERT INTO `cmsdam_guestbook_badwords` VALUES ('merda');
INSERT INTO `cmsdam_guestbook_badwords` VALUES ('merde');
INSERT INTO `cmsdam_guestbook_badwords` VALUES ('bastardi');
INSERT INTO `cmsdam_guestbook_badwords` VALUES ('bastardo');
INSERT INTO `cmsdam_guestbook_badwords` VALUES ('cazzo');
INSERT INTO `cmsdam_guestbook_badwords` VALUES ('cazzi');
INSERT INTO `cmsdam_guestbook_badwords` VALUES ('fregna');
INSERT INTO `cmsdam_guestbook_badwords` VALUES ('fregne');
INSERT INTO `cmsdam_guestbook_badwords` VALUES ('mignotta');
INSERT INTO `cmsdam_guestbook_badwords` VALUES ('mignotte');
INSERT INTO `cmsdam_guestbook_badwords` VALUES ('puttane');
INSERT INTO `cmsdam_guestbook_badwords` VALUES ('puttana');
INSERT INTO `cmsdam_guestbook_badwords` VALUES ('bocchignottola');
INSERT INTO `cmsdam_guestbook_badwords` VALUES ('puttanona');
INSERT INTO `cmsdam_guestbook_badwords` VALUES ('puttanone');
INSERT INTO `cmsdam_guestbook_badwords` VALUES ('puttanoni');
INSERT INTO `cmsdam_guestbook_badwords` VALUES ('zoccolona');
--
-- Table structure for table `cmsdam_guestbook_bannedips`
--
CREATE TABLE `cmsdam_guestbook_bannedips` (
`banned_ip` varchar(15) NOT NULL default '',
PRIMARY KEY (`banned_ip`)
) TYPE=MyISAM;
--
-- Dumping data for table `cmsdam_guestbook_bannedips`
--
--
-- Table structure for table `cmsdam_guestbook_main`
--
CREATE TABLE `cmsdam_guestbook_main` (
`id` int(5) NOT NULL auto_increment,
`name` varchar(25) NOT NULL default '',
`email` varchar(35) NOT NULL default '',
`icq` int(11) NOT NULL default '0',
`http` varchar(50) NOT NULL default '',
`message` mediumtext NOT NULL,
`timestamp` int(11) NOT NULL default '0',
`ip` varchar(15) NOT NULL default '',
`location` varchar(35) NOT NULL default '',
`browser` varchar(50) NOT NULL default '',
`comment` mediumtext NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM;
--
-- Dumping data for table `cmsdam_guestbook_main`
--
INSERT INTO `cmsdam_guestbook_main` VALUES (1,'dAm2K','dam2k@users.sourceforge.net',0,'cmsdam.sourceforge.net','This is just a guestbook message. This is a plugin of cmsdam.\r
\r
Bye, Dino!',1084109705,'','Italia','','');
INSERT INTO `cmsdam_guestbook_main` VALUES (2,'dAm2K','dam2k@users.sourceforge.net',0,'cmsdam.sourceforge.net','Another try!!',1084112226,'','Italia','','Mo si che funziona sto cacchio de guestbook!');
INSERT INTO `cmsdam_guestbook_main` VALUES (4,'dam2k','dam2k@users.sourceforge.net',0,'cmsdam.sourceforge.net','prova',1084224911,'127.0.0.2','Italia','','Ora funziona bene sia l\'inserimento che la cancellazione!');
--
-- Table structure for table `cmsdam_guestbook_smilies`
--
CREATE TABLE `cmsdam_guestbook_smilies` (
`code` char(3) NOT NULL default '',
`file` varchar(15) NOT NULL default '',
`name` varchar(25) NOT NULL default ''
) TYPE=MyISAM;
--
-- Dumping data for table `cmsdam_guestbook_smilies`
--
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':)','smile.gif','Smile');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':-)','smile.gif','Smile');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':))','lol.gif','LOL');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (';)','wink.gif','Winkywinky');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (';-)','wink.gif','Winkywinky');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':(','frown.gif','Frown');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':-(','frown.gif','Frown');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':[','mad.gif','Mad');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':z)','grazy.gif','Grazy');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':y)','crying.gif','Crying');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':o)','sleepy.gif','Sleepy');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':a)','alien.gif','Alien');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':s)','smokie.gif','Smokie');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':l)','love.gif','Loooove');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':L)','love2.gif','Loooooooooove');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':]','biggrin.gif','Big Smile');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':-/','bounce.gif','Bounce');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':b)','burnout.gif','Burnout');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':&)','clown.gif','Clown');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':?)','confused.gif','Confused');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':c)','cool.gif','Cooooooool');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':e)','eek.gif','Eeeeeeek');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':f)','flash.gif','Flash');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':g)','girl.gif','Girl');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':i)','idee.gif','Idea');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':r)','redface.gif','Redface');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':8)','rolleyes.gif','RollEyes');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':}','tongue.gif','Tongue');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':t)','tasty.gif','Tasty');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':1)','alien2.gif','invader');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':2)','kitty.gif','Bastard Kitty');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':3)','heart.gif','Heart1');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':4)','rainbow.gif','tie died');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':5)','el.gif','Embarrassed');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':6)','pumpkin2.gif','Helloween');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':7)','private.gif','Secret');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':x)','xmas.gif','Christmas');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':9)','kiss.gif','Kiss, Kiss');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':1]','karate.gif','Karate');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':2]','cold.gif','Cold');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':3]','devil.gif','Devil');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':4]','tongue2.gif','So Nyah!');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':5]','redhot.gif','Red Hot');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':6]','smash.gif','Smash!');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':7]','frosty.gif','Frosty');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':8]','confused2.gif','Confused again');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':9]','kaioken.gif','KAI');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':1}','vampire.gif','Vampire');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':2}','splat.gif','Splat');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':3}','rwb.gif','Flag Smiley');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':4}','FRlol.gif','LOL2');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':5}','goodbad.gif','Good / Bad');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':6}','eek2.gif','EEEEK');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':7}','dodgy.gif','Dodgy');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':8}','bawling.gif','Bawling');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':9}','party.gif','Party on, Garth!');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':ni','nighty.gif','Nightey, Night!');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':wa','wavey.gif','Wave!');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':pa','patty.gif','Patty');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':al','alarm.gif','Alarm');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':ba','barf.gif','Barf!');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':bd','birthday.gif','Birthday');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':bu','bubble.gif','bubble');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':ca','cat.gif','Kitty');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':ce','censored.gif','Censor');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':ch','cheers.gif','Cheers');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':co','cowboy.gif','Cowboy');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':da','dance.gif','Dancing');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':gr','dance1.gif','Dancing Stick');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':du','dunce.gif','Dunce');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':fi','finger.gif','Bird');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':fe','flame.gif','Flame');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':fg','flaming.gif','Flaming');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':fl','flower2.gif','Flower2');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':hi','hippie.gif','Hippie');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':jo','joker.gif','Jester');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':kn','knight.gif','Knight');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':ko','koolaid.gif','KoolAid');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':lo','looney.gif','Looney');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':pi','pimp.gif','Pimp');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':fy','mfinger.gif','Monkey Bird');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':pu','pukeface.gif','Puke');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':no','no.gif','NO!');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':ro','rosie.gif','Rosy Cheeks');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':sh','shudder.gif','Shudder');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':si','sick.gif','Sick');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':sm','smoker.gif','Smokin');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':se','sperm.gif','Sperm');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':to','tomato.gif','tomato');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':tu','tut.gif','King Tut');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':ty','type.gif','Typing');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':wh','whip.gif','Whip It!');
INSERT INTO `cmsdam_guestbook_smilies` VALUES (':ja','whoa.gif','Jaw Dropping');
--
-- 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,'','home.php','Home','cmsdAm, the simple CMS generation!','dino','2005-08-14 21:19:37');
INSERT INTO `cmsdam_section_templates` VALUES (2,1,'it','home.php','Inizio','cmsdAm, la generazione dei CMS semplici!','dino','2005-08-14 21:20:08');
INSERT INTO `cmsdam_section_templates` VALUES (3,5,'','search.php','Search','Search engine','dino','2005-08-16 12:24:21');
INSERT INTO `cmsdam_section_templates` VALUES (4,5,'it','search.php','Ricerca','Ricerca','dino','2005-08-16 12:25:14');
INSERT INTO `cmsdam_section_templates` VALUES (5,6,'','mailinglists.php','Mailinglists','cmsdAm mailinglists','dino','2005-08-16 12:35:38');
INSERT INTO `cmsdam_section_templates` VALUES (6,6,'it','mailinglists.php','Liste mail','Liste mail','dino','2005-08-16 12:36:12');
INSERT INTO `cmsdam_section_templates` VALUES (7,7,'','downloads.php','Downloads','cmsdAm download area','dino','2005-08-16 12:39:22');
INSERT INTO `cmsdam_section_templates` VALUES (8,7,'it','downloads.php','Scarica','Scarica','dino','2005-08-16 12:39:44');
INSERT INTO `cmsdam_section_templates` VALUES (9,9,'','news.php','News','News about cmsdam','dino','2005-08-16 12:48:45');
INSERT INTO `cmsdam_section_templates` VALUES (10,9,'it','news.php','Notizie','Notizie di cmsdAm','dino','2005-08-16 12:49:06');
INSERT INTO `cmsdam_section_templates` VALUES (11,10,'','top.php','TOP','TOP','dino','2005-08-16 12:52:47');
INSERT INTO `cmsdam_section_templates` VALUES (12,10,'it','top.php','TOP','TOP','dino','2005-08-16 12:52:52');
INSERT INTO `cmsdam_section_templates` VALUES (13,11,'','left.php','LEFT','LEFT','dino','2005-08-16 12:55:20');
INSERT INTO `cmsdam_section_templates` VALUES (14,11,'it','left.php','LEFT','LEFT','dino','2005-08-16 12:55:25');
INSERT INTO `cmsdam_section_templates` VALUES (15,13,'','section_header.php','section header','Section header','dino','2005-08-16 12:57:59');
INSERT INTO `cmsdam_section_templates` VALUES (16,13,'it','section_header.php','section header','Section header','dino','2005-08-16 12:58:04');
INSERT INTO `cmsdam_section_templates` VALUES (17,14,'','section_bottom.php','section bottom','Section bottom','dino','2005-08-16 13:00:48');
INSERT INTO `cmsdam_section_templates` VALUES (18,14,'it','section_bottom.php','section bottom','Section bottom','dino','2005-08-16 13:00:54');
INSERT INTO `cmsdam_section_templates` VALUES (19,15,'','features_list.php','Features','Features List','dino','2005-08-16 13:03:28');
INSERT INTO `cmsdam_section_templates` VALUES (20,15,'it','features_list.php','Richieste','Lista Richieste','dino','2005-08-16 13:03:42');
INSERT INTO `cmsdam_section_templates` VALUES (21,17,'','api.php','Api Set','API Documentation','dino','2005-08-16 13:06:47');
INSERT INTO `cmsdam_section_templates` VALUES (22,17,'it','api.php','Api Set','Documentazione API','dino','2005-08-16 13:06:57');
INSERT INTO `cmsdam_section_templates` VALUES (23,18,'','faq.php','FAQ','Frequently Asked Questions','dino','2005-08-16 13:09:31');
INSERT INTO `cmsdam_section_templates` VALUES (24,18,'it','faq.php','FAQ','Domande Frequentemente Richieste','dino','2005-08-16 13:09:45');
INSERT INTO `cmsdam_section_templates` VALUES (28,28,'it','test_it.php','Short test it','Long test it','dino','2005-08-22 17:49:08');
INSERT INTO `cmsdam_section_templates` VALUES (29,28,'','test.php','Short test en','Long test en','','2005-08-23 17:25:16');
INSERT INTO `cmsdam_section_templates` VALUES (30,29,'','testpub.php','Short test en','Long test en','','2005-09-13 13:15:53');
--
-- 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,'Group1',1,'dino','2005-08-14 21:21:47');
INSERT INTO `cmsdam_section_groups` VALUES (2,'Group1',5,'dino','2005-08-16 12:28:30');
INSERT INTO `cmsdam_section_groups` VALUES (3,'Group1',6,'dino','2005-08-16 12:37:05');
INSERT INTO `cmsdam_section_groups` VALUES (4,'Group1',7,'dino','2005-08-16 12:41:08');
INSERT INTO `cmsdam_section_groups` VALUES (5,'Group1',9,'dino','2005-08-16 12:49:42');
INSERT INTO `cmsdam_section_groups` VALUES (6,'Group1',10,'dino','2005-08-16 12:53:22');
INSERT INTO `cmsdam_section_groups` VALUES (7,'Group1',11,'dino','2005-08-16 12:55:57');
INSERT INTO `cmsdam_section_groups` VALUES (8,'Group1',13,'dino','2005-08-16 12:58:32');
INSERT INTO `cmsdam_section_groups` VALUES (9,'Group1',14,'dino','2005-08-16 13:01:17');
INSERT INTO `cmsdam_section_groups` VALUES (10,'Group1',15,'dino','2005-08-16 13:04:07');
INSERT INTO `cmsdam_section_groups` VALUES (11,'Group1',17,'dino','2005-08-16 13:07:23');
INSERT INTO `cmsdam_section_groups` VALUES (12,'Group1',18,'dino','2005-08-16 13:10:09');
INSERT INTO `cmsdam_section_groups` VALUES (14,'*',28,'','2005-08-23 17:41:34');
INSERT INTO `cmsdam_section_groups` VALUES (15,'*',29,'','2005-09-13 13:15:53');
--
-- 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,'*','dino','2005-08-14 21:24:33');
INSERT INTO `cmsdam_section_search_groups` VALUES (2,5,'*','dino','2005-08-16 12:32:06');
INSERT INTO `cmsdam_section_search_groups` VALUES (3,6,'*','dino','2005-08-16 12:37:43');
INSERT INTO `cmsdam_section_search_groups` VALUES (4,7,'*','dino','2005-08-16 12:41:37');
INSERT INTO `cmsdam_section_search_groups` VALUES (5,9,'*','dino','2005-08-16 12:50:40');
INSERT INTO `cmsdam_section_search_groups` VALUES (6,10,'','dino','2005-08-16 12:53:53');
INSERT INTO `cmsdam_section_search_groups` VALUES (7,11,'','dino','2005-08-16 12:56:19');
INSERT INTO `cmsdam_section_search_groups` VALUES (8,13,'','dino','2005-08-16 12:59:27');
INSERT INTO `cmsdam_section_search_groups` VALUES (9,14,'','dino','2005-08-16 13:01:34');
INSERT INTO `cmsdam_section_search_groups` VALUES (10,15,'*','dino','2005-08-16 13:04:27');
INSERT INTO `cmsdam_section_search_groups` VALUES (11,17,'*','dino','2005-08-16 13:07:52');
INSERT INTO `cmsdam_section_search_groups` VALUES (12,18,'*','dino','2005-08-16 13:10:38');
INSERT INTO `cmsdam_section_search_groups` VALUES (14,28,'*','','2005-08-23 17:50:32');
INSERT INTO `cmsdam_section_search_groups` VALUES (15,29,'*','','2005-09-13 13:15:53');
--
-- 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','dino','2005-08-14 21:24:13');
INSERT INTO `cmsdam_section_search_users` VALUES (2,1,'*','dino','2005-08-14 21:24:23');
INSERT INTO `cmsdam_section_search_users` VALUES (5,5,'anonymous','dino','2005-08-16 12:30:42');
INSERT INTO `cmsdam_section_search_users` VALUES (6,5,'*','dino','2005-08-16 12:30:45');
INSERT INTO `cmsdam_section_search_users` VALUES (7,6,'anonymous','dino','2005-08-16 12:37:20');
INSERT INTO `cmsdam_section_search_users` VALUES (8,6,'*','dino','2005-08-16 12:37:31');
INSERT INTO `cmsdam_section_search_users` VALUES (9,7,'anonymous','dino','2005-08-16 12:41:19');
INSERT INTO `cmsdam_section_search_users` VALUES (10,7,'*','dino','2005-08-16 12:41:29');
INSERT INTO `cmsdam_section_search_users` VALUES (11,9,'anonymous','dino','2005-08-16 12:50:03');
INSERT INTO `cmsdam_section_search_users` VALUES (12,9,'*','dino','2005-08-16 12:50:11');
INSERT INTO `cmsdam_section_search_users` VALUES (13,10,'','dino','2005-08-16 12:53:41');
INSERT INTO `cmsdam_section_search_users` VALUES (14,11,'','dino','2005-08-16 12:56:08');
INSERT INTO `cmsdam_section_search_users` VALUES (15,13,'','dino','2005-08-16 12:59:22');
INSERT INTO `cmsdam_section_search_users` VALUES (16,14,'','dino','2005-08-16 13:01:23');
INSERT INTO `cmsdam_section_search_users` VALUES (17,15,'anonymous','dino','2005-08-16 13:04:14');
INSERT INTO `cmsdam_section_search_users` VALUES (18,15,'*','dino','2005-08-16 13:04:21');
INSERT INTO `cmsdam_section_search_users` VALUES (19,17,'anonymous','dino','2005-08-16 13:07:32');
INSERT INTO `cmsdam_section_search_users` VALUES (20,17,'*','dino','2005-08-16 13:07:41');
INSERT INTO `cmsdam_section_search_users` VALUES (21,18,'anonymous','dino','2005-08-16 13:10:20');
INSERT INTO `cmsdam_section_search_users` VALUES (22,18,'*','dino','2005-08-16 13:10:28');
INSERT INTO `cmsdam_section_search_users` VALUES (27,28,'anonymous','','2005-08-23 17:47:27');
INSERT INTO `cmsdam_section_search_users` VALUES (26,28,'*','dino','2005-08-22 18:51:45');
INSERT INTO `cmsdam_section_search_users` VALUES (28,29,'anonymous','','2005-09-13 13:15:53');
INSERT INTO `cmsdam_section_search_users` VALUES (29,29,'*','','2005-09-13 13:15:53');
--
-- 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,'dino','2005-08-14 21:22:11');
INSERT INTO `cmsdam_section_users` VALUES (2,'*',1,'dino','2005-08-14 21:22:15');
INSERT INTO `cmsdam_section_users` VALUES (3,'anonymous',5,'dino','2005-08-16 12:27:09');
INSERT INTO `cmsdam_section_users` VALUES (4,'*',5,'dino','2005-08-16 12:27:37');
INSERT INTO `cmsdam_section_users` VALUES (5,'anonymous',6,'dino','2005-08-16 12:36:39');
INSERT INTO `cmsdam_section_users` VALUES (6,'*',6,'dino','2005-08-16 12:36:45');
INSERT INTO `cmsdam_section_users` VALUES (7,'anonymous',7,'dino','2005-08-16 12:40:13');
INSERT INTO `cmsdam_section_users` VALUES (8,'*',7,'dino','2005-08-16 12:40:25');
INSERT INTO `cmsdam_section_users` VALUES (9,'anonymous',9,'dino','2005-08-16 12:49:24');
INSERT INTO `cmsdam_section_users` VALUES (10,'*',9,'dino','2005-08-16 12:49:31');
INSERT INTO `cmsdam_section_users` VALUES (11,'anonymous',10,'dino','2005-08-16 12:53:05');
INSERT INTO `cmsdam_section_users` VALUES (12,'*',10,'dino','2005-08-16 12:53:12');
INSERT INTO `cmsdam_section_users` VALUES (13,'anonymous',11,'dino','2005-08-16 12:55:36');
INSERT INTO `cmsdam_section_users` VALUES (14,'*',11,'dino','2005-08-16 12:55:46');
INSERT INTO `cmsdam_section_users` VALUES (15,'anonymous',13,'dino','2005-08-16 12:58:12');
INSERT INTO `cmsdam_section_users` VALUES (16,'*',13,'dino','2005-08-16 12:58:23');
INSERT INTO `cmsdam_section_users` VALUES (17,'anonymous',14,'dino','2005-08-16 13:01:05');
INSERT INTO `cmsdam_section_users` VALUES (18,'*',14,'dino','2005-08-16 13:01:11');
INSERT INTO `cmsdam_section_users` VALUES (19,'anonymous',15,'dino','2005-08-16 13:03:51');
INSERT INTO `cmsdam_section_users` VALUES (20,'*',15,'dino','2005-08-16 13:03:58');
INSERT INTO `cmsdam_section_users` VALUES (21,'anonymous',17,'dino','2005-08-16 13:07:07');
INSERT INTO `cmsdam_section_users` VALUES (22,'*',17,'dino','2005-08-16 13:07:15');
INSERT INTO `cmsdam_section_users` VALUES (23,'anonymous',18,'dino','2005-08-16 13:09:55');
INSERT INTO `cmsdam_section_users` VALUES (24,'*',18,'dino','2005-08-16 13:10:01');
INSERT INTO `cmsdam_section_users` VALUES (25,'anonymous',19,'dino','2005-08-16 16:49:26');
INSERT INTO `cmsdam_section_users` VALUES (28,'anonymous',28,'','2005-08-23 17:35:46');
INSERT INTO `cmsdam_section_users` VALUES (27,'*',28,'','2005-08-22 18:20:20');
INSERT INTO `cmsdam_section_users` VALUES (29,'anonymous',29,'','2005-09-13 13:15:53');
INSERT INTO `cmsdam_section_users` VALUES (30,'*',29,'','2005-09-13 13:15:53');
--
-- 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,'home','dino','2005-08-14 20:51:48');
INSERT INTO `cmsdam_sections` VALUES (6,'mailinglists','dino','2005-08-16 11:57:09');
INSERT INTO `cmsdam_sections` VALUES (5,'search','dino','2005-08-16 11:57:00');
INSERT INTO `cmsdam_sections` VALUES (7,'downloads','dino','2005-08-16 11:57:18');
INSERT INTO `cmsdam_sections` VALUES (28,'test','dino','2005-08-22 17:49:08');
INSERT INTO `cmsdam_sections` VALUES (9,'news','dino','2005-08-16 11:57:33');
INSERT INTO `cmsdam_sections` VALUES (10,'top','dino','2005-08-16 11:57:40');
INSERT INTO `cmsdam_sections` VALUES (11,'left','dino','2005-08-16 11:57:46');
INSERT INTO `cmsdam_sections` VALUES (13,'section_header','dino','2005-08-16 11:58:39');
INSERT INTO `cmsdam_sections` VALUES (14,'section_bottom','dino','2005-08-16 11:59:02');
INSERT INTO `cmsdam_sections` VALUES (15,'features','dino','2005-08-16 11:59:10');
INSERT INTO `cmsdam_sections` VALUES (29,'testpub','','2005-09-13 13:15:53');
INSERT INTO `cmsdam_sections` VALUES (17,'api','dino','2005-08-16 11:59:22');
INSERT INTO `cmsdam_sections` VALUES (18,'faq','dino','2005-08-16 11:59:26');
--
-- 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`
--
INSERT INTO `cmsdam_users` VALUES (1,'anonymous',0,'noreply@domain.com','nopass','2004-03-02 23:50:42','127.0.0.1');
INSERT INTO `cmsdam_users` VALUES (2,'dAm2K',1,'dam2000@users.sourceforge.net','dino','2004-04-27 18:30:20','127.0.0.1');
INSERT INTO `cmsdam_users` VALUES (3,'dino',1,'your@mail.net','dino','2004-05-12 23:18:45','127.0.0.2');
INSERT INTO `cmsdam_users` VALUES (4,'dino2',1,'dino@pro-netics.com','dino','2004-05-12 23:19:39','127.0.0.2');
INSERT INTO `cmsdam_users` VALUES (5,'pippo',1,'pippo@inzaghi.it','peppino','2004-05-12 23:21:11','127.0.0.2');
INSERT INTO `cmsdam_users` VALUES (6,'paolo',1,'paolo@underbridges.com','paolo','2004-05-12 23:43:06','127.0.0.2');
INSERT INTO `cmsdam_users` VALUES (7,'dam2k2',1,'your@mail.net','prova','2004-05-14 23:47:42','127.0.0.2');
INSERT INTO `cmsdam_users` VALUES (8,'erica',1,'erica@underbridges.com','erica','2004-05-25 16:50:07','127.0.0.2');
INSERT INTO `cmsdam_users` VALUES (9,'pippi',1,'pippi@pippi.it','pippi','2004-07-06 18:51:51','127.0.0.2');
INSERT INTO `cmsdam_users` VALUES (10,'pippolo',1,'dino@dino.it','pippo','2005-07-12 16:17:35','192.168.1.1');
--
-- Table structure for table `test`
--
CREATE TABLE `test` (
`id` int(11) NOT NULL auto_increment,
PRIMARY KEY (`id`)
) TYPE=MyISAM;
--
-- Dumping data for table `test`
--
INSERT INTO `test` VALUES (8);
INSERT INTO `test` VALUES (9);
INSERT INTO `test` VALUES (10);
INSERT INTO `test` VALUES (11);
INSERT INTO `test` VALUES (12);
INSERT INTO `test` VALUES (13);
INSERT INTO `test` VALUES (14);
create table cmsdam_publish_frm_modules (
id integer not null primary key auto_increment,
module_name varchar(255) not null unique,
module_type integer not null,
default_module integer not null default 0);
create table cmsdam_publish_frm_module_types (
id integer not null primary key auto_increment,
module_type integer not null,
keyname varchar(100) not null default "%s",
module_value text not null);