|
|
| Line 1: |
Line 1: |
| == Server Database Specification: ==
| | [[Database Specifications]] |
| '''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)
| |
| )
| |
|
| |
|
| --[[User:Nym|Nym]] 01:21, 23 May 2005 (PDT) | | --[[User:Nym|Nym]] 01:21, 23 May 2005 (PDT) |
Revision as of 08:22, 23 May 2005
