How to import tables in SQLite?

[danipopeye]

Well, I just want to know how I can import the following table with sqlitestudio-2.1.4 on my database because I want to use the server on sqlite mode NOT MYSQL. Someone who has done it and know?

ALTER TABLE `players` ADD `exphist_lastexp` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `exphist1` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `exphist2` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `exphist3` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `exphist4` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `exphist5` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `exphist6` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `exphist7` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `onlinetimetoday` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `onlinetime1` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `onlinetime2` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `onlinetime3` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `onlinetime4` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `onlinetime5` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `onlinetime6` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `onlinetime7` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `onlinetimeall` BIGINT( 255 ) NOT NULL DEFAULT '0';

Kind regards,
danipopeye

 

[brank50]

Open up sqlite and click open database and then you want to open the forgottenserver file

 

[danipopeye]

Open up sqlite and click open database and then you want to open the forgottenserver file

I know how to open the database, I want to know how to import a tables... <_< Anyone know? Fast plx!

 

[Ninja]

[SQLite] Accessing and modifying the database

SQLite Expert seems to be easier to use than SQLiteStudio.

 

[danipopeye]

[SQLite] Accessing and modifying the database

SQLite Expert seems to be easier to use than SQLiteStudio.

Thank you, maybe I test it but someone can explain how? :'(