API tools faq
paste
Guest User

Untitled

a guest
Dec 24th, 2017
330
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 65.97 KB | None | 0 0
raw download clone embed print report
  1. fCREATE DATABASE IF NOT EXISTS `melencolia` /*!40100 DEFAULT CHARACTER SET latin1 */;
  2. USE `melencolia`;
  3. -- MySQL dump 10.13 Distrib 5.1.41, for debian-linux-gnu (i486)
  4. --
  5. -- Host: localhost Database: melencolia
  6. -- ------------------------------------------------------
  7. -- Server version 5.1.41-3ubuntu12.10
  8.  
  9. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  10. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  11. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  12. /*!40101 SET NAMES utf8 */;
  13. /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
  14. /*!40103 SET TIME_ZONE='+00:00' */;
  15. /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  16. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  17. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  18. /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  19.  
  20. --
  21. -- Table structure for table `File`
  22. --
  23.  
  24. DROP TABLE IF EXISTS `File`;
  25. /*!40101 SET @saved_cs_client = @@character_set_client */;
  26. /*!40101 SET character_set_client = utf8 */;
  27. CREATE TABLE `File` (
  28. `fileId` int(11) NOT NULL AUTO_INCREMENT,
  29. `uploadDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  30. `filename` varchar(150) DEFAULT NULL,
  31. `file` mediumblob,
  32. `ownerName` varchar(150) DEFAULT NULL,
  33. PRIMARY KEY (`fileId`)
  34. ) ENGINE=MyISAM AUTO_INCREMENT=57 DEFAULT CHARSET=latin1;
  35. /*!40101 SET character_set_client = @saved_cs_client */;
  36.  
  37. --
  38. -- Dumping data for table `File`
  39. --
  40.  
  41. LOCK TABLES `File` WRITE;
  42. /*!40000 ALTER TABLE `File` DISABLE KEYS */;
  43. /*!40000 ALTER TABLE `File` ENABLE KEYS */;
  44. UNLOCK TABLES;
  45.  
  46. --
  47. -- Table structure for table `PatientsForms`
  48. --
  49.  
  50. DROP TABLE IF EXISTS `PatientsForms`;
  51. /*!40101 SET @saved_cs_client = @@character_set_client */;
  52. /*!40101 SET character_set_client = utf8 */;
  53. CREATE TABLE `PatientsForms` (
  54. `patientId` int(11) NOT NULL,
  55. `formId` int(11) NOT NULL,
  56. KEY `patientId` (`patientId`),
  57. KEY `formId` (`formId`)
  58. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  59. /*!40101 SET character_set_client = @saved_cs_client */;
  60.  
  61. --
  62. -- Dumping data for table `PatientsForms`
  63. --
  64.  
  65. LOCK TABLES `PatientsForms` WRITE;
  66. /*!40000 ALTER TABLE `PatientsForms` DISABLE KEYS */;
  67. INSERT INTO `PatientsForms` VALUES (21,13),(21,12),(21,15),(21,16),(21,19),(21,20),(21,21),(21,22),(21,23),(21,24),(21,25),(21,26),(21,27),(21,28),(21,29),(7,33),(21,33),(6,33),(7,37),(6,37),(6,38),(5,38),(5,37),(5,39),(6,40),(6,41),(6,44);
  68. /*!40000 ALTER TABLE `PatientsForms` ENABLE KEYS */;
  69. UNLOCK TABLES;
  70.  
  71. --
  72. -- Table structure for table `Doctor`
  73. --
  74.  
  75. DROP TABLE IF EXISTS `Doctor`;
  76. /*!40101 SET @saved_cs_client = @@character_set_client */;
  77. /*!40101 SET character_set_client = utf8 */;
  78. CREATE TABLE `Doctor` (
  79. `doctorId` int(11) NOT NULL AUTO_INCREMENT,
  80. `doctorEmail` varchar(255) NOT NULL,
  81. `doctorUsername` varchar(255) NOT NULL,
  82. `doctorPassword` varchar(255) NOT NULL,
  83. `tempDoctorOneTimePassword` varchar(255) DEFAULT NULL,
  84. `lastLoggedIn` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  85. PRIMARY KEY (`doctorId`),
  86. UNIQUE KEY `doctorUsername` (`doctorUsername`)
  87. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
  88. /*!40101 SET character_set_client = @saved_cs_client */;
  89.  
  90. --
  91. -- Dumping data for table `Doctor`
  92. --
  93.  
  94. LOCK TABLES `Doctor` WRITE;
  95. /*!40000 ALTER TABLE `Doctor` DISABLE KEYS */;
  96. INSERT INTO `Doctor` VALUES (1,'@','Freud','7110eda4d09e062aa5e4a390b0a572ac0d2c0220','8f97cd34d5f4ceb0564beb90ad9fcec23009e88e','2011-08-14 08:23:38');
  97. /*!40000 ALTER TABLE `Doctor` ENABLE KEYS */;
  98. UNLOCK TABLES;
  99.  
  100. --
  101. -- Table structure for table `Admin`
  102. --
  103.  
  104. DROP TABLE IF EXISTS `Admin`;
  105. /*!40101 SET @saved_cs_client = @@character_set_client */;
  106. /*!40101 SET character_set_client = utf8 */;
  107. CREATE TABLE `Admin` (
  108. `adminId` int(11) NOT NULL AUTO_INCREMENT,
  109. `adminEmail` varchar(255) NOT NULL,
  110. `adminUsername` varchar(255) NOT NULL,
  111. `adminPassword` varchar(255) NOT NULL,
  112. `tempAdminOneTimePassword` varchar(255) DEFAULT NULL,
  113. PRIMARY KEY (`adminId`),
  114. UNIQUE KEY `adminUsername` (`adminUsername`)
  115. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
  116. /*!40101 SET character_set_client = @saved_cs_client */;
  117.  
  118. --
  119. -- Dumping data for table `Admin`
  120. --
  121.  
  122. LOCK TABLES `Admin` WRITE;
  123. /*!40000 ALTER TABLE `Admin` DISABLE KEYS */;
  124. INSERT INTO `Admin` VALUES (1,'emilgoode@gamil.com','admin','7110eda4d09e062aa5e4a390b0a572ac0d2c0220','1fb987642befcb8cfcd37723d6c55e183db2ba45');
  125. /*!40000 ALTER TABLE `Admin` ENABLE KEYS */;
  126. UNLOCK TABLES;
  127.  
  128. --
  129. -- Table structure for table `PatientInfoblock`
  130. --
  131.  
  132. DROP TABLE IF EXISTS `PatientInfoblock`;
  133. /*!40101 SET @saved_cs_client = @@character_set_client */;
  134. /*!40101 SET character_set_client = utf8 */;
  135. CREATE TABLE `PatientInfoblock` (
  136. `patientInfoblockId` int(11) NOT NULL AUTO_INCREMENT,
  137. `patientContent` longtext NOT NULL,
  138. `patientType` varchar(255) NOT NULL,
  139. `patientPosition` int(11) NOT NULL,
  140. `patientChapter` int(11) NOT NULL,
  141. PRIMARY KEY (`patientInfoblockId`),
  142. KEY `patientChapter` (`patientChapter`),
  143. CONSTRAINT `PatientInfoblock_ibfk_1` FOREIGN KEY (`patientChapter`) REFERENCES `PatientChapter` (`patientChapterId`) ON DELETE CASCADE ON UPDATE CASCADE
  144. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  145. /*!40101 SET character_set_client = @saved_cs_client */;
  146.  
  147. --
  148. -- Dumping data for table `PatientInfoblock`
  149. --
  150.  
  151. LOCK TABLES `PatientInfoblock` WRITE;
  152. /*!40000 ALTER TABLE `PatientInfoblock` DISABLE KEYS */;
  153. /*!40000 ALTER TABLE `PatientInfoblock` ENABLE KEYS */;
  154. UNLOCK TABLES;
  155.  
  156. --
  157. -- Table structure for table `PatientOneTimePasswords`
  158. --
  159.  
  160. DROP TABLE IF EXISTS `PatientOneTimePasswords`;
  161. /*!40101 SET @saved_cs_client = @@character_set_client */;
  162. /*!40101 SET character_set_client = utf8 */;
  163. CREATE TABLE `PatientOneTimePasswords` (
  164. `patientId` int(11) NOT NULL,
  165. `password` varchar(150) DEFAULT NULL,
  166. `passwordNumber` int(11) NOT NULL,
  167. KEY `patientId` (`patientId`)
  168. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  169. /*!40101 SET character_set_client = @saved_cs_client */;
  170.  
  171. --
  172. -- Dumping data for table `PatientOneTimePasswords`
  173. --
  174.  
  175. LOCK TABLES `PatientOneTimePasswords` WRITE;
  176. /*!40000 ALTER TABLE `PatientOneTimePasswords` DISABLE KEYS */;
  177. INSERT INTO `PatientOneTimePasswords` VALUES (6,'cbae0a9547250e257928c68e8cef354699acce1d',89),(6,'38a19097ba4f5a8c1cb55f916ea2f1e4f676ed7c',90),(6,'cab855058cf46b6032fa5e309cdceb2a3576bf38',91),(6,'72045f64726d223893849e30c35152a036fa430c',92),(25,'f6b40b4925b259a288082eab7137c0aa415f6e4c',100),(25,'6a26e2db76fe5c9d187bde8eb12953c233acf821',99),(25,'2f0ec024909659fa75eb3e523362af367f2831b2',98),(25,'87c23b305c6d0b51c4bb9d17eb44195c2eccf8bc',97),(25,'2f4af65d426b8f2915df26f660571a0739814984',96),(25,'3b0178b81aa62e4e70c0a8b54c0bacfce6974f36',95),(25,'7a3996a650644d3f4985ce51e6cb38ff63886007',94),(25,'b984bb347faf6f6e56624a5c8a188ee40df12d3b',93),(25,'4b9d97e481549c11a86a2d2412f740f5b118363b',92),(25,'0be637add2266c5dfe6c9ae0529a32a1a6fbcee5',91),(25,'4ec42f98c3b5b5780d8e4854018fa565a780ef7d',90),(25,'dc13dfb9740f940ceee08c4ff683031473aa37be',89),(25,'6bd89e24713c69f1832d0c8fcb757f21b398811e',88),(25,'ee82a621aeb68d39d3416a69b99c5ac6c86fc39b',87),(25,'9fb7db8c7fac1dcb2bdc8c3cb70bc2510eb85bea',86),(25,'ab9514649b659c3efaf53e83035b733895fa6a08',85),(25,'8e275057e9d0eb7e11b737761fed5c83744e9370',84),(25,'756453c869e48ac5fb0b6c372a6a7ef0c16ca63c',83),(25,'c86af1668c6a261d4c1c28998d0be1a8cd44f8f5',82),(25,'a5236cada90daf30a447f96c356e64e030ed3a04',81),(25,'cb9fced6bb1777e742e15010f41473b390a371d9',80),(25,'66929e94de46a67f114eecd8568407a52861a6ed',79),(25,'e3327a1a1f0914055b1892c1cca0e8f5a677e627',78),(25,'7466081e773bca902003724b0258457060c7ff22',77),(25,'54b446f5bfe4e31a04bdff17ef1013f99afc6f33',76),(25,'e10f5dceb753c068255662a4e94d0ae66bbd2218',75),(25,'3b35501696c35ad090ac4c875bf9e4060b1bc19b',74),(25,'3e25f247b1ce4dbd49b8f8c15c55f9ffb5271350',73),(25,'0b9f2f1f765feafe7f259921386aaf4d40c1092d',72),(25,'4b0f600dcd875f841f86a4357c892c4a310e2757',71),(25,'962fa9d66044fd6cb1a429c6c5e03f20cdd8ab84',70),(25,'8f65288a645a3e920f24b7bc27954040ca785910',69),(25,'9da716902d22ad1886f5353431727d6efd999740',68),(25,'9df1f9f6bc42503f4b9d21bde33220b2f4b8503b',67),(25,'420caf76376d2db2caf5f1f7ca5c771389295ab6',66),(25,'815f1ffcc7baa1d809390174a3d167ce5c830729',65),(25,'63b9e8cd3054b69efa7e95af7c664460d096487c',64),(25,'cf0f20d3939c964aed66ef304a66dffa1877216c',63),(25,'623becc25bfe282d33ee6a247ba57ce9ac1975d2',62),(25,'6a5bf984be762bea836740e3821ef2e0ff1ad47a',61),(25,'c3213062ee6c1b6625120995cea137f6dd455fcf',60),(25,'12789101b568cc3113b60c4c9d3bc7213cb81af4',59),(25,'ddcf55808257cf977a34142f9aec4e61436a8d09',58),(25,'b2fb42a0774b7d1632365e4693bc8a2bfbff8f83',57),(25,'427b1fb572471556aef80a5edfbc85dc9f7ce98e',56),(25,'026404105d6e03bba3a679645d4e075b8bef742f',55),(25,'9caf59df5c2b633d9e295f5c079c58f8fb3a7c43',54),(25,'11d04f24cdd641957d49bd6aa87767f7ba797a32',53),(25,'5a93c01116678d6dbf9d61b2a65228e2faf1975a',52),(25,'eb9ac8d37fa4b0fdb96333ecbad48475855c0be3',51),(25,'0da55dd32d2c9ad50fdb4ad531298930ba47cd0a',50),(25,'98c36c7711b980b11ff4555d10c7796dc672218b',49),(25,'23a25513dc05fc0a8c218d842139ac4733bf4d8b',48),(25,'6c8f1c134e71da4f73d3c2580e81add84c257273',47),(25,'7985341c441bed195d804da3ddf9f54611050ced',46),(25,'440d461112db5514f234c5137eeb688822b3352a',45),(25,'65eaef60ab3281a7c2b76e9b5e1a50f687819612',44),(25,'2658c458fbc3e2e7157055db78a0118cbabe595e',43),(25,'9dcb0c09f600089877770187f81e9b4ad5f3b074',42),(25,'a2c5c13e18eca0032662109eb6b3d78f2211831f',41),(25,'6945ff2f8beebe8a57afe078ad0f19adfbda31f3',40),(25,'8495843d159c6a3c55917092069a8880e28e2232',39),(25,'60bd1ac17e2da3eb500cf5dc2907ee0000c75d45',38),(25,'31d080b34ee852a0f6cb347fc84fce75074d6f9b',37),(25,'4d2a2f3f9eb87edb8b6ac0b66e85fe4134f0396d',36),(25,'9a2c6e6c1a87c2845478d88cdb7e218c0cec387d',35),(25,'e925e6a95af83314d06b9cfd24f8de1cde009c0d',34),(25,'36d5dfb92a175365496324ba0d465f14951d8685',33),(25,'f07f281e12fd31b284d0973ec05fd98d0f9ae5f7',32),(25,'3b240ad6a747ede49bb5117135906a8722dc2aba',31),(25,'9b9c605993159c91cf43c5354d29febb7d800b53',30),(25,'bb7da713e725aba562fc408fe7bf130c614a0dea',29),(25,'4caba2d5fe56966988a287721e57581f5ac7400e',28),(25,'acc97e9e50eabce5148ccae33bc7460f91266461',27),(25,'54b6c7426db8fa9abd6d2434d490852ad1cf91a3',26),(25,'8b80b9646480a94cb39a957b9283e2cdfb25ddae',25),(25,'8d280de4ebaee0707f49c3482b838ddf5d8ccee6',24),(25,'69fbf012119b633dfdb638f25137478dfd45d7ab',23),(25,'443fdc8d1946415cb9064108caf20d075c3442d3',22),(25,'7ea56a023fa9b09f73f06d847b43f6b17cde51d0',21),(25,'269ff186c221fcf27c1d96c0c1ba9f8c2674a224',20),(25,'245c9e0751c9a1c653d1975481c29f534f58ed7f',19),(25,'1ccc387b9cb6527a7b2328ebb75aae97fc08ecc9',18),(25,'8d2f974a8b81511e34786ba1a62610f2484ee133',17),(25,'bcd05b3a0a5a236078b37b9c8efef65cc6e0b58a',16),(25,'42ea3ce04ccd6fb0c0af9e2eb573fa5d9ba5b1a2',15),(25,'14b417c9c8060be1c2cd0338eeffe5c0b19f30ac',14),(25,'6f4b0947779553d53b73da92364e8f97d97c1999',13),(25,'e8c01a0af9aa85a166ffc8fb7ab54f6a37e2d4e4',12),(25,'972a77cbd8d68c38ed3c11c03128f4a5c5f35282',11),(25,'b733643028aae9893ad70c9e5753f68f7d8ab9b8',10),(25,'1cfb6ea56bb3f9c13a97de62e8820a02fb91c735',9),(25,'abdd0b1a3212dbbf6fb3326fd65a115ec8e4c9bb',8),(6,'777305c67652dabbba0e057aecde766d233e353e',93),(25,'1458c109048ca10e0ea45244ea40e94e0d686054',2),(25,'2d72d783528ef11785ff7a9bfb6b62d87aa0f1c9',3),(25,'c9c330c7dd09f0c0b8bc2477582e29986bb0e956',4),(25,'e135ec77f0cb053bf530004df702ba99843522d8',5),(25,'4921b4e52b2ecd23a899baf2144734fb8ae2e6ea',6),(25,'175540cae0243676e332618d20e5e5726e47bed6',7),(6,'6da68e3a356b2d251af2d016ea724f6ffcc72e3f',88),(6,'a87cff7ab681bc7e493c0887e947b311062600db',87),(6,'a6f21a5a2fce1f26e5eb738cfb4ee6b0f5ae5c46',86),(6,'91620f52b8f220783c6240b3163b63dcd06c23b7',85),(6,'91070d5ee37f7eda28cc3eaaa30466955ac824b5',84),(6,'aef27a58010da5a9e43023f21e52614cab032f13',83),(6,'fe88e85cf0c7134a7634a77bd8cc21d1f33b84b8',82),(6,'70b7fd0187108829865da0b7b5ec50c59d694fd5',81),(6,'608b48674dff607dfd364a5f630b8f7e358742b1',80),(6,'4121c1d92d015f875b13ec19d81151396bd34f79',79),(6,'8bc632393ca286acfd953465e1c773c33dcf84f1',78),(6,'6a9f70b195045c0bc4f6827e10c31ad3dcabb515',77),(6,'e70c2a0048f585d6777f47ecf5aa704dd272c492',76),(6,'2cbd45ef1e0dfe8e27f2398bac20d6894efce9fa',75),(6,'438476b12fbb16e1398d725f3d9ba80150cd46eb',74),(6,'b0c1b7c155bc7df2c8991234d8eb55ef0ad7a7cf',73),(6,'d6165c5efd3430af91542ff9ceee2bc888681f19',72),(6,'4f27812138c2640d459e61e8980448a9db3f465c',71),(6,'7cae590bf4530976164bc6059bd63dfecc7c9250',70),(6,'18c44c23183f8247d1df35e21c723475fde4accf',69),(6,'f5baa5f570454c2c3b2c26322a0355fb53ff9c65',68),(6,'d93ee3540e7cdbab6722295e3e0dd21f21b2d358',67),(6,'092699f9fd21702a9fd1f8c4e5a039f2d0f39e27',66),(6,'4cbebfea8afe074fec35fae6cdd03300acce0917',65),(6,'931f206ee1efe2b727681ab6a19051b8d6f9867d',64),(6,'5bcc13d2150848fc11ed0fbafce5863bb94455b6',63),(6,'1f13b9161e71594ef4832cb4949d721e1fbd0707',62),(6,'814e4954e14712e496d851b9dbb885db65a365bd',61),(6,'7f649307b341c31c3b2ebc6d943375b54551e4ea',60),(6,'11c45d13c35f791c9b151e8e7ea35e703383dae9',59),(6,'df8911415c1cf23db22e445a777bc60191454d1a',58),(6,'f307ef8f9e5b7580aea96256e20b7ed4e97c5e0d',57),(6,'21fd41c4cbf3d01aab6db789d14397ee85f0e3fc',56),(6,'649656e6713819b59250b66f5385551da2af261c',55),(6,'e2b5f0dc5077b4d307e16da02969a30b083d983e',54),(6,'2397179b48d843d126f9409bfb629be2c6060ef7',53),(6,'46c96bfb28c46ad71360c9104c831e415cd00c8a',52),(6,'e542c701f1cfd1f1d452c0917a491ba4190b6dcd',51),(6,'0fb4257ff4fd0dd6f86b609f43b5aca6c95e4b3a',50),(6,'0c34d009de9e7517884098468036f000623667d2',49),(6,'ac14db77652f796a9703da00b1d91aa99899c988',48),(6,'dd00889393a6533b0f56f6afac967a36134c3cbe',47),(6,'2198b08ac0b086fe9c8d1e2464ba17ffd3a3511d',46),(6,'60ca4c42ddec2a0d271604841f55f44e41247ab2',45),(6,'10034fa5dc8eabe2cf3a3fef5f40f344e4082ff5',44),(6,'049f2563691e96d854f126c04f3e4df0a8eacf2b',43),(6,'4f1506d4bcde0cfbb2e305ed2627eb5404cc1dee',42),(6,'07da828e76500bc529391249ccf5b387cca07b7f',41),(6,'dca93d614ca2d94da912f68fba4fb513d143938c',40),(6,'6b6430ddc0b3e8916ed8ba1fd4af1b89dd5c3952',39),(6,'d9ad9cfbb5168ac6fc65af25207d255f7a5b17fa',38),(6,'351da7c20b6994bb34fe344e60b14bb4f3e15303',37),(6,'f36bb1b36551d1be02e3214d4af5d28c2493bd95',36),(6,'ab459979d7fc927fd0911abd13e8437d3a41af53',35),(6,'192a465f48dfa025c18efa189370cbd35bb2a0d2',34),(6,'c1e4ef30bd93ddea08783908caea37c07d9e6962',33),(6,'40020c96c4ecd4ca5505a418e03a3d15aea60020',32),(6,'70d6d7ed177e9feaf512d2ec8045f2dc6012272d',31),(6,'e2bd854909fba928761698754bdb13299b4021ce',30),(6,'bc41199b8c370a7edb2fbb0886c2546eb8bca8ac',29),(6,'9fdf19235ff2be0dd4cbd52067a092f1ae9a5977',27),(6,'50d9712ab2e22e5facc5b22636d86afaadabe7ff',28),(6,'7b74f0ccfe53f4d45c545e392b7777e8acdaa9c4',94),(6,'dd087a33cd2cb2e03d507e4ff9a33c4af8dabb17',95),(6,'9788b8415d35d533e8bd864b8326bde3dd597bc6',96),(6,'005a87917da26f41433aa79e8fe99a673a8648f8',97),(6,'844dfb7f91b26e8343beea3e00e80792cdac6ce8',98),(6,'f99fe260d8fd7922840fdba730ee9165d174dc17',99),(6,'be3efda05a1b2c6eed3cb9672c6d650aa5906b54',100),(6,'6b640f7995505690403636c4b38f3ded5a0e17ae',1),(6,'2ea4de0e71085d1d7bdbedad46d9cb0f1008ebc2',2),(6,'bffde065b6a0d79d52221d99620f70c81161d39d',3),(6,'e2cb1feeca38f93a9e834b5782ac50bf9f80a161',4),(6,'de8af865629c5438113edc5e29c28394050c87fb',5),(6,'1fd07cc93f5a8ed2868ccc0a932c52ba65f60717',6),(6,'532c7df4939196053a184776def1879393ea07fe',7),(6,'404bee65ea9c710a639050916a8782ed84d5bf0a',8),(6,'358e0baa362419a3e9cf6444f0a67d384f82659c',9),(6,'feee985c4137ce9a72a427b1c9ef216295822adf',10),(6,'4007f868e399d367de971b7ea2433956c867be76',11),(6,'c5af5ee4c6dbba16b78e1c1d4c15602aecc7168e',12),(6,'38d5fffdf9e8fdff01360cca2746445276f658ad',13),(6,'9e69a9c2cb20b517bd2445b6fe2e32eb9be00109',14),(6,'47b89bb05d0f8332be8d07f9d29ff78476bb08c1',15),(6,'086c6d832dcb779683f29eca77012d64e68b66c8',16),(6,'008d95ae42f3117e032d8bfafa9ce1de9336687a',17),(6,'b649300d1f229f8d919dc2c1f79dd3eb9c5bad23',18),(6,'4e8f52a01f31adcacc3dc98dd65fe79c3be7a8f6',19),(6,'71b873817ff8e2693dada201baf052dd52eaaa98',20),(6,'54fa0775df540133e6fc66434103c85b1da67ac7',21),(6,'e9ae99a4b065b68b0c92a6c50586033f7ea8a6d1',22),(6,'ad4ff33498fe16f89f6ff8f33694b0836b96de10',23),(6,'c651cf4004e09b69bc1450e7e97921be0ae6b5de',24),(6,'1388059bfd41ad37dc6e1e740d9c33f9e140fa75',25),(6,'18357a0f6cf94611faf10bbd8389fd52a9c6786c',26),(6,'af11a78d253edac2ae52755f96ba217fcbca979e',27),(6,'c22a4fe2703ff58f8ce9265169462193609e4b87',28),(6,'ee08fa8def45c7f50d1fffae84f044f036802b11',29),(6,'6ab8d42bc8065e6c37cb33ee5e2e0a922b2aee9a',30),(6,'5599d2c9c176a5c86c48602dbc3237b2e39a5984',31),(6,'2edf113c24a47c1ce528cf822d851d8ca3a4f84c',32),(6,'e12bc54663251580abcb3a7a486b17b3f25bbd42',33),(6,'89e83298ebe01bb48d46ff6f1e5d545c3713464a',34),(6,'b62888f3c6a758788b20dd271a49fa232a0413ba',35),(6,'f8b0c12d31c6e15573cdac4652749ab6fa092990',36),(6,'364e6e49d6c6bc9662072ba1f851ef4f99a46508',37),(6,'7fbfde83712d4ca8be8ca02fc9bb41a8cf6632ac',38),(6,'cd0e06ec14e00c5e98e75a8144c2fb773c42d811',39),(6,'c56506cad3ecb9ddf283763fa8d298e46a9f493b',40),(6,'f660a9977a6b14921bb7ab39421565872b212f54',41),(6,'154741907d09619988f81c7bc8a58d9975565c0b',42),(6,'e714d19bb7d5f9d13718d3aa5da47b1d5a95e6ee',43),(6,'698e3ef93616ce685afa620c175afb44c9c34f9d',44),(6,'cef8b0bccc8392e6c37042e876e478dd7cb15c07',45),(6,'3eac681b26eb094241a632efb77f1fd6d97c91f9',46),(6,'fe80f1644a9db1aa6d9b4bfd3874649b98dd744e',47),(6,'53b2f8bd5a9e9087bde0c96dea67b524d3130cb8',48),(6,'97eef0356543682f1d40730eadf761f9c9bc1acd',49),(6,'bcdf20c479b3826acc2e4654917242433e672b4e',50),(6,'9ab45db3cf4067ad961a98a7a63c60caba6300d4',51),(6,'94b600dc322a1d3cc16d1fa62deef413914e8a85',52),(6,'ea933bb0e4fac3e9056aadca322e0bf1e4018e5f',53),(6,'ae4c76d03eb8359be89c7e69297ad61a299a755b',54),(6,'02ad32a0d068e8961172acfdf8bf9af70ce5eb7d',55),(6,'8f24378def34c9f4500a129ae9df81e27eb2bf6c',56),(6,'547c275d36606a67dc675b066a617d9bc519aad2',57),(6,'6142f634d78509588f057986006df86e19ef896d',58),(6,'dca1b41133d5603e5a13a787988d35066840cf9b',59),(6,'a9020d20a9a88ac0970e46d6355731513bcfe415',60),(6,'393c93e0c191dbb05c81d7f1910ccfbef58b515b',61),(6,'3be5822157d0786bd48d9f06d1471d1a1382e568',62),(6,'40aba78d600e27f0517af7b654de1d5b51ef8bbf',63),(6,'f4e8724f79592077565a83765df3b97534b99298',64),(6,'015e903d0f652ec60b94ba456057ef49425feaf1',65),(6,'9030cb3ccf89da7119db3395e5dc45ce11a70b2f',66),(6,'2156a49e0bb5d55bd8f00a8d820d20a3bb6cce30',67),(6,'70fb1a610b6952377ab99dee1810e6ef048d3d75',68),(6,'f0c9f400222745bdff6dec4c468bf88c27fb0bf1',69),(6,'852959bcfdec8ea21936d2f0ce229c468f4cbb19',70),(6,'0d96343837b4cb50838acab68f718850434862ad',71),(6,'2821f982e55a8027516abead40133d3f43754ac8',72),(6,'9200fbd62e5efcca182492bab54ace5040092d0b',73),(6,'6a85225f198810ca55a77698f86e9e8354345681',74),(6,'ab8e140e87c767383b3769d51a6bd2d568cd386b',75),(6,'b3c4e028e5a116b3d94b8958e6e5d3e71514aea9',76),(6,'eab97525db82ce3e1a53674d2bfe94b6570e97f0',77),(6,'b57fa490c3a3757762491987d8d707774d201152',78),(6,'fd66a749f7c6693cfe85e43dfc63c7014d36a265',79),(6,'ab5fdd09ebdea0f32a1edc8eec3afd0874829115',80),(6,'747faeaf6badaf42f6cb46056f42edb279913a04',81),(6,'dbb3da0d9dd1fc3a980707310d9e5c045ff79bc6',82),(6,'fb44626e3dfb8402c7588062becd6d6889ddbdd5',83),(6,'c21a2f3256c05b63cb5f50020d2d321b6403c8e9',84),(6,'819361ef7e17969eb3faf1f26d2207955f09efcd',85),(6,'3de0bafae1b786e75409eccb6453c56877a829f1',86),(6,'e090347a2c96d2e6f6c8c645110a1cdfc121630c',87),(6,'a4047eb0feda6a7b4e503077fbc41d737fe0dc46',88),(6,'56e4cae489f5623fb96f8fcbd47e057b11c405ad',89),(6,'71914aca0efc9f917634f8bcf7e3c9eb2770b4d4',90),(6,'eb0f1813a8692aba727c8858d09ed454513d167b',91),(6,'041bda764e4e22182608aac5055920918711d506',92),(6,'8b3addd788f7aaabdad8873d78bb3dbc4568aef0',93),(6,'27e5f86b30e40eb937259233790338498f6f0e43',94),(6,'f530da963dd9233f1d85fdc548383ced0b35207d',95),(6,'2b2c627a3221615297db21b2215985208d28c925',96),(6,'7da6e45dd0a75f49ceb33d82d39447bdbde1ba0e',97),(6,'7eba61e5c721cd4d126e6a68c3943a8e6593182c',98),(6,'8c34bfd55b9b3da355389b07a3215367c30eedb9',99),(6,'7f37abd33d19d9acbe071641ed360ef036dbc68d',100),(7,'0eea8db379ea11d6c6ef42f47f119aa6a9654a26',1),(7,'23b7d97ceed906c7715268b3ae3f864fcf6962b9',2),(7,'9c70173cc93590e0f0cb79853f036148d1d4f846',3),(7,'510f0201b54b153d58610e7422f6607271f4de9c',4),(7,'2f5e43c3bef23ff12f35f24a1e50d2c6ae26fa90',5),(7,'24c5fe02d7bd43ae7f9109a8d362b004e812327f',6),(7,'484990df458b3f21501126c2b626ddb2a1608395',7),(7,'189cb157068d46b450af2334a09a3b4229115e64',8),(7,'723e2f8b65e6a7eed5cbcafdbebdc823bb4ac4ef',9),(7,'05a8c1c26c969c3fca25b6ef3c99f2f46697e7c8',10),(7,'a4c2932b1065450d372e6a08e165694ddee0be92',11),(7,'badba717791b8081dca9e312ccaf9238642273bc',12),(7,'e83c5957b72596d7f180614d3cac92b61e1e850f',13),(7,'d046cf2aa460fb84ed29b79ded3e2bf3de4d3820',14),(7,'7b2efc473d9f8108adc6dceece60c4a6119f8e56',15),(7,'4c7a9f46e17ad525ecbd064d684dec531e5fadf1',16),(7,'d18c1b67213130462e6c6de4779343097b97bda7',17),(7,'4d1552b78b87bc907bd5b96421dc7e1d3a7e276e',18),(7,'f8f04510f4575899cff92d712a41f1dde7c120d6',19),(7,'ec8f48473f37576d78e418ef1658b7335067a180',20),(7,'deb8c72e445f149c0fe9b8c59cd23f49e9201477',21),(7,'4649267583dcffb881fac38296c7fd2abeaa6b13',22),(7,'03ac92625124e9bc57024e4d6fa21070846ea650',23),(7,'5a852b503a7c7d3aee1c11e78fd63ea991865d24',24),(7,'012cad3cf73ad88acccfd047c2cce3ff6b0872f4',25),(7,'1927b80ef621a7871069a807199457f2ae00a1b6',26),(7,'8e612c4934b3743b3fa78bb82527eaa49c47a3a1',27),(7,'a9d4523e87683a41b127632f850b4686382bb753',28),(7,'bef883b611fba3d8f227b6a2fde313bae62f5912',29),(7,'71f8b56e55bfb4f92bd25d46e14b561c7ea5f11f',30),(7,'74a0ddab93a47d25041590266607497b61f70bee',31),(7,'cda0740f58900851cde497a1ec3ef44898d45db0',32),(7,'329d46ad894881a1e755ed5e443959dc3518317e',33),(7,'c04a391a83b725e65a23b203b6e402f3b31bd78f',34),(7,'8db76dc6b4e18658a1e37063cf85ffc7ff528130',35),(7,'ba33ab71e3d1c5c568b322f04606dc838e230885',36),(7,'7d17ab5fd4796f6c0a3336ed4e6ad00ad0d5a4f6',37),(7,'737668e8def50050cdbb2ae569f4efc0ad1c7157',38),(7,'0b19b280ba115d3a9efa55851e5b0d5d6ce12f7f',39),(7,'7c4650e1072e29a76505d7175e635e04441e3f0c',40),(7,'5a4c37dbdf932da9724b6c7f8fed33894993f0cf',41),(7,'40c272397ec00365b0aa1f31bf99d46793b6f38b',42),(7,'eaa278bdcb9420d76307a7e60a83076c588adda2',43),(7,'18c071f11ce3839770031e700e7235955be5d89b',44),(7,'699695732023c8a1f9396e85f614bd89595ebd59',45),(7,'287ec9b4b190b0355bdd052cfc88c81528ed8cbb',46),(7,'c8e9169b8240904b09ec44efcbf345075b75476e',47),(7,'8a854d267cb32db8dc96ad300072b4e4cb02b35c',48),(7,'66e8bb2634fc4e6d106ccfa97c249177bce38769',49),(7,'00995bc88e5b983c9d803fa8da80336e24fb5a62',50),(7,'bd17f918c49f45c2b343e638fb646f698262398e',51),(7,'e5a5b10067ce18183606f1548b0777b568613387',52),(7,'bae511ef240f1fc692286312f9f379f1132500de',53),(7,'90e76c74a293fc43c0006093b381d0601700f891',54),(7,'781dcbe5bb8fce3c512c0096916e32839fd3c711',55),(7,'5e3aec45fb4c43d222486b289c493ba74b94f407',56),(7,'c733457123848a345629d30585ae5ca69e1674c7',57),(7,'2fb2e2a098e96757cb3e93415ece98799687da17',58),(7,'52694e00aef9860e5f285072e601295f1a79bb51',59),(7,'7160a3c4f4e44e39b6bbde753469551ef95f3400',60),(7,'fc2d7c938181b01f70975329ae39816069cdb1c6',61),(7,'bee5bfa8e18703b3a396739fd5b67bc3852dae48',62),(7,'3c364899f0f56d926b817410e5dddcfcde14828b',63),(7,'1ee05006d95fdfcfdfc7a2af93a23abb66fbb2e2',64),(7,'1629e68ec8f6a34b25e7bb4146164785eeeb8829',65),(7,'3106676c20603140c1e1917bf98fd19926a86c59',66),(7,'b03af7aa88414b94f828ab5746a5cc1c7ca0b517',67),(7,'791c6aa89474aa9ee4b6d0ba44c40fbc0d8b5d3d',68),(7,'26fa924f0da516fae23ccc86f68b7edcf6f383b1',69),(7,'23f6160d23a3a457442ddd6a2de4b6f6f6653ced',70),(7,'af28a1b829f02e845ed376a6723dfa409fd9d6e1',71),(7,'652cfd75037a08b264ed1113f1904480e940dfbe',72),(7,'dc73c6baf93dccd2b5dd211040a5775d24a4cf70',73),(7,'53f09fae663d661d6ed7770a87be149a70f5c1ed',74),(7,'23158a4203546794f455e3153b55659f647bc886',75),(7,'42348c0f5df1b87533808b330c9a0f03f29b940c',76),(7,'86056ff7a7bd7fab4e7d9e8206a22c685a33e86a',77),(7,'2a109870da13fce9b905ad1ed562b351d0de8343',78),(7,'3cf46fa26c2e6961b0ffd29e7d9f3ce0435fce67',79),(7,'16ca4b75f1bce17ac6cf00e8dbfb2d4a75854da1',80),(7,'9fda515ec20cfba94a5629037a8317818b93f6c5',81),(7,'8ecdfd89c3120bc56fc82be19907836a51a368d6',82),(7,'4c8afd6445e3feed54b8ae2265f85040a7f32a7c',83),(7,'4201a906404f42891c642ff27c54c26ef0851a58',84),(7,'ec3d3a1e8d98ec47ceb6a5ed46012eb9752bc70e',85),(7,'b01d10eda31c1191a34dba65073fafd06231334c',86),(7,'0b5b0ae471393fe14d722fe7a93f1753ef6ce660',87),(7,'8dab12094f4a6d69fc90ba4d9542238be8fc67f4',88),(7,'c680f6a1682acb87b683e38c862361e74a18a345',89),(7,'7742743e3563b00a0e4d8a2abdbc10411a22e3b8',90),(7,'df6695ad12e164e58eae12f29bf80bb6f4ad15cc',91),(7,'98e95ef541b55db8fa2042b473a5a5f2b658eb0c',92),(7,'3f5c3096a4bd208685105d1e18df3639b5ca0ebb',93),(7,'077ef000ce36bf177ee70ae4ad69eadad1f0cf7e',94),(7,'2d843023f10f4a71b8c001135b80f0722f7da9df',95),(7,'a9c604e1df404712f510eff03a650fd03142ebf3',96),(7,'54e2f34e9249f54f50622eafad5173d8ee2a48ea',97),(7,'c5972e769b3d3720e09025cd0ca53d8c09ffd194',98),(7,'071449db8fada6257f7eb5dc638d051b298da68d',99),(7,'1d1db28e37fa5e10de68a80751301a62db7a67f5',100);
  178. /*!40000 ALTER TABLE `PatientOneTimePasswords` ENABLE KEYS */;
  179. UNLOCK TABLES;
  180.  
  181. --
  182. -- Table structure for table `DoctorsFiles`
  183. --
  184.  
  185. DROP TABLE IF EXISTS `DoctorsFiles`;
  186. /*!40101 SET @saved_cs_client = @@character_set_client */;
  187. /*!40101 SET character_set_client = utf8 */;
  188. CREATE TABLE `DoctorsFiles` (
  189. `doctorId` int(11) NOT NULL,
  190. `fileId` int(11) NOT NULL,
  191. KEY `doctorId` (`doctorId`),
  192. KEY `fileId` (`fileId`)
  193. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  194. /*!40101 SET character_set_client = @saved_cs_client */;
  195.  
  196. --
  197. -- Dumping data for table `DoctorsFiles`
  198. --
  199.  
  200. LOCK TABLES `DoctorsFiles` WRITE;
  201. /*!40000 ALTER TABLE `DoctorsFiles` DISABLE KEYS */;
  202. /*!40000 ALTER TABLE `DoctorsFiles` ENABLE KEYS */;
  203. UNLOCK TABLES;
  204.  
  205. --
  206. -- Table structure for table `AdminOneTimePasswords`
  207. --
  208.  
  209. DROP TABLE IF EXISTS `AdminOneTimePasswords`;
  210. /*!40101 SET @saved_cs_client = @@character_set_client */;
  211. /*!40101 SET character_set_client = utf8 */;
  212. CREATE TABLE `AdminOneTimePasswords` (
  213. `adminId` int(11) NOT NULL,
  214. `password` varchar(150) DEFAULT NULL,
  215. `passwordNumber` int(11) NOT NULL,
  216. KEY `adminId` (`adminId`)
  217. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  218. /*!40101 SET character_set_client = @saved_cs_client */;
  219.  
  220. --
  221. -- Dumping data for table `AdminOneTimePasswords`
  222. --
  223.  
  224. LOCK TABLES `AdminOneTimePasswords` WRITE;
  225. /*!40000 ALTER TABLE `AdminOneTimePasswords` DISABLE KEYS */;
  226. INSERT INTO `AdminOneTimePasswords` VALUES (1,'07a132ae0d72be092f7e94ca6c96054d1d37850d',84),(1,'e46cc741701468d263c8659a1914b9ec348ccbcd',83),(1,'44ef52fbe96759cd315ae25b56eb00e8cc71f15e',82),(1,'1b52617c5b160a352c9776199a14bc844cca0e31',81),(1,'7241e323067665b8c25f66c7fcc135bfd609235b',80),(1,'90a29d57f8da5b8f513f291a1aa70dc512de1c68',79),(1,'e42315ce5bac99fed1b5466a7affbc9410eeccab',78),(1,'6e0fe34d0835e820859205a532f22af8db2d6094',77),(1,'f915e39d5ecfa185e1b63ae65e40a56ac79ce269',76),(1,'c50654a292eff9821a4401eb2cb6d0ef6308e58a',75),(1,'cde8aff8ce41c7bd194bc60b91379cffd630842b',74),(1,'a0bd15d28727f8f801c74cff4b70dce6f077b020',73),(1,'3a118f7340ac8a800eb469d0aef8278c82b12582',72),(1,'a45a09dc81fd5310aaf900a8904a510bed35d6f2',71),(1,'c488aefb989ba70a48a409a98bb6b31f2b148750',70),(1,'9eb3089d1101fa96718bbad6ea428905b8f2c0ad',69),(1,'5c6ace48a37a464fa53528dc877be49f3645d199',68),(1,'5157d5dca424ea0272923213d7206c24bc409c8e',67),(1,'9b430a285218146020ce1c635c336fded68c72c8',66),(1,'13b14a143dd1c179ae6b4bbd73a1e609071ed1ad',65),(1,'9b89bf9976f06cd432c13f2924c4205864a63145',64),(1,'f19476bb424108e9031ef80c1b38ee2f97856a84',63),(1,'deddbcc5537a79762a6cf532010fa20ff651e177',62),(1,'688ed6f593d3c09693524b1dc664387ee86ddb6a',61),(1,'74f7b6fe676f326618e93baf374476fbf560ad0e',60),(1,'7c3c86f286336b96c77089a944e6dd950740d608',59),(1,'aeb29b4b1671b554e89e57da8009e359a7afafea',58),(1,'3e524ab13a15d29873e264ba15ffb3713031c101',57),(1,'09c1aaf8c52ab8707f1cdfe5df0e637fea52f997',56),(1,'78a0b95a3be7e319d5a3399d95e18c0ba5767204',55),(1,'212be609d6b9fc883f362de5c2bcbb1aab0f1d91',54),(1,'0804d507fcdc1e336b03f7b00373cd40162ba459',53),(1,'0e2aef331d37f6011ed5ced4833904342de815fe',52),(1,'9319d7545d51f358657963311ed843ea116ffd04',51),(1,'686a4e0ca941630b07f6df1f3e0477e68ca2ffa9',50),(1,'bede607f705a56ac75659b188b23b79accba2150',49),(1,'252613ec30bc7cec193d2c7ec4b5dcf5b0ae1024',48),(1,'f9ca95d8701c0c8bff9bb304ff824db5d75dceb7',47),(1,'7a357c8bf6dec33ac5cec6e582e766561a748411',46),(1,'38a6bba8b956b72ef05f070097b34e20ae626a60',45),(1,'5a4ada42fb30077adb0967bd95f8fd19a887436a',44),(1,'dccca26e4e8682e4c03eafde71a3f28e60c74698',43),(1,'c50342e9491375652ea993924132f1873878e121',42),(1,'da467805d4f93492ae8736daa35aef0f59994701',41),(1,'6fa56194c0f5a13721e911acce6e08ba7b315c64',40),(1,'39989e58a0d3ae040425bb9772bd1fb93ef3db80',39),(1,'29abe92e03bd45b65ae166c8edf7bbb90e947fcb',38),(1,'d3739ae69fad658bd19080849189d4a726de30d4',37),(1,'2c38f353670408c39f75d0a672cf6541c93e4967',36),(1,'d1fd46ac72bbd88623550067942637548dc7c26b',35),(1,'338a33fdc4a1784bd99b10663c4095595f0f62af',34),(1,'7abc3db94d3f9055104908d9cac1cadf07c5c0c4',33),(1,'91ed2e0a68ce233f8683c67f2c7089a1ec1a01b4',32),(1,'975d0296f645965a58a66312edf720e0f92a39f2',31),(1,'f173ee970e05a61b68d2047aed7bcf6c65513512',30),(1,'2d17d9e13d1849cf72ff0d9736fe420c53f94850',29),(1,'c73343aa20bca927b1c268b3aa3894d0e8ac2a3e',28),(1,'535f335735978f96b5c9df443743c28f038125d2',27),(1,'6eda0190ce06c50fcc8f85c414afc5721621b02b',26),(1,'7b4f758b2f8eef3d7d0c37396f09d77d3c3a970e',25),(1,'a6081ed6b0de1913465b80b463503cb075f1fec2',24),(1,'952f1cf59e2c99327a257d466566817ce94ec565',23),(1,'20a466be7992aafba80e4b738a3f78d99447a3f0',22),(1,'d6baa72d6a3ca5ca533c258185e550729e61d057',21),(1,'04b29c890d0dcd0fed594da94d26cd66556d3564',20),(1,'54923b8d043895cfb698093004cb7580450864ce',19),(1,'5c681efb63f57937b381fd2b83d0b01ef679cf18',18),(1,'ffb89c58d421c14bed3724ea121ad354fb9eee44',17),(1,'077cd238b5307427a8ec1d8fa5d0ec789ec40f1d',16),(1,'25530cf76e72686fc14ff73707de72daa1207bc1',15),(1,'59957e50dcf3da4e75a270dc580f5786819c8a89',14),(1,'1d40640e863ff0b46b2da7f1dab360b1fb334df5',13),(1,'1921875fbb3a78cd00ad09da8d79f1b81cda8c77',12),(1,'aca33a4716b10019a280dea176bcb099e2fba9b0',11),(1,'0422b1263858234a4a0d7b26a8d4636097de4b4c',10),(1,'5f6478033bf31fb135d8124f963ece2ab7c7187f',9),(1,'6bc1982787cfbd9c0a605aab3982867e27987670',8),(1,'79ee017e24ff226bd1ffd6feae030b93ed809a33',7),(1,'a3f3fc39ae9b09396566c906e2757554991e6ef1',6),(1,'50761460b287800e292f2e5514547d01b20972eb',5),(1,'fd0b2e9d750de4552156f8222ee589ab602022c2',4),(1,'618d82272b4954b473367b398606e0924ba22080',3),(1,'3710db135de135aad53f6f52a30a864c351b549f',2),(1,'491461579bde53fa045781d136fbd09486105292',85),(1,'0a0215f795c72b9b0a348bebe3424cb8565a5e91',86),(1,'a7aa99bac8266a8efb68b00116028f9d388b10de',87),(1,'c9859d3c9685eb99c86bda2904d4026ad5951f3e',88),(1,'91311c25e4b4bde845366e5eb11fa6016cb4268b',89),(1,'af291b91d877d9e43c03c33b565ff3bc15db91fb',90),(1,'a21fe0c4ba3b49ee75d8a0e71401e9a05e5206b6',91),(1,'de08e5f32788dbbbd6d5c4ee13dd1122e2017295',92),(1,'0fbef1bd8c8d4562742997ad3edea94f552f86b4',93),(1,'7a8a678070e199d48e76a4b1117d78ab8f84ccfa',94),(1,'e08195b6120eaf07c405ff75aa44d4a6f475d354',95),(1,'d7d3f388d9c08ed37d763b2c025bef1de158bcd5',96),(1,'215c0998d3a9ecd46b1dcff8f92aab6887e2d4ed',97),(1,'5b3397f732a3c5f4aab308ffa53c9b7f88d13212',98),(1,'cf2de7a016eae44748f7ed5996f86adef3d9b36b',99),(1,'13de07a90e3b07f01faac4716e0bdd7077fbff96',100);
  227. /*!40000 ALTER TABLE `AdminOneTimePasswords` ENABLE KEYS */;
  228. UNLOCK TABLES;
  229.  
  230. --
  231. -- Table structure for table `Patient`
  232. --
  233.  
  234. DROP TABLE IF EXISTS `Patient`;
  235. /*!40101 SET @saved_cs_client = @@character_set_client */;
  236. /*!40101 SET character_set_client = utf8 */;
  237. CREATE TABLE `Patient` (
  238. `patientId` int(11) NOT NULL AUTO_INCREMENT,
  239. `patientEmail` varchar(255) NOT NULL,
  240. `patientUsername` varchar(255) NOT NULL,
  241. `patientPassword` varchar(255) NOT NULL,
  242. `tempPatientOneTimePassword` varchar(255) DEFAULT NULL,
  243. `lastLoggedIn` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  244. `doctor` int(11) NOT NULL,
  245. PRIMARY KEY (`patientId`),
  246. UNIQUE KEY `patientUsername` (`patientUsername`),
  247. KEY `doctor` (`doctor`)
  248. ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
  249. /*!40101 SET character_set_client = @saved_cs_client */;
  250.  
  251. --
  252. -- Dumping data for table `Patient`
  253. --
  254.  
  255. LOCK TABLES `Patient` WRITE;
  256. /*!40000 ALTER TABLE `Patient` DISABLE KEYS */;
  257. INSERT INTO `Patient` VALUES (6,'@','Emil','7110eda4d09e062aa5e4a390b0a572ac0d2c0220','1e9b56f18e61ac0334925a189ff0737a107948fc','2011-08-27 10:50:08',1),(7,'aaa','aaa','7e240de74fb1ed08fa08d38063f6a6a91462a815',NULL,'2011-09-11 14:52:05',1);
  258. /*!40000 ALTER TABLE `Patient` ENABLE KEYS */;
  259. UNLOCK TABLES;
  260.  
  261. --
  262. -- Table structure for table `PatientModule`
  263. --
  264.  
  265. DROP TABLE IF EXISTS `PatientModule`;
  266. /*!40101 SET @saved_cs_client = @@character_set_client */;
  267. /*!40101 SET character_set_client = utf8 */;
  268. CREATE TABLE `PatientModule` (
  269. `patientModuleId` int(11) NOT NULL AUTO_INCREMENT,
  270. `patientModuleName` varchar(255) NOT NULL,
  271. `patientCompleted` tinyint(1) NOT NULL DEFAULT '0',
  272. `treatment` int(11) NOT NULL,
  273. PRIMARY KEY (`patientModuleId`),
  274. KEY `treatment` (`treatment`),
  275. CONSTRAINT `PatientModule_ibfk_1` FOREIGN KEY (`treatment`) REFERENCES `PatientTreatment` (`patientTreatmentId`) ON DELETE CASCADE ON UPDATE CASCADE
  276. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  277. /*!40101 SET character_set_client = @saved_cs_client */;
  278.  
  279. --
  280. -- Dumping data for table `PatientModule`
  281. --
  282.  
  283. LOCK TABLES `PatientModule` WRITE;
  284. /*!40000 ALTER TABLE `PatientModule` DISABLE KEYS */;
  285. /*!40000 ALTER TABLE `PatientModule` ENABLE KEYS */;
  286. UNLOCK TABLES;
  287.  
  288. --
  289. -- Table structure for table `Form`
  290. --
  291.  
  292. DROP TABLE IF EXISTS `Form`;
  293. /*!40101 SET @saved_cs_client = @@character_set_client */;
  294. /*!40101 SET character_set_client = utf8 */;
  295. CREATE TABLE `Form` (
  296. `formId` int(11) NOT NULL AUTO_INCREMENT,
  297. `uploadDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  298. `formXML` varchar(5000) DEFAULT NULL,
  299. `ownerName` varchar(150) DEFAULT NULL,
  300. PRIMARY KEY (`formId`)
  301. ) ENGINE=MyISAM AUTO_INCREMENT=46 DEFAULT CHARSET=latin1;
  302. /*!40101 SET character_set_client = @saved_cs_client */;
  303.  
  304. --
  305. -- Dumping data for table `Form`
  306. --
  307.  
  308. LOCK TABLES `Form` WRITE;
  309. /*!40000 ALTER TABLE `Form` DISABLE KEYS */;
  310. INSERT INTO `Form` VALUES (14,'2011-07-21 10:39:30','<form><title>Mitt formulär</title><intro>Ingen inledande text angiven</intro><element><type>textone</type><question>Fråga ej angiven</question></element><element><type>textmulti</type><question>Fråga ej angiven</question></element><element><type>multichoice</type><question>Fråga ej angiven</question><option>Alternativ 1</option><option>Alternativ 2</option><option>Alternativ 3</option></element><element><type>checkboxes</type><question>Fråga ej angiven</question><option>Alternativ 1</option><option>Alternativ 2</option><option>Alternativ 3</option><option>Alternativ 4</option></element></form>','Olof'),(17,'2011-07-21 11:24:54','<form><title>Ingen titel angiven</title><intro>Ingen inledande text angiven</intro><element><type>textone</type><question>Fråga ej angiven</question></element><element><type>textmulti</type><question>Fråga ej angiven</question></element><element><type>multichoice</type><question>Fråga ej angiven</question><option>Alternativ 1</option><option>Alternativ 2</option><option>Alternativ 3</option></element></form>','Olof'),(41,'2011-08-27 12:03:15','<form><title>Ett nytt formulär</title><intro>Ingen inledande text angiven</intro><element><type>textmulti</type><question>Fråga ej angiven</question></element><element><type>checkboxes</type><question>Fråga ej angiven</question><option>Alternativ 1</option><option>Alternativ 2</option><option>Alternativ 3</option><option>Alternativ 4</option></element><element><type>textone</type><question>Fråga ej angiven</question></element><element><type>multichoice</type><question>Fråga ej angiven</question><option>Alternativ 1</option><option>Alternativ 2</option><option>Alternativ 3</option><option>Alternativ 4</option></element></form>','Freud'),(42,'2011-09-11 09:31:48','<form><title>Ingen titel angiven</title><intro>Ingen inledande text angiven</intro></form>','Freud'),(43,'2011-09-11 09:40:40','<form><title>Ingen titel angiven</title><intro>Ingen inledande text angiven</intro><element><type>scale</type><question>Fråga ej angiven</question><scale-from>Ett</scale-from><scale-to>Fem</scale-to><nbr-radio>5</nbr-radio></element></form>','Freud'),(44,'2011-09-11 11:19:42','<form><title>Nytt</title><intro>Ingen inledande text angiven</intro><element><type>scale</type><question>Fråga ej angiven</question><scale-from>Ett</scale-from><scale-to>Fem</scale-to><nbr-radio>5</nbr-radio></element></form>','Freud'),(45,'2011-09-11 13:08:43','<form><title>Ingen titel angiven</title><intro>Ingen inledande text angiven</intro><element><type>scale</type><question>Fråga ej angiven</question><scale-from>från</scale-from><scale-to>till</scale-to><nbr-radio>9</nbr-radio></element></form>','Freud');
  311. /*!40000 ALTER TABLE `Form` ENABLE KEYS */;
  312. UNLOCK TABLES;
  313.  
  314. --
  315. -- Table structure for table `PatientChapter`
  316. --
  317.  
  318. DROP TABLE IF EXISTS `PatientChapter`;
  319. /*!40101 SET @saved_cs_client = @@character_set_client */;
  320. /*!40101 SET character_set_client = utf8 */;
  321. CREATE TABLE `PatientChapter` (
  322. `patientChapterId` int(11) NOT NULL AUTO_INCREMENT,
  323. `patientChapterName` varchar(255) NOT NULL,
  324. `patientChapterPosition` int(11) NOT NULL,
  325. `module` int(11) NOT NULL,
  326. PRIMARY KEY (`patientChapterId`),
  327. KEY `module` (`module`),
  328. CONSTRAINT `PatientChapter_ibfk_1` FOREIGN KEY (`module`) REFERENCES `PatientModule` (`patientModuleId`) ON DELETE CASCADE ON UPDATE CASCADE
  329. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  330. /*!40101 SET character_set_client = @saved_cs_client */;
  331.  
  332. --
  333. -- Dumping data for table `PatientChapter`
  334. --
  335.  
  336. LOCK TABLES `PatientChapter` WRITE;
  337. /*!40000 ALTER TABLE `PatientChapter` DISABLE KEYS */;
  338. /*!40000 ALTER TABLE `PatientChapter` ENABLE KEYS */;
  339. UNLOCK TABLES;
  340.  
  341. --
  342. -- Table structure for table `PatientTreatment`
  343. --
  344.  
  345. DROP TABLE IF EXISTS `PatientTreatment`;
  346. /*!40101 SET @saved_cs_client = @@character_set_client */;
  347. /*!40101 SET character_set_client = utf8 */;
  348. CREATE TABLE `PatientTreatment` (
  349. `patientTreatmentId` int(11) NOT NULL AUTO_INCREMENT,
  350. `patientTreatmentName` varchar(255) NOT NULL,
  351. `patient` int(11) NOT NULL,
  352. PRIMARY KEY (`patientTreatmentId`),
  353. KEY `patient` (`patient`),
  354. CONSTRAINT `PatientTreatment_ibfk_1` FOREIGN KEY (`patient`) REFERENCES `Patient` (`patientId`) ON DELETE CASCADE ON UPDATE CASCADE
  355. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  356. /*!40101 SET character_set_client = @saved_cs_client */;
  357.  
  358. --
  359. -- Dumping data for table `PatientTreatment`
  360. --
  361.  
  362. LOCK TABLES `PatientTreatment` WRITE;
  363. /*!40000 ALTER TABLE `PatientTreatment` DISABLE KEYS */;
  364. /*!40000 ALTER TABLE `PatientTreatment` ENABLE KEYS */;
  365. UNLOCK TABLES;
  366.  
  367. --
  368. -- Table structure for table `PatientsFiles`
  369. --
  370.  
  371. DROP TABLE IF EXISTS `PatientsFiles`;
  372. /*!40101 SET @saved_cs_client = @@character_set_client */;
  373. /*!40101 SET character_set_client = utf8 */;
  374. CREATE TABLE `PatientsFiles` (
  375. `patientId` int(11) NOT NULL,
  376. `fileId` int(11) NOT NULL,
  377. `fileBeenLoadedByPatient` int(11) NOT NULL,
  378. KEY `patientId` (`patientId`),
  379. KEY `fileId` (`fileId`)
  380. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  381. /*!40101 SET character_set_client = @saved_cs_client */;
  382.  
  383. --
  384. -- Dumping data for table `PatientsFiles`
  385. --
  386.  
  387. LOCK TABLES `PatientsFiles` WRITE;
  388. /*!40000 ALTER TABLE `PatientsFiles` DISABLE KEYS */;
  389. /*!40000 ALTER TABLE `PatientsFiles` ENABLE KEYS */;
  390. UNLOCK TABLES;
  391.  
  392. --
  393. -- Table structure for table `DoctorOneTimePasswords`
  394. --
  395.  
  396. DROP TABLE IF EXISTS `DoctorOneTimePasswords`;
  397. /*!40101 SET @saved_cs_client = @@character_set_client */;
  398. /*!40101 SET character_set_client = utf8 */;
  399. CREATE TABLE `DoctorOneTimePasswords` (
  400. `doctorId` int(11) NOT NULL,
  401. `password` varchar(150) DEFAULT NULL,
  402. `passwordNumber` int(11) NOT NULL,
  403. KEY `doctorId` (`doctorId`)
  404. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  405. /*!40101 SET character_set_client = @saved_cs_client */;
  406.  
  407. --
  408. -- Dumping data for table `DoctorOneTimePasswords`
  409. --
  410.  
  411. LOCK TABLES `DoctorOneTimePasswords` WRITE;
  412. /*!40000 ALTER TABLE `DoctorOneTimePasswords` DISABLE KEYS */;
  413. INSERT INTO `DoctorOneTimePasswords` VALUES (1,'106beee0b15077b83b0f794be8bebd0138e7ee52',77),(1,'eba07745ab22aa83b56830db65789edfa8ee043d',78),(1,'0421500fbb194a8e3a979cf8f1d3917a0eb0bbea',79),(1,'4148591c1030fc45497a22b6574f7ba4c278ac00',80),(1,'bf203c3a2677632b2cb164a0e706f98e1d03f49c',81),(1,'d95c4d4a3fdc6c4c414c6eb79df8e287998f64f8',82),(1,'a1de3e519127f04dfc9d816fffbd8bd0b22a089e',83),(1,'ec523e61ae2c72efad95f907ee4e893a427737a0',84),(1,'5fa450cb56318fc542821404a2d8f92ce7214890',85),(1,'bc7e6836de0efbffdebfc0e8c22a0f3acafc7a08',86),(1,'6da08aaeb9cac4c208305c2b34e4b300b35ac8f0',87),(1,'922ed5901ef57c506d2a0c6ad87e03c382919a92',88),(1,'99e5e568c62c482a273776d560c4c8fc9107cdb0',89),(1,'482049591fcde1b2bb55011b2dce2c6e02a4b246',90),(1,'aed0bdacbcae017b9f1ac8bb7f1358e775f46009',91),(1,'2c631e6da16a5fbd5273a832dcab1d1a16e0b885',92),(1,'b78aba42f32a2ba7b35f24c3b2f530f38102ef01',93),(1,'c4cb36f7fcd429495291fc972ca0fabde5ac0fc4',94),(1,'4b38c158162a88dcdc7d2ef75b22c9374d735b9d',95),(1,'f5f621c30e621df8674bd797d51b1b0db5798531',96),(1,'f88ca1e6ab45230e9cbc367f9fd6711759c48fa4',97),(1,'841c7741efbbe3e4f0bcc6392da37f99ba0c4026',98),(1,'17e13a8817dcb6542c54c08256887c45f7b9a998',99),(1,'08933d984ab3130c70f194fd8c37881975e43db6',100);
  414. /*!40000 ALTER TABLE `DoctorOneTimePasswords` ENABLE KEYS */;
  415. UNLOCK TABLES;
  416.  
  417. --
  418. -- Table structure for table `Message`
  419. --
  420.  
  421. DROP TABLE IF EXISTS `Message`;
  422. /*!40101 SET @saved_cs_client = @@character_set_client */;
  423. /*!40101 SET character_set_client = utf8 */;
  424. CREATE TABLE `Message` (
  425. `messageId` int(11) NOT NULL AUTO_INCREMENT,
  426. `sentDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  427. `senderName` varchar(150) DEFAULT NULL,
  428. `recieverName` varchar(150) DEFAULT NULL,
  429. `messSubject` varchar(300) DEFAULT NULL,
  430. `messText` varchar(2000) DEFAULT NULL,
  431. `readByRec` int(11) DEFAULT NULL,
  432. PRIMARY KEY (`messageId`)
  433. ) ENGINE=MyISAM AUTO_INCREMENT=58 DEFAULT CHARSET=latin1;
  434. /*!40101 SET character_set_client = @saved_cs_client */;
  435.  
  436. --
  437. -- Dumping data for table `Message`
  438. --
  439.  
  440. LOCK TABLES `Message` WRITE;
  441. /*!40000 ALTER TABLE `Message` DISABLE KEYS */;
  442. INSERT INTO `Message` VALUES (17,'2011-06-23 11:10:40','Anders','Teknisk support','support','Nu skriver vi lite för att testa om meddelandet går fram',0),(2,'2011-06-22 13:55:03','admin','Emil',NULL,'Har nu skickat ett',1),(3,'2011-06-22 13:58:20','admin','Freud',NULL,'hej på dej',1),(4,'2011-06-22 13:59:14','admin','Mia',NULL,'En till',0),(5,'2011-06-22 14:13:28','admin','Anders','angående','lite text',1),(6,'2011-06-23 08:35:10','Mia','Teknisk support','teknisk support','text',0),(7,'2011-06-23 08:47:31','admin','Mia','testar att skicka','text',0),(8,'2011-06-23 08:48:34','MIa','Freud','text till freud','text',1),(9,'2011-06-23 09:15:37','Freud','Kalle','Till kalle','text',0),(10,'2011-06-23 09:16:12','Kalle','Freud','TIll freud','Text',1),(11,'2011-06-23 10:40:40','mia','Professor Lund','angående','Här skriver vi snabbt lite text och skickar iväg i ett huj',0),(12,'2011-06-23 10:47:01','admin','Mia','Hänt i veckan','VI tar och skriver lite text här bara för att testa',0),(13,'2011-06-23 10:48:53','Professor Lund','Mia','angående','Lite mer text skickar vi så att det syns i rutan',0),(14,'2011-06-23 10:50:57','admin','Freud','Ett skepp kommer lastat','Ett skepp kommer lastat med lite text',1),(15,'2011-06-23 10:54:24','Freud','Emil','Här får du ett meddelande','Med lite text som vi skickar för att testa',1),(16,'2011-06-23 10:58:48','Mia','Teknisk support','behöver support','Nu behöver vi lite assistans ',0),(18,'2011-06-24 12:42:13','admin','Kalle','Här kommer ett','Här kommer ett meddelande skickat ',0),(19,'2011-06-24 12:43:55','admin','Professor Lund','Testar igen','Vi testar och skicka ett nytt meddelande',0),(20,'2011-07-05 12:17:28','Emil','Teknisk support','Hej','hej',0),(21,'2011-07-05 13:58:25','Olof','Anders','Hej ','Hej',1),(22,'2011-07-14 22:46:47','Olof','Anders','Hej','Hej hopp',1),(23,'2011-07-15 08:40:41','Freud','Emil','Nytt','Nytt',1),(24,'2011-07-25 09:22:06','Emil','Freud','Svar på formulär: Fråge formulär','nullFråge formulär\nIngen inledande text angiven\n',1),(25,'2011-07-25 09:26:57','Emil','Freud','Svar på formulär: Fråge formulär','Fråge formulär\nIngen inledande text angiven\n',1),(26,'2011-07-25 09:29:25','Emil','Freud','Svar på formulär: Fråge formulär','Fråge formulär\nIngen inledande text angiven\n1',1),(27,'2011-07-25 09:39:09','Emil','Freud','Svar på formulär: Fråge formulär','Fråge formulär<br>Ingen inledande text angiven<br>1Vad tycker du?<br>Vet inte<br>',1),(28,'2011-07-25 09:41:10','Emil','Freud','Svar på formulär: Fråge formulär','Fråge formulär<br>Ingen inledande text angiven<br>1Vad tycker du?<br>Här är mitt svar<br>',1),(29,'2011-07-25 09:49:00','Emil','Freud','Svar på formulär: Nytt formulär','Nytt formulär<br>Här skiver vi lite text för att beskriva formulärets innehåll<br>En rads fråga?<br>Svar: Här är mitt svar på en rad<br>Flerrads Fråga?<br>Svar: Här är mitt svar på flera rader....<br>',1),(30,'2011-07-25 09:56:42','Emil','Freud','Svar på formulär: Mitt formulär','Mitt formulär<br>Ingen inledande text angiven<br>Fråga 1<br>Svar: Här är svar på fråga 1<br>Fråga 2<br>Svar: Här är svar på fråga 2<br>Fråga 3<br>Valt svar: Alternativ 2<br>',1),(31,'2011-07-25 10:01:40','Emil','Freud','Svar på formulär: Mitt formulär','Mitt formulär<br>Ingen inledande text angiven<br>Fråga 1<br>Svar: Svar på fråga 1<br>Fråga 2<br>Svar: Svar på fråga 2<br>Fråga 3<br>Valt svar: Alternativ 3<br>Fråga 4<br>Valda svar: <br>Alternativ 1<br>Alternativ 2<br>Alternativ 3<br>Alternativ 4<br>Alternativ 5<br>Alternativ 6<br><br>',1),(32,'2011-07-25 10:09:09','Emil','Freud','Svar på formulär: Mitt formulär','Mitt formulär<br>Ingen inledande text angiven<br>Fråga 1<br>Svar: asdflkasdölfkjödfflk<br>Fråga 2<br>Svar: adöalskdjfölaskjdflökasd<br>Fråga 3<br>Valt svar: Alternativ 2<br>Fråga 4<br>Valda svar: <br>Alternativ 1<br>Alternativ 3<br>Alternativ 5<br><br>',1),(33,'2011-07-25 10:11:12','Emil','Freud','Svar på formulär: Mitt formulär','Mitt formulär<br>Ingen inledande text angiven<br>Fråga 1<br>Svar: sdef<br>Fråga 2<br>Svar: asdfasdf<br>Fråga 3<br>Valt svar: Alternativ 4<br>Fråga 4<br>Valda svar: <br>Alternativ 1<br><br>',1),(34,'2011-07-25 10:17:57','Emil','Freud','Svar på formulär: Fråge formulär','Fråge formulär<br>Ingen inledande text angiven<br>Vad tycker du?<br>Svar: <br>',1),(35,'2011-07-26 10:43:41','Emil','Freud','Svar på formulär: Mitt formulär','Mitt formulär<br>Ingen inledande text angiven<br>Fråga 1<br>Svar: aaaaaaaa<br>Fråga 2<br>Svar: aaaaaaaaaaaa<br>Fråga 3<br>Valt svar: Alternativ 1<br>Fråga 4<br>Valda svar: <br>Alternativ 6<br><br>',1),(36,'2011-07-26 12:08:56','Freud','Emil','Hej ','Hej Hej',1),(37,'2011-07-26 12:10:13','Emil','Freud','Svar på formulär: Mitt formulär','Mitt formulär<br>Ingen inledande text angiven<br>Fråga 1<br>Svar: Svar<br>Fråga 2<br>Svar: asdfasdgasd<br>Fråga 3<br>Valt svar: Alternativ 1<br>Fråga 4<br>Valda svar: <br>Alternativ 2<br>Alternativ 3<br>Alternativ 4<br>Alternativ 5<br><br>',1),(38,'2011-07-26 12:13:40','Emil','Freud','Svar på formulär: Ett nytt till Emil','Ett nytt till Emil<br>Ingen inledande text angiven<br>Fråga 1<br>Svar: dfagsadfg<br>Fråga 2<br>Svar: asdfgsdfhsdfhsdfhsdfh<br>Fråga 3<br>Valt svar: Alternativ 2<br>Fråga 4<br>Valda svar: <br>Alternativ 1<br>Alternativ 3<br>Alternativ 5<br>Alternativ 7<br>Alternativ 8<br><br>',1),(39,'2011-07-26 12:20:47','Emil','Freud','Svar på formulär: Ett nytt till Emil','Ett nytt till Emil<br>Ingen inledande text angiven<br>Fråga 1<br>Svar: mitt svar 1<br>Fråga 2<br>Svar: mitt svar 2<br>Fråga 3<br>Valt svar: Alternativ 2<br>Fråga 4<br>Valda svar: <br>Alternativ 2<br>Alternativ 3<br><br>',1),(40,'2011-07-26 18:27:07','Emil','Freud','Svar på formulär: Ett nytt till Emil','Ett nytt till Emil<br>Ingen inledande text angiven<br>Fråga 1<br>Svar: jkjlhkjh<br>Fråga 2<br>Svar: ölkjölkjölk<br>Fråga 3<br>Valt svar: Alternativ 2<br>Fråga 4<br>Valda svar: <br>Alternativ 1<br>Alternativ 3<br><br>',1),(41,'2011-07-27 17:09:07','Anders','Freud','Svar på formulär: Ett nytt till Emil','Ett nytt till Emil<br>Ingen inledande text angiven<br>Fråga 1<br>Svar: nsdfgnfgn<br>Fråga 2<br>Svar: szdfbsdfbsdf<br>Fråga 3<br>Valt svar: null<br>Fråga 4<br>Valda svar: <br>Alternativ 1<br>Alternativ 2<br>Alternativ 3<br><br>',1),(42,'2011-07-29 11:37:32','Anders','Freud','Svar på formulär: Nytt','Nytt<br>Ingen inledande text angiven<br>Fråga ej angiven<br>Svar: efewfqwefqewf<br>Fråga ej angiven<br>Svar: ergerwregregr<br>Fråga ej angiven<br>Valt svar: Alternativ 2<br>',1),(43,'2011-08-13 11:00:54','Emil','Teknisk support','Hej','Hej',0),(44,'2011-08-13 11:02:21','Emil','Teknisk support','','',0),(45,'2011-08-13 11:04:12','Emil','Teknisk support','Hej','Hej',0),(46,'2011-08-20 07:37:16','Freud','Emil','Hej','Hej',1),(47,'2011-08-20 07:44:22','Freud','Emil','Hej igen','Hej Igen',1),(48,'2011-08-20 08:00:08','Emil','Freud','Svar på formulär: Ett nytt till Emil','Ett nytt till Emil<br>Ingen inledande text angiven<br>Fråga ej angiven<br>Svar: svar 1<br>Fråga ej angiven<br>Valt svar: Alternativ 2<br>Fråga ej angiven<br>Svar: svar 2<br>',1),(49,'2011-08-20 08:02:33','Freud','Emil','Hej','Bra svar',1),(50,'2011-08-27 10:50:28','admin','Emil','Hej ','Hej igen',1),(51,'2011-08-27 10:53:09','admin','Emil','Hej ','Hej igen',1),(52,'2011-08-27 10:54:32','admin','Freud','Skickar igen','Skickar igen',1),(53,'2011-08-27 12:05:00','Emil','Freud','Svar på formulär: Ett nytt formulär','Ett nytt formulär<br>Ingen inledande text angiven<br>Fråga ej angiven<br>Svar: saölsdkfjöalsdkfja<br>Fråga ej angiven<br>Valda svar: <br>Alternativ 1<br>Alternativ 2<br>Alternativ 3<br>Alternativ 4<br><br>Fråga ej angiven<br>Svar: sdfasdgasdga<br>Fråga ej angiven<br>Valt svar: Alternativ 3<br>',1),(54,'2011-08-27 12:07:27','Emil','Freud','Svar på formulär: Ett nytt formulär','Ett nytt formulär<br>Ingen inledande text angiven<br>Fråga ej angiven<br>Svar: aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa<br>Fråga ej angiven<br>Valda svar: <br>Alternativ 1<br>Alternativ 2<br>Alternativ 3<br><br>Fråga ej angiven<br>Svar: aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa<br>Fråga ej angiven<br>Valt svar: Alternativ 2<br>',1),(55,'2011-09-11 11:30:22','Emil','Freud','Svar på formulär: Nytt','Nytt<br>Ingen inledande text angiven<br>Fråga ej angiven<br>Valda svar: 2<br>',1),(56,'2011-09-11 11:33:19','Emil','Freud','Svar på formulär: Nytt','Nytt<br>Ingen inledande text angiven<br>Fråga ej angiven<br>Valda svar: 2<br>',1),(57,'2011-09-11 13:09:46','Emil','Freud','Svar på formulär: Nytt','Nytt<br>Ingen inledande text angiven<br>Fråga ej angiven<br>Valda svar: 3<br>',0);
  443. /*!40000 ALTER TABLE `Message` ENABLE KEYS */;
  444. UNLOCK TABLES;
  445.  
  446. --
  447. -- Dumping routines for database 'melencolia'
  448. --
  449. /*!50003 DROP FUNCTION IF EXISTS `checkAdminCurrOneTimePassword` */;
  450. /*!50003 SET @saved_cs_client = @@character_set_client */ ;
  451. /*!50003 SET @saved_cs_results = @@character_set_results */ ;
  452. /*!50003 SET @saved_col_connection = @@collation_connection */ ;
  453. /*!50003 SET character_set_client = utf8 */ ;
  454. /*!50003 SET character_set_results = utf8 */ ;
  455. /*!50003 SET collation_connection = utf8_general_ci */ ;
  456. /*!50003 SET @saved_sql_mode = @@sql_mode */ ;
  457. /*!50003 SET sql_mode = '' */ ;
  458. DELIMITER ;;
  459. /*!50003 CREATE*/ /*!50020 DEFINER=`root`@`localhost`*/ /*!50003 FUNCTION `checkAdminCurrOneTimePassword`(p_adminUsername varchar(150), p_password varchar(150)) RETURNS int(11)
  460. begin
  461. declare found int;
  462. declare result int;
  463. SELECT count(*) INTO found FROM Admin WHERE p_adminUsername=adminUsername AND tempAdminOneTimePassword=p_password;
  464. if found = 1 then
  465. SET result=1;
  466. else
  467. SET result=0;
  468. end if;
  469. return result;
  470. end */;;
  471. DELIMITER ;
  472. /*!50003 SET sql_mode = @saved_sql_mode */ ;
  473. /*!50003 SET character_set_client = @saved_cs_client */ ;
  474. /*!50003 SET character_set_results = @saved_cs_results */ ;
  475. /*!50003 SET collation_connection = @saved_col_connection */ ;
  476. /*!50003 DROP FUNCTION IF EXISTS `checkDoctorCurrOneTimePassword` */;
  477. /*!50003 SET @saved_cs_client = @@character_set_client */ ;
  478. /*!50003 SET @saved_cs_results = @@character_set_results */ ;
  479. /*!50003 SET @saved_col_connection = @@collation_connection */ ;
  480. /*!50003 SET character_set_client = utf8 */ ;
  481. /*!50003 SET character_set_results = utf8 */ ;
  482. /*!50003 SET collation_connection = utf8_general_ci */ ;
  483. /*!50003 SET @saved_sql_mode = @@sql_mode */ ;
  484. /*!50003 SET sql_mode = '' */ ;
  485. DELIMITER ;;
  486. /*!50003 CREATE*/ /*!50020 DEFINER=`root`@`localhost`*/ /*!50003 FUNCTION `checkDoctorCurrOneTimePassword`(p_doctorUsername varchar(150), p_password varchar(150)) RETURNS int(11)
  487. begin
  488. declare found int;
  489. declare result int;
  490. SELECT count(*) INTO found FROM Doctor WHERE p_doctorUsername=doctorUsername AND tempDoctorOneTimePassword=p_password;
  491. if found = 1 then
  492. SET result=1;
  493. else
  494. SET result=0;
  495. end if;
  496. return result;
  497. end */;;
  498. DELIMITER ;
  499. /*!50003 SET sql_mode = @saved_sql_mode */ ;
  500. /*!50003 SET character_set_client = @saved_cs_client */ ;
  501. /*!50003 SET character_set_results = @saved_cs_results */ ;
  502. /*!50003 SET collation_connection = @saved_col_connection */ ;
  503. /*!50003 DROP FUNCTION IF EXISTS `checkPatientCurrOneTimePassword` */;
  504. /*!50003 SET @saved_cs_client = @@character_set_client */ ;
  505. /*!50003 SET @saved_cs_results = @@character_set_results */ ;
  506. /*!50003 SET @saved_col_connection = @@collation_connection */ ;
  507. /*!50003 SET character_set_client = utf8 */ ;
  508. /*!50003 SET character_set_results = utf8 */ ;
  509. /*!50003 SET collation_connection = utf8_general_ci */ ;
  510. /*!50003 SET @saved_sql_mode = @@sql_mode */ ;
  511. /*!50003 SET sql_mode = '' */ ;
  512. DELIMITER ;;
  513. /*!50003 CREATE*/ /*!50020 DEFINER=`root`@`localhost`*/ /*!50003 FUNCTION `checkPatientCurrOneTimePassword`(p_patientUsername varchar(150), p_password varchar(150)) RETURNS int(11)
  514. begin
  515. declare found int;
  516. declare result int;
  517. SELECT count(*) INTO found FROM Patient WHERE p_patientUsername=patientUsername AND tempPatientOneTimePassword=p_password;
  518. if found = 1 then
  519. SET result=1;
  520. else
  521. SET result=0;
  522. end if;
  523. return result;
  524. end */;;
  525. DELIMITER ;
  526. /*!50003 SET sql_mode = @saved_sql_mode */ ;
  527. /*!50003 SET character_set_client = @saved_cs_client */ ;
  528. /*!50003 SET character_set_results = @saved_cs_results */ ;
  529. /*!50003 SET collation_connection = @saved_col_connection */ ;
  530. /*!50003 DROP FUNCTION IF EXISTS `loginAdmin` */;
  531. /*!50003 SET @saved_cs_client = @@character_set_client */ ;
  532. /*!50003 SET @saved_cs_results = @@character_set_results */ ;
  533. /*!50003 SET @saved_col_connection = @@collation_connection */ ;
  534. /*!50003 SET character_set_client = utf8 */ ;
  535. /*!50003 SET character_set_results = utf8 */ ;
  536. /*!50003 SET collation_connection = utf8_general_ci */ ;
  537. /*!50003 SET @saved_sql_mode = @@sql_mode */ ;
  538. /*!50003 SET sql_mode = '' */ ;
  539. DELIMITER ;;
  540. /*!50003 CREATE*/ /*!50020 DEFINER=`root`@`localhost`*/ /*!50003 FUNCTION `loginAdmin`(p_adminUsername varchar(100), p_adminPassword varchar(100)) RETURNS int(11)
  541. begin
  542. declare found int;
  543. select count(*) into found from Admin where adminUsername = p_adminUsername and adminPassword = p_adminPassword;
  544. if found = 1 then
  545. return 1;
  546. elseif found > 1 then
  547. return 2;
  548. else
  549. return 0;
  550. end if;
  551. end */;;
  552. DELIMITER ;
  553. /*!50003 SET sql_mode = @saved_sql_mode */ ;
  554. /*!50003 SET character_set_client = @saved_cs_client */ ;
  555. /*!50003 SET character_set_results = @saved_cs_results */ ;
  556. /*!50003 SET collation_connection = @saved_col_connection */ ;
  557. /*!50003 DROP FUNCTION IF EXISTS `loginAdminOneTimePasswords` */;
  558. /*!50003 SET @saved_cs_client = @@character_set_client */ ;
  559. /*!50003 SET @saved_cs_results = @@character_set_results */ ;
  560. /*!50003 SET @saved_col_connection = @@collation_connection */ ;
  561. /*!50003 SET character_set_client = utf8 */ ;
  562. /*!50003 SET character_set_results = utf8 */ ;
  563. /*!50003 SET collation_connection = utf8_general_ci */ ;
  564. /*!50003 SET @saved_sql_mode = @@sql_mode */ ;
  565. /*!50003 SET sql_mode = '' */ ;
  566. DELIMITER ;;
  567. /*!50003 CREATE*/ /*!50020 DEFINER=`root`@`localhost`*/ /*!50003 FUNCTION `loginAdminOneTimePasswords`(p_adminId int, p_password varchar(150)) RETURNS int(11)
  568. begin
  569. declare currPasswordNumber int;
  570. declare found int;
  571. declare result int;
  572. declare currOneTimePassword varchar(150);
  573. SELECT MIN(passwordNumber) INTO currPasswordNumber FROM AdminOneTimePasswords WHERE adminId=p_adminId;
  574. SELECT count(*) INTO found FROM AdminOneTimePasswords WHERE p_adminId = adminId AND currPasswordNumber=passwordNumber AND p_password=password;
  575. if found = 1 then
  576. SET result=1;
  577. SELECT password INTO currOneTimePassword FROM AdminOneTimePasswords WHERE passwordNumber=currPasswordNumber AND adminId=p_adminId;
  578. UPDATE Admin SET tempAdminOneTimePassword=currOneTimePassword WHERE adminId=p_adminId;
  579. else
  580. SET result=0;
  581. end if;
  582. DELETE FROM AdminOneTimePasswords WHERE passwordNumber=currPasswordNumber AND adminId=p_adminId;
  583. return result;
  584. end */;;
  585. DELIMITER ;
  586. /*!50003 SET sql_mode = @saved_sql_mode */ ;
  587. /*!50003 SET character_set_client = @saved_cs_client */ ;
  588. /*!50003 SET character_set_results = @saved_cs_results */ ;
  589. /*!50003 SET collation_connection = @saved_col_connection */ ;
  590. /*!50003 DROP FUNCTION IF EXISTS `loginDoctor` */;
  591. /*!50003 SET @saved_cs_client = @@character_set_client */ ;
  592. /*!50003 SET @saved_cs_results = @@character_set_results */ ;
  593. /*!50003 SET @saved_col_connection = @@collation_connection */ ;
  594. /*!50003 SET character_set_client = utf8 */ ;
  595. /*!50003 SET character_set_results = utf8 */ ;
  596. /*!50003 SET collation_connection = utf8_general_ci */ ;
  597. /*!50003 SET @saved_sql_mode = @@sql_mode */ ;
  598. /*!50003 SET sql_mode = '' */ ;
  599. DELIMITER ;;
  600. /*!50003 CREATE*/ /*!50020 DEFINER=`root`@`localhost`*/ /*!50003 FUNCTION `loginDoctor`(p_doctorUsername varchar(100), p_doctorPassword varchar(100)) RETURNS int(11)
  601. begin
  602. declare found int;
  603. select count(*) into found from Doctor where doctorUsername = p_doctorUsername and doctorPassword = p_doctorPassword;
  604. if found = 1 then
  605. return 1;
  606. elseif found > 1 then
  607. return 2;
  608. else
  609. return 0;
  610. end if;
  611. end */;;
  612. DELIMITER ;
  613. /*!50003 SET sql_mode = @saved_sql_mode */ ;
  614. /*!50003 SET character_set_client = @saved_cs_client */ ;
  615. /*!50003 SET character_set_results = @saved_cs_results */ ;
  616. /*!50003 SET collation_connection = @saved_col_connection */ ;
  617. /*!50003 DROP FUNCTION IF EXISTS `loginDoctorOneTimePasswords` */;
  618. /*!50003 SET @saved_cs_client = @@character_set_client */ ;
  619. /*!50003 SET @saved_cs_results = @@character_set_results */ ;
  620. /*!50003 SET @saved_col_connection = @@collation_connection */ ;
  621. /*!50003 SET character_set_client = utf8 */ ;
  622. /*!50003 SET character_set_results = utf8 */ ;
  623. /*!50003 SET collation_connection = utf8_general_ci */ ;
  624. /*!50003 SET @saved_sql_mode = @@sql_mode */ ;
  625. /*!50003 SET sql_mode = '' */ ;
  626. DELIMITER ;;
  627. /*!50003 CREATE*/ /*!50020 DEFINER=`root`@`localhost`*/ /*!50003 FUNCTION `loginDoctorOneTimePasswords`(p_doctorId int, p_password varchar(150)) RETURNS int(11)
  628. begin
  629. declare currPasswordNumber int;
  630. declare found int;
  631. declare result int;
  632. declare currOneTimePassword varchar(150);
  633. SELECT MIN(passwordNumber) INTO currPasswordNumber FROM DoctorOneTimePasswords WHERE doctorId=p_doctorId;
  634. SELECT count(*) INTO found FROM DoctorOneTimePasswords WHERE p_doctorId = doctorId AND currPasswordNumber=passwordNumber AND p_password=password;
  635. if found = 1 then
  636. SET result=1;
  637. SELECT password INTO currOneTimePassword FROM DoctorOneTimePasswords WHERE passwordNumber=currPasswordNumber AND doctorId=p_doctorId;
  638. UPDATE Doctor SET tempDoctorOneTimePassword=currOneTimePassword WHERE doctorId=p_doctorId;
  639. else
  640. SET result=0;
  641. end if;
  642. DELETE FROM DoctorOneTimePasswords WHERE passwordNumber=currPasswordNumber AND doctorId=p_doctorId;
  643. return result;
  644. end */;;
  645. DELIMITER ;
  646. /*!50003 SET sql_mode = @saved_sql_mode */ ;
  647. /*!50003 SET character_set_client = @saved_cs_client */ ;
  648. /*!50003 SET character_set_results = @saved_cs_results */ ;
  649. /*!50003 SET collation_connection = @saved_col_connection */ ;
  650. /*!50003 DROP FUNCTION IF EXISTS `loginPatient` */;
  651. /*!50003 SET @saved_cs_client = @@character_set_client */ ;
  652. /*!50003 SET @saved_cs_results = @@character_set_results */ ;
  653. /*!50003 SET @saved_col_connection = @@collation_connection */ ;
  654. /*!50003 SET character_set_client = utf8 */ ;
  655. /*!50003 SET character_set_results = utf8 */ ;
  656. /*!50003 SET collation_connection = utf8_general_ci */ ;
  657. /*!50003 SET @saved_sql_mode = @@sql_mode */ ;
  658. /*!50003 SET sql_mode = '' */ ;
  659. DELIMITER ;;
  660. /*!50003 CREATE*/ /*!50020 DEFINER=`root`@`localhost`*/ /*!50003 FUNCTION `loginPatient`(p_patientUsername varchar(100), p_patientPassword varchar(100)) RETURNS int(11)
  661. begin
  662. declare found int;
  663. select count(*) into found from Patient where patientUsername = p_patientUsername and patientPassword = p_patientPassword;
  664. if found = 1 then
  665. return 1;
  666. elseif found > 1 then
  667. return 2;
  668. else
  669. return 0;
  670. end if;
  671. end */;;
  672. DELIMITER ;
  673. /*!50003 SET sql_mode = @saved_sql_mode */ ;
  674. /*!50003 SET character_set_client = @saved_cs_client */ ;
  675. /*!50003 SET character_set_results = @saved_cs_results */ ;
  676. /*!50003 SET collation_connection = @saved_col_connection */ ;
  677. /*!50003 DROP FUNCTION IF EXISTS `loginPatientOneTimePasswords` */;
  678. /*!50003 SET @saved_cs_client = @@character_set_client */ ;
  679. /*!50003 SET @saved_cs_results = @@character_set_results */ ;
  680. /*!50003 SET @saved_col_connection = @@collation_connection */ ;
  681. /*!50003 SET character_set_client = utf8 */ ;
  682. /*!50003 SET character_set_results = utf8 */ ;
  683. /*!50003 SET collation_connection = utf8_general_ci */ ;
  684. /*!50003 SET @saved_sql_mode = @@sql_mode */ ;
  685. /*!50003 SET sql_mode = '' */ ;
  686. DELIMITER ;;
  687. /*!50003 CREATE*/ /*!50020 DEFINER=`root`@`localhost`*/ /*!50003 FUNCTION `loginPatientOneTimePasswords`(p_patientId int, p_password varchar(150)) RETURNS int(11)
  688. begin
  689. declare currPasswordNumber int;
  690. declare found int;
  691. declare result int;
  692. declare currOneTimePassword varchar(150);
  693. SELECT MIN(passwordNumber) INTO currPasswordNumber FROM PatientOneTimePasswords WHERE patientId=p_patientId;
  694. SELECT count(*) INTO found FROM PatientOneTimePasswords WHERE p_patientId = patientId AND currPasswordNumber=passwordNumber AND p_password=password;
  695. if found = 1 then
  696. SET result=1;
  697. SELECT password INTO currOneTimePassword FROM PatientOneTimePasswords WHERE passwordNumber=currPasswordNumber AND patientId=p_patientId;
  698. UPDATE Patient SET tempPatientOneTimePassword=currOneTimePassword WHERE patientId=p_patientId;
  699. else
  700. SET result=0;
  701. end if;
  702. DELETE FROM PatientOneTimePasswords WHERE passwordNumber=currPasswordNumber AND patientId=p_patientId;
  703. return result;
  704. end */;;
  705. DELIMITER ;
  706. /*!50003 SET sql_mode = @saved_sql_mode */ ;
  707. /*!50003 SET character_set_client = @saved_cs_client */ ;
  708. /*!50003 SET character_set_results = @saved_cs_results */ ;
  709. /*!50003 SET collation_connection = @saved_col_connection */ ;
  710. /*!50003 DROP FUNCTION IF EXISTS `numberOfAccessGivenFiles` */;
  711. /*!50003 SET @saved_cs_client = @@character_set_client */ ;
  712. /*!50003 SET @saved_cs_results = @@character_set_results */ ;
  713. /*!50003 SET @saved_col_connection = @@collation_connection */ ;
  714. /*!50003 SET character_set_client = utf8 */ ;
  715. /*!50003 SET character_set_results = utf8 */ ;
  716. /*!50003 SET collation_connection = utf8_general_ci */ ;
  717. /*!50003 SET @saved_sql_mode = @@sql_mode */ ;
  718. /*!50003 SET sql_mode = '' */ ;
  719. DELIMITER ;;
  720. /*!50003 CREATE*/ /*!50020 DEFINER=`root`@`localhost`*/ /*!50003 FUNCTION `numberOfAccessGivenFiles`(p_patientId int) RETURNS int(11)
  721. begin
  722. declare nbrFiles int;
  723. select count(*) into nbrFiles from PatientsFiles WHERE p_patientId = patientId;
  724. return nbrFiles;
  725. end */;;
  726. DELIMITER ;
  727. /*!50003 SET sql_mode = @saved_sql_mode */ ;
  728. /*!50003 SET character_set_client = @saved_cs_client */ ;
  729. /*!50003 SET character_set_results = @saved_cs_results */ ;
  730. /*!50003 SET collation_connection = @saved_col_connection */ ;
  731. /*!50003 DROP FUNCTION IF EXISTS `numberOfAccessGivenFilesLoadedByPatient` */;
  732. /*!50003 SET @saved_cs_client = @@character_set_client */ ;
  733. /*!50003 SET @saved_cs_results = @@character_set_results */ ;
  734. /*!50003 SET @saved_col_connection = @@collation_connection */ ;
  735. /*!50003 SET character_set_client = utf8 */ ;
  736. /*!50003 SET character_set_results = utf8 */ ;
  737. /*!50003 SET collation_connection = utf8_general_ci */ ;
  738. /*!50003 SET @saved_sql_mode = @@sql_mode */ ;
  739. /*!50003 SET sql_mode = '' */ ;
  740. DELIMITER ;;
  741. /*!50003 CREATE*/ /*!50020 DEFINER=`root`@`localhost`*/ /*!50003 FUNCTION `numberOfAccessGivenFilesLoadedByPatient`(p_patientId int) RETURNS int(11)
  742. begin
  743. declare nbrLoadedFiles int;
  744. select count(*) into nbrLoadedFiles from PatientsFiles where patientId = p_patientId and fileBeenLoadedByPatient = 1;
  745. return nbrLoadedFiles;
  746. end */;;
  747. DELIMITER ;
  748. /*!50003 SET sql_mode = @saved_sql_mode */ ;
  749. /*!50003 SET character_set_client = @saved_cs_client */ ;
  750. /*!50003 SET character_set_results = @saved_cs_results */ ;
  751. /*!50003 SET collation_connection = @saved_col_connection */ ;
  752. /*!50003 DROP FUNCTION IF EXISTS `numberOfNewMessages` */;
  753. /*!50003 SET @saved_cs_client = @@character_set_client */ ;
  754. /*!50003 SET @saved_cs_results = @@character_set_results */ ;
  755. /*!50003 SET @saved_col_connection = @@collation_connection */ ;
  756. /*!50003 SET character_set_client = utf8 */ ;
  757. /*!50003 SET character_set_results = utf8 */ ;
  758. /*!50003 SET collation_connection = utf8_general_ci */ ;
  759. /*!50003 SET @saved_sql_mode = @@sql_mode */ ;
  760. /*!50003 SET sql_mode = '' */ ;
  761. DELIMITER ;;
  762. /*!50003 CREATE*/ /*!50020 DEFINER=`root`@`localhost`*/ /*!50003 FUNCTION `numberOfNewMessages`(p_patientUserName varchar(100)) RETURNS int(11)
  763. begin
  764. declare nbrNewMess int;
  765. select count(*) into nbrNewMess from Message where recieverName = p_patientUserName and readByRec = 0;
  766. return nbrNewMess;
  767. end */;;
  768. DELIMITER ;
  769. /*!50003 SET sql_mode
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!