mvhub-dev team mailing list archive

[noreply@xxxxxxxxxxxxx]

Merge authors:
  Priya Ravindran (priya)
Related merge proposals:
  https://code.launchpad.net/~priya/mvhub/fix_db_schema_update/+merge/25551
  proposed by: Priya Ravindran (priya)
  review: Approve - Dan MacNeil (omacneil)
------------------------------------------------------------
revno: 398 [merge]
committer: Priya Ravindran <pthirumal@xxxxxxxxxx>
branch nick: trunk
timestamp: Thu 2010-06-03 12:09:44 -0400
message:
  Modified template_version_log_sql to include version numbers
modified:
  app-mvhub/project-tools/templates/template_version_log.sql
  app-mvhub/setup/database/sql/001_setup_version_log.sql
  app-mvhub/setup/database/sql/002_add_comment_to_version_log_table.sql
  app-mvhub/setup/database/sql/003_add_empty_constraint_to_note.sql


--
lp:mvhub
https://code.launchpad.net/~mvhub-commit/mvhub/trunk

Your team MVHub Developers is subscribed to branch lp:mvhub.
To unsubscribe from this branch go to https://code.launchpad.net/~mvhub-commit/mvhub/trunk/+edit-subscription

=== modified file 'app-mvhub/project-tools/templates/template_version_log.sql'
--- app-mvhub/project-tools/templates/template_version_log.sql	2010-04-30 20:23:54 +0000
+++ app-mvhub/project-tools/templates/template_version_log.sql	2010-05-18 18:53:08 +0000
@@ -1,5 +1,6 @@
+--add version number and note before you add the other sql
 BEGIN;
-INSERT INTO version_log ( note ) 
-	VALUES ('');
+INSERT INTO version_log ( version,note ) 
+	VALUES (,'');
 
 COMMIT;

=== modified file 'app-mvhub/setup/database/sql/001_setup_version_log.sql'
--- app-mvhub/setup/database/sql/001_setup_version_log.sql	2010-04-30 20:23:54 +0000
+++ app-mvhub/setup/database/sql/001_setup_version_log.sql	2010-05-18 18:53:08 +0000
@@ -4,14 +4,14 @@
 DROP TABLE IF EXISTS meta_schema_version;
 
 CREATE TABLE version_log (
-	version SERIAL PRIMARY KEY,
+	version INTEGER PRIMARY KEY,
 	change_date DATE NOT NULL DEFAULT now(),
 	note TEXT NOT NULL UNIQUE
 );
 
 COMMENT ON TABLE version_log IS 'Tracks schema and other metadata changes for MVHub app';
 
-INSERT INTO version_log ( note ) 
-	VALUES ('initial creation of the version log table');
-
+INSERT INTO version_log ( version,note ) 
+	VALUES (1,'initial creation of the version log table');
+         
 COMMIT;

=== modified file 'app-mvhub/setup/database/sql/002_add_comment_to_version_log_table.sql'
--- app-mvhub/setup/database/sql/002_add_comment_to_version_log_table.sql	2010-04-30 20:23:54 +0000
+++ app-mvhub/setup/database/sql/002_add_comment_to_version_log_table.sql	2010-05-18 18:53:08 +0000
@@ -1,6 +1,6 @@
 BEGIN;
-INSERT INTO version_log ( note ) 
-	VALUES ('make SQL COMMENT on version_log table');
+INSERT INTO version_log ( version,note ) 
+	VALUES (2,'make SQL COMMENT on version_log table');
 
 COMMENT ON TABLE version_log IS 'Tracks schema and other metadata changes for MVHub app';
 COMMIT;

=== modified file 'app-mvhub/setup/database/sql/003_add_empty_constraint_to_note.sql'
--- app-mvhub/setup/database/sql/003_add_empty_constraint_to_note.sql	2010-04-30 20:23:54 +0000
+++ app-mvhub/setup/database/sql/003_add_empty_constraint_to_note.sql	2010-05-18 18:53:08 +0000
@@ -1,7 +1,7 @@
 BEGIN;
-INSERT INTO version_log ( note ) 
-	VALUES ('Added a constraint to version_log.note to disallow empty strings');
-
 ALTER TABLE version_log ADD CONSTRAINT version_log_note CHECK ( note <> '');
+INSERT INTO version_log (version, note ) 
+	VALUES (3,'Added a constraint to version_log.note to disallow empty strings');
+
 
 COMMIT;