sql/update_db_0_13_to_0_16.sql
changeset 60 a8ad7ebf5902
child 62 39b2dab4f939
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/sql/update_db_0_13_to_0_16.sql	Wed Sep 15 15:07:08 2010 +0200
@@ -0,0 +1,8 @@
+ALTER TABLE ldt_utils_content
+   ADD COLUMN tags character varying(2048);
+
+ALTER TABLE ldt_utils_content DROP COLUMN videopath;
+ALTER TABLE ldt_utils_content DROP COLUMN external_id;
+
+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");