mirror of https://github.com/openresty/openresty
You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
25 lines
592 B
25 lines
592 B
-- Blog posts |
|
drop table if exists posts; |
|
create table posts ( |
|
id serial, |
|
title text not null, |
|
content text not null, |
|
author varchar(64) not null, |
|
created timestamp(0) default now() not null, |
|
comments integer default 0 not null, |
|
primary key (id) |
|
); |
|
|
|
-- Blog comments |
|
drop table if exists comments; |
|
create table comments ( |
|
id serial, |
|
sender varchar(64) not null, |
|
email varchar(64), |
|
url varchar(1024), |
|
body text not null, |
|
created timestamp(0) default now() not null, |
|
post bigint not null, |
|
foreign key (post) references posts(id) |
|
); |
|
|
|
|