blob: 15e94d0450b7b79f45abf7f6d99439346f7bcdfc (
plain)
1
2
3
4
5
6
7
|
CREATE SEQUENCE seq_test START 1;
CREATE TABLE tbl_test (
key integer PRIMARY KEY, -- primary key
personid integer NOT NULL REFERENCES tbl_person(key), -- person foreign key
gametypeid integer NOT NULL REFERENCES const_gametype(key) -- gametype foreign key
);
|