33pbcFUT

1-- phpMyAdmin SQL Dump
2-- version 4.1.14
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: Jan 18, 2017 at 11:07 AM
7-- Server version: 5.6.17
8-- PHP Version: 5.5.12
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `tools4ever`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `fabriek`
27--
28
29CREATE TABLE IF NOT EXISTS `fabriek` (
30  `fabriekscode` varchar(7) NOT NULL,
31  `fabriek` varchar(30) NOT NULL,
32  `telefoon` varchar(22) NOT NULL
33) ENGINE=InnoDB DEFAULT CHARSET=latin1;
34
35-- --------------------------------------------------------
36
37--
38-- Table structure for table `locatie`
39--
40
41CREATE TABLE IF NOT EXISTS `locatie` (
42  `locatiecode` int(4) NOT NULL,
43  `locatie` varchar(30) NOT NULL
44) ENGINE=InnoDB DEFAULT CHARSET=latin1;
45
46-- --------------------------------------------------------
47
48--
49-- Table structure for table `medewerker`
50--
51
52CREATE TABLE IF NOT EXISTS `medewerker` (
53  `medewerkerscode` int(5) NOT NULL,
54  `voorletters` varchar(10) NOT NULL,
55  `voorvoegsels` varchar(10) NOT NULL,
56  `achternaam` varchar(30) NOT NULL,
57  `gebruikersnaam` varchar(30) NOT NULL,
58  `wachtwoord` varchar(32) NOT NULL
59) ENGINE=InnoDB DEFAULT CHARSET=latin1;
60
61-- --------------------------------------------------------
62
63--
64-- Table structure for table `product`
65--
66
67CREATE TABLE IF NOT EXISTS `product` (
68  `productcode` int(10) NOT NULL,
69  `product` varchar(30) NOT NULL,
70  `type` varchar(30) NOT NULL,
71  `fabriekscode` varchar(7) NOT NULL,
72  `inkoopprijs` decimal(7,2) NOT NULL,
73  `verkoopprijs` decimal(7,2) NOT NULL
74) ENGINE=InnoDB DEFAULT CHARSET=latin1;
75
76-- --------------------------------------------------------
77
78--
79-- Table structure for table `voorraad`
80--
81
82CREATE TABLE IF NOT EXISTS `voorraad` (
83  `locatiecode` int(4) NOT NULL,
84  `productcode` int(10) NOT NULL,
85  `aantal` int(5) NOT NULL
86) ENGINE=InnoDB DEFAULT CHARSET=latin1;
87
88/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
89/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
90/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;