List:General Discussion« Previous MessageNext Message »
From:Hervey Liu Date:February 28 2011 7:23am
Subject:quick question
View as plain text  
hello

i am a noob in general
i just want to double check
can someone perhaps send me a screen shot of how the following data will
look in a mysql table


;
CREATE TABLE logins (
   success
enum('Y','N[banned]','N[password]','N[panic]','N[activation]','N[authorization]')
DEFAULT 'Y' NOT NULL,
   when datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
   browser varchar(255) NOT NULL,
   ipaddress varchar(20) NOT NULL,
   activity enum('user','quote','liquidate','manage','finale') DEFAULT
'quote' NOT NULL,
   userid int(10) unsigned NOT NULL,
   symbolid int(10) unsigned,
   PRIMARY KEY (when, userid)


thank you
hervey

Thread
quick questionHervey Liu28 Feb
  • Re: quick questionJohan De Meersman1 Mar