schema/spacewalk/common/tables/rhnChannel.sql | 1 +
schema/spacewalk/common/tables/rhnContentSource.sql | 1 -
2 files changed, 1 insertion(+), 1 deletion(-)
New commits:
commit d9bde2e9fc8a9289b9e3c7924c45d19c41d836f2
Author: Shannon Hughes <shughes(a)redhat.com>
Date: Wed Jun 30 14:37:59 2010 -0400
modify last_synced column for repo sync
diff --git a/schema/spacewalk/common/tables/rhnChannel.sql
b/schema/spacewalk/common/tables/rhnChannel.sql
index ab83082..0e8caff 100644
--- a/schema/spacewalk/common/tables/rhnChannel.sql
+++ b/schema/spacewalk/common/tables/rhnChannel.sql
@@ -48,6 +48,7 @@ CREATE TABLE rhnChannel
CHECK (receiving_updates in ( 'Y' , 'N'
)),
last_modified DATE
DEFAULT (sysdate) NOT NULL,
+ last_synced DATE,
channel_product_id NUMBER
CONSTRAINT rhn_channel_cpid_fk
REFERENCES rhnChannelProduct (id),
diff --git a/schema/spacewalk/common/tables/rhnContentSource.sql
b/schema/spacewalk/common/tables/rhnContentSource.sql
index 03882ab..d7912c3 100644
--- a/schema/spacewalk/common/tables/rhnContentSource.sql
+++ b/schema/spacewalk/common/tables/rhnContentSource.sql
@@ -29,7 +29,6 @@ rhnContentSource
references rhnContentSourceType(id),
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
)
Show replies by date