Database Schemas

CREATE TABLE mapcraft (name char(64), width int, height int, scale int, shape char(16), template 
char(64), author char(64), description char(128), created timestamp);
 
CREATE TABLE X_area (id int, name varchar(128), type varchar(128));
 
CREATE TABLE X_terrain(id int, name varchar(32), description varchar(128),
                       image varchar(128), colour int);
 
CREATE TABLE X_things(id int, name varchar(128), description text, 
                      x int, y int, terrain_id int);
 
CREATE TABLE X_tiles(x int, y int, terrain_id int, feature_id int, altitude int);
 
CREATE TABLE X_tile_area(x int, y int, area_id int);