-- MySQL dump 10.13 Distrib 5.6.51, for Linux (x86_64) -- -- Host: localhost Database: twist_0master -- ------------------------------------------------------ -- Server version 5.6.51 /*!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 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!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 `linkMasterOptionApp` -- DROP TABLE IF EXISTS `linkMasterOptionApp`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `linkMasterOptionApp` ( `deletedDateTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `deletedMemberID` int(11) DEFAULT '0', `insertedDateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `insertedMemberID` int(11) DEFAULT '0', `linkMasterOptionAppID` int(11) NOT NULL AUTO_INCREMENT, `masterAppID` int(11) NOT NULL, `masterOptionID` int(11) NOT NULL, `updatedDateTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `updatedMemberID` int(11) DEFAULT '0', PRIMARY KEY (`linkMasterOptionAppID`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `linkMasterOptionApp` -- LOCK TABLES `linkMasterOptionApp` WRITE; /*!40000 ALTER TABLE `linkMasterOptionApp` DISABLE KEYS */; INSERT INTO `linkMasterOptionApp` VALUES ('0000-00-00 00:00:00',0,'2017-09-29 18:11:10',0,1,160,3,'0000-00-00 00:00:00',0); /*!40000 ALTER TABLE `linkMasterOptionApp` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `linkMasterOptionDataManager` -- DROP TABLE IF EXISTS `linkMasterOptionDataManager`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `linkMasterOptionDataManager` ( `deletedDateTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `deletedMemberID` int(11) DEFAULT '0', `insertedDateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `insertedMemberID` int(11) DEFAULT '0', `linkMasterOptionDataManagerID` int(11) NOT NULL AUTO_INCREMENT, `masterDataManagerID` int(11) NOT NULL, `masterOptionID` int(11) NOT NULL, `updatedDateTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `updatedMemberID` int(11) DEFAULT '0', PRIMARY KEY (`linkMasterOptionDataManagerID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `linkMasterOptionDataManager` -- LOCK TABLES `linkMasterOptionDataManager` WRITE; /*!40000 ALTER TABLE `linkMasterOptionDataManager` DISABLE KEYS */; /*!40000 ALTER TABLE `linkMasterOptionDataManager` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `linkMasterOptionEntityRequest` -- DROP TABLE IF EXISTS `linkMasterOptionEntityRequest`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `linkMasterOptionEntityRequest` ( `deletedDateTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `deletedMemberID` int(11) DEFAULT '0', `insertedDateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `insertedMemberID` int(11) DEFAULT '0', `linkMasterOptionEntityRequestID` int(11) NOT NULL AUTO_INCREMENT, `masterEntityRequestID` int(11) NOT NULL, `masterOptionID` int(11) NOT NULL, `updatedDateTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `updatedMemberID` int(11) DEFAULT '0', PRIMARY KEY (`linkMasterOptionEntityRequestID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `linkMasterOptionEntityRequest` -- LOCK TABLES `linkMasterOptionEntityRequest` WRITE; /*!40000 ALTER TABLE `linkMasterOptionEntityRequest` DISABLE KEYS */; /*!40000 ALTER TABLE `linkMasterOptionEntityRequest` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `linkMasterOptionParameter` -- DROP TABLE IF EXISTS `linkMasterOptionParameter`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `linkMasterOptionParameter` ( `deletedDateTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `deletedMemberID` int(11) DEFAULT '0', `insertedDateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `insertedMemberID` int(11) DEFAULT '0', `linkMasterOptionParameterID` int(11) NOT NULL AUTO_INCREMENT, `masterOptionID` int(11) NOT NULL, `masterParameterID` int(11) NOT NULL, `updatedDateTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `updatedMemberID` int(11) DEFAULT '0', PRIMARY KEY (`linkMasterOptionParameterID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `linkMasterOptionParameter` -- LOCK TABLES `linkMasterOptionParameter` WRITE; /*!40000 ALTER TABLE `linkMasterOptionParameter` DISABLE KEYS */; /*!40000 ALTER TABLE `linkMasterOptionParameter` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `linkMasterOptionQuery` -- DROP TABLE IF EXISTS `linkMasterOptionQuery`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `linkMasterOptionQuery` ( `deletedDateTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `deletedMemberID` int(11) DEFAULT '0', `insertedDateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `insertedMemberID` int(11) DEFAULT '0', `linkMasterOptionQueryID` int(11) NOT NULL AUTO_INCREMENT, `masterOptionID` int(11) NOT NULL, `masterQueryID` int(11) NOT NULL, `updatedDateTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `updatedMemberID` int(11) DEFAULT '0', PRIMARY KEY (`linkMasterOptionQueryID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `linkMasterOptionQuery` -- LOCK TABLES `linkMasterOptionQuery` WRITE; /*!40000 ALTER TABLE `linkMasterOptionQuery` DISABLE KEYS */; /*!40000 ALTER TABLE `linkMasterOptionQuery` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `linkMasterOptionQueryView` -- DROP TABLE IF EXISTS `linkMasterOptionQueryView`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `linkMasterOptionQueryView` ( `deletedDateTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `deletedMemberID` int(11) DEFAULT '0', `insertedDateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `insertedMemberID` int(11) DEFAULT '0', `linkMasterOptionQueryViewID` int(11) NOT NULL AUTO_INCREMENT, `masterOptionID` int(11) NOT NULL, `masterQueryViewID` int(11) NOT NULL, `updatedDateTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `updatedMemberID` int(11) DEFAULT '0', PRIMARY KEY (`linkMasterOptionQueryViewID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `linkMasterOptionQueryView` -- LOCK TABLES `linkMasterOptionQueryView` WRITE; /*!40000 ALTER TABLE `linkMasterOptionQueryView` DISABLE KEYS */; /*!40000 ALTER TABLE `linkMasterOptionQueryView` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `linkMasterOptionSQLColumn` -- DROP TABLE IF EXISTS `linkMasterOptionSQLColumn`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `linkMasterOptionSQLColumn` ( `deletedDateTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `deletedMemberID` int(11) DEFAULT '0', `insertedDateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `insertedMemberID` int(11) DEFAULT '0', `linkMasterOptionSQLColumnID` int(11) NOT NULL AUTO_INCREMENT, `masterSQLColumnID` int(11) NOT NULL, `masterOptionID` int(11) NOT NULL, `updatedDateTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `updatedMemberID` int(11) DEFAULT '0', PRIMARY KEY (`linkMasterOptionSQLColumnID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `linkMasterOptionSQLColumn` -- LOCK TABLES `linkMasterOptionSQLColumn` WRITE; /*!40000 ALTER TABLE `linkMasterOptionSQLColumn` DISABLE KEYS */; /*!40000 ALTER TABLE `linkMasterOptionSQLColumn` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `linkMasterOptionSQLTable` -- DROP TABLE IF EXISTS `linkMasterOptionSQLTable`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `linkMasterOptionSQLTable` ( `deletedDateTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `deletedMemberID` int(11) DEFAULT '0', `insertedDateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `insertedMemberID` int(11) DEFAULT '0', `linkMasterOptionSQLTableID` int(11) NOT NULL AUTO_INCREMENT, `masterOptionID` int(11) NOT NULL, `masterSQLTableID` int(11) NOT NULL, `updatedDateTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `updatedMemberID` int(11) DEFAULT '0', PRIMARY KEY (`linkMasterOptionSQLTableID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `linkMasterOptionSQLTable` -- LOCK TABLES `linkMasterOptionSQLTable` WRITE; /*!40000 ALTER TABLE `linkMasterOptionSQLTable` DISABLE KEYS */; /*!40000 ALTER TABLE `linkMasterOptionSQLTable` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `masterApp` -- DROP TABLE IF EXISTS `masterApp`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `masterApp` ( `appCode` varchar(100) NOT NULL, `appCodeTitleCase` varchar(100) NOT NULL, `appGUID` varchar(38) NOT NULL, `appID` int(11) NOT NULL AUTO_INCREMENT, `appInstallData` varchar(8000) NOT NULL, `appInstallDatabaseName` varchar(100) NOT NULL, `appName` varchar(100) NOT NULL, `appNameLowerCasePlural` varchar(50) NOT NULL, `appNameLowerCaseSingular` varchar(50) NOT NULL, `appNameMixedCasePlural` varchar(50) NOT NULL, `appNameMixedCaseSingular` varchar(50) NOT NULL, `appNamePublic` varchar(100) NOT NULL, `appOverview` varchar(500) NOT NULL, `appTitle` varchar(100) NOT NULL, `appUpdatedDateTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `appUpdatedMemberID` int(11) NOT NULL DEFAULT '0', `appUpdateSQL` varchar(500) NOT NULL, `appVersion` smallint(6) NOT NULL DEFAULT '0', `appVersionOld` varchar(20) NOT NULL, `appVersionArchive` tinyint(1) NOT NULL DEFAULT '0', `appVersionMajor` tinyint(1) NOT NULL DEFAULT '0', `appVersionMinor` tinyint(1) NOT NULL DEFAULT '0', `deletedDateTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `deletedMemberID` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`appID`) ) ENGINE=MyISAM AUTO_INCREMENT=161 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `masterApp` -- LOCK TABLES `masterApp` WRITE; /*!40000 ALTER TABLE `masterApp` DISABLE KEYS */; INSERT INTO `masterApp` VALUES ('project','Project','350DDA85-3C6C-6CFA-DFFD-6652DD0A8E7D',1,'{\"strSQLTableCode01\":\"twistProject\"}','twist_package_app_twistProject','Twist! Projects','projects','project','Projects','Project','Projects','Manages Projects','Twist! App Manager','0000-00-00 00:00:00',0,'UPDATE twistProject AS proj',1,'V1.00',0,1,0,'0000-00-00 00:00:00',0),('opportunity','Opportunity','4E9090BF-A545-5377-4CBD-9B4133FF39DE',2,'{\"strSQLTableCode01\":\"twistOpportunity\"}','twist_package_app_twistOpportunity','Twist! Opportunities','opportunities','opportunity','Opportunities','Opportunity','Opportunities','Manages Opportunities','','0000-00-00 00:00:00',0,'UPDATE twistOpportunity AS oppo',1,'V1.00',0,1,0,'0000-00-00 00:00:00',0),('organization','Organization','8A397816-C23A-2867-0DFD-2CDB5CE124C7',3,'{\"strSQLTableCode01\":\"twistOrganization\"}','twist_package_app_twistOrganization','Twist! Organizations','organizations','organization','Organizations','Organization','Organizations','Manages Organizations','','0000-00-00 00:00:00',0,'UPDATE twistOrganization AS orgn',3,'V1.00',0,1,0,'0000-00-00 00:00:00',0),('entityRequest','EntityRequest','5A74AF38-EA85-9542-4A50-36CF1964D438',4,'{\"strSQLTableCode01\":\"twistEntityRequest\",\"strSQLTableCode02\":\"twistEntityRequestGroup\"}','twist_package_app_twistEntityRequest','Twist! Entity Requests','entity requests','entity request','Entity Requests','Entity Request','Entity Requests','Manages Entity Requests','','0000-00-00 00:00:00',0,'UPDATE twistEntityRequest AS ereq',2,'V1.00',0,1,0,'0000-00-00 00:00:00',0),('goal','Goal','08BE600E-5DA4-C28B-BE16-7C93EFC388A5',5,'{\"strSQLTableCode01\":\"twistGoal\"}','twist_package_app_twistGoal','Twist! Goals','goals','goal','Goals','Goal','Goals','Manages Goals','','0000-00-00 00:00:00',0,'UPDATE twistGoal AS goal',1,'V1.00',0,1,0,'0000-00-00 00:00:00',0),('task','Task','8549A893-E7B7-CC4C-E90F-4B46BBFE7ECC',6,'{\"strSQLTableCode01\":\"twistTask\"}','twist_package_app_twistTask','Twist! Tasks','tasks','task','Tasks','Task','Tasks','Manages Tasks','','0000-00-00 00:00:00',0,'UPDATE twistTask AS task',1,'V1.00',0,1,0,'0000-00-00 00:00:00',0),('person','Person','',7,'{\"strSQLTableCode01\":\"twistPerson\"}','twist_package_app_twistPerson','Twist! People','people','person','People','Person','People','Manages People','','0000-00-00 00:00:00',0,'UPDATE twistPerson AS prsn',7,'V1.00',0,1,0,'0000-00-00 00:00:00',0),('address','Address','',8,'{\"strSQLTableCode01\":\"twistAddress\"}','twist_package_app_twistAddress','Twist! Addresses','addresses','address','Addresses','Address','Addresses','Manage Addresses with the following types:\n\n-- Phone\n-- Email\n-- Web Addresses\n-- Web Names\n-- Physical Addresses','','0000-00-00 00:00:00',0,'UPDATE twistAddress AS addr',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('app','App','',9,'{\"strSQLTableCode01\":\"twistApp\"}','twist_package_app_twistApp','Twist! Apps','apps','app','Apps','App','Apps','Manages Twist! and Third-Party Applications. Apps can be:\r\n\r\n-- Installed\r\n-- Updated\r\n-- De-Instatlled\r\n\r\nUsers with permission can publish apps to the Twist! App Store.','','0000-00-00 00:00:00',0,'UPDATE twistApp AS apps',2,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('businessPartner','BusinessPartner','',10,'{\"strSQLTableCode01\":\"twistBusinessPartner\"}','twist_package_app_twistBusinessPartner','Twist! Business Partners','business partners','business partner','Business Partners','Business Partner','Bus. Partners','Manages Business Partners','','0000-00-00 00:00:00',0,'UPDATE twistBusinessPartner AS bupa',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('businessPlan','BusinessPlan','',11,'{\"strSQLTableCode01\":\"twistBusinessPlan\"}','twist_package_app_twistBusinessPlan','Twist! Business Plans','business plans','business plan','Business Plan','Business Plan','Bus. Plans','Manages Business Plans','','0000-00-00 00:00:00',0,'UPDATE twistBusinessPlans AS bpln',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('proposal','Proposal','',12,'{\"strSQLTableCode01\":\"twistProposal\"}','twist_package_app_twistProposal','Twist! Proposals','proposals','proposal','Proposals','Proposal','Proposals','Manages Proposals','','0000-00-00 00:00:00',0,'UPDATE twistProposal AS prpo',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('calendar','Calendar','',13,'{\"strSQLTableCode01\":\"twistCalendar\",\"strSQLTableCode02\":\"twistTask\"}','twist_package_app_twistCalendar','Twist! Calendars','calendars','calendar','Calendars','Calendar','Calendars','Manage an unlimited number of Calendars for use with:\r\n\r\n-- Twist! Tasks\r\n-- Twist Projects\r\n-- Twist Deliverables\r\n-- Twist Opportunities\r\n\r\nor any other Twist! application with at least one embedded date field.','','0000-00-00 00:00:00',0,'UPDATE twistCalendar AS cldr',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('valuation','Valuation','',14,'{\"strSQLTableCode01\":\"twistValuation\"}','twist_package_app_twistValuation','Twist! Valuations','valuations','valuation','Valuations','Valuation','Valuations','Manages Valuations','','0000-00-00 00:00:00',0,'UPDATE twistValuation AS valu',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('contentVersion','Content','',15,'{\"strSQLTableCode01\":\"twistContentVersion\",\"strSQLTableCode02\":\"twistContent\"}','twist_package_app_twistContent','Twist! Content','content','content','Content','Content','Content','Manages Content','','0000-00-00 00:00:00',0,'UPDATE twistContentVersion AS conv JOIN twistContent AS cont ON cver.contentVersionContentID = cont.contentID',2,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('customerClient','CustomerClient','',16,'{\"strSQLTableCode01\":\"twistCustomerClient\"}','twist_package_app_twistCustomerClient','Twist! Customers/Clients','customers / clients','customer / client','Customers/Clients','Customer/Client','Cust./Clients','Manages Customer and Clients','','0000-00-00 00:00:00',0,'UPDATE twistCustomerClient AS cucl',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('dataManager','DataManager','',17,'{\"strSQLTableCode01\":\"twistDataManager\",\"strSQLTableCode02\":\"twistDataManagerOption\",\"strSQLTable03\",\"twistDataManagerSection\",\"strSQLTableCode04\":\"twistForm\",\"strSQLTable05\":\"twistFormItem\"}','twist_package_app_twistDataManager','Twist! DataManagers','data managers','data manager','Data Managers','Data Manager','Data Managers','Manages Data Managers','','0000-00-00 00:00:00',0,'UPDATE twistDataManager AS dmgr',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('password','Password','',18,'{\"strSQLTableCode01\":\"twistPassword\"}','twist_package_app_twistPassword','Twist! Passwords','passwords','password','Passwords','Password','Passwords','Manages Passwords','','0000-00-00 00:00:00',0,'UPDATE twistPassword AS pswd',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('linkedIn','LinkedIn','',19,'{\"strSQLTableCode01\":\"twistLinkedInConnection\"}','twist_package_app_twistLinkedIn','Twist! LinkedIn Connections','LinkedIn connections','LinkedIn connection','LinkedIn Connections','LinkedIn Connection','LinkedIn Conn.','Manages LinkedIn Connections','','0000-00-00 00:00:00',0,'UPDATE twistLinkedInConnection AS lico',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('document','Document','',20,'{\"strSQLTableCode01\":\"twistDocument\"}','twist_package_app_twistDocument','Twist! Documents','documents','document','Documents','Document','Documents','Manages Documents','','0000-00-00 00:00:00',0,'UPDATE twistDocument AS docu',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('domainName','DomainName','',21,'{\"strSQLTableCode01\":\"twistDomainName\"}','twist_package_app_twistDomainName','Twist! Domain Names','domain names','domain name','Domain Names','Domain Name','Domain Names','Manages Domain Names','','0000-00-00 00:00:00',0,'UPDATE twistDomainName AS dona',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('employeeReview','EmployeeReview','',22,'{\"strSQLTableCode01\":\"twistEmployeeReview\",\"strSQLTableCode02\":\"twistEmployee\"}','twist_package_app_twistEmployeeReview','Twist! Employee Reviews','employee reviews','employee review','Employee Reviews','Employee Review','Employee Reviews','Manages Employee Reviews','','0000-00-00 00:00:00',0,'UPDATE twistEmployeeReview AS erev',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('employee','Employee','',23,'{\"strSQLTableCode01\":\"twistEmployee\"}','twist_package_app_twistEmployee','Twist! Employees','employees','employee','Employees','Employee','Employees','Manages Employees','','0000-00-00 00:00:00',0,'UPDATE twistEmployee AS empl',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('issue','Issue','',25,'{\"strSQLTableCode01\":\"twistIssue\"}','twist_package_app_twistIssue','Twist! Issues','issues','issue','Issues','Issue','Issues','Manages Issues','','0000-00-00 00:00:00',0,'UPDATE twistIssue AS issu',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('linkType','LinkType','',26,'{\"strSQLTableCode01\":\"twistLinkType\"}','twist_package_app_twistLinkType','Twist! Link Types','link types','link type','Link Types','Link Type','Link Types','Manages Link Types','','0000-00-00 00:00:00',0,'UPDATE twistLinkType AS lktp',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('memory','Memory','',27,'{\"strSQLTableCode01\":\"twistMemory\"}','twist_package_app_twistMemory','Twist! Memories','memories','memory','Memories','Memory','Memories','Manages Memories','','0000-00-00 00:00:00',0,'UPDATE twistMemory AS mery',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('message','Message','',28,'{\"strSQLTableCode01\":\"twistMessage\"}','twist_package_app_twistMessage','Twist! Messages','messages','message','Messages','Message','Messages','Manages Messages','','0000-00-00 00:00:00',0,'UPDATE twistMessage AS mesg',2,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('note','Note','',29,'{\"strSQLTableCode01\":\"twistNote\"}','twist_package_app_twistNote','Twist! Notes','notes','note','Notes','Note','Notes','Manages Notes','','0000-00-00 00:00:00',0,'UPDATE twistNote AS note',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('parameter','Parameter','',30,'{\"strSQLTableCode01\":\"twistParameter\"}','twist_package_app_twistParameter','Twist! Parameters','parameters','parameter','Parameters','Parameter','Parameters','Manages Parameters','','0000-00-00 00:00:00',0,'UPDATE twistParameter AS pram',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('permission','Permission','',31,'{\"strSQLTableCode01\":\"twistPermission\"}','twist_package_app_twistPermission','Twist! Permissions','permissions','permission','Permissions','Permission','Permissions','Manages Permissions','','0000-00-00 00:00:00',0,'UPDATE twistPermission AS prmi',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('queryView','QueryView','',32,'{\"strSQLTableCode01\":\"twistQueryView\"}','twist_package_app_twistQueryView','Twist! Query Views','query views','query view','Query Views','Query View','Query Views','Manages Query Views','','0000-00-00 00:00:00',0,'UPDATE twistQueryView AS qvew',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('query','Query','',33,'{\"strSQLTableCode01\":\"twistQuery\"}','twist_package_app_twistQuery','Twist! Queries','queries','query','Queries','Query','Query','Manages Queries','','0000-00-00 00:00:00',0,'UPDATE twistQuery AS qury',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('role','Role','',34,'{\"strSQLTableCode01\":\"twistRole\"}','twist_package_app_twistRole','Twist! Roles','roles','role','Roles','Role','Roles','Manages Roles','','0000-00-00 00:00:00',0,'UPDATE twistRole AS role',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('selectList','SelectList','',35,'{\"strSQLTableCode01\":\"twistSelectList\"}','twist_package_app_twistSelectList','Twist! Select Lists','select lists','select list','Select Lists','Select List','Select Lists','Manages Select Lists','','0000-00-00 00:00:00',0,'UPDATE twistSelectList AS slst',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('sqlTable','SQLTable','',36,'{\"strSQLTableCode01\":\"twistSQLTable\",\"strSQLTableCode02\":\"twistSparkSQLColumn\"}','twist_package_app_twistSQLTable','Twist! SQL Tables','sql tables','sql table','SQL Tables','SQL Table','SQL Tables','Manages SQL Tables','','0000-00-00 00:00:00',0,'UPDATE twistSQLTable AS tabl',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('thing','Thing','',37,'{\"strSQLTableCode01\":\"twistThing\"}','twist_package_app_twistThing','Twist! Things','things','thing','Things','Thing','Things','Manages Things','','0000-00-00 00:00:00',0,'UPDATE twistThing AS thng',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('website','Website','',38,'{\"strSQLTableCode01\":\"twistWebsite\"}','twist_package_app_twistWebsite','Twist! Websites','websites','website','Websites','Website','Websites','Manages Websites','','0000-00-00 00:00:00',0,'UPDATE twistWebsite AS wsit',3,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('venture','Venture','',39,'{\"strSQLTableCode01\":\"twistVenture\"}','twist_package_app_twistVenture','Twist! Ventures','ventures','venture','Ventures','Venture','Ventures','Manages Ventures','','0000-00-00 00:00:00',0,'UPDATE twistVenture AS vntr',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('skill','Skill','',40,'{\"strSQLTableCode01\":\"twistSkill\"}','twist_package_app_twistSkill','Twist! Skills','skills','skill','Skills','Skill','Skills','Manages Skills','','0000-00-00 00:00:00',0,'UPDATE twistSkill AS skil',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('interaction','Interaction','',41,'{\"strSQLTableCode01\":\"twistInteraction\"}','twist_package_app_twistInteraction','Twist! Interactions','interactions','interaction','Interactions','Interaction','Interactions','Manages Interactions','','0000-00-00 00:00:00',0,'UPDATE twistInteraction AS iact',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('place','Place','',42,'{\"strSQLTableCode01\":\"twistPlace\"}','twist_package_app_twistPlace','Twist! Places','places','place','Places','Place','Places','Manages Places','','0000-00-00 00:00:00',0,'UPDATE twistPlace AS plac',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('device','Device','',43,'{\"strSQLTableCode01\":\"twistDevice\"}','twist_package_app_twistDevice','Twist! Devices','device','device','Devices','Device','Devices','Manages Devices','','0000-00-00 00:00:00',0,'UPDATE twistDevice AS dvce',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('channel','Channel','',44,'{\"strSQLTableCode01\":\"twistChannel\"}','twist_package_app_twistChannel','Twist! Channels','channels','channel','Channels','Channel','Channels','Manages Channels','','0000-00-00 00:00:00',0,'UPDATE twistChannel AS chnl',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('ping','Ping','',45,'{\"strSQLTableCode01\":\"twistPing\"}','twist_package_app_twistPing','Twist! Pings','pings','ping','Pings','Ping','Pings','Manages Pings','','0000-00-00 00:00:00',0,'UPDATE twistPing AS ping',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('systemLog','System Log','',46,'{\"strSQLTableCode01\":\"twistSystemLog\"}','twist_package_app_twistSystemLog','Twist! System Log','system log items','system log item','System Log Items','System Log Item','System Log','Manages the System Log','','0000-00-00 00:00:00',0,'UPDATE twistSystemLog AS slog',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('spark','Spark','',132,'{\"strSQLTableCode01\":\"twistSparkEvent\",\"strSQLTableCode01\":\"twistSparkEvent\",\"strSQLTableCode01\":\"twistSparkEvent\",\"strSQLTableCode01\":\"twistSparkEvent\"}','twist_package_app_twistSparkEvent','Twist! Spark','spark','spark','Spark','Spark','Spark','Manages Spark Actions, Events, Rules, and Subscriptions ','','0000-00-00 00:00:00',0,'UPDATE twistSparkEvent AS spev',1,'',0,0,0,'0000-00-00 00:00:00',0),('topic','Topic','',133,'{\"strSQLTableCode01\":\"twistTopic\"}','twist_package_app_twistTopic','Twist! Topics','topics','topic','Topics','Topic','Topics','Manages Topics','','0000-00-00 00:00:00',0,'UPDATE twistTopic AS tpic',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('biometric','Biometric','',50,'{\"strSQLTableCode01\":\"twistBiometric\"}','twist_package_app_twistBiometric','Twist! Biometrics','biometrics','biometric','Biometrics','Biometric','Biometrics','Manages Biometrics','','0000-00-00 00:00:00',0,'UPDATE twistBiometric AS biom',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('demographic','Demographic','',51,'{\"strSQLTableCode01\":\"twistDemographic\"}','twist_package_app_twistDemographic','Twist! Demographics','demographics','demographics','Demographics','Demographic','Demographics','Manages Demographics','','0000-00-00 00:00:00',0,'UPDATE twistDemographic AS dmgr',2,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('emotion','Emotion','',52,'{\"strSQLTableCode01\":\"twistEmotion\"}','twist_package_app_twistEmotion','Twist! Emotions','emotions','emotion','Emotions','Emotion','Emotions','Manages Emotions','','0000-00-00 00:00:00',0,'UPDATE twistEmotion AS emot',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('interactionEvent','InteractionEvent','',53,'{\"strSQLTableCode01\":\"twistInteractionEvent\"}','twist_package_app_twistInteractionEvent','Twist! Interaction Events','interaction events','interaction event','Interaction Events','Interaction Event','Int. Events','Manages Events','','0000-00-00 00:00:00',0,'UPDATE twistInteractionEvent AS iaev',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('interactionGoal','InteractionGoal','',54,'{\"strSQLTableCode01\":\"twistInteractionGoal\"}','twist_package_app_twistInteractionGoal','Twist! Interaction Goals','interaction goals','interaction goal','Interaction Goals','Interaction Goal','Int. Goals','Manages Goals','','0000-00-00 00:00:00',0,'UPDATE twistInteractionGoal AS iago',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('interactionLocation','InteractionLocation','',55,'{\"strSQLTableCode01\":\"twistInteractionLocation\"}','twist_package_app_twistInteractionLocation','Twist! Interaction Locations','interaction locations','interaction location','Interaction Location','Interaction Location','Int. Locations','Manages Locations','','0000-00-00 00:00:00',0,'UPDATE twistInteractionLocation AS ialo',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('psychographic','Psychographic','',56,'{\"strSQLTableCode01\":\"twistPsychographic\"}','twist_package_app_twistPsychographic','Twist! Psychographics','psychographics','psychographic','Psychographics','Psychographic','Psychographics','Manages Psychographics','','0000-00-00 00:00:00',0,'UPDATE twistPsychographic AS psgr',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('interactionRule','InteractionRule','',57,'{\"strSQLTableCode01\":\"twistInteractionRule\"}','twist_package_app_twistInteractionRule','Twist! Interaction Rules','interaction rules','interaction rule','Interaction Rules','Interaction Rule','Int. Rules','Manages Interaction Rules','','0000-00-00 00:00:00',0,'UPDATE twistInteractionRule AS iaru',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('group','Group','',136,'{\"strSQLTableCode01\":\"twistGroup\",\"strSQLTableCode02\":\"twistGroupMember\"}','twist_package_app_twistGroup','Twist! Groups','groups','group','Groups','Group','Groups','Manages Groups','','0000-00-00 00:00:00',0,'UPDATE twistGroup AS grup',1,'',0,0,0,'0000-00-00 00:00:00',0),('interactionState','InteractionState','',59,'{\"strSQLTableCode01\":\"twistInteractionState\"}','twist_package_app_twistInteractionState','Twist! Interaction States','interaction states','interaction state','Interaction States','Interaction State','Int. States','Manages Interaction State','','0000-00-00 00:00:00',0,'UPDATE twistInteractionState AS iast',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('interactionSituation','InteractionSituation','',130,'{\"strSQLTableCode01\":\"twistInteractionSituation\"}','twist_package_app_twistInteractionSituation','Twist! Interaction Situations','interaction situations','interaction situation','Interaction Situation','Interaction Situation','Int. Situation','Manages Interaction Situations','','0000-00-00 00:00:00',0,'UPDATE twistInteractionSituation AS iasi',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('interactionVocabulary','InteractionVocabulary','',61,'{\"strSQLTableCode01\":\"twistInteractionVocabulary\"}','twist_package_app_twistInteractionVocabulary','Twist! Interaction Vocabulary','interaction vocabulary','interaction vocabulary','Interaction Vocabularies','Interaction Vocabulary','Int. Vocabulary','Manages Interaction Vocabulary','','0000-00-00 00:00:00',0,'UPDATE twistInteractionRule AS iaru',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('interactionRuleSet','InteractionRuleSet','',62,'{\"strSQLTableCode01\":\"twistInteractionRuleSet\"}','twist_package_app_twistInteractionRuleSet','Twist! Interaction Rules','interaction rule sets','interaction rule set','Interaction Rule Sets','Interaction Rule Set','Int. Rule Sets','Manages Interaction Rule Sets','','0000-00-00 00:00:00',0,'UPDATE twistInteractionRuleSet AS iars',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('member','Member','',64,'{\"strSQLTableCode01\":\"twistMember\",\"strSQLTableCode02\":\"twistPerson\"}','twist_package_app_twistMember','Twist! Members','members','member','Members','Member','Members','Manages Members','','0000-00-00 00:00:00',0,'UPDATE twistMember AS mebr JOIN twistPerson AS prsn ON mebr.personID = prsn.personID',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('post','Post','',65,'{\"strSQLTableCode01\":\"twistPost\"}','twist_package_app_twistPost','Twist! Posts','posts','post','Posts','Post','Posts','Manages Posts','','0000-00-00 00:00:00',0,'UPDATE twistPost AS post',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('installation','Installation','',66,'{\"strSQLTableCode01\":\"twistInstallation\"}','twist_package_app_twistInstallation','Twist! Installations','installations','installation','Installations','Installation','Installations','Manages Installations','','0000-00-00 00:00:00',0,'UPDATE twistInstallation AS nstl',2,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('newsletter','Newsletter','',73,'{\"strSQLTableCode01\":\"twistNewsletter\"}','twist_package_app_twistNewsletter','Twist! Newsletters','newsletters','newsletter','Newsletters','','Newsletters','Manages Newsletters','','0000-00-00 00:00:00',0,'UPDATE twistNewsletter AS nltr',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('testimonial','Testimonial','',71,'{\"strSQLTableCode01\":\"twistTestimonial\"}','twist_package_app_twistTestimonial','Twist! Testimonial','testimonials','testimonial','Testimonials','','Testimonial','Manages Testimonials','','0000-00-00 00:00:00',0,'UPDATE twistTestimonial AS temo',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('caseStudy','CaseStudy','',75,'{\"strSQLTableCode01\":\"twistCaseStudy\"}','twist_package_app_twistCaseStudy','Twist! Case Studies','case studies','case study','Case Studies','Case Study','Case Studies','Manages Case Studies','','0000-00-00 00:00:00',0,'UPDATE twistCaseStudy AS csty',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('workflow','Workflow','',76,'{\"strSQLTableCode01\":\"twistWorkflow\"}','twist_package_app_twistWorkflow','Twist! Workflow','workflows','workflow','Workflows','','Workflows','Manages Workflows','','0000-00-00 00:00:00',0,'UPDATE twistWorkflow AS wkfl',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('taskTemplate','TaskTemplate','',78,'{\"strSQLTableCode01\":\"twistTaskTemplate\",\"strSQLTableCode02\":\"twistTaskTemplateTask\"}','twist_package_app_twistTaskTemplate','Twist! Task Template','task templates','task templates','Task Templates','','Task Templates','Manages Task Templates','','0000-00-00 00:00:00',0,'UPDATE twistTaskTemplate AS tktm',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('bot','Bot','',80,'{\"strSQLTableCode01\":\"twistBot\"}','twist_package_app_twistBot','Twist! Bots','bots','bot','Bots','Bot','Bots','Manages Bots','','0000-00-00 00:00:00',0,'UPDATE twistBot AS tbot',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('memberGroup','MemberGroup','',81,'{\"strSQLTableCode01\":\"twistMemberGroup\"}','twist_package_app_twistMemberGroup','Twist! Member Groups','member groups','member group','Member Groups','Member Group','Member Groups','Manages Member Groups','','0000-00-00 00:00:00',0,'UPDATE twistMemberGroup AS mbrg',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('schedule','Schedule','',82,'{\"strSQLTableCode01\":\"twistSchedule\"}','twist_package_app_twistSchedule','Twist! Schedules','schedules','schedule','Schedules','Schedule','Schedules','Manages Schedules','','0000-00-00 00:00:00',0,'UPDATE twistSchedule AS schd',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('journal','Journal','',92,'{\"strSQLTableCode01\":\"twistJournal\"}','twist_package_app_twistJournal','Twist! Journal','journals','journal','Journals','Journal','Journals','Manages Journal Entries','','0000-00-00 00:00:00',0,'UPDATE twistJournal AS jrnl',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('policy','Policy','',83,'{\"strSQLTableCode01\":\"twistPolicy\"}','twist_package_app_twistPolicy','Twist! Policies','policies','policy','Policies','Policy','Policies','Manages Organizations Policies','','0000-00-00 00:00:00',0,'UPDATE twistPolicy AS plcy',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('procedure','Procedure','',84,'{\"strSQLTableCode01\":\"twistProcedure\"}','twist_package_app_twistProcedure','Twist! Procedures','procedures','procedure','Procedures','Procedure','Procedures','Manages Organizational Procedures and provides an ability to document each procedure with:','','0000-00-00 00:00:00',0,'UPDATE twistProcedure AS prcd',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('metric','Metric','',131,'{\"strSQLTableCode01\":\"twistNewsletter\"}','twist_package_app_twistMetric','Twist! Metrics','metrics','metric','Metrics','Metric','Metrics','Manages Metrics','','0000-00-00 00:00:00',0,'UPDATE twistMetric AS mtrc',1,'',0,0,0,'0000-00-00 00:00:00',0),('introduction','Introduction','',86,'{\"strSQLTableCode01\":\"twistIntroduction\"}','twist_package_app_twistIntroduction','Twist! Introductions','introductions','introduction','Introductions','Introduction','Introduction','Manages Introductions','','0000-00-00 00:00:00',0,'UPDATE twistIntroduction AS intr',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('dataSubscription','DataSubscription','',87,'{\"strSQLTableCode01\":\"twistDataSubscription\"}','twist_package_app_twistDataSubscription','Twist! Data Subscriptions','data subscriptions','data subscription','Data Subscriptions','Data Subscription','Data Subscrip.','Manages Data Subscriptions','','0000-00-00 00:00:00',0,'UPDATE twistDataSubscription AS dasu',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('report','Report','',88,'{\"strSQLTableCode01\":\"twistReport\"}','twist_package_app_twistReport','Twist! Reports','reports','report','Reports','Report','Report','Manages Reports','','0000-00-00 00:00:00',0,'UPDATE twistReport AS rept',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('tag','Tag','',89,'{\"strSQLTableCode01\":\"twistTag\"}','twist_package_app_twistTag','Twist! Tags','tags','tag','Tags','Tag','Tags','Allows for the tagging and reporting on most every item in Twist!','','0000-00-00 00:00:00',0,'UPDATE twistTag AS ttag',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('city','City','',91,'{\"strSQLTableCode01\":\"twistCity\"}','twist_package_app_twistCity','Twist! City','cities','city','Cities','City','Cities','Manages a list of cities. Can be populated by a Twist! Data subscription','','0000-00-00 00:00:00',0,'UPDATE twistTag AS city',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('usState','USState','',93,'{\"strSQLTableCode01\":\"usState\"}','twist_package_app_twistUSState','Twist! US States','US states','state','US States','US State','US States','Manages a List of U.S. States','','0000-00-00 00:00:00',0,'UPDATE twistUSState AS usst',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('security','Security','',95,'{}','twist_package_app_twistSecurity','Twist! Security','security','security','Security','Security','Security','Security best practices and management','','0000-00-00 00:00:00',0,'UPDATE twistSecurity AS secu',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('workout','Workout','',117,'{\"strSQLTableCode01\":\"twistWorkout\"}','twist_package_app_twistWorkout','Twist! Workouts','workouts','workout','Workouts','Workout','Workouts','Manages Workout History','','0000-00-00 00:00:00',0,'UPDATE twistWorkout AS wkou',1,'',0,0,0,'0000-00-00 00:00:00',0),('stockKeepingUnit','StockKeepingUnit','',116,'{\"strSQLTableCode01\":\"twistStockKeepingUnit\"}','twist_package_app_twistStockKeepingUnit','Twist! Stock Keeping Units','stock keeping units','stock keeping unit','Stock Keeping Units','Stock Keeping Unit','SKU\'s','Manages stock keeping units (SKU\'s)','','0000-00-00 00:00:00',0,'UPDATE twistStockKeepingUnit AS stku',1,'',0,0,0,'0000-00-00 00:00:00',0),('salesOrder','SalesOrder','',115,'{\"strSQLTableCode01\":\"twistSalesOrder\"}','twist_package_app_twistSalesOrder','Twist! Sales Order','sales orders','sales order','Sales Orders','Sales Order','Sales Orders','Manages Sales Orders','','0000-00-00 00:00:00',0,'UPDATE twistSalesOrder AS saor',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('salesCommission','SalesCommission','',114,'{\"strSQLTableCode01\":\"twistSalesCommission\"}','twist_package_app_twistSalesCommission','Twist! Sales Commission','sales commissions','sales commission','Sales Commissions','Sales Commission','Sales Commissions','Manages Sales Commissions','','0000-00-00 00:00:00',0,'UPDATE twistSalesCommission AS saco',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('interactionParty','InteractionParty','',96,'{\"strSQLTableCode01\":\"twistInteractionParty\"}','twist_package_app_twistInteractionParty','Twist! Interaction Parties','interaction parties','interaction party','Interaction Parties','Interaction Party','Int. Parties','Manages Interaction Parties','','0000-00-00 00:00:00',0,'UPDATE twistInteractionParty AS iapa',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('serviceRequest','ServiceRequest','',97,'{\"strSQLTableCode01\":\"twistServiceRequest\"}','twist_package_app_twistServiceRequest','Twist! Services Requests','service requests','service request','Service Requests','Service Request','Service Req.','Manages Service Requests','','0000-00-00 00:00:00',0,'UPDATE twistServiceRequest AS svrq',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('messageTemplate','MessageTemplate','',98,'{\"strSQLTableCode01\":\"twistMessageTemplate\"}','twist_package_app_twistMessageTemplate','Twist! Message Templates','message templates','message template','Message Templates','Message Template','Msg. Templates','Manages Message Templates','','0000-00-00 00:00:00',0,'UPDATE twistMessageTemplate AS mstm',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('chapter','Chapter','',101,'{\"strSQLTableCode01\":\"twistChapter\"}','twist_package_app_twistChapter','Twist! Chapters','chapters','chapter','Chapters','Chapter','Chapters','Manages Group Chapters','','0000-00-00 00:00:00',0,'UPDATE twistChapter AS chpt',1,'',0,0,0,'0000-00-00 00:00:00',0),('messageJob','MessageJob','',99,'{\"strSQLTableCode01\":\"twistMessageJob\"}','twist_package_app_twistMessageJob','Twist! Message Job','message jobs','message job','Message Jobs','Message Job','Message Jobs','Manages Message Jobs','','0000-00-00 00:00:00',0,'UPDATE twistMessageJob AS msjb',1,' \nV1.00',0,0,0,'0000-00-00 00:00:00',0),('messageQueue','MessageQueue','',100,'{\"strSQLTableCode01\":\"twistMessageQueue\"}','twist_package_app_twistMessageQueue','Twist! Message Queue','message queue','message queue','Message Queue','Message Queue','Message Queue','Manages the Message Queue','','0000-00-00 00:00:00',0,'UPDATE twistMessageQueue AS msqu',1,' \nV1.00',0,0,0,'0000-00-00 00:00:00',0),('colorPalette','ColorPalette','',102,'{\"strSQLTableCode01\":\"twistColorPalette\"}','twist_package_app_twistColorPalette','Twist! Color Palettes','palettes','palette','palettes','Palette','Palettes','Manages color palettes','','0000-00-00 00:00:00',0,'UPDATE twistColorPalette AS copa',1,'',0,0,0,'0000-00-00 00:00:00',0),('contest','Contest','',103,'{\"strSQLTableCode01\":\"twistContest\"}','twist_package_app_twistContest','Twist! Contests','contests','contest','contests','Contest','Contests','Manages contests','','0000-00-00 00:00:00',0,'UPDATE twistContest AS ctst',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('ipMark','IPMark','',104,'{\"strSQLTableCode01\":\"twistIPMark\"}','twist_package_app_twistIPMark','Twist! IPMarks','ip/marks','ip/mark','IP/Marks','IP/Mark','IP / Marks','Manages Intellectual Property and Marks','','0000-00-00 00:00:00',0,'UPDATE twistIPMark AS ipmk',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('idea','Idea','',105,'{\"strSQLTableCode01\":\"twistIdea\"}','twist_package_app_twistIdea','Twist! Ideas','ideas','idea','Ideas','Idea','Ideas','Manages Ideas','','0000-00-00 00:00:00',0,'UPDATE twistIdea AS idea',1,'',0,0,0,'0000-00-00 00:00:00',0),('patent','Patent','',106,'{\"strSQLTableCode01\":\"twistPatent\"}','twist_package_app_twistPatent','Twist! Patents','patents','patent','Patents','Patent','Patents','Manages Patents','','0000-00-00 00:00:00',0,'UPDATE twistPatent AS ptnt',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('prediction','Prediction','',107,'{\"strSQLTableCode01\":\"twistPrediction\"}','twist_package_app_twistPrediction','Twist! Predictions','predictions','prediction','Predictions','Prediction','Predictions','Manages Predictions','','0000-00-00 00:00:00',0,'UPDATE twistPrediction AS prdc',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('publication','Publication','',108,'{\"strSQLTableCode01\":\"twistPublication\"}','twist_package_app_twistPublication','Twist! Publications','publications','publication','Publications','Publication','Publications','Manages Publications','','0000-00-00 00:00:00',0,'UPDATE twistPublication AS pblc',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('survey','Survey','',109,'{\"strSQLTableCode01\":\"twistSurvey\"}','twist_package_app_twistSurvey','Twist! Surveys','surveys','survey','Surveys','Survey','Surveys','Manages Surveys','','0000-00-00 00:00:00',0,'UPDATE twistSurvey AS svey',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('trend','Trend','',110,'{\"strSQLTableCode01\":\"twistTrend\"}','twist_package_app_twistTrend','Twist! Trends','trends','trend','Trends','Trend','Trends','Manages Trends','','0000-00-00 00:00:00',0,'UPDATE twistTrend AS trnd',1,'',0,0,0,'0000-00-00 00:00:00',0),('continent','Continent','',111,'{\"strSQLTableCode01\":\"twistContinent\"}','twist_package_app_twistContinent','Twist! Continents','continents','continent','Continents','Continent','Continents','Manages Continents','','0000-00-00 00:00:00',0,'UPDATE twistContinent AS ctnt',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('core','Core','',112,'{\"strSQLTableCode01\":\"twistCore\"}','twist_package_app_twistCore','Twist! Core','core','core','Core','Core','Core','Manages Core Apps','','0000-00-00 00:00:00',0,'',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('invoice','Invoice','',113,'{\"strSQLTableCode01\":\"twistInvoice\"}','twist_package_app_twistInvoice','Twist! Invoice','invoices','invoice','Invoices','Invoice','Invoices','Manages Invoices','','0000-00-00 00:00:00',0,'UPDATE twistInvoice AS invc',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('answer','Answer','',123,'{\"strSQLTableCode01\":\"twistAnswer\"}','twist_package_app_twistAnswer','Twist! Answers','answers','answer','answers','Answer','Answers','Manages Answers','','0000-00-00 00:00:00',0,'UPDATE twistAnswer AS ansr',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('retailCenter','RetailCenter','',121,'{\"strSQLTableCode01\":\"twistRetailCenter\"}','twist_package_app_twistRetailCenter','Twist! Retail Centers','retail centers','retail center','Retail Centers','Retail Center','Ret. Centers','Manages Retail Centers','','0000-00-00 00:00:00',0,'UPDATE twistRetailCenter AS rtce',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('preference','Preference','',120,'{\"strSQLTableCode01\":\"twistPreference\"}','twist_package_app_twistPreference','Twist! Preferences','preferences','preference','Preferences','Preference','Preferences','Manages personal preferences','','0000-00-00 00:00:00',0,'UPDATE twistPreference AS pref',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('interactionResponse','InteractionResponse','',129,'{\"strSQLTableCode01\":\"twistInteractionResponse\"}','twist_package_app_twistInteractionResponse','Twist! Interaction Responses','interaction responses','interaction response','Interaction Responses','Interaction Response','Int. Responses','Manages Interaction Responses','','0000-00-00 00:00:00',0,'UPDATE twistInteractionParty AS iare',1,'',0,0,0,'0000-00-00 00:00:00',0),('workflowDesign','WorkflowDesign','',134,'{\"strSQLTableCode01\":\"twistWorkflow\"}','twist_package_app_twistWorkflowDesign','Twist! Workflow Design','workflow designs','workflow design',' \nWorkflow Designs','Workflow Design','Workflow Des.','Designs Workflows','','0000-00-00 00:00:00',0,'UPDATE twistWorkflow AS wkfl',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('residentialTenant','ResidentialTenant','',122,'{\"strSQLTableCode01\":\"twistResidentialTenant\"}','twist_package_app_twistReidentialTenant','Twist! Residential Tenants','residential tenants','residential tenant','Residential Tenants','Residential Tenant','Resid. Tenants','Manages Residential Tenants','','0000-00-00 00:00:00',0,'UPDATE twistResidentialTenant AS rtnt',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('asset','Asset','',124,'{\"strSQLTableCode01\":\"twistAsset\"}','twist_package_app_twistAsset','Twist! Assets','assets','asset','Assets','Asset','Assets','Manages Assets','','0000-00-00 00:00:00',0,'UPDATE twistAsset AS aset',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('fact','Fact','',125,'{\"strSQLTableCode01\":\"twistFact\"}','twist_package_app_twistFact','Twist! Facts','facts','fact','Facts','Fact','Facts','Manages Facts','','0000-00-00 00:00:00',0,'UPDATE twistFact AS fact',1,'',0,0,0,'0000-00-00 00:00:00',0),('lead','Lead','',126,'{\"strSQLTableCode01\":\"twistLead\"}','twist_package_app_twistLead','Twist! Leads','leads','lead','Leads','Lead','Twist! Leads','Manages Sales Leads','','0000-00-00 00:00:00',0,'UPDATE twistLead AS lead',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('observation','Observation','',128,'{\"strSQLTableCode01\":\"twistObservation\"}','twist_package_app_twistObservations','Twist! Observations','observations','observation','Observations','Observation','Observations','Manages Observations','','0000-00-00 00:00:00',0,'UPDATE twistObservation AS obsv',1,'',0,0,0,'0000-00-00 00:00:00',0),('integration','Integration','',137,'{\"strSQLTableCode01\":\"twistIntegration\"}','twist_package_app_twistIntegration','Twist! Integration','integrations','integration','Integrations','Integration','Integrations','Manages Integrations','','0000-00-00 00:00:00',0,'UPDATE twistIntegration AS nteg',1,'',0,0,0,'0000-00-00 00:00:00',0),('sparkEvent','SparkEvent','',138,'{\"strSQLTableCode01\":\"twistSparkEvent\"}','twist_package_app_twistSparkEvent','Twist! Spark Events','spark events','spark event','Spark Events','Spark Event','Spark Events','Manages Spark Events','','0000-00-00 00:00:00',0,'UPDATE twistSparkEvent AS spev',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('sparkSubscription','SparkSubscription','',139,'{\"strSQLTableCode01\":\"twistSparkSubscription\"}','twist_package_app_twistSparkSubscription','Twist! Spark Subscriptions','spark subscriptions','spark subscription','Spark Subscriptions','Spark Subscription','Spark Subscriptions','Manage Spark Subscriptions','','0000-00-00 00:00:00',0,'UPDATE twistSparkSubscription AS spsu',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('sparkAction','SparkAction','',140,'{\"strSQLTableCode01\":\"twistSparkAction\"}','twist_package_app_twistSparkAction','Twist! Spark Actions','spark actions','spark action','Spark Actions','Spark Action','Spark Actions','Manage Spark Actions','','0000-00-00 00:00:00',0,'UPDATE twistSparkAction AS spac',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('sparkRule','SparkRule','',141,'{\"strSQLTableCode01\":\"twistSparkRule\"}','twist_package_app_twistSparkRule','Twist! Spark Rules\n','spark rules','spark rule','Spark Rules','Spark Rule','Spark Rules','Manage Spark Rules','','0000-00-00 00:00:00',0,'UPDATE twistSparkRule AS spru',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('elevator','Elevator','',142,'{\"strSQLTableCode01\":\"twistElevator\"}','twist_package_app_twistElevator','Twist! Elevator','elevators','elevator','Elevators','Elevator','Elevators','Manages Elevators','','0000-00-00 00:00:00',0,'UPDATE twistElevator AS lvtr',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('importContact','ImportContact','',156,'{\"strSQLTableCode01\":\"twistImportContact\"}','twist_package_app_twistImportContact','Twist! Import Contacts','import contacts','import contact','Import Contacts','Import Contact','Imp. Contacts','Manages Imported Contacts','','0000-00-00 00:00:00',0,'UPDATE twistImportContact AS imco',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('webSection','WebSection','',144,'{\"strSQLTableCode01\":\"twistWebSection\"}','twist_package_app_twistWebSection','Twist! Web Sections','web sections','web section','Web Sections','Web Section','Web Sections','Manages Web Sections','','0000-00-00 00:00:00',0,'UPDATE twistWebSection AS wbsc',3,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('webSession','WebSession','',145,'{\"strSQLTableCode01\":\"twistWebSession\"}','twist_package_app_twistWebSession','Twist! Web Sessions','web sessions','web session','Web Sessions','Web Session','Web Sessions','Manages Web Sessions','','0000-00-00 00:00:00',0,'UPDATE twistWebSession AS wbsn',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('webTemplate','WebTemplate','',146,'{\"strSQLTableCode01\":\"twistWebTemplate\"}','twist_package_app_twistWebTemplate','Twist! Web Templates','web templates','web template','Web Templates','Web Template','Web Templates','Manages Web Templates','','0000-00-00 00:00:00',0,'UPDATE twistWebTemplate AS wtmp',3,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('websiteSection','WebsiteSection','',147,'{\"strSQLTableCode01\":\"twistWebsiteSection\"}','twist_package_app_twistWebsiteSection','Twist! Website Sections','website section','website section','Website Sections','Website Section','Website Sect.','Manages Website Sections','','0000-00-00 00:00:00',0,'UPDATE twistWebsiteSection AS wssc',5,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('messageSignature','MessageSignature','',148,'{\"strSQLTableCode01\":\"twistMessageSignature\"}','twist_package_app_twistMessageSignature','Twist! Message Signatures','message signatures','message signature','Message Signatures','Message Signature','Msg. Signatures','Manages Message Signatures','','0000-00-00 00:00:00',0,'UPDATE twistMessageSignature AS mssg',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('messageAccount','MessageAccount','',149,'{\"strSQLTableCode01\":\"twistMessageAccount\"}','twist_package_app_twistMessageAccount','Twist! Message Accounts','message accounts','messsage account','Message Accounts','Message Account','Msg. Accounts','Manages Message Accounts','','0000-00-00 00:00:00',0,'UPDATE twistMessageAccount AS msac',2,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('webPage','WebPage','',150,'{\"strSQLTableCode01\":\"twistWebPage\"}','twist_package_app_twistWebPage','Twist! Web Pages','web pages','web page','Web Pages','Web Page','Web Pages','Manages Web Pages','','0000-00-00 00:00:00',0,'UPDATE twistWebPage AS wpag',3,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('situation','Situation','',153,'{\"strSQLTableCode01\":\"twistSituation\"}','twist_package_app_twistSituation','Twist! Situations','situations','situation','Situations','Situation','Situations','Manages Situations','','0000-00-00 00:00:00',0,'UPDATE twistSituation AS situ',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('campaign','Campaign','',151,'{\"strSQLTableCode01\":\"twistCampaign\"}','twist_package_app_twistCampaign','Twist! Campaigns','campaigns','campaign','Campaigns','Campaign','Campaigns','Manage Spark Campaigns','','0000-00-00 00:00:00',0,'',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('translation','Translation','',155,'{\"strSQLTableCode01\":\"twistTranslation\"}','twist_package_app_twistTranslation','Twist! Translations','translations','translation','Translations','Translation','Translations','Manages Translations','','0000-00-00 00:00:00',0,'UPDATE twistTranslation AS tltn',1,'',0,0,0,'0000-00-00 00:00:00',0),('deadline','Deadline','',154,'{\"strSQLTableCode01\":\"twistDeadline\"}','twist_package_app_twistDeadline','Twist! Deadlines','deadlines','deadline','Deadlines','Deadline','Deadlines','Manages Deadlines','','0000-00-00 00:00:00',0,'UPDATE twistDeadline AS dedl',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('service','Service','',157,'{\"strSQLTableCode01\":\"twistService\"}','twist_package_app_twistService','Twist! Services','services','service','Services','Service','Services','Manage Services for Sale','','0000-00-00 00:00:00',0,'UPDATE twistService AS svce',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('webSectionType','WebSectionType','',158,'{\"strSQLTableCode01\":\"twistWebSectionType\"}','twist_package_app_twistWebSectionType','Twist! Web Section Types','web section types','web section type','Web Section Types','Web Section Type','Web Sec. Types','Manages Web Section Types','','0000-00-00 00:00:00',0,'UPDATE twistWebSectionType AS wsty',2,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('userInterface','UserInterface','',159,'{\"strSQLTableCode01\":\"twistUserInterface\"}','twist_package_app_twistUserInterface','Twist! User Interfaces','user interfaces','user interface','User Interfaces','User Interface','User Interf.','Manages Twist User Interfaces','','0000-00-00 00:00:00',0,'UPDATE twistUserInterface AS usin',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0),('need','Need','',160,'{\"strSQLTableCode01\":\"twistNeed\"}','twist_package_app_twistNeed','Twist! Needs','needs','need','Needs','Need','Needs','Manages Needs','','0000-00-00 00:00:00',0,'UPDATE twistNeed AS need',1,'V1.00',0,0,0,'0000-00-00 00:00:00',0); /*!40000 ALTER TABLE `masterApp` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `masterDataManager` -- DROP TABLE IF EXISTS `masterDataManager`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `masterDataManager` ( `actionBar` tinyint(1) NOT NULL DEFAULT '0', `actionBarBookmark` tinyint(1) NOT NULL DEFAULT '0', `actionBarBookmarkEntityRequest` varchar(100) NOT NULL, `actionBarCall` tinyint(1) NOT NULL DEFAULT '0', `actionBarCallEntityRequest` varchar(100) NOT NULL, `actionBarDelete` tinyint(1) NOT NULL DEFAULT '0', `actionBarDeleteEntityRequest` varchar(100) NOT NULL, `actionBarHelp` tinyint(1) NOT NULL DEFAULT '0', `actionBarHelpEntityRequest` varchar(100) NOT NULL, `actionBarLinkAdd` tinyint(1) NOT NULL DEFAULT '0', `actionBarLinkAddEntityRequest` varchar(100) NOT NULL, `actionBarLinkShow` tinyint(1) NOT NULL DEFAULT '0', `actionBarLinkShowEntityRequest` varchar(100) NOT NULL, `actionBarMessage` tinyint(1) NOT NULL DEFAULT '0', `actionBarMessageEntityRequest` varchar(100) NOT NULL, `actionBarNote` tinyint(1) NOT NULL DEFAULT '0', `actionBarNoteEntityRequest` varchar(100) NOT NULL, `actionBarReport` tinyint(1) NOT NULL DEFAULT '0', `actionBarReportEntityRequest` varchar(100) NOT NULL, `actionBarRow` tinyint(1) NOT NULL DEFAULT '0', `actionBarRowEntityRequest` varchar(100) NOT NULL, `actionBarRowFirst` tinyint(1) NOT NULL DEFAULT '0', `actionBarRowFirstEntityRequest` varchar(100) NOT NULL, `actionBarRowLast` tinyint(1) NOT NULL DEFAULT '0', `actionBarRowLastEntityRequest` varchar(100) NOT NULL, `actionBarRowNext` tinyint(1) NOT NULL DEFAULT '0', `actionBarRowNextEntityRequest` varchar(100) NOT NULL, `actionBarRowPrevious` tinyint(1) NOT NULL DEFAULT '0', `actionBarRowPreviousEntityRequest` varchar(100) NOT NULL, `actionBarSourceFileLocal` tinyint(1) NOT NULL DEFAULT '0', `actionBarSourceFileName` varchar(100) NOT NULL, `actionBarSourceFilePath` varchar(200) NOT NULL, `actionBarSourceLocal` tinyint(1) NOT NULL DEFAULT '0', `actionBarWorkflow` tinyint(1) NOT NULL DEFAULT '0', `actionBarWorkflowEntityRequest` varchar(100) NOT NULL, `appCode` varchar(100) NOT NULL, `contentAreaSourceFileLocal` tinyint(1) NOT NULL DEFAULT '0', `contentAreaSourceFileName` varchar(100) NOT NULL, `contentAreaSourceFilePath` varchar(200) NOT NULL, `contentAreaSourceLocal` tinyint(1) NOT NULL DEFAULT '0', `dataManagerCode` varchar(100) NOT NULL, `dataManagerID` int(11) NOT NULL AUTO_INCREMENT, `dataManagerName` varchar(100) NOT NULL, `dataManagerNamePublic` varchar(100) NOT NULL, `dataManagerOptionCodeDefault` varchar(100) NOT NULL, `dataManagerOverview` varchar(1000) NOT NULL, `dataManagerQueryCodeDefault` varchar(100) NOT NULL, `dataManagerShowLinks` tinyint(1) NOT NULL DEFAULT '0', `dataManagerUpdateSourceCode` varchar(4000) NOT NULL, `dataManagerUpdateSourceFileLocal` tinyint(1) NOT NULL DEFAULT '0', `dataManagerUpdateSourceCustom` tinyint(1) NOT NULL DEFAULT '0', `dataManagerUpdateSourceFileName` varchar(100) NOT NULL, `dataManagerUpdateSourceFilePath` varchar(200) NOT NULL, `dataManagerWebTemplateCode` varchar(100) NOT NULL, `deletedCondition` varchar(200) NOT NULL, `footerSection` tinyint(1) NOT NULL DEFAULT '0', `footerSectionSourceFileLocal` tinyint(1) NOT NULL DEFAULT '0', `footerSectionSourceFileName` varchar(100) NOT NULL, `footerSectionSourceFilePath` varchar(200) NOT NULL, `footerSectionSourceLocal` tinyint(1) NOT NULL DEFAULT '0', `headerSection` tinyint(1) NOT NULL DEFAULT '0', `headerSectionSourceFileLocal` tinyint(1) NOT NULL DEFAULT '0', `headerSectionSourceFileName` varchar(100) NOT NULL, `headerSectionSourceFilePath` varchar(200) NOT NULL, `headerSectionSourceLocal` tinyint(1) NOT NULL DEFAULT '0', `queryCode` varchar(100) NOT NULL, `tabMenu` tinyint(1) NOT NULL DEFAULT '0', `tabMenuSourceFileLocal` tinyint(1) NOT NULL DEFAULT '0', `tabMenuSourceFileName` varchar(100) NOT NULL, `tabMenuSourceFilePath` varchar(200) NOT NULL, `tabMenuSourceLocal` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`dataManagerID`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `masterDataManager` -- LOCK TABLES `masterDataManager` WRITE; /*!40000 ALTER TABLE `masterDataManager` DISABLE KEYS */; INSERT INTO `masterDataManager` VALUES (1,0,'',0,'',1,'',0,'',1,'linkInsertGlobalForm',0,'',0,'',0,'',0,'',1,'',1,'',1,'',1,'',1,'',0,'','',0,0,'','address',0,'','',0,'addressDataManager',1,'Address Data Manager','Address Data Manager','addressOverview','','',1,'',0,0,'','','','',1,0,'','',0,0,0,'','',0,'addressDataManager',1,0,'','',0); /*!40000 ALTER TABLE `masterDataManager` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `masterDataManagerOption` -- DROP TABLE IF EXISTS `masterDataManagerOption`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `masterDataManagerOption` ( `actionBarSourceFileName` varchar(100) NOT NULL, `actionBarSourceFilePath` varchar(200) NOT NULL, `actionBarSourceLocal` tinyint(1) NOT NULL DEFAULT '0', `contentAreaSourceFileName` varchar(100) NOT NULL, `contentAreaSourceFilePath` varchar(200) NOT NULL, `contentAreaSourceLocal` tinyint(1) NOT NULL DEFAULT '0', `dataManagerCode` varchar(100) NOT NULL, `dataManagerOptionCode` varchar(100) NOT NULL, `dataManagerOptionCustom` tinyint(1) NOT NULL DEFAULT '0', `dataManagerOptionFormSelectSourceFileLocal` tinyint(1) NOT NULL DEFAULT '0', `dataManagerOptionFormSelectSourceFileName` varchar(100) NOT NULL, `dataManagerOptionFormSelectSourceFilePath` varchar(200) NOT NULL, `dataManagerOptionID` int(11) NOT NULL AUTO_INCREMENT, `dataManagerOptionName` varchar(100) NOT NULL, `dataManagerOptionNamePublic` varchar(100) NOT NULL, `dataManagerOptionOverview` varchar(1000) NOT NULL, `dataManagerOptionSourceFileName` varchar(100) NOT NULL, `dataManagerOptionSourceFilePath` varchar(200) NOT NULL, `dataManagerOptionSourceLocal` tinyint(1) NOT NULL DEFAULT '0', `entityRequestCode` varchar(100) NOT NULL, `footerSectionSourceFileName` varchar(100) NOT NULL, `footerSectionSourceFilePath` varchar(200) NOT NULL, `footerSectionSourceLocal` tinyint(1) NOT NULL DEFAULT '0', `headerSectionSourceFileName` varchar(100) NOT NULL, `headerSectionSourceFilePath` varchar(200) NOT NULL, `headerSectionSourceLocal` tinyint(1) NOT NULL DEFAULT '0', `sqlUpdatePrefix` varchar(1000) NOT NULL, `tabMenuSourceFileName` varchar(100) NOT NULL, `tabMenuSourceFilePath` varchar(200) NOT NULL, `tabMenuSourceLocal` tinyint(1) NOT NULL DEFAULT '0', `webTemplateCode` varchar(100) NOT NULL, PRIMARY KEY (`dataManagerOptionID`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `masterDataManagerOption` -- LOCK TABLES `masterDataManagerOption` WRITE; /*!40000 ALTER TABLE `masterDataManagerOption` DISABLE KEYS */; INSERT INTO `masterDataManagerOption` VALUES ('','',0,'','',0,'addressDataManager','addressOverview',0,0,'dataManagerOptionOverviewFormSelect.php','portal|default|address|',1,'Address Overview','Overview','','','',0,'addressOverview','','',0,'','',0,'UPDATE twistAddress AS addr SET','','',0,''); /*!40000 ALTER TABLE `masterDataManagerOption` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `masterDataManagerSection` -- DROP TABLE IF EXISTS `masterDataManagerSection`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `masterDataManagerSection` ( `cssClass` varchar(100) NOT NULL, `cssClassSection` varchar(100) NOT NULL, `cssClassSectionContent` varchar(100) NOT NULL, `cssStyle` varchar(500) NOT NULL, `cssStyleSection` varchar(500) NOT NULL, `cssStyleSectionContent` varchar(500) NOT NULL, `dataManagerCode` varchar(100) NOT NULL, `dataManagerOptionCode` varchar(100) DEFAULT NULL, `dataManagerSectionCode` varchar(100) NOT NULL, `dataManagerSectionCustom` tinyint(1) NOT NULL DEFAULT '0', `dataManagerSectionFormSelectSourceFileLocal` tinyint(1) NOT NULL DEFAULT '0', `dataManagerSectionFormSelectSourceFileName` varchar(100) NOT NULL, `dataManagerSectionFormSelectSourceFilePath` varchar(200) NOT NULL, `dataManagerSectionID` int(11) NOT NULL AUTO_INCREMENT, `dataManagerSectionName` varchar(100) NOT NULL, `dataManagerSectionNamePublic` varchar(100) NOT NULL, `dataManagerSectionOverview` varchar(1000) NOT NULL, `dataManagerSectionSourceCode` varchar(4000) NOT NULL, `dataManagerSectionSourceCustom` tinyint(1) NOT NULL DEFAULT '0', `dataManagerSectionSourceFileName` varchar(100) NOT NULL, `dataManagerSectionSourceFilePath` varchar(200) NOT NULL, `dataManagerSectionType` varchar(100) NOT NULL, `displayOrder` smallint(6) NOT NULL DEFAULT '0', `domID` varchar(100) NOT NULL, `draggable` tinyint(1) NOT NULL DEFAULT '0', `formCode` varchar(100) NOT NULL, `nameVisible` tinyint(1) NOT NULL DEFAULT '0', `sectionLayout` varchar(20) NOT NULL, `sectionType` varchar(20) NOT NULL, `sectionVisible` tinyint(1) NOT NULL DEFAULT '0', `webTemplateCode` varchar(100) NOT NULL, PRIMARY KEY (`dataManagerSectionID`) ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `masterDataManagerSection` -- LOCK TABLES `masterDataManagerSection` WRITE; /*!40000 ALTER TABLE `masterDataManagerSection` DISABLE KEYS */; INSERT INTO `masterDataManagerSection` VALUES ('','','','',' height:18; width:863;',' height:399; width:863;','addressDataManager','addressOverview','addressDataManagerSectionData1',0,0,'dataManagerOptionOverviewFormSelect.php','portal|default|address|',1,'addressDataManagerSectionData1','Data Section 1','','',0,'','','',1,'addressDataManagerSectionData1',0,'addressDataManagerSection1',1,'freeForm','data',1,''),('','twistDataManagerSectionControl','','','','','addressDataManager','addressOverview','addressDataManagerSectionControl1',0,0,'','',2,'addressDataManagerSectionControl1','Control Section 1','','',0,'','','',3,'addressDataManagerSectionControl1',1,'',0,'','control',1,''); /*!40000 ALTER TABLE `masterDataManagerSection` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `masterEntityRequest` -- DROP TABLE IF EXISTS `masterEntityRequest`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `masterEntityRequest` ( `appCode` varchar(100) NOT NULL, `client` tinyint(1) NOT NULL DEFAULT '0', `clientDelete` tinyint(1) NOT NULL DEFAULT '0', `clientVisible` tinyint(1) NOT NULL DEFAULT '0', `deletedDateTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `deletedMemberID` int(11) NOT NULL DEFAULT '0', `entityRequestCode` varchar(100) NOT NULL, `entityRequestCustom` tinyint(1) NOT NULL DEFAULT '0', `entityRequestID` int(11) NOT NULL AUTO_INCREMENT, `entityRequestName` varchar(100) NOT NULL, `entityRequestNamePublic` varchar(100) NOT NULL, `entityRequestOverview` varchar(500) NOT NULL, `entityRequestSourceCode` varchar(8000) NOT NULL, `entityRequestSourceFileLocal` tinyint(1) NOT NULL DEFAULT '0', `entityRequestSourceFileName` varchar(100) NOT NULL, `entityRequestSourceFilePath` varchar(200) NOT NULL, `entityRequestSourceType` varchar(20) NOT NULL, `entityRequestStatusCode` varchar(100) NOT NULL, `entityRequestTitle` varchar(100) NOT NULL, `entityRequestTypeCode` varchar(100) NOT NULL, `entityRequestWebTemplateCode` varchar(100) NOT NULL, `initializedDateTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `insertedDateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `insertedMemberID` int(11) NOT NULL DEFAULT '0', `managerMemberID` int(11) NOT NULL DEFAULT '0', `parameter1Code` varchar(50) NOT NULL, `parameter1Value` varchar(200) NOT NULL, `parameter2Code` varchar(50) NOT NULL, `parameter2Value` varchar(50) NOT NULL, `parameter3Code` varchar(50) NOT NULL, `parameter3Value` varchar(200) NOT NULL, `parameter4Code` varchar(50) NOT NULL, `parameter4Value` varchar(200) NOT NULL, `parameter5Code` varchar(50) NOT NULL, `parameter5Value` varchar(200) NOT NULL, `parameter6Code` varchar(50) NOT NULL, `parameter6Value` varchar(200) NOT NULL, `parameter7Code` varchar(50) NOT NULL, `parameter7Value` varchar(200) NOT NULL, `parameter8Code` varchar(50) NOT NULL, `parameter8Value` varchar(200) NOT NULL, `parameter9Code` varchar(50) NOT NULL, `parameter9Value` varchar(200) NOT NULL, `roleCode` varchar(100) NOT NULL, `secure` tinyint(1) NOT NULL DEFAULT '0', `updatedDateTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `updatedMemberID` int(11) NOT NULL DEFAULT '0', `websiteCode` varchar(100) NOT NULL, `window` tinyint(1) NOT NULL DEFAULT '0', `windowCenterH` tinyint(1) NOT NULL DEFAULT '0', `windowCenterV` tinyint(1) NOT NULL DEFAULT '0', `windowCloseIcon` tinyint(1) NOT NULL DEFAULT '1', `windowDOMID` varchar(100) NOT NULL, `windowDraggable` tinyint(1) NOT NULL DEFAULT '0', `windowHeight` smallint(6) NOT NULL DEFAULT '0', `windowLeft` smallint(6) NOT NULL DEFAULT '0', `windowModal` tinyint(1) NOT NULL DEFAULT '0', `windowResizeable` tinyint(1) NOT NULL DEFAULT '0', `windowTemplateCode` varchar(100) NOT NULL, `windowTop` smallint(6) NOT NULL DEFAULT '0', `windowWidth` smallint(6) NOT NULL DEFAULT '0', `windowZIndex` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`entityRequestID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `masterEntityRequest` -- LOCK TABLES `masterEntityRequest` WRITE; /*!40000 ALTER TABLE `masterEntityRequest` DISABLE KEYS */; /*!40000 ALTER TABLE `masterEntityRequest` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `masterForm` -- DROP TABLE IF EXISTS `masterForm`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `masterForm` ( `cssClass` varchar(100) NOT NULL, `cssStyle` varchar(500) NOT NULL, `deletedDateTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `deletedMemberID` int(11) DEFAULT '0', `entityRequestCodeSubmit` varchar(100) NOT NULL, `formCode` varchar(100) NOT NULL, `formID` int(11) NOT NULL AUTO_INCREMENT, `formName` varchar(100) NOT NULL, `formNamePublic` varchar(100) NOT NULL, `formOverview` varchar(500) NOT NULL, `formStatus` varchar(20) NOT NULL, `formType` varchar(20) NOT NULL, `insertedDateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `insertedMemberID` int(11) DEFAULT '0', `updatedDateTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `updatedMemberID` int(11) DEFAULT '0', PRIMARY KEY (`formID`) ) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `masterForm` -- LOCK TABLES `masterForm` WRITE; /*!40000 ALTER TABLE `masterForm` DISABLE KEYS */; INSERT INTO `masterForm` VALUES ('','','0000-00-00 00:00:00',0,'','addressDataManagerHeader',1,'Address Data Manager Header','Address Data Manager Header','','','','2017-08-15 13:50:24',0,'0000-00-00 00:00:00',0),('','','0000-00-00 00:00:00',0,'','addressDataManagerSection1',2,'Address Data Manager Section 1','Address Data Manager Section 1','','','','2017-08-15 13:50:24',0,'0000-00-00 00:00:00',0),('','','0000-00-00 00:00:00',0,'','addressDataManagerPhysical',3,'addressDataManagerPhysical','addressDataManagerPhysical','','','','2017-08-15 13:50:24',0,'0000-00-00 00:00:00',0),('','','0000-00-00 00:00:00',0,'','addressDataManagerVirtualEmail',4,'addressDataManagerEmail','addressDataManagerVirtualEmail','','','','2017-08-15 13:50:24',0,'0000-00-00 00:00:00',0),('','','0000-00-00 00:00:00',0,'','addressDataManagerVirtualInternetAddress',5,'addressDataManagerInternetAddress','addressDataManagerVirtualInternetAddress','','','','2017-08-15 13:50:24',0,'0000-00-00 00:00:00',0),('','','0000-00-00 00:00:00',0,'','addressDataManagerVirtualInternetName',6,'addressDataManagerInternetName','addressDataManagerVirtualInternetName','','','','2017-08-15 13:50:24',0,'0000-00-00 00:00:00',0),('','','0000-00-00 00:00:00',0,'','addressDataManagerVirtualPhone',7,'addressDataManagerPhone','addressDataManagerVirtualPhone','','','','2017-08-15 13:50:24',0,'0000-00-00 00:00:00',0); /*!40000 ALTER TABLE `masterForm` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `masterFormItem` -- DROP TABLE IF EXISTS `masterFormItem`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `masterFormItem` ( `actionBlurSource` varchar(1000) NOT NULL, `actionBlurTypeID` tinyint(1) NOT NULL DEFAULT '0', `actionClickSource` varchar(1000) NOT NULL, `actionClickTypeID` tinyint(1) NOT NULL DEFAULT '0', `actionFocusSource` varchar(1000) NOT NULL, `actionFocusTypeID` tinyint(1) NOT NULL DEFAULT '0', `actionHoverSource` varchar(1000) NOT NULL, `actionHoverTypeID` tinyint(1) NOT NULL DEFAULT '0', `cssDataClass` varchar(100) NOT NULL, `cssDataStyle` varchar(200) NOT NULL, `cssLabelClass` varchar(100) NOT NULL, `cssLabelStyle` varchar(200) NOT NULL, `custom` tinyint(1) NOT NULL DEFAULT '0', `dataClass` varchar(100) NOT NULL, `dataDOMID` varchar(100) NOT NULL, `dataEntryOrder` int(11) NOT NULL DEFAULT '0', `dataHide` tinyint(1) NOT NULL DEFAULT '0', `dataManagerSectionID` int(11) NOT NULL DEFAULT '0', `dataStyle` varchar(500) NOT NULL, `dataTitle` varchar(100) NOT NULL, `defaultValue` varchar(500) NOT NULL, `displayLogic` varchar(1000) NOT NULL, `displayOrder` int(11) NOT NULL DEFAULT '0', `draggable` tinyint(1) NOT NULL DEFAULT '0', `formCode` varchar(100) NOT NULL, `formItemCode` varchar(100) NOT NULL, `formItemAllowHTML` tinyint(1) NOT NULL DEFAULT '0', `formItemAllowJavascript` tinyint(1) NOT NULL DEFAULT '0', `formItemAllowPHP` tinyint(1) NOT NULL DEFAULT '0', `formItemID` int(11) NOT NULL AUTO_INCREMENT, `formItemJoinReadOnly` tinyint(1) NOT NULL DEFAULT '0', `formItemLinkManagerID` int(11) NOT NULL DEFAULT '0', `formItemLinkManagerCode` varchar(100) NOT NULL, `formItemName` varchar(100) NOT NULL, `formItemNamePublic` varchar(100) NOT NULL, `formItemOverview` varchar(500) NOT NULL, `formItemSourceFileLocal` tinyint(1) NOT NULL DEFAULT '0', `formItemSourceFileName` varchar(100) NOT NULL, `formItemSourceFilePath` varchar(200) NOT NULL, `formItemType` varchar(50) NOT NULL, `formItemWebPageSectionID` int(11) NOT NULL DEFAULT '0', `hotKey` varchar(10) NOT NULL, `inputClass` varchar(100) NOT NULL, `inputStyle` varchar(200) NOT NULL, `inputType` varchar(20) NOT NULL, `instructions` varchar(100) NOT NULL, `joinOutput` varchar(500) NOT NULL, `joinSelectSQLLimitClause` varchar(100) NOT NULL, `joinSelectSQLOptionDisplay` varchar(100) NOT NULL, `joinSelectSQLOptionSelected` varchar(100) NOT NULL, `joinSelectSQLOptionValue` varchar(100) NOT NULL, `joinSelectSQLOrderByClause` varchar(500) NOT NULL, `joinSelectSQLStatement` varchar(500) NOT NULL, `joinSelectSQLWhereClause` varchar(500) NOT NULL, `joinSource` varchar(2000) NOT NULL, `joinSourceFileLocal` tinyint(1) NOT NULL DEFAULT '0', `joinSourceFileName` varchar(100) NOT NULL, `joinSourceFilePath` varchar(200) NOT NULL, `joinSQLTableCode` varchar(100) NOT NULL, `labelOnly` tinyint(1) NOT NULL DEFAULT '0', `labelText` varchar(100) NOT NULL, `linKMatchSQLTableCode` varchar(100) NOT NULL, `linkSourceTableCode` varchar(100) NOT NULL, `linkTypeCode` varchar(100) NOT NULL, `linkUpdateEntityRequestCode` varchar(100) NOT NULL, `mask` varchar(100) NOT NULL, `nonDataClass` varchar(100) NOT NULL, `nonDataDOMID` varchar(100) NOT NULL, `nonDataHide` tinyint(1) NOT NULL DEFAULT '0', `nonDataStyle` varchar(500) NOT NULL, `nonDataTitle` varchar(100) NOT NULL, `onBlur` varchar(100) NOT NULL, `onClick` varchar(100) NOT NULL, `onFocus` varchar(100) NOT NULL, `pickListCode` varchar(100) NOT NULL, `placeholder` varchar(100) NOT NULL, `positionLeft` int(11) NOT NULL DEFAULT '0', `positionTop` int(11) NOT NULL DEFAULT '0', `readOnly` tinyint(1) NOT NULL DEFAULT '0', `relationSQLTableID` int(11) NOT NULL DEFAULT '0', `selectListAllowReset` tinyint(1) NOT NULL DEFAULT '0', `selectListCode` varchar(100) NOT NULL, `sqlColumnCode` varchar(100) NOT NULL, `sqlTableCode` varchar(100) NOT NULL, `tabIndex` smallint(6) NOT NULL DEFAULT '0', `title` varchar(100) NOT NULL, `updateLogic` varchar(500) NOT NULL, `validationLogic` varchar(500) NOT NULL, `validationSequence` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`formItemID`) ) ENGINE=MyISAM AUTO_INCREMENT=75 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `masterFormItem` -- LOCK TABLES `masterFormItem` WRITE; /*!40000 ALTER TABLE `masterFormItem` DISABLE KEYS */; INSERT INTO `masterFormItem` VALUES ('',0,'',0,'',0,'',0,'','','','',0,'','addressNameInput',0,0,0,'left:260px; top:32px; height:19px; width:173px;','addressName Input','','',0,0,'addressDataManagerSection1','addressName',0,0,0,1,0,0,'','','','',0,'','','labelInput',0,'','','','text','','','','','','','','','','',0,'','','',0,'Address Name:','','','','','','','addressNameLabel',0,'left:157px; top:34px; height:15px; width:90px;','addressName Label','','','','','',0,0,0,0,0,'','addressName','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressOverviewInput',0,0,0,'left:260px; top:59px; height:100px; width:350px;','addressOverview Input','','',0,0,'addressDataManagerSection1','addressOverview',0,0,0,2,0,0,'','addressOverview','','',0,'','','labelInput',0,'','','','textarea','','','','','','','','','','',0,'','','',0,'Address Overview:','','','','','','','addressOverviewLabel',0,'left:136px; top:63px; height:15px; width:150px;','addressOverview Label','','','','','',0,0,0,0,0,'','addressOverview','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressPhysicalLatitudeInput',0,0,0,'left:261px; top:211px; height:19px; width:173px;','addressPhysicalLatitude Input','','',0,0,'addressDataManagerSection1','addressPhysicalLatitude',0,0,0,3,0,0,'','','','',0,'','','labelInput',0,'','','','text','','','','','','','','','','',0,'','','',0,'Latitude:','','','','','','','addressPhysicalLatitudeLabel',0,'left:198px; top:212px; height:15px; width:54px;','addressPhysicalLatitude Label','','','','','',0,0,0,0,0,'','addressPhysicalLatitude','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressPhysicalLongitudeInput',0,0,0,'left:261px; top:238px; height:19px; width:173px;','addressPhysicalLongitude Input','','',0,0,'addressDataManagerSection1','addressPhysicalLongitude',0,0,0,4,0,0,'','','','',0,'','','labelInput',0,'','','','text','','','','','','','','','','',0,'','','',0,'Longitude:','','','','','','','addressPhysicalLongitudeLabel',0,'left:190px; top:239px; height:15px; width:64px;','addressPhysicalLongitude Label','','','','','',0,0,0,0,0,'','addressPhysicalLongitude','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressPhysicalAltitudeInput',0,0,0,'left:260px; top:185px; height:19px; width:173px;','addressPhysicalAltitude Input','','',0,0,'addressDataManagerSection1','addressPhysicalAltitude',0,0,0,5,0,0,'','','','',0,'','','labelInput',0,'','','','text','','','','','','','','','','',0,'','','',0,'Altitude:','','','','','','','addressPhysicalAltitudeLabel',0,'left:200px; top:186px; height:15px; width:51px;','addressPhysicalAltitude Label','','','','','',0,0,0,0,0,'','addressPhysicalAltitude','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressPhysicalStreet1Input',0,0,0,'left:387px; top:54px; height:20px; width:350px;','addressPhysicalStreet1 Input','','',0,0,'addressDataManagerPhysical','addressPhysicalStreet1',0,0,0,6,0,0,'','addressPhysicalStreet1','','',0,'','','labelInput',0,'','','','text','','','','','','','','','','',0,'','','',0,'Street 1:','','','','','','','addressPhysicalStreet1Label',0,'left:328px; top:56px; height:14px; width:150px;','addressPhysicalStreet1 Label','','','','','',0,0,0,0,0,'','addressPhysicalStreet1','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressNameInput',0,0,0,'left:388px; top:10px; height:18px; width:350px;','addressName Input','','',0,0,'addressDataManagerPhysical','addressName',0,0,0,7,0,0,'','addressName','','',0,'','','labelInput',0,'','','','text','','','','','','','','','','',0,'','','',0,'Address Name:','','','','','','','addressNameLabel',0,'left:293px; top:12px; height:15px; width:150px;','addressName Label','','','','','',0,0,0,0,0,'','addressName','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressPhysicalStreet2Input',0,0,0,'left:387px; top:77px; height:20px; width:350px;','addressPhysicalStreet2 Input','','',0,0,'addressDataManagerPhysical','addressPhysicalStreet2',0,0,0,8,0,0,'','addressPhysicalStreet2','','',0,'','','labelInput',0,'','','','text','','','','','','','','','','',0,'','','',0,'Street 2:','','','','','','','addressPhysicalStreet2Label',0,'left:328px; top:78px; height:14px; width:150px;','addressPhysicalStreet2 Label','','','','','',0,0,0,0,0,'','addressPhysicalStreet2','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','',0,0,0,'','','','',0,0,'addressDataManagerPhysical','undefined',0,0,0,9,0,0,'','','','',0,'','','labelOnly',0,'','','','','','','','','','','','','','',0,'','','',0,'City / State / Zipcode:','','','','','','','undefinedLabel',0,'left:250px; top:103px; height:15px; width:131px;','undefined Label','','','','','',0,0,0,0,0,'','','',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressPhysicalCityInput',0,0,0,'left:386px; top:101px; height:19px; width:190px;','addressPhysicalCity Input','','',0,0,'addressDataManagerPhysical','addressPhysicalCity',0,0,0,10,0,0,'','addressPhysicalCity','','',0,'','','labelInput',0,'','','','text','','','','','','','','','','',0,'','','',0,'addressPhysicalCity:','','','','','','','addressPhysicalCityLabel',1,'left:33px; top:130px; height:15px; width:120px;','addressPhysicalCity Label','','','','','',0,0,0,0,0,'','addressPhysicalCity','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressPhysicalStateInput',0,0,0,'left:581px; top:100px; height:19px; width:40px;','addressPhysicalState Input','','',0,0,'addressDataManagerPhysical','addressPhysicalState',0,0,0,11,0,0,'','addressPhysicalState','','',0,'','','labelInput',0,'','','','text','','','','','','','','','','',0,'','','',0,'State:','','','','','','','addressPhysicalStateLabel',1,'left:20px; top:-30px; height:15px; width:37px;','addressPhysicalState Label','','','','','',0,0,0,0,0,'','addressPhysicalState','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressPhysicalZipcodeInput',0,0,0,'left:636px; top:101px; height:19px; width:100px;','addressPhysicalZipcode Input','','',0,0,'addressDataManagerPhysical','addressPhysicalZipcode',0,0,0,12,0,0,'','addressPhysicalZipcode','','',0,'','','labelInput',0,'','','','text','','','','','','','','','','',0,'','','',0,'Zipcode:','','','','','','','addressPhysicalZipcodeLabel',1,'left:67px; top:148px; height:15px; width:50px;','addressPhysicalZipcode Label','','','','','',0,0,0,0,0,'','addressPhysicalZipcode','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressPhysicalCountyInput',0,0,0,'left:385px; top:123px; height:19px; width:150px;','addressPhysicalCounty Input','','',0,0,'addressDataManagerPhysical','addressPhysicalCounty',0,0,0,13,0,0,'','addressPhysicalCounty','','',0,'','','labelInput',0,'','','','text','','','','','','','','','','',0,'','','',0,'County:','','','','','','','addressPhysicalCountyLabel',1,'left:104px; top:118px; height:15px; width:48px;','addressPhysicalCounty Label','','','','','',0,0,0,0,0,'','addressPhysicalCounty','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressPhysicalCountryInput',0,0,0,'left:546px; top:124px; height:19px; width:190px;','addressPhysicalCountry Input','','',0,0,'addressDataManagerPhysical','addressPhysicalCountry',0,0,0,14,0,0,'','addressPhysicalCountry','','',0,'','','labelInput',0,'','','','text','','','','','','','','','','',0,'','','',0,'Country:','','','','','','','addressPhysicalCountryLabel',1,'left:69px; top:168px; height:15px; width:53px;','addressPhysicalCountry Label','','','','','',0,0,0,0,0,'','addressPhysicalCountry','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','',0,0,0,'','','','',0,0,'addressDataManagerPhysical','undefined',0,0,0,15,0,0,'','','','',0,'','','labelOnly',0,'','','','','','','','','','','','','','',0,'','','',0,'County / Country:','','','','','','','undefinedLabel',0,'left:272px; top:124px; height:15px; width:109px;','undefined Label','','','','','',0,0,0,0,0,'','','',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressPhysicalLatitudeInput',0,0,0,'left:384px; top:146px; height:19px; width:120px;','addressPhysicalLatitude Input','','',0,0,'addressDataManagerPhysical','addressPhysicalLatitude',0,0,0,16,0,0,'','addressPhysicalLatitude','','',0,'','','labelInput',0,'','','','text','','','','','','','','','','',0,'','','',0,'Latitude:','','','','','','','addressPhysicalLatitudeLabel',1,'left:72px; top:181px; height:15px; width:54px;','addressPhysicalLatitude Label','','','','','',0,0,0,0,0,'','addressPhysicalLatitude','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressPhysicalLongitudeInput',0,0,0,'left:509px; top:147px; height:19px; width:120px;','addressPhysicalLongitude Input','','',0,0,'addressDataManagerPhysical','addressPhysicalLongitude',0,0,0,17,0,0,'','addressPhysicalLongitude','','',0,'','','labelInput',0,'','','','text','','','','','','','','','','',0,'','','',0,'Longitude:','','','','','','','addressPhysicalLongitudeLabel',1,'left:134px; top:208px; height:15px; width:64px;','addressPhysicalLongitude Label','','','','','',0,0,0,0,0,'','addressPhysicalLongitude','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','',0,0,0,'','','','',0,0,'addressDataManagerPhysical','undefined',0,0,0,18,0,0,'','','','',0,'','','labelOnly',0,'','','','','','','','','','','','','','',0,'','','',0,'Lat. / Lon. / Altitude:','','','','','','','undefinedLabel',0,'left:255px; top:146px; height:15px; width:126px;','undefined Label','','','','','',0,0,0,0,0,'','','',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressPhysicalAltitudeInput',0,0,0,'left:646px; top:147px; height:19px; width:90px;','addressPhysicalAltitude Input','','',0,0,'addressDataManagerPhysical','addressPhysicalAltitude',0,0,0,19,0,0,'','addressPhysicalAltitude','','',0,'','','labelInput',0,'','','','text','','','','','','','','','','',0,'','','',0,'Altitude:','','','','','','','addressPhysicalAltitudeLabel',1,'left:222px; top:204px; height:15px; width:51px;','addressPhysicalAltitude Label','','','','','',0,0,0,0,0,'','addressPhysicalAltitude','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressPhysicalGalaxyInput',0,0,0,'left:383px; top:169px; height:19px; width:160px;','addressPhysicalGalaxy Input','','',0,0,'addressDataManagerPhysical','addressPhysicalGalaxy',0,0,0,20,0,0,'','addressPhysicalGalaxy','','',0,'','','labelInput',0,'','','','text','','','','','','','','','','',0,'','','',0,'Galaxy:','','','','','','','addressPhysicalGalaxyLabel',0,'left:335px; top:170px; height:15px; width:45px;','addressPhysicalGalaxy Label','','','','','',0,0,0,0,0,'','addressPhysicalGalaxy','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressPhysicalEarthDistanceInput',0,0,0,'left:384px; top:192px; height:19px; width:160px;','addressPhysicalEarthDistance Input','','',0,0,'addressDataManagerPhysical','addressPhysicalEarthDistance',0,0,0,21,0,0,'','addressPhysicalEarthDistance','','',0,'','','labelInput',0,'','','','text','','','','','','','','','','',0,'','','',0,'Earth Distance:','','','','','','','addressPhysicalEarthDistanceLabel',0,'left:287px; top:192px; height:15px; width:93px;','addressPhysicalEarthDistance Label','','','','','',0,0,0,0,0,'','addressPhysicalEarthDistance','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressPhysicalEarthDistanceUnitInput',0,0,0,'left:594px; top:191px; height:19px; width:140px;','addressPhysicalEarthDistanceUnit Input','','',0,0,'addressDataManagerPhysical','addressPhysicalEarthDistanceUnit',0,0,0,22,0,0,'','addressPhysicalEarthDistanceUnit','','',0,'','','labelInput',0,'','','','text','','','','','','','','','','',0,'','','',0,'Unit:','','','','','','','addressPhysicalEarthDistanceUnitLabel',0,'left:559px; top:193px; height:15px; width:122px;','addressPhysicalEarthDistanceUnit Label','','','','','',0,0,0,0,0,'','addressPhysicalEarthDistanceUnit','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressOverviewInput',0,0,0,'left:384px; top:215px; height:60px; width:350px;','addressOverview Input','','',0,0,'addressDataManagerPhysical','addressOverview',0,0,0,23,0,0,'','addressOverview','','',0,'','','labelInput',0,'','','','textarea','','','','','','','','','','',0,'','','',0,'Overview:','','','','','','','addressOverviewLabel',0,'left:319px; top:219px; height:15px; width:60px;','addressOverview Label','','','','','',0,0,0,0,0,'','addressOverview','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressContentVersionIDPrimarySmallInput',0,0,0,'left:10px; top:10px; height:19px; width:173px;','addressContentVersionIDPrimarySmall Input','','',0,0,'addressDataManagerPhysical','addressContentVersionIDPrimarySmall',0,0,0,24,0,0,'','addressContentVersionIDPrimarySmall','','',0,'','','labelInput',0,'','','','joinOne','','','','','','','','','','',0,'joinContentVersionPrimaryExecute.php','portal|default|core|','',0,'addressContentVersionIDPrimarySmall:','','','','','','','addressContentVersionIDPrimarySmallLabel',1,'left:20px; top:-30px;','addressContentVersionIDPrimarySmall Label','','','','','',0,0,0,0,0,'','addressContentVersionIDPrimarySmall','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressNamePublicInput',0,0,0,'left:388px; top:32px; height:19px; width:350px;','addressNamePublic Input','','',0,0,'addressDataManagerPhysical','addressNamePublic',0,0,0,25,0,0,'','addressNamePublic','','',0,'','','labelInput',0,'','','','text','','','','','','','','','','',0,'','','',0,'Address Name Public:','','','','','','','addressNamePublicLabel',0,'left:255px; top:34px; height:15px; width:128px;','addressNamePublic Label','','','','','',0,0,0,0,0,'','addressNamePublic','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressContactInput',0,0,0,'left:198px; top:219px; height:13px; width:13px;','addressContact Input','','',0,0,'addressDataManagerPhysical','addressContact',0,0,0,26,0,0,'','','','',0,'','','labelInput',0,'','','','checkbox','','','','','','','','','','',0,'','','',0,'Contact Address:','','','','','','','addressContactLabel',0,'left:89px; top:217px; height:15px; width:101px;','addressContact Label','','','','','',0,0,0,0,0,'','addressContact','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressInformationInput',0,0,0,'left:198px; top:238px; height:13px; width:13px;','addressInformation Input','','',0,0,'addressDataManagerPhysical','addressInformation',0,0,0,27,0,0,'','addressInformation','','',0,'','','labelInput',0,'','','','checkbox','','','','','','','','','','',0,'','','',0,'Information Address:','','','','','','','addressInformationLabel',0,'left:64px; top:237px; height:15px; width:126px;','addressInformation Label','','','','','',0,0,0,0,0,'','addressInformation','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressBlockInboundDateInput',0,0,0,'left:384px; top:278px; height:19px; width:80px;','addressBlockInboundDate Input','','',0,0,'addressDataManagerPhysical','addressBlockInboundDate',0,0,0,28,0,0,'','addressBlockInboundDate','','',0,'','','labelInput',0,'','','','date','','','','','','','','','','',0,'','','',0,'Inbound Block Date:','','','','','','','addressBlockInboundDateLabel',0,'left:258px; top:279px; height:15px; width:122px;','addressBlockInboundDate Label','','','','','',0,0,0,0,0,'','addressBlockInboundDate','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressBlockOutboundDateInput',0,0,0,'left:383px; top:301px; height:19px; width:173px;','addressBlockOutboundDate Input','','',0,0,'addressDataManagerPhysical','addressBlockOutboundDate',0,0,0,29,0,0,'','','','',0,'','','labelInput',0,'','','','date','','','','','','','','','','',0,'','','',0,'Outbound Block Date:','','','','','','','addressBlockOutboundDateLabel',0,'left:249px; top:303px; height:15px; width:131px;','addressBlockOutboundDate Label','','','','','',0,0,0,0,0,'','addressBlockOutboundDate','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressBlockReasonInput',0,0,0,'left:383px; top:326px; height:40px; width:167px;','addressBlockReason Input','','',0,0,'addressDataManagerPhysical','addressBlockReason',0,0,0,30,0,0,'','','','',0,'','','labelInput',0,'','','','textarea','','','','','','','','','','',0,'','','',0,'Block Reason:','','','','','','','addressBlockReasonLabel',0,'left:297px; top:324px; height:15px; width:83px;','addressBlockReason Label','','','','','',0,0,0,0,0,'','addressBlockReason','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressVirtualTextInput',0,0,0,'left:385px; top:54px; height:19px; width:350px;','addressVirtualText Input','','',0,0,'addressDataManagerVirtualEmail','addressVirtualText',0,0,0,31,0,0,'','addressVirtualText','','',0,'','','labelInput',0,'','','','text','','','','','','','','','','',0,'','','',0,'Email Address:','','','','','','','addressVirtualTextLabel',0,'left:293px; top:55px; height:15px; width:150px;','addressVirtualText Label','','','','','',0,0,0,0,0,'','addressVirtualText','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressNameInput',0,0,0,'left:385px; top:10px; height:19px; width:350px;','addressName Input','','',0,0,'addressDataManagerVirtualEmail','addressName',0,0,0,32,0,0,'','addressName','','',0,'','','labelInput',0,'','','','text','','','','','','','','','','',0,'','','',0,'Email Name:','','','','','','','addressNameLabel',0,'left:303px; top:12px; height:15px; width:150px;','addressName Label','','','','','',0,0,0,0,0,'','addressName','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressOverviewInput',0,0,0,'left:386px; top:77px; height:100px; width:350px;','addressOverview Input','','',0,0,'addressDataManagerVirtualEmail','addressOverview',0,0,0,33,0,0,'','addressOverview','','',0,'','','labelInput',0,'','','','textarea','','','','','','','','','','',0,'','','',0,'Overview:','','','','','','','addressOverviewLabel',0,'left:320px; top:77px; height:15px; width:60px;','addressOverview Label','','','','','',0,0,0,0,0,'','addressOverview','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressNamePublicInput',0,0,0,'left:385px; top:33px; height:17px; width:350px;','addressNamePublic Input','','',0,0,'addressDataManagerVirtualEmail','addressNamePublic',0,0,0,34,0,0,'','addressNamePublic','','',0,'','','labelInput',0,'','','','text','','','','','','','','','','',0,'','','',0,'Email Name Public:','','','','','','','addressNamePublicLabel',0,'left:266px; top:34px; height:15px; width:150px;','addressNamePublic Label','','','','','',0,0,0,0,0,'','addressNamePublic','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressContentVersionIDPrimarySmallInput',0,0,0,'left:10px; top:10px; height:19px; width:173px;','addressContentVersionIDPrimarySmall Input','','',0,0,'addressDataManagerVirtualEmail','addressContentVersionIDPrimarySmall',0,0,0,35,0,0,'','addressContentVersionIDPrimarySmall','','',0,'','','labelInput',0,'','','','joinOne','','','','','','','','','','',0,'joinContentVersionPrimaryExecute.php','portal|default|core|','',0,'addressContentVersionIDPrimarySmall:','','','','','','','addressContentVersionIDPrimarySmallLabel',1,'left:304px; top:182px; height:15px; width:234px;','addressContentVersionIDPrimarySmall Label','','','','','',0,0,0,0,0,'','addressContentVersionIDPrimarySmall','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressContactInput',0,0,0,'left:198px; top:218px; height:13px; width:13px;','addressContact Input','','',0,0,'addressDataManagerVirtualEmail','addressContact',0,0,0,36,0,0,'','addressContact','','',0,'','','labelInput',0,'','','','checkbox','','','','','','','','','','',0,'','','',0,'Contact Address:','','','','','','','addressContactLabel',0,'left:86px; top:217px; height:15px; width:150px;','addressContact Label','','','','','',0,0,0,0,0,'','addressContact','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressInformationInput',0,0,0,'left:198px; top:238px; height:13px; width:13px;','addressInformation Input','','',0,0,'addressDataManagerVirtualEmail','addressInformation',0,0,0,37,0,0,'','addressInformation','','',0,'','','labelInput',0,'','','','checkbox','','','','','','','','','','',0,'','','',0,'Information Address:','','','','','','','addressInformationLabel',0,'left:61px; top:236px; height:15px; width:200px;','addressInformation Label','','','','','',0,0,0,0,0,'','addressInformation','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressBlockInboundDateInput',0,0,0,'left:385px; top:182px; height:19px; width:80px;','addressBlockInboundDate Input','','',0,0,'addressDataManagerVirtualEmail','addressBlockInboundDate',0,0,0,38,0,0,'','addressBlockInboundDate','','',0,'','','labelInput',0,'','','','date','','','','','','','','','','',0,'','','',0,'Inbound Block Date:','','','','','','','addressBlockInboundDateLabel',0,'left:258px; top:183px; height:15px; width:200px;','addressBlockInboundDate Label','','','','','',0,0,0,0,0,'','addressBlockInboundDate','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressBlockOutboundDateInput',0,0,0,'left:385px; top:205px; height:19px; width:80px;','addressBlockOutboundDate Input','','',0,0,'addressDataManagerVirtualEmail','addressBlockOutboundDate',0,0,0,39,0,0,'','addressBlockOutboundDate','','',0,'','','labelInput',0,'','','','date','','','','','','','','','','',0,'','','',0,'Outbound Block Date:','','','','','','','addressBlockOutboundDateLabel',0,'left:249px; top:208px; height:15px; width:200px;','addressBlockOutboundDate Label','','','','','',0,0,0,0,0,'','addressBlockOutboundDate','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressBlockReasonInput',0,0,0,'left:384px; top:229px; height:40px; width:350px;','addressBlockReason Input','','',0,0,'addressDataManagerVirtualEmail','addressBlockReason',0,0,0,40,0,0,'','addressBlockReason','','',0,'','','labelInput',0,'','','','textarea','','','','','','','','','','',0,'','','',0,'Block Reason:','','','','','','','addressBlockReasonLabel',0,'left:297px; top:232px; height:15px; width:150px;','addressBlockReason Label','','','','','',0,0,0,0,0,'','addressBlockReason','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressContactInput',0,0,0,'left:201px; top:217px; height:13px; width:13px;','addressContact Input','','',0,0,'addressDataManagerVirtualInternetAddress','addressContact',0,0,0,41,0,0,'','addressContact','','',0,'','','labelInput',0,'','','','checkbox','','','','','','','','','','',0,'','','',0,'Contact Address:','','','','','','','addressContactLabel',0,'left:93px; top:215px; height:15px; width:200px;','addressContact Label','','','','','',0,0,0,0,0,'','addressContact','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressInformationInput',0,0,0,'left:201px; top:236px; height:13px; width:13px;','addressInformation Input','','',0,0,'addressDataManagerVirtualInternetAddress','addressInformation',0,0,0,42,0,0,'','addressInformation','','',0,'','','labelInput',0,'','','','checkbox','','','','','','','','','','',0,'','','',0,'Information Address:','','','','','','','addressInformationLabel',0,'left:68px; top:233px; height:15px; width:200px;','addressInformation Label','','','','','',0,0,0,0,0,'','addressInformation','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressVirtualTextInput',0,0,0,'left:410px; top:55px; height:19px; width:350px;','addressVirtualText Input','','',0,0,'addressDataManagerVirtualInternetAddress','addressVirtualText',0,0,0,43,0,0,'','addressVirtualText','','',0,'','','labelInput',0,'','','','text','','','','','','','','','','',0,'','','',0,'Internet Address:','','','','','','','addressVirtualTextLabel',0,'left:298px; top:56px; height:15px; width:200px;','addressVirtualText Label','','','','','',0,0,0,0,0,'','addressVirtualText','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressOverviewInput',0,0,0,'left:408px; top:78px; height:100px; width:350px;','addressOverview Input','','',0,0,'addressDataManagerVirtualInternetAddress','addressOverview',0,0,0,44,0,0,'','addressOverview','','',0,'','','labelInput',0,'','','','textarea','','','','','','','','','','',0,'','','',0,'Overview:','','','','','','','addressOverviewLabel',0,'left:342px; top:80px; height:15px; width:60px;','addressOverview Label','','','','','',0,0,0,0,0,'','addressOverview','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressNameInput',0,0,0,'left:410px; top:10px; height:19px; width:350px;','addressName Input','','',0,0,'addressDataManagerVirtualInternetAddress','addressName',0,0,0,45,0,0,'','addressName','','',0,'','','labelInput',0,'','','','text','','','','','','','','','','',0,'','','',0,'Internet Address Name:','','','','','','','addressNameLabel',0,'left:259px; top:12px; height:15px; width:200px;','addressName Label','','','','','',0,0,0,0,0,'','addressName','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressContentVersionIDPrimarySmallInput',0,0,0,'left:14px; top:10px; height:19px; width:173px;','addressContentVersionIDPrimarySmall Input','','',0,0,'addressDataManagerVirtualInternetAddress','addressContentVersionIDPrimarySmall',0,0,0,46,0,0,'','addressContentVersionIDPrimarySmall','','',0,'','','labelInput',0,'','','','joinOne','','','','','','','','','','',0,'joinContentVersionPrimaryExecute.php','portal|default|core|','',0,'addressContentVersionIDPrimarySmall:','','','','','','','addressContentVersionIDPrimarySmallLabel',1,'left:20px; top:-30px;','addressContentVersionIDPrimarySmall Label','','','','','',0,0,0,0,0,'','addressContentVersionIDPrimarySmall','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressNamePublicInput',0,0,0,'left:410px; top:33px; height:19px; width:350px;','addressNamePublic Input','','',0,0,'addressDataManagerVirtualInternetAddress','addressNamePublic',0,0,0,47,0,0,'','addressNamePublic','','',0,'','','labelInput',0,'','','','text','','','','','','','','','','',0,'','','',0,'Address Name Public:','','','','','','','addressNamePublicLabel',0,'left:277px; top:34px; height:15px; width:200px;','addressNamePublic Label','','','','','',0,0,0,0,0,'','addressNamePublic','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressBlockInboundDateInput',0,0,0,'left:409px; top:183px; height:19px; width:80px;','addressBlockInboundDate Input','','',0,0,'addressDataManagerVirtualInternetAddress','addressBlockInboundDate',0,0,0,48,0,0,'','addressBlockInboundDate','','',0,'','','labelInput',0,'','','','date','','','','','','','','','','',0,'','','',0,'Inbound Block Date:','','','','','','','addressBlockInboundDateLabel',0,'left:280px; top:185px; height:15px; width:200px;','addressBlockInboundDate Label','','','','','',0,0,0,0,0,'','addressBlockInboundDate','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressBlockOutboundDateInput',0,0,0,'left:409px; top:207px; height:19px; width:80px;','addressBlockOutboundDate Input','','',0,0,'addressDataManagerVirtualInternetAddress','addressBlockOutboundDate',0,0,0,49,0,0,'','addressBlockOutboundDate','','',0,'','','labelInput',0,'','','','date','','','','','','','','','','',0,'','','',0,'Outbound Block Date:','','','','','','','addressBlockOutboundDateLabel',0,'left:272px; top:208px; height:15px; width:200px;','addressBlockOutboundDate Label','','','','','',0,0,0,0,0,'','addressBlockOutboundDate','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressBlockReasonInput',0,0,0,'left:409px; top:230px; height:40px; width:350px;','addressBlockReason Input','','',0,0,'addressDataManagerVirtualInternetAddress','addressBlockReason',0,0,0,50,0,0,'','addressBlockReason','','',0,'','','labelInput',0,'','','','textarea','','','','','','','','','','',0,'','','',0,'Block Reason:','','','','','','','addressBlockReasonLabel',0,'left:321px; top:231px; height:15px; width:200px;','addressBlockReason Label','','','','','',0,0,0,0,0,'','addressBlockReason','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressContentVersionIDPrimarySmallInput',0,0,0,'left:10px; top:10px; height:17px; width:156px;','addressContentVersionIDPrimarySmall Input','','',0,0,'addressDataManagerVirtualInternetName','addressContentVersionIDPrimarySmall',0,0,0,51,0,0,'','addressContentVersionIDPrimarySmall','','',0,'','','labelInput',0,'','','','joinOne','','','','','','','','','','',0,'joinContentVersionPrimaryExecute.php','portal|default|core|','',0,'addressContentVersionIDPrimarySmall:','','','','','','','addressContentVersionIDPrimarySmallLabel',1,'left:406px; top:129px; height:15px; width:238px;','addressContentVersionIDPrimarySmall Label','','','','','',0,0,0,0,0,'','addressContentVersionIDPrimarySmall','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressNameInput',0,0,0,'left:397px; top:10px; height:18px; width:350px;','addressName Input','','',0,0,'addressDataManagerVirtualInternetName','addressName',0,0,0,52,0,0,'','addressName','','',0,'','','labelInput',0,'','','','text','','','','','','','','','','',0,'','','',0,'Address Name:','','','','','','','addressNameLabel',0,'left:298px; top:11px; height:29px; width:150px;','addressName Label','','','','','',0,0,0,0,0,'','addressName','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressNamePublicInput',0,0,0,'left:397px; top:32px; height:18px; width:350px;','addressNamePublic Input','','',0,0,'addressDataManagerVirtualInternetName','addressNamePublic',0,0,0,53,0,0,'','addressNamePublic','','',0,'','','labelInput',0,'','','','text','','','','','','','','','','',0,'','','',0,'Address Name Public:','','','','','','','addressNamePublicLabel',0,'left:259px; top:33px; height:15px; width:132px;','addressNamePublic Label','','','','','',0,0,0,0,0,'','addressNamePublic','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressOverviewInput',0,0,0,'left:396px; top:77px; height:100px; width:350px;','addressOverview Input','','',0,0,'addressDataManagerVirtualInternetName','addressOverview',0,0,0,54,0,0,'','addressOverview','','',0,'','','labelInput',0,'','','','textarea','','','','','','','','','','',0,'','','',0,'Address Overview:','','','','','','','addressOverviewLabel',0,'left:276px; top:77px; height:15px; width:114px;','addressOverview Label','','','','','',0,0,0,0,0,'','addressOverview','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressBlockInboundDateInput',0,0,0,'left:395px; top:183px; height:18px; width:150px;','addressBlockInboundDate Input','','',0,0,'addressDataManagerVirtualInternetName','addressBlockInboundDate',0,0,0,55,0,0,'','addressBlockInboundDate','','',0,'','','labelInput',0,'','','','date','','','','','','','','','','',0,'','','',0,'Inbound Block Date:','','','','','','','addressBlockInboundDateLabel',0,'left:267px; top:184px; height:30px; width:150px;','addressBlockInboundDate Label','','','','','',0,0,0,0,0,'','addressBlockInboundDate','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressVirtualTextInput',0,0,0,'left:396px; top:54px; height:18px; width:350px;','addressVirtualText Input','','',0,0,'addressDataManagerVirtualInternetName','addressVirtualText',0,0,0,56,0,0,'','addressVirtualText','','',0,'','','labelInput',0,'','','','text','','','','','','','','','','',0,'','','',0,'Internet Name:','','','','','','','addressVirtualTextLabel',0,'left:297px; top:53px; height:15px; width:94px;','addressVirtualText Label','','','','','',0,0,0,0,0,'','addressVirtualText','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressBlockOutboundDateInput',0,0,0,'left:396px; top:205px; height:18px; width:150px;','addressBlockOutboundDate Input','','',0,0,'addressDataManagerVirtualInternetName','addressBlockOutboundDate',0,0,0,57,0,0,'','','','',0,'','','labelInput',0,'','','','date','','','','','','','','','','',0,'','','',0,'Outbound Block Date:','','','','','','','addressBlockOutboundDateLabel',0,'left:258px; top:207px; height:15px; width:134px;','addressBlockOutboundDate Label','','','','','',0,0,0,0,0,'','addressBlockOutboundDate','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressBlockReasonInput',0,0,0,'left:394px; top:227px; height:38px; width:167px;','addressBlockReason Input','','',0,0,'addressDataManagerVirtualInternetName','addressBlockReason',0,0,0,58,0,0,'','addressBlockReason','','',0,'','','labelInput',0,'','','','textarea','','','','','','','','','','',0,'','','',0,'Block Reason:','','','','','','','addressBlockReasonLabel',0,'left:306px; top:228px; height:30px; width:150px;','addressBlockReason Label','','','','','',0,0,0,0,0,'','addressBlockReason','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressContactInput',0,0,0,'left:199px; top:218px; height:13px; width:13px;','addressContact Input','','',0,0,'addressDataManagerVirtualInternetName','addressContact',0,0,0,59,0,0,'','','','',0,'','','labelInput',0,'','','','checkbox','','','','','','','','','','',0,'','','',0,'Contact Address:','','','','','','','addressContactLabel',0,'left:90px; top:216px; height:15px; width:104px;','addressContact Label','','','','','',0,0,0,0,0,'','addressContact','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressInformationInput',0,0,0,'left:199px; top:234px; height:13px; width:13px;','addressInformation Input','','',0,0,'addressDataManagerVirtualInternetName','addressInformation',0,0,0,60,0,0,'','','','',0,'','','labelInput',0,'','','','checkbox','','','','','','','','','','',0,'','','',0,'Information Address:','','','','','','','addressInformationLabel',0,'left:65px; top:232px; height:15px; width:129px;','addressInformation Label','','','','','',0,0,0,0,0,'','addressInformation','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressNameInput',0,0,0,'left:395px; top:10px; height:15px; width:350px;','addressName Input','','',0,0,'addressDataManagerVirtualPhone','addressName',0,0,0,61,0,0,'','addressName','','',0,'','','labelInput',0,'','','','text','','','','','','','','','','',0,'','','',0,'Address Name:','','','','','','','addressNameLabel',0,'left:299px; top:10px; height:15px; width:150px;','addressName Label','','','','','',0,0,0,0,0,'','addressName','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressVirtualPhoneAreaCodeInput',0,0,0,'left:394px; top:51px; height:19px; width:40px;','addressVirtualPhoneAreaCode Input','','',0,0,'addressDataManagerVirtualPhone','addressVirtualPhoneAreaCode',0,0,0,62,0,0,'','addressVirtualPhoneAreaCode','','',0,'','','labelInput',0,'','','','text','','','','','','','','','','',0,'','','',0,'Area Code:','','','','','','','addressVirtualPhoneAreaCodeLabel',1,'left:193px; top:55px; height:15px; width:65px;','addressVirtualPhoneAreaCode Label','','','','','',0,0,0,0,0,'','addressVirtualPhoneAreaCode','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressVirtualPhonePrefixInput',0,0,0,'left:439px; top:51px; height:19px; width:40px;','addressVirtualPhonePrefix Input','','',0,0,'addressDataManagerVirtualPhone','addressVirtualPhonePrefix',0,0,0,63,0,0,'','addressVirtualPhonePrefix','','',0,'','','labelInput',0,'','','','text','','','','','','','','','','',0,'','','',0,'Prefix:','','','','','','','addressVirtualPhonePrefixLabel',1,'left:20px; top:-30px; height:15px; width:38px;','addressVirtualPhonePrefix Label','','','','','',0,0,0,0,0,'','addressVirtualPhonePrefix','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressVirtualPhoneLineNumberInput',0,0,0,'left:484px; top:51px; height:19px; width:50px;','addressVirtualPhoneLineNumber Input','','',0,0,'addressDataManagerVirtualPhone','addressVirtualPhoneLineNumber',0,0,0,64,0,0,'','addressVirtualPhoneLineNumber','','',0,'','','labelInput',0,'','','','text','','','','','','','','','','',0,'','','',0,'Line Number:','','','','','','','addressVirtualPhoneLineNumberLabel',1,'left:72px; top:141px; height:15px; width:82px;','addressVirtualPhoneLineNumber Label','','','','','',0,0,0,0,0,'','addressVirtualPhoneLineNumber','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','',0,0,0,'','','','',0,0,'addressDataManagerVirtualPhone','undefined',0,0,0,65,0,0,'','undefined','','',0,'','','labelOnly',0,'','','','','','','','','','','','','','',0,'','','',0,'Phone Number:','','','','','','','label1',0,'left:294px; top:52px; height:15px; width:150px;','undefined Label','','','','','',0,0,0,0,0,'','','',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressOverviewInput',0,0,0,'left:392px; top:74px; height:100px; width:350px;','addressOverview Input','','',0,0,'addressDataManagerVirtualPhone','addressOverview',0,0,0,66,0,0,'','addressOverview','','',0,'','','labelInput',0,'','','','textarea','','','','','','','','','','',0,'','','',0,'Overview:','','','','','','','addressOverviewLabel',0,'left:328px; top:77px; height:15px; width:55px;','addressOverview Label','','','','','',0,0,0,0,0,'','addressOverview','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressVirtualPhoneExtensionInput',0,0,0,'left:665px; top:51px; height:19px; width:80px;','addressVirtualPhoneExtension Input','','',0,0,'addressDataManagerVirtualPhone','addressVirtualPhoneExtension',0,0,0,67,0,0,'','addressVirtualPhoneExtension','','',0,'','','labelInput',0,'','','','text','','','','','','','','','','',0,'','','',0,'Extension:','','','','','','','addressVirtualPhoneExtensionLabel',0,'left:596px; top:54px; height:15px; width:64px;','addressVirtualPhoneExtension Label','','','','','',0,0,0,0,0,'','addressVirtualPhoneExtension','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressNamePublicInput',0,0,0,'left:395px; top:29px; height:18px; width:350px;','addressNamePublic Input','','',0,0,'addressDataManagerVirtualPhone','addressNamePublic',0,0,0,68,0,0,'','addressNamePublic','','',0,'','','labelInput',0,'','','','text','','','','','','','','','','',0,'','','',0,'Address Public Name:','','','','','','','addressNamePublicLabel',0,'left:261px; top:29px; height:15px; width:134px;','addressNamePublic Label','','','','','',0,0,0,0,0,'','addressNamePublic','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressContentVersionIDPrimarySmallInput',0,0,0,'left:10px; top:10px; height:19px; width:173px;','addressContentVersionIDPrimarySmall Input','','',0,0,'addressDataManagerVirtualPhone','addressContentVersionIDPrimarySmall',0,0,0,69,0,0,'','addressContentVersionIDPrimarySmall','','',0,'','','labelInput',0,'','','','joinOne','','','','','','','','','','',0,'joinContentVersionPrimaryExecute.php','portal|default|core|','',0,'addressContentVersionIDPrimarySmall:','','','','','','','addressContentVersionIDPrimarySmallLabel',1,'left:242px; top:224px; height:15px; width:234px;','addressContentVersionIDPrimarySmall Label','','','','','',0,0,0,0,0,'','addressContentVersionIDPrimarySmall','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressContactInput',0,0,0,'left:198px; top:218px; height:13px; width:13px;','addressContact Input','','',0,0,'addressDataManagerVirtualPhone','addressContact',0,0,0,70,0,0,'','addressContact','','',0,'','','labelInput',0,'','','','checkbox','','','','','','','','','','',0,'','','',0,'Contact Address:','','','','','','','addressContactLabel',0,'left:90px; top:216px; height:15px; width:150px;','addressContact Label','','','','','',0,0,0,0,0,'','addressContact','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressInformationInput',0,0,0,'left:198px; top:235px; height:13px; width:13px;','addressInformation Input','','',0,0,'addressDataManagerVirtualPhone','addressInformation',0,0,0,71,0,0,'','addressInformation','','',0,'','','labelInput',0,'','','','checkbox','','','','','','','','','','',0,'','','',0,'Information Address:','','','','','','','addressInformationLabel',0,'left:65px; top:234px; height:15px; width:200px;','addressInformation Label','','','','','',0,0,0,0,0,'','addressInformation','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressBlockInboundDateInput',0,0,0,'left:393px; top:178px; height:19px; width:80px;','addressBlockInboundDate Input','','',0,0,'addressDataManagerVirtualPhone','addressBlockInboundDate',0,0,0,72,0,0,'','addressBlockInboundDate','','',0,'','','labelInput',0,'','','','date','','','','','','','','','','',0,'','','',0,'Inbound Block Date:','','','','','','','addressBlockInboundDateLabel',0,'left:263px; top:180px; height:15px; width:150px;','addressBlockInboundDate Label','','','','','',0,0,0,0,0,'','addressBlockInboundDate','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressBlockOutboundDateInput',0,0,0,'left:393px; top:201px; height:19px; width:80px;','addressBlockOutboundDate Input','','',0,0,'addressDataManagerVirtualPhone','addressBlockOutboundDate',0,0,0,73,0,0,'','addressBlockOutboundDate','','',0,'','','labelInput',0,'','','','date','','','','','','','','','','',0,'','','',0,'Outbound Block Date:','','','','','','','addressBlockOutboundDateLabel',0,'left:254px; top:200px; height:15px; width:150px;','addressBlockOutboundDate Label','','','','','',0,0,0,0,0,'','addressBlockOutboundDate','twistAddress',0,'','','',0),('',0,'',0,'',0,'',0,'','','','',0,'','addressBlockReasonInput',0,0,0,'left:392px; top:225px; height:40px; width:350px;','addressBlockReason Input','','',0,0,'addressDataManagerVirtualPhone','addressBlockReason',0,0,0,74,0,0,'','addressBlockReason','','',0,'','','labelInput',0,'','','','textarea','','','','','','','','','','',0,'','','',0,'Block Reason:','','','','','','','addressBlockReasonLabel',0,'left:302px; top:227px; height:15px; width:150px;','addressBlockReason Label','','','','','',0,0,0,0,0,'','addressBlockReason','twistAddress',0,'','','',0); /*!40000 ALTER TABLE `masterFormItem` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `masterOption` -- DROP TABLE IF EXISTS `masterOption`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `masterOption` ( `masterConfigurationDeletedDateTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `masterConfigurationDeletedMemberID` int(11) DEFAULT '0', `masterConfigurationGUID` varchar(36) NOT NULL, `masterConfigurationID` int(11) NOT NULL AUTO_INCREMENT, `masterConfigurationInsertedDateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `masterConfigurationInsertedMemberID` int(11) DEFAULT '0', `masterConfigurationName` varchar(100) NOT NULL, `masterConfigurationOverview` varchar(500) NOT NULL, `masterConfigurationUpdatedDateTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `masterConfigurationUpdatedMemberID` int(11) DEFAULT '0', `masterConfigurationVersion` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`masterConfigurationID`) ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `masterOption` -- LOCK TABLES `masterOption` WRITE; /*!40000 ALTER TABLE `masterOption` DISABLE KEYS */; INSERT INTO `masterOption` VALUES ('0000-00-00 00:00:00',0,'',1,'2017-08-18 17:40:19',0,'Initialize','Base configuration required for all Twist! instances','0000-00-00 00:00:00',0,2),('0000-00-00 00:00:00',0,'',2,'2017-08-18 17:40:35',0,'Twist! Unify','','0000-00-00 00:00:00',0,2),('0000-00-00 00:00:00',0,'',3,'2017-08-18 17:40:51',0,'Twist! Parter Portal','','0000-00-00 00:00:00',0,2),('0000-00-00 00:00:00',0,'',4,'2017-08-18 17:41:05',0,'Twist! for Real Estate','','0000-00-00 00:00:00',0,2); /*!40000 ALTER TABLE `masterOption` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `masterParameter` -- DROP TABLE IF EXISTS `masterParameter`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `masterParameter` ( `appSpecific` tinyint(1) NOT NULL DEFAULT '0', `clientCustomMetadata` tinyint(1) NOT NULL DEFAULT '0', `clientCustomValue` tinyint(1) NOT NULL DEFAULT '0', `clientDelete` tinyint(1) NOT NULL DEFAULT '0', `clientVisible` tinyint(1) NOT NULL DEFAULT '0', `deletedDateTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `deletedMemberID` int(11) NOT NULL DEFAULT '0', `insertedDateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `insertedMemberID` int(11) NOT NULL DEFAULT '0', `isColor` tinyint(1) NOT NULL DEFAULT '0', `isSkin` tinyint(1) NOT NULL DEFAULT '0', `memberCode` varchar(100) NOT NULL, `memberCustomizable` tinyint(1) NOT NULL DEFAULT '0', `memberID` int(11) NOT NULL DEFAULT '0', `memberSpecific` tinyint(1) NOT NULL DEFAULT '0', `parameterCode` varchar(100) NOT NULL, `parameterID` int(11) NOT NULL AUTO_INCREMENT, `parameterName` varchar(100) NOT NULL, `parameterNamePublic` varchar(100) NOT NULL, `parameterOverview` varchar(500) NOT NULL, `parameterRoleID` int(11) NOT NULL DEFAULT '0', `parameterStatusLookupID` int(11) NOT NULL DEFAULT '0', `parameterTypeLookupID` int(11) NOT NULL DEFAULT '0', `parameterValueDateTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `parameterValueInt` int(11) NOT NULL DEFAULT '0', `parameterValueTinyInt` tinyint(1) NOT NULL DEFAULT '0', `parameterValueType` varchar(20) NOT NULL, `parameterValueVarchar` varchar(500) NOT NULL, `roleSpecific` tinyint(1) NOT NULL DEFAULT '0', `skinCode` varchar(100) NOT NULL, `skinID` int(11) NOT NULL DEFAULT '0', `twistVersionID` int(11) NOT NULL DEFAULT '0', `updatedDateTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `updatedMemberID` int(11) NOT NULL DEFAULT '0', `webPageCode` varchar(100) NOT NULL, `websiteCode` varchar(100) NOT NULL, `websiteID` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`parameterID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `masterParameter` -- LOCK TABLES `masterParameter` WRITE; /*!40000 ALTER TABLE `masterParameter` DISABLE KEYS */; /*!40000 ALTER TABLE `masterParameter` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `masterQuery` -- DROP TABLE IF EXISTS `masterQuery`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `masterQuery` ( `orderByClause` varchar(1000) NOT NULL, `orderByClauseBackup` varchar(1000) NOT NULL, `orderByClauseMasterQueryID` int(11) NOT NULL DEFAULT '0', `orderByClauseMasterQueryCode` varchar(100) NOT NULL, `pagination` varchar(100) NOT NULL, `queryAppCode` varchar(100) NOT NULL, `queryCode` varchar(100) NOT NULL, `queryID` int(11) NOT NULL AUTO_INCREMENT, `queryName` varchar(100) NOT NULL, `queryNamePublic` varchar(100) NOT NULL, `queryOverview` varchar(500) NOT NULL, `queryStatement` varchar(2000) NOT NULL, `queryStatementBackup` varchar(1000) NOT NULL, `queryStatementMasterQueryCode` varchar(100) NOT NULL, `queryTitle` varchar(100) NOT NULL, `queryTypeAppQuick` tinyint(1) NOT NULL DEFAULT '0', `queryTypeAppSearch` tinyint(1) NOT NULL DEFAULT '0', `queryTypeDataManager` tinyint(1) NOT NULL DEFAULT '0', `queryTypeDataManagerSelect` tinyint(1) NOT NULL DEFAULT '0', `queryTypeDefault` tinyint(1) NOT NULL DEFAULT '0', `queryTypeFormItem` tinyint(1) NOT NULL DEFAULT '0', `queryTypeFormSelect` tinyint(1) NOT NULL DEFAULT '0', `queryTypeGlobalQuick` tinyint(1) NOT NULL DEFAULT '0', `queryTypeGlobalSearch` tinyint(1) NOT NULL DEFAULT '0', `queryTypeMassUpdate` tinyint(1) NOT NULL DEFAULT '0', `queryTypeMaster` tinyint(1) NOT NULL DEFAULT '0', `queryTypeMessage` tinyint(1) NOT NULL DEFAULT '0', `queryTypeWeb` tinyint(1) NOT NULL DEFAULT '0', `queryTypeWorkflow` tinyint(1) NOT NULL DEFAULT '0', `queryViewCodeDefault` varchar(100) NOT NULL, `quickQuery` tinyint(1) NOT NULL DEFAULT '0', `quickSearchQuery` tinyint(1) NOT NULL DEFAULT '0', `updatedDateTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `whereClause` varchar(2000) NOT NULL, `whereClauseBackup` varchar(1000) NOT NULL, `whereClauseMasterQueryCode` varchar(100) NOT NULL, PRIMARY KEY (`queryID`) ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `masterQuery` -- LOCK TABLES `masterQuery` WRITE; /*!40000 ALTER TABLE `masterQuery` DISABLE KEYS */; INSERT INTO `masterQuery` VALUES ('','',0,'','','address','dataManagerSectionDataManager',1,'Data Manager Sections Data Manager','Data Manager Sections Data Manager','','SELECT * FROM twistDataManagerSection','','','',0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,'0000-00-00 00:00:00','dataManagerSectionID = [primaryID]','',''),('addressName','',0,'','','address','addressDeleted',2,'Addresses - Deleted','Addresses - Deleted','','SELECT * FROM twistAddress','','','',1,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,'0000-00-00 00:00:00','deletedDateTime \"0000-00-00 00:00:00\"','',''),('addressName','',0,'','','address','addressQuickSearch',3,'Addresses - Quick Search','Addresses - Quick Search','','SELECT * FROM twistAddress','','','',0,1,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,'0000-00-00 00:00:00','(addressName LIKE [quickSearchText] OR addressVirtualText LIKE [quickSearchText] OR concat(addressVirtualPhoneAreaCode,addressVirtualPhonePrefix,addressVirtualPhoneLineNumber) LIKE [quickSearchText]) AND deletedDateTime=\"0000-00-00 00:00:00\"','',''),('','',0,'','','address','addressDataManager',4,'Addresses Data Manager','Addresses Data Manager','','SELECT * FROM twistAddress','','','',0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,'0000-00-00 00:00:00','addressID = [primaryID]','',''),('addr.addressName','',0,'','','address','addressActive',5,'Addresses All Active','All Active','','SELECT * FROM twistAddress AS addr','','','',1,1,0,0,0,0,0,1,1,0,0,0,0,0,'',0,0,'0000-00-00 00:00:00','addr.deletedDateTime = \'0000-00-00 00:00:00\'','',''); /*!40000 ALTER TABLE `masterQuery` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `masterQueryView` -- DROP TABLE IF EXISTS `masterQueryView`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `masterQueryView` ( `queryViewCode` varchar(100) NOT NULL, `queryViewContent` varchar(4000) NOT NULL, `queryViewID` int(11) NOT NULL AUTO_INCREMENT, `queryViewName` varchar(100) NOT NULL, `queryViewNamePublic` varchar(100) NOT NULL, `queryViewOverview` varchar(500) NOT NULL, `queryViewStatusID` int(11) NOT NULL DEFAULT '0', `queryViewTitle` varchar(100) NOT NULL, `queryViewType` varchar(20) NOT NULL, `queryViewTypeDefault` tinyint(1) NOT NULL DEFAULT '0', `queryViewTypeID` int(11) NOT NULL DEFAULT '0', `sqlTableCode` varchar(100) NOT NULL, PRIMARY KEY (`queryViewID`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `masterQueryView` -- LOCK TABLES `masterQueryView` WRITE; /*!40000 ALTER TABLE `masterQueryView` DISABLE KEYS */; INSERT INTO `masterQueryView` VALUES ('addressDefault','',1,'Addresses - Default','Addresses - Default','',0,'','',0,0,''); /*!40000 ALTER TABLE `masterQueryView` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `masterQueryViewItem` -- DROP TABLE IF EXISTS `masterQueryViewItem`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `masterQueryViewItem` ( `cssClass` varchar(100) NOT NULL, `cssID` varchar(100) NOT NULL, `cssStyle` varchar(500) NOT NULL, `displayOrder` smallint(10) NOT NULL, `queryViewCode` varchar(100) NOT NULL, `queryViewItemCode` varchar(100) NOT NULL, `queryViewItemID` int(11) NOT NULL AUTO_INCREMENT, `queryViewItemName` varchar(100) NOT NULL, `queryViewItemNamePublic` varchar(100) NOT NULL, `queryViewItemOverview` varchar(1000) NOT NULL, `queryViewItemSourceCode` varchar(4000) NOT NULL, `queryViewItemStatusID` int(11) NOT NULL DEFAULT '0', `queryViewItemStyleData` varchar(500) NOT NULL, `queryViewItemStyleHeader` varchar(500) NOT NULL, `queryViewItemTitle` varchar(100) NOT NULL, `queryViewItemTypeID` int(11) NOT NULL DEFAULT '0', `sqlColumnCode` varchar(100) NOT NULL, `sqlColumnCodeCustom` varchar(8000) NOT NULL, PRIMARY KEY (`queryViewItemID`) ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `masterQueryViewItem` -- LOCK TABLES `masterQueryViewItem` WRITE; /*!40000 ALTER TABLE `masterQueryViewItem` DISABLE KEYS */; INSERT INTO `masterQueryViewItem` VALUES ('','','',1,'addressDefault','',1,'','','','',0,'','','Address Name',0,'addressName',''),('','','',2,'addressDefault','addressID',2,'addressID','addressID','','echo twistAddressDisplay(\'V1.00\',$rowDataTable[\"addressID\"],\'\');',0,'','','Address Detail',0,'addressID',''),('','','',3,'addressDefault','addressContact',3,'addressContact','addressContact','','echo ($rowDataTable[\"addressContact\"]==1) ? \'Yes\' : \'\';',0,'','','Is Contact?',0,'addressContact',''),('','','',4,'addressDefault','addressInformation',4,'addressInformation','addressInformation','','echo ($rowDataTable[\"addressInformation\"]==1) ? \'Yes\' : \'\';',0,'','','Is Information?',0,'addressInformation',''),('','','',0,'addressDefault','addressContentVersionIDPrimarySmall',5,'addressContentVersionIDPrimarySmall','addressContentVersionIDPrimarySmall','','echo twistPrimaryImageDisplay(\'V1.0\',$rowDataTable[\"addressContentVersionIDPrimarySmall\"],\'\',\'\',$strTwistFolderLocal);',0,'','','Image',0,'addressContentVersionIDPrimarySmall',''); /*!40000 ALTER TABLE `masterQueryViewItem` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `masterSQLColumn` -- DROP TABLE IF EXISTS `masterSQLColumn`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `masterSQLColumn` ( `clientColumn` tinyint(1) NOT NULL DEFAULT '0', `clientVisible` tinyint(1) NOT NULL DEFAULT '0', `customMetadata` tinyint(1) NOT NULL DEFAULT '0', `deletedDateTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `deletedMemberID` int(11) NOT NULL DEFAULT '0', `inputTypeDefault` varchar(20) NOT NULL, `insertedDateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `insertedMemberID` int(11) NOT NULL DEFAULT '0', `sqlColumnCode` varchar(100) NOT NULL, `sqlColumnDefault` varchar(200) NOT NULL, `sqlColumnExtra` varchar(50) NOT NULL, `sqlColumnID` int(11) NOT NULL AUTO_INCREMENT, `sqlColumnKey` varchar(20) NOT NULL, `sqlColumnName` varchar(100) NOT NULL, `sqlColumnNamePublic` varchar(100) NOT NULL, `sqlColumnNull` varchar(3) NOT NULL, `sqlColumnOverview` varchar(500) NOT NULL, `sqlColumnType` varchar(20) NOT NULL, `sqlTableID` int(11) NOT NULL DEFAULT '0', `twistVersion` varchar(10) NOT NULL, `updatedDateTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `updatedMemberID` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`sqlColumnID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `masterSQLColumn` -- LOCK TABLES `masterSQLColumn` WRITE; /*!40000 ALTER TABLE `masterSQLColumn` DISABLE KEYS */; /*!40000 ALTER TABLE `masterSQLColumn` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `masterSQLTable` -- DROP TABLE IF EXISTS `masterSQLTable`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `masterSQLTable` ( `clientTable` tinyint(1) NOT NULL DEFAULT '0', `clientVisible` tinyint(1) NOT NULL DEFAULT '0', `customMetadata` tinyint(1) NOT NULL DEFAULT '0', `deletedDateTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `deletedMemberID` int(11) NOT NULL DEFAULT '0', `insertedDateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `insertedMemberID` int(11) NOT NULL DEFAULT '0', `linkableTable` tinyint(1) NOT NULL DEFAULT '0', `linkDataSQLTableID` int(11) NOT NULL DEFAULT '0', `linkSourceSQLTableID` int(11) NOT NULL DEFAULT '0', `linkTable` tinyint(1) NOT NULL DEFAULT '0', `sqlDatabaseID` int(11) NOT NULL DEFAULT '0', `sqlTableAlias` varchar(100) NOT NULL, `sqlTableCode` varchar(100) NOT NULL, `sqlTableCodeLink` varchar(100) NOT NULL, `sqlTableCodeLinkTitleCase` varchar(100) NOT NULL, `sqlTableGlobalPurge` tinyint(1) NOT NULL DEFAULT '0', `sqlTableID` int(11) NOT NULL AUTO_INCREMENT, `sqlTableName` varchar(100) NOT NULL, `sqlTableNamePublic` varchar(100) NOT NULL, `sqlTableOverview` varchar(500) NOT NULL, `sqlTablePrimaryIDCode` varchar(100) NOT NULL, `twistVersion` varchar(10) NOT NULL, `updatedDateTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `updatedMemberID` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`sqlTableID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `masterSQLTable` -- LOCK TABLES `masterSQLTable` WRITE; /*!40000 ALTER TABLE `masterSQLTable` DISABLE KEYS */; /*!40000 ALTER TABLE `masterSQLTable` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `twistWebSectionType` -- DROP TABLE IF EXISTS `twistWebSectionType`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `twistWebSectionType` ( `dataManagerMemberID` int(11) NOT NULL DEFAULT '0', `dataOwnerMemberID` int(11) NOT NULL DEFAULT '0', `dataOwnerOrganizationID` int(11) NOT NULL DEFAULT '0', `deletedDateTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `deletedMemberID` int(11) DEFAULT '0', `webSectionTypeArchivedDateTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `webSectionTypeArchivedMemberID` int(11) NOT NULL DEFAULT '0', `webSectionTypeCategory` varchar(100) NOT NULL, `webSectionTypeCode` varchar(100) NOT NULL, `webSectionTypeCodeGroup` varchar(100) NOT NULL, `webSectionTypeContainerClass` varchar(200) NOT NULL, `webSectionTypeContainerStyle` varchar(1000) NOT NULL, `webSectionTypeContentClass` varchar(200) NOT NULL, `webSectionTypeContentStyle` varchar(1000) NOT NULL, `webSectionTypeContentVersionIDPrimaryExtraLarge` int(11) NOT NULL DEFAULT '0', `webSectionTypeContentVersionIDPrimaryExtraSmall` int(11) NOT NULL DEFAULT '0', `webSectionTypeContentVersionIDPrimaryLarge` int(11) NOT NULL DEFAULT '0', `webSectionTypeContentVersionIDPrimaryMacro` int(11) NOT NULL DEFAULT '0', `webSectionTypeContentVersionIDPrimaryMedium` int(11) NOT NULL DEFAULT '0', `webSectionTypeContentVersionIDPrimaryMicro` int(11) NOT NULL DEFAULT '0', `webSectionTypeContentVersionIDPrimarySmall` int(11) NOT NULL DEFAULT '0', `webSectionTypeData` varchar(4000) NOT NULL, `webSectionTypeDeletedDateTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `webSectionTypeDeletedMemberID` int(11) DEFAULT '0', `webSectionTypeID` int(11) NOT NULL AUTO_INCREMENT, `webSectionTypeInsertedDateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `webSectionTypeInsertedMemberID` int(11) DEFAULT '0', `webSectionTypeJavascript` varchar(2000) NOT NULL, `webSectionTypeLayoutCode` varchar(100) NOT NULL, `webSectionTypeName` varchar(100) NOT NULL, `webSectionTypeNamePublic` varchar(100) NOT NULL, `webSectionTypeOptions` varchar(4000) NOT NULL, `webSectionTypeOverview` varchar(500) NOT NULL, `webSectionTypeStatusID` int(11) NOT NULL DEFAULT '0', `webSectionTypeTypeID` int(11) NOT NULL DEFAULT '0', `webSectionTypeUpdatedDateTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `webSectionTypeUpdatedMemberID` int(11) DEFAULT '0', `webSectionTypeVersion` int(11) DEFAULT '0', PRIMARY KEY (`webSectionTypeID`) ) ENGINE=MyISAM AUTO_INCREMENT=46 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `twistWebSectionType` -- LOCK TABLES `twistWebSectionType` WRITE; /*!40000 ALTER TABLE `twistWebSectionType` DISABLE KEYS */; INSERT INTO `twistWebSectionType` VALUES (0,0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'accordion','','','','','','',0,0,0,0,0,0,0,'','0000-00-00 00:00:00',0,1,'2017-08-18 18:03:44',0,'','','','','','',0,0,'0000-00-00 00:00:00',0,0),(0,0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'address','address','','','','','',0,0,0,0,0,0,0,'','0000-00-00 00:00:00',0,2,'2017-08-18 18:03:44',0,'','','','','','',0,0,'0000-00-00 00:00:00',0,0),(0,0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'addressList','address-list','','','','','',0,0,0,0,0,0,0,'','0000-00-00 00:00:00',0,3,'2017-08-18 18:03:44',0,'','','','','','',0,0,'0000-00-00 00:00:00',0,0),(0,0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'blogHome','blog-home','','','','','',0,0,0,0,0,0,0,'','0000-00-00 00:00:00',0,4,'2017-08-18 18:03:44',0,'','','','','','',0,0,'0000-00-00 00:00:00',0,0),(0,0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'breadCrumb','bread-crumb','','','','','',0,0,0,0,0,0,0,'','0000-00-00 00:00:00',0,5,'2017-08-18 18:03:44',0,'','','','','','',0,0,'0000-00-00 00:00:00',0,0),(0,0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'callToAction','call-to-action','','','','','',0,0,0,0,0,0,0,'','0000-00-00 00:00:00',0,6,'2017-08-18 18:03:44',0,'','','','','','',0,0,'0000-00-00 00:00:00',0,0),(0,0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'chart','chart','','','','','',0,0,0,0,0,0,0,'','0000-00-00 00:00:00',0,7,'2017-08-18 18:03:44',0,'','','','','','',0,0,'0000-00-00 00:00:00',0,0),(0,0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'chartGroup','chart-group','','','','','',0,0,0,0,0,0,0,'','0000-00-00 00:00:00',0,8,'2017-08-18 18:03:44',0,'','','','','','',0,0,'0000-00-00 00:00:00',0,0),(0,0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'customerDetail','customer-detail','','','','','',0,0,0,0,0,0,0,'','0000-00-00 00:00:00',0,9,'2017-08-18 18:03:44',0,'','','','','','',0,0,'0000-00-00 00:00:00',0,0),(0,0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'customerList','customer-list','','','','','',0,0,0,0,0,0,0,'','0000-00-00 00:00:00',0,10,'2017-08-18 18:03:44',0,'','','','','','',0,0,'0000-00-00 00:00:00',0,0),(0,0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'compare','compare','','','','','',0,0,0,0,0,0,0,'','0000-00-00 00:00:00',0,11,'2017-08-18 18:03:44',0,'','','','','','',0,0,'0000-00-00 00:00:00',0,0),(0,0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'entityLInks','entity-links','','','','','',0,0,0,0,0,0,0,'','0000-00-00 00:00:00',0,12,'2017-08-18 18:03:44',0,'','','','','','',0,0,'0000-00-00 00:00:00',0,0),(0,0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'entityList','entity-list','','','','','',0,0,0,0,0,0,0,'','0000-00-00 00:00:00',0,13,'2017-08-18 18:03:44',0,'','','','','','',0,0,'0000-00-00 00:00:00',0,0),(0,0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'featureList','feature-list','','','','','',0,0,0,0,0,0,0,'','0000-00-00 00:00:00',0,14,'2017-08-18 18:03:44',0,'','','','','','',0,0,'0000-00-00 00:00:00',0,0),(0,0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'form','form','','','','','',0,0,0,0,0,0,0,'','0000-00-00 00:00:00',0,15,'2017-08-18 18:03:44',0,'','','','','','',0,0,'0000-00-00 00:00:00',0,0),(0,0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'html','html','','','','','',0,0,0,0,0,0,0,'','0000-00-00 00:00:00',0,16,'2017-08-18 18:03:44',0,'','','','','','',0,0,'0000-00-00 00:00:00',0,0),(0,0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'image','image','','','','','',0,0,0,0,0,0,0,'','0000-00-00 00:00:00',0,17,'2017-08-18 18:03:44',0,'','','','','','',0,0,'0000-00-00 00:00:00',0,0),(0,0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'imageGallery','image-gallery','','','','','',0,0,0,0,0,0,0,'','0000-00-00 00:00:00',0,18,'2017-08-18 18:03:44',0,'','','','','','',0,0,'0000-00-00 00:00:00',0,0),(0,0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'installationDetail','installation-detail','','','','','',0,0,0,0,0,0,0,'','0000-00-00 00:00:00',0,19,'2017-08-18 18:03:44',0,'','','','','','',0,0,'0000-00-00 00:00:00',0,0),(0,0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'installationList','installation-list','','','','','',0,0,0,0,0,0,0,'','0000-00-00 00:00:00',0,20,'2017-08-18 18:03:44',0,'','','','','','',0,0,'0000-00-00 00:00:00',0,0),(0,0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'jobOpeningDetail','job-opening-detail','','','','','',0,0,0,0,0,0,0,'','0000-00-00 00:00:00',0,21,'2017-08-18 18:03:44',0,'','','','','','',0,0,'0000-00-00 00:00:00',0,0),(0,0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'jobOpeningList','job-opening-list','','','','','',0,0,0,0,0,0,0,'','0000-00-00 00:00:00',0,22,'2017-08-18 18:03:44',0,'','','','','','',0,0,'0000-00-00 00:00:00',0,0),(0,0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'landingPage','landing-page','','','','','',0,0,0,0,0,0,0,'','0000-00-00 00:00:00',0,23,'2017-08-18 18:03:44',0,'','','','','','',0,0,'0000-00-00 00:00:00',0,0),(0,0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'map','map','','','','','',0,0,0,0,0,0,0,'','0000-00-00 00:00:00',0,24,'2017-08-18 18:03:44',0,'','','','','','',0,0,'0000-00-00 00:00:00',0,0),(0,0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'menu','menu','','','','','',0,0,0,0,0,0,0,'','0000-00-00 00:00:00',0,25,'2017-08-18 18:03:44',0,'','','','','','',0,0,'0000-00-00 00:00:00',0,0),(0,0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'newsletterDetail','newsletter-detail','','','','','',0,0,0,0,0,0,0,'','0000-00-00 00:00:00',0,26,'2017-08-18 18:03:44',0,'','','','','','',0,0,'0000-00-00 00:00:00',0,0),(0,0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'newsletterHome','newsletter-home','','','','','',0,0,0,0,0,0,0,'','0000-00-00 00:00:00',0,27,'2017-08-18 18:03:44',0,'','','','','','',0,0,'0000-00-00 00:00:00',0,0),(0,0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'newsletterList','newsletterList','','','','','',0,0,0,0,0,0,0,'','0000-00-00 00:00:00',0,28,'2017-08-18 18:03:44',0,'','','','','','',0,0,'0000-00-00 00:00:00',0,0),(0,0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'personDetail','person-detail','','','','','',0,0,0,0,0,0,0,'','0000-00-00 00:00:00',0,29,'2017-08-18 18:03:44',0,'','','','','','',0,0,'0000-00-00 00:00:00',0,0),(0,0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'personList','person-list','','','','','',0,0,0,0,0,0,0,'','0000-00-00 00:00:00',0,30,'2017-08-18 18:03:44',0,'','','','','','',0,0,'0000-00-00 00:00:00',0,0),(0,0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'postDetail','post-detail','','','','','',0,0,0,0,0,0,0,'','0000-00-00 00:00:00',0,31,'2017-08-18 18:03:44',0,'','','','','','',0,0,'0000-00-00 00:00:00',0,0),(0,0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'postTags','post-tags','','','','','',0,0,0,0,0,0,0,'','0000-00-00 00:00:00',0,32,'2017-08-18 18:03:44',0,'','','','','','',0,0,'0000-00-00 00:00:00',0,0),(0,0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'sitemap','sitemap','','','','','',0,0,0,0,0,0,0,'','0000-00-00 00:00:00',0,33,'2017-08-18 18:03:44',0,'','','','','','',0,0,'0000-00-00 00:00:00',0,0),(0,0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'slider','slider','','','','','',0,0,0,0,0,0,0,'','0000-00-00 00:00:00',0,34,'2017-08-18 18:03:44',0,'','','','','','',0,0,'0000-00-00 00:00:00',0,0),(0,0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'socialLinks','social-links','','','','','',0,0,0,0,0,0,0,'','0000-00-00 00:00:00',0,35,'2017-08-18 18:03:44',0,'','','','','','',0,0,'0000-00-00 00:00:00',0,0),(0,0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'table','table','','','','','',0,0,0,0,0,0,0,'','0000-00-00 00:00:00',0,36,'2017-08-18 18:03:44',0,'','','','','','',0,0,'0000-00-00 00:00:00',0,0),(0,0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'text','text','','','','','',0,0,0,0,0,0,0,'','0000-00-00 00:00:00',0,37,'2017-08-18 18:03:44',0,'','','','','','',0,0,'0000-00-00 00:00:00',0,0),(0,0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'textPlus','text-plus','','','','','',0,0,0,0,0,0,0,'','0000-00-00 00:00:00',0,38,'2017-08-18 18:03:44',0,'','','','','','',0,0,'0000-00-00 00:00:00',0,0),(0,0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'video','video','','','','','',0,0,0,0,0,0,0,'','0000-00-00 00:00:00',0,39,'2017-08-18 18:06:47',0,'','','','','','',0,0,'0000-00-00 00:00:00',0,0),(0,0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'videoGallery','video-gallery','','','','','',0,0,0,0,0,0,0,'','0000-00-00 00:00:00',0,40,'2017-08-18 18:06:47',0,'','','','','','',0,0,'0000-00-00 00:00:00',0,0),(0,0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'webPageTitle','web-page-title','','','','','',0,0,0,0,0,0,0,'','0000-00-00 00:00:00',0,41,'2017-08-18 18:06:47',0,'','','','','','',0,0,'0000-00-00 00:00:00',0,0),(0,0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'websiteFooter','website-footer','','','','','',0,0,0,0,0,0,0,'','0000-00-00 00:00:00',0,42,'2017-08-18 18:06:47',0,'','','','','','',0,0,'0000-00-00 00:00:00',0,0),(0,0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'websiteHeader','website-header','','','','','',0,0,0,0,0,0,0,'','0000-00-00 00:00:00',0,43,'2017-08-18 18:06:47',0,'','','','','','',0,0,'0000-00-00 00:00:00',0,0),(0,0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'websiteSectionFooter','website-section-footer','','','','','',0,0,0,0,0,0,0,'','0000-00-00 00:00:00',0,44,'2017-08-18 18:06:47',0,'','','','','','',0,0,'0000-00-00 00:00:00',0,0),(0,0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'websiteSectionHeader','website-section-header','','','','','',0,0,0,0,0,0,0,'','0000-00-00 00:00:00',0,45,'2017-08-18 18:06:47',0,'','','','','','',0,0,'0000-00-00 00:00:00',0,0); /*!40000 ALTER TABLE `twistWebSectionType` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!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 */; -- Dump completed on 2022-10-17 16:06:13