




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', '');
