[Aplaws-commit] r1150 - trunk/ccm-core/sql/ccm-core/default/upgrade/6.2.0-6.3.1

[<ap...@vh...>]

Author: apevec
Date: 2006-06-08 00:08:17 +0200 (Thu, 08 Jun 2006)
New Revision: 1150

Added:
   trunk/ccm-core/sql/ccm-core/default/upgrade/6.2.0-6.3.1/auto-categorization.sql
Log:
sql upgrade script for isAuto flag


Added: trunk/ccm-core/sql/ccm-core/default/upgrade/6.2.0-6.3.1/auto-categorization.sql
===================================================================
--- trunk/ccm-core/sql/ccm-core/default/upgrade/6.2.0-6.3.1/auto-categorization.sql	2006-06-07 21:57:40 UTC (rev 1149)
+++ trunk/ccm-core/sql/ccm-core/default/upgrade/6.2.0-6.3.1/auto-categorization.sql	2006-06-07 22:08:17 UTC (rev 1150)
@@ -0,0 +1,3 @@
+alter table cat_object_category_map add auto_p char(1) default '0'
+    constraint cat_obj_map_auto_p_ck
+    check (auto_p in ('0','1')) ;