-- phpMyAdmin SQL Dump -- version 3.3.9 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Feb 08, 2014 at 06:53 AM -- Server version: 5.1.36 -- PHP Version: 5.3.0 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- Database: `sample` -- -- -------------------------------------------------------- -- -- Table structure for table `agents` -- CREATE TABLE IF NOT EXISTS `agents` ( `AGENT_CODE` varchar(6) NOT NULL DEFAULT '', `AGENT_NAME` varchar(40) DEFAULT NULL, `WORKING_AREA` varchar(35) DEFAULT NULL, `COMMISSION` decimal(10,2) DEFAULT NULL, `PHONE_NO` varchar(15) DEFAULT NULL, `COUNTRY` varchar(25) DEFAULT NULL, PRIMARY KEY (`AGENT_CODE`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `agents` -- INSERT INTO `agents` (`AGENT_CODE`, `AGENT_NAME`, `WORKING_AREA`, `COMMISSION`, `PHONE_NO`, `COUNTRY`) VALUES ('A007 ', 'Ramasundar ', 'Bangalore ', '0.15', '077-25814763 ', '\r'), ('A003 ', 'Alex ', 'London ', '0.13', '075-12458969 ', '\r'), ('A008 ', 'Alford ', 'New York ', '0.12', '044-25874365 ', '\r'), ('A011 ', 'Ravi Kumar ', 'Bangalore ', '0.15', '077-45625874 ', '\r'), ('A010 ', 'Santakumar ', 'Chennai ', '0.14', '007-22388644 ', '\r'), ('A012 ', 'Lucida ', 'San Jose ', '0.12', '044-52981425 ', '\r'), ('A005 ', 'Anderson ', 'Brisban ', '0.13', '045-21447739 ', '\r'), ('A001 ', 'Subbarao ', 'Bangalore ', '0.14', '077-12346674 ', '\r'), ('A002 ', 'Mukesh ', 'Mumbai ', '0.11', '029-12358964 ', '\r'), ('A006 ', 'McDen ', 'London ', '0.15', '078-22255588 ', '\r'), ('A004 ', 'Ivan ', 'Torento ', '0.15', '008-22544166 ', '\r'), ('A009 ', 'Benjamin ', 'Hampshair ', '0.11', '008-22536178 ', '\r'); -- -------------------------------------------------------- -- -- Table structure for table `company` -- CREATE TABLE IF NOT EXISTS `company` ( `COMPANY_ID` varchar(6) NOT NULL DEFAULT '', `COMPANY_NAME` varchar(25) DEFAULT NULL, `COMPANY_CITY` varchar(25) DEFAULT NULL, PRIMARY KEY (`COMPANY_ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `company` -- INSERT INTO `company` (`COMPANY_ID`, `COMPANY_NAME`, `COMPANY_CITY`) VALUES ('18', 'Order All', 'Boston\r'), ('15', 'Jack Hill Ltd', 'London\r'), ('16', 'Akas Foods', 'Delhi\r'), ('17', 'Foodies.', 'London\r'), ('19', 'sip-n-Bite.', 'New York\r'); -- -------------------------------------------------------- -- -- Table structure for table `customer` -- CREATE TABLE IF NOT EXISTS `customer` ( `CUST_CODE` varchar(6) NOT NULL, `CUST_NAME` varchar(40) NOT NULL, `CUST_CITY` varchar(35) DEFAULT NULL, `WORKING_AREA` varchar(35) NOT NULL, `CUST_COUNTRY` varchar(20) NOT NULL, `GRADE` decimal(10,0) DEFAULT NULL, `OPENING_AMT` decimal(12,2) NOT NULL, `RECEIVE_AMT` decimal(12,2) NOT NULL, `PAYMENT_AMT` decimal(12,2) NOT NULL, `OUTSTANDING_AMT` decimal(12,2) NOT NULL, `PHONE_NO` varchar(17) NOT NULL, `AGENT_CODE` varchar(6) DEFAULT NULL, KEY `CUSTCITY` (`CUST_CITY`), KEY `CUSTCITY_COUNTRY` (`CUST_CITY`,`CUST_COUNTRY`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `customer` -- INSERT 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 ('C00013', 'Holmes', 'London ', 'London', 'UK', '2', '6000.00', '5000.00', '7000.00', '4000.00', 'BBBBBBB', 'A003 '), ('C00001', 'Micheal', 'New York ', 'New York', 'USA', '2', '3000.00', '5000.00', '2000.00', '6000.00', 'CCCCCCC', 'A008 '), ('C00020', 'Albert', 'New York ', 'New York', 'USA', '3', '5000.00', '7000.00', '6000.00', '6000.00', 'BBBBSBB', 'A008 '), ('C00025', 'Ravindran', 'Bangalore ', 'Bangalore', 'India', '2', '5000.00', '7000.00', '4000.00', '8000.00', 'AVAVAVA', 'A011 '), ('C00024', 'Cook', 'London ', 'London', 'UK', '2', '4000.00', '9000.00', '7000.00', '6000.00', 'FSDDSDF', 'A006 '), ('C00015', 'Stuart', 'London ', 'London', 'UK', '1', '6000.00', '8000.00', '3000.00', '11000.00', 'GFSGERS', 'A003 '), ('C00002', 'Bolt', 'New York ', 'New York', 'USA', '3', '5000.00', '7000.00', '9000.00', '3000.00', 'DDNRDRH', 'A008 '), ('C00018', 'Fleming', 'Brisban ', 'Brisban', 'Australia', '2', '7000.00', '7000.00', '9000.00', '5000.00', 'NHBGVFC', 'A005 '), ('C00021', 'Jacks', 'Brisban ', 'Brisban', 'Australia', '1', '7000.00', '7000.00', '7000.00', '7000.00', 'WERTGDF', 'A005 '), ('C00019', 'Yearannaidu', 'Chennai ', 'Chennai', 'India', '1', '8000.00', '7000.00', '7000.00', '8000.00', 'ZZZZBFV', 'A010 '), ('C00005', 'Sasikant', 'Mumbai ', 'Mumbai', 'India', '1', '7000.00', '11000.00', '7000.00', '11000.00', '147-25896312', 'A002 '), ('C00007', 'Ramanathan', 'Chennai ', 'Chennai', 'India', '1', '7000.00', '11000.00', '9000.00', '9000.00', 'GHRDWSD', 'A010 '), ('C00022', 'Avinash', 'Mumbai ', 'Mumbai', 'India', '2', '7000.00', '11000.00', '9000.00', '9000.00', '113-12345678', 'A002 '), ('C00004', 'Winston', 'Brisban ', 'Brisban', 'Australia', '1', '5000.00', '8000.00', '7000.00', '6000.00', 'AAAAAAA', 'A005 '), ('C00023', 'Karl', 'London ', 'London', 'UK', '0', '4000.00', '6000.00', '7000.00', '3000.00', 'AAAABAA', 'A006 '), ('C00006', 'Shilton', 'Torento ', 'Torento', 'Canada', '1', '10000.00', '7000.00', '6000.00', '11000.00', 'DDDDDDD', 'A004 '), ('C00010', 'Charles', 'Hampshair ', 'Hampshair', 'UK', '3', '6000.00', '4000.00', '5000.00', '5000.00', 'MMMMMMM', 'A009 '), ('C00017', 'Srinivas', 'Bangalore ', 'Bangalore', 'India', '2', '8000.00', '4000.00', '3000.00', '9000.00', 'AAAAAAB', 'A007 '), ('C00012', 'Steven', 'San Jose ', 'San Jose', 'USA', '1', '5000.00', '7000.00', '9000.00', '3000.00', 'KRFYGJK', 'A012 '), ('C00008', 'Karolina', 'Torento ', 'Torento', 'Canada', '1', '7000.00', '7000.00', '9000.00', '5000.00', 'HJKORED', 'A004 '), ('C00003', 'Martin', 'Torento ', 'Torento', 'Canada', '2', '8000.00', '7000.00', '7000.00', '8000.00', 'MJYURFD', 'A004 '), ('C00009', 'Ramesh', 'Mumbai ', 'Mumbai', 'India', '3', '8000.00', '7000.00', '3000.00', '12000.00', 'Phone No', 'A002 '), ('C00014', 'Rangarappa', 'Bangalore ', 'Bangalore', 'India', '2', '8000.00', '11000.00', '7000.00', '12000.00', 'AAAATGF', 'A001 '), ('C00016', 'Venkatpati', 'Bangalore ', 'Bangalore', 'India', '2', '8000.00', '11000.00', '7000.00', '12000.00', 'JRTVFDD', 'A007 '), ('C00011', 'Sundariya', 'Chennai ', 'Chennai', 'India', '3', '7000.00', '11000.00', '7000.00', '11000.00', 'PPHGRTS', 'A010 '); -- -------------------------------------------------------- -- -- Table structure for table `daysorder` -- CREATE TABLE IF NOT EXISTS `daysorder` ( `ORD_NUM` decimal(6,0) NOT NULL, `ORD_AMOUNT` decimal(12,2) NOT NULL, `ADVANCE_AMOUNT` decimal(12,2) NOT NULL, `ORD_DATE` date NOT NULL, `CUST_CODE` varchar(6) NOT NULL, `AGENT_CODE` varchar(6) NOT NULL, `ORD_DESCRIPTION` varchar(60) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `daysorder` -- INSERT INTO `daysorder` (`ORD_NUM`, `ORD_AMOUNT`, `ADVANCE_AMOUNT`, `ORD_DATE`, `CUST_CODE`, `AGENT_CODE`, `ORD_DESCRIPTION`) VALUES ('200107', '4500.00', '900.00', '2008-08-30', 'C00007', 'A010', 'SOD\r'), ('200114', '3500.00', '1500.00', '2008-08-15', 'C00002', 'A008', 'SOD\r'), ('200134', '4200.00', '1800.00', '2008-09-25', 'C00004', 'A005', 'SOD\r'), ('200115', '2000.00', '1200.00', '2008-02-08', 'C00013', 'A013', 'SOD\r'), ('200101', '3000.00', '1000.00', '2008-07-15', 'C00001', 'A008', 'SOD\r'), ('200128', '3500.00', '1500.00', '2008-07-20', 'C00009', 'A002', 'SOD\r'), ('200132', '4000.00', '1500.00', '2008-08-15', 'C00013', 'A013', 'SOD\r'); -- -------------------------------------------------------- -- -- Table structure for table `despatch` -- CREATE TABLE IF NOT EXISTS `despatch` ( `DES_NUM` varchar(6) NOT NULL DEFAULT '', `DES_DATE` date DEFAULT NULL, `DES_AMOUNT` decimal(12,2) DEFAULT NULL, `ORD_NUM` decimal(6,0) DEFAULT NULL, `ORD_DATE` date DEFAULT NULL, `ORD_AMOUNT` decimal(12,2) DEFAULT NULL, `AGENT_CODE` varchar(6) DEFAULT NULL, PRIMARY KEY (`DES_NUM`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `despatch` -- -- -------------------------------------------------------- -- -- Table structure for table `foods` -- CREATE TABLE IF NOT EXISTS `foods` ( `ITEM_ID` varchar(6) NOT NULL DEFAULT '', `ITEM_NAME` varchar(25) DEFAULT NULL, `ITEM_UNIT` varchar(5) DEFAULT NULL, `COMPANY_ID` varchar(6) DEFAULT NULL, PRIMARY KEY (`ITEM_ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `foods` -- INSERT INTO `foods` (`ITEM_ID`, `ITEM_NAME`, `ITEM_UNIT`, `COMPANY_ID`) VALUES ('1', 'Chex Mix', 'Pcs', '16\r'), ('6', 'Cheez-It', 'Pcs', '15\r'), ('2', 'BN Biscuit', 'Pcs', '15\r'), ('3', 'Mighty Munch', 'Pcs', '17\r'), ('4', 'Pot Rice', 'Pcs', '15\r'), ('5', 'Jaffa Cakes', 'Pcs', '18\r'), ('7', 'Salt n Shake', 'Pcs', '\r'); -- -------------------------------------------------------- -- -- Table structure for table `listofitem` -- CREATE TABLE IF NOT EXISTS `listofitem` ( `ITEMCODE` varchar(6) NOT NULL, `ITEMNAME` varchar(25) NOT NULL, `BATCHCODE` varchar(35) NOT NULL, `CONAME` varchar(35) DEFAULT NULL, UNIQUE KEY `ITEMCODE` (`ITEMCODE`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `listofitem` -- INSERT INTO `listofitem` (`ITEMCODE`, `ITEMNAME`, `BATCHCODE`, `CONAME`) VALUES ('I001 ', 'CHOCOLATE ', 'DM/2007-08/WBM%1 ', '\r'), ('I003 ', 'HOT DOG ', 'DM/2007-08/WB1 ', 'ABJ ENTERPRISE '), ('I002 ', 'CONDENSED MILK ', 'DM/2007-08/WBM%2 ', 'ABJ CONCERN '); -- -------------------------------------------------------- -- -- Table structure for table `orders` -- CREATE TABLE IF NOT EXISTS `orders` ( `ORD_NUM` decimal(6,0) NOT NULL, `ORD_AMOUNT` decimal(12,2) NOT NULL, `ADVANCE_AMOUNT` decimal(12,2) NOT NULL, `ORD_DATE` date NOT NULL, `CUST_CODE` varchar(6) NOT NULL, `AGENT_CODE` varchar(6) NOT NULL, `ORD_DESCRIPTION` varchar(60) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `orders` -- INSERT INTO `orders` (`ORD_NUM`, `ORD_AMOUNT`, `ADVANCE_AMOUNT`, `ORD_DATE`, `CUST_CODE`, `AGENT_CODE`, `ORD_DESCRIPTION`) VALUES ('200100', '1000.00', '600.00', '2008-01-08', 'C00015', 'A003 ', 'SOD\r'), ('200110', '3000.00', '500.00', '2008-04-15', 'C00019', 'A010 ', 'SOD\r'), ('200107', '4500.00', '900.00', '2008-08-30', 'C00007', 'A010 ', 'SOD\r'), ('200112', '2000.00', '400.00', '2008-05-30', 'C00016', 'A007 ', 'SOD\r'), ('200113', '4000.00', '600.00', '2008-06-10', 'C00022', 'A002 ', 'SOD\r'), ('200102', '2000.00', '300.00', '2008-05-25', 'C00012', 'A012 ', 'SOD\r'), ('200114', '3500.00', '2000.00', '2008-08-15', 'C00002', 'A008 ', 'SOD\r'), ('200122', '2500.00', '400.00', '2008-09-16', 'C00003', 'A004 ', 'SOD\r'), ('200118', '500.00', '100.00', '2008-07-20', 'C00023', 'A006 ', 'SOD\r'), ('200119', '4000.00', '700.00', '2008-09-16', 'C00007', 'A010 ', 'SOD\r'), ('200121', '1500.00', '600.00', '2008-09-23', 'C00008', 'A004 ', 'SOD\r'), ('200130', '2500.00', '400.00', '2008-07-30', 'C00025', 'A011 ', 'SOD\r'), ('200134', '4200.00', '1800.00', '2008-09-25', 'C00004', 'A005 ', 'SOD\r'), ('200115', '2000.00', '1200.00', '2008-02-08', 'C00013', 'A013 ', 'SOD\r'), ('200108', '4000.00', '600.00', '2008-02-15', 'C00008', 'A004 ', 'SOD\r'), ('200103', '1500.00', '700.00', '2008-05-15', 'C00021', 'A005 ', 'SOD\r'), ('200105', '2500.00', '500.00', '2008-07-18', 'C00025', 'A011 ', 'SOD\r'), ('200109', '3500.00', '800.00', '2008-07-30', 'C00011', 'A010 ', 'SOD\r'), ('200101', '3000.00', '1000.00', '2008-07-15', 'C00001', 'A008 ', 'SOD\r'), ('200111', '1000.00', '300.00', '2008-07-10', 'C00020', 'A008 ', 'SOD\r'), ('200104', '1500.00', '500.00', '2008-03-13', 'C00006', 'A004 ', 'SOD\r'), ('200106', '2500.00', '700.00', '2008-04-20', 'C00005', 'A002 ', 'SOD\r'), ('200125', '2000.00', '600.00', '2008-10-10', 'C00018', 'A005 ', 'SOD\r'), ('200117', '800.00', '200.00', '2008-10-20', 'C00014', 'A001 ', 'SOD\r'), ('200123', '500.00', '100.00', '2008-09-16', 'C00022', 'A002 ', 'SOD\r'), ('200120', '500.00', '100.00', '2008-07-20', 'C00009', 'A002 ', 'SOD\r'), ('200116', '500.00', '100.00', '2008-07-13', 'C00010', 'A009 ', 'SOD\r'), ('200124', '500.00', '100.00', '2008-06-20', 'C00017', 'A007 ', 'SOD\r'), ('200126', '500.00', '100.00', '2008-06-24', 'C00022', 'A002 ', 'SOD\r'), ('200129', '2500.00', '500.00', '2008-07-20', 'C00024', 'A006 ', 'SOD\r'), ('200127', '2500.00', '400.00', '2008-07-20', 'C00015', 'A003 ', 'SOD\r'), ('200128', '3500.00', '1500.00', '2008-07-20', 'C00009', 'A002 ', 'SOD\r'), ('200135', '2000.00', '800.00', '2008-09-16', 'C00007', 'A010 ', 'SOD\r'), ('200131', '900.00', '150.00', '2008-08-26', 'C00012', 'A012 ', 'SOD\r'), ('200133', '1200.00', '400.00', '2008-06-29', 'C00009', 'A002 ', 'SOD\r'), ('200132', '4000.00', '2000.00', '2008-08-15', 'C00013', 'A013 ', 'SOD\r'); -- -------------------------------------------------------- -- -- Table structure for table `student` -- CREATE TABLE IF NOT EXISTS `student` ( `NAME` varchar(30) NOT NULL, `TITLE` varchar(25) NOT NULL, `CLASS` varchar(5) NOT NULL, `SECTION` varchar(1) NOT NULL, `ROLLID` decimal(3,0) NOT NULL, PRIMARY KEY (`CLASS`,`SECTION`,`ROLLID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `student` -- INSERT INTO `student` (`NAME`, `TITLE`, `CLASS`, `SECTION`, `ROLLID`) VALUES ('Deepak ', 'Saxana ', 'V ', 'A', '15'), ('Robert ', 'Paul ', 'VI ', 'A', '2'), ('Danny ', 'Moris ', 'V ', 'B', '15'); -- -------------------------------------------------------- -- -- Table structure for table `studentreport` -- CREATE TABLE IF NOT EXISTS `studentreport` ( `CLASS` varchar(5) NOT NULL, `SECTION` varchar(1) NOT NULL, `ROLLID` decimal(3,0) NOT NULL, `GRADE` varchar(5) NOT NULL, `SEMISTER` varchar(5) DEFAULT NULL, `CLASS_ATTENDED` decimal(25,0) DEFAULT NULL, KEY `FK_CSR` (`CLASS`,`SECTION`,`ROLLID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `studentreport` -- INSERT INTO `studentreport` (`CLASS`, `SECTION`, `ROLLID`, `GRADE`, `SEMISTER`, `CLASS_ATTENDED`) VALUES ('V ', 'A', '15', 'A++ ', '1St ', '75'), ('VI ', 'A', '2', 'A+ ', '2Nd ', '70'), ('V ', 'B', '15', 'AA ', '1St ', '85'), ('VI ', 'A', '2', 'A+ ', '1St ', '70'), ('V ', 'A', '15', 'AA ', '2Nd ', '85');