Page MenuHomeGRNET
Files F448923

dias_portal.sql
No OneTemporary
Actions

File Metadata

Created
Thu, Apr 24, 11:47 AM

dias_portal.sql
View Options

-- MySQL dump 10.13 Distrib 5.6.23, for Win64 (x86_64)
--
-- Host: 127.0.0.1 Database: dias_portal
-- ------------------------------------------------------
-- Server version 5.6.11-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 `db_body_part`
--
DROP TABLE IF EXISTS `db_body_part`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `db_body_part` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`body_part` varchar(255) NOT NULL,
`user_id` varchar(255) NOT NULL,
`persistent_id` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `db_body_part`
--
LOCK TABLES `db_body_part` WRITE;
/*!40000 ALTER TABLE `db_body_part` DISABLE KEYS */;
/*!40000 ALTER TABLE `db_body_part` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `db_columns_order`
--
DROP TABLE IF EXISTS `db_columns_order`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `db_columns_order` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`table_name` varchar(45) DEFAULT NULL,
`user_id` varchar(255) NOT NULL,
`column_orig_position` int(11) NOT NULL,
`column_cur_position` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=255 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `db_columns_order`
--
LOCK TABLES `db_columns_order` WRITE;
/*!40000 ALTER TABLE `db_columns_order` DISABLE KEYS */;
/*!40000 ALTER TABLE `db_columns_order` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `db_department`
--
DROP TABLE IF EXISTS `db_department`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `db_department` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`department` varchar(255) NOT NULL,
`user_id` varchar(255) NOT NULL,
`persistent_id` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `db_department`
--
LOCK TABLES `db_department` WRITE;
/*!40000 ALTER TABLE `db_department` DISABLE KEYS */;
/*!40000 ALTER TABLE `db_department` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `db_menu`
--
DROP TABLE IF EXISTS `db_menu`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `db_menu` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL,
`link` varchar(5000) NOT NULL,
`isgroup` int(11) NOT NULL,
`parent_id` int(11) NOT NULL,
`menuorder` int(11) NOT NULL,
`mob_version` int(11) DEFAULT NULL,
`fonts` varchar(45) DEFAULT NULL,
`storn` varchar(255) DEFAULT '0',
`icon` varchar(255) DEFAULT NULL,
`lang` varchar(2) DEFAULT 'el',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=408 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `db_menu`
--
LOCK TABLES `db_menu` WRITE;
/*!40000 ALTER TABLE `db_menu` DISABLE KEYS */;
INSERT INTO `db_menu` VALUES (1,'Ασθενείς ','',1,0,2,1,'','','','el'),(2,'Αναζήτηση Ασθενών','admin_pat',0,1,1,0,'','','Doctor.png','el'),(3,'Αναζήτηση Εξετάσεων','admin_exams',0,1,2,1,'fa fa-stethoscope','','medical-suitcase.png','el'),(18,'Γενικά','',1,0,1,1,'fa fa-home','','','el'),(19,'Κεντρική σελίδα','index_2',0,18,1,1,'fa fa-home','','Clinic.jpg','el'),(25,'Διαχείριση χρηστών','',1,0,4,NULL,NULL,'','','el'),(26,'Χρήστες','admin_user',0,25,1,NULL,NULL,'','people.png','el'),(28,'Λίστες Εργασίας','',1,0,3,NULL,NULL,'','','el'),(29,'Δημιουργία Λίστας','admin_list',0,28,1,NULL,NULL,'','emr.png','el'),(173,'Επεξεργασία Λίστας','admin_list&action=view&edit=yes',0,28,2,NULL,NULL,'','editlist.png','el'),(78,'Patients','',1,0,2,NULL,NULL,'','','en'),(255,'JavaViewer','manuals/javaviewer_manual',0,253,3,NULL,NULL,'0','help2.png','en'),(81,'General','',1,0,1,NULL,NULL,'','Clinic.jpg','en'),(83,'Users','',1,0,4,NULL,NULL,'','','en'),(84,'Worklists','',1,0,3,NULL,NULL,'','','en'),(254,'WebViewer','manuals/zeroweb_manual',0,253,2,NULL,NULL,'0','help2.png','en'),(86,'Exams List','admin_order',0,78,2,NULL,NULL,'','medical-suitcase.png','en'),(256,'DIAS','manuals/dias_manual',0,253,1,NULL,NULL,'0','help2.png','en'),(236,'Εγχειρίδια','',1,0,6,NULL,NULL,'',NULL,'el'),(237,'DIAS','manuals/dias_manual',0,236,1,NULL,NULL,'','help2.png','el'),(247,'Home Page','index_2',0,81,1,NULL,NULL,'',NULL,'en'),(248,'Patients List','admin_pat',0,78,1,NULL,NULL,'','Doctor.png','en'),(249,'Create List','admin_list',0,84,1,NULL,NULL,'','emr.png','en'),(250,'Edit List','admin_list&action=view&edit=yes',0,84,2,NULL,NULL,'','editlist.png','en'),(251,'Users','admin_user',0,83,1,NULL,NULL,'','people.png','en'),(253,'Help','',1,0,5,NULL,NULL,'0','help2.png','en'),(258,'Ειδοποιήσεις','',1,0,5,1,'','',NULL,'el'),(259,'Ειδοποιήσεις','notifications_page',0,258,1,1,'fa fa-envelope','','notif.png','el'),(242,'WebViewer','manuals/zeroweb_manual',0,236,2,NULL,NULL,'','help2.png','el'),(246,'JavaViewer','manuals/javaviewer_manual',0,236,3,NULL,NULL,'','help2.png','el'),(268,'Statistics','statistics',0,266,99,NULL,NULL,'0','stats.png','en'),(267,'Στατιστικά','statistics',0,265,99,NULL,NULL,'0','stats.png','el'),(265,'Στατιστικά','',1,0,7,NULL,NULL,'','','el'),(266,'Statistics','',1,0,7,NULL,NULL,'','','en'),(277,'Orders List','admin_mwl',0,78,3,NULL,NULL,'0','mwl.png','en'),(276,'Αναζήτηση παραγγελιών','admin_mwl',0,1,3,NULL,NULL,'0','mwl.png','el'),(403,'Απεσταλμένες Ειδοποιήσεις','notifications_delete',0,258,2,NULL,NULL,'0','sent_notif.png','el');
/*!40000 ALTER TABLE `db_menu` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `db_menu_assignment`
--
DROP TABLE IF EXISTS `db_menu_assignment`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `db_menu_assignment` (
`menu_id` int(11) NOT NULL,
`usergroup_id` varchar(255) NOT NULL,
PRIMARY KEY (`menu_id`,`usergroup_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `db_menu_assignment`
--
LOCK TABLES `db_menu_assignment` WRITE;
/*!40000 ALTER TABLE `db_menu_assignment` DISABLE KEYS */;
INSERT INTO `db_menu_assignment` VALUES (1,'Doctor'),(1,'Hospital IT'),(2,'Doctor'),(2,'Hospital IT'),(3,'Doctor'),(3,'Hospital IT'),(25,'Hospital IT'),(26,'Hospital IT'),(236,'Doctor'),(236,'Hospital IT'),(237,'Doctor'),(237,'Hospital IT'),(242,'Doctor'),(265,'Management'),(267,'Management');
/*!40000 ALTER TABLE `db_menu_assignment` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `db_modalities`
--
DROP TABLE IF EXISTS `db_modalities`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `db_modalities` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` varchar(255) NOT NULL,
`modalities` varchar(2000) CHARACTER SET latin1 DEFAULT NULL,
`filter_user_modal` varchar(5000) DEFAULT 'all',
`persistent_id` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `db_modalities`
--
LOCK TABLES `db_modalities` WRITE;
/*!40000 ALTER TABLE `db_modalities` DISABLE KEYS */;
/*!40000 ALTER TABLE `db_modalities` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `db_ref_phys`
--
DROP TABLE IF EXISTS `db_ref_phys`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `db_ref_phys` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` varchar(255) NOT NULL,
`ref_name` varchar(2000) NOT NULL,
`persistent_id` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=122 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `db_ref_phys`
--
LOCK TABLES `db_ref_phys` WRITE;
/*!40000 ALTER TABLE `db_ref_phys` DISABLE KEYS */;
/*!40000 ALTER TABLE `db_ref_phys` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `db_stations`
--
DROP TABLE IF EXISTS `db_stations`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `db_stations` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` varchar(255) NOT NULL,
`station_name` varchar(500) NOT NULL,
`persistent_id` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=105 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `db_stations`
--
LOCK TABLES `db_stations` WRITE;
/*!40000 ALTER TABLE `db_stations` DISABLE KEYS */;
/*!40000 ALTER TABLE `db_stations` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `db_user`
--
DROP TABLE IF EXISTS `db_user`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `db_user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`persistent_id` varchar(255) NOT NULL,
`login` varchar(255) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`surname` varchar(255) DEFAULT NULL,
`AMKA` varchar(255) DEFAULT NULL,
`usergroup` varchar(255) DEFAULT NULL,
`institution` varchar(255) DEFAULT NULL,
`email` varchar(255) DEFAULT NULL,
`is_admin` varchar(255) DEFAULT '1',
`created` datetime DEFAULT NULL,
`created_by` varchar(255) DEFAULT NULL,
`updated` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`updated_by` varchar(255) DEFAULT NULL,
`storn` varchar(255) DEFAULT NULL,
`ref_name` varchar(255) DEFAULT NULL,
`authorized` tinyint(1) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `persistent_id_UNIQUE` (`persistent_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1514 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `db_user`
--
LOCK TABLES `db_user` WRITE;
/*!40000 ALTER TABLE `db_user` DISABLE KEYS */;
/*!40000 ALTER TABLE `db_user` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `search_columns`
--
DROP TABLE IF EXISTS `search_columns`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `search_columns` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` varchar(255) DEFAULT NULL,
`table_name` varchar(255) DEFAULT NULL,
`columns` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `search_columns`
--
LOCK TABLES `search_columns` WRITE;
/*!40000 ALTER TABLE `search_columns` DISABLE KEYS */;
/*!40000 ALTER TABLE `search_columns` 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 2015-09-30 12:19:33

Event Timeline