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