database.sql

Time 4 Crime online

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

-- 
-- Tabel structuur voor tabel `[auto]`
-- 

CREATE TABLE `[auto]` (
  `id` int(255) NOT NULL auto_increment,
  `soort` int(3) NOT NULL default '0',
  `schade` int(3) NOT NULL default '0',
  `owner` varchar(255) NOT NULL default '',
  `land` int(10) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

-- 
-- Gegevens worden uitgevoerd voor tabel `[auto]`
-- 


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

-- 
-- Tabel structuur voor tabel `[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'
) TYPE=MyISAM;

-- 
-- Gegevens worden uitgevoerd voor tabel `[buildings]`
-- 

INSERT INTO `[buildings]` VALUES ('trainstation', 'Groningen', 'unowned', '2005-12-12 00:12:01', 2500, '0000-00-00 00:00:00', 1069, 0, 0);
INSERT INTO `[buildings]` VALUES ('trainstation', 'Amsterdam', 'unowned', '2005-12-10 23:52:11', 2500, '0000-00-00 00:00:00', 280, 0, 0);
INSERT INTO `[buildings]` VALUES ('trainstation', 'Den Haag', 'unowned', '2005-12-11 21:53:08', 2500, '0000-00-00 00:00:00', 210, 0, 0);
INSERT INTO `[buildings]` VALUES ('trainstation', 'Rotterdam', 'unowned', '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 70, 0, 0);
INSERT INTO `[buildings]` VALUES ('trainstation', 'Bergen op Zoom', 'unowned', '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 70, 0, 0);
INSERT INTO `[buildings]` VALUES ('trainstation', 'Venlo', 'unowned', '2005-12-18 19:17:30', 2500, '0000-00-00 00:00:00', 140, 0, 0);
INSERT INTO `[buildings]` VALUES ('bulletfactory', 'Groningen', 'unowned', '2005-12-11 23:15:07', 2500, '0000-00-00 00:00:00', -124001, 0, 740);
INSERT INTO `[buildings]` VALUES ('bulletfactory', 'Amsterdam', 'unowned', '2005-11-16 06:15:46', 2500, '0000-00-00 00:00:00', 22500, 0, 15);
INSERT INTO `[buildings]` VALUES ('bulletfactory', 'Den Haag', 'unowned', '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, 0, 0);
INSERT INTO `[buildings]` VALUES ('bulletfactory', 'Colorado', 'unowned', '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, 0, 0);
INSERT INTO `[buildings]` VALUES ('bulletfactory', 'Rotterdam', 'unowned', '2005-11-17 11:25:43', 2500, '0000-00-00 00:00:00', 412500, 0, 0);
INSERT INTO `[buildings]` VALUES ('bulletfactory', 'Bergen op Zoom', 'unowned', '2005-12-18 19:18:03', 99999, '0000-00-00 00:00:00', -547250, 0, 0);
INSERT INTO `[buildings]` VALUES ('roulette', 'Venlo', 'unowned', '2005-12-10 23:55:11', 2500, '0000-00-00 00:00:00', 300, 0, 0);
INSERT INTO `[buildings]` VALUES ('roulette', 'Groningen', 'unowned', '2005-11-15 07:11:09', 20000, '0000-00-00 00:00:00', 0, 0, 0);
INSERT INTO `[buildings]` VALUES ('roulette', 'Amsterdam', 'unowned', '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, 0, 0);
INSERT INTO `[buildings]` VALUES ('roulette', 'Den Haag', 'unowned', '2005-11-11 23:29:44', 2500, '0000-00-00 00:00:00', 0, 0, 0);
INSERT INTO `[buildings]` VALUES ('roulette', 'Rotterdam', 'unowned', '2005-11-15 07:47:13', 2500, '0000-00-00 00:00:00', 26500, 0, 0);
INSERT INTO `[buildings]` VALUES ('roulette', 'Bergen op Zoom', 'unowned', '2005-11-20 05:29:27', 2500, '0000-00-00 00:00:00', 0, 0, 0);
INSERT INTO `[buildings]` VALUES ('slot', 'Venlo', 'unowned', '2005-12-10 23:54:59', 2500, '0000-00-00 00:00:00', 0, 0, 0);
INSERT INTO `[buildings]` VALUES ('slot', 'Groningen', 'unowned', '2005-12-07 21:51:22', 2500, '0000-00-00 00:00:00', 600, 0, 0);
INSERT INTO `[buildings]` VALUES ('slot', 'Amsterdam', 'unowned', '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, 0, 0);
INSERT INTO `[buildings]` VALUES ('slot', 'Den Haag', 'unowned', '2005-12-11 21:39:52', 2500, '0000-00-00 00:00:00', 301, 0, 0);
INSERT INTO `[buildings]` VALUES ('slot', 'Rotterdam', 'unowned', '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, 0, 0);
INSERT INTO `[buildings]` VALUES ('slot', 'Bergen op Zoom', 'unowned', '2005-11-20 05:36:05', 2500, '0000-00-00 00:00:00', 500, 0, 0);
INSERT INTO `[buildings]` VALUES ('bulletfactory', 'Venlo', 'unowned', '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, 0, 0);
INSERT INTO `[buildings]` VALUES ('racetrack', 'Groningen', 'unowned', '2005-12-10 23:55:08', 2500, '0000-00-00 00:00:00', 999, 0, 0);
INSERT INTO `[buildings]` VALUES ('racetrack', 'Amsterdam', 'unowned', '2005-11-15 09:25:35', 25000, '0000-00-00 00:00:00', 0, 0, 0);
INSERT INTO `[buildings]` VALUES ('racetrack', 'Den Haag', 'unowned', '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, 0, 0);
INSERT INTO `[buildings]` VALUES ('racetrack', 'Rotterdam', 'unowned', '2005-11-11 23:30:06', 2500, '0000-00-00 00:00:00', 0, 0, 0);
INSERT INTO `[buildings]` VALUES ('racetrack', 'Bergen op Zoom', 'unowned', '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, 0, 0);
INSERT INTO `[buildings]` VALUES ('racetrack', 'Venlo', 'unowned', '2005-12-12 00:57:04', 2500, '0000-00-00 00:00:00', 480, 0, 0);

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

-- 
-- Tabel structuur voor tabel `[cron]`
-- 

CREATE TABLE `[cron]` (
  `time` datetime default NULL,
  `name` varchar(16) NOT NULL default '',
  PRIMARY KEY  (`name`)
) TYPE=MyISAM;

-- 
-- Gegevens worden uitgevoerd voor tabel `[cron]`
-- 

INSERT INTO `[cron]` VALUES ('2006-01-06 14:06:36', 'hour');
INSERT INTO `[cron]` VALUES ('2006-01-06 14:06:36', 'day');
INSERT INTO `[cron]` VALUES ('2006-01-06 14:06:36', 'week');
INSERT INTO `[cron]` VALUES ('2006-01-06 14:06:36', 'month');
INSERT INTO `[cron]` VALUES ('2005-12-29 22:24:33', 'horserace');

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

-- 
-- Tabel structuur voor tabel `[detective]`
-- 

CREATE TABLE `[detective]` (
  `id` int(200) NOT NULL auto_increment,
  `naam` varchar(200) default NULL,
  `zoeker` varchar(200) default NULL,
  `uren` int(200) NOT NULL default '0',
  `tijd` datetime NOT NULL default '0000-00-00 00:00:00',
  `vind` int(200) NOT NULL default '0',
  `status` int(200) NOT NULL default '0',
  `land` varchar(225) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=21 ;

-- 
-- Gegevens worden uitgevoerd voor tabel `[detective]`
-- 

INSERT INTO `[detective]` VALUES (19, 'gerbie', 'kefcodeman', 1, '2005-12-18 13:41:58', 0, 0, '');

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

-- 
-- Tabel structuur voor tabel `[donates]`
-- 

CREATE TABLE `[donates]` (
  `time` datetime default NULL,
  `login` varchar(16) default NULL,
  `person` varchar(16) default NULL,
  `amount` int(11) default NULL,
  `timeneeded` int(5) default NULL,
  `message` varchar(200) default NULL
) TYPE=MyISAM;

-- 
-- Gegevens worden uitgevoerd voor tabel `[donates]`
-- 


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

-- 
-- Tabel structuur voor tabel `[drank]`
-- 

CREATE TABLE `[drank]` (
  `land` int(10) NOT NULL default '0',
  `verandertijd` datetime NOT NULL default '0000-00-00 00:00:00',
  `prijs1` int(10) NOT NULL default '0',
  `prijs2` int(10) NOT NULL default '0',
  `prijs3` int(10) NOT NULL default '0',
  `prijs4` int(10) NOT NULL default '0',
  `prijs5` int(10) NOT NULL default '0'
) TYPE=MyISAM;

-- 
-- Gegevens worden uitgevoerd voor tabel `[drank]`
-- 


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

-- 
-- Tabel structuur voor tabel `[drugs]`
-- 

CREATE TABLE `[drugs]` (
  `land` int(10) NOT NULL default '0',
  `verandertijd` datetime NOT NULL default '0000-00-00 00:00:00',
  `prijs1` int(10) NOT NULL default '0',
  `prijs2` int(10) NOT NULL default '0',
  `prijs3` int(10) NOT NULL default '0',
  `prijs4` int(10) NOT NULL default '0',
  `prijs5` int(10) NOT NULL default '0'
) TYPE=MyISAM;

-- 
-- Gegevens worden uitgevoerd voor tabel `[drugs]`
-- 


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

-- 
-- Tabel structuur voor tabel `[families]`
-- 

CREATE TABLE `[families]` (
  `id` int(255) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `leader` varchar(255) NOT NULL default '',
  `consig` varchar(255) NOT NULL default '',
  `sotto` varchar(255) NOT NULL default '',
  `charge` varchar(255) NOT NULL default '',
  `leavecost` int(255) NOT NULL default '0',
  `bank` int(255) NOT NULL default '0',
  `recruit` varchar(255) NOT NULL default '',
  `startdate` datetime NOT NULL default '0000-00-00 00:00:00',
  `info` text NOT NULL,
  `caponame1` varchar(255) NOT NULL default '',
  `famimg` varchar(255) NOT NULL default '',
  `activated` int(255) NOT NULL default '1',
  `crush` int(255) NOT NULL default '0',
  `crushsys` int(255) NOT NULL default '0',
  `convsys` int(255) NOT NULL default '0',
  `maxautos` varchar(255) NOT NULL default '0',
  `autosnu` varchar(255) NOT NULL default '0',
  `maxkogels` varchar(255) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=4 ;

-- 
-- Gegevens worden uitgevoerd voor tabel `[families]`
-- 

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

-- 
-- Tabel structuur voor tabel `[garage]`
-- 

CREATE TABLE `[garage]` (
  `id` int(11) NOT NULL auto_increment,
  `car` varchar(255) NOT NULL default '',
  `damage` int(2) NOT NULL default '0',
  `original` varchar(255) NOT NULL default '',
  `city` varchar(225) NOT NULL default '',
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `login` varchar(225) NOT NULL default '',
  UNIQUE KEY `id` (`id`)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=217 ;

-- 
-- Gegevens worden uitgevoerd voor tabel `[garage]`
-- 


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

-- 
-- Tabel structuur voor tabel `[getuige]`
-- 

CREATE TABLE `[getuige]` (
  `id` int(255) NOT NULL auto_increment,
  `naam` varchar(255) NOT NULL default '',
  `vermoord` varchar(255) NOT NULL default '',
  `moorder` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

-- 
-- Gegevens worden uitgevoerd voor tabel `[getuige]`
-- 


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

-- 
-- Tabel structuur voor tabel `[handdruk]`
-- 

CREATE TABLE `[handdruk]` (
  `id` int(255) NOT NULL auto_increment,
  `naam` varchar(255) NOT NULL default '',
  `inzet` int(255) NOT NULL default '0',
  `wanneer` datetime NOT NULL default '0000-00-00 00:00:00',
  `land` varchar(225) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=11 ;

-- 
-- Gegevens worden uitgevoerd voor tabel `[handdruk]`
-- 


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

--