e0UiuP0m

1-- MySQL Administrator dump 1.4
2--
3-- ------------------------------------------------------
4-- Server version	5.1.38-community
5
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11
12/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
13/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
14/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
15
16
17--
18-- Create schema inventory
19--
20
21CREATE DATABASE IF NOT EXISTS inventory;
22USE inventory;
23
24--
25-- Definition of table `bins`
26--
27CREATE TABLE `bins` (
28  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
29  `name` varchar(45) NOT NULL,
30  PRIMARY KEY (`id`)
31) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Where can the parts be stored';
32
33--
34-- Dumping data for table `bins`
35--
36
37--
38-- Definition of table `monthly_counts`
39--
40CREATE TABLE `monthly_counts` (
41  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
42  `part_id` int(10) unsigned NOT NULL,
43  `date` datetime NOT NULL,
44  PRIMARY KEY (`id`)
45) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Stores the monthly total of parts';
46
47--
48-- Dumping data for table `monthly_counts`
49--
50
51--
52-- Definition of table `parts`
53--
54CREATE TABLE `parts` (
55  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
56  `name` varchar(45) NOT NULL,
57  PRIMARY KEY (`id`)
58) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='This holds the names of various parts';
59
60--
61-- Dumping data for table `parts`
62--
63
64--
65-- Definition of table `transactions`
66--
67CREATE TABLE `transactions` (
68  `id` double NOT NULL AUTO_INCREMENT,
69  `part_id` int(10) unsigned NOT NULL,
70  `from_id` int(10) unsigned NOT NULL,
71  `to_id` int(10) unsigned NOT NULL,
72  `quantity` int(10) unsigned NOT NULL,
73  `timestamp` datetime NOT NULL,
74  PRIMARY KEY (`id`)
75) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='When did we transfer how many of what from where to where';
76
77--
78-- Dumping data for table `transactions`
79--
80
81
82
83/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
84/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
85/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
86/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
87/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
88/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
89/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;