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(a)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);
Show replies by date