sql/update_db_0_13_to_0_16.1.sql
author ymh <ymh.work@gmail.com>
Mon, 18 Apr 2011 16:28:20 +0200
changeset 142 77fdf5d1786c
parent 63 7b721b427b73
permissions -rw-r--r--
Added tag V00.32 for changeset ebca39584596
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
60
a8ad7ebf5902 various update and splitmedia from content
ymh <ymh.work@gmail.com>
parents:
diff changeset
     1
ALTER TABLE ldt_utils_content
a8ad7ebf5902 various update and splitmedia from content
ymh <ymh.work@gmail.com>
parents:
diff changeset
     2
   ADD COLUMN tags character varying(2048);
a8ad7ebf5902 various update and splitmedia from content
ymh <ymh.work@gmail.com>
parents:
diff changeset
     3
62
39b2dab4f939 separate contet and media
ymh <ymh.work@gmail.com>
parents: 60
diff changeset
     4
ALTER TABLE ldt_utils_content ADD COLUMN "media_obj_id" integer REFERENCES "ldt_utils_media" ("id") DEFERRABLE INITIALLY DEFERRED;
39b2dab4f939 separate contet and media
ymh <ymh.work@gmail.com>
parents: 60
diff changeset
     5
CREATE INDEX "ldt_utils_content_media_obj_id" ON "ldt_utils_content" ("media_obj_id");