modules/core/dbutils/src/main/scripts/dbsetup/inventory-schema.xml | 2 +- modules/core/dbutils/src/main/scripts/dbupgrade/db-upgrade.xml | 1 + 2 files changed, 2 insertions(+), 1 deletion(-)
New commits: commit 501e5d1c1bc27399c5c46a9778829bd927925ed5 Author: John Sanda jsanda@redhat.com Date: Tue Oct 19 14:05:56 2010 -0400
making deleted column not nullable
diff --git a/modules/core/dbutils/src/main/scripts/dbsetup/inventory-schema.xml b/modules/core/dbutils/src/main/scripts/dbsetup/inventory-schema.xml index 1644849..a181d83 100644 --- a/modules/core/dbutils/src/main/scripts/dbsetup/inventory-schema.xml +++ b/modules/core/dbutils/src/main/scripts/dbsetup/inventory-schema.xml @@ -17,7 +17,7 @@ <column name="PLUGIN" type="VARCHAR2" size="100"/> <column name="CTIME" type="LONG"/> <column name="MTIME" type="LONG"/> - <column name="DELETED" type="BOOLEAN" default="FALSE"/> + <column name="DELETED" type="BOOLEAN" default="FALSE" required="TRUE"/> <column name="SUBCATEGORY_ID" type="INTEGER"/> <!-- TODO add support to DB setup for tables with circular dependencies and then add back this RI diff --git a/modules/core/dbutils/src/main/scripts/dbupgrade/db-upgrade.xml b/modules/core/dbutils/src/main/scripts/dbupgrade/db-upgrade.xml index 4b4c6a0..69d7e3c 100644 --- a/modules/core/dbutils/src/main/scripts/dbupgrade/db-upgrade.xml +++ b/modules/core/dbutils/src/main/scripts/dbupgrade/db-upgrade.xml @@ -3263,6 +3263,7 @@ SET DELETED = false </statement> </schema-directSQL> + <schema-alterColumn table="RHQ_RESOURCE_TYPE" column="DELETED" nullable="FALSE" /> </schemaSpec> </dbupgrade> </target>
rhq-commits@lists.fedorahosted.org