sql/update_db_0_13_to_0_16.sql
changeset 62 39b2dab4f939
parent 60 a8ad7ebf5902
--- a/sql/update_db_0_13_to_0_16.sql	Wed Sep 15 15:20:26 2010 +0200
+++ b/sql/update_db_0_13_to_0_16.sql	Tue Sep 21 04:27:08 2010 +0200
@@ -3,6 +3,7 @@
 
 ALTER TABLE ldt_utils_content DROP COLUMN videopath;
 ALTER TABLE ldt_utils_content DROP COLUMN external_id;
+ALTER TABLE ldt_utils_content DROP COLUMN src;
 
-ALTER TABLE ldt_utils_content ADD COLUMN "media_id" integer REFERENCES "ldt_utils_media" ("id") DEFERRABLE INITIALLY DEFERRED;
-CREATE INDEX "ldt_utils_content_media_id" ON "ldt_utils_content" ("media_id");
+ALTER TABLE ldt_utils_content ADD COLUMN "media_obj_id" integer REFERENCES "ldt_utils_media" ("id") DEFERRABLE INITIALLY DEFERRED;
+CREATE INDEX "ldt_utils_content_media_obj_id" ON "ldt_utils_content" ("media_obj_id");