--
--
--
-- A very simple database to maintain usernames and passwords
--
--
--
-- Here's the ERD:
--
--
--   +-------------+
--   |  Person     |
--   |-------------|
--   |  id         |
--   |  name       |
--   |  password   |
--   +-------------+
--
--
--
--
--
--
--
--
--
--

------------------------------------------------------------------

-- The following prevents consistency checks between tables.

CREATE TABLE Person (
  id int(11) NOT NULL auto_increment
  , name VARCHAR(255) DEFAULT ''
  , password VARCHAR(255) DEFAULT ''
  , cookie VARCHAR(255) DEFAULT ''
  , PRIMARY KEY (id)
) TYPE=InnoDB;

INSERT INTO Person VALUES (1, 'Gabriel', 'chewtoy', NULL);
INSERT INTO Person VALUES (2, 'Kirsten', 'fishpaste', NULL);

--- And now that the tables are set up, turn checking back on.

