projects
/
dbsrgits/SQL-Translator.git
/ blob
commit
grep
author
committer
pickaxe
?
search:
re
9802baaa3e15b7b8410adf118c152870e9c720cc
[dbsrgits/SQL-Translator.git]
/
t
/
data
/
mysql
/
create.sql
1
create table person (
2
person_id INTEGER PRIMARY KEY,
3
name varchar(20),
4
age integer,
5
weight double(11,2),
6
iq tinyint default '0',
7
description text
8
) ENGINE=MyISAM;
9
10
create unique index u_name on person (name);
11
12
create table employee (
13
position varchar(50),
14
employee_id integer,
15
CONSTRAINT FK5302D47D93FE702E FOREIGN KEY (employee_id) REFERENCES person (person_id)
16
) ENGINE=InnoDB;
17