Index: trunk/admin/install/inportal_schema.sql =================================================================== diff -u -N -r7391 -r7867 --- trunk/admin/install/inportal_schema.sql (.../inportal_schema.sql) (revision 7391) +++ trunk/admin/install/inportal_schema.sql (.../inportal_schema.sql) (revision 7867) @@ -52,8 +52,8 @@ ThumbUrl varchar(255) default NULL, Priority int(11) NOT NULL default '0', ThumbPath varchar(255) default NULL, - LocalThumb tinyint(4) NOT NULL default '0', - SameImages tinyint(4) NOT NULL default '0', + LocalThumb tinyint(4) NOT NULL default '1', + SameImages tinyint(4) NOT NULL default '1', PRIMARY KEY (ImageId), KEY ResourceId (ResourceId) ) @@ -77,10 +77,10 @@ ReviewText longtext NOT NULL, IPAddress varchar(255) NOT NULL default '', ItemId int(11) NOT NULL default '0', - CreatedById 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 '0', + Status tinyint(4) NOT NULL default '2', TextFormat int(11) NOT NULL default '0', Module varchar(255) NOT NULL default '', PRIMARY KEY (ReviewId) @@ -127,8 +127,8 @@ CREATE TABLE SearchConfig ( TableName varchar(40) NOT NULL default '', FieldName varchar(40) NOT NULL default '', - SimpleSearch tinyint(4) NOT NULL default '0', - AdvancedSearch tinyint(4) NOT NULL default '0', + 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) default NULL, @@ -271,7 +271,7 @@ 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 '0', + PortalUserId int(11) NOT NULL default '-2', PRIMARY KEY (VisitId), KEY PortalUserId (PortalUserId), KEY AffiliateId (AffiliateId) @@ -290,12 +290,3 @@ ) # -------------------------------------------------------- - -CREATE TABLE CategoryCustomData ( - CustomDataId int(11) NOT NULL auto_increment, - ResourceId int(10) unsigned NOT NULL default '0', - KEY ResourceId (ResourceId), - PRIMARY KEY (CustomDataId) -) - -# --------------------------------------------------------