Server Database Specification:

SQL[ite] Table Specifications:

• Account Information Table

create table tmw_accounts (

   -- Username
   user varchar(32) unique primary key not null,

   -- Password hash
   password varchar(32) not null,

   -- Email address
   email varchar(128) not null

)

• Character/Player Information Table

create table tmw_characters (

   -- Character name
   name varchar(32) unique primary key not null,
   -- Username
   user varchar(32) not null,
   -- Player information
   gender int not null,
   level int not null,
   money int not null,

   -- Coordinates & map
   x int not null,
   y int not null,
   map text not null,

   -- Statistics
   strength int not null,
   agility int not null,
   vitality int not null,
   intelligence int not null,
   dexterity int not null,
   luck int not null,

   -- Player equipment
   inventory blob not null,
   equipment blob not null,

   -- Table relationship
   foreign key(user) references tmw_accounts(user)

)