why is my Install.sql code is not working?

[KaL]

this is my install.sql

Code: Select all

drop table if exists timers;
create table timers(
id integer(100) unsigned not null primary key auto_increment,
name varchar(100) null,
PutTime varchar(100) null,
InTime varchar(100)  null,
NotInTime varchar(100) null,
ReleaseTime varchar(100) null,
ReduceTime varchar(100) null,)
ENGINE InnoDB, CHARACTER SET utf8, COLLATE utf8_bin;

then i got this error when installing it:

Code: Select all

Error whilst executing:
create table timers( id integer(100) unsigned not null primary key auto_increment, name varchar(100) null, PutTime varchar(100) null, InTime varchar(100) null, NotInTime varchar(100) null, ReleaseTime varchar(100) null, ReduceTime varchar(100) null,) ENGINE InnoDB, CHARACTER SET utf8, COLLATE utf8_bin

i don't get it.

[hallsofvallhalla]

not too sure but please for the love of God do not leave those at 100!

[a_bertrand]

Try to run the SQL directly and see how it goes.

[KaL]

Hahahaha! Ok I won't put 100. LOL!

And yes I did tried it directly. It's kinda weird.

[KyleMassacre]

At a quick glance you have a comma where it shouldn't be on you or reduceTime column after the "null"

[KaL]

Thanks Kyle! it works now.