dh_demo

commit f273a8900dd195d0a550468bb8efc3f4279c0420
parent bba0b0864bfe4d2132bf4df5e6cfd568f00aa0fc
Author: Yongbin Kim <iam@yongbin.kim>
Date:   Fri, 20 Jan 2023 12:11:45 +0900

feat: wiki 및 관련 테이블 추가

Signed-off-by: Yongbin Kim <iam@yongbin.kim>

Diffstat:
M
sql/0001_base.sql
 | 
15
+++++++++++++--

1 file changed, 13 insertions(+), 2 deletions(-)
diff --git a/sql/0001_base.sql b/sql/0001_base.sql
@@ -31,7 +31,7 @@ create table wikis
     id          int          not null auto_increment primary key,
     owner_id    int          not null references logins (id)
         on delete restrict on update cascade,
-    slug        varchar(48)  not null unique check (slug <> ''),
+    slug        varchar(48)  not null unique check ( slug <> '' ),
     title       varchar(255) not null,
     description text         null,
     created_at  datetime     not null default current_timestamp,
@@ -42,9 +42,10 @@ create table wiki_pages
 (
     wiki_id    int          not null references wikis (id)
         on delete cascade on update cascade,
-    slug       varchar(255) not null check (slug <> ''),
+    slug       varchar(255) not null check ( slug <> '' ),
     title      varchar(255) not null check ( title <> '' ),
     html       text         not null,
+    content    text         not null check ( content <> '' ),
     created_at datetime     not null default current_timestamp,
     updated_at datetime     null on update current_timestamp,
 
@@ -53,5 +54,15 @@ create table wiki_pages
 
 create table wiki_changes
 (
+    id int not null auto_increment primary key,
+    wiki_id int not null references wikis (id)
+        on delete cascade on update cascade,
+    page_slug varchar(255) not null,
+    author_id int not null references logins (id)
+        on delete set null on update cascade,
+    diff text not null,
+    created_at datetime not null default current_timestamp,
 
+    foreign key (wiki_id, page_slug) references wiki_pages (wiki_id, slug)
+        on delete cascade on update cascade
 );