Mysql To Sqlite!

[Druiden Keso]

Could anyone help me to get this code its currently in mysql format and i want it into sqlite!

ALTER TABLE `players` ADD `cast` TINYINT NOT NULL DEFAULT '0',
ADD `castViewers` INT( 11 ) NOT NULL DEFAULT '0',
ADD `castDescription` VARCHAR( 255 ) NOT NULL

 

[Limos]

Change INT(11)/TINYINT to INTEGER.
It's btw MySQL, not MySQLite

 

[Imfreezing]

ALTER TABLE `players` ADD `cast` INTEGER NOT NULL DEFAULT '0',
ADD `castViewers` INTEGER NOT NULL DEFAULT '0',
ADD `castDescription` VARCHAR( 255 ) NOT NULL

 

[Druiden Keso]

Change INT(11)/TINYINT to INTEGER.
It's btw MySQL, not MySQLite

ALTER TABLE `players` ADD `cast` INTEGER NOT NULL DEFAULT '0',
ADD `castViewers` INTEGER NOT NULL DEFAULT '0',
ADD `castDescription` VARCHAR( 255 ) NOT NULL

Error while executing query: near ",": syntax error

 

[Limos]

Add them 1 by 1 (so run 3x)

ALTER TABLE "players" ADD "cast" INTEGER NOT NULL DEFAULT 0
ALTER TABLE "players" ADD "castViewers" INTEGER NOT NULL DEFAULT 0
ALTER TABLE "players" ADD "castDescription" VARCHAR(255) NOT NULL DEFAULT ''

 

[Druiden Keso]

Still getting this msg
Error while executing query: near "ALTER": syntax error

 

[Limos]

Edited, forgot to add 1 thing to the third line.

 

[Druiden Keso]

Edited, forgot to add 1 thing to the third line.

Still getting that error
Error while executing query: near "ALTER": syntax error

 

[Limos]

Just tested it myself, works fine for me, no errors.

 

[Imfreezing]

 Error while executing query: near "ALTER": syntax error

Tested myself SQLITESTUDIO

 

[Druiden Keso]

^ +1

 

[Limos]

Do you add the lines 1 by 1? So not all 3 at the same time?
Btw I use SQLite Manager, SQLite Studio sux :x, don't think it will make a difference though.

 

[Imfreezing]

Do you add the lines 1 by 1? So not all 3 at the same time?
Btw I use SQLite Manager, SQLite Studio sux :x, don't think it will make a difference though.

Oh,1 by 1,Oki Thanks m8