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 f167d3614e58cc62e02de088b1d3dcaae7a3a19a
Merge: 0f62ed4... 501e5d1...
Author: John Sanda <jsanda(a)redhat.com>
Date: Tue Oct 19 14:07:04 2010 -0400
Merge branch 'delete-agent-plugin'
commit 501e5d1c1bc27399c5c46a9778829bd927925ed5
Author: John Sanda <jsanda(a)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>
Show replies by date