Index: branches/unlabeled/unlabeled-1.64.2/admin/install/inportal_schema.sql =================================================================== diff -u -r7775 -r7853 --- branches/unlabeled/unlabeled-1.64.2/admin/install/inportal_schema.sql (.../inportal_schema.sql) (revision 7775) +++ branches/unlabeled/unlabeled-1.64.2/admin/install/inportal_schema.sql (.../inportal_schema.sql) (revision 7853) @@ -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)