From 662d78b9a5bebdb98dc178ebd1f8e3384793c104 Mon Sep 17 00:00:00 2001 From: Jari Vetoniemi Date: Sun, 17 Mar 2019 15:30:43 +0200 Subject: Initial commit --- sql/login.sql | 63 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 63 insertions(+) create mode 100644 sql/login.sql (limited to 'sql') diff --git a/sql/login.sql b/sql/login.sql new file mode 100644 index 0000000..0ada114 --- /dev/null +++ b/sql/login.sql @@ -0,0 +1,63 @@ +drop table if exists servers; +create table servers ( + id integer primary key autoincrement, + name char(15) not null, + host char(15) not null, + port smallint not null, + -- 0: MAINTENANCE + -- 1: GOOD + -- 2: NORMAL + -- 3: OVERLOADED + -- 4: QUEUE + status tinyint not null check (status <= 4) +); + +insert into servers values (null, "login", "84.248.5.167", 10000, 1); +insert into servers values (null, "BENIS", "84.248.5.167", 10100, 1); +insert into servers values (null, "maintenance", "84.248.5.167", 10100, 0); +insert into servers values (null, "normal", "84.248.5.167", 10100, 2); +insert into servers values (null, "overloaded", "84.248.5.167", 10100, 3); +insert into servers values (null, "queue", "84.248.5.167", 10100, 4); + +drop table if exists accounts; +create table accounts ( + id integer primary key autoincrement, + username varchar(16) not null, + password varchar(64) not null, + email varchar(64) not null, + last_login datetime default null, + created datetime not null default current_timestamp +); + +insert into accounts values (null, "benis", "benis", "", null, current_timestamp); + +drop table if exists sessions; +create table sessions ( + id integer primary key not null check (id < 0xffffffff), + account_id integer not null, + char_id integer, + server char(15) not null, + created datetime not null default current_timestamp +); + +drop table if exists characters; +create table characters ( + id integer primary key autoincrement check (id < 0xffffffff), + account_id integer not null, + last_login datetime, + created datetime not null default current_timestamp, + -- 1: Haru + -- 2: Ed + -- 3: Lily + -- 4: Jin + -- 5: Stella + -- 6: Iris + -- 7: Chi + model tinyint not null check (id > 0 and id <= 7), + name char(12) not null, + evolution tinyint not null default 0, + lvl tinyint not null default 1 check (lvl > 0) +); + +insert into characters values (null, 1, null, current_timestamp, 6, "Iris", 1, 255); +insert into characters values (null, 1, null, current_timestamp, 3, "Lily", 1, 255); -- cgit v1.2.3