[pics.git] / sql / 002_posts.sql

CREATE TABLE posts (
  ID TEXT PRIMARY KEY,
  USERNAME TEXT NOT NULL,
  TIMESTAMP INT NOT NULL,
  FOREIGN KEY(username) references users(username)
);
CREATE TABLE pics (
  ID TEXT PRIMARY KEY,
  POST_ID TEXT NOT NULL,
  MIME_TYPE TEXT NOT NULL,
  PIC_B64 TEXT NOT NULL,
  FOREIGN KEY(POST_ID) references posts(id)
);
CREATE TABLE comments (
  ID TEXT PRIMARY KEY,
  POST_ID TEXT NOT NULL,
  BODY TEXT NOT NULL,
  FOREIGN KEY(POST_ID) references posts(id)
);
Commit	Line	Data
cd757b9e JC	1	CREATE TABLE posts (
	2	ID TEXT PRIMARY KEY,
	3	USERNAME TEXT NOT NULL,
	4	TIMESTAMP INT NOT NULL,
	5	FOREIGN KEY(username) references users(username)
	6	);
	7	CREATE TABLE pics (
	8	ID TEXT PRIMARY KEY,
	9	POST_ID TEXT NOT NULL,
	10	MIME_TYPE TEXT NOT NULL,
	11	PIC_B64 TEXT NOT NULL,
	12	FOREIGN KEY(POST_ID) references posts(id)
	13	);
	14	CREATE TABLE comments (
	15	ID TEXT PRIMARY KEY,
	16	POST_ID TEXT NOT NULL,
	17	BODY TEXT NOT NULL,
	18	FOREIGN KEY(POST_ID) references posts(id)
	19	);