 
 /*Data for the table `tan_view` */
 
-insert  into `tan_view`(`id`,`createdBy`,`updatedBy`,`creationDate`,`updateDate`,`updateProcess`,`viewType`,`modelID`,`parentID`,`name`,`label`,`displayOrder`) values ('05d0777b-3c83-11e0-8c47-001c238ae411',NULL,NULL,NULL,NULL,NULL,'Grid','095e14d4-9f58-11df-936f-e37ecc873ea2','5f9a65ea-3c83-11e0-8c47-001c238ae411','DefineModelField','Field',20),('0df07b20-3c83-11e0-8c47-001c238ae411',NULL,NULL,NULL,NULL,NULL,'Grid','2c35f8ba-3c86-11e0-8c47-001c238ae411','5f9a65ea-3c83-11e0-8c47-001c238ae411','DefineModelReference','Reference',30),('32ee7a32-3d10-11e0-8705-001c238ae411',NULL,NULL,NULL,NULL,NULL,'Grid','459404e9-3d0f-11e0-8705-001c238ae411','3a9418f5-3dd7-11e0-8705-001c238ae411','DefineTableIndexColumn','Index Columns',20),('3a9418f5-3dd7-11e0-8705-001c238ae411',NULL,NULL,NULL,NULL,NULL,'Container',NULL,'aedf4d33-379f-11e0-86aa-001c238ae411','DefineTableIndexContainer','Indexes',30),('5f9a65ea-3c83-11e0-8c47-001c238ae411',NULL,NULL,NULL,NULL,NULL,'Tabs',NULL,'88002361-3c7f-11e0-8c47-001c238ae411','DefineModelChildren','Data',10),('88002361-3c7f-11e0-8c47-001c238ae411',NULL,NULL,NULL,NULL,NULL,'Grid','54e96e2a-3c7f-11e0-8c47-001c238ae411',NULL,'DefineModel','Define Model',10),('aedf4d33-379f-11e0-86aa-001c238ae411',NULL,NULL,NULL,NULL,NULL,'Tabs',NULL,'e88068d5-9f57-11df-936f-e37ecc873ea2','DefineTableTabs','Tabs',10),('b7bc1542-3399-11e0-a9e1-00059a3c7800',NULL,NULL,NULL,NULL,NULL,'Grid','fe0e7ad3-3399-11e0-a9e1-00059a3c7800','5f9a65ea-3c83-11e0-8c47-001c238ae411','DefineModelModel','Children Models',10),('be373ebd-3d10-11e0-8705-001c238ae411',NULL,NULL,NULL,NULL,NULL,'Grid','1588be02-3d0f-11e0-8705-001c238ae411','e880753d-9f57-11df-936f-e37ecc873ea2','DefineTableJoinColumn','Join Columns',20),('ca272d48-339a-11e0-a9e1-00059a3c7800',NULL,NULL,NULL,NULL,NULL,'Form',NULL,NULL,'DefinePages','Define Pages',1),('e88065f5-9f57-11df-936f-e37ecc873ea2',NULL,NULL,NULL,NULL,NULL,'Grid','095e0687-9f58-11df-936f-e37ecc873ea2',NULL,'ListTables','List Tables',1),('e88068d5-9f57-11df-936f-e37ecc873ea2',NULL,NULL,NULL,NULL,NULL,'Form','095e0978-9f58-11df-936f-e37ecc873ea2',NULL,'DefineTable','Define Table',10),('e8806a9d-9f57-11df-936f-e37ecc873ea2',NULL,NULL,NULL,NULL,NULL,'Grid','095e1122-9f58-11df-936f-e37ecc873ea2',NULL,'ListModels','List Models',10),('e8806c5f-9f57-11df-936f-e37ecc873ea2',NULL,NULL,NULL,NULL,NULL,'Grid','095e0b79-9f58-11df-936f-e37ecc873ea2',NULL,'Page','List Pages',10),('e8806e17-9f57-11df-936f-e37ecc873ea2',NULL,NULL,NULL,NULL,NULL,'Grid','095e0f48-9f58-11df-936f-e37ecc873ea2','aedf4d33-379f-11e0-86aa-001c238ae411','DefineTableColumns','Columns',10),('e8806fce-9f57-11df-936f-e37ecc873ea2',NULL,NULL,NULL,NULL,NULL,'Grid','095e12fb-9f58-11df-936f-e37ecc873ea2','e880753d-9f57-11df-936f-e37ecc873ea2','DefineTableJoin','Joins',10),('e880737b-9f57-11df-936f-e37ecc873ea2',NULL,NULL,NULL,NULL,NULL,'Container',NULL,NULL,'ManageTables','ManageTables',10),('e880753d-9f57-11df-936f-e37ecc873ea2',NULL,NULL,NULL,NULL,NULL,'Container',NULL,'aedf4d33-379f-11e0-86aa-001c238ae411','DefineTableJoinContainer','Joins',20),('e88076f4-9f57-11df-936f-e37ecc873ea2',NULL,NULL,NULL,NULL,NULL,'Form','095e1122-9f58-11df-936f-e37ecc873ea2','e880789a-9f57-11df-936f-e37ecc873ea2','Models','Model',10),('e880789a-9f57-11df-936f-e37ecc873ea2',NULL,NULL,NULL,NULL,NULL,'Container',NULL,NULL,'Top','Top',10),('e8807a52-9f57-11df-936f-e37ecc873ea2',NULL,NULL,NULL,NULL,NULL,'Grid','095e14d4-9f58-11df-936f-e37ecc873ea2','e88076f4-9f57-11df-936f-e37ecc873ea2','Fields','Fields',20),('e8807c09-9f57-11df-936f-e37ecc873ea2',NULL,NULL,NULL,NULL,NULL,'Grid','095e16ae-9f58-11df-936f-e37ecc873ea2','e88076f4-9f57-11df-936f-e37ecc873ea2','Views','Views',30),('ebb5eb9f-3bf5-11e0-8c47-001c238ae411',NULL,NULL,NULL,NULL,NULL,'Grid','e69acb51-3399-11e0-a9e1-00059a3c7800','3a9418f5-3dd7-11e0-8705-001c238ae411','DefineTableIndex','Indexes',10);
-
-/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;+LOCK TABLES `tan_view` WRITE;
+
+insert  into `tan_view`(`id`,`createdBy`,`updatedBy`,`creationDate`,`updateDate`,`updateProcess`,`viewType`,`modelID`,`parentID`,`name`,`label`,`displayOrder`,`weight`) values ('05d0777b-3c83-11e0-8c47-001c238ae411',NULL,NULL,NULL,NULL,NULL,'Grid','095e14d4-9f58-11df-936f-e37ecc873ea2','5f9a65ea-3c83-11e0-8c47-001c238ae411','DefineModelField','Field',20,1),('0df07b20-3c83-11e0-8c47-001c238ae411',NULL,NULL,NULL,NULL,NULL,'Grid','2c35f8ba-3c86-11e0-8c47-001c238ae411','5f9a65ea-3c83-11e0-8c47-001c238ae411','DefineModelReference','Reference',30,1),('32ee7a32-3d10-11e0-8705-001c238ae411',NULL,NULL,NULL,NULL,NULL,'Grid','459404e9-3d0f-11e0-8705-001c238ae411','3a9418f5-3dd7-11e0-8705-001c238ae411','DefineTableIndexColumn','Index Columns',20,1),('3a9418f5-3dd7-11e0-8705-001c238ae411',NULL,NULL,NULL,NULL,NULL,'Container',NULL,'aedf4d33-379f-11e0-86aa-001c238ae411','DefineTableIndexContainer','Indexes',30,1),('5f9a65ea-3c83-11e0-8c47-001c238ae411',NULL,NULL,NULL,NULL,NULL,'Tabs',NULL,'88002361-3c7f-11e0-8c47-001c238ae411','DefineModelChildren','Data',10,1),('65e1de4e-422c-11e0-8705-001c238ae411',NULL,NULL,NULL,NULL,NULL,'Container','8eeb3df8-422c-11e0-8705-001c238ae411',NULL,'FieldReport','Field Report',10,1),('88002361-3c7f-11e0-8c47-001c238ae411',NULL,NULL,NULL,NULL,NULL,'Grid','54e96e2a-3c7f-11e0-8c47-001c238ae411',NULL,'DefineModel','Define Model',10,1),('8ae87650-422a-11e0-8705-001c238ae411',NULL,NULL,NULL,NULL,NULL,'Grid','9e6b94b8-422a-11e0-8705-001c238ae411',NULL,'ManageMenus','Manage Menus',10,1),('aedf4d33-379f-11e0-86aa-001c238ae411',NULL,NULL,NULL,NULL,NULL,'Tabs',NULL,'e88068d5-9f57-11df-936f-e37ecc873ea2','DefineTableTabs','Tabs',10,1),('b417f3f2-4241-11e0-8705-001c238ae411',NULL,NULL,NULL,NULL,NULL,'Grid','a4395be4-4241-11e0-8705-001c238ae411',NULL,'ListAccounts','List Accounts',10,1),('b7bc1542-3399-11e0-a9e1-00059a3c7800',NULL,NULL,NULL,NULL,NULL,'Grid','fe0e7ad3-3399-11e0-a9e1-00059a3c7800','5f9a65ea-3c83-11e0-8c47-001c238ae411','DefineModelModel','Children Models',10,1),('be373ebd-3d10-11e0-8705-001c238ae411',NULL,NULL,NULL,NULL,NULL,'Grid','1588be02-3d0f-11e0-8705-001c238ae411','e880753d-9f57-11df-936f-e37ecc873ea2','DefineTableJoinColumn','Join Columns',20,1),('ca272d48-339a-11e0-a9e1-00059a3c7800',NULL,NULL,NULL,NULL,NULL,'Form',NULL,NULL,'DefinePages','Define Pages',1,1),('e06fe13d-422d-11e0-8705-001c238ae411',NULL,NULL,NULL,NULL,NULL,'Form','8eeb3df8-422c-11e0-8705-001c238ae411','65e1de4e-422c-11e0-8705-001c238ae411','FieldReportForm','Field Detail',20,1),('e07828b3-422d-11e0-8705-001c238ae411',NULL,NULL,NULL,NULL,NULL,'Grid','8eeb3df8-422c-11e0-8705-001c238ae411','65e1de4e-422c-11e0-8705-001c238ae411','FieldReportGrid','Fields',10,1),('e88065f5-9f57-11df-936f-e37ecc873ea2',NULL,NULL,NULL,NULL,NULL,'Grid','095e0687-9f58-11df-936f-e37ecc873ea2',NULL,'ListTables','List Tables',1,1),('e88068d5-9f57-11df-936f-e37ecc873ea2',NULL,NULL,NULL,NULL,NULL,'Form','095e0978-9f58-11df-936f-e37ecc873ea2',NULL,'DefineTable','Define Table',10,1),('e8806a9d-9f57-11df-936f-e37ecc873ea2',NULL,NULL,NULL,NULL,NULL,'Grid','095e1122-9f58-11df-936f-e37ecc873ea2',NULL,'ListModels','List Models',10,1),('e8806c5f-9f57-11df-936f-e37ecc873ea2',NULL,NULL,NULL,NULL,NULL,'Grid','095e0b79-9f58-11df-936f-e37ecc873ea2',NULL,'Page','List Pages',10,1),('e8806e17-9f57-11df-936f-e37ecc873ea2',NULL,NULL,NULL,NULL,NULL,'Grid','095e0f48-9f58-11df-936f-e37ecc873ea2','aedf4d33-379f-11e0-86aa-001c238ae411','DefineTableColumns','Columns',10,1),('e8806fce-9f57-11df-936f-e37ecc873ea2',NULL,NULL,NULL,NULL,NULL,'Grid','095e12fb-9f58-11df-936f-e37ecc873ea2','e880753d-9f57-11df-936f-e37ecc873ea2','DefineTableJoin','Joins',10,1),('e880737b-9f57-11df-936f-e37ecc873ea2',NULL,NULL,NULL,NULL,NULL,'Container',NULL,NULL,'ManageTables','ManageTables',10,1),('e880753d-9f57-11df-936f-e37ecc873ea2',NULL,NULL,NULL,NULL,NULL,'Container',NULL,'aedf4d33-379f-11e0-86aa-001c238ae411','DefineTableJoinContainer','Joins',20,1),('e88076f4-9f57-11df-936f-e37ecc873ea2',NULL,NULL,NULL,NULL,NULL,'Form','095e1122-9f58-11df-936f-e37ecc873ea2','e880789a-9f57-11df-936f-e37ecc873ea2','Models','Model',10,1),('e880789a-9f57-11df-936f-e37ecc873ea2',NULL,NULL,NULL,NULL,NULL,'Container',NULL,NULL,'Top','Top',10,1),('e8807a52-9f57-11df-936f-e37ecc873ea2',NULL,NULL,NULL,NULL,NULL,'Grid','095e14d4-9f58-11df-936f-e37ecc873ea2','e88076f4-9f57-11df-936f-e37ecc873ea2','Fields','Fields',20,1),('e8807c09-9f57-11df-936f-e37ecc873ea2',NULL,NULL,NULL,NULL,NULL,'Grid','095e16ae-9f58-11df-936f-e37ecc873ea2','e88076f4-9f57-11df-936f-e37ecc873ea2','Views','Views',30,1),('ebb5eb9f-3bf5-11e0-8c47-001c238ae411',NULL,NULL,NULL,NULL,NULL,'Grid','e69acb51-3399-11e0-a9e1-00059a3c7800','3a9418f5-3dd7-11e0-8705-001c238ae411','DefineTableIndex','Indexes',10,1);
+
+UNLOCK TABLES;
+
+/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
+/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;

  `logTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `message` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC;

/*Data for the table `tan_logging` */

/*Table structure for table `tan_menu` */

DROP TABLE IF EXISTS `tan_menu`;

CREATE TABLE `tan_menu` (
  `id` char(36) NOT NULL,
  `createdBy` int(11) unsigned DEFAULT NULL,
  `updatedBy` int(11) unsigned DEFAULT NULL,
  `creationDate` datetime DEFAULT NULL,
  `updateDate` datetime DEFAULT NULL,
  `updateProcess` varchar(100) DEFAULT NULL,
  `name` varchar(50) NOT NULL,
  `label` varchar(50) DEFAULT NULL,
  `databaseID` char(36) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `tan_menu` */

/*Table structure for table `tan_model` */



/*Data for the table `tan_model` */

LOCK TABLES `tan_model` WRITE;

insert  into `tan_model`(`id`,`createdBy`,`updatedBy`,`creationDate`,`updateDate`,`updateProcess`,`resultsPerPage`,`basisTableID`,`name`,`parentID`,`referenceID`,`queryOrder`,`label`,`allowAdd`,`allowEdit`,`allowDelete`,`condition`) values ('095e0687-9f58-11df-936f-e37ecc873ea2',NULL,NULL,NULL,NULL,NULL,100,'fce920bd-9f57-11df-936f-e37ecc873ea2','ManageTables',NULL,NULL,0,'Manage Tables',1,1,0,NULL),('095e0978-9f58-11df-936f-e37ecc873ea2',NULL,NULL,NULL,NULL,NULL,10,'fce920bd-9f57-11df-936f-e37ecc873ea2','DefineTable',NULL,NULL,0,'Define Table',1,1,1,NULL),('095e0b79-9f58-11df-936f-e37ecc873ea2',NULL,NULL,NULL,NULL,NULL,100,'fce93485-9f57-11df-936f-e37ecc873ea2','WebpageList',NULL,NULL,0,'List Webpages',1,0,0,NULL),('095e0f48-9f58-11df-936f-e37ecc873ea2',NULL,NULL,NULL,NULL,NULL,0,'fce924a9-9f57-11df-936f-e37ecc873ea2','DefineTableColumn','095e0978-9f58-11df-936f-e37ecc873ea2','e325875d-9f57-11df-936f-e37ecc873ea2',0,NULL,1,1,1,NULL),('095e1122-9f58-11df-936f-e37ecc873ea2',NULL,NULL,NULL,NULL,NULL,0,'fce92fa4-9f57-11df-936f-e37ecc873ea2','ListModels',NULL,NULL,0,'Define Webpage',1,1,1,'ListModelParentID IS NULL'),('095e12fb-9f58-11df-936f-e37ecc873ea2',NULL,NULL,NULL,NULL,NULL,0,'fce92677-9f57-11df-936f-e37ecc873ea2','DefineTableJoinParent','095e0978-9f58-11df-936f-e37ecc873ea2','e3258cbc-9f57-11df-936f-e37ecc873ea2',0,NULL,1,1,1,NULL),('095e14d4-9f58-11df-936f-e37ecc873ea2',NULL,NULL,NULL,NULL,NULL,0,'fce929b7-9f57-11df-936f-e37ecc873ea2','DefineModelField','54e96e2a-3c7f-11e0-8c47-001c238ae411','e3258e29-9f57-11df-936f-e37ecc873ea2',0,NULL,1,1,1,NULL),('095e16ae-9f58-11df-936f-e37ecc873ea2',NULL,NULL,NULL,NULL,NULL,0,'fce93485-9f57-11df-936f-e37ecc873ea2','Views','WAS095e1122-9f58-11df-936f-e37ecc873','e3258f9b-9f57-11df-936f-e37ecc873ea2',0,NULL,1,1,1,NULL),('1588be02-3d0f-11e0-8705-001c238ae411',NULL,NULL,NULL,NULL,NULL,0,'fce93af0-9f57-11df-936f-e37ecc873ea2','DefineTableJoinParentColumns','095e12fb-9f58-11df-936f-e37ecc873ea2','8ede4520-3d0f-11e0-8705-001c238ae411',0,NULL,1,1,1,NULL),('17784223-4495-11e0-8705-001c238ae411',NULL,NULL,NULL,NULL,NULL,100,'27939565-4492-11e0-8705-001c238ae411','InformationSchemaColumn','d72a0c14-4493-11e0-8705-001c238ae411',NULL,0,NULL,1,1,1,NULL),('2c35f8ba-3c86-11e0-8c47-001c238ae411',NULL,NULL,NULL,NULL,NULL,0,'fce93615-9f57-11df-936f-e37ecc873ea2','DefineModelReference','54e96e2a-3c7f-11e0-8c47-001c238ae411','a14d4a5a-3dd9-11e0-8705-001c238ae411',0,NULL,1,1,1,NULL),('459404e9-3d0f-11e0-8705-001c238ae411',NULL,NULL,NULL,NULL,NULL,0,'fce9394a-9f57-11df-936f-e37ecc873ea2','DefineTableIndexColumn','e69acb51-3399-11e0-a9e1-00059a3c7800','d9d3034b-3d0f-11e0-8705-001c238ae411',0,NULL,1,1,1,NULL),('5077d5a1-430b-11e0-8705-001c238ae411',NULL,NULL,NULL,NULL,NULL,0,'fce92fa4-9f57-11df-936f-e37ecc873ea2','ModelTree','5077d5a1-430b-11e0-8705-001c238ae411','a711dd51-430c-11e0-8705-001c238ae411',0,NULL,1,1,1,NULL),('54e96e2a-3c7f-11e0-8c47-001c238ae411',NULL,NULL,NULL,NULL,NULL,5,'fce92fa4-9f57-11df-936f-e37ecc873ea2','DefineModel',NULL,NULL,0,NULL,1,1,1,NULL),('596f118f-339a-11e0-a9e1-00059a3c7800',NULL,NULL,NULL,NULL,NULL,10,'fce93485-9f57-11df-936f-e37ecc873ea2','DefineWebPages',NULL,NULL,0,NULL,1,1,1,NULL),('8eeb3df8-422c-11e0-8705-001c238ae411',NULL,NULL,NULL,NULL,NULL,100,'fce929b7-9f57-11df-936f-e37ecc873ea2','FieldReport',NULL,NULL,0,NULL,1,1,1,NULL),('9e6b94b8-422a-11e0-8705-001c238ae411',NULL,NULL,NULL,NULL,NULL,100,'80f67124-41f9-11e0-8705-001c238ae411','ManageMenus',NULL,NULL,0,NULL,1,1,1,NULL),('a4395be4-4241-11e0-8705-001c238ae411',NULL,NULL,NULL,NULL,NULL,100,'ee1f03e2-3f76-11e0-8705-001c238ae411','ListAccounts',NULL,NULL,0,NULL,1,1,1,NULL),('d72a0c14-4493-11e0-8705-001c238ae411',NULL,NULL,NULL,NULL,NULL,100,'27aa87c4-4492-11e0-8705-001c238ae411','InformationSchema',NULL,NULL,0,NULL,1,1,1,NULL),('e69acb51-3399-11e0-a9e1-00059a3c7800',NULL,NULL,NULL,NULL,NULL,0,'fce937aa-9f57-11df-936f-e37ecc873ea2','DefineTableIndex','095e0978-9f58-11df-936f-e37ecc873ea2','eda16078-3c51-11e0-8c47-001c238ae411',0,NULL,1,1,1,NULL),('fe0e7ad3-3399-11e0-a9e1-00059a3c7800',NULL,NULL,NULL,NULL,NULL,0,'fce92fa4-9f57-11df-936f-e37ecc873ea2','DefineModelModels','54e96e2a-3c7f-11e0-8c47-001c238ae411','b69402eb-3e14-11e0-8705-001c238ae411',0,'Child Models',1,1,1,NULL);

UNLOCK TABLES;

/*Table structure for table `tan_project` */

