My favorites | Sign in
Project Home Downloads Wiki
READ-ONLY: This project has been archived. For more information see this post.
Search
for
  Advanced search   Search tips   Subscriptions

Issue 43 attachment: init-mysql.sql (351 bytes)

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
CREATE TABLE test1 (
id int NOT NULL PRIMARY KEY,
name varchar(100),
ref int
);

CREATE TABLE test2 (
id int NOT NULL PRIMARY KEY,
name varchar(100)
);

ALTER TABLE test1
ADD CONSTRAINT FK_test1_ref FOREIGN KEY (ref)
REFERENCES test2 (id);

Powered by Google Project Hosting