-- -- Table structure for table `[buildings]` -- CREATE TABLE `[buildings]` ( `type` varchar(225) NOT NULL default '', `city` varchar(225) NOT NULL default '', `owner` varchar(225) NOT NULL default 'unowned', `start` datetime NOT NULL default '0000-00-00 00:00:00', `price` int(11) NOT NULL default '0', `production` datetime NOT NULL default '0000-00-00 00:00:00', `profit` int(50) NOT NULL default '0', `active` int(11) NOT NULL default '0', `amount` int(50) NOT NULL default '0', `code` int(2) NOT NULL default '0', `bank` int(11) NOT NULL default '250000', `aantalx` mediumint(11) NOT NULL default '0' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `[buildings]` -- INSERT INTO `[buildings]` VALUES ('trainstation', '1', '', '2005-12-16 16:15:03', 2500, '0000-00-00 00:00:00', 940000, 0, 0, 34, -335440, 0); INSERT INTO `[buildings]` VALUES ('trainstation', '2', '', '2005-12-16 16:17:17', 2500, '0000-00-00 00:00:00', 242500, 0, 0, 27, 250000, 0); INSERT INTO `[buildings]` VALUES ('trainstation', '3', '', '2005-12-16 16:17:56', 2500, '0000-00-00 00:00:00', 260000, 0, 0, 23, 250000, 0); INSERT INTO `[buildings]` VALUES ('trainstation', '4', '', '2006-01-06 12:24:27', 2500, '0000-00-00 00:00:00', 237500, 0, 0, 13, -335440, 0); INSERT INTO `[buildings]` VALUES ('trainstation', '5', '', '2006-01-03 00:58:52', 2500, '0000-00-00 00:00:00', 120000, 0, 0, 0, -335440, 0); INSERT INTO `[buildings]` VALUES ('trainstation', '6', '', '2006-01-10 21:08:04', 2500, '0000-00-00 00:00:00', 147500, 0, 0, 76, 250000, 0); INSERT INTO `[buildings]` VALUES ('trainstation', '7', '', '2005-12-16 19:03:31', 2500, '0000-00-00 00:00:00', 242500, 0, 0, 10, -27560, 0); INSERT INTO `[buildings]` VALUES ('trainstation', '8', '', '2006-01-03 01:01:42', 2500, '0000-00-00 00:00:00', 177500, 0, 0, 59, -335440, 0); INSERT INTO `[buildings]` VALUES ('trainstation', '9', '', '2006-01-06 17:03:11', 2500, '0000-00-00 00:00:00', 195000, 0, 0, 20, -335440, 0); INSERT INTO `[buildings]` VALUES ('trainstation', '10', '', '2005-12-16 16:15:03', 2500, '0000-00-00 00:00:00', 940000, 0, 0, 34, -335440, 0); INSERT INTO `[buildings]` VALUES ('trainstation', '11', '', '2005-12-16 16:15:03', 2500, '0000-00-00 00:00:00', 940000, 0, 0, 34, -335440, 0); INSERT INTO `[buildings]` VALUES ('trainstation', '12', '', '2005-12-16 16:17:17', 2500, '0000-00-00 00:00:00', 242500, 0, 0, 27, 250000, 0); INSERT INTO `[buildings]` VALUES ('trainstation', '13', '', '2005-12-16 16:17:56', 2500, '0000-00-00 00:00:00', 260000, 0, 0, 23, 250000, 0); INSERT INTO `[buildings]` VALUES ('trainstation', '14', '', '2006-01-06 12:24:27', 2500, '0000-00-00 00:00:00', 237500, 0, 0, 13, -335440, 0); INSERT INTO `[buildings]` VALUES ('trainstation', '15', '', '2006-01-03 00:58:52', 2500, '0000-00-00 00:00:00', 120000, 0, 0, 0, -335440, 0); INSERT INTO `[buildings]` VALUES ('racetrack', '1', '', '2006-01-06 13:34:56', 0, '0000-00-00 00:00:00', 299997, 0, 0, 0, 250000, 0); INSERT INTO `[buildings]` VALUES ('racetrack', '2', '', '2006-01-06 13:38:54', 200, '0000-00-00 00:00:00', 4331, 0, 0, 0, 250000, 0); INSERT INTO `[buildings]` VALUES ('racetrack', '3', '', '2006-01-06 13:56:53', 99999, '0000-00-00 00:00:00', 1001, 0, 0, 0, 250000, 0); INSERT INTO `[buildings]` VALUES ('racetrack', '4', '', '2006-01-06 16:08:39', 50000, '0000-00-00 00:00:00', 19840, 0, 0, 0, 240000, 0); INSERT INTO `[buildings]` VALUES ('racetrack', '5', '', '2005-09-01 13:29:00', 1000, '0000-00-00 00:00:00', 0, 0, 0, 0, 250000, 0); INSERT INTO `[buildings]` VALUES ('racetrack', '6', '', '2006-01-06 12:44:14', 2500, '0000-00-00 00:00:00', 0, 0, 0, 0, 250000, 0); INSERT INTO `[buildings]` VALUES ('racetrack', '7', '', '2006-01-06 15:58:15', 99999, '0000-00-00 00:00:00', 34000, 0, 0, 0, 247440, 0); INSERT INTO `[buildings]` VALUES ('racetrack', '8', '', '2006-01-08 11:54:27', 30000, '0000-00-00 00:00:00', 0, 0, 0, 0, 250000, 0); INSERT INTO `[buildings]` VALUES ('racetrack', '9', '', '2005-09-11 21:23:29', 99999, '0000-00-00 00:00:00', 2104079, 0, 0, 0, 239950, 0); INSERT INTO `[buildings]` VALUES ('racetrack', '10', '', '2006-01-06 13:34:56', 0, '0000-00-00 00:00:00', 299997, 0, 0, 0, 250000, 0); INSERT INTO `[buildings]` VALUES ('racetrack', '11', '', '2006-01-06 13:34:56', 0, '0000-00-00 00:00:00', 299997, 0, 0, 0, 250000, 0); INSERT INTO `[buildings]` VALUES ('racetrack', '12', '', '2006-01-06 13:38:54', 200, '0000-00-00 00:00:00', 4331, 0, 0, 0, 250000, 0); INSERT INTO `[buildings]` VALUES ('racetrack', '13', '', '2006-01-06 13:56:53', 99999, '0000-00-00 00:00:00', 1001, 0, 0, 0, 250000, 0); INSERT INTO `[buildings]` VALUES ('racetrack', '14', '', '2006-01-06 16:08:39', 50000, '0000-00-00 00:00:00', 19840, 0, 0, 0, 240000, 0); INSERT INTO `[buildings]` VALUES ('racetrack', '15', '', '2005-09-01 13:29:00', 1000, '0000-00-00 00:00:00', 0, 0, 0, 0, 250000, 0); INSERT INTO `[buildings]` VALUES ('slot', '1', '', '2005-12-15 19:48:37', 25000, '0000-00-00 00:00:00', 1596009, 0, 0, 0, 250000, 0); INSERT INTO `[buildings]` VALUES ('slot', '2', '', '2005-12-15 21:38:14', 99999, '0000-00-00 00:00:00', 1679667, 0, 0, 0, -27560, 0); INSERT INTO `[buildings]` VALUES ('slot', '3', '', '2005-12-28 19:01:08', 25000, '0000-00-00 00:00:00', 2559757, 0, 0, 0, 250000, 0); INSERT INTO `[buildings]` VALUES ('slot', '4', '', '2005-12-16 09:52:12', 25000, '0000-00-00 00:00:00', 130398, 0, 0, 0, 250000, 0); INSERT INTO `[buildings]` VALUES ('slot', '5', '', '2006-01-10 21:08:38', 99999, '0000-00-00 00:00:00', 20, 0, 0, 0, 250000, 0); INSERT INTO `[buildings]` VALUES ('slot', '6', '', '2006-01-12 20:22:36', 25000, '0000-00-00 00:00:00', 51017, 0, 0, 0, 8950, 0); INSERT INTO `[buildings]` VALUES ('slot', '7', '', '2005-09-01 14:55:13', 99999, '0000-00-00 00:00:00', 4818357, 0, 0, 0, -27560, 0); INSERT INTO `[buildings]` VALUES ('slot', '8', '', '2006-01-10 11:00:42', 2500, '0000-00-00 00:00:00', -70000, 0, 0, 0, -335440, 0); INSERT INTO `[buildings]` VALUES ('slot', '9', '', '2005-10-02 11:16:28', 20000, '0000-00-00 00:00:00', 5739687, 0, 0, 0, 250000, 0); INSERT INTO `[buildings]` VALUES ('slot', '10', '', '2005-12-15 19:48:37', 25000, '0000-00-00 00:00:00', 1596009, 0, 0, 0, 250000, 0); INSERT INTO `[buildings]` VALUES ('slot', '11', '', '2005-12-15 19:48:37', 25000, '0000-00-00 00:00:00', 1596009, 0, 0, 0, 250000, 0); INSERT INTO `[buildings]` VALUES ('slot', '12', '', '2005-12-15 21:38:14', 99999, '0000-00-00 00:00:00', 1679667, 0, 0, 0, -27560, 0); INSERT INTO `[buildings]` VALUES ('slot', '13', '', '2005-12-28 19:01:08', 25000, '0000-00-00 00:00:00', 2559757, 0, 0, 0, 250000, 0); INSERT INTO `[buildings]` VALUES ('slot', '14', '', '2005-12-16 09:52:12', 25000, '0000-00-00 00:00:00', 130398, 0, 0, 0, 250000, 0); INSERT INTO `[buildings]` VALUES ('slot', '15', '', '2006-01-10 21:08:38', 99999, '0000-00-00 00:00:00', 20, 0, 0, 0, 250000, 0); INSERT INTO `[buildings]` VALUES ('bulletfactory', '1', '', '2005-09-01 12:35:00', 10000, '0000-00-00 00:00:00', 2147133647, 1000, 19386, 0, -610440, 0); INSERT INTO `[buildings]` VALUES ('bulletfactory', '2', '', '2005-09-01 15:05:50', 10000, '0000-00-00 00:00:00', 2146483647, 1000, 20000, 0, -613000, 0); INSERT INTO `[buildings]` VALUES ('bulletfactory', '3', '', '2005-09-01 12:32:20', 10000, '0000-00-00 00:00:00', 2146933647, 1000, 11000, 0, -335440, 0); INSERT INTO `[buildings]` VALUES ('bulletfactory', '4', '', '2006-01-06 11:53:16', 10000, '0000-00-00 00:00:00', 2145433647, 1000, 44974, 0, -335440, 0); INSERT INTO `[buildings]` VALUES ('bulletfactory', '5', '', '2005-12-10 18:32:47', 10000, '0000-00-00 00:00:00', 2147083647, 1000, 8000, 0, -335440, 0); INSERT INTO `[buildings]` VALUES ('bulletfactory', '6', '', '2006-01-06 11:51:21', 10000, '0000-00-00 00:00:00', 2146583647, 1000, 25934, 0, -749990, 0); INSERT INTO `[buildings]` VALUES ('bulletfactory', '7', '', '2006-01-07 21:52:28', 10000, '0000-00-00 00:00:00', 2147133647, 1000, 7000, 0, -613000, 0); INSERT INTO `[buildings]` VALUES ('bulletfactory', '8', '', '2005-10-02 11:14:18', 14750, '0000-00-00 00:00:00', 2147133647, 1000, 7000, 0, 250000, 0); INSERT INTO `[buildings]` VALUES ('bulletfactory', '9', '', '2006-01-06 11:47:39', 25000, '0000-00-00 00:00:00', 2145933647, 1000, 31000, 0, 250000, 0); INSERT INTO `[buildings]` VALUES ('bulletfactory', '10', '', '2005-09-01 12:35:00', 10000, '0000-00-00 00:00:00', 2147133647, 1000, 19386, 0, -610440, 0); INSERT INTO `[buildings]` VALUES ('bulletfactory', '11', '', '2005-09-01 12:35:00', 10000, '0000-00-00 00:00:00', 2147133647, 1000, 19386, 0, -610440, 0); INSERT INTO `[buildings]` VALUES ('bulletfactory', '12', '', '2005-09-01 15:05:50', 10000, '0000-00-00 00:00:00', 2146483647, 1000, 20000, 0, -613000, 0); INSERT INTO `[buildings]` VALUES ('bulletfactory', '13', '', '2005-09-01 12:32:20', 10000, '0000-00-00 00:00:00', 2146933647, 1000, 11000, 0, -335440, 0); INSERT INTO `[buildings]` VALUES ('bulletfactory', '14', '', '2006-01-06 11:53:16', 10000, '0000-00-00 00:00:00', 2145433647, 1000, 44974, 0, -335440, 0); INSERT INTO `[buildings]` VALUES ('bulletfactory', '15', '', '2005-12-10 18:32:47', 10000, '0000-00-00 00:00:00', 2147083647, 1000, 8000, 0, -335440, 0); INSERT INTO `[buildings]` VALUES ('roulette', '2', '', '2006-01-10 12:00:10', 2500, '0000-00-00 00:00:00', 0, 0, 0, 0, 3190710, 145); INSERT INTO `[buildings]` VALUES ('roulette', '1', '', '2006-01-10 11:04:34', 99999, '0000-00-00 00:00:00', 2400043, 0, 0, 0, 15716649, 1109); INSERT INTO `[buildings]` VALUES ('roulette', '3', '', '0000-00-00 00:00:00', 100, '0000-00-00 00:00:00', 4154726, 0, 0, 0, 4404726, 259); INSERT INTO `[buildings]` VALUES ('roulette', '4', '', '2006-01-10 07:30:38', 2500, '0000-00-00 00:00:00', 101, 0, 0, 0, 8429734, 206); INSERT INTO `[buildings]` VALUES ('roulette', '5', '', '2006-01-10 17:26:59', 100, '0000-00-00 00:00:00', 608, 0, 0, 0, 742698, 115); INSERT INTO `[buildings]` VALUES ('roulette', '6', '', '2006-01-12 20:22:45', 10000, '0000-00-00 00:00:00', 2184385, 0, 0, 0, 3651328, 130); INSERT INTO `[buildings]` VALUES ('roulette', '7', '', '2006-01-10 11:00:45', 2147483647, '0000-00-00 00:00:00', 50000, 0, 0, 0, 404541, 93); INSERT INTO `[buildings]` VALUES ('roulette', '8', '', '2006-01-10 11:00:45', 2147483647, '0000-00-00 00:00:00', 50000, 0, 0, 0, 404541, 93); INSERT INTO `[buildings]` VALUES ('roulette', '9', '', '2006-01-16 18:14:30', 100, '0000-00-00 00:00:00', 0, 0, 0, 0, 1375536, 181); INSERT INTO `[buildings]` VALUES ('roulette', '10', '', '2006-01-10 12:00:10', 2500, '0000-00-00 00:00:00', 0, 0, 0, 0, 3190710, 145); INSERT INTO `[buildings]` VALUES ('roulette', '11', '', '2006-01-10 11:04:34', 99999, '0000-00-00 00:00:00', 2400043, 0, 0, 0, 15716649, 1109); INSERT INTO `[buildings]` VALUES ('roulette', '12', '', '0000-00-00 00:00:00', 100, '0000-00-00 00:00:00', 4154726, 0, 0, 0, 4404726, 259); INSERT INTO `[buildings]` VALUES ('roulette', '13', '', '2006-01-10 07:30:38', 2500, '0000-00-00 00:00:00', 101, 0, 0, 0, 8429734, 206); INSERT INTO `[buildings]` VALUES ('roulette', '14', '', '2006-01-10 17:26:59', 100, '0000-00-00 00:00:00', 608, 0, 0, 0, 742698, 115); INSERT INTO `[buildings]` VALUES ('roulette', '15', '', '2006-01-10 12:00:10', 2500, '0000-00-00 00:00:00', 0, 0, 0, 0, 3190710, 145); -- --------------------------------------------------------