Compare report

Structure	mojo.db.config	Portalmojo.db.config
Connection	mojo.db.config	Portalmojo.db.config
ID	sqlite_jdbc-19d4e780f60-2f2bfe7c2d733428	sqlite_jdbc-19d4ad5fda6-e80c4d53045bb2c
Name	mojo.db.config	Portalmojo.db.config
Database	C:\___Fire\SqliteMojo\Web\Data\sqlitedb\mojo.db.config	C:\___Fire\mojoportal\Web\Data\sqlitedb\mojo.db.config
URL	jdbc:sqlite:C:\___Fire\SqliteMojo\Web\Data\sqlitedb\mojo.db.config	jdbc:sqlite:C:\___Fire\mojoportal\Web\Data\sqlitedb\mojo.db.config
Tables	Tables	Tables
Table	mp_Blogs	mp_Blogs
Definition	CREATE TABLE `mp_Blogs` ( `ItemID` INTEGER PRIMARY KEY, `ModuleID` INTEGER NOT NULL default '0', `CreatedByUser` varchar(100) NOT NULL default '', `CreatedDate` datetime NOT NULL default '0000-00-00 00:00:00', `Title` varchar(100) default NULL, `Excerpt` text NOT NULL, `StartDate` datetime NOT NULL default '0000-00-00 00:00:00', `IsInNewsletter` INTEGER NOT NULL default '0', `Description` text NOT NULL, `CommentCount` INTEGER NOT NULL default '0', `TrackBackCount` INTEGER NOT NULL default '0', `Category` varchar(50) default NULL, `IncludeInFeed` INTEGER default '1', `AllowCommentsForDays` INTEGER default '0' , BlogGuid VARCHAR(36), ModuleGuid VARCHAR(36), Location text, UserGuid VARCHAR(36), LastModUserGuid VARCHAR(36), LastModUtc datetime, ItemUrl VARCHAR(255), `Heading` VARCHAR(255), `MetaKeywords` VARCHAR(255), `MetaDescription` VARCHAR(255), `Abstract` text, `CompiledMeta` text, `IsPublished` INTEGER);	CREATE TABLE `mp_Blogs` ( `ItemID` INTEGER PRIMARY KEY, `ModuleID` INTEGER NOT NULL default '0', `CreatedByUser` varchar(100) NOT NULL default '', `CreatedDate` datetime NOT NULL default '0000-00-00 00:00:00', `Title` varchar(100) default NULL, `Excerpt` text NOT NULL, `StartDate` datetime NOT NULL default '0000-00-00 00:00:00', `IsInNewsletter` INTEGER NOT NULL default '0', `Description` text NOT NULL, `CommentCount` INTEGER NOT NULL default '0', `TrackBackCount` INTEGER NOT NULL default '0', `Category` varchar(50) default NULL, `IncludeInFeed` INTEGER default '1', `AllowCommentsForDays` INTEGER default '0' , BlogGuid VARCHAR(36), ModuleGuid VARCHAR(36), Location text, UserGuid VARCHAR(36), LastModUserGuid VARCHAR(36), LastModUtc datetime, ItemUrl VARCHAR(255), `Heading` VARCHAR(255), `MetaKeywords` VARCHAR(255), `MetaDescription` VARCHAR(255), `Abstract` text, `CompiledMeta` text, `IsPublished` INTEGER, `SubTitle` varchar(500), `EndDate` datetime NULL, `Approved` INTEGER, `ApprovedDate` datetime NULL, `ApprovedBy` varchar(36), `ShowAuthorName` INTEGER, `ShowAuthorAvatar` INTEGER, `ShowAuthorBio` INTEGER, `IncludeInSearch` INTEGER, `IncludeInSiteMap` INTEGER, `UseBingMap` INTEGER, `MapHeight` varchar(10), `MapWidth` varchar(10), `ShowMapOptions` INTEGER, `ShowZoomTool` INTEGER, `ShowLocationInfo` INTEGER, `UseDrivingDirections` INTEGER, `MapType` varchar(20), `MapZoom` INTEGER, `ShowDownloadLink` INTEGER, `ExcludeFromRecentContent` INTEGER NOT NULL default 0, `IncludeInNews` INTEGER, `PubName` varchar(255), `PubLanguage` varchar(7), `PubAccess` varchar(20), `PubGenres` varchar(255), `PubKeyWords` varchar(255), `PubGeoLocations` varchar(255), `PubStockTickers` varchar(255), `HeadlineImageUrl` varchar(255), `IncludeImageInExcerpt` INTEGER);
Columns	Columns	Columns
Column	N/A	SubTitle
Column	N/A	EndDate
Column	N/A	Approved
Column	N/A	ApprovedDate
Column	N/A	ApprovedBy
Column	N/A	ShowAuthorName
Column	N/A	ShowAuthorAvatar
Column	N/A	ShowAuthorBio
Column	N/A	IncludeInSearch
Column	N/A	IncludeInSiteMap
Column	N/A	UseBingMap
Column	N/A	MapHeight
Column	N/A	MapWidth
Column	N/A	ShowMapOptions
Column	N/A	ShowZoomTool
Column	N/A	ShowLocationInfo
Column	N/A	UseDrivingDirections
Column	N/A	MapType
Column	N/A	MapZoom
Column	N/A	ShowDownloadLink
Column	N/A	ExcludeFromRecentContent
Column	N/A	IncludeInNews
Column	N/A	PubName
Column	N/A	PubLanguage
Column	N/A	PubAccess
Column	N/A	PubGenres
Column	N/A	PubKeyWords
Column	N/A	PubGeoLocations
Column	N/A	PubStockTickers
Column	N/A	HeadlineImageUrl
Column	N/A	IncludeImageInExcerpt
Table	mp_CommerceReport	mp_CommerceReport
Definition	CREATE TABLE `mp_CommerceReport` ( `RowGuid` varchar(36) NOT NULL PRIMARY KEY, `SiteGuid` varchar(36) NOT NULL, `UserGuid` varchar(36) NOT NULL, `FeatureGuid` varchar(36) NOT NULL, `ModuleGuid` varchar(36) NOT NULL, `ModuleTitle` varchar(255) NULL, `OrderGuid` varchar(36) NOT NULL, `ItemGuid` varchar(36) NOT NULL, `ItemName` varchar(255) NULL, `Quantity` INTEGER NOT NULL, `Price` Decimal(15,4) NOT NULL, `SubTotal` Decimal(15,4) NOT NULL, `OrderDateUtc` datetime NOT NULL, `PaymentMethod` varchar(50) NULL, `IPAddress` varchar(250) NULL, `AdminOrderLink` varchar(255) NOT NULL, `UserOrderLink` varchar(255) NOT NULL, `RowCreatedUtc` datetime NOT NULL ); CREATE INDEX idxCRSiteGuid ON mp_CommerceReport(`SiteGuid`); CREATE INDEX idxCRUserGuid ON mp_CommerceReport(`UserGuid`); CREATE INDEX idxCRModuleGuid ON mp_CommerceReport(`ModuleGuid`); CREATE INDEX idxCRItemGuid ON mp_CommerceReport(`ItemGuid`);	CREATE TABLE `mp_CommerceReport` ( `RowGuid` varchar(36) NOT NULL PRIMARY KEY, `SiteGuid` varchar(36) NOT NULL, `UserGuid` varchar(36) NOT NULL, `FeatureGuid` varchar(36) NOT NULL, `ModuleGuid` varchar(36) NOT NULL, `ModuleTitle` varchar(255) NULL, `OrderGuid` varchar(36) NOT NULL, `ItemGuid` varchar(36) NOT NULL, `ItemName` varchar(255) NULL, `Quantity` INTEGER NOT NULL, `Price` Decimal(15,4) NOT NULL, `SubTotal` Decimal(15,4) NOT NULL, `OrderDateUtc` datetime NOT NULL, `PaymentMethod` varchar(50) NULL, `IPAddress` varchar(250) NULL, `AdminOrderLink` varchar(255) NOT NULL, `UserOrderLink` varchar(255) NOT NULL, `RowCreatedUtc` datetime NOT NULL , `IncludeInAggregate` INTEGER NOT NULL default 1); CREATE INDEX idxCRSiteGuid ON mp_CommerceReport(`SiteGuid`); CREATE INDEX idxCRUserGuid ON mp_CommerceReport(`UserGuid`); CREATE INDEX idxCRModuleGuid ON mp_CommerceReport(`ModuleGuid`); CREATE INDEX idxCRItemGuid ON mp_CommerceReport(`ItemGuid`);
Columns	Columns	Columns
Column	N/A	IncludeInAggregate
Table	mp_CommerceReportOrders	mp_CommerceReportOrders
Definition	CREATE TABLE `mp_CommerceReportOrders` ( `RowGuid` varchar(36) NOT NULL PRIMARY KEY, `SiteGuid` varchar(36) NOT NULL, `FeatureGuid` varchar(36) NOT NULL, `ModuleGuid` varchar(36) NOT NULL, `UserGuid` varchar(36) NOT NULL, `OrderGuid` varchar(36) NOT NULL, `BillingFirstName` varchar(100) NULL, `BillingLastName` varchar(50) NULL, `BillingCompany` varchar(255) NULL, `BillingAddress1` varchar(255) NULL, `BillingAddress2` varchar(255) NULL, `BillingSuburb` varchar(255) NULL, `BillingCity` varchar(255) NULL, `BillingPostalCode` varchar(20) NULL, `BillingState` varchar(255) NULL, `BillingCountry` varchar(255) NULL, `PaymentMethod` varchar(50) NULL, `SubTotal` Decimal NOT NULL, `TaxTotal` Decimal NOT NULL, `ShippingTotal` Decimal NOT NULL, `OrderTotal` Decimal NOT NULL, `OrderDateUtc` datetime NOT NULL, `AdminOrderLink` varchar(255) NOT NULL, `UserOrderLink` varchar(255) NOT NULL, `RowCreatedUtc` datetime NOT NULL ); CREATE INDEX idxCROSiteGuid ON mp_CommerceReportOrders(`SiteGuid`); CREATE INDEX idxCROUserGuid ON mp_CommerceReportOrders(`UserGuid`); CREATE INDEX idxCROModuleGuid ON mp_CommerceReportOrders(`ModuleGuid`); CREATE INDEX idxCROOrderGuid ON mp_CommerceReportOrders(`OrderGuid`); CREATE INDEX idxCROCity ON mp_CommerceReportOrders(`BillingCity`); CREATE INDEX idxCROState ON mp_CommerceReportOrders(`BillingState`); CREATE INDEX idxCROCountry ON mp_CommerceReportOrders(`BillingCountry`); CREATE INDEX idxCROPostalCode ON mp_CommerceReportOrders(`BillingPostalCode`); CREATE INDEX idxCROPaymentMethod ON mp_CommerceReportOrders(`PaymentMethod`);	CREATE TABLE `mp_CommerceReportOrders` ( `RowGuid` varchar(36) NOT NULL PRIMARY KEY, `SiteGuid` varchar(36) NOT NULL, `FeatureGuid` varchar(36) NOT NULL, `ModuleGuid` varchar(36) NOT NULL, `UserGuid` varchar(36) NOT NULL, `OrderGuid` varchar(36) NOT NULL, `BillingFirstName` varchar(100) NULL, `BillingLastName` varchar(50) NULL, `BillingCompany` varchar(255) NULL, `BillingAddress1` varchar(255) NULL, `BillingAddress2` varchar(255) NULL, `BillingSuburb` varchar(255) NULL, `BillingCity` varchar(255) NULL, `BillingPostalCode` varchar(20) NULL, `BillingState` varchar(255) NULL, `BillingCountry` varchar(255) NULL, `PaymentMethod` varchar(50) NULL, `SubTotal` Decimal NOT NULL, `TaxTotal` Decimal NOT NULL, `ShippingTotal` Decimal NOT NULL, `OrderTotal` Decimal NOT NULL, `OrderDateUtc` datetime NOT NULL, `AdminOrderLink` varchar(255) NOT NULL, `UserOrderLink` varchar(255) NOT NULL, `RowCreatedUtc` datetime NOT NULL , `IncludeInAggregate` INTEGER NOT NULL default 1); CREATE INDEX idxCROSiteGuid ON mp_CommerceReportOrders(`SiteGuid`); CREATE INDEX idxCROUserGuid ON mp_CommerceReportOrders(`UserGuid`); CREATE INDEX idxCROModuleGuid ON mp_CommerceReportOrders(`ModuleGuid`); CREATE INDEX idxCROOrderGuid ON mp_CommerceReportOrders(`OrderGuid`); CREATE INDEX idxCROCity ON mp_CommerceReportOrders(`BillingCity`); CREATE INDEX idxCROState ON mp_CommerceReportOrders(`BillingState`); CREATE INDEX idxCROCountry ON mp_CommerceReportOrders(`BillingCountry`); CREATE INDEX idxCROPostalCode ON mp_CommerceReportOrders(`BillingPostalCode`); CREATE INDEX idxCROPaymentMethod ON mp_CommerceReportOrders(`PaymentMethod`);
Columns	Columns	Columns
Column	N/A	IncludeInAggregate
Table	mp_FileAttachment	mp_FileAttachment
Definition	CREATE TABLE `mp_FileAttachment` ( `RowGuid` varchar(36) NOT NULL PRIMARY KEY, `SiteGuid` varchar(36) NOT NULL, `ModuleGuid` varchar(36) NOT NULL, `ItemGuid` varchar(36) NOT NULL, `SpecialGuid1` varchar(36) NOT NULL, `SpecialGuid2` varchar(36) NOT NULL, `ServerFileName` varchar(255) NOT NULL, `FileName` varchar(255) NOT NULL, `CreatedUtc` datetime NOT NULL, `CreatedBy` varchar(36) NOT NULL ); CREATE INDEX idxFASiteGuid ON mp_FileAttachment(`SiteGuid`); CREATE INDEX idxFAModuleGuid ON mp_FileAttachment(`ModuleGuid`); CREATE INDEX idxFAItemGuid ON mp_FileAttachment(`ItemGuid`); CREATE INDEX idxFASpecialGuid1 ON mp_FileAttachment(`SpecialGuid1`); CREATE INDEX idxFASpecialGuid2 ON mp_FileAttachment(`SpecialGuid2`);	CREATE TABLE `mp_FileAttachment` ( `RowGuid` varchar(36) NOT NULL PRIMARY KEY, `SiteGuid` varchar(36) NOT NULL, `ModuleGuid` varchar(36) NOT NULL, `ItemGuid` varchar(36) NOT NULL, `SpecialGuid1` varchar(36) NOT NULL, `SpecialGuid2` varchar(36) NOT NULL, `ServerFileName` varchar(255) NOT NULL, `FileName` varchar(255) NOT NULL, `CreatedUtc` datetime NOT NULL, `CreatedBy` varchar(36) NOT NULL , `ContentLength` int, `ContentType` varchar(36), `ContentTitle` varchar(255)); CREATE INDEX idxFASiteGuid ON mp_FileAttachment(`SiteGuid`); CREATE INDEX idxFAModuleGuid ON mp_FileAttachment(`ModuleGuid`); CREATE INDEX idxFAItemGuid ON mp_FileAttachment(`ItemGuid`); CREATE INDEX idxFASpecialGuid1 ON mp_FileAttachment(`SpecialGuid1`); CREATE INDEX idxFASpecialGuid2 ON mp_FileAttachment(`SpecialGuid2`);
Columns	Columns	Columns
Column	N/A	ContentLength
Column	N/A	ContentType
Column	N/A	ContentTitle
Table	mp_ForumPosts	mp_ForumPosts
Definition	CREATE TABLE `mp_ForumPosts` ( `PostID` INTEGER PRIMARY KEY, `ThreadID` INTEGER NOT NULL default '0', `ThreadSequence` INTEGER NOT NULL default '1', `Subject` varchar(255) NOT NULL default '', `PostDate` datetime NOT NULL default '0000-00-00 00:00:00', `Approved` INTEGER NOT NULL default '1', `UserID` INTEGER NOT NULL default '0', `SortOrder` INTEGER NOT NULL default '100', `Post` text NOT NULL ); CREATE INDEX idxforumpostuid ON mp_ForumPosts(`UserID`);	CREATE TABLE `mp_ForumPosts` ( `PostID` INTEGER PRIMARY KEY, `ThreadID` INTEGER NOT NULL default '0', `ThreadSequence` INTEGER NOT NULL default '1', `Subject` varchar(255) NOT NULL default '', `PostDate` datetime NOT NULL default '0000-00-00 00:00:00', `Approved` INTEGER NOT NULL default '1', `UserID` INTEGER NOT NULL default '0', `SortOrder` INTEGER NOT NULL default '100', `Post` text NOT NULL , `PostGuid` varchar(36), `AnswerVotes` INTEGER, `ApprovedBy` varchar(36), `ApprovedUtc` datetime, `UserIp` varchar(50), `NotificationSent` INTEGER default 1, `ModStatus` INTEGER default '1'); CREATE INDEX idxforumpostuid ON mp_ForumPosts(`UserID`);
Columns	Columns	Columns
Column	N/A	PostGuid
Column	N/A	AnswerVotes
Column	N/A	ApprovedBy
Column	N/A	ApprovedUtc
Column	N/A	UserIp
Column	N/A	NotificationSent
Column	N/A	ModStatus
Table	mp_Forums	mp_Forums
Definition	CREATE TABLE `mp_Forums` ( `ItemID` INTEGER PRIMARY KEY, `ModuleID` INTEGER NOT NULL default '0', `CreatedDate` datetime NOT NULL default '0000-00-00 00:00:00', `CreatedBy` INTEGER NOT NULL default '0', `Title` varchar(100) NOT NULL default '', `Description` text NOT NULL, `IsModerated` INTEGER NOT NULL default '0', `IsActive` INTEGER NOT NULL default '0', `SortOrder` INTEGER NOT NULL default '100', `ThreadCount` INTEGER NOT NULL default '0', `PostCount` INTEGER NOT NULL default '0', `MostRecentPostDate` datetime default NULL, `MostRecentPostUserID` INTEGER NOT NULL default '0', `PostsPerPage` INTEGER NOT NULL default '10', `ThreadsPerPage` INTEGER default '20', `AllowAnonymousPosts` INTEGER NOT NULL default '1' );	CREATE TABLE `mp_Forums` ( `ItemID` INTEGER PRIMARY KEY, `ModuleID` INTEGER NOT NULL default '0', `CreatedDate` datetime NOT NULL default '0000-00-00 00:00:00', `CreatedBy` INTEGER NOT NULL default '0', `Title` varchar(100) NOT NULL default '', `Description` text NOT NULL, `IsModerated` INTEGER NOT NULL default '0', `IsActive` INTEGER NOT NULL default '0', `SortOrder` INTEGER NOT NULL default '100', `ThreadCount` INTEGER NOT NULL default '0', `PostCount` INTEGER NOT NULL default '0', `MostRecentPostDate` datetime default NULL, `MostRecentPostUserID` INTEGER NOT NULL default '0', `PostsPerPage` INTEGER NOT NULL default '10', `ThreadsPerPage` INTEGER default '20', `AllowAnonymousPosts` INTEGER NOT NULL default '1' , `ForumGuid` varchar(36), `RolesThatCanPost` varchar default 'Authenticated Users', `RolesThatCanModerate` varchar, `ModeratorNotifyEmail` varchar, `IncludeInGoogleMap` INTEGER default 1, `AddNoIndexMeta` INTEGER default 0, `Closed` INTEGER default 0, `Visible` INTEGER default 1, `RequireModeration` INTEGER default 0, `RequireModForNotify` INTEGER default 0, `AllowTrustedDirectPosts` INTEGER default 0, `AllowTrustedDirectNotify` INTEGER default 0);
Columns	Columns	Columns
Column	N/A	ForumGuid
Column	N/A	RolesThatCanPost
Column	N/A	RolesThatCanModerate
Column	N/A	ModeratorNotifyEmail
Column	N/A	IncludeInGoogleMap
Column	N/A	AddNoIndexMeta
Column	N/A	Closed
Column	N/A	Visible
Column	N/A	RequireModeration
Column	N/A	RequireModForNotify
Column	N/A	AllowTrustedDirectPosts
Column	N/A	AllowTrustedDirectNotify
Table	mp_ForumSubscriptions	mp_ForumSubscriptions
Definition	CREATE TABLE `mp_ForumSubscriptions` ( `SubscriptionID` INTEGER PRIMARY KEY, `ForumID` INTEGER NOT NULL default '0', `UserID` INTEGER NOT NULL default '0', `SubscribeDate` datetime NOT NULL default '0000-00-00 00:00:00', `UnSubscribeDate` datetime default NULL );	CREATE TABLE `mp_ForumSubscriptions` ( `SubscriptionID` INTEGER PRIMARY KEY, `ForumID` INTEGER NOT NULL default '0', `UserID` INTEGER NOT NULL default '0', `SubscribeDate` datetime NOT NULL default '0000-00-00 00:00:00', `UnSubscribeDate` datetime default NULL , `SubGuid` varchar(36));
Columns	Columns	Columns
Column	N/A	SubGuid
Table	mp_ForumThreads	mp_ForumThreads
Definition	CREATE TABLE `mp_ForumThreads` ( `ThreadID` INTEGER PRIMARY KEY, `ForumID` INTEGER NOT NULL default '0', `ThreadSubject` varchar(255) NOT NULL default '', `ThreadDate` datetime NOT NULL default '0000-00-00 00:00:00', `TotalViews` INTEGER NOT NULL default '0', `TotalReplies` INTEGER NOT NULL default '0', `SortOrder` INTEGER NOT NULL default '1000', `IsLocked` INTEGER NOT NULL default '0', `ForumSequence` INTEGER NOT NULL default '1', `MostRecentPostDate` datetime default NULL, `MostRecentPostUserID` INTEGER default NULL, `StartedByUserID` INTEGER NOT NULL default '0' );	CREATE TABLE `mp_ForumThreads` ( `ThreadID` INTEGER PRIMARY KEY, `ForumID` INTEGER NOT NULL default '0', `ThreadSubject` varchar(255) NOT NULL default '', `ThreadDate` datetime NOT NULL default '0000-00-00 00:00:00', `TotalViews` INTEGER NOT NULL default '0', `TotalReplies` INTEGER NOT NULL default '0', `SortOrder` INTEGER NOT NULL default '1000', `IsLocked` INTEGER NOT NULL default '0', `ForumSequence` INTEGER NOT NULL default '1', `MostRecentPostDate` datetime default NULL, `MostRecentPostUserID` INTEGER default NULL, `StartedByUserID` INTEGER NOT NULL default '0' , `ThreadGuid` varchar(36), `IsQuestion` INTEGER, `IncludeInSiteMap` INTEGER, `SetNoIndexMeta` INTEGER, `PTitleOverride` varchar(255), `ModStatus` INTEGER default '1', `ThreadType` varchar(100), `AssignedTo` char(36) default '00000000-0000-0000-0000-000000000000', `LockedBy` char(36) default '00000000-0000-0000-0000-000000000000', `LockedReason` varchar(255) NULL, `LockedUtc` datetime NULL);
Columns	Columns	Columns
Column	N/A	ThreadGuid
Column	N/A	IsQuestion
Column	N/A	IncludeInSiteMap
Column	N/A	SetNoIndexMeta
Column	N/A	PTitleOverride
Column	N/A	ModStatus
Column	N/A	ThreadType
Column	N/A	AssignedTo
Column	N/A	LockedBy
Column	N/A	LockedReason
Column	N/A	LockedUtc
Table	mp_ForumThreadSubscriptions	mp_ForumThreadSubscriptions
Definition	CREATE TABLE `mp_ForumThreadSubscriptions` ( `ThreadSubscriptionID` INTEGER PRIMARY KEY, `ThreadID` INTEGER NOT NULL default '0', `UserID` INTEGER NOT NULL default '0', `SubscribeDate` datetime NOT NULL default '0000-00-00 00:00:00', `UnSubscribeDate` datetime default NULL );	CREATE TABLE `mp_ForumThreadSubscriptions` ( `ThreadSubscriptionID` INTEGER PRIMARY KEY, `ThreadID` INTEGER NOT NULL default '0', `UserID` INTEGER NOT NULL default '0', `SubscribeDate` datetime NOT NULL default '0000-00-00 00:00:00', `UnSubscribeDate` datetime default NULL , `SubGuid` varchar(36));
Columns	Columns	Columns
Column	N/A	SubGuid
Table	mp_HtmlContent	mp_HtmlContent
Definition	CREATE TABLE `mp_HtmlContent` ( `ItemID` INTEGER PRIMARY KEY, `ModuleID` INTEGER NOT NULL default '0', `Title` varchar(255) default NULL, `Excerpt` text, `Body` text NOT NULL, `MoreLink` varchar(255) default NULL, `SortOrder` INTEGER default '500', `BeginDate` datetime default NULL, `EndDate` datetime default NULL, `CreatedDate` datetime default NULL, `UserID` INTEGER default NULL , ItemGuid VARCHAR(36), ModuleGuid VARCHAR(36), UserGuid VARCHAR(36), LastModUserGuid VARCHAR(36), LastModUtc datetime);	CREATE TABLE `mp_HtmlContent` ( `ItemID` INTEGER PRIMARY KEY, `ModuleID` INTEGER NOT NULL default '0', `Title` varchar(255) default NULL, `Excerpt` text, `Body` text NOT NULL, `MoreLink` varchar(255) default NULL, `SortOrder` INTEGER default '500', `BeginDate` datetime default NULL, `EndDate` datetime default NULL, `CreatedDate` datetime default NULL, `UserID` INTEGER default NULL , ItemGuid VARCHAR(36), ModuleGuid VARCHAR(36), UserGuid VARCHAR(36), LastModUserGuid VARCHAR(36), LastModUtc datetime, `ExcludeFromRecentContent` INTEGER NOT NULL default 0);
Columns	Columns	Columns
Column	N/A	ExcludeFromRecentContent
Table	mp_IndexingQueue	mp_IndexingQueue
Definition	CREATE TABLE `mp_IndexingQueue` ( `RowId` INTEGER NOT NULL PRIMARY KEY, `IndexPath` varchar(255) NOT NULL, `SerializedItem` text NOT NULL, `ItemKey` varchar(255) NOT NULL, `RemoveOnly` INTEGER NOT NULL );	CREATE TABLE `mp_IndexingQueue` ( `RowId` INTEGER NOT NULL PRIMARY KEY, `IndexPath` varchar(255) NOT NULL, `SerializedItem` text NOT NULL, `ItemKey` varchar(255) NOT NULL, `RemoveOnly` INTEGER NOT NULL , `SiteID` INTEGER);
Columns	Columns	Columns
Column	N/A	SiteID
Table	mp_LetterInfo	mp_LetterInfo
Definition	CREATE TABLE `mp_LetterInfo` ( `LetterInfoGuid` varchar(36) NOT NULL PRIMARY KEY, `SiteGuid` varchar(36) NOT NULL, `Title` varchar(255) NOT NULL, `Description` text NOT NULL, `AvailableToRoles` text NOT NULL, `Enabled` INTEGER NOT NULL, `AllowUserFeedback` INTEGER NOT NULL, `AllowAnonFeedback` INTEGER NOT NULL, `FromAddress` varchar(255) NOT NULL, `FromName` varchar(255) NOT NULL, `ReplyToAddress` varchar(255) NOT NULL, `SendMode` INTEGER NOT NULL, `EnableViewAsWebPage` INTEGER NOT NULL, `EnableSendLog` INTEGER NOT NULL, `RolesThatCanEdit` text NOT NULL, `RolesThatCanApprove` text NOT NULL, `RolesThatCanSend` text NOT NULL, `SubscriberCount` INTEGER NOT NULL, `CreatedUTC` datetime NOT NULL, `CreatedBy` varchar(36) NOT NULL, `LastModUTC` datetime NOT NULL, `LastModBy` varchar(36) NOT NULL , `AllowArchiveView` int, `ProfileOptIn` int, `SortRank` int, `UnVerifiedCount` INTEGER);	CREATE TABLE `mp_LetterInfo` ( `LetterInfoGuid` varchar(36) NOT NULL PRIMARY KEY, `SiteGuid` varchar(36) NOT NULL, `Title` varchar(255) NOT NULL, `Description` text NOT NULL, `AvailableToRoles` text NOT NULL, `Enabled` INTEGER NOT NULL, `AllowUserFeedback` INTEGER NOT NULL, `AllowAnonFeedback` INTEGER NOT NULL, `FromAddress` varchar(255) NOT NULL, `FromName` varchar(255) NOT NULL, `ReplyToAddress` varchar(255) NOT NULL, `SendMode` INTEGER NOT NULL, `EnableViewAsWebPage` INTEGER NOT NULL, `EnableSendLog` INTEGER NOT NULL, `RolesThatCanEdit` text NOT NULL, `RolesThatCanApprove` text NOT NULL, `RolesThatCanSend` text NOT NULL, `SubscriberCount` INTEGER NOT NULL, `CreatedUTC` datetime NOT NULL, `CreatedBy` varchar(36) NOT NULL, `LastModUTC` datetime NOT NULL, `LastModBy` varchar(36) NOT NULL , `AllowArchiveView` int, `ProfileOptIn` int, `SortRank` int, `UnVerifiedCount` INTEGER, `DisplayNameDefault` varchar(50), `FirstNameDefault` varchar(50), `LastNameDefault` varchar(50));
Columns	Columns	Columns
Column	N/A	DisplayNameDefault
Column	N/A	FirstNameDefault
Column	N/A	LastNameDefault
Table	mp_ModuleDefinitions	mp_ModuleDefinitions
Definition	CREATE TABLE `mp_ModuleDefinitions` ( `ModuleDefID` INTEGER PRIMARY KEY, `Guid` char(36) NOT NULL, `FeatureName` varchar(255) NOT NULL default '', `ControlSrc` varchar(255) NOT NULL default '', `SortOrder` INTEGER default '500', `DefaultCacheTime` INTEGER NOT NULL default '0', `Icon` varchar(255) NOT NULL default '', `IsAdmin` INTEGER default '0' , `ResourceFile` VARCHAR(255), `IsCacheable` INTEGER, `IsSearchable` INTEGER, `SearchListName` varchar(255), `SupportsPageReuse` INTEGER, `DeleteProvider` varchar(255));	CREATE TABLE `mp_ModuleDefinitions` ( `ModuleDefID` INTEGER PRIMARY KEY, `Guid` char(36) NOT NULL, `FeatureName` varchar(255) NOT NULL default '', `ControlSrc` varchar(255) NOT NULL default '', `SortOrder` INTEGER default '500', `DefaultCacheTime` INTEGER NOT NULL default '0', `Icon` varchar(255) NOT NULL default '', `IsAdmin` INTEGER default '0' , `ResourceFile` VARCHAR(255), `IsCacheable` INTEGER, `IsSearchable` INTEGER, `SearchListName` varchar(255), `SupportsPageReuse` INTEGER, `DeleteProvider` varchar(255), `PartialView` varchar(255));
Columns	Columns	Columns
Column	N/A	PartialView
Table	mp_ModuleDefinitionSettings	mp_ModuleDefinitionSettings
Definition	CREATE TABLE `mp_ModuleDefinitionSettings` ( `ID` INTEGER PRIMARY KEY, `ModuleDefID` INTEGER NOT NULL default '0', `FeatureGuid` char(36) NOT NULL, `ResourceFile` varchar(255) NULL, `SettingName` varchar(100) NOT NULL default '', `SettingValue` varchar(255) NOT NULL default '', `ControlType` varchar(255) default NULL, `RegexValidationExpression` text , ControlSrc VARCHAR(255), HelpKey VARCHAR(255), SortOrder INTEGER NOT NULL default '100'); CREATE INDEX IXmpModuleDefSetDefId ON mp_ModuleDefinitionSettings(`ModuleDefID`); CREATE INDEX IXmpModuleDefSetSetName ON mp_ModuleDefinitionSettings(`SettingName`);	CREATE TABLE `mp_ModuleDefinitionSettings` ( `ID` INTEGER PRIMARY KEY, `ModuleDefID` INTEGER NOT NULL default '0', `FeatureGuid` char(36) NOT NULL, `ResourceFile` varchar(255) NULL, `SettingName` varchar(100) NOT NULL default '', `SettingValue` varchar(255) NOT NULL default '', `ControlType` varchar(255) default NULL, `RegexValidationExpression` text , ControlSrc VARCHAR(255), HelpKey VARCHAR(255), SortOrder INTEGER NOT NULL default '100', `GroupName` varchar(255)); CREATE INDEX IXmpModuleDefSetDefId ON mp_ModuleDefinitionSettings(`ModuleDefID`); CREATE INDEX IXmpModuleDefSetSetName ON mp_ModuleDefinitionSettings(`SettingName`); CREATE INDEX IXmpModuleDefSetGroup ON mp_ModuleDefinitionSettings(`GroupName`);
Columns	Columns	Columns
Column	N/A	GroupName
Indexes	Indexes	Indexes
Index	N/A	IXmpModuleDefSetGroup
Table	mp_Modules	mp_Modules
Definition	CREATE TABLE `mp_Modules` ( `ModuleID` INTEGER PRIMARY KEY, `SiteID` INTEGER NOT NULL default '0', `ModuleDefID` INTEGER NOT NULL default '0', `ModuleTitle` varchar(255) default NULL, `CacheTime` INTEGER NOT NULL default '0', `ShowTitle` INTEGER NOT NULL default '1', `EditUserID` INTEGER default NULL, `AuthorizedEditRoles` text, `AvailableForMyPage` INTEGER NOT NULL default'0', `AllowMultipleInstancesOnMyPage` INTEGER NOT NULL default'1', `CountOfUseOnMyPage` INTEGER NOT NULL default '0', `Icon` varchar(255) NOT NULL default '', `CreatedByUserID` INTEGER NOT NULL default '0', `CreatedDate` datetime default NULL , Guid VARCHAR(36), FeatureGuid VARCHAR(36), SiteGuid VARCHAR(36), EditUserGuid VARCHAR(36), `HideFromAuth` INTEGER default '0', `HideFromUnAuth` INTEGER default '0', `ViewRoles` text, `DraftEditRoles` text);	CREATE TABLE `mp_Modules` ( `ModuleID` INTEGER PRIMARY KEY, `SiteID` INTEGER NOT NULL default '0', `ModuleDefID` INTEGER NOT NULL default '0', `ModuleTitle` varchar(255) default NULL, `CacheTime` INTEGER NOT NULL default '0', `ShowTitle` INTEGER NOT NULL default '1', `EditUserID` INTEGER default NULL, `AuthorizedEditRoles` text, `AvailableForMyPage` INTEGER NOT NULL default'0', `AllowMultipleInstancesOnMyPage` INTEGER NOT NULL default'1', `CountOfUseOnMyPage` INTEGER NOT NULL default '0', `Icon` varchar(255) NOT NULL default '', `CreatedByUserID` INTEGER NOT NULL default '0', `CreatedDate` datetime default NULL , Guid VARCHAR(36), FeatureGuid VARCHAR(36), SiteGuid VARCHAR(36), EditUserGuid VARCHAR(36), `HideFromAuth` INTEGER default '0', `HideFromUnAuth` INTEGER default '0', `ViewRoles` text, `DraftEditRoles` text, `IncludeInSearch` INTEGER, `IsGlobal` INTEGER, `HeadElement` varchar(25), `PublishMode` INTEGER, `DraftApprovalRoles` text);
Columns	Columns	Columns
Column	N/A	IncludeInSearch
Column	N/A	IsGlobal
Column	N/A	HeadElement
Column	N/A	PublishMode
Column	N/A	DraftApprovalRoles
Table	mp_PageModules	mp_PageModules
Definition	CREATE TABLE `mp_PageModules` ( `RowID` INTEGER NOT NULL PRIMARY KEY, `PageID` INTEGER NOT NULL , `ModuleID` INTEGER NOT NULL , `PaneName` varchar(50) NOT NULL default '', `ModuleOrder` INTEGER NOT NULL default '0', `PublishBeginDate` datetime NOT NULL default '0000-00-00 00:00:00', `PublishEndDate` datetime default NULL , ModuleGuid VARCHAR(36), PageGuid VARCHAR(36));	CREATE TABLE `mp_PageModules` ( `RowID` INTEGER NOT NULL PRIMARY KEY, `PageID` INTEGER NOT NULL , `ModuleID` INTEGER NOT NULL , `PaneName` varchar(50) NOT NULL default '', `ModuleOrder` INTEGER NOT NULL default '0', `PublishBeginDate` datetime NOT NULL default '0000-00-00 00:00:00', `PublishEndDate` datetime default NULL , ModuleGuid VARCHAR(36), PageGuid VARCHAR(36)); CREATE INDEX IXpmpanename ON mp_PageModules(`PaneName`);
Indexes	Indexes	Indexes
Index	N/A	IXpmpanename
Table	mp_Pages	mp_Pages
Definition	CREATE TABLE `mp_Pages` ( `PageID` INTEGER PRIMARY KEY, `ParentID` INTEGER NOT NULL default '-1', `PageOrder` INTEGER NOT NULL default '0', `SiteID` INTEGER NOT NULL default '1', `PageName` varchar(50) NOT NULL default '', `PageTitle` varchar(255) NULL , `RequireSSL` INTEGER default '0', `AllowBrowserCache` INTEGER default '1', `ShowBreadcrumbs` INTEGER default '0', `PageKeyWords` varchar(255) default NULL, `PageDescription` varchar(255) default NULL, `PageEncoding` varchar(255) default NULL, `AdditionalMetaTags` varchar(255) default NULL, `MenuImage` varchar(50) default NULL, `UseUrl` INTEGER NOT NULL default '0', `Url` varchar(255) default NULL, `OpenInNewWindow` INTEGER NOT NULL default '0', `ShowChildPageMenu` INTEGER NOT NULL default '0', `AuthorizedRoles` text, `EditRoles` text, `CreateChildPageRoles` text, `ShowChildBreadCrumbs` INTEGER default '0', `HideMainMenu` INTEGER default '0', `Skin` varchar(100) default NULL, `IncludeInMenu` INTEGER NOT NULL default '1' , `ChangeFrequency` VARCHAR(20), `SiteMapPriority` VARCHAR(10), `LastModifiedUTC` datetime, `PageGuid` VARCHAR(36), `ParentGuid` VARCHAR(36), `HideAfterLogin` INTEGER default '0', SiteGuid VARCHAR(36), CompiledMeta text, CompiledMetaUtc datetime, `IncludeInSiteMap` INTEGER, `IsClickable` INTEGER, `ShowHomeCrumb` INTEGER, `DraftEditRoles` text, `IsPending` INTEGER, `CanonicalOverride` varchar(255), `IncludeInSearchMap` int, `EnableComments` INTEGER, `CreateChildDraftRoles` text);	CREATE TABLE `mp_Pages` ( `PageID` INTEGER PRIMARY KEY, `ParentID` INTEGER NOT NULL default '-1', `PageOrder` INTEGER NOT NULL default '0', `SiteID` INTEGER NOT NULL default '1', `PageName` varchar(50) NOT NULL default '', `PageTitle` varchar(255) NULL , `RequireSSL` INTEGER default '0', `AllowBrowserCache` INTEGER default '1', `ShowBreadcrumbs` INTEGER default '0', `PageKeyWords` varchar(255) default NULL, `PageDescription` varchar(255) default NULL, `PageEncoding` varchar(255) default NULL, `AdditionalMetaTags` varchar(255) default NULL, `MenuImage` varchar(50) default NULL, `UseUrl` INTEGER NOT NULL default '0', `Url` varchar(255) default NULL, `OpenInNewWindow` INTEGER NOT NULL default '0', `ShowChildPageMenu` INTEGER NOT NULL default '0', `AuthorizedRoles` text, `EditRoles` text, `CreateChildPageRoles` text, `ShowChildBreadCrumbs` INTEGER default '0', `HideMainMenu` INTEGER default '0', `Skin` varchar(100) default NULL, `IncludeInMenu` INTEGER NOT NULL default '1' , `ChangeFrequency` VARCHAR(20), `SiteMapPriority` VARCHAR(10), `LastModifiedUTC` datetime, `PageGuid` VARCHAR(36), `ParentGuid` VARCHAR(36), `HideAfterLogin` INTEGER default '0', SiteGuid VARCHAR(36), CompiledMeta text, CompiledMetaUtc datetime, `IncludeInSiteMap` INTEGER, `IsClickable` INTEGER, `ShowHomeCrumb` INTEGER, `DraftEditRoles` text, `IsPending` INTEGER, `CanonicalOverride` varchar(255), `IncludeInSearchMap` int, `EnableComments` INTEGER, `CreateChildDraftRoles` text, `IncludeInChildSiteMap` INTEGER, `PubTeamId` char(36), `BodyCssClass` varchar(50), `MenuCssClass` varchar(50), `ExpandOnSiteMap` INTEGER, `PublishMode` INTEGER, `PCreatedUtc` datetime, `PCreatedBy` varchar(36), `PCreatedFromIp` varchar(36), `PLastModUtc` datetime, `PLastModBy` varchar(36), `PLastModFromIp` varchar(36), `MenuDesc` text, `DraftApprovalRoles` text, `LinkRel` varchar(20), `PageHeading` varchar(255), `ShowPageHeading` INTEGER NOT NULL default 1, `PubDateUtc` datetime); CREATE INDEX IXpagesname ON mp_Pages(`PageName`);
Columns	Columns	Columns
Column	N/A	IncludeInChildSiteMap
Column	N/A	PubTeamId
Column	N/A	BodyCssClass
Column	N/A	MenuCssClass
Column	N/A	ExpandOnSiteMap
Column	N/A	PublishMode
Column	N/A	PCreatedUtc
Column	N/A	PCreatedBy
Column	N/A	PCreatedFromIp
Column	N/A	PLastModUtc
Column	N/A	PLastModBy
Column	N/A	PLastModFromIp
Column	N/A	MenuDesc
Column	N/A	DraftApprovalRoles
Column	N/A	LinkRel
Column	N/A	PageHeading
Column	N/A	ShowPageHeading
Column	N/A	PubDateUtc
Indexes	Indexes	Indexes
Index	N/A	IXpagesname
Table	mp_Place	mp_Place
Definition	CREATE TABLE mp_Place ( RowID VARCHAR NOT NULL, UserGuid VARCHAR NOT NULL, SiteGuid VARCHAR NOT NULL, Name VARCHAR, Mode VARCHAR, ParentID VARCHAR, Description VARCHAR, Company VARCHAR, License VARCHAR, Longitude FLOAT NOT NULL, Latitude FLOAT NOT NULL, Altitude FLOAT NOT NULL, Address1 VARCHAR, Address2 VARCHAR, Continent VARCHAR, Country VARCHAR, Region VARCHAR, City VARCHAR, Zip VARCHAR, TimeZone VARCHAR, Addtl VARCHAR );	CREATE TABLE mp_Place ( RowID VARCHAR(36) NOT NULL, UserGuid VARCHAR(36) NOT NULL, SiteGuid VARCHAR(36) NOT NULL, Name varchar(255), Mode varchar(255), ParentID varchar(36), Description varchar(2000000000), Company varchar(255), License varchar(255), Longitude Float NOT NULL DEFAULT '0.0', Latitude Float NOT NULL DEFAULT '0.0', Altitude Float NOT NULL DEFAULT '0.0', Address1 varchar(255), Address2 varchar(255), Continent varchar(255), Country varchar(255), Region varchar(255), City varchar(255), Zip varchar(255), TimeZone varchar(255), Addtl varchar(2000000000) );
Columns	Columns	Columns
Column	Longitude	Longitude
Column	Latitude	Latitude
Column	Altitude	Altitude
Table	mp_Tracking	mp_Tracking
Definition	CREATE TABLE mp_Tracking ( RowID VARCHAR NOT NULL, UserGuid VARCHAR NOT NULL, SiteGuid VARCHAR NOT NULL, DeviceGuid VARCHAR NOT NULL, Track VARCHAR, captureUTC DATETIME NOT NULL );	CREATE TABLE mp_Tracking ( RowID VARCHAR(36) NOT NULL, UserGuid VARCHAR(36) NOT NULL, SiteGuid VARCHAR(36) NOT NULL, DeviceGuid VARCHAR(36) NOT NULL, Track VARCHAR(2000000000), captureUTC DATETIME(2000000000) NOT NULL, CONSTRAINT MP_TRACKING_PK PRIMARY KEY (RowID) );
Columns	Columns	Columns
Column	RowID	RowID
Key	false	true
Keys	Keys	Keys
Key	N/A	MP_TRACKING_PK
Indexes	Indexes	Indexes
Index	N/A	sqlite_autoindex_mp_Tracking_1
Table	mp_UserDevice	mp_UserDevice
Definition	CREATE TABLE mp_UserDevice ( RowID VARCHAR NOT NULL, UserGuid VARCHAR NOT NULL, SiteGuid VARCHAR NOT NULL, DeviceName VARCHAR, TrackName VARCHAR, TrackUser VARCHAR, IMEI VARCHAR, SIMCard VARCHAR, HardwareVersion VARCHAR, IPPort VARCHAR, TrackMail INTEGER NOT NULL, GSM FLOAT NOT NULL, GPS FLOAT NOT NULL, Longitude FLOAT NOT NULL, Latitude FLOAT NOT NULL, RawAddress VARCHAR, Continent VARCHAR, Country VARCHAR, Region VARCHAR, City VARCHAR, TimeZone VARCHAR, DeviceStatus VARCHAR, TrackStatus VARCHAR, AlarmStatus VARCHAR, DeviceMode VARCHAR, AlarmMode VARCHAR, TrackMode VARCHAR, ACC INTEGER NOT NULL, AGPS INTEGER NOT NULL, Emergency1 VARCHAR, Emergency2 VARCHAR, Emergency3 VARCHAR, Emergency4 VARCHAR, Emergency5 VARCHAR, Messages VARCHAR, Tracks VARCHAR, Installed DATETIME NOT NULL, LastCaptureUTC DATETIME NOT NULL );	CREATE TABLE mp_UserDevice ( RowID VARCHAR(36) NOT NULL, UserGuid VARCHAR(36) NOT NULL, SiteGuid VARCHAR(36) NOT NULL, DeviceName VARCHAR(255), TrackName VARCHAR(255), TrackUser VARCHAR(255), IMEI VARCHAR(255), SIMCard VARCHAR(255), HardwareVersion VARCHAR(255), IPPort VARCHAR(255), TrackMail INTEGER NOT NULL DEFAULT '0', GSM FLOAT NOT NULL DEFAULT '0.0', GPS FLOAT NOT NULL DEFAULT '0.0', Longitude FLOAT NOT NULL DEFAULT '0.0', Latitude FLOAT NOT NULL DEFAULT '0.0', RawAddress VARCHAR(1023), Continent VARCHAR(255), Country VARCHAR(255), Region VARCHAR(255), City VARCHAR(255), TimeZone VARCHAR(255), DeviceStatus VARCHAR(255) DEFAULT 'None', TrackStatus VARCHAR(255) DEFAULT 'None', AlarmStatus VARCHAR(255) DEFAULT 'None', DeviceMode VARCHAR(255) DEFAULT 'None', AlarmMode VARCHAR(255) DEFAULT 'None', TrackMode VARCHAR(255) DEFAULT 'None', ACC INTEGER NOT NULL DEFAULT '0', AGPS INTEGER NOT NULL DEFAULT '0', Emergency1 VARCHAR(36), Emergency2 VARCHAR(36), Emergency3 VARCHAR(36), Emergency4 VARCHAR(36), Emergency5 VARCHAR(36), Messages VARCHAR(2000000000), Tracks VARCHAR(2000000000), Installed DATETIME(2000000000) NOT NULL DEFAULT '0000-00-00 00:00:00', LastCaptureUTC DATETIME(2000000000) NOT NULL DEFAULT '0000-00-00 00:00:00', CONSTRAINT MP_USERDEVICES_PK PRIMARY KEY (RowID) );
Columns	Columns	Columns
Column	RowID	RowID
Key	false	true
Column	TrackMail	TrackMail
Column	GSM	GSM
Column	GPS	GPS
Column	Longitude	Longitude
Column	Latitude	Latitude
Column	DeviceStatus	DeviceStatus
Column	TrackStatus	TrackStatus
Column	AlarmStatus	AlarmStatus
Column	DeviceMode	DeviceMode
Column	AlarmMode	AlarmMode
Column	TrackMode	TrackMode
Column	ACC	ACC
Column	AGPS	AGPS
Column	Installed	Installed
Column	LastCaptureUTC	LastCaptureUTC
Keys	Keys	Keys
Key	N/A	MP_USERDEVICES_PK
Indexes	Indexes	Indexes
Index	N/A	sqlite_autoindex_mp_UserDevice_1
Table	mp_UserRoles	mp_UserRoles
Definition	CREATE TABLE `mp_UserRoles` ( `ID` INTEGER PRIMARY KEY, `UserID` INTEGER NOT NULL default '0', `RoleID` INTEGER NOT NULL default '0' , UserGuid VARCHAR(36), RoleGuid VARCHAR(36));	CREATE TABLE `mp_UserRoles` ( `ID` INTEGER PRIMARY KEY, `UserID` INTEGER NOT NULL default '0', `RoleID` INTEGER NOT NULL default '0' , UserGuid VARCHAR(36), RoleGuid VARCHAR(36)); CREATE INDEX IXUserRolesRoleID ON mp_UserRoles(`RoleID`);
Indexes	Indexes	Indexes
Index	N/A	IXUserRolesRoleID
Table	mp_Users	mp_Users
Definition	CREATE TABLE `mp_Users` ( `UserID` INTEGER PRIMARY KEY, `SiteID` INTEGER NOT NULL default '1', `Name` varchar(50) NOT NULL default '', `Password` varchar(128) default NULL, `Email` varchar(100) NOT NULL default '', `Gender` char(1) default NULL, `ProfileApproved` INTEGER NOT NULL default '1', `ApprovedForForums` INTEGER NOT NULL default '1', `Trusted` INTEGER NOT NULL default '0', `DisplayInMemberList` INTEGER NOT NULL default '1', `WebSiteURL` varchar(100) default NULL, `Country` varchar(100) default NULL, `State` varchar(100) default NULL, `Occupation` varchar(100) default NULL, `Interests` varchar(100) default NULL, `MSN` varchar(50) default NULL, `Yahoo` varchar(50) default NULL, `AIM` varchar(50) default NULL, `ICQ` varchar(50) default NULL, `TotalPosts` INTEGER NOT NULL default '0', `AvatarUrl` varchar(255) default 'blank.gif', `AvatarType` INTEGER default NULL, `TimeOffsetHours` INTEGER default '0', `Signature` varchar(255) default NULL, `DateCreated` datetime NOT NULL default '0000-00-00 00:00:00', `UserGuid` varchar(36) default NULL, `Skin` varchar(100) default NULL, `LoginName` varchar(50) default NULL, `IsDeleted` INTEGER default '0', `LoweredEmail` varchar(100) default NULL, `RegisterConfirmGuid` varchar(36) default '00000000-0000-0000-0000-000000000000', `PasswordQuestion` varchar(255) default NULL, `PasswordAnswer` varchar(255) default NULL, `LastActivityDate` datetime default NULL, `LastLoginDate` datetime default NULL, `LastPasswordChangedDate` datetime default NULL, `LastLockoutDate` datetime default NULL, `FailedPasswordAttemptCount` INTEGER default '0', `FailedPwdAttemptWindowStart` datetime default NULL, `FailedPwdAnswerAttemptCount` INTEGER default '0', `FailedPwdAnswerWindowStart` datetime default NULL, `IsLockedOut` INTEGER default '0', `MobilePIN` varchar(16) default NULL, `PasswordSalt` varchar(128) default NULL, `Comment` text , `OpenIDURI` VARCHAR(255), `WindowsLiveID` VARCHAR(36), SiteGuid VARCHAR(36), `TotalRevenue` Decimal(15,4), `FirstName` varchar(100), `LastName` varchar(100), `Pwd` varchar(1000), `MustChangePwd` INTEGER, `NewEmail` varchar(100), `EditorPreference` varchar(100), `EmailChangeGuid` varchar(36), `TimeZoneId` varchar(32), PasswordResetGuid VARCHAR, RolesChanged INTEGER, AuthorBio TEXT, DateOfBirth DATETIME, EmailConfirmed INTEGER, PwdFormat INTEGER, PasswordHash VARCHAR, SecurityStamp VARCHAR, PhoneNumber VARCHAR, PhoneNumberConfirmed INTEGER, TwoFactorEnabled INTEGER, LockoutEndDateUtc DATETIME); CREATE INDEX idxuserssiteid ON mp_Users(`SiteID`); CREATE INDEX idxusersreguid ON mp_Users(`RegisterConfirmGuid`);	CREATE TABLE `mp_Users` ( `UserID` INTEGER PRIMARY KEY, `SiteID` INTEGER NOT NULL default '1', `Name` varchar(50) NOT NULL default '', `Password` varchar(128) default NULL, `Email` varchar(100) NOT NULL default '', `Gender` char(1) default NULL, `ProfileApproved` INTEGER NOT NULL default '1', `ApprovedForForums` INTEGER NOT NULL default '1', `Trusted` INTEGER NOT NULL default '0', `DisplayInMemberList` INTEGER NOT NULL default '1', `WebSiteURL` varchar(100) default NULL, `Country` varchar(100) default NULL, `State` varchar(100) default NULL, `Occupation` varchar(100) default NULL, `Interests` varchar(100) default NULL, `MSN` varchar(50) default NULL, `Yahoo` varchar(50) default NULL, `AIM` varchar(50) default NULL, `ICQ` varchar(50) default NULL, `TotalPosts` INTEGER NOT NULL default '0', `AvatarUrl` varchar(255) default 'blank.gif', `AvatarType` INTEGER default NULL, `TimeOffsetHours` INTEGER default '0', `Signature` varchar(255) default NULL, `DateCreated` datetime NOT NULL default '0000-00-00 00:00:00', `UserGuid` varchar(36) default NULL, `Skin` varchar(100) default NULL, `LoginName` varchar(50) default NULL, `IsDeleted` INTEGER default '0', `LoweredEmail` varchar(100) default NULL, `RegisterConfirmGuid` varchar(36) default '00000000-0000-0000-0000-000000000000', `PasswordQuestion` varchar(255) default NULL, `PasswordAnswer` varchar(255) default NULL, `LastActivityDate` datetime default NULL, `LastLoginDate` datetime default NULL, `LastPasswordChangedDate` datetime default NULL, `LastLockoutDate` datetime default NULL, `FailedPasswordAttemptCount` INTEGER default '0', `FailedPwdAttemptWindowStart` datetime default NULL, `FailedPwdAnswerAttemptCount` INTEGER default '0', `FailedPwdAnswerWindowStart` datetime default NULL, `IsLockedOut` INTEGER default '0', `MobilePIN` varchar(16) default NULL, `PasswordSalt` varchar(128) default NULL, `Comment` text , `OpenIDURI` VARCHAR(255), `WindowsLiveID` VARCHAR(36), SiteGuid VARCHAR(36), `TotalRevenue` Decimal(15,4), `FirstName` varchar(100), `LastName` varchar(100), `Pwd` varchar(1000), `MustChangePwd` INTEGER, `NewEmail` varchar(100), `EditorPreference` varchar(100), `EmailChangeGuid` varchar(36), `TimeZoneId` varchar(32), `PasswordResetGuid` varchar(36), `RolesChanged` INTEGER, `AuthorBio` text, `DateOfBirth` datetime NULL, `EmailConfirmed` INTEGER default 1, `PwdFormat` INTEGER default 0, `PasswordHash` varchar, `SecurityStamp` varchar, `PhoneNumber` varchar(50), `PhoneNumberConfirmed` INTEGER default 0, `TwoFactorEnabled` INTEGER default 0, `LockoutEndDateUtc` datetime NULL); CREATE INDEX idxuserssiteid ON mp_Users(`SiteID`); CREATE INDEX idxusersreguid ON mp_Users(`RegisterConfirmGuid`);
Columns	Columns	Columns
Column	EmailConfirmed	EmailConfirmed
Column	PwdFormat	PwdFormat
Column	PhoneNumberConfirmed	PhoneNumberConfirmed
Column	TwoFactorEnabled	TwoFactorEnabled
Table	N/A	mp_Category
Table	N/A	mp_CategoryItem
Table	N/A	mp_Comments
Table	N/A	mp_MediaFile
Table	N/A	mp_MediaPlayer
Table	N/A	mp_MediaTrack
Table	N/A	mp_PaymentLog
Table	N/A	mp_SystemLog
Table	N/A	mp_Tag
Table	N/A	mp_TagItem
Table	N/A	mp_TagVocabulary
Table	N/A	mp_UserAddress
Table	N/A	mp_UserClaims
Table	N/A	mp_UserLogins
2305 objects compared