summaryrefslogtreecommitdiff
path: root/db/migrations/0174_peaceful_warpath.sql
diff options
context:
space:
mode:
Diffstat (limited to 'db/migrations/0174_peaceful_warpath.sql')
-rw-r--r--db/migrations/0174_peaceful_warpath.sql16
1 files changed, 16 insertions, 0 deletions
diff --git a/db/migrations/0174_peaceful_warpath.sql b/db/migrations/0174_peaceful_warpath.sql
new file mode 100644
index 00000000..2181c9ac
--- /dev/null
+++ b/db/migrations/0174_peaceful_warpath.sql
@@ -0,0 +1,16 @@
+CREATE TABLE "page_information" (
+ "id" serial PRIMARY KEY NOT NULL,
+ "page_code" varchar(100) NOT NULL,
+ "page_name" varchar(255) NOT NULL,
+ "title" varchar(500) NOT NULL,
+ "description" text NOT NULL,
+ "notice_title" varchar(500),
+ "notice_content" text,
+ "attachment_file_name" varchar(255),
+ "attachment_file_path" varchar(1024),
+ "attachment_file_size" varchar(50),
+ "is_active" boolean DEFAULT true NOT NULL,
+ "created_at" timestamp DEFAULT now() NOT NULL,
+ "updated_at" timestamp DEFAULT now() NOT NULL,
+ CONSTRAINT "page_information_page_code_unique" UNIQUE("page_code")
+);