-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathuren.sql
133 lines (109 loc) · 4.75 KB
/
uren.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
-- phpMyAdmin SQL Dump
-- version 4.0.10.14
-- http://www.phpmyadmin.net
--
-- Machine: localhost:3306
-- Genereertijd: 15 sep 2016 om 11:29
-- Serverversie: 10.1.17-MariaDB
-- PHP-versie: 5.6.20
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Databank: `kb`
--
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `gebruikers`
--
CREATE TABLE IF NOT EXISTS `gebruikers` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
`naam` varchar(32) COLLATE utf8_bin NOT NULL COMMENT 'gebruiker naam',
`wachtwoord` tinytext COLLATE utf8_bin NOT NULL COMMENT 'hash',
`rechten` varchar(1) COLLATE utf8_bin NOT NULL COMMENT 'Rechten',
`groep` varchar(3) COLLATE utf8_bin NOT NULL COMMENT 'Groep',
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`,`naam`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='gebruikers Tabel' AUTO_INCREMENT=2 ;
--
-- Gegevens worden uitgevoerd voor tabel `gebruikers`
--
INSERT INTO `gebruikers` (`id`, `naam`, `wachtwoord`, `rechten`) VALUES
(1, 'admin', 'sha1:64000:18:oL3WvUkwNucezB2W+i8aCtmm9FeYI9bK:b6ttPoBf48gGCMci/SW2mZT7', '3');
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `groep`
--
CREATE TABLE IF NOT EXISTS `groep` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
`user` text COLLATE utf8_bin NOT NULL COMMENT 'user id',
`naam` tinytext COLLATE utf8_bin NOT NULL COMMENT 'groepnaam',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Groep Tabel' AUTO_INCREMENT=1 ;
--
-- Tabelstructuur voor tabel `klanten`
--
CREATE TABLE IF NOT EXISTS `klanten` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
`naam` varchar(64) COLLATE utf8_bin NOT NULL COMMENT 'Klant Naam',
`email` varchar(64) COLLATE utf8_bin NOT NULL COMMENT 'Klant email',
`adress` tinytext COLLATE utf8_bin NOT NULL COMMENT 'klant adress',
`telefoon` varchar(20) COLLATE utf8_bin NOT NULL COMMENT 'Klant email',
PRIMARY KEY (`id`),
UNIQUE KEY `naam` (`naam`),
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='klanten Tabel' AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `projecten`
--
CREATE TABLE IF NOT EXISTS `projecten` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
`klant` tinyint(4) NOT NULL COMMENT 'Klant id',
`naam` varchar(64) COLLATE utf8_bin NOT NULL COMMENT 'Project Naam',
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Projecten tabel' AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `aanwezig`
--
CREATE TABLE IF NOT EXISTS `aanwezig` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
`uid` tinyint(4) NOT NULL COMMENT 'Gebruiker ID',
`van` tinytext COLLATE utf8_bin NOT NULL COMMENT 'aanwezig Van',
`tot` tinytext COLLATE utf8_bin NOT NULL COMMENT 'Aanwezig Tot',
`datum` tinytext COLLATE utf8_bin NOT NULL COMMENT 'Aanwezig Datum',
`uren` tinytext COLLATE utf8_bin NOT NULL COMMENT 'Totaal Uren',
`gefactureerd` varchar(1) DEFAULT 'n' COLLATE utf8_bin NOT NULL COMMENT 'Factuur Aangemaakt',
`ziek` varchar(1) DEFAULT 'n' COLLATE utf8_bin NOT NULL COMMENT 'Ziek',
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='aanwezig Tabel' AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `Details`
--
CREATE TABLE IF NOT EXISTS `details` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
`awid` tinyint(4) NOT NULL COMMENT 'Aanwezigheids ID',
`van` tinytext COLLATE utf8_bin NOT NULL COMMENT 'aanwezig Van',
`tot` tinytext COLLATE utf8_bin NOT NULL COMMENT 'Aanwezig Tot',
`datum` tinytext COLLATE utf8_bin NOT NULL COMMENT 'Aanwezig Datum',
`kid` tinyint(4) NOT NULL COMMENT 'Klant ID',
`pid` tinyint(4) NOT NULL COMMENT 'Project ID',
`uren` tinytext COLLATE utf8_bin NOT NULL COMMENT 'Totaal Uren',
`factuur` varchar(1) COLLATE utf8_bin NOT NULL COMMENT 'Factureren',
`info` tinytext COLLATE utf8_bin NOT NULL COMMENT 'Details info',
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Details Tabel' AUTO_INCREMENT=1 ;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
--
-- /* CopyRight PowerChaos 2016 */
--