--
-- 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`
--



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


