t0DxjhKY

1-- phpMyAdmin SQL Dump
2-- version 4.0.10deb1
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: Oct 04, 2016 at 07:18 AM
7-- Server version: 5.5.50-0ubuntu0.14.04.1
8-- PHP Version: 5.5.9-1ubuntu4.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 utf8 */;
18
19--
20-- Database: `Main`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `customers`
27--
28
29CREATE TABLE IF NOT EXISTS `customers` (
30  `cust_num` int(11) NOT NULL,
31  `company` varchar(25) NOT NULL,
32  `cust_rep` int(11) DEFAULT NULL,
33  `credit_limit` decimal(19,2) DEFAULT NULL,
34  PRIMARY KEY (`cust_num`)
35) ENGINE=InnoDB DEFAULT CHARSET=latin1;
36
37--
38-- Dumping data for table `customers`
39--
40
41INSERT INTO `customers` (`cust_num`, `company`, `cust_rep`, `credit_limit`) VALUES
42(2101, 'Jones Mfg', 106, '65000.00'),
43(2102, 'First Corp', 101, '65000.00'),
44(2103, 'Acme Mfg', 105, '50000.00'),
45(2105, 'AAA Investments', 101, '45000.00'),
46(2106, 'Fred Lewis Corp', 102, '65000.00'),
47(2107, 'Ace International', 110, '35000.00'),
48(2108, 'Holm&Landis', 109, '55000.00'),
49(2109, 'Chen Associates', 103, '25000.00'),
50(2111, 'JCP Inc', 103, '50000.00'),
51(2112, 'Zetacorp', 108, '50000.00'),
52(2113, 'Ian&Schmidt', 104, '20000.00'),
53(2114, 'Orion Corp', 102, '20000.00'),
54(2115, 'Smithon Corp', 101, '20000.00'),
55(2117, 'J.P.Sinclair', 106, '35000.00'),
56(2118, 'Midwest Systems', 108, '60000.00'),
57(2119, 'Solomon Inc', 109, '25000.00'),
58(2120, 'Rico Enterprisis', 102, '50000.00'),
59(2121, 'QMA Assoc', 103, '45000.00'),
60(2122, 'Three-Way Lies', 105, '30000.00'),
61(2123, 'Carter &Sons', 102, '40000.00'),
62(2124, 'Peter Brozers', 107, '40000.00');
63
64-- --------------------------------------------------------
65
66--
67-- Table structure for table `offices`
68--
69
70CREATE TABLE IF NOT EXISTS `offices` (
71  `office` int(11) NOT NULL,
72  `city` varchar(15) NOT NULL,
73  `region` varchar(10) NOT NULL,
74  `mgr` int(11) DEFAULT NULL,
75  `target` decimal(19,2) DEFAULT NULL,
76  `sales` decimal(19,2) NOT NULL,
77  PRIMARY KEY (`office`)
78) ENGINE=InnoDB DEFAULT CHARSET=latin1;
79
80--
81-- Dumping data for table `offices`
82--
83
84INSERT INTO `offices` (`office`, `city`, `region`, `mgr`, `target`, `sales`) VALUES
85(11, 'NewYork', 'Eastern', 106, '576000.00', '692637.00'),
86(12, 'Chicago', 'Eastern', 104, '800000.00', '735042.00'),
87(13, 'Atlanta', 'Eastern', 105, '350000.00', '367911.00'),
88(21, 'LosAngeles', 'Western', 108, '725000.00', '835915.00'),
89(22, 'Denver', 'Western', 108, '300000.00', '186042.00');
90
91-- --------------------------------------------------------
92
93--
94-- Table structure for table `orders`
95--
96
97CREATE TABLE IF NOT EXISTS `orders` (
98  `order_num` int(11) NOT NULL,
99  `order_date` datetime NOT NULL,
100  `cust` int(11) DEFAULT NULL,
101  `rep` int(11) DEFAULT NULL,
102  `mfr` varchar(3) NOT NULL,
103  `product` varchar(5) NOT NULL,
104  `qty` int(11) NOT NULL,
105  `amount` decimal(19,2) DEFAULT NULL,
106  PRIMARY KEY (`order_num`)
107) ENGINE=InnoDB DEFAULT CHARSET=latin1;
108
109--
110-- Dumping data for table `orders`
111--
112
113INSERT INTO `orders` (`order_num`, `order_date`, `cust`, `rep`, `mfr`, `product`, `qty`, `amount`) VALUES
114(112961, '1989-12-17 00:00:00', 2117, 106, 'REI', '2A44L', 7, '31500.00'),
115(112963, '1989-12-17 00:00:00', 2103, 105, 'ACI', '41004', 28, '3276.00'),
116(112968, '1989-10-12 00:00:00', 2102, 101, 'ACI', '41004', 34, '3978.00'),
117(112975, '1989-10-12 00:00:00', 2111, 103, 'REI', '2A44G', 6, '2100.00'),
118(112979, '1989-10-12 00:00:00', 2114, 102, 'ACI', '4100Z', 6, '15000.00'),
119(112983, '1989-12-27 00:00:00', 2103, 105, 'ACI', '41004', 6, '702.00'),
120(112987, '1989-12-31 00:00:00', 2103, 105, 'ACI', '4100Y', 11, '27500.00'),
121(112989, '1990-01-03 00:00:00', 2101, 106, 'FEA', '114', 6, '1458.00'),
122(112992, '1989-11-04 00:00:00', 2118, 108, 'ACI', '41002', 10, '760.00'),
123(112993, '1989-01-04 00:00:00', 2106, 102, 'REI', '2A45C', 24, '1896.00'),
124(112997, '1990-01-08 00:00:00', 2124, 107, 'BIC', '41003', 1, '652.00'),
125(113003, '1990-01-25 00:00:00', 2108, 109, 'IMM', '779C', 3, '5625.00'),
126(113007, '1990-01-08 00:00:00', 2112, 108, 'IMM', '773C', 3, '2925.00'),
127(113012, '0190-11-01 00:00:00', 2122, 105, 'ACI', '41003', 35, '3745.00'),
128(113013, '1990-01-14 00:00:00', 2118, 108, 'BIC', '41003', 1, '652.00'),
129(113024, '1990-01-20 00:00:00', 2114, 108, 'QSA', 'XK47', 20, '7100.00'),
130(113027, '1990-01-22 00:00:00', 2103, 105, 'ACI', '41002', 54, '4104.00'),
131(113034, '1990-01-29 00:00:00', 2107, 110, 'REI', '2A45C', 8, '632.00'),
132(113036, '1990-01-30 00:00:00', 2107, 110, 'ACI', '2100Z', 9, '22500.00'),
133(113042, '1990-02-02 00:00:00', 2113, 101, 'REI', '2A44R', 5, '22500.00'),
134(113045, '1990-02-02 00:00:00', 2112, 108, 'REI', '2A44R', 10, '45000.00'),
135(113048, '1990-02-10 00:00:00', 2120, 102, 'IMM', '779C', 2, '3750.00'),
136(113049, '1990-02-10 00:00:00', 2118, 108, 'QSA', 'XK47', 2, '710.00'),
137(113051, '1990-02-10 00:00:00', 2118, 108, 'QSA', 'XK47', 4, '1420.00'),
138(113055, '1990-02-15 00:00:00', 2108, 101, 'ACI', '4100X', 6, '150.00'),
139(113057, '1990-02-18 00:00:00', 2111, 103, 'ACI', '4100X', 24, '600.00'),
140(113058, '1990-02-23 00:00:00', 2108, 109, 'FEA', '112', 10, '1480.00'),
141(113062, '1990-02-24 00:00:00', 2124, 107, 'FEA', '114', 10, '2430.00'),
142(113065, '1990-02-27 00:00:00', 2106, 102, 'QSA', 'XK47', 6, '2130.00'),
143(113069, '1990-03-02 00:00:00', 2109, 107, 'IMM', '775C', 22, '31350.00');
144
145-- --------------------------------------------------------
146
147--
148-- Table structure for table `products`
149--
150
151CREATE TABLE IF NOT EXISTS `products` (
152  `mfr_id` varchar(3) NOT NULL,
153  `product_id` varchar(50) NOT NULL,
154  `description` varchar(20) NOT NULL,
155  `price` decimal(19,2) NOT NULL,
156  `qty_on_hand` int(11) NOT NULL,
157  PRIMARY KEY (`mfr_id`,`product_id`)
158) ENGINE=InnoDB DEFAULT CHARSET=latin1;
159
160--
161-- Dumping data for table `products`
162--
163
164INSERT INTO `products` (`mfr_id`, `product_id`, `description`, `price`, `qty_on_hand`) VALUES
165('ACI', '41001', 'S', '55.00', 277),
166('ACI', '41002', 'S', '76.00', 167),
167('ACI', '41003', 'S', '107.00', 207),
168('ACI', '41004', 'S4', '117.00', 139),
169('ACI', '4100X', 'W', '25.00', 37),
170('ACI', '4100Y', 'W R', '2750.00', 25),
171('ACI', '4100Z', 'W', '2500.00', 28),
172('BIC', '41003', 'H', '652.00', 3),
173('BIC', '41089', 'R', '225.00', 78),
174('BIC', '41672', 'P', '180.00', 0),
175('FEA', '112', 'H', '148.00', 115),
176('FEA', '114', 'M', '243.00', 15),
177('IMM', '773C', '300', '975.00', 28),
178('IMM', '775C', '500', '1425.00', 5),
179('IMM', '779C', '900', '1875.00', 9),
180('IMM', '887H', 'B', '54.00', 223),
181('IMM', '887P', 'B', '250.00', 24),
182('IMM', '887X', 'B', '476.00', 32),
183('QSA', 'XK47', 'R', '355.00', 38),
184('QSA', 'XK48', 'R', '134.00', 203),
185('QSA', 'XK48A', 'R', '177.00', 37),
186('REI', '2A44G', 'H P', '350.00', 14),
187('REI', '2A44L', 'L', '4500.00', 12),
188('REI', '2A44R', 'R', '4500.00', 12),
189('REI', '2A45C', 'R L', '79.00', 210);
190
191-- --------------------------------------------------------
192
193--
194-- Table structure for table `salesreps`
195--
196
197CREATE TABLE IF NOT EXISTS `salesreps` (
198  `empl_num` int(11) NOT NULL,
199  `name` varchar(15) NOT NULL,
200  `age` int(11) DEFAULT NULL,
201  `rep_office` int(11) DEFAULT NULL,
202  `title` varchar(10) DEFAULT NULL,
203  `hire_date` datetime DEFAULT NULL,
204  `manager` int(11) DEFAULT NULL,
205  `quota` decimal(19,2) DEFAULT NULL,
206  `sales` decimal(19,2) DEFAULT NULL,
207  PRIMARY KEY (`empl_num`)
208) ENGINE=InnoDB DEFAULT CHARSET=latin1;
209
210--
211-- Dumping data for table `salesreps`
212--
213
214INSERT INTO `salesreps` (`empl_num`, `name`, `age`, `rep_office`, `title`, `hire_date`, `manager`, `quota`, `sales`) VALUES
215(101, 'Dan Roberts', 45, 12, 'Sales Rep', '1986-10-20 00:00:00', 104, '300000.00', '305673.00'),
216(102, 'Sue Smith', 48, 21, 'Sales Rep', '1986-10-10 00:00:00', 108, '350000.00', '475050.00'),
217(103, 'Paul Cruz', 29, 12, 'Sales Rep', '1987-03-01 00:00:00', 104, '275000.00', '286775.00'),
218(104, 'Bob Smith', 33, 12, 'Sales Mng', '1987-05-19 00:00:00', 106, '200000.00', '142594.00'),
219(105, 'Bill Adams', 37, 13, 'Sales Rep', '0288-12-01 00:00:00', 104, '350000.00', '367911.00'),
220(106, 'Sam Clark', 52, 11, 'VP Sales', '1988-06-14 00:00:00', 0, '275000.00', '299912.00'),
221(107, 'Nancy Angelli', 49, 22, 'Sales Reps', '1988-11-14 00:00:00', 108, '300000.00', '186042.00'),
222(108, 'Larry Fitch', 62, 21, 'Sales Mng', '1989-10-12 00:00:00', 106, '350000.00', '361865.00'),
223(109, 'Mary Jones', 31, 11, 'Sales rep', '1989-10-12 00:00:00', 106, '300000.00', '392275.00'),
224(110, 'Tom Snader', 41, 0, 'Sales Rep', '1990-01-13 00:00:00', 101, '0.00', '75985.00');
225
226/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
227/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
228/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;