Index: branches/unlabeled/unlabeled-1.63.2/admin/install/inportal_schema.sql =================================================================== diff -u -r6901 -r6939 --- branches/unlabeled/unlabeled-1.63.2/admin/install/inportal_schema.sql (.../inportal_schema.sql) (revision 6901) +++ branches/unlabeled/unlabeled-1.63.2/admin/install/inportal_schema.sql (.../inportal_schema.sql) (revision 6939) @@ -91,33 +91,6 @@ # -------------------------------------------------------- -CREATE TABLE ConfigurationAdmin ( - VariableName varchar(80) NOT NULL default '', - heading varchar(255) default NULL, - prompt varchar(255) default NULL, - element_type varchar(20) NOT NULL default '', - validation varchar(255) default NULL, - ValueList text default NULL, - DisplayOrder double NOT NULL default '0', - GroupDisplayOrder double NOT NULL default '0', - Install int(11) NOT NULL default '1', - PRIMARY KEY (VariableName) -) - -# -------------------------------------------------------- - -CREATE TABLE ConfigurationValues ( - VariableId int(11) NOT NULL auto_increment, - VariableName varchar(255) NOT NULL default '', - VariableValue varchar(255) default NULL, - ModuleOwner varchar(20) default 'In-Portal', - Section varchar(255) NOT NULL default '', - PRIMARY KEY (VariableId), - UNIQUE KEY VariableName (VariableName) -) - -# -------------------------------------------------------- - CREATE TABLE CountCache ( ListType int(11) NOT NULL default '0', ItemType int(11) NOT NULL default '-1', @@ -131,66 +104,6 @@ # -------------------------------------------------------- -CREATE TABLE CustomField ( - CustomFieldId int(11) NOT NULL auto_increment, - Type int(11) NOT NULL default '0', - FieldName varchar(255) NOT NULL default '', - FieldLabel varchar(40) default NULL, - Heading varchar(60) default NULL, - Prompt varchar(60) default NULL, - ElementType varchar(50) NOT NULL default '', - ValueList varchar(255) default NULL, - DisplayOrder int(11) NOT NULL default '0', - OnGeneralTab tinyint(4) NOT NULL default '0', - IsSystem tinyint(3) unsigned NOT NULL default '0', - PRIMARY KEY (CustomFieldId), - KEY Type (Type) -) - -# -------------------------------------------------------- - -CREATE TABLE EmailMessage ( - EmailMessageId int(10) NOT NULL auto_increment, - Template longtext, - MessageType enum('html','text') NOT NULL default 'text', - LanguageId int(11) NOT NULL default '0', - EventId int(11) NOT NULL default '0', - PRIMARY KEY (EmailMessageId) -) - -# -------------------------------------------------------- - -CREATE TABLE EmailQueue ( - Subject text NOT NULL, - toaddr text NOT NULL, - fromaddr text NOT NULL, - message blob, - headers blob, - queued timestamp NOT NULL -) - -# -------------------------------------------------------- - -CREATE TABLE EmailSubscribers ( - EmailMessageId int(11) NOT NULL default '0', - PortalUserId int(11) NOT NULL default '0' -) - -# -------------------------------------------------------- - -CREATE TABLE Events ( - EventId int(11) NOT NULL auto_increment, - Event varchar(40) NOT NULL default '', - Enabled int(11) NOT NULL default '1', - FromUserId int(11) NOT NULL default '0', - Module varchar(40) NOT NULL default '', - Description varchar(255) NOT NULL default '', - Type int(11) NOT NULL default '0', - PRIMARY KEY (EventId) -) - -# -------------------------------------------------------- - CREATE TABLE Favorites ( FavoriteId int(11) NOT NULL auto_increment, PortalUserId int(11) NOT NULL default '0', @@ -203,12 +116,6 @@ # -------------------------------------------------------- -CREATE TABLE IdGenerator ( - lastid int(11) default NULL -) - -# -------------------------------------------------------- - CREATE TABLE Images ( ImageId int(11) NOT NULL auto_increment, ResourceId int(11) NOT NULL default '0', @@ -279,54 +186,6 @@ # -------------------------------------------------------- -CREATE TABLE Language ( - LanguageId int(11) NOT NULL auto_increment, - PackName varchar(40) NOT NULL default '', - LocalName varchar(40) NOT NULL default '', - Enabled int(11) NOT NULL default '0', - PrimaryLang int(11) NOT NULL default '0', - IconURL varchar(255) default NULL, - DateFormat varchar(50) NOT NULL default '', - TimeFormat varchar(50) NOT NULL default '', - InputDateFormat varchar(50) NOT NULL default '', - InputTimeFormat varchar(50) NOT NULL default '', - DecimalPoint char(2) NOT NULL default '.', - ThousandSep tinytext NULL, - Charset varchar(20) NOT NULL default '', - UnitSystem tinyint(4) NOT NULL default '1', - PRIMARY KEY (LanguageId) -) - -# -------------------------------------------------------- - -CREATE TABLE Modules ( - Name varchar(255) NOT NULL default '', - Path varchar(255) NOT NULL default '', - Var varchar(10) NOT NULL default '', - Version varchar(10) NOT NULL default '', - Loaded tinyint(4) NOT NULL default '1', - LoadOrder tinyint(4) NOT NULL default '0', - TemplatePath varchar(255) NOT NULL default '', - RootCat int(11) NOT NULL default '0', - BuildDate double NOT NULL default '0', - PRIMARY KEY (Name) -) - -# -------------------------------------------------------- - -CREATE TABLE PermCache ( - PermCacheId int(11) NOT NULL auto_increment, - CategoryId int(11) NOT NULL default '0', - PermId int(11) NOT NULL default '0', - ACL varchar(255) NOT NULL default '', - DACL varchar(255) NOT NULL default '', - PRIMARY KEY (PermCacheId), - KEY CategoryId (CategoryId), - KEY PermId (PermId) -) - -# -------------------------------------------------------- - CREATE TABLE PermissionConfig ( PermissionConfigId int(11) NOT NULL auto_increment, PermissionName varchar(30) NOT NULL default '', @@ -337,113 +196,9 @@ KEY PermissionName (PermissionName) ) -# -------------------------------------------------------- -CREATE TABLE Permissions ( - PermissionId int(11) NOT NULL auto_increment, - Permission varchar(255) NOT NULL default '', - GroupId int(11) default '0', - PermissionValue int(11) NOT NULL default '0', - Type tinyint(4) NOT NULL default '0', - CatId int(11) NOT NULL default '0', - PRIMARY KEY (PermissionId), - UNIQUE KEY PermIndex (Permission,GroupId,CatId,Type) -) - # -------------------------------------------------------- -CREATE TABLE PersistantSessionData ( - PortalUserId int(11) NOT NULL default '0', - VariableName varchar(255) NOT NULL default '', - VariableValue text NOT NULL, - PRIMARY KEY (PortalUserId,VariableName), - KEY UserId (PortalUserId), - KEY VariableName (VariableName) -) -# -------------------------------------------------------- - -CREATE TABLE Phrase ( - Phrase varchar(255) NOT NULL default '', - Translation text NOT NULL default '', - PhraseType int(11) NOT NULL default '0', - PhraseId int(11) NOT NULL auto_increment, - LanguageId int(11) NOT NULL default '0', - LastChanged int(10) unsigned NOT NULL default '0', - LastChangeIP varchar(15) NOT NULL default '', - Module varchar(30) NOT NULL default '', - PRIMARY KEY (PhraseId), - KEY LanguageId (LanguageId), - INDEX Phrase_Index (Phrase) -) - -# -------------------------------------------------------- - -CREATE TABLE PhraseCache ( - Template varchar(40) NOT NULL default '', - PhraseList text NOT NULL, - CacheDate int(11) NOT NULL default '0', - ThemeId int(11) NOT NULL default '0', - StylesheetId int(10) unsigned NOT NULL default '0', - ConfigVariables text, - PRIMARY KEY (Template) -) - -# -------------------------------------------------------- - -CREATE TABLE PortalGroup ( - GroupId int(11) NOT NULL auto_increment, - Name varchar(255) NOT NULL default '', - Description varchar(255) default NULL, - CreatedOn double NOT NULL default '0', - System tinyint(4) NOT NULL default '0', - Personal tinyint(4) NOT NULL default '0', - Enabled tinyint(4) NOT NULL default '1', - ResourceId int(11) NOT NULL default '0', - PRIMARY KEY (GroupId), - UNIQUE KEY Name (Name), - UNIQUE KEY ResourceId (ResourceId), - KEY Personal (Personal), - KEY Enabled (Enabled) -) - -# -------------------------------------------------------- - -CREATE TABLE PortalUser ( - PortalUserId int(11) NOT NULL auto_increment, - Login varchar(255) default NULL, - `Password` varchar(255) default NULL, - FirstName varchar(255) default NULL, - LastName varchar(255) default NULL, - Company varchar(255) NOT NULL default '', - Email varchar(255) NOT NULL default '', - CreatedOn double NOT NULL default '0', - Phone varchar(20) default NULL, - Fax varchar(255) NOT NULL default '', - Street varchar(255) default NULL, - Street2 varchar(255) NOT NULL default '', - City varchar(20) default NULL, - State varchar(20) NOT NULL default '', - Zip varchar(20) default NULL, - Country varchar(20) NOT NULL default '', - ResourceId int(11) NOT NULL default '0', - `Status` tinyint(4) NOT NULL default '2', - Modified int(11) NOT NULL default '0', - dob double NOT NULL default '0', - tz int(11) default NULL, - ip varchar(20) default NULL, - IsBanned tinyint(1) NOT NULL default '0', - PassResetTime bigint(20) default NULL, - PwResetConfirm varchar(255) default NULL, - PwRequestTime bigint(25) default NULL, - MinPwResetDelay int(11) NOT NULL default '1800', - PRIMARY KEY (PortalUserId), - UNIQUE KEY ResourceId (ResourceId), - UNIQUE KEY Login (Login), - KEY CreatedOn (CreatedOn) -) - -# -------------------------------------------------------- - CREATE TABLE Relationship ( RelationshipId int(11) NOT NULL auto_increment, SourceId int(11) default NULL, @@ -502,17 +257,6 @@ # -------------------------------------------------------- -CREATE TABLE SessionData ( - SessionKey varchar(50) NOT NULL default '', - VariableName varchar(255) NOT NULL default '', - VariableValue text NOT NULL, - PRIMARY KEY (SessionKey,VariableName), - KEY SessionKey (SessionKey), - KEY VariableName (VariableName) -) - -# -------------------------------------------------------- - CREATE TABLE SpamControl ( ItemResourceId int(11) NOT NULL default '0', IPaddress varchar(20) NOT NULL default '', @@ -536,71 +280,6 @@ # -------------------------------------------------------- -CREATE TABLE Theme ( - ThemeId int(11) NOT NULL auto_increment, - Name varchar(40) NOT NULL default '', - Enabled int(11) NOT NULL default '1', - Description varchar(255) default NULL, - PrimaryTheme int(11) NOT NULL default '0', - CacheTimeout int(11) NOT NULL default '0', - StylesheetId INTEGER(10) UNSIGNED NOT NULL DEFAULT '0', - PRIMARY KEY (ThemeId) -) - -# -------------------------------------------------------- - -CREATE TABLE ThemeFiles ( - FileId int(11) NOT NULL auto_increment, - ThemeId int(11) NOT NULL default '0', - FileName varchar(255) NOT NULL default '', - FilePath varchar(255) NOT NULL default '', - Description varchar(255) default NULL, - FileType int(11) NOT NULL default '0', - FileFound tinyint(3) unsigned NOT NULL default '0', - PRIMARY KEY (FileId), - KEY theme (ThemeId), - KEY FileName (FileName), - KEY FilePath (FilePath), - KEY FileFound (FileFound) -) - -# -------------------------------------------------------- - -CREATE TABLE UserGroup ( - PortalUserId int(11) NOT NULL default '0', - GroupId int(11) NOT NULL default '0', - MembershipExpires int(10) unsigned default NULL, - PrimaryGroup tinyint(4) NOT NULL default '1', - ExpirationReminderSent tinyint(4) NOT NULL default '0', - PRIMARY KEY (PortalUserId,GroupId), - KEY GroupId (GroupId), - KEY PrimaryGroup (PrimaryGroup) -) - -# -------------------------------------------------------- - - - -CREATE TABLE UserSession ( - SessionKey varchar(50) NOT NULL default '', - CurrentTempKey varchar(50) default NULL, - PrevTempKey varchar(50) default NULL, - LastAccessed double NOT NULL default '0', - PortalUserId varchar(255) NOT NULL default '', - Language varchar(255) NOT NULL default '', - Theme varchar(255) NOT NULL default '', - GroupId int(11) NOT NULL default '0', - IpAddress varchar(20) NOT NULL default '0.0.0.0', - Status int(11) NOT NULL default '1', - GroupList varchar(255) default NULL, - tz int(11) default NULL, - PRIMARY KEY (SessionKey), - KEY UserId (PortalUserId), - KEY LastAccessed (LastAccessed) -) - -# -------------------------------------------------------- - CREATE TABLE SuggestMail ( email varchar(255) NOT NULL default '', sent double, @@ -647,18 +326,6 @@ # -------------------------------------------------------- -CREATE TABLE EmailLog ( - EmailLogId int(11) NOT NULL auto_increment, - fromuser varchar(200) default NULL, - addressto varchar(255) default NULL, - subject varchar(255) default NULL, - timestamp bigint(20) default '0', - event varchar(100) default NULL, - PRIMARY KEY (EmailLogId) -) - -# -------------------------------------------------------- - CREATE TABLE ImportScripts ( is_id smallint(5) unsigned NOT NULL auto_increment, is_Module varchar(50) NOT NULL default '', @@ -674,15 +341,6 @@ # -------------------------------------------------------- -CREATE TABLE Cache ( - VarName varchar(255) NOT NULL default '', - Data longtext, - Cached int(11) default NULL, - LifeTime int(11) NOT NULL default '-1', - PRIMARY KEY (VarName), - KEY Cached (Cached) -) -# -------------------------------------------------------- CREATE TABLE StylesheetSelectors ( SelectorId int(11) NOT NULL auto_increment, StylesheetId int(11) NOT NULL default '0', @@ -695,28 +353,9 @@ ParentId int(11) NOT NULL default '0', PRIMARY KEY (SelectorId) ) -# -------------------------------------------------------- -CREATE TABLE Stylesheets ( - StylesheetId int(11) NOT NULL auto_increment, - Name varchar(255) NOT NULL default '', - Description varchar(255) NOT NULL default '', - AdvancedCSS text NOT NULL, - LastCompiled int(10) unsigned NOT NULL default '0', - Enabled int(11) NOT NULL default '0', - PRIMARY KEY (StylesheetId) -) -# -------------------------------------------------------- -CREATE TABLE StdDestinations ( - DestId int(11) NOT NULL auto_increment, - DestType int(11) NOT NULL default '0', - DestParentId int(11) default NULL, - DestName varchar(255) NOT NULL default '', - DestAbbr char(3) NOT NULL default '', - DestAbbr2 char(2) default '', - PRIMARY KEY (DestId) -) # -------------------------------------------------------- + CREATE TABLE Visits ( VisitId int(11) NOT NULL auto_increment, VisitDate int(10) unsigned NOT NULL default '0', @@ -728,7 +367,9 @@ KEY PortalUserId (PortalUserId), KEY AffiliateId (AffiliateId) ) + # -------------------------------------------------------- + CREATE TABLE ImportCache ( CacheId int(11) NOT NULL auto_increment, CacheName varchar(255) NOT NULL default '', @@ -738,27 +379,14 @@ KEY CacheName (CacheName), KEY VarName (VarName) ) + # -------------------------------------------------------- -CREATE TABLE PortalUserCustomData ( - CustomDataId int(11) NOT NULL auto_increment, - ResourceId int(10) unsigned NOT NULL default '0', - KEY ResourceId (ResourceId), - PRIMARY KEY (CustomDataId) -) -# -------------------------------------------------------- + CREATE TABLE CategoryCustomData ( CustomDataId int(11) NOT NULL auto_increment, ResourceId int(10) unsigned NOT NULL default '0', KEY ResourceId (ResourceId), PRIMARY KEY (CustomDataId) ) + # -------------------------------------------------------- -CREATE TABLE PopupSizes ( - PopupId int(10) unsigned NOT NULL auto_increment, - TemplateName varchar(255) NOT NULL default '', - PopupWidth int(11) NOT NULL default '0', - PopupHeight int(11) NOT NULL default '0', - PRIMARY KEY (PopupId), - KEY TemplateName (TemplateName) -) -# -------------------------------------------------------- \ No newline at end of file