· 6 years ago · Jul 03, 2019, 07:42 AM
1-- MySQL dump 10.13 Distrib 8.0.16, for Win64 (x86_64)
2--
3-- Host: 127.0.0.1 Database: ims
4-- ------------------------------------------------------
5-- Server version 5.6.25
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10 SET NAMES utf8 ;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `client`
20--
21
22DROP TABLE IF EXISTS `client`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24 SET character_set_client = utf8mb4 ;
25CREATE TABLE `client` (
26 `hospital` varchar(50) NOT NULL,
27 `identifier_code` varchar(50) NOT NULL,
28 `area` varchar(50) NOT NULL,
29 `contact_name` varchar(50) NOT NULL,
30 `contact_number` varchar(50) NOT NULL,
31 `email` varchar(50) NOT NULL
32) ENGINE=InnoDB DEFAULT CHARSET=latin1;
33/*!40101 SET character_set_client = @saved_cs_client */;
34
35--
36-- Dumping data for table `client`
37--
38
39LOCK TABLES `client` WRITE;
40/*!40000 ALTER TABLE `client` DISABLE KEYS */;
41INSERT INTO `client` VALUES ('Ragama Central Hospital','RGCH','Ragama','Sansun Silva','0113453453','sandun@hcl.lk'),('Colombo Chest Clinic','CCC','Borella','Kasun Pradeep','0113483832','kasun@ccc.lk'),('Nagoda General Hospital','NGH','Kalutara','Nimal Hettiaracchi','0342228987','nimal@nagoda.lk'),('National Hospital Colombo','NHSL','Colombo','Pradeepa Fernando','0113453453','pradeepa@nhsl.lk');
42/*!40000 ALTER TABLE `client` ENABLE KEYS */;
43UNLOCK TABLES;
44
45--
46-- Table structure for table `po_item`
47--
48
49DROP TABLE IF EXISTS `po_item`;
50/*!40101 SET @saved_cs_client = @@character_set_client */;
51 SET character_set_client = utf8mb4 ;
52CREATE TABLE `po_item` (
53 `po` int(11) NOT NULL,
54 `item_code` varchar(50) NOT NULL,
55 `qty` int(11) NOT NULL,
56 KEY `po` (`po`),
57 CONSTRAINT `po_item_ibfk_1` FOREIGN KEY (`po`) REFERENCES `purchaseorder` (`po`)
58) ENGINE=InnoDB DEFAULT CHARSET=latin1;
59/*!40101 SET character_set_client = @saved_cs_client */;
60
61--
62-- Dumping data for table `po_item`
63--
64
65LOCK TABLES `po_item` WRITE;
66/*!40000 ALTER TABLE `po_item` DISABLE KEYS */;
67INSERT INTO `po_item` VALUES (1,'DESKLA01',50),(1,'WRDLG50',30),(2,'CHRVI01',12),(2,'DSKDO01',20),(3,'SYRI45',100);
68/*!40000 ALTER TABLE `po_item` ENABLE KEYS */;
69UNLOCK TABLES;
70
71--
72-- Table structure for table `purchaseorder`
73--
74
75DROP TABLE IF EXISTS `purchaseorder`;
76/*!40101 SET @saved_cs_client = @@character_set_client */;
77 SET character_set_client = utf8mb4 ;
78CREATE TABLE `purchaseorder` (
79 `po` int(11) NOT NULL AUTO_INCREMENT,
80 `supplier_code` varchar(50) NOT NULL,
81 `creation_time` datetime DEFAULT CURRENT_TIMESTAMP,
82 `postedUser` varchar(20) DEFAULT NULL,
83 `approval` varchar(10) NOT NULL,
84 `recieved` varchar(50) DEFAULT 'No',
85 PRIMARY KEY (`po`),
86 KEY `supplier_code` (`supplier_code`),
87 CONSTRAINT `purchaseorder_ibfk_1` FOREIGN KEY (`supplier_code`) REFERENCES `supplier` (`supplier_code`)
88) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
89/*!40101 SET character_set_client = @saved_cs_client */;
90
91--
92-- Dumping data for table `purchaseorder`
93--
94
95LOCK TABLES `purchaseorder` WRITE;
96/*!40000 ALTER TABLE `purchaseorder` DISABLE KEYS */;
97INSERT INTO `purchaseorder` VALUES (1,'OLBUL45','2019-05-13 21:47:22','admin','Approved','Yes'),(2,'NILKMF67','2019-05-13 21:48:16','admin','Approved','Yes'),(3,'TECMI34','2019-05-13 21:50:57','admin','Approved','Yes');
98/*!40000 ALTER TABLE `purchaseorder` ENABLE KEYS */;
99UNLOCK TABLES;
100
101--
102-- Table structure for table `requestorder`
103--
104
105DROP TABLE IF EXISTS `requestorder`;
106/*!40101 SET @saved_cs_client = @@character_set_client */;
107 SET character_set_client = utf8mb4 ;
108CREATE TABLE `requestorder` (
109 `ro` int(11) NOT NULL AUTO_INCREMENT,
110 `client_code` varchar(50) NOT NULL,
111 `creation_time` datetime DEFAULT CURRENT_TIMESTAMP,
112 `postedUser` varchar(20) DEFAULT NULL,
113 `approval` varchar(10) NOT NULL,
114 `released` varchar(50) DEFAULT 'No',
115 PRIMARY KEY (`ro`)
116) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
117/*!40101 SET character_set_client = @saved_cs_client */;
118
119--
120-- Dumping data for table `requestorder`
121--
122
123LOCK TABLES `requestorder` WRITE;
124/*!40000 ALTER TABLE `requestorder` DISABLE KEYS */;
125INSERT INTO `requestorder` VALUES (1,'RGCH','2019-05-13 21:53:17','admin','Approved','Yes'),(2,'RGCH','2019-05-13 21:57:26','admin','Approved','Yes'),(3,'NGH','2019-05-13 21:59:58','admin','Approved','Yes'),(4,'RGCH','2019-06-19 11:28:05','admin','Declined','No'),(5,'RGCH','2019-06-19 11:33:26','admin','Declined','No'),(6,'RGCH','2019-06-19 11:51:41','admin','Declined','No'),(7,'RGCH','2019-06-19 12:00:42','admin','Declined','No'),(8,'RGCH','2019-06-19 12:03:01','admin','Declined','No'),(9,'RGCH','2019-06-19 12:05:11','admin','Declined','No');
126/*!40000 ALTER TABLE `requestorder` ENABLE KEYS */;
127UNLOCK TABLES;
128
129--
130-- Table structure for table `ro_item`
131--
132
133DROP TABLE IF EXISTS `ro_item`;
134/*!40101 SET @saved_cs_client = @@character_set_client */;
135 SET character_set_client = utf8mb4 ;
136CREATE TABLE `ro_item` (
137 `ro` int(11) NOT NULL,
138 `item_code` varchar(50) NOT NULL,
139 `qty` int(11) NOT NULL
140) ENGINE=InnoDB DEFAULT CHARSET=latin1;
141/*!40101 SET character_set_client = @saved_cs_client */;
142
143--
144-- Dumping data for table `ro_item`
145--
146
147LOCK TABLES `ro_item` WRITE;
148/*!40000 ALTER TABLE `ro_item` DISABLE KEYS */;
149INSERT INTO `ro_item` VALUES (1,'SYRI45',50),(1,'DESKLA01',20),(2,'DSKDO01',10),(2,'CHRVI01',10),(3,'SYRI45',50),(4,'DSKDO01',5),(5,'WRDLG50',4),(6,'DSKDO01',2),(7,'DSKDO01',2),(8,'DSKDO01',1),(9,'CHRVI01',2);
150/*!40000 ALTER TABLE `ro_item` ENABLE KEYS */;
151UNLOCK TABLES;
152
153--
154-- Table structure for table `store`
155--
156
157DROP TABLE IF EXISTS `store`;
158/*!40101 SET @saved_cs_client = @@character_set_client */;
159 SET character_set_client = utf8mb4 ;
160CREATE TABLE `store` (
161 `supplier_code` varchar(50) NOT NULL,
162 `item_code` varchar(50) NOT NULL,
163 `item_name` varchar(50) NOT NULL,
164 `qty` int(11) DEFAULT '0',
165 `description` varchar(50) NOT NULL,
166 `pending_removal` varchar(10) DEFAULT 'No',
167 UNIQUE KEY `item_code` (`item_code`),
168 KEY `supplier_code` (`supplier_code`),
169 CONSTRAINT `store_ibfk_1` FOREIGN KEY (`supplier_code`) REFERENCES `supplier` (`supplier_code`)
170) ENGINE=InnoDB DEFAULT CHARSET=latin1;
171/*!40101 SET character_set_client = @saved_cs_client */;
172
173--
174-- Dumping data for table `store`
175--
176
177LOCK TABLES `store` WRITE;
178/*!40000 ALTER TABLE `store` DISABLE KEYS */;
179INSERT INTO `store` VALUES ('NILKMF67','CHRDO01','Cusion Chair',0,'Doctor Chair - Black - Adjustable','No'),('NILKMF67','CHRVI01','Arm Chair',2,'Visitor Chair; Black','No'),('OLBUL45','DESKLA01','25w Desk Lamp',0,'Doctor Desk Lamp','No'),('NILKMF67','DSKDO01','5x3 Desk',0,'Doctor Desk- Black ','No'),('TFSCS56','FOODEX01','Executive Meal',0,'Doctor\'s Meal','No'),('TFSCS56','FOODSD01','Patient Meal PP',0,'Standard - General Ward','No'),('TFSCS56','FOODSD02','Patient Meal PP Emergancy',0,'Patient-Emergancy Ward','No'),('TECMI34','PARAC15','Paracetamol 150mg',0,'Market Name: Panadol Grade A','No'),('IDGOG45','PILOW01','Pillow Case - Standard',0,'White Pillowcase - General Ward','No'),('IDGOG45','PILOW02','Pillow Case - Emergancy',0,'Blue Pillow Case - Emergancy Ward','No'),('TECMI34','SYRI45','45ml Syringe',0,'Red Calibrated - Made: Italy','No'),('TECMI34','SYRI90','90ml Syringe',0,'Black Calibrated - Made: Italy, Grade: A','No'),('OLBUL45','WRDLG50','50w Ward Light',26,'High Intensity Light - Warm White','No');
180/*!40000 ALTER TABLE `store` ENABLE KEYS */;
181UNLOCK TABLES;
182
183--
184-- Table structure for table `supplier`
185--
186
187DROP TABLE IF EXISTS `supplier`;
188/*!40101 SET @saved_cs_client = @@character_set_client */;
189 SET character_set_client = utf8mb4 ;
190CREATE TABLE `supplier` (
191 `supplier_code` varchar(50) NOT NULL,
192 `supplier_name` varchar(50) NOT NULL,
193 `contact_name` varchar(50) NOT NULL,
194 `contact_number` varchar(50) NOT NULL,
195 `email` varchar(50) NOT NULL,
196 UNIQUE KEY `supplier_code` (`supplier_code`),
197 UNIQUE KEY `supplier_name` (`supplier_name`)
198) ENGINE=InnoDB DEFAULT CHARSET=latin1;
199/*!40101 SET character_set_client = @saved_cs_client */;
200
201--
202-- Dumping data for table `supplier`
203--
204
205LOCK TABLES `supplier` WRITE;
206/*!40000 ALTER TABLE `supplier` DISABLE KEYS */;
207INSERT INTO `supplier` VALUES ('IDGOG45','Indigo Garments (PVT) Ltd','Natasha Fernando','0345567676','natasha@indigo.com'),('NILKMF67','Nilkamal Furnitures','Gehan Jayathilake','0114563546','gehan@nilkamal.lk'),('OLBUL45','Orange Lanka','Nethmi Nisansa','0112453452','nethmi@orange.lk'),('TECMI34','Technomedics International','Dilhani Perera','0717343234','dilhani@techno.com'),('TFSCS56','TastyFood Catering (Pvt) Ltd','Anura Dissanayake','0773452341','anura@yahoo.com');
208/*!40000 ALTER TABLE `supplier` ENABLE KEYS */;
209UNLOCK TABLES;
210
211--
212-- Table structure for table `user`
213--
214
215DROP TABLE IF EXISTS `user`;
216/*!40101 SET @saved_cs_client = @@character_set_client */;
217 SET character_set_client = utf8mb4 ;
218CREATE TABLE `user` (
219 `member_name` varchar(50) NOT NULL,
220 `username` varchar(50) NOT NULL,
221 `password` varchar(50) NOT NULL,
222 `role` varchar(50) NOT NULL,
223 UNIQUE KEY `username` (`username`)
224) ENGINE=InnoDB DEFAULT CHARSET=latin1;
225/*!40101 SET character_set_client = @saved_cs_client */;
226
227--
228-- Dumping data for table `user`
229--
230
231LOCK TABLES `user` WRITE;
232/*!40000 ALTER TABLE `user` DISABLE KEYS */;
233INSERT INTO `user` VALUES ('Ravindu Fernando','admin','root','Admin');
234/*!40000 ALTER TABLE `user` ENABLE KEYS */;
235UNLOCK TABLES;
236/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
237
238/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
239/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
240/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
241/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
242/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
243/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
244/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
245
246-- Dump completed on 2019-07-03 12:39:26