db_version/SQL/sqlite.initial.sql


1
2
3
4
5
6
7
8
9
10
11
12

PRAGMA foreign_keys = ON;

CREATE TABLE IF NOT EXISTS myrc (
	id serial NOT NULL,
	user_id integer NOT NULL,
	PRIMARY KEY (id),
	FOREIGN KEY (user_id) REFERENCES users (user_id) ON DELETE CASCADE ON UPDATE CASCADE
);

CREATE INDEX myrc_idx ON myrc (user_id);

DROP TABLE myrc;