sql.sql

--
-- Tabelstructuur voor tabel `objectlist`
--

CREATE TABLE `objectlist` (
`id` int(15) NOT NULL AUTO_INCREMENT,
`objectname` varchar(150) NOT NULL,
`objectimage` varchar(150) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Gegevens worden uitgevoerd voor tabel `objectlist`
--

INSERT INTO `objectlist` (`id`, `objectname`, `objectimage`) VALUES
(1, 'Voetpad', 'images/path.png'),
(2, 'Prullenbak', 'images/delete.png'),
(3, 'Boom', 'images/tree.png'),
(4, 'Water', 'images/water.png');

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

--
-- Tabelstructuur voor tabel `objects`
--

CREATE TABLE `objects` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`objectnaam` varchar(150) NOT NULL,
`objectImage` varchar(200) NOT NULL,
`userid` int(11) NOT NULL,
`xPos` int(15) NOT NULL,
`yPos` int(15) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Gegevens worden uitgevoerd voor tabel `objects`
--

INSERT INTO `objects` (`id`, `objectnaam`, `objectImage`, `userid`, `xPos`, `yPos`) VALUES
(1, 'Voetpad', 'images/path.png', 1, 8, 6),
(2, 'Voetpad', 'images/path.png', 1, 8, 7),
(3, 'Voetpad', 'images/path.png', 1, 8, 8),
(4, 'Voetpad', 'images/path.png', 1, 8, 9),
(5, 'Voetpad', 'images/path.png', 1, 8, 10),
(6, 'Voetpad', 'images/path.png', 1, 9, 10),
(7, 'Voetpad', 'images/path.png', 1, 10, 10),
(8, 'Voetpad', 'images/path.png', 1, 11, 10),
(9, 'Prullenbak', 'images/delete.png', 1, 11, 9),
(10, 'Voetpad', 'images/path.png', 1, 12, 10),
(11, 'Voetpad', 'images/path.png', 1, 13, 10),
(12, 'Voetpad', 'images/path.png', 1, 13, 11),
(13, 'Voetpad', 'images/path.png', 1, 13, 12),
(14, 'Voetpad', 'images/path.png', 1, 7, 6),
(15, 'Voetpad', 'images/path.png', 1, 6, 6),
(16, 'Voetpad', 'images/path.png', 1, 5, 6),
(17, 'Voetpad', 'images/path.png', 1, 4, 6),
(18, 'Boom', 'images/tree.png', 1, 14, 10),
(19, 'Boom', 'images/tree.png', 1, 7, 5),
(20, 'Voetpad', 'images/path.png', 1, 3, 6),
(21, 'Voetpad', 'images/path.png', 1, 2, 6),
(22, 'Voetpad', 'images/path.png', 1, 1, 6),
(23, 'Boom', 'images/tree.png', 1, 5, 7),
(24, 'Boom', 'images/tree.png', 1, 10, 11),
(25, 'Voetpad', 'images/path.png', 1, 13, 13),
(26, 'Voetpad', 'images/path.png', 1, 14, 13),
(27, 'Voetpad', 'images/path.png', 1, 15, 13),
(28, 'Boom', 'images/tree.png', 1, 15, 12),
(29, 'Voetpad', 'images/path.png', 1, 16, 13),
(30, 'Voetpad', 'images/path.png', 1, 16, 14),
(31, 'Voetpad', 'images/path.png', 1, 16, 15),
(32, 'Voetpad', 'images/path.png', 1, 16, 16),
(33, 'Voetpad', 'images/path.png', 1, 15, 16),
(34, 'Voetpad', 'images/path.png', 1, 14, 16),
(35, 'Voetpad', 'images/path.png', 1, 13, 16),
(36, 'Voetpad', 'images/path.png', 1, 12, 16),
(37, 'Voetpad', 'images/path.png', 1, 11, 16),
(38, 'Water', 'images/water.png', 1, 15, 15),
(39, 'Water', 'images/water.png', 1, 15, 14),
(40, 'Water', 'images/water.png', 1, 14, 14),
(41, 'Water', 'images/water.png', 1, 14, 15),
(42, 'Water', 'images/water.png', 1, 13, 14),
(43, 'Water', 'images/water.png', 1, 13, 15),
(44, 'Water', 'images/water.png', 1, 12, 15),
(45, 'Voetpad', 'images/path.png', 1, 10, 16),
(46, 'Voetpad', 'images/path.png', 1, 9, 16),
(47, 'Voetpad', 'images/path.png', 1, 8, 16),
(48, 'Voetpad', 'images/path.png', 1, 8, 15),
(49, 'Voetpad', 'images/path.png', 1, 8, 14),
(50, 'Voetpad', 'images/path.png', 1, 8, 13),
(51, 'Voetpad', 'images/path.png', 1, 8, 12),
(52, 'Voetpad', 'images/path.png', 1, 8, 11),
(53, 'Boom', 'images/tree.png', 1, 9, 15),
(54, 'Voetpad', 'images/path.png', 1, 17, 14),
(55, 'Voetpad', 'images/path.png', 1, 18, 14),
(56, 'Voetpad', 'images/path.png', 1, 19, 14),
(57, 'Prullenbak', 'images/delete.png', 1, 20, 14);