--
-- Host: localhost    Database: twist_0master
-- ------------------------------------------------------


--
-- Table structure for table `linkMasterOptionApp`
--

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;

--
-- Dumping data for table `linkMasterOptionApp`
--

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);

--
-- Table structure for table `linkMasterOptionDataManager`
--

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;

--
-- Dumping data for table `linkMasterOptionDataManager`
--


--
-- Table structure for table `linkMasterOptionEntityRequest`
--

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;

--
-- Dumping data for table `linkMasterOptionEntityRequest`
--


--
-- Table structure for table `linkMasterOptionParameter`
--

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;

--
-- Dumping data for table `linkMasterOptionParameter`
--


--
-- Table structure for table `linkMasterOptionQuery`
--

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;

--
-- Dumping data for table `linkMasterOptionQuery`
--


--
-- Table structure for table `linkMasterOptionQueryView`
--

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;

--
-- Dumping data for table `linkMasterOptionQueryView`
--


--
-- Table structure for table `linkMasterOptionSQLColumn`
--

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;

--
-- Dumping data for table `linkMasterOptionSQLColumn`
--


--
-- Table structure for table `linkMasterOptionSQLTable`
--

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;

--
-- Dumping data for table `linkMasterOptionSQLTable`
--


--
-- Table structure for table `masterApp`
--

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;

--
-- Dumping data for table `masterApp`
--

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);

--
-- Table structure for table `masterDataManager`
--

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;

--
-- Dumping data for table `masterDataManager`
--

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);

--
-- Table structure for table `masterDataManagerOption`
--

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;

--
-- Dumping data for table `masterDataManagerOption`
--

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,'');

--
-- Table structure for table `masterDataManagerSection`
--

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;

--
-- Dumping data for table `masterDataManagerSection`
--

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,'');

--
-- Table structure for table `masterEntityRequest`
--

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;

--
-- Dumping data for table `masterEntityRequest`
--


--
-- Table structure for table `masterForm`
--

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;

--
-- Dumping data for table `masterForm`
--

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);

--
-- Table structure for table `masterFormItem`
--

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;

--
-- Dumping data for table `masterFormItem`
--

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);

--
-- Table structure for table `masterOption`
--

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;

--
-- Dumping data for table `masterOption`
--

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);

--
-- Table structure for table `masterParameter`
--

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;

--
-- Dumping data for table `masterParameter`
--


--
-- Table structure for table `masterQuery`
--

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;

--
-- Dumping data for table `masterQuery`
--

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\'','','');

--
-- Table structure for table `masterQueryView`
--

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;

--
-- Dumping data for table `masterQueryView`
--

INSERT INTO `masterQueryView` VALUES ('addressDefault','',1,'Addresses - Default','Addresses - Default','',0,'','',0,0,'');

--
-- Table structure for table `masterQueryViewItem`
--

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;

--
-- Dumping data for table `masterQueryViewItem`
--

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','');

--
-- Table structure for table `masterSQLColumn`
--

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;

--
-- Dumping data for table `masterSQLColumn`
--


--
-- Table structure for table `masterSQLTable`
--

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;

--
-- Dumping data for table `masterSQLTable`
--


--
-- Table structure for table `twistWebSectionType`
--

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;

--
-- Dumping data for table `twistWebSectionType`
--

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);


