SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";




CREATE TABLE IF NOT EXISTS `bots` (
  `name` varchar(50) NOT NULL,
  `room` int(11) NOT NULL,
  `startx` int(11) NOT NULL,
  `starty` int(11) NOT NULL,
  `shouts` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


INSERT INTO `bots` (`name`, `room`, `startx`, `starty`, `shouts`) VALUES
('Maarit', 1, 10, 2, 'Welcome to pMobiles, the best in disco emulation!\r\n5/19/13 - Expect us\r\nSam is the best, period.\r\nI give beer to minors, just ask me!');



CREATE TABLE IF NOT EXISTS `rooms` (
  `id` int(10) NOT NULL,
  `name` varchar(100) NOT NULL,
  `layout` varchar(32) NOT NULL,
  `maxusers` int(4) NOT NULL,
  `decorid` int(2) NOT NULL,
  `doorx` int(4) NOT NULL,
  `doory` int(4) NOT NULL,
  `doorz` int(4) NOT NULL,
  `heightmap` text NOT NULL,
  `objects` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


INSERT INTO `rooms` (`id`, `name`, `layout`, `maxusers`, `decorid`, `doorx`, `doory`, `doorz`, `heightmap`, `objects`) VALUES
(1, 'Main room', 'main', 40, 0, 2, 0, 0, 'xx0xxxxxxxxxxxxx\r\nxx0xxxxxxxxxxxxx\r\n000000000000000x\r\n000000000000000x\r\n000000000000000x\r\n000000000000000x\r\n000000000000000x\r\n000000000000000x\r\n000000000000000x\r\n000000000000000x\r\n000000000000000x\r\n000000000000000x\r\n000000000000000x\r\n000000000000000x\r\n000000000000000x\r\n000000000000000x\r\n000000000000000x\r\n000000000000000x\r\n000000000000000x\r\n0000000000000000\r\n000000000000000x\r\n000000000000000x\r\n000000000000000x\r\n000000000000000x\r\n000000000000000x\r\n000000000000000x', '1 bardesk 15 3 0 6\r\n2 bardesk 14 3 0 6\r\n3 bardesk 13 3 0 6\r\n4 bardesk 12 3 0 6\r\n5 bardesk 11 3 0 6\r\n6 bardesk 10 3 0 6\r\n7 bardesk 9 3 0 6\r\n8 bardesk 8 3 0 6\r\n9 bardesk 7 3 0 0\r\n10 bardesk 7 2 0 0\r\n11 bardesk 7 1 0 0\r\n12 bardesk 15 2 0 0\r\n13 bardesk 15 1 0 0\r\n14 fridgeB 8 1 0 4\r\n15 fridgeA 9 1 0 4\r\n16 chair 0 11 0 2\r\n17 chair 1 13 0 0\r\n18 chair 3 11 0 6\r\n19 chair 1 10 0 4\r\n20 table 1 11 0 2 2\r\n21 chair 0 17 0 2\r\n22 chair 1 19 0 0\r\n23 chair 3 17 0 6\r\n24 chair 1 16 0 4\r\n25 table 1 17 0 2 2\r\n26 chair 0 22 0 2\r\n27 chair 1 24 0 0\r\n28 chair 3 22 0 6\r\n29 chair 1 21 0 4\r\n30 table 1 22 0 2 2\r\n31 chair 9 12 0 2\r\n33 chair 12 12 0 6\r\n34 chair 10 10 0 4\r\n35 table 10 11 0 2 2\r\n36 chair 11 22 0 2\r\n37 chair 12 24 0 0\r\n38 chair 14 22 0 6\r\n39 chair 12 21 0 4\r\n40 table 12 22 0 2 2'),
(2, 'Disco room', 'disco', 30, 1, 6, 6, 0, 'x777777775432100\r\nx777777775432100\r\nx770000000000000\r\nx770000000000000\r\nx770000000000000\r\nx770000000000000\r\nx770000000000000\r\nx770000000000000\r\nx7700000000x1111\r\nx7700000000xx222\r\nx7700000000x2222\r\nx7700000000x2222\r\nx5500000000x2222\r\nx4400000000x22x2\r\nx3300000000x22x2\r\nx2200000000x2222\r\nx1100000000x2222\r\nx0000000000x2222\r\nx0000000000xx222', '');



CREATE TABLE IF NOT EXISTS `users` (
  `name` varchar(15) NOT NULL,
  `password` varchar(32) NOT NULL,
  `email` varchar(50) NOT NULL,
  `age` int(3) NOT NULL,
  `pants` int(2) NOT NULL,
  `shirt` int(2) NOT NULL,
  `head` int(2) NOT NULL,
  `sex` char(1) NOT NULL,
  `mission` varchar(50) NOT NULL,
  `created` varchar(60) NOT NULL,
  `rank` int(1) NOT NULL DEFAULT '1',
  `lastvisit` varchar(50) NOT NULL,
  PRIMARY KEY (`name`),
  UNIQUE KEY `username` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


INSERT INTO `users` (`name`, `password`, `email`, `age`, `pants`, `shirt`, `head`, `sex`, `mission`, `created`, `rank`, `lastvisit`) VALUES
('Sam', 'ness', 'you@domain.com', 15, 6, 6, 18, 'F', 'pMobiles ftw!', '4/9/2010 19:56:57', 4, '6/9/2010 19:12:05'),
('Maarit', 'bot', 'maarit@mobiles.com', 99, 9, 9, 9, 'F', 'Ask me for beer, coffee or whisky!', '4/9/2010 20:01:37', 1, '6/9/2010 19:12:05'),
('test', 'test', 'test@domain.com', 15, 1, 1, 1, 'M', 'ness', '4/9/2010 19:56:58', 1, '6/9/2010 19:12:05'),
('ThuGie', 'hax', 'wut@wut.nl', 15, 3, 8, 2, 'M', 'pMobiles ftw!', '7/9/2010 20:55:23', 1, '');