

--user table
create table blog_user(
	id						int					not null,
	username				varchar(256) 		not null,
	password				text,
	primary key(id)
);


--post table
create table post(
	id							int		not null,
	user_id					int		not null,
	post_date				date		not null,
	post_text				text		not null,
	extra						json		not null,
	primary key(id),
	foreign key(user_id) references blog_user (id)
);

