· 5 years ago · Feb 04, 2020, 05:02 PM
1-- phpMyAdmin SQL Dump
2-- version 3.3.9
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Feb 08, 2014 at 06:53 AM
7-- Server version: 5.1.36
8-- PHP Version: 5.3.0
9
10CREATE DATABASE ourWebshop;
11USE ourWebshop;
12
13SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
14
15--
16-- Database: `sample`
17--
18
19-- --------------------------------------------------------
20
21--
22-- Table structure for table `agents`
23--
24
25CREATE TABLE IF NOT EXISTS `agents` (
26 `AGENT_CODE` varchar(6) NOT NULL DEFAULT '',
27 `AGENT_NAME` varchar(40) DEFAULT NULL,
28 `WORKING_AREA` varchar(35) DEFAULT NULL,
29 `COMMISSION` decimal(10,2) DEFAULT NULL,
30 `PHONE_NO` varchar(15) DEFAULT NULL,
31 `COUNTRY` varchar(25) DEFAULT NULL,
32 PRIMARY KEY (`AGENT_CODE`)
33) ENGINE=MyISAM DEFAULT CHARSET=latin1;
34
35--
36-- Dumping data for table `agents`
37--
38
39INSERT INTO `agents` (`AGENT_CODE`, `AGENT_NAME`, `WORKING_AREA`, `COMMISSION`, `PHONE_NO`, `COUNTRY`) VALUES
40('A007 ', 'Ramasundar ', 'Bangalore ', '0.15', '077-25814763 ', '\r'),
41('A003 ', 'Alex ', 'London ', '0.13', '075-12458969 ', '\r'),
42('A008 ', 'Alford ', 'New York ', '0.12', '044-25874365 ', '\r'),
43('A011 ', 'Ravi Kumar ', 'Bangalore ', '0.15', '077-45625874 ', '\r'),
44('A010 ', 'Santakumar ', 'Chennai ', '0.14', '007-22388644 ', '\r'),
45('A012 ', 'Lucida ', 'San Jose ', '0.12', '044-52981425 ', '\r'),
46('A005 ', 'Anderson ', 'Brisban ', '0.13', '045-21447739 ', '\r'),
47('A001 ', 'Subbarao ', 'Bangalore ', '0.14', '077-12346674 ', '\r'),
48('A002 ', 'Mukesh ', 'Mumbai ', '0.11', '029-12358964 ', '\r'),
49('A006 ', 'McDen ', 'London ', '0.15', '078-22255588 ', '\r'),
50('A004 ', 'Ivan ', 'Torento ', '0.15', '008-22544166 ', '\r'),
51('A009 ', 'Benjamin ', 'Hampshair ', '0.11', '008-22536178 ', '\r');
52
53-- --------------------------------------------------------
54
55--
56-- Table structure for table `company`
57--
58
59CREATE TABLE IF NOT EXISTS `company` (
60 `COMPANY_ID` varchar(6) NOT NULL DEFAULT '',
61 `COMPANY_NAME` varchar(25) DEFAULT NULL,
62 `COMPANY_CITY` varchar(25) DEFAULT NULL,
63 PRIMARY KEY (`COMPANY_ID`)
64) ENGINE=MyISAM DEFAULT CHARSET=latin1;
65
66--
67-- Dumping data for table `company`
68--
69
70INSERT INTO `company` (`COMPANY_ID`, `COMPANY_NAME`, `COMPANY_CITY`) VALUES
71('18', 'Order All', 'Boston\r'),
72('15', 'Jack Hill Ltd', 'London\r'),
73('16', 'Akas Foods', 'Delhi\r'),
74('17', 'Foodies.', 'London\r'),
75('19', 'sip-n-Bite.', 'New York\r');
76
77-- --------------------------------------------------------
78
79--
80-- Table structure for table `customer`
81--
82
83CREATE TABLE IF NOT EXISTS `customer` (
84 `CUST_CODE` varchar(6) NOT NULL,
85 `CUST_NAME` varchar(40) NOT NULL,
86 `CUST_CITY` varchar(35) DEFAULT NULL,
87 `WORKING_AREA` varchar(35) NOT NULL,
88 `CUST_COUNTRY` varchar(20) NOT NULL,
89 `GRADE` decimal(10,0) DEFAULT NULL,
90 `OPENING_AMT` decimal(12,2) NOT NULL,
91 `RECEIVE_AMT` decimal(12,2) NOT NULL,
92 `PAYMENT_AMT` decimal(12,2) NOT NULL,
93 `OUTSTANDING_AMT` decimal(12,2) NOT NULL,
94 `PHONE_NO` varchar(17) NOT NULL,
95 `AGENT_CODE` varchar(6) DEFAULT NULL,
96 KEY `CUSTCITY` (`CUST_CITY`),
97 KEY `CUSTCITY_COUNTRY` (`CUST_CITY`,`CUST_COUNTRY`)
98) ENGINE=MyISAM DEFAULT CHARSET=latin1;
99
100--
101-- Dumping data for table `customer`
102--
103
104INSERT INTO `customer` (`CUST_CODE`, `CUST_NAME`, `CUST_CITY`, `WORKING_AREA`, `CUST_COUNTRY`, `GRADE`, `OPENING_AMT`, `RECEIVE_AMT`, `PAYMENT_AMT`, `OUTSTANDING_AMT`, `PHONE_NO`, `AGENT_CODE`) VALUES
105('C00013', 'Holmes', 'London ', 'London', 'UK', '2', '6000.00', '5000.00', '7000.00', '4000.00', 'BBBBBBB', 'A003 '),
106('C00001', 'Micheal', 'New York ', 'New York', 'USA', '2', '3000.00', '5000.00', '2000.00', '6000.00', 'CCCCCCC', 'A008 '),
107('C00020', 'Albert', 'New York ', 'New York', 'USA', '3', '5000.00', '7000.00', '6000.00', '6000.00', 'BBBBSBB', 'A008 '),
108('C00025', 'Ravindran', 'Bangalore ', 'Bangalore', 'India', '2', '5000.00', '7000.00', '4000.00', '8000.00', 'AVAVAVA', 'A011 '),
109('C00024', 'Cook', 'London ', 'London', 'UK', '2', '4000.00', '9000.00', '7000.00', '6000.00', 'FSDDSDF', 'A006 '),
110('C00015', 'Stuart', 'London ', 'London', 'UK', '1', '6000.00', '8000.00', '3000.00', '11000.00', 'GFSGERS', 'A003 '),
111('C00002', 'Bolt', 'New York ', 'New York', 'USA', '3', '5000.00', '7000.00', '9000.00', '3000.00', 'DDNRDRH', 'A008 '),
112('C00018', 'Fleming', 'Brisban ', 'Brisban', 'Australia', '2', '7000.00', '7000.00', '9000.00', '5000.00', 'NHBGVFC', 'A005 '),
113('C00021', 'Jacks', 'Brisban ', 'Brisban', 'Australia', '1', '7000.00', '7000.00', '7000.00', '7000.00', 'WERTGDF', 'A005 '),
114('C00019', 'Yearannaidu', 'Chennai ', 'Chennai', 'India', '1', '8000.00', '7000.00', '7000.00', '8000.00', 'ZZZZBFV', 'A010 '),
115('C00005', 'Sasikant', 'Mumbai ', 'Mumbai', 'India', '1', '7000.00', '11000.00', '7000.00', '11000.00', '147-25896312', 'A002 '),
116('C00007', 'Ramanathan', 'Chennai ', 'Chennai', 'India', '1', '7000.00', '11000.00', '9000.00', '9000.00', 'GHRDWSD', 'A010 '),
117('C00022', 'Avinash', 'Mumbai ', 'Mumbai', 'India', '2', '7000.00', '11000.00', '9000.00', '9000.00', '113-12345678', 'A002 '),
118('C00004', 'Winston', 'Brisban ', 'Brisban', 'Australia', '1', '5000.00', '8000.00', '7000.00', '6000.00', 'AAAAAAA', 'A005 '),
119('C00023', 'Karl', 'London ', 'London', 'UK', '0', '4000.00', '6000.00', '7000.00', '3000.00', 'AAAABAA', 'A006 '),
120('C00006', 'Shilton', 'Torento ', 'Torento', 'Canada', '1', '10000.00', '7000.00', '6000.00', '11000.00', 'DDDDDDD', 'A004 '),
121('C00010', 'Charles', 'Hampshair ', 'Hampshair', 'UK', '3', '6000.00', '4000.00', '5000.00', '5000.00', 'MMMMMMM', 'A009 '),
122('C00017', 'Srinivas', 'Bangalore ', 'Bangalore', 'India', '2', '8000.00', '4000.00', '3000.00', '9000.00', 'AAAAAAB', 'A007 '),
123('C00012', 'Steven', 'San Jose ', 'San Jose', 'USA', '1', '5000.00', '7000.00', '9000.00', '3000.00', 'KRFYGJK', 'A012 '),
124('C00008', 'Karolina', 'Torento ', 'Torento', 'Canada', '1', '7000.00', '7000.00', '9000.00', '5000.00', 'HJKORED', 'A004 '),
125('C00003', 'Martin', 'Torento ', 'Torento', 'Canada', '2', '8000.00', '7000.00', '7000.00', '8000.00', 'MJYURFD', 'A004 '),
126('C00009', 'Ramesh', 'Mumbai ', 'Mumbai', 'India', '3', '8000.00', '7000.00', '3000.00', '12000.00', 'Phone No', 'A002 '),
127('C00014', 'Rangarappa', 'Bangalore ', 'Bangalore', 'India', '2', '8000.00', '11000.00', '7000.00', '12000.00', 'AAAATGF', 'A001 '),
128('C00016', 'Venkatpati', 'Bangalore ', 'Bangalore', 'India', '2', '8000.00', '11000.00', '7000.00', '12000.00', 'JRTVFDD', 'A007 '),
129('C00011', 'Sundariya', 'Chennai ', 'Chennai', 'India', '3', '7000.00', '11000.00', '7000.00', '11000.00', 'PPHGRTS', 'A010 ');
130
131-- --------------------------------------------------------
132
133--
134-- Table structure for table `daysorder`
135--
136
137CREATE TABLE IF NOT EXISTS `daysorder` (
138 `ORD_NUM` decimal(6,0) NOT NULL,
139 `ORD_AMOUNT` decimal(12,2) NOT NULL,
140 `ADVANCE_AMOUNT` decimal(12,2) NOT NULL,
141 `ORD_DATE` date NOT NULL,
142 `CUST_CODE` varchar(6) NOT NULL,
143 `AGENT_CODE` varchar(6) NOT NULL,
144 `ORD_DESCRIPTION` varchar(60) NOT NULL
145) ENGINE=MyISAM DEFAULT CHARSET=latin1;
146
147--
148-- Dumping data for table `daysorder`
149--
150
151INSERT INTO `daysorder` (`ORD_NUM`, `ORD_AMOUNT`, `ADVANCE_AMOUNT`, `ORD_DATE`, `CUST_CODE`, `AGENT_CODE`, `ORD_DESCRIPTION`) VALUES
152('200107', '4500.00', '900.00', '2008-08-30', 'C00007', 'A010', 'SOD\r'),
153('200114', '3500.00', '1500.00', '2008-08-15', 'C00002', 'A008', 'SOD\r'),
154('200134', '4200.00', '1800.00', '2008-09-25', 'C00004', 'A005', 'SOD\r'),
155('200115', '2000.00', '1200.00', '2008-02-08', 'C00013', 'A013', 'SOD\r'),
156('200101', '3000.00', '1000.00', '2008-07-15', 'C00001', 'A008', 'SOD\r'),
157('200128', '3500.00', '1500.00', '2008-07-20', 'C00009', 'A002', 'SOD\r'),
158('200132', '4000.00', '1500.00', '2008-08-15', 'C00013', 'A013', 'SOD\r');
159
160-- --------------------------------------------------------
161
162--
163-- Table structure for table `despatch`
164--
165
166CREATE TABLE IF NOT EXISTS `despatch` (
167 `DES_NUM` varchar(6) NOT NULL DEFAULT '',
168 `DES_DATE` date DEFAULT NULL,
169 `DES_AMOUNT` decimal(12,2) DEFAULT NULL,
170 `ORD_NUM` decimal(6,0) DEFAULT NULL,
171 `ORD_DATE` date DEFAULT NULL,
172 `ORD_AMOUNT` decimal(12,2) DEFAULT NULL,
173 `AGENT_CODE` varchar(6) DEFAULT NULL,
174 PRIMARY KEY (`DES_NUM`)
175) ENGINE=MyISAM DEFAULT CHARSET=latin1;
176
177--
178-- Dumping data for table `despatch`
179--
180
181
182-- --------------------------------------------------------
183
184--
185-- Table structure for table `foods`
186--
187
188CREATE TABLE IF NOT EXISTS `foods` (
189 `ITEM_ID` varchar(6) NOT NULL DEFAULT '',
190 `ITEM_NAME` varchar(25) DEFAULT NULL,
191 `ITEM_UNIT` varchar(5) DEFAULT NULL,
192 `COMPANY_ID` varchar(6) DEFAULT NULL,
193 PRIMARY KEY (`ITEM_ID`)
194) ENGINE=MyISAM DEFAULT CHARSET=latin1;
195
196--
197-- Dumping data for table `foods`
198--
199
200INSERT INTO `foods` (`ITEM_ID`, `ITEM_NAME`, `ITEM_UNIT`, `COMPANY_ID`) VALUES
201('1', 'Chex Mix', 'Pcs', '16\r'),
202('6', 'Cheez-It', 'Pcs', '15\r'),
203('2', 'BN Biscuit', 'Pcs', '15\r'),
204('3', 'Mighty Munch', 'Pcs', '17\r'),
205('4', 'Pot Rice', 'Pcs', '15\r'),
206('5', 'Jaffa Cakes', 'Pcs', '18\r'),
207('7', 'Salt n Shake', 'Pcs', '\r');
208
209-- --------------------------------------------------------
210
211--
212-- Table structure for table `listofitem`
213--
214
215CREATE TABLE IF NOT EXISTS `listofitem` (
216 `ITEMCODE` varchar(6) NOT NULL,
217 `ITEMNAME` varchar(25) NOT NULL,
218 `BATCHCODE` varchar(35) NOT NULL,
219 `CONAME` varchar(35) DEFAULT NULL,
220 UNIQUE KEY `ITEMCODE` (`ITEMCODE`)
221) ENGINE=MyISAM DEFAULT CHARSET=latin1;
222
223--
224-- Dumping data for table `listofitem`
225--
226
227INSERT INTO `listofitem` (`ITEMCODE`, `ITEMNAME`, `BATCHCODE`, `CONAME`) VALUES
228('I001 ', 'CHOCOLATE ', 'DM/2007-08/WBM%1 ', '\r'),
229('I003 ', 'HOT DOG ', 'DM/2007-08/WB1 ', 'ABJ ENTERPRISE '),
230('I002 ', 'CONDENSED MILK ', 'DM/2007-08/WBM%2 ', 'ABJ CONCERN ');
231
232-- --------------------------------------------------------
233
234--
235-- Table structure for table `orders`
236--
237
238CREATE TABLE IF NOT EXISTS `orders` (
239 `ORD_NUM` decimal(6,0) NOT NULL,
240 `ORD_AMOUNT` decimal(12,2) NOT NULL,
241 `ADVANCE_AMOUNT` decimal(12,2) NOT NULL,
242 `ORD_DATE` date NOT NULL,
243 `CUST_CODE` varchar(6) NOT NULL,
244 `AGENT_CODE` varchar(6) NOT NULL,
245 `ORD_DESCRIPTION` varchar(60) NOT NULL
246) ENGINE=MyISAM DEFAULT CHARSET=latin1;
247
248--
249-- Dumping data for table `orders`
250--
251
252INSERT INTO `orders` (`ORD_NUM`, `ORD_AMOUNT`, `ADVANCE_AMOUNT`, `ORD_DATE`, `CUST_CODE`, `AGENT_CODE`, `ORD_DESCRIPTION`) VALUES
253('200100', '1000.00', '600.00', '2008-01-08', 'C00015', 'A003 ', 'SOD\r'),
254('200110', '3000.00', '500.00', '2008-04-15', 'C00019', 'A010 ', 'SOD\r'),
255('200107', '4500.00', '900.00', '2008-08-30', 'C00007', 'A010 ', 'SOD\r'),
256('200112', '2000.00', '400.00', '2008-05-30', 'C00016', 'A007 ', 'SOD\r'),
257('200113', '4000.00', '600.00', '2008-06-10', 'C00022', 'A002 ', 'SOD\r'),
258('200102', '2000.00', '300.00', '2008-05-25', 'C00012', 'A012 ', 'SOD\r'),
259('200114', '3500.00', '2000.00', '2008-08-15', 'C00002', 'A008 ', 'SOD\r'),
260('200122', '2500.00', '400.00', '2008-09-16', 'C00003', 'A004 ', 'SOD\r'),
261('200118', '500.00', '100.00', '2008-07-20', 'C00023', 'A006 ', 'SOD\r'),
262('200119', '4000.00', '700.00', '2008-09-16', 'C00007', 'A010 ', 'SOD\r'),
263('200121', '1500.00', '600.00', '2008-09-23', 'C00008', 'A004 ', 'SOD\r'),
264('200130', '2500.00', '400.00', '2008-07-30', 'C00025', 'A011 ', 'SOD\r'),
265('200134', '4200.00', '1800.00', '2008-09-25', 'C00004', 'A005 ', 'SOD\r'),
266('200115', '2000.00', '1200.00', '2008-02-08', 'C00013', 'A013 ', 'SOD\r'),
267('200108', '4000.00', '600.00', '2008-02-15', 'C00008', 'A004 ', 'SOD\r'),
268('200103', '1500.00', '700.00', '2008-05-15', 'C00021', 'A005 ', 'SOD\r'),
269('200105', '2500.00', '500.00', '2008-07-18', 'C00025', 'A011 ', 'SOD\r'),
270('200109', '3500.00', '800.00', '2008-07-30', 'C00011', 'A010 ', 'SOD\r'),
271('200101', '3000.00', '1000.00', '2008-07-15', 'C00001', 'A008 ', 'SOD\r'),
272('200111', '1000.00', '300.00', '2008-07-10', 'C00020', 'A008 ', 'SOD\r'),
273('200104', '1500.00', '500.00', '2008-03-13', 'C00006', 'A004 ', 'SOD\r'),
274('200106', '2500.00', '700.00', '2008-04-20', 'C00005', 'A002 ', 'SOD\r'),
275('200125', '2000.00', '600.00', '2008-10-10', 'C00018', 'A005 ', 'SOD\r'),
276('200117', '800.00', '200.00', '2008-10-20', 'C00014', 'A001 ', 'SOD\r'),
277('200123', '500.00', '100.00', '2008-09-16', 'C00022', 'A002 ', 'SOD\r'),
278('200120', '500.00', '100.00', '2008-07-20', 'C00009', 'A002 ', 'SOD\r'),
279('200116', '500.00', '100.00', '2008-07-13', 'C00010', 'A009 ', 'SOD\r'),
280('200124', '500.00', '100.00', '2008-06-20', 'C00017', 'A007 ', 'SOD\r'),
281('200126', '500.00', '100.00', '2008-06-24', 'C00022', 'A002 ', 'SOD\r'),
282('200129', '2500.00', '500.00', '2008-07-20', 'C00024', 'A006 ', 'SOD\r'),
283('200127', '2500.00', '400.00', '2008-07-20', 'C00015', 'A003 ', 'SOD\r'),
284('200128', '3500.00', '1500.00', '2008-07-20', 'C00009', 'A002 ', 'SOD\r'),
285('200135', '2000.00', '800.00', '2008-09-16', 'C00007', 'A010 ', 'SOD\r'),
286('200131', '900.00', '150.00', '2008-08-26', 'C00012', 'A012 ', 'SOD\r'),
287('200133', '1200.00', '400.00', '2008-06-29', 'C00009', 'A002 ', 'SOD\r'),
288('200132', '4000.00', '2000.00', '2008-08-15', 'C00013', 'A013 ', 'SOD\r');
289
290-- --------------------------------------------------------
291
292--
293-- Table structure for table `student`
294--
295
296CREATE TABLE IF NOT EXISTS `student` (
297 `NAME` varchar(30) NOT NULL,
298 `TITLE` varchar(25) NOT NULL,
299 `CLASS` varchar(5) NOT NULL,
300 `SECTION` varchar(1) NOT NULL,
301 `ROLLID` decimal(3,0) NOT NULL,
302 PRIMARY KEY (`CLASS`,`SECTION`,`ROLLID`)
303) ENGINE=MyISAM DEFAULT CHARSET=latin1;
304
305--
306-- Dumping data for table `student`
307--
308
309INSERT INTO `student` (`NAME`, `TITLE`, `CLASS`, `SECTION`, `ROLLID`) VALUES
310('Deepak ', 'Saxana ', 'V ', 'A', '15'),
311('Robert ', 'Paul ', 'VI ', 'A', '2'),
312('Danny ', 'Moris ', 'V ', 'B', '15');
313
314-- --------------------------------------------------------
315
316--
317-- Table structure for table `studentreport`
318--
319
320CREATE TABLE IF NOT EXISTS `studentreport` (
321 `CLASS` varchar(5) NOT NULL,
322 `SECTION` varchar(1) NOT NULL,
323 `ROLLID` decimal(3,0) NOT NULL,
324 `GRADE` varchar(5) NOT NULL,
325 `SEMISTER` varchar(5) DEFAULT NULL,
326 `CLASS_ATTENDED` decimal(25,0) DEFAULT NULL,
327 KEY `FK_CSR` (`CLASS`,`SECTION`,`ROLLID`)
328) ENGINE=MyISAM DEFAULT CHARSET=latin1;
329
330--
331-- Dumping data for table `studentreport`
332--
333
334INSERT INTO `studentreport` (`CLASS`, `SECTION`, `ROLLID`, `GRADE`, `SEMISTER`, `CLASS_ATTENDED`) VALUES
335('V ', 'A', '15', 'A++ ', '1St ', '75'),
336('VI ', 'A', '2', 'A+ ', '2Nd ', '70'),
337('V ', 'B', '15', 'AA ', '1St ', '85'),
338('VI ', 'A', '2', 'A+ ', '1St ', '70'),
339('V ', 'A', '15', 'AA ', '2Nd ', '85');