db_version/SQL/pgsql.initial.sql


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

CREATE TABLE IF NOT EXISTS myrc (
	id serial NOT NULL,
	user_id integer NOT NULL,
	PRIMARY KEY (id)
);

ALTER TABLE myrc
	ADD CONSTRAINT myrc_ibfk_1 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;