-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------




--
-- Definition of table `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`
--



--
-- Definition of table `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`
--



--
-- Definition of table `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`
--



--
-- Definition of table `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`
--



--
-- Definition of table `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`
--



--
-- Definition of table `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`
--



--
-- Definition of table `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`
--



--
-- Definition of table `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`
--
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');


--
-- Definition of table `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`),
   KEY `IX_TContent_5` (`ModuleID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tcontent`
--

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


--
-- Definition of table `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`
--

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



--
-- Definition of table `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`
--



--
-- Definition of table `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`
--



--
-- Definition of table `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(100) 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`
--



--
-- Definition of table `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`
--



--
-- Definition of table `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`
--



--
-- Definition of table `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`
--



--
-- Definition of table `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`
--



--
-- Definition of table `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`
--



--
-- Definition of table `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`
--



--
-- Definition of table `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`
--



--
-- Definition of table `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`
--



--
-- Definition of table `temailreturnstats`
--

CREATE TABLE `temailreturnstats` (
  `emailID` char(35) character set utf8 default NULL,
  `email` varchar(100) character set utf8 default NULL,
  `url` mediumtext,
  `created` datetime default NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `temailreturnstats`
--



--
-- Definition of table `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`
--



--
-- Definition of table `temailstats`
--

CREATE TABLE `temailstats` (
  `EmailID` char(35) character set utf8 default NULL,
  `Email` char(100) 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`
--



--
-- Definition of table `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(100) character set utf8 default NULL,
  `contentSubType` varchar(200) 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`
--



--
-- Definition of table `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`
--



--
-- Definition of table `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`
--



--
-- Definition of table `tglobals`
--

CREATE TABLE `tglobals` (
  `appreload` datetime default NULL,
  `loadlist` mediumtext
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tglobals`
--



--
-- Definition of table `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`
--

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


--
-- Definition of table `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`
--



--
-- Definition of table `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`
--



--
-- Definition of table `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`
--



--
-- Definition of table `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`
--

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),
 ('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),
 ('goToFirstChild','default','Go To First Child',23);


--
-- Definition of table `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`
--



--
-- Definition of table `tusersfavorites`
--

CREATE TABLE `tusersfavorites` (
  `favoriteID` char(35) NOT NULL default '',
  `userID` char(35) NOT NULL default '',
  `favoriteName` varchar(100) default NULL,
  `favorite` mediumtext,
  `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`
--



--
-- Definition of table `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`
--



--
-- Definition of table `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`
--



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;


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;


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;


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;


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;


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;


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;


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;

