Index: branches/RC/core/install/install_schema.sql =================================================================== diff -u -r10323 -r10399 --- branches/RC/core/install/install_schema.sql (.../install_schema.sql) (revision 10323) +++ branches/RC/core/install/install_schema.sql (.../install_schema.sql) (revision 10399) @@ -375,7 +375,7 @@ l5_Description text, CreatedOn int(11) NOT NULL default '0', EditorsPick tinyint(4) NOT NULL default '0', - `Status` tinyint(4) NOT NULL default '0', + `Status` tinyint(4) NOT NULL default '2', Priority int(11) NOT NULL default '0', MetaKeywords varchar(255) default NULL, CachedDescendantCatsQty int(11) default NULL, Index: branches/RC/admin/install/inportal_schema.sql =================================================================== diff -u -r10323 -r10399 --- branches/RC/admin/install/inportal_schema.sql (.../inportal_schema.sql) (revision 10323) +++ branches/RC/admin/install/inportal_schema.sql (.../inportal_schema.sql) (revision 10399) @@ -130,7 +130,7 @@ 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 '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 '', Index: branches/RC/core/install/upgrades.sql =================================================================== diff -u -r10373 -r10399 --- branches/RC/core/install/upgrades.sql (.../upgrades.sql) (revision 10373) +++ branches/RC/core/install/upgrades.sql (.../upgrades.sql) (revision 10399) @@ -241,4 +241,6 @@ INSERT INTO ConfigurationAdmin VALUES ('AutoRefreshIntervals', 'la_Text_Website', 'la_config_AutoRefreshIntervals', 'text', '', '', 10.26, 0, 0); INSERT INTO ConfigurationValues VALUES (DEFAULT, 'AutoRefreshIntervals', '1,5,15,30,60,120,240', 'In-Portal', 'in-portal:configure_general'); -DELETE FROM Cache WHERE SUBSTRING(VarName, 1, 7) = 'mod_rw_'; \ No newline at end of file +DELETE FROM Cache WHERE SUBSTRING(VarName, 1, 7) = 'mod_rw_'; + +ALTER TABLE Category CHANGE `Status` `Status` TINYINT(4) NOT NULL DEFAULT '2'; \ No newline at end of file Index: branches/RC/core/units/related_searches/related_searches_config.php =================================================================== diff -u -r9489 -r10399 --- branches/RC/core/units/related_searches/related_searches_config.php (.../related_searches_config.php) (revision 9489) +++ branches/RC/core/units/related_searches/related_searches_config.php (.../related_searches_config.php) (revision 10399) @@ -68,13 +68,13 @@ 'Fields' => Array( 'RelatedSearchId' => Array('type' => 'int', 'not_null' => 1, 'default' => 0), - 'ResourceId' => Array('type'=>'int', 'required' => 1, 'default' => NULL), + 'ResourceId' => Array('type'=>'int', 'not_null' => 1, 'required' => 1, 'default' => 0), 'Keyword' => Array('type'=>'string', 'required' => 1, 'not_null' => 1, 'default' => ''), /* 'SourceType' => Array('type'=>'int','not_null'=>1,'default'=>0), 'TargetType' => Array('type'=>'int','not_null'=>1,'default'=>0), */ - 'ItemType' => Array('type'=>'int', 'required' => 1, 'default' => NULL), + 'ItemType' => Array('type'=>'int', 'not_null' => 1, 'required' => 1, 'default' => 0), 'Enabled' => Array('type'=>'int','formatter'=>'kOptionsFormatter','options'=>Array(0=>'la_Disabled',1=>'la_Enabled'),'not_null'=>1,'default'=>1,'use_phrases'=>1), 'Priority' => Array('type'=>'int','not_null'=>1,'default'=>0), ), Index: branches/RC/kernel/units/related_searches/related_searches_config.php =================================================================== diff -u -r9489 -r10399 --- branches/RC/kernel/units/related_searches/related_searches_config.php (.../related_searches_config.php) (revision 9489) +++ branches/RC/kernel/units/related_searches/related_searches_config.php (.../related_searches_config.php) (revision 10399) @@ -68,13 +68,13 @@ 'Fields' => Array( 'RelatedSearchId' => Array('type' => 'int', 'not_null' => 1, 'default' => 0), - 'ResourceId' => Array('type'=>'int', 'required' => 1, 'default' => NULL), + 'ResourceId' => Array('type'=>'int', 'not_null' => 1, 'required' => 1, 'default' => 0), 'Keyword' => Array('type'=>'string', 'required' => 1, 'not_null' => 1, 'default' => ''), /* 'SourceType' => Array('type'=>'int','not_null'=>1,'default'=>0), 'TargetType' => Array('type'=>'int','not_null'=>1,'default'=>0), */ - 'ItemType' => Array('type'=>'int', 'required' => 1, 'default' => NULL), + 'ItemType' => Array('type'=>'int', 'not_null' => 1, 'required' => 1, 'default' => 0), 'Enabled' => Array('type'=>'int','formatter'=>'kOptionsFormatter','options'=>Array(0=>'la_Disabled',1=>'la_Enabled'),'not_null'=>1,'default'=>1,'use_phrases'=>1), 'Priority' => Array('type'=>'int','not_null'=>1,'default'=>0), ), Index: branches/RC/admin/install/upgrades/inportal_upgrade_v4.3.0.sql =================================================================== diff -u -r10373 -r10399 --- branches/RC/admin/install/upgrades/inportal_upgrade_v4.3.0.sql (.../inportal_upgrade_v4.3.0.sql) (revision 10373) +++ branches/RC/admin/install/upgrades/inportal_upgrade_v4.3.0.sql (.../inportal_upgrade_v4.3.0.sql) (revision 10399) @@ -71,6 +71,8 @@ INSERT INTO ConfigurationValues VALUES (DEFAULT, 'AutoRefreshIntervals', '1,5,15,30,60,120,240', 'In-Portal', 'in-portal:configure_general'); DELETE FROM Cache WHERE SUBSTRING(VarName, 1, 7) = 'mod_rw_'; +ALTER TABLE ItemFiles CHANGE `Status` `Status` TINYINT(4) NOT NULL DEFAULT '1'; +ALTER TABLE Category CHANGE `Status` `Status` TINYINT(4) NOT NULL DEFAULT '2'; UPDATE Modules SET Version = '4.3.0' WHERE Name = 'Core'; UPDATE Modules SET Version = '4.3.0' WHERE Name = 'In-Portal'; \ No newline at end of file