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