----- Original Message -----
> From: "Hervey Liu" <[email protected]>
>
> 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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[email protected]
