Create README.md

//===========================
//== Database Queries

create database generic_mud;
use generic_mud;

CREATE TABLE worlds (
  id INT UNSIGNED NOT NULL AUTO_INCREMENT,
  name CHAR(12) NOT NULL,
  
  root_x INT,
  root_y INT,
  root_z INT,
  
  PRIMARY KEY (id)
);

CREATE TABLE rooms (
  id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  world_id INT UNSIGNED NOT NULL,
  x INT NOT NULL,
  y INT NOT NULL,
  z INT NOT NULL,
  description TEXT NOT NULL,
  phase_state CHAR(12) NOT NULL,
  PRIMARY KEY (id),
  FOREIGN KEY (world_id) REFERENCES worlds(id)
);

CREATE TABLE adventurers (
  id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  world_id INT UNSIGNED,
  x INT,
  y INT,
  z INT,
  
  name CHAR(12) NOT NULL UNIQUE,
  owner_type CHAR(12),
  session_id CHAR(26),  // maybe 40 to be safe in case using different hashing.
  
  last_ping_time TIMESTAMP,
  last_action_time TIMESTAMP,
  
  PRIMARY KEY (id),
  FOREIGN KEY (room_id) REFERENCES rooms (id)
);


CREATE TABLE message_queue (
    id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
    adventurer_id BIGINT UNSIGNED NOT NULL,
    text TEXT NOT NULL,
    type CHAR(12) NOT NULL,
    created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    
    PRIMARY KEY (id)
);