vnLxaDe3

1-- phpMyAdmin SQL Dump
2-- version 4.5.5.1
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: Sep 28, 2016 at 09:56 AM
7-- Server version: 5.7.11
8-- PHP Version: 5.6.19
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 utf8mb4 */;
18
19--
20-- Database: `bestelling`
21--
22CREATE DATABASE IF NOT EXISTS `bestelling` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
23USE `bestelling`;
24
25-- --------------------------------------------------------
26
27--
28-- Table structure for table `artikelnmr`
29--
30
31DROP TABLE IF EXISTS `artikelnmr`;
32CREATE TABLE IF NOT EXISTS `artikelnmr` (
33  `artikelnummer` int(11) NOT NULL,
34  `omschrijving` int(11) NOT NULL,
35  `maat` int(11) NOT NULL,
36  `prijsperstuk` int(11) NOT NULL
37) ENGINE=MyISAM DEFAULT CHARSET=latin1;
38
39-- --------------------------------------------------------
40
41--
42-- Table structure for table `bestelde artikelen`
43--
44
45DROP TABLE IF EXISTS `bestelde artikelen`;
46CREATE TABLE IF NOT EXISTS `bestelde artikelen` (
47  `bonnummer` int(11) NOT NULL,
48  `artikelnummer` int(11) NOT NULL,
49  `aantal` int(11) NOT NULL,
50  PRIMARY KEY (`bonnummer`,`artikelnummer`)
51) ENGINE=MyISAM DEFAULT CHARSET=latin1;
52
53-- --------------------------------------------------------
54
55--
56-- Table structure for table `bestelling`
57--
58
59DROP TABLE IF EXISTS `bestelling`;
60CREATE TABLE IF NOT EXISTS `bestelling` (
61  `bonnummer` int(11) NOT NULL,
62  `datum` date NOT NULL,
63  `handtekening` int(11) NOT NULL,
64  PRIMARY KEY (`bonnummer`)
65) ENGINE=MyISAM DEFAULT CHARSET=latin1;
66
67--
68-- Dumping data for table `bestelling`
69--
70
71INSERT INTO `bestelling` (`bonnummer`, `datum`, `handtekening`) VALUES
72(1, '2016-10-05', 12345);
73
74-- --------------------------------------------------------
75
76--
77-- Table structure for table `klantgegevens`
78--
79
80DROP TABLE IF EXISTS `klantgegevens`;
81CREATE TABLE IF NOT EXISTS `klantgegevens` (
82  `klantnmr` int(11) NOT NULL,
83  `naam` int(11) NOT NULL,
84  `adres` int(11) NOT NULL,
85  `woonplaats` int(11) NOT NULL,
86  PRIMARY KEY (`klantnmr`)
87) ENGINE=MyISAM DEFAULT CHARSET=latin1;
88
89/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
90/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
91/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;