Pastebin launched a little side project called VERYVIRAL.com, check it out ;-) Want more features on Pastebin? Sign Up, it's FREE!
Guest

mysql troubles

By: a guest on Oct 11th, 2011  |  syntax: MySQL  |  size: 0.44 KB  |  views: 32  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
This paste has a previous version, view the difference. Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  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;
  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;
  16.  
  17.  
  18.  
clone this paste RAW Paste Data