-
Notifications
You must be signed in to change notification settings - Fork 0
/
db.sql
121 lines (106 loc) · 5.4 KB
/
db.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
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
-- MySQL dump 10.13 Distrib 5.5.24, for Win64 (x86)
--
-- Host: localhost Database: hms_hms
-- ------------------------------------------------------
-- Server version 5.5.24-log
/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `ci_sessions`
--
DROP TABLE IF EXISTS `ci_sessions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ci_sessions` (
`session_id` varchar(40) NOT NULL DEFAULT '0',
`ip_address` varchar(45) NOT NULL DEFAULT '0',
`user_agent` varchar(120) NOT NULL,
`last_activity` int(10) unsigned NOT NULL DEFAULT '0',
`user_data` text NOT NULL,
PRIMARY KEY (`session_id`),
KEY `last_activity_idx` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ci_sessions`
--
LOCK TABLES `ci_sessions` WRITE;
/*!40000 ALTER TABLE `ci_sessions` DISABLE KEYS */;
INSERT INTO `ci_sessions` VALUES ('032b1342716decff04b4b41e60060d64','127.0.0.1','Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.4 (KHTML, like Gecko) Chrome/22.0.1229.94 Safari/537.4',1350168568,'a:3:{s:9:\"user_data\";s:0:\"\";s:8:\"loggedIn\";b:1;s:8:\"username\";s:32:\"2e9cc0cc73d64cd2bcdc602eaa8f0759\";}'),('2e7a2df8827b4f1a4aef18341efa33b8','127.0.0.1','Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.4 (KHTML, like Gecko) Chrome/22.0.1229.94 Safari/537.4',1350168853,'a:3:{s:9:\"user_data\";s:0:\"\";s:8:\"loggedIn\";b:1;s:8:\"username\";s:32:\"2e9cc0cc73d64cd2bcdc602eaa8f0759\";}'),('31c3b9d4590c7b7f3b32d9aad2d79ad9','127.0.0.1','Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.4 (KHTML, like Gecko) Chrome/22.0.1229.94 Safari/537.4',1350175833,'');
/*!40000 ALTER TABLE `ci_sessions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `person`
--
DROP TABLE IF EXISTS `person`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `person` (
`personId` bigint(20) NOT NULL AUTO_INCREMENT,
`fName` varchar(45) NOT NULL,
`mName` varchar(45) NOT NULL,
`lName` varchar(45) NOT NULL,
`address` varchar(500) NOT NULL,
`rPhone` varchar(45) NOT NULL,
`mobile` varchar(45) NOT NULL,
`registrationNo` varchar(45) DEFAULT NULL,
`gender` enum('Male','Female') NOT NULL,
`DOB` timestamp NULL DEFAULT NULL,
`email` varchar(100) DEFAULT NULL,
PRIMARY KEY (`personId`),
UNIQUE KEY `personId_UNIQUE` (`personId`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `person`
--
LOCK TABLES `person` WRITE;
/*!40000 ALTER TABLE `person` DISABLE KEYS */;
INSERT INTO `person` VALUES (4,'Shantanu','Chandrashekhar','Thatte','17, Yeshwant Colony, Indore, MP 452003','02055551111','9960066611','abc123','Male','1989-11-05 18:30:00','shantanuthatte@gmail.com'),(5,'vikram','abc','chaudhari','karve nagar,pune','1234567899','9766699569','2','Male','0000-00-00 00:00:00','vikram@gmail.com'),(6,'Anagha','S','Kulkarni',' karve nagar , pune','25467094','9850214282',NULL,'Female',NULL,'anagha_sam@hotmail.com');
/*!40000 ALTER TABLE `person` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
`userId` bigint(20) NOT NULL AUTO_INCREMENT,
`userName` varchar(40) NOT NULL,
`password` varchar(40) NOT NULL,
`type` int(11) NOT NULL,
`recoveryEmail` varchar(100) NOT NULL,
`permission` varchar(20) NOT NULL,
`personId` bigint(20) DEFAULT NULL,
PRIMARY KEY (`userId`),
UNIQUE KEY `userName` (`userName`),
KEY `personId_idx` (`personId`),
CONSTRAINT `personId` FOREIGN KEY (`personId`) REFERENCES `person` (`personId`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users`
--
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'vikram','vikram',2,'vikram@gmail.com','1',5),(2,'doctor1','doctor1',1,'saurabhzunke@gmail.com','1',5),(3,'shantanu','2e9cc0cc73d64cd2bcdc602eaa8f0759',2,'shantanuthatte@gmail.com','1',4),(4,'anagha','d0ba19748f63d2ea4c8a5730ccfc6f9e',1,'anagha_sam@hotmail.com','1',6);
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2012-10-14 7:42:55