database.sql

Time 4 Crime online

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

CREATE TABLE `[honourpoints]` (
  `id` int(255) NOT NULL auto_increment,
  `to` varchar(255) NOT NULL default '',
  `from` varchar(255) NOT NULL default '',
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `points` int(255) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

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


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

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

CREATE TABLE `[land]` (
  `owner` varchar(255) NOT NULL default '',
  `id` int(255) NOT NULL default '0'
) TYPE=MyISAM;

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

INSERT INTO `[land]` VALUES ('none', 2);
INSERT INTO `[land]` VALUES ('none', 3);
INSERT INTO `[land]` VALUES ('none', 4);
INSERT INTO `[land]` VALUES ('none', 5);
INSERT INTO `[land]` VALUES ('none', 6);
INSERT INTO `[land]` VALUES ('none', 7);
INSERT INTO `[land]` VALUES ('none', 1);
INSERT INTO `[land]` VALUES ('none', 8);
INSERT INTO `[land]` VALUES ('none', 9);
INSERT INTO `[land]` VALUES ('none', 10);
INSERT INTO `[land]` VALUES ('none', 11);
INSERT INTO `[land]` VALUES ('none', 12);
INSERT INTO `[land]` VALUES ('none', 13);
INSERT INTO `[land]` VALUES ('none', 14);
INSERT INTO `[land]` VALUES ('none', 15);
INSERT INTO `[land]` VALUES ('none', 16);
INSERT INTO `[land]` VALUES ('none', 17);
INSERT INTO `[land]` VALUES ('none', 18);
INSERT INTO `[land]` VALUES ('none', 19);
INSERT INTO `[land]` VALUES ('none', 20);
INSERT INTO `[land]` VALUES ('none', 21);
INSERT INTO `[land]` VALUES ('none', 22);
INSERT INTO `[land]` VALUES ('none', 23);
INSERT INTO `[land]` VALUES ('none', 24);
INSERT INTO `[land]` VALUES ('none', 25);
INSERT INTO `[land]` VALUES ('none', 26);
INSERT INTO `[land]` VALUES ('none', 27);
INSERT INTO `[land]` VALUES ('none', 28);
INSERT INTO `[land]` VALUES ('none', 29);
INSERT INTO `[land]` VALUES ('none', 30);
INSERT INTO `[land]` VALUES ('none', 31);
INSERT INTO `[land]` VALUES ('none', 32);
INSERT INTO `[land]` VALUES ('none', 33);
INSERT INTO `[land]` VALUES ('none', 34);
INSERT INTO `[land]` VALUES ('none', 35);
INSERT INTO `[land]` VALUES ('none', 36);
INSERT INTO `[land]` VALUES ('none', 37);
INSERT INTO `[land]` VALUES ('none', 38);
INSERT INTO `[land]` VALUES ('none', 39);
INSERT INTO `[land]` VALUES ('none', 40);
INSERT INTO `[land]` VALUES ('none', 41);
INSERT INTO `[land]` VALUES ('none', 42);
INSERT INTO `[land]` VALUES ('none', 44);
INSERT INTO `[land]` VALUES ('none', 43);
INSERT INTO `[land]` VALUES ('none', 45);
INSERT INTO `[land]` VALUES ('none', 46);
INSERT INTO `[land]` VALUES ('none', 47);
INSERT INTO `[land]` VALUES ('none', 48);
INSERT INTO `[land]` VALUES ('none', 49);
INSERT INTO `[land]` VALUES ('none', 50);
INSERT INTO `[land]` VALUES ('none', 51);
INSERT INTO `[land]` VALUES ('none', 52);
INSERT INTO `[land]` VALUES ('none', 53);
INSERT INTO `[land]` VALUES ('none', 54);
INSERT INTO `[land]` VALUES ('none', 55);

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

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

CREATE TABLE `[landen1]` (
  `id` int(6) NOT NULL auto_increment,
  `area` int(3) NOT NULL default '0',
  `land` varchar(128) NOT NULL default '',
  `aantal` int(3) NOT NULL default '0',
  `prijs` int(128) NOT NULL default '0',
  UNIQUE KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=71 ;

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

INSERT INTO `[landen1]` VALUES (8, 4, 'groningen', 184, 413);
INSERT INTO `[landen1]` VALUES (7, 3, 'groningen', 339, 466);
INSERT INTO `[landen1]` VALUES (6, 2, 'groningen', 264, 321);
INSERT INTO `[landen1]` VALUES (5, 1, 'groningen', 981, 190);
INSERT INTO `[landen1]` VALUES (9, 5, 'groningen', 151, 331);
INSERT INTO `[landen1]` VALUES (10, 6, 'groningen', 2486, 483);
INSERT INTO `[landen1]` VALUES (11, 1, 'amsterdam', 456, 242);
INSERT INTO `[landen1]` VALUES (12, 2, 'amsterdam', 176, 470);
INSERT INTO `[landen1]` VALUES (13, 3, 'amsterdam', 159, 215);
INSERT INTO `[landen1]` VALUES (14, 4, 'amsterdam', 236, 452);
INSERT INTO `[landen1]` VALUES (15, 5, 'amsterdam', 226, 495);
INSERT INTO `[landen1]` VALUES (16, 6, 'amsterdam', 70, 181);
INSERT INTO `[landen1]` VALUES (17, 1, 'den haag', 353, 345);
INSERT INTO `[landen1]` VALUES (18, 2, 'den haag', 600, 292);
INSERT INTO `[landen1]` VALUES (19, 3, 'den haag', 165, 320);
INSERT INTO `[landen1]` VALUES (20, 4, 'den haag', 610, 434);
INSERT INTO `[landen1]` VALUES (21, 5, 'den haag', 155, 385);
INSERT INTO `[landen1]` VALUES (22, 6, 'den haag', 185, 467);
INSERT INTO `[landen1]` VALUES (23, 1, 'rotterdam', 234, 382);
INSERT INTO `[landen1]` VALUES (24, 2, 'rotterdam', 155, 270);
INSERT INTO `[landen1]` VALUES (25, 3, 'rotterdam', 470, 212);
INSERT INTO `[landen1]` VALUES (26, 4, 'rotterdam', 100, 421);
INSERT INTO `[landen1]` VALUES (27, 5, 'rotterdam', 165, 497);
INSERT INTO `[landen1]` VALUES (28, 6, 'rotterdam', 405, 384);
INSERT INTO `[landen1]` VALUES (29, 1, 'bergen op zoom', 2116, 403);
INSERT INTO `[landen1]` VALUES (30, 2, 'bergen op zoom', 100, 140);
INSERT INTO `[landen1]` VALUES (31, 3, 'bergen op zoom', 100, 356);
INSERT INTO `[landen1]` VALUES (32, 4, 'bergen op zoom', 100, 156);
INSERT INTO `[landen1]` VALUES (33, 5, 'bergen op zoom', 75, 157);
INSERT INTO `[landen1]` VALUES (34, 6, 'bergen op zoom', 5, 128);
INSERT INTO `[landen1]` VALUES (35, 1, 'venlo', 255, 377);
INSERT INTO `[landen1]` VALUES (36, 2, 'venlo', 108, 373);
INSERT INTO `[landen1]` VALUES (37, 3, 'venlo', 100, 394);
INSERT INTO `[landen1]` VALUES (38, 4, 'venlo', 120, 265);
INSERT INTO `[landen1]` VALUES (39, 5, 'venlo', 17, 101);
INSERT INTO `[landen1]` VALUES (40, 6, 'venlo', 250, 243);

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

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

CREATE TABLE `[landen]` (
  `id` int(6) NOT NULL auto_increment,
  `area` int(3) NOT NULL default '0',
  `land` varchar(128) NOT NULL default '',
  `aantal` int(3) NOT NULL default '0',
  `prijs` int(128) NOT NULL default '0',
  UNIQUE KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=71 ;

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

INSERT INTO `[landen]` VALUES (8, 4, 'groningen', 185, 360);
INSERT INTO `[landen]` VALUES (7, 3, 'groningen', 340, 466);
INSERT INTO `[landen]` VALUES (6, 2, 'groningen', 265, 321);
INSERT INTO `[landen]` VALUES (5, 1, 'groningen', 51, 190);
INSERT INTO `[landen]` VALUES (9, 5, 'groningen', 152, 331);
INSERT INTO `[landen]` VALUES (10, 6, 'groningen', 2487, 483);
INSERT INTO `[landen]` VALUES (11, 1, 'amsterdam', 455, 242);
INSERT INTO `[landen]` VALUES (12, 2, 'amsterdam', 175, 470);
INSERT INTO `[landen]` VALUES (13, 3, 'amsterdam', 158, 215);
INSERT INTO `[landen]` VALUES (14, 4, 'amsterdam', 235, 452);
INSERT INTO `[landen]` VALUES (15, 5, 'amsterdam', 225, 495);
INSERT INTO `[landen]` VALUES (16, 6, 'amsterdam', 769, 181);
INSERT INTO `[landen]` VALUES (17, 1, 'den haag', 12, 430);
INSERT INTO `[landen]` VALUES (18, 2, 'den haag', 600, 292);
INSERT INTO `[landen]` VALUES (19, 3, 'den haag', 165, 320);
INSERT INTO `[landen]` VALUES (20, 4, 'den haag', 610, 434);
INSERT INTO `[landen]` VALUES (21, 5, 'den haag', 155, 385);
INSERT INTO `[landen]` VALUES (22, 6, 'den haag', 183, 467);
INSERT INTO `[landen]` VALUES (23, 1, 'rotterdam', 234, 382);
INSERT INTO `[landen]` VALUES (24, 2, 'rotterdam', 154, 270);
INSERT INTO `[landen]` VALUES (25, 3, 'rotterdam', 4, 193);
INSERT INTO `[landen]` VALUES (26, 4, 'rotterdam', 99, 421);
INSERT INTO `[landen]` VALUES (27, 5, 'rotterdam', 164, 497);
INSERT INTO `[landen]` VALUES (28, 6, 'rotterdam', 404, 384);
INSERT INTO `[landen]` VALUES (29, 1, 'bergen op zoom', 2116, 403);
INSERT INTO `[landen]` VALUES (30, 2, 'bergen op zoom', 100, 140);
INSERT INTO `[landen]` VALUES (31, 3, 'bergen op zoom', 100, 356);
INSERT INTO `[landen]` VALUES (32, 4, 'bergen op zoom', 100, 156);
INSERT INTO `[landen]` VALUES (33, 5, 'bergen op zoom', 75, 157);
INSERT INTO `[landen]` VALUES (34, 6, 'bergen op zoom', 0, 113);
INSERT INTO `[landen]` VALUES (35, 1, 'venlo', 255, 377);
INSERT INTO `[landen]` VALUES (36, 2, 'venlo', 108, 373);
INSERT INTO `[landen]` VALUES (37, 3, 'venlo', 100, 394);
INSERT INTO `[landen]` VALUES (38, 4, 'venlo', 120, 265);
INSERT INTO `[landen]` VALUES (39, 5, 'venlo', 317, 101);
INSERT INTO `[landen]` VALUES (40, 6, 'venlo', 250, 243);

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

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

CREATE TABLE `[logs]` (
  `time` datetime default NULL,
  `IP` varchar(32) default NULL,
  `forwardedFor` varchar(32) default NULL,
  `login` varchar(225) default NULL,
  `person` varchar(225) default NULL,
  `code` int(10) default NULL,
  `area` varchar(32) default NULL
) TYPE=MyISAM;

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


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

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

CREATE TABLE `[messages]` (
  `id` int(9) NOT NULL auto_increment,
  `IP` varchar(32) NOT NULL default '',
  `forwardedFor` varchar(32) default NULL,
  `time` datetime default NULL,
  `from` varchar(45) default NULL,
  `to` varchar(16) default NULL,
  `subject` varchar(50) NOT NULL default '',
  `message` text NOT NULL,
  `read` int(1) NOT NULL default '0',
  `inbox` int(1) default '1',
  `outbox` int(1) default '1',
  `saved` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=139 ;

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

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

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

CREATE TABLE `[omnilog]` (
  `time` datetime default NULL,
  `login` varchar(16) default NULL,
  `IP` varchar(32) default NULL,
  `forwardedFor` varchar(32) default NULL,
  `file` varchar(64) default NULL,
  `$_POST` text,
  `$_GET` text
) TYPE=MyISAM;

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

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

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

CREATE TABLE `[online]` (
  `time` datetime default NULL,
  `IP` varchar(32) default NULL,
  `login` varchar(16) NOT NULL default '',
  `validate` varchar(32) default NULL,
  PRIMARY KEY  (`login`),
  KEY `IP` (`IP`)
) TYPE=MyISAM;