-
Notifications
You must be signed in to change notification settings - Fork 0
/
medical_store.sql
103 lines (87 loc) · 4.03 KB
/
medical_store.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
-- phpMyAdmin SQL Dump
-- version 3.3.9
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Feb 07, 2013 at 04:48 PM
-- Server version: 5.5.8
-- PHP Version: 5.3.5
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `medical_store`
--
-- --------------------------------------------------------
--
-- Table structure for table `medicine`
--
CREATE TABLE IF NOT EXISTS `medicine` (
`mbno` varchar(10) NOT NULL,
`mname` varchar(50) DEFAULT NULL,
`mcompany` varchar(50) DEFAULT NULL,
`mqty` int(10) DEFAULT NULL,
`mexpdate` varchar(50) DEFAULT NULL,
`mpurdate` varchar(50) DEFAULT NULL,
`mtype` varchar(30) DEFAULT NULL,
`mpurprice` float DEFAULT NULL,
`msaleprice` float DEFAULT NULL,
`mrackno` varchar(20) DEFAULT NULL,
`sid` int(10) DEFAULT NULL,
`sname` varchar(50) DEFAULT NULL,
PRIMARY KEY (`mbno`),
KEY `sid` (`sid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `medicine`
--
INSERT INTO `medicine` (`mbno`, `mname`, `mcompany`, `mqty`, `mexpdate`, `mpurdate`, `mtype`, `mpurprice`, `msaleprice`, `mrackno`, `sid`, `sname`) VALUES
('E20302', 'Mecobion-OD', 'Medley pharmacceuticals ltd', 100, '8-2013', '6-2-2013', 'Tablet', 50, 78, 'm', 2, 'rupesh kamble'),
('l127', 'cystone', 'himalaya', 60, '2-2015', '6-2-2013', 'Tablet', 60, 80, 'c', 7, 'baban marne'),
('m145', 'metxl-25', 'meta parma', 10, '5-2014', '6-2-2013', 'Tablet', 80, 100, 'm', 3, 'Ganesh marne'),
('p20776', 'GlimiSave-4', 'Gilmepiride', 100, '7-2014', '6-2-2013', 'Tablet', 70, 87, 'g', 1, 'akshay mahadik'),
('q111', 'vix500', 'vix pharma', 10, '2-2014', '7-2-2013', 'Tablet', 25, 50, 'v1', 2, 'Ganesh marne'),
('r2025', 'tiger balm', 'makson pvt ltd', 50, '2-2016', '6-2-2013', 'Balm', 15, 27, 'x', 6, 'nitin pawar'),
('s1234', 'combiflan-5mg', 'combifan pharma', 10, '4-2015', '7-2-2013', 'Tablet', 50, 100, 'c1', 2, 'rupesh kamble'),
('s167', 'supradin', 'supra phrma', 50, '8-2014', '6-2-2013', 'Tablet', 17, 30, 's', 4, 'Mayur joshi'),
('w12', 'crocine', 'crocine pharma', 10, '2-2015', '7-2-2013', 'Tablet', 50, 100, 'c`', 2, 'rupesh kamble');
-- --------------------------------------------------------
--
-- Table structure for table `supplier`
--
CREATE TABLE IF NOT EXISTS `supplier` (
`sid` int(10) NOT NULL AUTO_INCREMENT,
`sname` varchar(50) DEFAULT NULL,
`saddress` varchar(100) DEFAULT NULL,
`sphoneno` varchar(20) DEFAULT NULL,
`semailid` varchar(30) DEFAULT NULL,
PRIMARY KEY (`sid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;
--
-- Dumping data for table `supplier`
--
INSERT INTO `supplier` (`sid`, `sname`, `saddress`, `sphoneno`, `semailid`) VALUES
(1, 'akshay mahadik', 'kothrud,pune-411038', '9604856881', '[email protected]'),
(2, 'rupesh kamble', 'varaje,Pune-411052', '9869663450', '[email protected]'),
(3, 'Ganesh marne', 'sadashiv peth,pune-411001', '9922205610', '[email protected]'),
(4, 'Mayur joshi', 'sadashiv peth,pune-4110111', '98989863620', '[email protected]'),
(5, 'dinesh divekar', 'kondhva', '89898565601', '[email protected]'),
(6, 'nitin pawar', 'pimpri,pune', '0202546468567', '[email protected]'),
(7, 'baban marne', 'vadgaon,pune', '7788556611', '[email protected]'),
(9, 'arnav kulkarni', 'aundh,pune', '7852146585', '[email protected]'),
(10, 'ganesh pawale', 'kothrud', '020-25487978', '[email protected]'),
(11, 'sagar sirke', 'ganesh nagar,pune', '8956237412', '[email protected]'),
(12, 'sandeep shinde1', 'shashtrinagar,pune', '8789789899', '[email protected]'),
(13, 'akash rahane', 'kothrud,pune', '7858963258', '[email protected]'),
(14, 'Ganesh vele', 'kothrud,pune', '7845123288', '[email protected]'),
(16, 'harish rawat', 'nalstop ,pune', '78451203695', '[email protected]');
--
-- Constraints for dumped tables
--
--
-- Constraints for table `medicine`
--
ALTER TABLE `medicine`
ADD CONSTRAINT `medicine_ibfk_1` FOREIGN KEY (`sid`) REFERENCES `supplier` (`sid`);