schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/133-rhn_tasko_run_id_seq.sql.oracle | 29 ++++++++++ schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/133-rhn_tasko_run_id_seq.sql.postgresl | 1 2 files changed, 30 insertions(+)
New commits: commit 5b01c60ba0ea7c667b3d3db1e2b50c6312425f53 Author: Tomas Lestach tlestach@redhat.com Date: Wed Dec 21 13:57:50 2011 +0100
update rhn_tasko_run_id_seq sequence number according to rhn_tasko_template_id_seq
upgrade script for 4561aadd
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/133-rhn_tasko_run_id_seq.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/133-rhn_tasko_run_id_seq.sql.oracle new file mode 100644 index 0000000..88f0b9f --- /dev/null +++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/133-rhn_tasko_run_id_seq.sql.oracle @@ -0,0 +1,29 @@ +BEGIN + DECLARE + seq_template_number NUMBER; + seq_run_number NUMBER; + BEGIN + + EXECUTE IMMEDIATE + 'SELECT rhn_tasko_template_id_seq.nextval FROM dual' + INTO seq_template_number; + + EXECUTE IMMEDIATE + 'SELECT rhn_tasko_run_id_seq.nextval FROM dual' + INTO seq_run_number; + + IF (seq_template_number != seq_run_number) THEN + EXECUTE IMMEDIATE + 'ALTER SEQUENCE rhn_tasko_run_id_seq INCREMENT BY ' || (seq_template_number - seq_run_number); + + EXECUTE IMMEDIATE + 'SELECT rhn_tasko_run_id_seq.nextval FROM dual' + INTO seq_run_number; + + EXECUTE IMMEDIATE + 'ALTER SEQUENCE rhn_tasko_run_id_seq INCREMENT BY 1'; + END IF; + + END; +END; +/ diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/133-rhn_tasko_run_id_seq.sql.postgresl b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/133-rhn_tasko_run_id_seq.sql.postgresl new file mode 100644 index 0000000..24e9b45 --- /dev/null +++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/133-rhn_tasko_run_id_seq.sql.postgresl @@ -0,0 +1 @@ +SELECT PG_CATALOG.SETVAL('rhn_tasko_run_id_seq', (SELECT nextval('rhn_tasko_template_id_seq')), false);
spacewalk-commits@lists.fedorahosted.org