This is east (Problem with define date and datetime)

[Chrysanthus]

Hi im trying to define thes tabels but im seem not to be able to do that becouse i get i error on date and datetime...

shoure i can fix it in phpmyadmin but i wanna know what i have don wrong

CREATE TABLE reg_info

(regid int(11) NOT NULL auto_increment,

username varchar(32) default NULL UNIQUE,
password varchar(32) default NULL,
firstname varchar(32) default NULL,
lastname varchar(32) default NULL,
birthdate date(10) default NULL,
gender ENUM('M','F') default NULL,
email varchar(32) default NULL UNIQUE,
country varchar(32) default NULL,
city varchar(32) default NULL,
gotmember ENUM('yes','no') default 'no',
regdate DATETIME(14) default NULL,
loggedin ENUM('yes','no') default 'no',
aktiveusertime TIMESTAMP(14) default NULL,

PRIMARY KEY (regid));

CREATE TABLE ipcounter (
ID int(50) DEFAULT '0' NOT NULL auto_increment,
remoteip varchar(50) DEFAULT '0' NOT NULL,
remoteiptimestamp datetime(16) NOT NULL,

PRIMARY KEY (ID));

[bastien]

don't set the length on the date/time and timestamp fields

[Chrysanthus]

isent this the lenght

birthdate date(10)

this (10)

[Chrysanthus]

how do i defien them then?

[bastien]

i use phpmyadmin to issue the create statement...have a look at the sql it generates

[Chrysanthus]

it should look like this

CREATE TABLE reg_info (

regid INT( 11 ) NOT NULL AUTO_INCREMENT ,
username VARCHAR( 32 ) NOT NULL ,
password VARCHAR( 32 ) NOT NULL ,
firstname VARCHAR( 32 ) ,
lastname VARCHAR( 32 ) ,
birthdate DATE DEFAULT '0000-00-00',
gender ENUM( 'M', 'F' ) ,
email VARCHAR( 32 ) ,
country VARCHAR( 32 ) ,
city VARCHAR( 32 ) ,
gotmember ENUM( 'yes', 'no' ) DEFAULT 'no' NOT NULL ,
regdate DATETIME DEFAULT '0000-00-00 00:00:00',
loggedin ENUM( 'yes', 'no' ) DEFAULT 'no' NOT NULL ,
aktiveusertime TIMESTAMP(14) default NULL,
PRIMARY KEY (regid) ,
UNIQUE (username ,email));

CREATE TABLE ipcounter (

ID INT( 50 ) DEFAULT '0' NOT NULL AUTO_INCREMENT ,
remoteip VARCHAR( 50 ) DEFAULT '0' NOT NULL ,
remoteiptimestamp` DATETIME DEFAULT '0000-00-00 00:00:00' NOT NULL ,
PRIMARY KEY (ID));