fixing typos.

diff --git a/dbscripts/populate_dbpatches.sql b/dbscripts/populate_dbpatches.sql
index 0e46e6f..6dabf4b 100755 (executable)
--- a/dbscripts/populate_dbpatches.sql
+++ b/dbscripts/populate_dbpatches.sql
@@ -1,11 +1,11 @@
 
-INSERT INTO "db_patches" VALUES (1, DATE '2002-12-13', "* introduces sequences and primary keys for comment_status, article_type and
-language\n * adds is_html to comment");
-INSERT INTO "db_patches" VALUES (2, DATE '2003-04-09', "* creates table comment_x_media, to support media in comments\n * adds webdb_lastchange to comment");
-INSERT INTO "db_patches" VALUES (3, DATE '2003-11-22', "* added a bunch of fields to webdb_user: is_disabled, email, profile, creation date, last login date");
-INSERT INTO "db_patches" VALUES (4, DATE '2003-11-24', "* Clean up comments\n * added a comment field for internal comments");
-INSERT INTO "db_patches" VALUES (5, DATE '2003-11-25', "* Removal of media (uploaded_media and content are now independently)\n * Clean up of content\n * Added a field for content-locking\n * Added a keywords field for content");
-INSERT INTO "db_patches" VALUES (6, DATE '2003-12-12', "* makes login unique on webdb_users\n * drops unnecessary index on webdb_users\n * inserts a line for ogg support in media_types\n * drop "- deprecated -" from media_types\n * drop redundant index on id of topic\n * drop redundant index on id of comment\n * recreate indexes on content_x_media");
-INSERT INTO "db_patches" VALUES (7, DATE '2005-01-09', "* adds filter and filtergroups to the database");
-INSERT INTO "db_patches" VALUES (8, DATE '2005-09-13', "* adds 'db_patches' and 'model_version' tables to the database");
+INSERT INTO "db_patches" VALUES (1, DATE '2002-12-13', '* introduces sequences and primary keys for comment_status, article_type and
+language\n * adds is_html to comment');
+INSERT INTO "db_patches" VALUES (2, DATE '2003-04-09', '* creates table comment_x_media, to support media in comments\n * adds webdb_lastchange to comment');
+INSERT INTO "db_patches" VALUES (3, DATE '2003-11-22', '* added a bunch of fields to webdb_user: is_disabled, email, profile, creation date, last login date');
+INSERT INTO "db_patches" VALUES (4, DATE '2003-11-24', '* Clean up comments\n * added a comment field for internal comments');
+INSERT INTO "db_patches" VALUES (5, DATE '2003-11-25', '* Removal of media (uploaded_media and content are now independently)\n * Clean up of content\n * Added a field for content-locking\n * Added a keywords field for content');
+INSERT INTO "db_patches" VALUES (6, DATE '2003-12-12', '* makes login unique on webdb_users\n * drops unnecessary index on webdb_users\n * inserts a line for ogg support in media_types\n * drop "- deprecated -" from media_types\n * drop redundant index on id of topic\n * drop redundant index on id of comment\n * recreate indexes on content_x_media');
+INSERT INTO "db_patches" VALUES (7, DATE '2005-01-09', '* adds filter and filtergroups to the database');
+INSERT INTO "db_patches" VALUES (8, DATE '2005-09-13', '* adds "db_patches" and "model_version" tables to the database');
 

diff --git a/dbscripts/populate_modelversion.sql b/dbscripts/populate_modelversion.sql
index d44a945..1669915 100755 (executable)
--- a/dbscripts/populate_modelversion.sql
+++ b/dbscripts/populate_modelversion.sql
@@ -1,3 +1,3 @@
 
-INSERT INTO "model_version" VALUES ("1.1-1");
+INSERT INTO "model_version" VALUES ('1.1-1');
 

diff --git a/dbscripts/updates/update20050913.sql b/dbscripts/updates/update20050913.sql
index 0e6b95d..641202b 100755 (executable)
--- a/dbscripts/updates/update20050913.sql
+++ b/dbscripts/updates/update20050913.sql
@@ -20,15 +20,15 @@ CREATE TABLE "db_patches" (
   "description" text
 );
 
-INSERT INTO "db_patches" VALUES (1, DATE '2002-12-13', "* introduces sequences and primary keys for comment_status, article_type and
-      language\n * adds is_html to comment");
-INSERT INTO "db_patches" VALUES (2, DATE '2003-04-09', "* creates table comment_x_media, to support media in comments\n * adds webdb_lastchange to comment");
-INSERT INTO "db_patches" VALUES (3, DATE '2003-11-22', "* added a bunch of fields to webdb_user: is_disabled, email, profile, creation date, last login date");
-INSERT INTO "db_patches" VALUES (4, DATE '2003-11-24', "* Clean up comments\n * added a comment field for internal comments");
-INSERT INTO "db_patches" VALUES (5, DATE '2003-11-25', "* Removal of media (uploaded_media and content are now independently)\n * Clean up of content\n * Added a field for content-locking\n * Added a keywords field for content");
-INSERT INTO "db_patches" VALUES (6, DATE '2003-12-12', "* makes login unique on webdb_users\n * drops unnecessary index on webdb_users\n * inserts a line for ogg support in media_types\n * drop "- deprecated -" from media_types\n * drop redundant index on id of topic\n * drop redundant index on id of comment\n * recreate indexes on content_x_media");
-INSERT INTO "db_patches" VALUES (7, DATE '2005-01-09', "* adds filter and filtergroups to the database");
-INSERT INTO "db_patches" VALUES (8, DATE '2005-09-13', "* adds 'db_patches' and 'model_version' tables to the database for database changes tracking");
+INSERT INTO "db_patches" VALUES (1, DATE '2002-12-13', '* introduces sequences and primary keys for comment_status, article_type and
+      language\n * adds is_html to comment');
+INSERT INTO "db_patches" VALUES (2, DATE '2003-04-09', '* creates table comment_x_media, to support media in comments\n * adds webdb_lastchange to comment');
+INSERT INTO "db_patches" VALUES (3, DATE '2003-11-22', '* added a bunch of fields to webdb_user: is_disabled, email, profile, creation date, last login date');
+INSERT INTO "db_patches" VALUES (4, DATE '2003-11-24', '* Clean up comments\n * added a comment field for internal comments');
+INSERT INTO "db_patches" VALUES (5, DATE '2003-11-25', '* Removal of media (uploaded_media and content are now independently)\n * Clean up of content\n * Added a field for content-locking\n * Added a keywords field for content');
+INSERT INTO "db_patches" VALUES (6, DATE '2003-12-12', '* makes login unique on webdb_users\n * drops unnecessary index on webdb_users\n * inserts a line for ogg support in media_types\n * drop "- deprecated -" from media_types\n * drop redundant index on id of topic\n * drop redundant index on id of comment\n * recreate indexes on content_x_media');
+INSERT INTO "db_patches" VALUES (7, DATE '2005-01-09', '* adds filter and filtergroups to the database');
+INSERT INTO "db_patches" VALUES (8, DATE '2005-09-13', '* adds "db_patches" and "model_version" tables to the database for database changes tracking');
 
 --
 -- model_version
@@ -38,7 +38,7 @@ CREATE TABLE "model_version" (
   "description"  character varying(24)
 );
 
-INSERT INTO "model_version" VALUES ("1.1-1");
+INSERT INTO "model_version" VALUES ('1.1-1');
 
 COMMIT TRANSACTION;