Index: branches/RC/core/install/install_schema.sql
===================================================================
diff -u -r10987 -r11121
--- branches/RC/core/install/install_schema.sql	(.../install_schema.sql)	(revision 10987)
+++ branches/RC/core/install/install_schema.sql	(.../install_schema.sql)	(revision 11121)
@@ -643,3 +643,322 @@
   ANSICodePage varchar(10) NOT NULL default '',
   PRIMARY KEY (LocaleId)
 );
+
+CREATE TABLE BanRules (
+  RuleId int(11) NOT NULL auto_increment,
+  RuleType tinyint(4) NOT NULL default '0',
+  ItemField varchar(255) default NULL,
+  ItemVerb tinyint(4) NOT NULL default '0',
+  ItemValue varchar(255) NOT NULL default '',
+  ItemType int(11) NOT NULL default '0',
+  Priority int(11) NOT NULL default '0',
+  Status tinyint(4) NOT NULL default '1',
+  ErrorTag varchar(255) default NULL,
+  PRIMARY KEY  (RuleId),
+  KEY Status (Status),
+  KEY Priority (Priority),
+  KEY ItemType (ItemType)
+);
+
+CREATE TABLE CountCache (
+  ListType int(11) NOT NULL default '0',
+  ItemType int(11) NOT NULL default '-1',
+  Value int(11) NOT NULL default '0',
+  CountCacheId int(11) NOT NULL auto_increment,
+  LastUpdate int(11) NOT NULL default '0',
+  ExtraId varchar(50) default NULL,
+  TodayOnly tinyint(4) NOT NULL default '0',
+  PRIMARY KEY  (CountCacheId)
+);
+
+CREATE TABLE Favorites (
+  FavoriteId int(11) NOT NULL auto_increment,
+  PortalUserId int(11) NOT NULL default '0',
+  ResourceId int(11) NOT NULL default '0',
+  ItemTypeId int(11) NOT NULL default '0',
+  Modified int(11) NOT NULL default '0',
+  PRIMARY KEY  (FavoriteId),
+  UNIQUE KEY main (PortalUserId,ResourceId),
+  KEY Modified (Modified),
+  KEY ItemTypeId (ItemTypeId)
+);
+
+CREATE TABLE Images (
+  ImageId int(11) NOT NULL auto_increment,
+  ResourceId int(11) NOT NULL default '0',
+  Url varchar(255) NOT NULL default '',
+  Name varchar(255) NOT NULL default '',
+  AltName VARCHAR(255) NOT NULL DEFAULT '',
+  ImageIndex int(11) NOT NULL default '0',
+  LocalImage tinyint(4) NOT NULL default '1',
+  LocalPath varchar(240) NOT NULL default '',
+  Enabled int(11) NOT NULL default '1',
+  DefaultImg int(11) NOT NULL default '0',
+  ThumbUrl varchar(255) default NULL,
+  Priority int(11) NOT NULL default '0',
+  ThumbPath varchar(255) default NULL,
+  LocalThumb tinyint(4) NOT NULL default '1',
+  SameImages tinyint(4) NOT NULL default '1',
+  PRIMARY KEY  (ImageId),
+  KEY ResourceId (ResourceId),
+  KEY Enabled (Enabled),
+  KEY Priority (Priority)
+);
+
+CREATE TABLE ItemRating (
+  RatingId int(11) NOT NULL auto_increment,
+  IPAddress varchar(255) NOT NULL default '',
+  CreatedOn INT UNSIGNED NULL DEFAULT NULL,
+  RatingValue int(11) NOT NULL default '0',
+  ItemId int(11) NOT NULL default '0',
+  PRIMARY KEY  (RatingId),
+  KEY CreatedOn (CreatedOn),
+  KEY ItemId (ItemId),
+  KEY RatingValue (RatingValue)
+);
+
+CREATE TABLE ItemReview (
+  ReviewId int(11) NOT NULL auto_increment,
+  CreatedOn INT UNSIGNED NULL DEFAULT NULL,
+  ReviewText longtext NOT NULL,
+  Rating tinyint(3) unsigned default NULL,
+  IPAddress varchar(255) NOT NULL default '',
+  ItemId int(11) NOT NULL default '0',
+  CreatedById int(11) NOT NULL default '-1',
+  ItemType tinyint(4) NOT NULL default '0',
+  Priority int(11) NOT NULL default '0',
+  Status tinyint(4) NOT NULL default '2',
+  TextFormat int(11) NOT NULL default '0',
+  Module varchar(255) NOT NULL default '',
+  PRIMARY KEY  (ReviewId),
+  KEY CreatedOn (CreatedOn),
+  KEY ItemId (ItemId),
+  KEY ItemType (ItemType),
+  KEY Priority (Priority),
+  KEY Status (Status)
+);
+
+CREATE TABLE ItemTypes (
+  ItemType int(11) NOT NULL default '0',
+  Module varchar(50) NOT NULL default '',
+  Prefix varchar(20) NOT NULL default '',
+  SourceTable varchar(100) NOT NULL default '',
+  TitleField varchar(50) default NULL,
+  CreatorField varchar(255) NOT NULL default '',
+  PopField varchar(255) default NULL,
+  RateField varchar(255) default NULL,
+  LangVar varchar(255) NOT NULL default '',
+  PrimaryItem int(11) NOT NULL default '0',
+  EditUrl varchar(255) NOT NULL default '',
+  ClassName varchar(40) NOT NULL default '',
+  ItemName varchar(50) NOT NULL default '',
+  PRIMARY KEY  (ItemType),
+  KEY Module (Module)
+);
+
+CREATE TABLE ItemFiles (
+  FileId int(11) NOT NULL auto_increment,
+  ResourceId int(11) unsigned NOT NULL default '0',
+  FileName varchar(255) NOT NULL default '',
+  FilePath varchar(255) NOT NULL default '',
+  Size int(11) NOT NULL default '0',
+  `Status` tinyint(4) NOT NULL default '1',
+  CreatedOn int(11) unsigned NOT NULL default '0',
+  CreatedById int(11) NOT NULL default '-1',
+  MimeType varchar(255) NOT NULL default '',
+  PRIMARY KEY  (FileId),
+  KEY ResourceId (ResourceId),
+  KEY CreatedOn (CreatedOn),
+  KEY Status (Status)
+);
+
+CREATE TABLE Relationship (
+  RelationshipId int(11) NOT NULL auto_increment,
+  SourceId int(11) default NULL,
+  TargetId int(11) default NULL,
+  SourceType tinyint(4) NOT NULL default '0',
+  TargetType tinyint(4) NOT NULL default '0',
+  Type int(11) NOT NULL default '0',
+  Enabled int(11) NOT NULL default '1',
+  Priority int(11) NOT NULL default '0',
+  PRIMARY KEY  (RelationshipId),
+  KEY RelSource (SourceId),
+  KEY RelTarget (TargetId),
+  KEY `Type` (`Type`),
+  KEY Enabled (Enabled),
+  KEY Priority (Priority),
+  KEY SourceType (SourceType),
+  KEY TargetType (TargetType)
+);
+
+CREATE TABLE SearchConfig (
+  TableName varchar(40) NOT NULL default '',
+  FieldName varchar(40) NOT NULL default '',
+  SimpleSearch tinyint(4) NOT NULL default '1',
+  AdvancedSearch tinyint(4) NOT NULL default '1',
+  Description varchar(255) default NULL,
+  DisplayName varchar(80) default NULL,
+  ModuleName VARCHAR(20) NOT NULL DEFAULT 'In-Portal',
+  ConfigHeader varchar(255) default NULL,
+  DisplayOrder int(11) NOT NULL default '0',
+  SearchConfigId int(11) NOT NULL auto_increment,
+  Priority int(11) NOT NULL default '0',
+  FieldType varchar(20) NOT NULL default 'text',
+  ForeignField TEXT,
+  JoinClause TEXT,
+  IsWhere text,
+  IsNotWhere text,
+  ContainsWhere text,
+  NotContainsWhere text,
+  CustomFieldId int(11) default NULL,
+  PRIMARY KEY  (SearchConfigId),
+  KEY SimpleSearch (SimpleSearch),
+  KEY AdvancedSearch (AdvancedSearch),
+  KEY DisplayOrder (DisplayOrder),
+  KEY Priority (Priority),
+  KEY CustomFieldId (CustomFieldId)
+);
+
+CREATE TABLE SearchLog (
+  SearchLogId int(11) NOT NULL auto_increment,
+  Keyword varchar(255) NOT NULL default '',
+  Indices bigint(20) NOT NULL default '0',
+  SearchType int(11) NOT NULL default '0',
+  PRIMARY KEY  (SearchLogId),
+  KEY SearchType (SearchType)
+);
+
+CREATE TABLE IgnoreKeywords (
+  keyword varchar(20) NOT NULL default '',
+  PRIMARY KEY  (keyword)
+);
+
+CREATE TABLE SpamControl (
+  ItemResourceId int(11) NOT NULL default '0',
+  IPaddress varchar(20) NOT NULL default '',
+  Expire INT UNSIGNED NULL DEFAULT NULL,
+  PortalUserId int(11) NOT NULL default '0',
+  DataType varchar(20) default NULL,
+  KEY PortalUserId (PortalUserId),
+  KEY Expire (Expire),
+  KEY ItemResourceId (ItemResourceId)
+);
+
+CREATE TABLE StatItem (
+  StatItemId int(11) NOT NULL auto_increment,
+  Module varchar(20) NOT NULL default '',
+  ValueSQL varchar(255) default NULL,
+  ResetSQL varchar(255) default NULL,
+  ListLabel varchar(255) NOT NULL default '',
+  Priority int(11) NOT NULL default '0',
+  AdminSummary int(11) NOT NULL default '0',
+  PRIMARY KEY  (StatItemId),
+  KEY AdminSummary (AdminSummary),
+  KEY Priority (Priority)
+);
+
+CREATE TABLE SuggestMail (
+  email varchar(255) NOT NULL default '',
+  sent INT UNSIGNED NULL DEFAULT NULL,
+  PRIMARY KEY  (email),
+  KEY sent (sent)
+);
+
+CREATE TABLE SysCache (
+  SysCacheId int(11) NOT NULL auto_increment,
+  Name varchar(255) NOT NULL default '',
+  Value mediumtext,
+  Expire INT UNSIGNED NULL DEFAULT NULL,
+  Module varchar(20) default NULL,
+  Context varchar(255) default NULL,
+  GroupList varchar(255) NOT NULL default '',
+  PRIMARY KEY  (SysCacheId),
+  KEY Name (Name)
+);
+
+CREATE TABLE TagLibrary (
+  TagId int(11) NOT NULL auto_increment,
+  name varchar(255) NOT NULL default '',
+  description text,
+  example text,
+  scope varchar(20) NOT NULL default 'global',
+  PRIMARY KEY  (TagId)
+);
+
+CREATE TABLE TagAttributes (
+  AttrId int(11) NOT NULL auto_increment,
+  TagId int(11) NOT NULL default '0',
+  Name varchar(255) NOT NULL default '',
+  AttrType varchar(20) default NULL,
+  DefValue varchar(255) default NULL,
+  Description TEXT,
+  Required int(11) NOT NULL default '0',
+  PRIMARY KEY  (AttrId),
+  KEY TagId (TagId)
+);
+
+CREATE TABLE ImportScripts (
+  ImportId INT(11) NOT NULL auto_increment,
+  Name VARCHAR(255) NOT NULL DEFAULT '',
+  Description TEXT NOT NULL,
+  Prefix VARCHAR(10) NOT NULL DEFAULT '',
+  Module VARCHAR(50) NOT NULL DEFAULT '',
+  ExtraFields VARCHAR(255) NOT NULL DEFAULT '',
+  Type VARCHAR(10) NOT NULL DEFAULT '',
+  Status TINYINT NOT NULL,
+  PRIMARY KEY (ImportId),
+  KEY Module (Module),
+  KEY Status (Status)
+);
+
+CREATE TABLE StylesheetSelectors (
+  SelectorId int(11) NOT NULL auto_increment,
+  StylesheetId int(11) NOT NULL default '0',
+  Name varchar(255) NOT NULL default '',
+  SelectorName varchar(255) NOT NULL default '',
+  SelectorData text NOT NULL,
+  Description text NOT NULL,
+  Type tinyint(4) NOT NULL default '0',
+  AdvancedCSS text NOT NULL,
+  ParentId int(11) NOT NULL default '0',
+  PRIMARY KEY  (SelectorId),
+  KEY StylesheetId (StylesheetId),
+  KEY ParentId (ParentId),
+  KEY `Type` (`Type`)
+);
+
+CREATE TABLE Visits (
+  VisitId int(11) NOT NULL auto_increment,
+  VisitDate int(10) unsigned NOT NULL default '0',
+  Referer varchar(255) NOT NULL default '',
+  IPAddress varchar(15) NOT NULL default '',
+  AffiliateId int(10) unsigned NOT NULL default '0',
+  PortalUserId int(11) NOT NULL default '-2',
+  PRIMARY KEY  (VisitId),
+  KEY PortalUserId (PortalUserId),
+  KEY AffiliateId (AffiliateId),
+  KEY VisitDate (VisitDate)
+);
+
+CREATE TABLE ImportCache (
+  CacheId int(11) NOT NULL auto_increment,
+  CacheName varchar(255) NOT NULL default '',
+  VarName int(11) NOT NULL default '0',
+  VarValue text NOT NULL,
+  PRIMARY KEY  (CacheId),
+  KEY CacheName (CacheName),
+  KEY VarName (VarName)
+);
+
+CREATE TABLE RelatedSearches (
+  RelatedSearchId int(11) NOT NULL auto_increment,
+  ResourceId int(11) NOT NULL default '0',
+  Keyword varchar(255) NOT NULL default '',
+  ItemType tinyint(4) NOT NULL default '0',
+  Enabled tinyint(4) NOT NULL default '1',
+  Priority int(11) NOT NULL default '0',
+  PRIMARY KEY  (RelatedSearchId),
+  KEY Enabled (Enabled),
+  KEY ItemType (ItemType),
+  KEY ResourceId (ResourceId)
+);
\ No newline at end of file