diff options
Diffstat (limited to 'db/migrations/0174_peaceful_warpath.sql')
| -rw-r--r-- | db/migrations/0174_peaceful_warpath.sql | 16 |
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") +); |
