Commit | Line | Data |
fb3e4caf |
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', |
70aafeed |
7 | description text default `name`, |
4d438549 |
8 | UNIQUE KEY UC_age_name (age) |
fb3e4caf |
9 | ) ENGINE=MyISAM; |
10 | |
11 | create unique index u_name on person (name); |
9ae898b9 |
12 | |
13 | create table employee ( |
2282f0e2 |
14 | position varchar(50), |
15 | employee_id integer, |
4d438549 |
16 | job_title varchar(255), |
2282f0e2 |
17 | CONSTRAINT FK5302D47D93FE702E FOREIGN KEY (employee_id) REFERENCES person (person_id), |
18 | CONSTRAINT `demo_constraint` CHECK (`employee_id` > 0 and `employee_id` IS NOT NULL), |
19 | PRIMARY KEY (position, employee_id) USING BTREE |
9ae898b9 |
20 | ) ENGINE=InnoDB; |
21 | |
4d438549 |
22 | create table deleted ( |
23 | id integer |
24 | ); |