schema/spacewalk/common/tables/rhnServerGroupNotes.sql | 51 ---------- schema/spacewalk/common/tables/tables.deps | 1 schema/spacewalk/oracle/triggers/rhnServerGroupNotes.sql | 25 ---- schema/spacewalk/postgres/triggers/rhnServerGroupNotes.sql | 17 --- schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/107-rhnServerGroupNotes-drop.sql | 3 schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/108-rhn_servergroup_note_mod_trig_fun-drop.sql.oracle | 1 schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/108-rhn_servergroup_note_mod_trig_fun-drop.sql.postgresql | 4 7 files changed, 8 insertions(+), 94 deletions(-)
New commits: commit 21e4cf086b5cbb19e2e0090a23a7abd9adffaafe Author: Jan Pazdziora jpazdziora@redhat.com Date: Wed Jun 27 10:45:52 2012 +0200
Table rhnServerGroupNotes not used, removing.
diff --git a/schema/spacewalk/common/tables/rhnServerGroupNotes.sql b/schema/spacewalk/common/tables/rhnServerGroupNotes.sql deleted file mode 100644 index 4774da3..0000000 --- a/schema/spacewalk/common/tables/rhnServerGroupNotes.sql +++ /dev/null @@ -1,51 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- - - -CREATE TABLE rhnServerGroupNotes -( - id NUMBER NOT NULL - CONSTRAINT rhn_servergrp_note_id_pk PRIMARY KEY - USING INDEX TABLESPACE [[64k_tbs]], - creator NUMBER - CONSTRAINT rhn_servergrp_note_creator_fk - REFERENCES web_contact (id) - ON DELETE SET NULL, - server_group_id NUMBER NOT NULL - CONSTRAINT rhn_servergrp_note_fk - REFERENCES rhnServerGroup (id) - ON DELETE CASCADE, - subject VARCHAR2(80) NOT NULL, - note VARCHAR2(4000) NOT NULL, - created DATE - DEFAULT (sysdate) NOT NULL, - modified DATE - DEFAULT (sysdate) NOT NULL -) -ENABLE ROW MOVEMENT -; - -CREATE INDEX rhn_servergrp_note_srvr_id_idx - ON rhnServerGroupNotes (server_group_id) - TABLESPACE [[64k_tbs]] - NOLOGGING; - -CREATE INDEX rhn_servergrp_note_creator_idx - ON rhnServerGroupNotes (creator) - TABLESPACE [[64k_tbs]] - NOLOGGING; - -CREATE SEQUENCE rhn_servergrp_note_id_seq; - diff --git a/schema/spacewalk/common/tables/tables.deps b/schema/spacewalk/common/tables/tables.deps index c0c1c3c..fcfe966 100644 --- a/schema/spacewalk/common/tables/tables.deps +++ b/schema/spacewalk/common/tables/tables.deps @@ -153,7 +153,6 @@ rhnServerCustomDataValue :: rhnCustomDataKey rhnServerDMI :: rhnServer rhnServerGroup :: rhnServerGroupType web_customer rhnServerGroupMembers :: rhnServer rhnServerGroup -rhnServerGroupNotes :: web_contact rhnServerGroup rhnServerGroupTypeFeature :: rhnFeature rhnServerGroupType rhnServerHistory :: rhnServer rhnServerInfo :: rhnServer diff --git a/schema/spacewalk/oracle/triggers/rhnServerGroupNotes.sql b/schema/spacewalk/oracle/triggers/rhnServerGroupNotes.sql deleted file mode 100644 index b17da42..0000000 --- a/schema/spacewalk/oracle/triggers/rhnServerGroupNotes.sql +++ /dev/null @@ -1,25 +0,0 @@ - --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- - -CREATE OR REPLACE TRIGGER -rhn_servergroup_note_mod_trig -BEFORE INSERT OR UPDATE ON rhnServerGroupNotes -FOR EACH ROW -BEGIN - :new.modified := sysdate; -END; -/ -show errors diff --git a/schema/spacewalk/postgres/triggers/rhnServerGroupNotes.sql b/schema/spacewalk/postgres/triggers/rhnServerGroupNotes.sql deleted file mode 100644 index e21d6ed..0000000 --- a/schema/spacewalk/postgres/triggers/rhnServerGroupNotes.sql +++ /dev/null @@ -1,17 +0,0 @@ --- oracle equivalent source sha1 841c287c0b98af0e2234cce570dd68abf0ea2c8c --- retrieved from ./1241102873/cdc6d42049bf86fbc9f1d3a5c54275eeacbd641d/schema/spacewalk/oracle/triggers/rhnServerGroupNotes.sql -create or replace function rhn_servergroup_note_mod_trig_fun() returns trigger as -$$ -begin - new.modified := current_timestamp; - return new; -end; -$$ language plpgsql; - -create trigger -rhn_servergroup_note_mod_trig -before insert or update on rhnServerGroupNotes -for each row -execute procedure rhn_servergroup_note_mod_trig_fun(); - - diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/107-rhnServerGroupNotes-drop.sql b/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/107-rhnServerGroupNotes-drop.sql new file mode 100644 index 0000000..1c95421 --- /dev/null +++ b/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/107-rhnServerGroupNotes-drop.sql @@ -0,0 +1,3 @@ + +drop table rhnServerGroupNotes; + diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/108-rhn_servergroup_note_mod_trig_fun-drop.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/108-rhn_servergroup_note_mod_trig_fun-drop.sql.oracle new file mode 100644 index 0000000..b7b00b1 --- /dev/null +++ b/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/108-rhn_servergroup_note_mod_trig_fun-drop.sql.oracle @@ -0,0 +1 @@ +-- This file is intentionally left empty. diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/108-rhn_servergroup_note_mod_trig_fun-drop.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/108-rhn_servergroup_note_mod_trig_fun-drop.sql.postgresql new file mode 100644 index 0000000..e124417 --- /dev/null +++ b/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/108-rhn_servergroup_note_mod_trig_fun-drop.sql.postgresql @@ -0,0 +1,4 @@ +-- oracle equivalent source sha1 b14267384bc104605623a41b755e68e0103b5aa8 + +drop function rhn_servergroup_note_mod_trig_fun(); +
spacewalk-commits@lists.fedorahosted.org