H2

LogicList.pdf

Create table users(username varchar(50) primary key,password varchar(255));

create table board(id int primary key auto_increment, title varchar(50), content varchar(5000),clickcnt int,image varchar(100),username varchar(30),date timestamp default now());

postgresql

create table board(id serial primary key, title varchar(50), content varchar(5000),clickcnt int,image varchar(100),username varchar(30),date timestamp default now());

alter table board alter column content set not null;

alter table board alter column title set not null;

AWS Linux Postgresql Schema

Create table users(username varchar(50) primary key,password varchar(255));

ALTER TABLE board ADD COLUMN created_at timestamp default now();

create table board(id serial primary key, title varchar(50), content varchar(5000),clickcnt int,image varchar(100),username varchar(30),date timestamp default now());

alter table board alter column content set not null;