-- MySQL Administrator dump 1.4 -- -- ------------------------------------------------------ -- Server version 4.1.14-nt /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; -- -- Create schema sava5model_dbo -- /*CREATE DATABASE IF NOT EXISTS sava5model_dbo; USE sava5model_dbo; */ -- -- Definition of table `tadcampaigns` -- DROP TABLE IF EXISTS `tadcampaigns`; CREATE TABLE `tadcampaigns` ( `campaignID` char(35) character set utf8 NOT NULL default '', `userID` char(35) character set utf8 default NULL, `dateCreated` datetime default NULL, `lastUpdate` datetime default NULL, `lastUpdateBy` varchar(50) character set utf8 default NULL, `name` varchar(50) character set utf8 default NULL, `startDate` datetime default NULL, `endDate` datetime default NULL, `isActive` int(10) default NULL, `notes` longtext, PRIMARY KEY (`campaignID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tadcampaigns` -- /*!40000 ALTER TABLE `tadcampaigns` DISABLE KEYS */; /*!40000 ALTER TABLE `tadcampaigns` ENABLE KEYS */; -- -- Definition of table `tadcreatives` -- DROP TABLE IF EXISTS `tadcreatives`; CREATE TABLE `tadcreatives` ( `creativeID` char(35) character set utf8 NOT NULL default '', `userID` char(35) character set utf8 default NULL, `dateCreated` datetime default NULL, `lastUpdate` datetime default NULL, `lastUpdateBy` varchar(50) character set utf8 default NULL, `name` varchar(50) character set utf8 default NULL, `creativeType` varchar(50) character set utf8 default NULL, `fileID` varchar(35) character set utf8 default NULL, `mediaType` varchar(50) character set utf8 default NULL, `redirectURL` varchar(200) character set utf8 default NULL, `altText` varchar(200) character set utf8 default NULL, `notes` longtext, `isActive` int(10) default NULL, `height` int(10) default NULL, `width` int(10) default NULL, `textBody` longtext, PRIMARY KEY (`creativeID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tadcreatives` -- /*!40000 ALTER TABLE `tadcreatives` DISABLE KEYS */; /*!40000 ALTER TABLE `tadcreatives` ENABLE KEYS */; -- -- Definition of table `tadipwhitelist` -- DROP TABLE IF EXISTS `tadipwhitelist`; CREATE TABLE `tadipwhitelist` ( `IP` varchar(50) character set utf8 NOT NULL default '', `siteID` varchar(50) character set utf8 NOT NULL default '' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tadipwhitelist` -- /*!40000 ALTER TABLE `tadipwhitelist` DISABLE KEYS */; /*!40000 ALTER TABLE `tadipwhitelist` ENABLE KEYS */; -- -- Definition of table `tadplacementdetails` -- DROP TABLE IF EXISTS `tadplacementdetails`; CREATE TABLE `tadplacementdetails` ( `detailID` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, `placementID` char(35) character set utf8 NOT NULL default '', `PlacementType` char(35) character set utf8 NOT NULL default '', `PlacementValue` int(10) NOT NULL default '0', PRIMARY KEY (`detailID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tadplacementdetails` -- /*!40000 ALTER TABLE `tadplacementdetails` DISABLE KEYS */; /*!40000 ALTER TABLE `tadplacementdetails` ENABLE KEYS */; -- -- Definition of table `tadplacements` -- DROP TABLE IF EXISTS `tadplacements`; CREATE TABLE `tadplacements` ( `placementID` char(35) character set utf8 NOT NULL default '', `campaignID` char(35) character set utf8 default NULL, `adZoneID` char(35) character set utf8 default NULL, `creativeID` char(35) character set utf8 default NULL, `dateCreated` datetime default NULL, `lastUpdate` datetime default NULL, `lastUpdateBy` varchar(50) character set utf8 default NULL, `startDate` datetime default NULL, `endDate` datetime default NULL, `costPerImp` decimal(18,5) default NULL, `costPerClick` decimal(18,2) default NULL, `isExclusive` int(10) default NULL, `billable` decimal(18,2) default NULL, `budget` int(10) default NULL, `isActive` int(10) default NULL, `notes` longtext, PRIMARY KEY (`placementID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tadplacements` -- /*!40000 ALTER TABLE `tadplacements` DISABLE KEYS */; /*!40000 ALTER TABLE `tadplacements` ENABLE KEYS */; -- -- Definition of table `tadstats` -- DROP TABLE IF EXISTS `tadstats`; CREATE TABLE `tadstats` ( `statID` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, `PlacementID` char(35) character set utf8 default NULL, `StatHour` int(10) default NULL, `StatDate` datetime default NULL, `Type` varchar(50) character set utf8 default NULL, `counter` int(10) default NULL, PRIMARY KEY (`statID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tadstats` -- /*!40000 ALTER TABLE `tadstats` DISABLE KEYS */; /*!40000 ALTER TABLE `tadstats` ENABLE KEYS */; -- -- Definition of table `tadzones` -- DROP TABLE IF EXISTS `tadzones`; CREATE TABLE `tadzones` ( `adZoneID` char(35) character set utf8 NOT NULL default '', `siteID` varchar(25) character set utf8 default NULL, `dateCreated` datetime default NULL, `lastUpdate` datetime default NULL, `lastUpdateBy` varchar(50) character set utf8 default NULL, `name` varchar(50) character set utf8 default NULL, `creativeType` varchar(50) character set utf8 default NULL, `notes` longtext, `isActive` int(10) default NULL, `height` int(10) default NULL, `width` int(10) default NULL, PRIMARY KEY (`adZoneID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tadzones` -- /*!40000 ALTER TABLE `tadzones` DISABLE KEYS */; /*!40000 ALTER TABLE `tadzones` ENABLE KEYS */; -- -- Definition of table `tcaptcha` -- DROP TABLE IF EXISTS `tcaptcha`; CREATE TABLE `tcaptcha` ( `LetterID` int(10) NOT NULL default '0', `Letter` char(1) default NULL, `ImageFile` varchar(50) default NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tcaptcha` -- /*!40000 ALTER TABLE `tcaptcha` DISABLE KEYS */; INSERT INTO `tcaptcha` (`LetterID`,`Letter`,`ImageFile`) VALUES (1,'a','a.gif'), (2,'b','b.gif'), (3,'c','c.gif'), (4,'d','d.gif'), (5,'e','e.gif'), (6,'f','f.gif'), (7,'g','g.gif'), (8,'h','h.gif'), (9,'i','i.gif'), (10,'j','j.gif'), (11,'k','k.gif'), (12,'l','l.gif'), (13,'m','m.gif'), (14,'n','n.gif'), (15,'o','o.gif'), (16,'p','p.gif'), (17,'q','q.gif'), (18,'r','r.gif'), (19,'s','s.gif'), (20,'t','t.gif'), (21,'u','u.gif'), (22,'v','v.gif'), (23,'w','w.gif'), (24,'x','x.gif'), (25,'y','y.gif'), (26,'z','z.gif'); /*!40000 ALTER TABLE `tcaptcha` ENABLE KEYS */; -- -- Definition of table `tcontent` -- DROP TABLE IF EXISTS `tcontent`; CREATE TABLE `tcontent` ( `TContent_ID` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, `SiteID` varchar(25) character set utf8 default NULL, `ModuleID` char(35) character set utf8 default NULL, `ParentID` char(35) character set utf8 default NULL, `ContentID` char(35) character set utf8 default NULL, `ContentHistID` char(35) character set utf8 default NULL, `RemoteID` varchar(255) character set utf8 default NULL, `RemoteURL` varchar(255) character set utf8 default NULL, `RemotePubDate` varchar(50) character set utf8 default NULL, `RemoteSourceURL` varchar(255) character set utf8 default NULL, `RemoteSource` varchar(255) character set utf8 default NULL, `Credits` varchar(255) character set utf8 default NULL, `FileID` char(35) character set utf8 default NULL, `Template` varchar(50) character set utf8 default NULL, `Type` varchar(25) character set utf8 default NULL, `subType` varchar(25) character set utf8 default NULL, `Active` tinyint(3) default '0', `OrderNo` int(10) default NULL, `Title` varchar(255) character set utf8 default NULL, `MenuTitle` varchar(255) character set utf8 default NULL, `Summary` longtext, `Filename` varchar(255) character set utf8 default NULL, `MetaDesc` longtext, `MetaKeyWords` longtext, `Body` longtext, `lastUpdate` datetime default NULL, `lastUpdateBy` varchar(50) character set utf8 default NULL, `lastUpdateByID` varchar(50) character set utf8 default NULL, `DisplayStart` datetime default NULL, `DisplayStop` datetime default NULL, `Display` tinyint(3) default NULL, `Approved` tinyint(3) default NULL, `IsNav` tinyint(3) default NULL, `Restricted` tinyint(3) default NULL, `RestrictGroups` varchar(255) character set utf8 default NULL, `Target` varchar(50) character set utf8 default NULL, `TargetParams` varchar(255) character set utf8 default NULL, `responseChart` tinyint(3) default NULL, `responseMessage` longtext, `responseSendTo` longtext, `responseDisplayFields` longtext, `moduleAssign` varchar(255) character set utf8 default NULL, `displayTitle` tinyint(3) default NULL, `Notes` longtext, `inheritObjects` varchar(25) character set utf8 default NULL, `isFeature` tinyint(3) default NULL, `ReleaseDate` datetime default NULL, `IsLocked` tinyint(3) default NULL, `nextN` int(10) default NULL, `sortBy` varchar(50) character set utf8 default NULL, `sortDirection` varchar(50) character set utf8 default NULL, `featureStart` datetime default NULL, `featureStop` datetime default NULL, `forceSSL` tinyint(3) NOT NULL default '0', `audience` longtext, `keyPoints` longtext, `searchExclude` tinyint(3) default NULL, `path` longtext, `tags` longtext, PRIMARY KEY (`TContent_ID`), KEY `IX_TContent` (`ContentID`), KEY `IX_TContent_1` (`ContentHistID`), KEY `IX_TContent_2` (`SiteID`), KEY `IX_TContent_3` (`ParentID`), KEY `IX_TContent_4` (`RemoteID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tcontent` -- /*!40000 ALTER TABLE `tcontent` DISABLE KEYS */; INSERT INTO `tcontent` (`SiteID`,`ModuleID`,`ParentID`,`ContentID`,`ContentHistID`,`RemoteID`,`RemoteURL`,`RemotePubDate`,`RemoteSourceURL`,`RemoteSource`,`Credits`,`FileID`,`Template`,`Type`,`subType`,`Active`,`OrderNo`,`Title`,`MenuTitle`,`Summary`,`Filename`,`MetaDesc`,`MetaKeyWords`,`Body`,`lastUpdate`,`lastUpdateBy`,`lastUpdateByID`,`DisplayStart`,`DisplayStop`,`Display`,`Approved`,`IsNav`,`Restricted`,`RestrictGroups`,`Target`,`TargetParams`,`responseChart`,`responseMessage`,`responseSendTo`,`responseDisplayFields`,`moduleAssign`,`displayTitle`,`Notes`,`inheritObjects`,`isFeature`,`ReleaseDate`,`IsLocked`,`nextN`,`sortBy`,`sortDirection`,`featureStart`,`featureStop`,`forceSSL`,`audience`,`keyPoints`,`searchExclude`,`path`) VALUES ('default','00000000000000000000000000000000003','00000000000000000000000000000000END','00000000000000000000000000000000003','6300ED4A-1320-5CC3-F9D6A2D279E386D0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Module','Default',1,NULL,'Components',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL), ('default','00000000000000000000000000000000004','00000000000000000000000000000000END','00000000000000000000000000000000004','6300ED59-1320-5CC3-F9706221E0EFF7A2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Module','Default',1,NULL,'Forms',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,NULL), ('default','00000000000000000000000000000000000','00000000000000000000000000000000END','00000000000000000000000000000000001','6300ED69-1320-5CC3-F922E3012E2C6BAE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'default.cfm','Page','Default',1,1,'Home Page','Home Page',NULL,NULL,NULL,NULL,NULL,now(),'System',NULL,NULL,NULL,1,1,1,0,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,NULL,'Cascade',0,NULL,0,10,'orderno','asc',NULL,NULL,0,NULL,NULL,0,'\'00000000000000000000000000000000001\''), ('default','00000000000000000000000000000000006','00000000000000000000000000000000END','00000000000000000000000000000000006','6300ED79-1320-5CC3-F92E6325C26664B6',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Module','Default',1,NULL,'Advertising',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,NULL), ('default','00000000000000000000000000000000000','00000000000000000000000000000000END','00000000000000000000000000000000000','6300ED88-1320-5CC3-F9E241684D21FEC9',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Module','Default',1,NULL,'Site Manager',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,NULL), ('default','00000000000000000000000000000000008','00000000000000000000000000000000END','00000000000000000000000000000000008','6300ED98-1320-5CC3-F9398EB23A57CBD0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Module','Default',1,NULL,'Site Members',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,NULL), ('default','00000000000000000000000000000000005','00000000000000000000000000000000END','00000000000000000000000000000000005','6300EDA8-1320-5CC3-F93DF074187C935E',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Module','Default',1,NULL,'Email Broadcaster',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,NULL), ('default','00000000000000000000000000000000009','00000000000000000000000000000000END','00000000000000000000000000000000009','6300EDB7-1320-5CC3-F9D664F38EBBD2D0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Module','Default',1,NULL,'Mailing Lists',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,NULL), ('default','00000000000000000000000000000000010','00000000000000000000000000000000END','00000000000000000000000000000000010','6300EDC7-1320-5CC3-F9DB8034C9626B70',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Module','Default',1,NULL,'Categories',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,NULL), ('default','00000000000000000000000000000000011','00000000000000000000000000000000END','00000000000000000000000000000000011','6300EDD6-1320-5CC3-F9625545444B880F',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Module','Default',1,NULL,'Content Collections',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,NULL), ('default','00000000000000000000000000000000012','00000000000000000000000000000000END','00000000000000000000000000000000012','6300EDE6-1320-5CC3-F94E2FCEF5DE046D',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Module','Default',1,NULL,'Filemanager Manager',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,NULL); /*!40000 ALTER TABLE `tcontent` ENABLE KEYS */; -- -- Definition of table `tcontentstats` -- DROP TABLE IF EXISTS `tcontentstats`; CREATE TABLE `tcontentstats` ( `contentID` char(35) NOT NULL default '', `siteID` varchar(25) NOT NULL default '', `views` int(10) unsigned NOT NULL default '0', `rating` float NOT NULL default '0', `totalVotes` int(10) unsigned NOT NULL default '0', `upVotes` int(10) unsigned NOT NULL default '0', `downVotes` int(10) unsigned NOT NULL default '0', `comments` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`contentID`,`siteID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Definition of table `tcontentassignments` -- DROP TABLE IF EXISTS `tcontentassignments`; CREATE TABLE `tcontentassignments` ( `contentID` char(35) NOT NULL default '', `contentHistID` char(35) NOT NULL default '', `siteID` varchar(25) character set utf8 NOT NULL default '', `userID` char(35) NOT NULL default '', PRIMARY KEY (`contentID`,`contentHistID`,`siteID`,`userID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tcontentassignments` -- /*!40000 ALTER TABLE `tcontentassignments` DISABLE KEYS */; /*!40000 ALTER TABLE `tcontentassignments` ENABLE KEYS */; -- -- Definition of table `tcontentcategories` -- DROP TABLE IF EXISTS `tcontentcategories`; CREATE TABLE `tcontentcategories` ( `categoryID` char(35) character set utf8 NOT NULL default '', `siteID` varchar(25) character set utf8 default NULL, `parentID` char(35) character set utf8 default NULL, `dateCreated` datetime default NULL, `lastUpdate` datetime default NULL, `lastUpdateBy` varchar(50) character set utf8 default NULL, `name` varchar(50) character set utf8 default NULL, `notes` longtext, `isInterestGroup` int(10) default NULL, `isActive` int(10) default NULL, `isOpen` int(10) default NULL, `sortBy` varchar(50) default NULL, `sortDirection` varchar(50) default NULL, `restrictGroups` varchar(255) character set utf8 default NULL, `path` longtext, PRIMARY KEY (`categoryID`), KEY `IX_TContentCategories` (`siteID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tcontentcategories` -- /*!40000 ALTER TABLE `tcontentcategories` DISABLE KEYS */; /*!40000 ALTER TABLE `tcontentcategories` ENABLE KEYS */; -- -- Definition of table `tcontentcategoryassign` -- DROP TABLE IF EXISTS `tcontentcategoryassign`; CREATE TABLE `tcontentcategoryassign` ( `contentHistID` char(35) character set utf8 NOT NULL default '', `categoryID` char(35) character set utf8 NOT NULL default '', `contentID` char(35) character set utf8 default NULL, `isFeature` int(10) default NULL, `orderno` int(10) default NULL, `siteID` varchar(50) character set utf8 default NULL, `featureStart` datetime default NULL, `featureStop` datetime default NULL, PRIMARY KEY (`contentHistID`,`categoryID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tcontentcategoryassign` -- /*!40000 ALTER TABLE `tcontentcategoryassign` DISABLE KEYS */; /*!40000 ALTER TABLE `tcontentcategoryassign` ENABLE KEYS */; -- -- Definition of table `tcontentcomments` -- DROP TABLE IF EXISTS `tcontentcomments`; CREATE TABLE `tcontentcomments` ( `commentid` char(35) character set utf8 NOT NULL default '', `contentid` char(35) character set utf8 default NULL, `contenthistid` char(35) character set utf8 default NULL, `url` varchar(50) character set utf8 default NULL, `name` varchar(50) character set utf8 default NULL, `comments` longtext, `entered` datetime default NULL, `email` varchar(50) character set utf8 default NULL, `siteid` varchar(25) character set utf8 default NULL, `ip` varchar(50) character set utf8 default NULL, `isApproved` tinyint(3) default '0', PRIMARY KEY (`commentid`), KEY `IX_TContentComments` (`contentid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tcontentcomments` -- /*!40000 ALTER TABLE `tcontentcomments` DISABLE KEYS */; /*!40000 ALTER TABLE `tcontentcomments` ENABLE KEYS */; -- -- Definition of table `tcontentdisplaytitleapprovals` -- DROP TABLE IF EXISTS `tcontentdisplaytitleapprovals`; CREATE TABLE `tcontentdisplaytitleapprovals` ( `contentid` char(35) character set utf8 NOT NULL default '', `isApproved` tinyint(3) default NULL, `email` varchar(150) character set utf8 default NULL, `siteid` varchar(25) character set utf8 default NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tcontentdisplaytitleapprovals` -- /*!40000 ALTER TABLE `tcontentdisplaytitleapprovals` DISABLE KEYS */; /*!40000 ALTER TABLE `tcontentdisplaytitleapprovals` ENABLE KEYS */; -- -- Definition of table `tcontenteventreminders` -- DROP TABLE IF EXISTS `tcontenteventreminders`; CREATE TABLE `tcontenteventreminders` ( `contentId` char(35) character set utf8 NOT NULL default '', `siteId` varchar(35) character set utf8 NOT NULL default '', `email` varchar(200) character set utf8 NOT NULL default '', `RemindDate` datetime default NULL, `RemindHour` int(10) default NULL, `RemindMinute` int(10) default NULL, `RemindInterval` int(10) default NULL, `isSent` int(10) default NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tcontenteventreminders` -- /*!40000 ALTER TABLE `tcontenteventreminders` DISABLE KEYS */; /*!40000 ALTER TABLE `tcontenteventreminders` ENABLE KEYS */; -- -- Definition of table `tcontentfeedadvancedparams` -- DROP TABLE IF EXISTS `tcontentfeedadvancedparams`; CREATE TABLE `tcontentfeedadvancedparams` ( `paramID` char(35) NOT NULL default '', `feedID` char(35) NOT NULL default '', `param` decimal(18,0) default NULL, `relationship` varchar(50) character set utf8 default NULL, `field` varchar(100) character set utf8 default NULL, `condition` varchar(50) character set utf8 default NULL, `criteria` varchar(200) character set utf8 default NULL, `dataType` varchar(50) character set utf8 default NULL, PRIMARY KEY (`paramID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tcontentfeedadvancedparams` -- /*!40000 ALTER TABLE `tcontentfeedadvancedparams` DISABLE KEYS */; /*!40000 ALTER TABLE `tcontentfeedadvancedparams` ENABLE KEYS */; -- -- Definition of table `tcontentfeeditems` -- DROP TABLE IF EXISTS `tcontentfeeditems`; CREATE TABLE `tcontentfeeditems` ( `feedID` char(35) NOT NULL default '', `itemID` char(35) NOT NULL default '', `type` varchar(50) default NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tcontentfeeditems` -- /*!40000 ALTER TABLE `tcontentfeeditems` DISABLE KEYS */; /*!40000 ALTER TABLE `tcontentfeeditems` ENABLE KEYS */; -- -- Definition of table `tcontentfeeds` -- DROP TABLE IF EXISTS `tcontentfeeds`; CREATE TABLE `tcontentfeeds` ( `feedID` char(35) NOT NULL default '', `siteID` varchar(35) default NULL, `parentID` char(35) default NULL, `name` varchar(250) default NULL, `isActive` tinyint(3) default NULL, `isPublic` tinyint(3) default NULL, `isDefault` tinyint(3) default NULL, `isFeaturesOnly` tinyint(3) default NULL, `description` longtext, `maxItems` int(10) default NULL, `allowHTML` tinyint(3) default NULL, `lang` varchar(50) default NULL, `lastUpdateBy` varchar(100) default NULL, `lastUpdate` datetime default NULL, `dateCreated` datetime default NULL, `restricted` tinyint(3) default NULL, `restrictGroups` longtext, `version` varchar(50) default NULL, `channelLink` varchar(250) default NULL, `Type` varchar(50) default NULL, `sortBy` varchar(50) default NULL, `sortDirection` varchar(50) default NULL, `nextN` int(10) default NULL, `displayName` tinyint(3) default NULL, `displayRatings` tinyint(3) default NULL, `displayComments` tinyint(3) default NULL, PRIMARY KEY (`feedID`), KEY `IX_TContentFeeds` (`siteID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tcontentfeeds` -- /*!40000 ALTER TABLE `tcontentfeeds` DISABLE KEYS */; /*!40000 ALTER TABLE `tcontentfeeds` ENABLE KEYS */; -- -- Definition of table `tcontentobjects` -- DROP TABLE IF EXISTS `tcontentobjects`; CREATE TABLE `tcontentobjects` ( `ContentHistID` char(35) NOT NULL default '', `ObjectID` varchar(100) NOT NULL default '', `Object` varchar(50) NOT NULL default '', `ContentID` char(35) default NULL, `Name` varchar(255) default NULL, `OrderNo` int(10) default NULL, `SiteID` varchar(25) default NULL, `ColumnID` int(10) default NULL, PRIMARY KEY (`ContentHistID`,`ObjectID`,`Object`,`ColumnID` ), KEY `IX_TContentObjects` (`SiteID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tcontentobjects` -- /*!40000 ALTER TABLE `tcontentobjects` DISABLE KEYS */; /*!40000 ALTER TABLE `tcontentobjects` ENABLE KEYS */; -- -- Definition of table `tcontentratings` -- DROP TABLE IF EXISTS `tcontentratings`; CREATE TABLE `tcontentratings` ( `contentID` char(35) NOT NULL default '', `userID` char(35) character set utf8 NOT NULL default '', `siteID` varchar(35) character set utf8 NOT NULL default '', `rate` int(10) default NULL, `entered` timestamp NULL default CURRENT_TIMESTAMP, PRIMARY KEY (`contentID`,`userID`,`siteID`), KEY `IDX_ENTERED` (`entered`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tcontentratings` -- /*!40000 ALTER TABLE `tcontentratings` DISABLE KEYS */; /*!40000 ALTER TABLE `tcontentratings` ENABLE KEYS */; -- -- Definition of table `tcontentrelated` -- DROP TABLE IF EXISTS `tcontentrelated`; CREATE TABLE `tcontentrelated` ( `contentHistID` char(35) NOT NULL default '', `relatedID` char(35) NOT NULL default '', `contentID` char(35) NOT NULL default '', `siteID` varchar(25) NOT NULL default '', PRIMARY KEY (`contentHistID`,`relatedID`,`contentID`,`siteID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tcontentrelated` -- /*!40000 ALTER TABLE `tcontentrelated` DISABLE KEYS */; /*!40000 ALTER TABLE `tcontentrelated` ENABLE KEYS */; -- -- Definition of table `temailreturnstats` -- DROP TABLE IF EXISTS `temailreturnstats`; CREATE TABLE `temailreturnstats` ( `emailID` char(35) character set utf8 default NULL, `email` varchar(50) character set utf8 default NULL, `url` mediumtext, `created` datetime default NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `temailreturnstats` -- /*!40000 ALTER TABLE `temailreturnstats` DISABLE KEYS */; /*!40000 ALTER TABLE `temailreturnstats` ENABLE KEYS */; -- -- Definition of table `temails` -- DROP TABLE IF EXISTS `temails`; CREATE TABLE `temails` ( `EmailID` char(35) character set utf8 NOT NULL default '', `siteid` varchar(25) character set utf8 default NULL, `Subject` varchar(255) character set utf8 default NULL, `BodyText` longtext, `BodyHtml` longtext, `CreatedDate` datetime default NULL, `DeliveryDate` datetime default NULL, `status` tinyint(3) default NULL, `GroupList` longtext, `LastUpdateBy` varchar(50) character set utf8 default NULL, `LastUpdateByID` varchar(35) character set utf8 default NULL, `NumberSent` int(10) NOT NULL default '0', `ReplyTo` varchar(50) character set utf8 default NULL, `format` varchar(50) character set utf8 default NULL, `fromLabel` varchar(50) character set utf8 default NULL, `isDeleted` tinyint(1) NOT NULL default '0', PRIMARY KEY (`EmailID`), KEY `IX_TEmails` (`siteid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `temails` -- /*!40000 ALTER TABLE `temails` DISABLE KEYS */; /*!40000 ALTER TABLE `temails` ENABLE KEYS */; -- -- Definition of table `temailstats` -- DROP TABLE IF EXISTS `temailstats`; CREATE TABLE `temailstats` ( `EmailID` char(35) character set utf8 default NULL, `Email` char(35) character set utf8 default NULL, `emailOpen` int(10) NOT NULL default '0', `returnClick` int(10) NOT NULL default '0', `bounce` int(10) NOT NULL default '0', `sent` int(10) NOT NULL default '0', `Created` datetime default NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `temailstats` -- /*!40000 ALTER TABLE `temailstats` DISABLE KEYS */; /*!40000 ALTER TABLE `temailstats` ENABLE KEYS */; -- -- Definition of table `tfiles` -- DROP TABLE IF EXISTS `tfiles`; CREATE TABLE `tfiles` ( `fileID` char(35) character set utf8 NOT NULL default '', `contentID` char(35) character set utf8 default NULL, `siteID` varchar(25) character set utf8 default NULL, `moduleID` char(35) character set utf8 default NULL, `filename` varchar(200) character set utf8 default NULL, `image` longblob, `imageSmall` longblob, `imageMedium` longblob, `fileSize` int(10) default NULL, `contentType` varchar(50) character set utf8 default NULL, `contentSubType` varchar(150) character set utf8 default NULL, `fileExt` varchar(50) character set utf8 default NULL, `created` datetime default NULL, PRIMARY KEY (`fileID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tfiles` -- /*!40000 ALTER TABLE `tfiles` DISABLE KEYS */; /*!40000 ALTER TABLE `tfiles` ENABLE KEYS */; -- -- Definition of table `tformresponsepackets` -- DROP TABLE IF EXISTS `tformresponsepackets`; CREATE TABLE `tformresponsepackets` ( `ResponseID` char(35) character set utf8 NOT NULL default '', `FormID` char(35) character set utf8 default NULL, `SiteID` varchar(25) character set utf8 default NULL, `FieldList` longtext, `Data` longtext, `Entered` datetime default NULL, PRIMARY KEY (`ResponseID`), KEY `IX_TFormResponsePackets` (`FormID`,`SiteID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tformresponsepackets` -- /*!40000 ALTER TABLE `tformresponsepackets` DISABLE KEYS */; /*!40000 ALTER TABLE `tformresponsepackets` ENABLE KEYS */; -- -- Definition of table `tformresponsequestions` -- DROP TABLE IF EXISTS `tformresponsequestions`; CREATE TABLE `tformresponsequestions` ( `responseID` char(35) character set utf8 default NULL, `formID` char(35) character set utf8 default NULL, `formField` varchar(50) character set utf8 default NULL, `formValue` longtext, `pollValue` varchar(255) character set utf8 default NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tformresponsequestions` -- /*!40000 ALTER TABLE `tformresponsequestions` DISABLE KEYS */; /*!40000 ALTER TABLE `tformresponsequestions` ENABLE KEYS */; -- -- Definition of table `tglobals` -- DROP TABLE IF EXISTS `tglobals`; CREATE TABLE `tglobals` ( `appreload` datetime default NULL, `loadlist` mediumtext ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tglobals` -- /*!40000 ALTER TABLE `tglobals` DISABLE KEYS */; /*!40000 ALTER TABLE `tglobals` ENABLE KEYS */; -- -- Definition of table `tmailinglist` -- DROP TABLE IF EXISTS `tmailinglist`; CREATE TABLE `tmailinglist` ( `MLID` char(35) character set utf8 default NULL, `SiteID` varchar(25) character set utf8 default NULL, `Name` varchar(50) character set utf8 default NULL, `Description` longtext, `LastUpdate` datetime default NULL, `isPurge` int(10) default NULL, `isPublic` int(10) default NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tmailinglist` -- /*!40000 ALTER TABLE `tmailinglist` DISABLE KEYS */; INSERT INTO `tmailinglist` (`MLID`,`SiteID`,`Name`,`Description`,`LastUpdate`,`isPurge`,`isPublic`) VALUES ('22FC551F-FABE-EA01-C6EDD0885DDC1680','default','Please Remove Me from All Lists','',now(),1,1); /*!40000 ALTER TABLE `tmailinglist` ENABLE KEYS */; -- -- Definition of table `tmailinglistmembers` -- DROP TABLE IF EXISTS `tmailinglistmembers`; CREATE TABLE `tmailinglistmembers` ( `MLID` char(35) character set utf8 default NULL, `Email` varchar(100) character set utf8 default NULL, `SiteID` varchar(25) character set utf8 default NULL, `fname` varchar(50) character set utf8 default NULL, `lname` varchar(50) character set utf8 default NULL, `company` varchar(50) character set utf8 default NULL, `isVerified` tinyint(1) NOT NULL default '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tmailinglistmembers` -- /*!40000 ALTER TABLE `tmailinglistmembers` DISABLE KEYS */; /*!40000 ALTER TABLE `tmailinglistmembers` ENABLE KEYS */; -- -- Definition of table `tpermissions` -- DROP TABLE IF EXISTS `tpermissions`; CREATE TABLE `tpermissions` ( `ContentID` char(35) character set utf8 default NULL, `GroupID` char(35) character set utf8 default NULL, `SiteID` varchar(25) character set utf8 default NULL, `Type` varchar(50) character set utf8 default NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tpermissions` -- /*!40000 ALTER TABLE `tpermissions` DISABLE KEYS */; /*!40000 ALTER TABLE `tpermissions` ENABLE KEYS */; -- -- Definition of table `tredirects` -- DROP TABLE IF EXISTS `tredirects`; CREATE TABLE `tredirects` ( `redirectID` char(35) NOT NULL default '', `URL` mediumtext, `created` datetime default NULL, PRIMARY KEY (`redirectID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tredirects` -- /*!40000 ALTER TABLE `tredirects` DISABLE KEYS */; /*!40000 ALTER TABLE `tredirects` ENABLE KEYS */; -- -- Definition of table `tsessiontracking` -- DROP TABLE IF EXISTS `tsessiontracking`; CREATE TABLE `tsessiontracking` ( `trackingID` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, `contentID` char(35) character set utf8 default NULL, `siteID` varchar(25) character set utf8 default NULL, `userid` char(35) character set utf8 default NULL, `remote_addr` varchar(50) character set utf8 default NULL, `server_name` varchar(50) character set utf8 default NULL, `query_string` mediumtext, `referer` varchar(255) character set utf8 default NULL, `user_agent` varchar(200) character set utf8 default NULL, `script_name` varchar(200) character set utf8 default NULL, `urlToken` varchar(130) character set utf8 NOT NULL default '', `entered` datetime NOT NULL default '0000-00-00 00:00:00', `country` varchar(50) character set utf8 default NULL, `lang` varchar(50) character set utf8 default NULL, `locale` varchar(50) character set utf8 default NULL, `keywords` varchar(200) character set utf8 default NULL, `originalUrlToken` varchar(130) character set utf8 default NULL, PRIMARY KEY (`trackingID`), KEY `IDX_ENTERED` (`entered`), KEY `IX_TSessionTracking` (`siteID`), KEY `IX_TSessionTracking_1` (`contentID`), KEY `IX_TSessionTracking_2` (`urlToken`), KEY `IX_TSessionTracking_3` (`userID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tsessiontracking` -- /*!40000 ALTER TABLE `tsessiontracking` DISABLE KEYS */; /*!40000 ALTER TABLE `tsessiontracking` ENABLE KEYS */; -- -- Definition of table `tsettings` -- DROP TABLE IF EXISTS `tsettings`; CREATE TABLE `tsettings` ( `SiteID` varchar(25) character set utf8 default NULL, `Site` varchar(50) character set utf8 default NULL, `MaxNestLevel` int(10) default NULL, `PageLimit` int(10) default NULL, `Locking` varchar(50) character set utf8 default NULL, `Domain` varchar(50) character set utf8 default NULL, `exportLocation` varchar(100) character set utf8 default NULL, `FileDir` varchar(50) character set utf8 default NULL, `Contact` varchar(50) character set utf8 default NULL, `MailserverIP` varchar(50) character set utf8 default NULL, `MailServerUsername` varchar(50) character set utf8 default NULL, `MailServerPassword` varchar(50) character set utf8 default NULL, `EmailBroadcaster` int(10) default NULL, `Extranet` int(10) default NULL, `ExtranetPublicReg` int(10) default NULL, `ExtranetPublicRegNotify` varchar(50) character set utf8 default NULL, `ExtranetSSL` int(10) default NULL, `Cache` int(10) default NULL, `ViewDepth` int(10) default NULL, `NextN` int(10) default NULL, `DataCollection` int(10) default NULL, `columnCount` int(10) default NULL, `columnNames` varchar(255) character set utf8 default NULL, `primaryColumn` int(10) default NULL, `publicSubmission` int(10) default NULL, `AdManager` int(10) default NULL, `archiveDate` datetime default NULL, `contactName` varchar(50) character set utf8 default NULL, `contactAddress` varchar(50) character set utf8 default NULL, `contactCity` varchar(50) character set utf8 default NULL, `contactState` varchar(50) character set utf8 default NULL, `contactZip` varchar(50) character set utf8 default NULL, `contactEmail` varchar(50) character set utf8 default NULL, `contactPhone` varchar(50) character set utf8 default NULL, `privateUserPoolID` varchar(50) character set utf8 default NULL, `publicUserPoolID` varchar(50) character set utf8 default NULL, `advertiserUserPoolID` varchar(50) character set utf8 default NULL, `orderNo` int(10) default NULL, `emailBroadcasterLimit` int(10) NOT NULL default '0', `feedManager` int(10) default NULL, `displayPoolID` varchar(50) character set utf8 default NULL, `galleryMainScaleBy` varchar(50) character set utf8 default NULL, `galleryMainScale` int(10) default NULL, `gallerySmallScaleBy` varchar(50) character set utf8 default NULL, `gallerySmallScale` int(10) default NULL, `galleryMediumScaleBy` varchar(50) character set utf8 default NULL, `galleryMediumScale` int(10) default NULL, `sendLoginScript` longtext, `mailingListConfirmScript` longtext, `publicSubmissionApprovalScript` longtext, `reminderScript` longtext, `loginURL` varchar(255) default NULL, `editProfileURL` varchar(255) default NULL, `CommentApprovalDefault` tinyint(3) default NULL, `deploy` tinyint(3) default NULL, `lastDeployment` datetime default NULL, `accountActivationScript` longtext, `googleAPIKey` varchar(100) default NULL, `useDefaultSMTPServer` tinyint(3) default NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tsettings` -- /*!40000 ALTER TABLE `tsettings` DISABLE KEYS */; INSERT INTO `tsettings` (`SiteID`,`Site`,`MaxNestLevel`,`PageLimit`,`Locking`,`Domain`,`exportLocation`,`FileDir`,`Contact`,`MailserverIP`,`MailServerUsername`,`MailServerPassword`,`EmailBroadcaster`,`Extranet`,`ExtranetPublicReg`,`ExtranetPublicRegNotify`,`ExtranetSSL`,`Cache`,`ViewDepth`,`NextN`,`DataCollection`,`columnCount`,`columnNames`,`primaryColumn`,`publicSubmission`,`AdManager`,`archiveDate`,`contactName`,`contactAddress`,`contactCity`,`contactState`,`contactZip`,`contactEmail`,`contactPhone`,`privateUserPoolID`,`publicUserPoolID`,`advertiserUserPoolID`,`orderNo`,`emailBroadcasterLimit`,`feedManager`,`displayPoolID`,`galleryMainScaleBy`,`galleryMainScale`,`gallerySmallScaleBy`,`gallerySmallScale`,`galleryMediumScaleBy`,`galleryMediumScale`,`sendLoginScript`,`mailingListConfirmScript`,`publicSubmissionApprovalScript`,`reminderScript`,`loginURL`,`editProfileURL`,`CommentApprovalDefault`,`deploy`,`lastDeployment`,`accountActivationScript`,`useDefaultSMTPServer`) VALUES ('default','Default',NULL,1000,'none','localhost','export1',NULL,'info@gosava.com','mail.server.com','username@server.com','password',1,1,1,NULL,0,0,1,20,1,3,'Left Column^Main Content^Right Column',2,0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'default','default','default',1,0,1,'default','y',100,'y',100,'y',100,NULL,NULL,NULL,NULL,'index.cfm?display=login','index.cfm?display=editProfile',1,0,NULL,NULL,0); /*!40000 ALTER TABLE `tsettings` ENABLE KEYS */; -- -- Definition of table `tsystemobjects` -- DROP TABLE IF EXISTS `tsystemobjects`; CREATE TABLE `tsystemobjects` ( `Object` varchar(50) character set utf8 default NULL, `SiteID` varchar(25) character set utf8 default NULL, `Name` varchar(50) character set utf8 default NULL, `OrderNo` int(10) default NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tsystemobjects` -- /*!40000 ALTER TABLE `tsystemobjects` DISABLE KEYS */; INSERT INTO `tsystemobjects` (`Object`,`SiteID`,`Name`,`OrderNo`) VALUES ('event_reminder_form','default','Event Reminder Form',12), ('forward_email','default','Forward Email',13), ('site_map','default','Site Map',2), ('peer_nav','default','Peer Navigation',3), ('sub_nav','default','Sub Navigation',4), ('standard_nav','default','Standard Navigation',5), ('portal_nav','default','Portal Navigation',6), ('comments','default','Accept Comments',9), ('seq_nav','default','Sequential Nav',8), ('payPalCart','default','PayPal Shopping Cart',14), ('rater','default','Content Rater',16), ('favorites','default','User Favorites',17), ('dragable_feeds','default','Dragable Feeds',18), ('related_content','default','Related Content',19), ('user_tools','default','User Tools',20), ('tag_cloud','default','Tag Cloud',21), ('IASiteMap','default','IA Site Map',22), ('goToFirstChild','default','Go To First Child',23); /*!40000 ALTER TABLE `tsystemobjects` ENABLE KEYS */; -- -- Definition of table `tuseraddresses` -- DROP TABLE IF EXISTS `tuseraddresses`; CREATE TABLE `tuseraddresses` ( `addressID` char(35) NOT NULL default '', `userID` char(35) default NULL, `siteID` varchar(25) character set utf8 default NULL, `addressName` varchar(50) character set utf8 default NULL, `address1` varchar(50) character set utf8 default NULL, `address2` varchar(50) character set utf8 default NULL, `city` varchar(50) character set utf8 default NULL, `state` varchar(50) character set utf8 default NULL, `zip` varchar(50) character set utf8 default NULL, `country` varchar(50) character set utf8 default NULL, `phone` varchar(50) character set utf8 default NULL, `fax` varchar(50) character set utf8 default NULL, `isPrimary` tinyint(3) default NULL, `addressNotes` longtext, `addressURL` varchar(200) character set utf8 default NULL, `longitude` float default NULL, `latitude` float default NULL, `addressEmail` varchar(100) character set utf8 default NULL, `hours` longtext, PRIMARY KEY (`addressID`), INDEX `Index_2`(`longitude`), INDEX `Index_3`(`latitude`), INDEX `Index_4`(`userID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tuseraddresses` -- /*!40000 ALTER TABLE `tuseraddresses` DISABLE KEYS */; /*!40000 ALTER TABLE `tuseraddresses` ENABLE KEYS */; -- -- Definition of table `tusers` -- DROP TABLE IF EXISTS `tusers`; CREATE TABLE `tusers` ( `UserID` char(35) character set utf8 NOT NULL default '', `GroupName` varchar(50) character set utf8 default NULL, `Fname` varchar(50) character set utf8 default NULL, `Lname` varchar(50) character set utf8 default NULL, `UserName` varchar(50) character set utf8 default NULL, `Password` varchar(50) character set utf8 default NULL, `PasswordCreated` datetime default NULL, `Email` varchar(50) character set utf8 default NULL, `Company` varchar(50) character set utf8 default NULL, `JobTitle` varchar(50) character set utf8 default NULL, `mobilePhone` varchar(50) character set utf8 default NULL, `Website` varchar(255) character set utf8 default NULL, `Type` int(10) default NULL, `subType` varchar(50) character set utf8 default NULL, `Ext` int(10) default NULL, `ContactForm` longtext, `Admin` int(10) default NULL, `S2` int(10) default NULL, `LastLogin` datetime default NULL, `LastUpdate` datetime default NULL, `LastUpdateBy` varchar(50) character set utf8 default NULL, `LastUpdateByID` varchar(35) character set utf8 default NULL, `Perm` tinyint(3) default NULL, `InActive` tinyint(3) default NULL, `isPublic` int(10) default NULL, `SiteID` varchar(50) character set utf8 default NULL, `Subscribe` int(10) default NULL, `notes` longtext, `description` longtext, `interests` longtext, `keepPrivate` tinyint(3) default NULL, `photoFileID` varchar(35) default NULL, `IMName` varchar(100) character set utf8 default NULL, `IMService` varchar(50) character set utf8 default NULL, `created` timestamp NULL default CURRENT_TIMESTAMP, `remoteID` varchar(35) default NULL, `tags` longtext, PRIMARY KEY (`userID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tusers` -- /*!40000 ALTER TABLE `tusers` DISABLE KEYS */; INSERT INTO `tusers` (`UserID`,`GroupName`,`Fname`,`Lname`,`UserName`,`Password`,`PasswordCreated`,`Email`,`Company`,`JobTitle`,`mobilePhone`,`Website`,`Type`,`subType`,`Ext`,`ContactForm`,`Admin`,`S2`,`LastLogin`,`LastUpdate`,`LastUpdateBy`,`LastUpdateByID`,`Perm`,`InActive`,`isPublic`,`SiteID`,`Subscribe`,`notes`,`description`,`interests`,`keepPrivate`,`photoFileID`,`IMName`,`IMService`,`created`,`remoteID`,`tags`) VALUES ('22FC551F-FABE-EA01-C6EDD0885DDC1682',NULL,'Admin','User','admin','21232F297A57A5A743894A0E4A801FC3',now(),'admin@localhost.com',NULL,NULL,NULL,NULL,2,'Default',NULL,NULL,NULL,1,now(),now(),'System','22FC551F-FABE-EA01-C6EDD0885DDC1682',0,0,0,'default',0,NULL,NULL,NULL,0,NULL,NULL,NULL,now(),NULL,NULL), ('6300EE15-1320-5CC2-F9F48B9DBBA54D9F','Admin',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'Default',NULL,NULL,NULL,0,NULL,now(),'System',NULL,1,0,0,'default',0,NULL,NULL,NULL,0,NULL,NULL,NULL,now(),NULL,NULL); /*!40000 ALTER TABLE `tusers` ENABLE KEYS */; -- -- Definition of table `tusersfavorites` -- DROP TABLE IF EXISTS `tusersfavorites`; CREATE TABLE `tusersfavorites` ( `favoriteID` char(35) NOT NULL default '', `userID` char(35) NOT NULL default '', `favoriteName` varchar(100) default NULL, `favorite` mediumtext NOT NULL, `type` varchar(30) NOT NULL default '', `siteID` varchar(35) default NULL, `dateCreated` timestamp NOT NULL default CURRENT_TIMESTAMP, `columnNumber` int(10) default NULL, `rowNumber` int(10) default NULL, `maxRSSItems` int(10) default NULL, PRIMARY KEY (`favoriteID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tusersfavorites` -- /*!40000 ALTER TABLE `tusersfavorites` DISABLE KEYS */; /*!40000 ALTER TABLE `tusersfavorites` ENABLE KEYS */; -- -- Definition of table `tusersinterests` -- DROP TABLE IF EXISTS `tusersinterests`; CREATE TABLE `tusersinterests` ( `userID` char(35) character set utf8 NOT NULL default '', `categoryID` char(35) character set utf8 NOT NULL default '', PRIMARY KEY (`userID`,`categoryID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tusersinterests` -- /*!40000 ALTER TABLE `tusersinterests` DISABLE KEYS */; /*!40000 ALTER TABLE `tusersinterests` ENABLE KEYS */; -- -- Definition of table `tusersmemb` -- DROP TABLE IF EXISTS `tusersmemb`; CREATE TABLE `tusersmemb` ( `UserID` char(35) character set utf8 NOT NULL default '', `GroupID` char(35) character set utf8 NOT NULL default '', PRIMARY KEY (`UserID`,`GroupID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tusersmemb` -- /*!40000 ALTER TABLE `tusersmemb` DISABLE KEYS */; /*!40000 ALTER TABLE `tusersmemb` ENABLE KEYS */; DROP TABLE IF EXISTS `tcontentpublicsubmissionapprovals`; CREATE TABLE `tcontentpublicsubmissionapprovals` ( `contentID` char(35) NOT NULL default '', `isApproved` int(10) unsigned NOT NULL, `email` varchar(150) NOT NULL, `siteID` varchar(25) NOT NULL, PRIMARY KEY USING BTREE (`contentID`,`siteID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `tcontenttags`; CREATE TABLE `tcontenttags` ( `tagID` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, `contentID` CHAR(35) NOT NULL, `contentHistID` CHAR(35) NOT NULL, `siteID` VARCHAR(25) NOT NULL, `tag` VARCHAR(100) NOT NULL, PRIMARY KEY (`tagID`), INDEX `Index_2`(`contentHistID`), INDEX `Index_3`(`siteID`), INDEX `Index_4`(`contentID`), INDEX `Index_5`(`tag`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `tuserstags`; CREATE TABLE `tuserstags` ( `tagID` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, `userID` CHAR(35) NOT NULL, `siteID` VARCHAR(25) NOT NULL, `tag` VARCHAR(100) NOT NULL, PRIMARY KEY (`tagID`), INDEX `Index_2`(`userID`), INDEX `Index_3`(`siteID`), INDEX `Index_4`(`tag`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `tclassextenddatauseractivity`; CREATE TABLE `tclassextenddatauseractivity` ( `dataID` INTEGER NOT NULL AUTO_INCREMENT, `baseID` char (35) NOT NULL , `attributeID`INTEGER NOT NULL , `siteID` varchar (25) NULL , `attributeValue` longtext, INDEX `Index_2`(`baseID`), INDEX `Index_3`(`attributeID`), PRIMARY KEY (`dataID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `tclassextenddata`; CREATE TABLE `tclassextenddata` ( `dataID` INTEGER NOT NULL AUTO_INCREMENT, `baseID` char (35) NOT NULL , `attributeID` INTEGER NOT NULL , `siteID` varchar (25) NULL , `attributeValue` longtext, INDEX `Index_2`(`baseID`), INDEX `Index_3`(`attributeID`), PRIMARY KEY (`dataID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `tclassextend`; CREATE TABLE `tclassextend` ( `subTypeID` char (35) NOT NULL , `siteID` varchar (25) NULL , `baseTable` varchar (50) NULL , `baseKeyField` varchar (50) NULL , `dataTable` varchar (50) NULL , `type` varchar (50) NULL , `subType` varchar (50) NULL , `isActive` tinyint(3) NULL , `notes` longtext , `lastUpdate` datetime NULL , `dateCreated` datetime NULL , `lastUpdateBy` varchar (100) NULL , PRIMARY KEY (`subTypeID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `tclassextendattributes`; CREATE TABLE `tclassextendattributes` ( `attributeID` INTEGER NOT NULL AUTO_INCREMENT, `extendSetID` char (35) NULL , `siteID` varchar (25) NULL , `name` varchar (100) NULL , `label` text NULL , `hint` text NULL , `type` varchar (100) NULL , `orderno` int NULL , `isActive` tinyint(3) NULL , `required` varchar(50) NULL , `validation` varchar (50) NULL , `regex` text NULL , `message` text NULL , `defaultValue` varchar (100) NULL , `optionList` longtext , `optionLabelList` longtext, INDEX `Index_2`(`extendSetID`), PRIMARY KEY (`attributeID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `tclassextendsets`; CREATE TABLE `tclassextendsets` ( `extendSetID` char(35) NOT NULL , `subTypeID` char(35) NULL , `categoryID` longtext , `siteID` varchar (25) NULL , `name` varchar(50) NULL , `orderno` int NULL , `isActive` tinyint(3) NULL, INDEX `Index_2`(`subTypeID`), PRIMARY KEY (`extendSetID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;