SHARE
TWEET

mysql troubles

a guest Oct 11th, 2011 68 Never
  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.  
RAW Paste Data
Top