   `alloweddomains` varchar(128) NOT NULL DEFAULT '',
   PRIMARY KEY (`id`),
   KEY `parent_idx` (`parent`)
-) AUTO_INCREMENT=200 DEFAULT CHARSET=utf8;
-
-
-LOCK TABLES `items` WRITE;
-INSERT INTO `items` VALUES 
-(1,'Website',-1,1,100,'M',100,'2010-01-01','2010-01-01 01:01:01','2100-01-01 01:01:01','S',NULL,'list',''),
-(2,'Login',3,1,2,'A',99,'2010-01-01','2010-01-01 01:01:01','2100-01-01 01:01:01','Y','N','',''),
-(3,'Pages',-1,1,100,'M',0,'2010-01-01','2010-01-01 01:01:01','2100-01-01 01:01:01','Y','Y','',''),
-(4,'Footer',-1,1,100,'M',0,'2010-01-01','2010-01-01 01:01:01','2100-01-01 01:01:01','Y','Y','',''),
-(9,'Dashboard',-1,1,9,'M',0,'2010-01-01','2010-01-01 01:01:01','2100-01-01 01:01:01','Y','Y','',''),
-(10,'CMS',9,1,2,'M',10,'2010-01-01','2010-01-01 01:01:01','2100-01-01 01:01:01','S','Y','',''),
-(11,'Structure',10,1,11,'A',10,'2010-01-01','2010-01-01 01:01:01','2100-01-01 01:01:01','Y','Y','',''),
-(12,'Images',10,1,12,'A',20,'2010-01-01','2010-01-01 01:01:01','2100-01-01 01:01:01','Y','Y','',''),
-(13,'Files',10,1,13,'A',30,'2010-01-01','2010-01-01 01:01:01','2100-01-01 01:01:01','Y','Y','',''),
-(14,'Forms',10,1,14,'A',40,'2010-01-01','2010-01-01 01:01:01','2100-01-01 01:01:01','Y','Y','',''),
-(15,'Users',10,1,15,'A',50,'2010-01-01','2010-01-01 01:01:01','2100-01-01 01:01:01','Y','Y','list',''),
-(16,'Templates',10,1,16,'A',60,'2010-01-01','2010-01-01 01:01:01','2100-01-01 01:01:01','Y','Y','list',''),
-(20,'Management',9,1,2,'M',10,'2010-01-01','2010-01-01 01:01:01','2100-01-01 01:01:01','S','Y','',''),
-(21,'Forms',20,1,18,'A',10,'2010-01-01','2010-01-01 01:01:01','2100-01-01 01:01:01','Y','Y','',''),
-(22,'Comments',20,1,19,'A',10,'2010-01-01','2010-01-01 01:01:01','2100-01-01 01:01:01','Y','Y','',''),
-
-(97,'Privacy Verklaring',4,1,100,'A',0,'2010-01-01','2010-01-01 01:01:01','2100-01-01 01:01:01','Y','N','',''),
-(98,'Disclaimer',4,1,100,'A',0,'2010-01-01','2010-01-01 01:01:01','2100-01-01 01:01:01','Y','N','',''),
-(99,'Global',3,1,100,'A',0,'2010-01-01','2010-01-01 01:01:01','2100-01-01 01:01:01','Y','N','',''),
-
-(102,'Map1',1,1,100,'M',40,'2013-07-11','2013-07-11 01:01:01','2101-01-31 01:01:01','S',NULL,'list',''),
-(103,'Page1',1,1,100,'A',20,'2013-07-11','2013-07-11 01:01:01','2101-01-31 01:01:01','Y',NULL,'list',''),
-(153,'page3 in map',102,1,100,'M',30,'2013-09-09','2013-09-09 01:01:01','2101-01-31 01:01:01','Y',NULL,'list',''),
-(105,'page2 in map',102,1,100,'A',20,'2013-07-11','2013-07-11 01:01:01','2101-01-31 01:01:01','Y',NULL,'list',''),
-(106,'Contact Us',1,1,100,'A',70,'2013-09-07','2013-09-07 01:01:01','2101-01-31 01:01:01','Y',NULL,'list',''),
-(147,'Intros',1,1,103,'M',60,'2013-09-08','2013-09-08 01:01:01','2101-01-31 01:01:01','Y',NULL,'list',''),
-(148,'subpage 1',147,1,100,'M',10,'2013-09-08','2013-09-08 01:01:01','2101-01-31 01:01:01','Y',NULL,'list',''),
-(149,'subpage 2',147,1,100,'M',20,'2013-09-08','2013-09-08 01:01:01','2101-01-31 01:01:01','Y',NULL,'list',''),
-(150,'page1 in map',102,1,100,'A',10,'2013-09-08','2013-09-08 01:01:01','2101-01-31 01:01:01','Y',NULL,'list',''),
-(151,'Page2',1,1,100,'M',30,'2013-09-08','2013-09-08 01:01:01','2101-01-31 01:01:01','Y',NULL,'list',''),
-(152,'News',1,1,100,'D',10,'2013-09-08','2013-09-08 01:01:01','2101-01-31 01:01:01','S',NULL,'list',''),
-(154,'11 sept 13',152,1,100,'M',5,'2013-09-11','2013-09-11 01:01:01','2101-01-31 01:01:01','Y',NULL,'list',''),
-(155,'28 sept 13',152,1,100,'M',5,'2013-09-28','2013-09-30 01:01:01','2101-01-31 01:01:01','Y',NULL,'list',''),
-(156,'02 nov 13',152,1,100,'D',5,'2013-11-02','2013-11-02 01:01:01','2101-01-31 01:01:01','Y',NULL,'list',''),
-(157,'New item',152,1,100,'D',5,'2013-12-06','2013-12-06 01:01:01','2101-01-31 01:01:01','Y',NULL,'list','');
-UNLOCK TABLES;
-
-
+) ENGINE=InnoDB AUTO_INCREMENT=158 DEFAULT CHARSET=utf8;
+
+-- ----------------------------
+-- Records of items
+-- ----------------------------
+INSERT INTO `items` VALUES ('1', '网站', '-1', '1', '100', 'M', '100', '2010-01-01', '2010-01-01 01:01:01', '2100-01-01 01:01:01', 'S', null, 'list', '');
+INSERT INTO `items` VALUES ('2', '登录', '3', '1', '2', 'A', '99', '2010-01-01', '2010-01-01 01:01:01', '2100-01-01 01:01:01', 'Y', 'N', '', '');
+INSERT INTO `items` VALUES ('3', '页面', '-1', '1', '100', 'M', '0', '2010-01-01', '2010-01-01 01:01:01', '2100-01-01 01:01:01', 'Y', 'Y', '', '');
+INSERT INTO `items` VALUES ('4', '底部', '-1', '1', '100', 'M', '0', '2010-01-01', '2010-01-01 01:01:01', '2100-01-01 01:01:01', 'Y', 'Y', '', '');
+INSERT INTO `items` VALUES ('9', '主面板', '-1', '1', '9', 'M', '0', '2010-01-01', '2010-01-01 01:01:01', '2100-01-01 01:01:01', 'Y', 'Y', '', '');
+INSERT INTO `items` VALUES ('10', 'CMS', '9', '1', '2', 'M', '10', '2010-01-01', '2010-01-01 01:01:01', '2100-01-01 01:01:01', 'S', 'Y', '', '');
+INSERT INTO `items` VALUES ('11', '结构', '10', '1', '11', 'A', '10', '2010-01-01', '2010-01-01 01:01:01', '2100-01-01 01:01:01', 'Y', 'Y', '', '');
+INSERT INTO `items` VALUES ('12', '图片', '10', '1', '12', 'A', '20', '2010-01-01', '2010-01-01 01:01:01', '2100-01-01 01:01:01', 'Y', 'Y', '', '');
+INSERT INTO `items` VALUES ('13', '文件', '10', '1', '13', 'A', '30', '2010-01-01', '2010-01-01 01:01:01', '2100-01-01 01:01:01', 'Y', 'Y', '', '');
+INSERT INTO `items` VALUES ('14', '表单', '10', '1', '14', 'A', '40', '2010-01-01', '2010-01-01 01:01:01', '2100-01-01 01:01:01', 'Y', 'Y', '', '');
+INSERT INTO `items` VALUES ('15', '用户', '10', '1', '15', 'A', '50', '2010-01-01', '2010-01-01 01:01:01', '2100-01-01 01:01:01', 'Y', 'Y', 'list', '');
+INSERT INTO `items` VALUES ('16', '模板', '10', '1', '16', 'A', '60', '2010-01-01', '2010-01-01 01:01:01', '2100-01-01 01:01:01', 'Y', 'Y', 'list', '');
+INSERT INTO `items` VALUES ('20', '管理', '9', '1', '2', 'M', '10', '2010-01-01', '2010-01-01 01:01:01', '2100-01-01 01:01:01', 'S', 'Y', '', '');
+INSERT INTO `items` VALUES ('21', '表单', '20', '1', '18', 'A', '10', '2010-01-01', '2010-01-01 01:01:01', '2100-01-01 01:01:01', 'Y', 'Y', '', '');
+INSERT INTO `items` VALUES ('22', '评论', '20', '1', '19', 'A', '10', '2010-01-01', '2010-01-01 01:01:01', '2100-01-01 01:01:01', 'Y', 'Y', '', '');
+INSERT INTO `items` VALUES ('97', '隐私声明', '4', '1', '100', 'A', '0', '2010-01-01', '2010-01-01 01:01:01', '2100-01-01 01:01:01', 'Y', 'N', '', '');
+INSERT INTO `items` VALUES ('98', '免责声明', '4', '1', '100', 'A', '0', '2010-01-01', '2010-01-01 01:01:01', '2100-01-01 01:01:01', 'Y', 'N', '', '');
+INSERT INTO `items` VALUES ('99', '全局', '3', '1', '100', 'A', '0', '2010-01-01', '2010-01-01 01:01:01', '2100-01-01 01:01:01', 'Y', 'N', '', '');
+INSERT INTO `items` VALUES ('102', 'Map1', '1', '1', '100', 'M', '40', '2013-07-11', '2013-07-11 00:00:00', '2101-01-31 00:00:00', 'S', null, 'list', '');
+INSERT INTO `items` VALUES ('103', '页面1', '1', '1', '100', 'A', '20', '2013-07-11', '2013-07-11 00:00:00', '2101-01-31 00:00:00', 'Y', null, 'list', '');
+INSERT INTO `items` VALUES ('105', 'page2 in map', '102', '1', '100', 'A', '20', '2013-07-11', '2013-07-11 01:01:01', '2101-01-31 01:01:01', 'Y', null, 'list', '');
+INSERT INTO `items` VALUES ('106', 'Contact Us', '1', '1', '100', 'A', '70', '2013-09-07', '2013-09-07 01:01:01', '2101-01-31 01:01:01', 'Y', null, 'list', '');
+INSERT INTO `items` VALUES ('147', 'Intros', '1', '1', '103', 'M', '60', '2013-09-08', '2013-09-08 01:01:01', '2101-01-31 01:01:01', 'Y', null, 'list', '');
+INSERT INTO `items` VALUES ('148', 'subpage 1', '147', '1', '100', 'M', '10', '2013-09-08', '2013-09-08 01:01:01', '2101-01-31 01:01:01', 'Y', null, 'list', '');
+INSERT INTO `items` VALUES ('149', 'subpage 2', '147', '1', '100', 'M', '20', '2013-09-08', '2013-09-08 01:01:01', '2101-01-31 01:01:01', 'Y', null, 'list', '');
+INSERT INTO `items` VALUES ('150', 'page1 in map', '102', '1', '100', 'A', '10', '2013-09-08', '2013-09-08 00:00:00', '2101-01-31 00:00:00', 'Y', null, 'list', '');
+INSERT INTO `items` VALUES ('151', 'Page2', '1', '1', '100', 'M', '30', '2013-09-08', '2013-09-08 01:01:01', '2101-01-31 01:01:01', 'Y', null, 'list', '');
+INSERT INTO `items` VALUES ('152', 'News', '1', '1', '100', 'D', '10', '2013-09-08', '2013-09-08 01:01:01', '2101-01-31 01:01:01', 'S', null, 'list', '');
+INSERT INTO `items` VALUES ('153', '第三个页面', '102', '1', '100', 'M', '30', '2013-09-09', '2013-09-09 00:00:00', '2101-01-31 00:00:00', 'Y', null, 'list', '');
+INSERT INTO `items` VALUES ('154', '11 sept 13', '152', '1', '100', 'M', '5', '2013-09-11', '2013-09-11 01:01:01', '2101-01-31 01:01:01', 'Y', null, 'list', '');
+INSERT INTO `items` VALUES ('155', '28 sept 13', '152', '1', '100', 'M', '5', '2013-09-28', '2013-09-30 01:01:01', '2101-01-31 01:01:01', 'Y', null, 'list', '');
+INSERT INTO `items` VALUES ('156', '02 nov 13', '152', '1', '100', 'D', '5', '2013-11-02', '2013-11-02 01:01:01', '2101-01-31 01:01:01', 'Y', null, 'list', '');
+INSERT INTO `items` VALUES ('157', 'New item', '152', '1', '100', 'D', '5', '2013-12-06', '2013-12-06 01:01:01', '2101-01-31 01:01:01', 'Y', null, 'list', '');
+
+-- ----------------------------
+-- Table structure for languages
+-- ----------------------------
 DROP TABLE IF EXISTS `languages`;
 CREATE TABLE `languages` (
   `id` varchar(4) NOT NULL DEFAULT '',
   `name` varchar(32) DEFAULT '',
   `sortorder` int(11) DEFAULT NULL,
   PRIMARY KEY (`id`)
-) DEFAULT CHARSET=utf8;
-
-LOCK TABLES `languages` WRITE;
-INSERT INTO `languages` VALUES 
- ('cn','中文',1),
- ('en','English',2);
-UNLOCK TABLES;
-
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+-- ----------------------------
+-- Records of languages
+-- ----------------------------
+INSERT INTO `languages` VALUES ('cn', '中文', '1');
+INSERT INTO `languages` VALUES ('en', 'English', '2');
+
+-- ----------------------------
+-- Table structure for levels
+-- ----------------------------
 DROP TABLE IF EXISTS `levels`;
 CREATE TABLE `levels` (
   `id` int(11) DEFAULT NULL,
   `name` varchar(32) DEFAULT NULL
-) DEFAULT CHARSET=utf8;
-
-
-LOCK TABLES `levels` WRITE;
-INSERT INTO `levels` VALUES 
- (2,'user'),
- (50,'admin'),
- (99,'super');
-UNLOCK TABLES;
-
-
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+-- ----------------------------
+-- Records of levels
+-- ----------------------------
+INSERT INTO `levels` VALUES ('2', 'user');
+INSERT INTO `levels` VALUES ('50', 'admin');
+INSERT INTO `levels` VALUES ('99', 'super');
+
+-- ----------------------------
+-- Table structure for pages
+-- ----------------------------
 DROP TABLE IF EXISTS `pages`;
 CREATE TABLE `pages` (
   `item` int(11) NOT NULL DEFAULT '0',

  `created` datetime DEFAULT '2010-01-01 01:01:01',
  `updated` datetime DEFAULT '2010-01-01 01:01:01',
  PRIMARY KEY (`item`,`language`)
) DEFAULT CHARSET=utf8;

LOCK TABLES `pages` WRITE;
INSERT INTO `pages` VALUES 
(1,'cn','Your site','welcome','Y','','','2010-01-01 01:01:01','2014-09-03 11:08:24'),
(2,'cn','Login','login','Y','','','2010-01-01 01:01:01','2010-01-01 01:01:01'),
(3,'cn','Pages','','Y','','','2010-01-01 01:01:01','2010-01-01 01:01:01'),
(4,'cn','Footer','','Y','','','2010-01-01 01:01:01','2010-01-01 01:01:01'),
(9,'cn','Dashboard','dashboard','Y','','','2010-01-01 01:01:01','2010-01-01 01:01:01'),
(10,'cn','Website CMS','cms','Y','','','2010-01-01 01:01:01','2010-01-01 01:01:01'),
(11,'cn','Structure','pages','Y','','','2010-01-01 01:01:01','2010-01-01 01:01:01'),
(12,'cn','Images','images','Y','','','2010-01-01 01:01:01','2010-01-01 01:01:01'),
(13,'cn','Files','files','Y','','','2010-01-01 01:01:01','2010-01-01 01:01:01'),
(14,'cn','Forms','forms','Y','','','2010-01-01 01:01:01','2010-01-01 01:01:01'),
(15,'cn','Users','users','Y','','','2010-01-01 01:01:01','2010-01-01 01:01:01'),
(16,'cn','Templates','templates','Y','','','2010-01-01 01:01:01','2010-01-01 01:01:01'),
(20,'cn','Management','admin','Y','','','2010-01-01 01:01:01','2010-01-01 01:01:01'),
(21,'cn','Forms','data','Y','','','2010-01-01 01:01:01','2010-01-01 01:01:01'),
(22,'cn','Comments','comments','Y','','','2010-01-01 01:01:01','2010-01-01 01:01:01'),

(97,'cn','Privacy Verklaring','privacy','Y','','','2010-01-01 01:01:01','2013-03-19 09:30:30'),
(98,'cn','Disclaimer','disclaimer','Y','','','2010-01-01 01:01:01','2012-08-20 17:09:50'),
(99,'cn','Global','global','Y','','','2010-01-01 01:01:01','2012-08-15 22:02:59'),

(152,'cn','News','nieuws','Y','','','2013-09-08 16:41:58','2013-09-30 19:52:12'),
(151,'cn','Page2','pagina2','Y','','','2013-09-08 16:40:07','2013-12-08 17:16:01'),
(150,'cn','page1 in map','','Y','','','2013-09-08 16:31:22','2013-09-09 16:04:31'),
(149,'cn','subpage 2','','Y','','','2013-09-08 16:25:44','2013-10-21 17:01:56'),
(148,'cn','subpage 1','','Y','','','2013-09-08 16:25:28','2013-10-21 17:01:46'),
(147,'cn','Intros','','Y','','','2013-09-08 16:23:37','2013-09-09 16:15:59'),
(102,'cn','Map1','officiele_documenten','Y','','','2013-07-11 16:00:40','2013-09-09 15:15:14'),
(103,'cn','Page1','thepage','Y','','','2013-07-11 16:00:47','2013-11-02 18:21:46'),
(153,'cn','page3 in map','voorwaarden','Y','','','2013-09-09 15:14:51','2013-09-30 20:18:53'),
(105,'cn','page2 in map','Statuten','Y','','','2013-07-11 16:40:43','2013-09-09 16:03:57'),
(106,'cn','Contact Us','contact','Y','','','2013-09-07 21:19:10','2013-09-10 19:10:21'),
(154,'cn','11 sept 13','11sep2013','Y','','','2013-09-30 19:41:31','2013-10-01 22:43:01'),
(155,'cn','28 sept 13','28sep2013','Y','','','2013-09-30 19:43:20','2013-10-20 23:30:55'),
(156,'cn','02 nov 13','02nov2013','Y','','','2013-11-02 17:59:36','2013-11-02 18:34:12'),
(157,'cn','11 dec 13','','Y','','','2013-12-06 22:04:00','2013-12-06 22:11:13'),

(1,'en','Empty Site','welcome','Y','','','2010-01-01 01:01:01','2014-09-03 11:08:14'),
(2,'en','Login','login','Y','','','2010-01-01 01:01:01','2010-01-01 01:01:01'),
(3,'en','Pages','','Y','','','2010-01-01 01:01:01','2010-01-01 01:01:01'),
(4,'en','Footer','','Y','','','2010-01-01 01:01:01','2010-01-01 01:01:01'),
(9,'en','Dashboard','dashboard','Y','','','2010-01-01 01:01:01','2010-01-01 01:01:01'),
(10,'en','Website CMS','cms','Y','','','2010-01-01 01:01:01','2010-01-01 01:01:01'),
(11,'en','Structure','pages','Y','','','2010-01-01 01:01:01','2014-09-03 10:21:49'),
(12,'en','Images','images','Y','','','2010-01-01 01:01:01','2014-09-03 10:21:53'),
(13,'en','Files','files','Y','','','2010-01-01 01:01:01','2014-09-03 10:21:57'),
(14,'en','Forms','forms','Y','','','2010-01-01 01:01:01','2014-09-03 10:22:01'),
(15,'en','Users','users','Y','','','2010-01-01 01:01:01','2014-09-03 10:22:05'),
(16,'en','Templates','templates','Y','','','2010-01-01 01:01:01','2014-09-03 10:22:10'),
/* (17,'en','System','system','Y','','','2010-01-01 01:01:01','2014-09-03 10:22:16'), */
(20,'en','Management','admin','Y','','','2010-01-01 01:01:01','2014-09-03 10:22:35'),
(21,'en','Forms','data','Y','','','2010-01-01 01:01:01','2014-09-03 10:22:39'),
(22,'en','Comments','comments','Y','','','2010-01-01 01:01:01','2014-09-03 10:22:45'),

(97,'en','Privacy Declaration','privacy','Y','','','2010-01-01 01:01:01','2013-03-19 09:30:30'),
(98,'en','Disclaimer','disclaimer','Y','','','2010-01-01 01:01:01','2012-08-20 17:09:50'),
(99,'en','Global','global','Y','','','2010-01-01 01:01:01','2012-08-15 22:02:59'),

(152,'en','News','news','Y','','','2013-09-08 16:41:58','2014-09-03 10:22:50'),
(151,'en','Page2','page2','Y','','','2013-09-08 16:40:07','2014-09-03 10:23:07'),
(150,'en','page1 in map','','Y','','','2013-09-08 16:31:22','2014-09-03 10:24:07'),
(149,'en','subpage 2','','Y','','','2013-09-08 16:25:44','2014-09-03 10:23:37'),
(148,'en','subpage 1','','Y','','','2013-09-08 16:25:28','2014-09-03 10:23:33'),
(147,'en','Intros','','Y','','','2013-09-08 16:23:37','2014-09-03 10:23:18'),
(102,'en','Map1','officiele_documenten','Y','','','2013-07-11 16:00:40','2014-09-03 10:23:12'),
(103,'en','Page1','page1','Y','','','2013-07-11 16:00:47','2014-09-03 10:23:01'),
(153,'en','page3 in map','conditions','Y','','','2013-09-09 15:14:51','2014-09-03 10:24:01'),
(105,'en','page2 in map','stats','Y','','','2013-07-11 16:40:43','2014-09-03 10:23:54'),
(106,'en','Contact Us','contact','Y','','','2013-09-07 21:19:10','2014-09-03 10:23:22'),
(154,'en','11 sept 13','11sep2013','Y','','','2013-09-30 19:41:31','2013-10-01 22:43:01'),
(155,'en','28 sept 13','28sep2013','Y','','','2013-09-30 19:43:20','2013-10-20 23:30:55'),
(156,'en','02 nov 13','02nov2013','Y','','','2013-11-02 17:59:36','2013-11-02 18:34:12'),
(157,'en','11 dec 13','','Y','','','2013-12-06 22:04:00','2013-12-06 22:11:13');
UNLOCK TABLES;

DROP TABLE IF EXISTS `templates`;

CREATE TABLE `templates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(64) DEFAULT '',

  `sortorder` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `username_idx` (`username`,`active`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES ('1', 'super', 'rWorks Super', '*BCF5280DEC442635BC70649677FBC2ADEBBD35F0', 'rWorks', '99', '0', '99', 'Y', 'info@mysite.com', '', 'N', '0');
INSERT INTO `users` VALUES ('2', 'admin', 'rWorks Admin', '*BCF5280DEC442635BC70649677FBC2ADEBBD35F0', 'rWorks', '50', '0', '99', 'Y', 'info@mysite.com', '', 'N', '0');
INSERT INTO `users` VALUES ('3', 'test', 'rWorks Test', '*BCF5280DEC442635BC70649677FBC2ADEBBD35F0', 'rWorks', '2', '0', '99', 'Y', 'info@mysite.com', '', 'N', '0');
INSERT INTO `users` VALUES ('11', 'user', 'Mr. Owner User', '*BCF5280DEC442635BC70649677FBC2ADEBBD35F0', 'users', '50', '0', '99', 'Y', 'info@mysite.com', '', 'N', '10');
