| Server IP : 134.236.49.22 / Your IP : 216.73.216.114 Web Server : Apache/2.2.15 (Fedora) System : Linux km10.dyndns.org 2.6.31.5-127.fc12.i686.PAE #1 SMP Sat Nov 7 21:25:57 EST 2009 i686 User : apache ( 48) PHP Version : 5.3.3 Disable Function : NONE MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/html/backup_db/ |
Upload File : |
-- MySQL dump 10.13 Distrib 5.1.47, for redhat-linux-gnu (i386) -- -- Host: localhost Database: hkm10_complain_report -- ------------------------------------------------------ -- Server version 5.1.47 /*!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 `pass4edit` -- DROP TABLE IF EXISTS `pass4edit`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pass4edit` ( `pass4edit_id` bigint(20) NOT NULL AUTO_INCREMENT, `secureimg_text` varchar(10) NOT NULL, `report_id` int(11) NOT NULL, PRIMARY KEY (`pass4edit_id`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pass4edit` -- LOCK TABLES `pass4edit` WRITE; /*!40000 ALTER TABLE `pass4edit` DISABLE KEYS */; INSERT INTO `pass4edit` VALUES (1,'ZWNP',1),(2,'SAV7',2),(3,'8ZE9',3),(4,'FVSK',4),(5,'TGZ2',5),(6,'N333',6),(7,'633Z',7),(8,'LOSHWBVATO',8),(9,'Z8MR',8),(10,'U6WP',9); /*!40000 ALTER TABLE `pass4edit` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `reports` -- DROP TABLE IF EXISTS `reports`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `reports` ( `report_id` bigint(20) NOT NULL AUTO_INCREMENT, `report_status` tinyint(1) NOT NULL COMMENT 'เà¸à¸²à¹„ว้ flag ดูว่า สถานะà¸à¸°à¹„ร ดูà¹à¸¥à¹‰à¸§,ยังไม่ได้ดู,ลบทิ้ง,ดำเนินà¸à¸²à¸£à¹à¸¥à¹‰à¸§,ไม่ผ่าน', `department` varchar(255) NOT NULL, `date_occur` varchar(32) NOT NULL, `time_occur` varchar(32) NOT NULL, `place` varchar(255) NOT NULL, `patient_name` varchar(255) NOT NULL, `patient_age` varchar(3) NOT NULL, `hn` varchar(20) NOT NULL, `an` varchar(20) NOT NULL, `description` text NOT NULL, `damage` varchar(512) NOT NULL, `first_resolve` varchar(512) NOT NULL, `cause1` varchar(255) NOT NULL, `resolve1` varchar(255) NOT NULL, `cause2` varchar(255) NOT NULL, `resolve2` varchar(255) NOT NULL, `cause3` varchar(255) NOT NULL, `resolve3` varchar(255) NOT NULL, `cause4` varchar(255) NOT NULL, `resolve4` varchar(255) NOT NULL, `cause5` varchar(255) NOT NULL, `resolve5` varchar(255) NOT NULL, `cause6` varchar(255) NOT NULL, `resolve6` varchar(255) NOT NULL, `cause7` varchar(255) NOT NULL, `resolve7` varchar(255) NOT NULL, `cause8` varchar(255) NOT NULL, `resolve8` varchar(255) NOT NULL, `leader_opinion` varchar(512) NOT NULL, `leader_name` varchar(255) NOT NULL, `date_signature` varchar(32) NOT NULL, `ir_no` varchar(10) NOT NULL, `kind_of` varchar(512) NOT NULL COMMENT '''รายงานตนเà¸à¸‡ (self report)'',''รายงานผู้à¸à¸·à¹ˆà¸™ \\/ หน่วยงานà¸à¸·à¹ˆà¸™ (other report)''', `type` varchar(512) NOT NULL COMMENT '1.Clinic 2.Med 3.IO 4.เครื่à¸à¸‡à¸¡à¸·à¸ 5.สื่à¸à¸ªà¸²à¸£ 6.ENV+ความปลà¸à¸”ภัย 7.Gen 8.à¸à¸²à¸£à¹€à¸‡à¸´à¸™ 9.บุคลาà¸à¸£ 10.ความพึงพà¸à¹ƒà¸ˆ', `violence` varchar(512) NOT NULL COMMENT 'ความรุนà¹à¸£à¸‡', `report_datetime_stamp` datetime NOT NULL, PRIMARY KEY (`report_id`) ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `reports` -- LOCK TABLES `reports` WRITE; /*!40000 ALTER TABLE `reports` DISABLE KEYS */; INSERT INTO `reports` VALUES (1,1,'à¸à¸à¸‡à¸à¸´à¸ˆà¸à¸²à¸£à¸™à¸´à¸ªà¸´à¸•','17/02/2010','14.00 น.','มหาวิทยาลัยบูรพา','นางสาววิมลพรรณ จันทศร','22','-','-','หà¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸','à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸','à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸','1. à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸','1. à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸','2. à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸','2.à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸ ','3. à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸','3.à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸ ','4. à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸','4. à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸','5. à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸','5. à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸','6. à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸','6. à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸','7. à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸','7. à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸','8. à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸','8. à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸','à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸','à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸à¸','07/02/2010','1111111','self_report','clinic,med,io,tool,commu,env,gen,finance,human,satisfaction','d','2010-02-07 17:29:28'),(2,1,'คอมพิวเตอร์','15/04/2010','13.48','ศูนย์คอมพิวเตอร์','ภราดร','24','22554','','ทดสอบ','ทดสอบ','ทดสอบ','1.ทดสอบ ','1. ทดสอบ','2. ','2. ','3. ','3. ','4. ','4. ','5. ','5. ','6. ','6. ','7. ','7. ','8. ','8. ','ทดสอบ','ภราดร','15/04/2010','','','','','2010-04-15 13:49:34'),(3,1,'สารสนเทศ','18/06/2010','16.47','ศูนย์คอม','ภราดร','24','47530575','','ทดสอบ ครั้งที่ 1 ','ไม่ทราบสาเหตุ','ไม่ทราบสาเหตุ','1. ไม่ทราบสาเหตุ','1. ไม่ทราบสาเหตุ','2. ','2. ','3. ','3. ','4. ','4. ','5. ','5. ','6. ','6. ','7. ','7. ','8. ','8. ','','ภราดร วัฒรอด','18/06/2010','','','','','2010-06-18 16:49:44'),(4,1,'','','','','','','','','','','','1. ','1. ','2. ','2. ','3. ','3. ','4. ','4. ','5. ','5. ','6. ','6. ','7. ','7. ','8. ','8. ','','','','','','clinic','d','2010-06-29 12:51:44'),(5,1,'ทดสอบ','29/10/2010','','ทดสอบ','ทดสอบ','','','','ทดสอบ','ทดสอบ','ทดสอบ','1. ทดสอบ','1. ทดสอบ','2. ทดสอบ','2. ทดสอบ','3. ทดสอบ','3. ทดสอบ','4. ','4. ','5. ','5. ','6. ','6. ','7. ','7. ','8. ','8. ','ทดสอบ','ทดสอบ','','','','','','2010-10-29 15:53:19'),(6,0,'sd','03/11/2010','sd','adcx','czxczxczcx','zcz','zxcxcx','czxc','cxczcx','dfsdfsdcx','svscxcs','1. ','1. ','2. ','2. ','3. ','3. ','4. ','4. ','5. ','5. ','6. ','6. ','7. ','7. ','8. ','8. ','','adxxdvdec','','','','','','2010-11-30 16:00:18'),(7,1,'ทดสอบ888','07/12/2010','','ทดสอบ888','ทดสอบ888','ทดส','','','ทดสอบ888','ทดสอบ888','ทดสอบ888','1. ','1. ','2. ','2. ','3. ','3. ','4. ','4. ','5. ','5. ','6. ','6. ','7. ','7. ','8. ','8. ','','ทดสอบ888','','','','','','2010-12-07 10:08:52'),(8,0,'','','','','','','','','','','','1. ','1. ','2. ','2. ','3. ','3. ','4. ','4. ','5. ','5. ','6. ','6. ','7. ','7. ','8. ','8. ','','','','','','','','2013-01-16 00:31:19'),(9,0,'ipd','05/04/2013','13.00','IPD','กอง แพงจัง','23','56-1236','56-12','','','','1. ','1. ','2. ','2. ','3. ','3. ','4. ','4. ','5. ','5. ','6. ','6. ','7. ','7. ','8. ','8. ','','','','','','','','2013-04-05 18:22:55'); /*!40000 ALTER TABLE `reports` 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` ( `user_id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(255) NOT NULL, `password` varchar(255) NOT NULL, `auth_type` tinyint(1) NOT NULL COMMENT '1=admin,2=executive', PRIMARY KEY (`user_id`), UNIQUE KEY `username` (`username`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*!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,'admin','admin',1); /*!40000 ALTER TABLE `users` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping routines for database 'hkm10_complain_report' -- /*!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 2026-07-22 0:00:04