schema/spacewalk/common/tables/rhnChannelContentSource.sql
| 21 ++-----
schema/spacewalk/common/tables/rhnContentSourceType.sql
| 14 +---
schema/spacewalk/common/tables/tables.deps
| 1
schema/spacewalk/upgrade/spacewalk-schema-0.5-to-spacewalk-schema-0.6/191-rhnContentSourceType.sql
| 16 ++---
schema/spacewalk/upgrade/spacewalk-schema-0.5-to-spacewalk-schema-0.6/192-rhnChannelContentSource.sql
| 29 ++++------
5 files changed, 32 insertions(+), 49 deletions(-)
New commits:
commit 8d101a35ee4314457144d90a0a10f2d761d47533
Author: Justin Sherrill <jsherril(a)redhat.com>
Date: Tue Aug 4 16:55:09 2009 -0400
updating repo-sync schema to better conform with new schema standards, also adding
deps
diff --git a/schema/spacewalk/common/tables/rhnChannelContentSource.sql
b/schema/spacewalk/common/tables/rhnChannelContentSource.sql
index f0b30a5..93c1b81 100644
--- a/schema/spacewalk/common/tables/rhnChannelContentSource.sql
+++ b/schema/spacewalk/common/tables/rhnChannelContentSource.sql
@@ -19,26 +19,19 @@
create table
rhnChannelContentSource
(
- id number
- constraint rhn_ccs_id_nn not null
+ id number NOT NULL
constraint rhn_ccs_id_pk primary key,
- channel_id number
- constraint rhn_ccs_c_nn not null
+ channel_id number NOT NULL
constraint rhn_ccs_c_fk
references rhnChannel(id) on delete cascade,
- type_id number
- constraint rhn_ccs_type_nn not null
+ type_id number NOT NULL
constraint rhn_ccs_type_fk
references rhnContentSourceType(id),
- source_url varchar2(512)
- constraint rhn_ccs_url_nn not null,
- label varchar2(64)
- constraint rhn_ccs_l_nn not null,
+ source_url varchar2(512) NOT NULL,
+ label varchar2(64) NOT NULL,
last_synced date,
- created date default(sysdate)
- constraint rhn_ccs_cre_nn not null,
- modified date default(sysdate)
- constraint rhn_ccs_mod_nn not null
+ created date default(sysdate) NOT NULL,
+ modified date default(sysdate) NOT NULL
)
enable row movement
;
diff --git a/schema/spacewalk/common/tables/rhnContentSourceType.sql
b/schema/spacewalk/common/tables/rhnContentSourceType.sql
index 6e0ce24..aeba44d 100644
--- a/schema/spacewalk/common/tables/rhnContentSourceType.sql
+++ b/schema/spacewalk/common/tables/rhnContentSourceType.sql
@@ -19,17 +19,13 @@
create table
rhnContentSourceType
(
- id number
- constraint rhn_cst_id_nn not null
+ id number NOT NULL
constraint rhn_cst_id_pk primary key,
- label varchar2(32)
- constraint rhn_cst_label_nn not null
+ label varchar2(32) NOT NULL
constraint rhn_cst_label_uq unique,
- created date default(sysdate)
- constraint rhn_cst_created_nn not null,
- modified date default(sysdate)
- constraint rhn_cst_modified_nn not null
-)
+ created date default(sysdate) NOT NULL,
+ modified date default(sysdate) NOT NULL
+)
enable row movement
;
diff --git a/schema/spacewalk/common/tables/tables.deps
b/schema/spacewalk/common/tables/tables.deps
index 0dd3d79..2bae2aa 100644
--- a/schema/spacewalk/common/tables/tables.deps
+++ b/schema/spacewalk/common/tables/tables.deps
@@ -66,6 +66,7 @@ rhnChannelPackageArchCompat :: rhnPackageArch rhnChannelArch
rhnChannelPermission :: rhnChannelPermissionRole rhnChannel web_contact
rhnChannelRelationship :: rhnRelationshipType rhnChannel
rhnChannelTrust :: rhnChannel
+rhnChannelContentSource :: rhnChannel rhnContentSourceType
rhnClientCapability :: rhnClientCapabilityName
rhnClientOptionVersionMap :: rhnClientConfigOption rhnPackageEVR
rhnConfigFile :: rhnConfigChannel rhnConfigFileState rhnConfigFileName
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.5-to-spacewalk-schema-0.6/191-rhnContentSourceType.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.5-to-spacewalk-schema-0.6/191-rhnContentSourceType.sql
index 546a3e1..889f747 100644
---
a/schema/spacewalk/upgrade/spacewalk-schema-0.5-to-spacewalk-schema-0.6/191-rhnContentSourceType.sql
+++
b/schema/spacewalk/upgrade/spacewalk-schema-0.5-to-spacewalk-schema-0.6/191-rhnContentSourceType.sql
@@ -19,20 +19,18 @@
create table
rhnContentSourceType
(
- id number
- constraint rhn_cst_id_nn not null
+ id number NOT NULL
constraint rhn_cst_id_pk primary key,
- label varchar2(32)
- constraint rhn_cst_label_nn not null
+ label varchar2(32) NOT NULL
constraint rhn_cst_label_uq unique,
- created date default(sysdate)
- constraint rhn_cst_created_nn not null,
- modified date default(sysdate)
- constraint rhn_cst_modified_nn not null
+ created date default(sysdate) NOT NULL,
+ modified date default(sysdate) NOT NULL
)
- enable row movement
+ enable row movement
;
+
+
create sequence rhn_content_source_type_id_seq start with 500;
create index rhn_ccst_id_l_idx
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.5-to-spacewalk-schema-0.6/192-rhnChannelContentSource.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.5-to-spacewalk-schema-0.6/192-rhnChannelContentSource.sql
index ccf5cb8..03ce034 100644
---
a/schema/spacewalk/upgrade/spacewalk-schema-0.5-to-spacewalk-schema-0.6/192-rhnChannelContentSource.sql
+++
b/schema/spacewalk/upgrade/spacewalk-schema-0.5-to-spacewalk-schema-0.6/192-rhnChannelContentSource.sql
@@ -16,34 +16,29 @@
--
--
+
create table
rhnChannelContentSource
(
- id number
- constraint rhn_ccs_id_nn not null
- constraint rhn_ccs_id_pk primary key,
- channel_id number
- constraint rhn_ccs_c_nn not null
+ id number NOT NULL
+ constraint rhn_ccs_id_pk primary key,
+ channel_id number NOT NULL
constraint rhn_ccs_c_fk
references rhnChannel(id) on delete cascade,
- type_id number
- constraint rhn_ccs_type_nn not null
+ type_id number NOT NULL
constraint rhn_ccs_type_fk
references rhnContentSourceType(id),
- source_url varchar2(512)
- constraint rhn_ccs_url_nn not null,
- label varchar2(64)
- constraint rhn_ccs_l_nn not null,
- last_synced date,
- created date default(sysdate)
- constraint rhn_ccs_cre_nn not null,
- modified date default(sysdate)
- constraint rhn_ccs_mod_nn not null
+ source_url varchar2(512) NOT NULL,
+ label varchar2(64) NOT NULL,
+ last_synced date,
+ created date default(sysdate) NOT NULL,
+ modified date default(sysdate) NOT NULL
)
- enable row movement
+ enable row movement
;
+
create sequence rhn_chan_content_src_id_seq start with 500;
Show replies by date