summaryrefslogtreecommitdiff
path: root/db/migrations/0036_aberrant_marvel_apes.sql
diff options
context:
space:
mode:
Diffstat (limited to 'db/migrations/0036_aberrant_marvel_apes.sql')
-rw-r--r--db/migrations/0036_aberrant_marvel_apes.sql9
1 files changed, 9 insertions, 0 deletions
diff --git a/db/migrations/0036_aberrant_marvel_apes.sql b/db/migrations/0036_aberrant_marvel_apes.sql
new file mode 100644
index 00000000..54c6c86d
--- /dev/null
+++ b/db/migrations/0036_aberrant_marvel_apes.sql
@@ -0,0 +1,9 @@
+CREATE TABLE "tag_classes" (
+ "id" integer PRIMARY KEY GENERATED ALWAYS AS IDENTITY (sequence name "tag_classes_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+ "code" varchar(100) NOT NULL,
+ "label" text NOT NULL,
+ "created_at" timestamp DEFAULT now() NOT NULL,
+ "updated_at" timestamp DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+ALTER TABLE "tag_subfield_options" ALTER COLUMN "attributes_id" SET DATA TYPE varchar(50); \ No newline at end of file