View difference between Paste ID: hJCSBArj and
SHOW:
|
|
- or go back to the newest paste.
1 | create table people ( | |
2 | id int unsigned not null auto_increment unique, | |
3 | nick varchar(9) not null, | |
4 | first_seen datetime not null, | |
5 | primary key(nick) | |
6 | ) default charset=utf8 ENGINE=InnoDB; | |
7 | ||
8 | create table url ( | |
9 | id int unsigned not null auto_increment unique, | |
10 | url varchar(100) not null, | |
11 | nickid int unsigned not null, | |
12 | date datetime not null, | |
13 | constraint foreign key(nickid) references people(id), | |
14 | primary key(id) | |
15 | ) default charset=utf8 ENGINE=InnoDB; | |
16 | ||
17 | ||
18 |