List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:March 1 2011 7:29am
Subject:Re: quick question
View as plain text  

----- Original Message -----
> From: "Hervey Liu" <herveyli@stripped>
> 
> 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,
     ^^^^
This is going to be an issue when querying. Avoid using reserved words as column names
whenever possible.

>    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)


For the rest, that isn't data, so it won't "look" like anything quite so much as an empty
table. Just execute the statement and have a look :-)


-- 
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel
Thread
quick questionHervey Liu28 Feb
  • Re: quick questionJohan De Meersman1 Mar