mvhub-dev team mailing list archive

[Priya Ravindran <pthirumal@xxxxxxxxxx>]

Priya Ravindran has proposed merging lp:~priya/mvhub/fix_db_schema_update into lp:mvhub.

Requested reviews:
  MVHub devs with commit rights (mvhub-commit)


modified template_version_log_Sql to include version number
-- 
https://code.launchpad.net/~priya/mvhub/fix_db_schema_update/+merge/25551
Your team MVHub Developers is subscribed to branch lp:mvhub.

=== 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 19:04:26 +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 19:04:26 +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 19:04:26 +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 19:04:26 +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;