KdMs9ezQ

1//Setting up the database if it dosent exist
2
3var DB = new SQLite("d2botstats.sqlite", true);
4query = "CREATE TABLE IF NOT EXISTS temp (" +
5"PROFILE TEXT NOT NULL," +
6"STATUS TEXT NOT NULL," +
7"RUNS INT NOT NULL," +
8"CHICKENS INT NOT NULL," +
9"DEATHS INT NOT NULL," +
10"CRASHES INT NOT NULL," +
11"RESTARTS INT NOT NULL)";
12DB.ready = DB.execute(query);
13
14//Insert example
15
16DB.sqls = "insert into temp (PROFILE, STATUS, RUNS, CHICKENS, DEATHS, CRASHES, RESTARTS) values ('EUMF 1', 'Running', 1, 0, 0, 0, 0)";
17DB.ready = DB.execute(DB.sqls);