608 lines
18 KiB
SQL
608 lines
18 KiB
SQL
-- MariaDB dump 10.19 Distrib 10.6.18-MariaDB, for debian-linux-gnu (x86_64)
|
|
--
|
|
-- Host: localhost Database: ol521
|
|
-- ------------------------------------------------------
|
|
-- Server version 10.6.18-MariaDB-0ubuntu0.22.04.1
|
|
|
|
/*!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 utf8mb4 */;
|
|
/*!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 `banners`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `banners`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `banners` (
|
|
`bannerid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`bannername` tinytext DEFAULT NULL,
|
|
`bannercolor` tinytext DEFAULT NULL,
|
|
`textcolor` tinytext DEFAULT NULL,
|
|
PRIMARY KEY (`bannerid`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `banners`
|
|
--
|
|
|
|
LOCK TABLES `banners` WRITE;
|
|
/*!40000 ALTER TABLE `banners` DISABLE KEYS */;
|
|
INSERT INTO `banners` VALUES
|
|
(1,'no banner','#000000','#000000'),
|
|
(2,'UNCLASSIFIED','#009900','#FFFFFF'),
|
|
(3,'CONFIDENTIAL','#000099','#FFFFFF'),
|
|
(4,'SECRET','#990000','#FFFFFF'),
|
|
(5,'TOP SECRET','#FF6600','#FFFFFF');
|
|
/*!40000 ALTER TABLE `banners` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `configs`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `configs`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `configs` (
|
|
`confid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`confname` text DEFAULT NULL,
|
|
`confvalue` text DEFAULT NULL,
|
|
PRIMARY KEY (`confid`),
|
|
UNIQUE (`confname`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `configs`
|
|
--
|
|
|
|
LOCK TABLES `configs` WRITE;
|
|
/*!40000 ALTER TABLE `configs` DISABLE KEYS */;
|
|
INSERT INTO `configs` VALUES
|
|
(1,'ol_version','5.2.4'),
|
|
(2,'log_name','OpenLog'),
|
|
(3,'banner','1'),
|
|
(4,'background_color','#003333'),
|
|
(5,'p_background_color','#FFFFFF'),
|
|
(6,'sidebar_color','#336666'),
|
|
(7,'p_sidebar_color','#FFFFFF'),
|
|
(8,'menubg_color','#000000'),
|
|
(9,'p_menubg_color','#FFFFFF'),
|
|
(10,'text_color','#FFFFFF'),
|
|
(11,'p_text_color','#000000'),
|
|
(12,'link_color','#00FF00'),
|
|
(13,'p_link_color','#000000'),
|
|
(14,'vlink_color','#00FF00'),
|
|
(15,'p_vlink_color','#000000'),
|
|
(16,'heading_color','#00FFFF'),
|
|
(17,'p_heading_color','#000000'),
|
|
(18,'footer_message','Please report bugs to software@thermionic.net.'),
|
|
(19,'show_ts','1'),
|
|
(20,'url_chunk_size','70'),
|
|
(21,'tech_alpha','1'),
|
|
(22,'subj_alpha','1'),
|
|
(23,'unix_server_session_dir','/tmp/openlog/openlog/sessions'),
|
|
(24,'win_server_session_dir','c:\\Windows\\Temp\\openlog\\\\openlog\\sessions'),
|
|
(25,'session_ttl_days','30'),
|
|
(26,'log_style','1'),
|
|
(27,'uid_text','Part ID Number'),
|
|
(28,'parts_functions','1'),
|
|
(29,'schedmaint_functions','1'),
|
|
(30,'log_errors','0');
|
|
/*!40000 ALTER TABLE `configs` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `customs`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `customs`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `customs` (
|
|
`customid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`customtech` int(11) DEFAULT NULL,
|
|
`customconfnum` int(11) DEFAULT NULL,
|
|
`customconfvalue` text DEFAULT NULL,
|
|
PRIMARY KEY (`customid`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `customs`
|
|
--
|
|
|
|
LOCK TABLES `customs` WRITE;
|
|
/*!40000 ALTER TABLE `customs` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `customs` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `devicegroups`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `devicegroups`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `devicegroups` (
|
|
`groupid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`groupdevice` int(11) DEFAULT NULL,
|
|
`memberdevice` int(11) DEFAULT NULL,
|
|
PRIMARY KEY (`groupid`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `devicegroups`
|
|
--
|
|
|
|
LOCK TABLES `devicegroups` WRITE;
|
|
/*!40000 ALTER TABLE `devicegroups` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `devicegroups` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `devices`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `devices`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `devices` (
|
|
`deviceid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`devicename` tinytext DEFAULT NULL,
|
|
`devicedesc` text DEFAULT NULL,
|
|
`group_flag` int(11) DEFAULT NULL,
|
|
`active_flag` int(11) DEFAULT NULL,
|
|
PRIMARY KEY (`deviceid`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `devices`
|
|
--
|
|
|
|
LOCK TABLES `devices` WRITE;
|
|
/*!40000 ALTER TABLE `devices` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `devices` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `events`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `events`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `events` (
|
|
`eventid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`task` int(11) DEFAULT NULL,
|
|
`device` int(11) DEFAULT NULL,
|
|
`start_date` date DEFAULT NULL,
|
|
`last_date` date DEFAULT NULL,
|
|
`deferred_flag` int(11) DEFAULT NULL,
|
|
`deferred_date` date DEFAULT NULL,
|
|
`active_flag` int(11) DEFAULT NULL,
|
|
PRIMARY KEY (`eventid`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `events`
|
|
--
|
|
|
|
LOCK TABLES `events` WRITE;
|
|
/*!40000 ALTER TABLE `events` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `events` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `flags`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `flags`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `flags` (
|
|
`flagid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`flagname` tinytext DEFAULT NULL,
|
|
`flagsym` tinytext DEFAULT NULL,
|
|
`flagcolor` tinytext DEFAULT NULL,
|
|
`status` int(11) NOT NULL,
|
|
PRIMARY KEY (`flagid`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `flags`
|
|
--
|
|
|
|
LOCK TABLES `flags` WRITE;
|
|
/*!40000 ALTER TABLE `flags` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `flags` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `links`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `links`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `links` (
|
|
`linkid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`linkpriority` int(11) NOT NULL,
|
|
`displaytxt` text DEFAULT NULL,
|
|
`urltxt` text DEFAULT NULL,
|
|
`status` int(11) NOT NULL,
|
|
PRIMARY KEY (`linkid`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `links`
|
|
--
|
|
|
|
LOCK TABLES `links` WRITE;
|
|
/*!40000 ALTER TABLE `links` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `links` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `lognotes`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `lognotes`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `lognotes` (
|
|
`lognoteid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`date` date DEFAULT NULL,
|
|
`time` time DEFAULT NULL,
|
|
`shift` int(11) NOT NULL,
|
|
`tech` int(11) NOT NULL,
|
|
`subject` int(11) NOT NULL,
|
|
`lognote` text DEFAULT NULL,
|
|
`refs` tinytext DEFAULT NULL,
|
|
PRIMARY KEY (`lognoteid`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `lognotes`
|
|
--
|
|
|
|
LOCK TABLES `lognotes` WRITE;
|
|
/*!40000 ALTER TABLE `lognotes` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `lognotes` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `logpartactions`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `logpartactions`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `logpartactions` (
|
|
`lpactionid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`lpactionname` tinytext DEFAULT NULL,
|
|
`status` int(11) DEFAULT NULL,
|
|
PRIMARY KEY (`lpactionid`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `logpartactions`
|
|
--
|
|
|
|
LOCK TABLES `logpartactions` WRITE;
|
|
/*!40000 ALTER TABLE `logpartactions` DISABLE KEYS */;
|
|
INSERT INTO `logpartactions` VALUES
|
|
(1,'removed',1),
|
|
(2,'installed',1),
|
|
(3,'repaired',1),
|
|
(4,'replaced',1),
|
|
(5,'incoming',1),
|
|
(6,'outgoing',1);
|
|
/*!40000 ALTER TABLE `logpartactions` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `logparts`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `logparts`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `logparts` (
|
|
`logpartid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`lognoteid` int(11) DEFAULT NULL,
|
|
`partid` int(11) DEFAULT NULL,
|
|
`action` int(11) DEFAULT NULL,
|
|
PRIMARY KEY (`logpartid`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `logparts`
|
|
--
|
|
|
|
LOCK TABLES `logparts` WRITE;
|
|
/*!40000 ALTER TABLE `logparts` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `logparts` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `maintactions`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `maintactions`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `maintactions` (
|
|
`maintactionid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`actiondate` date DEFAULT NULL,
|
|
`actiontime` time DEFAULT NULL,
|
|
`maintformnum` int(11) NOT NULL,
|
|
`actiontech` int(11) NOT NULL,
|
|
`action` text DEFAULT NULL,
|
|
PRIMARY KEY (`maintactionid`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `maintactions`
|
|
--
|
|
|
|
LOCK TABLES `maintactions` WRITE;
|
|
/*!40000 ALTER TABLE `maintactions` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `maintactions` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `maintforms`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `maintforms`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `maintforms` (
|
|
`maintformid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`mfdate` date DEFAULT NULL,
|
|
`mftime` time DEFAULT NULL,
|
|
`mftech` int(11) DEFAULT NULL,
|
|
`mfpart` int(11) NOT NULL,
|
|
`mfpartloc` text DEFAULT NULL,
|
|
`mfmalfunction` text DEFAULT NULL,
|
|
`nha` tinytext DEFAULT NULL,
|
|
`repord` tinytext DEFAULT NULL,
|
|
`lognoteid` int(11) DEFAULT NULL,
|
|
`pending` int(11) DEFAULT NULL,
|
|
PRIMARY KEY (`maintformid`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `maintforms`
|
|
--
|
|
|
|
LOCK TABLES `maintforms` WRITE;
|
|
/*!40000 ALTER TABLE `maintforms` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `maintforms` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `notetemplates`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `notetemplates`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `notetemplates` (
|
|
`templateid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`templatename` tinytext DEFAULT NULL,
|
|
`shift` int(11) NOT NULL,
|
|
`tech` int(11) NOT NULL,
|
|
`subject` int(11) NOT NULL,
|
|
`lognote` text DEFAULT NULL,
|
|
`refs` tinytext DEFAULT NULL,
|
|
PRIMARY KEY (`templateid`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `notetemplates`
|
|
--
|
|
|
|
LOCK TABLES `notetemplates` WRITE;
|
|
/*!40000 ALTER TABLE `notetemplates` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `notetemplates` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `parts`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `parts`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `parts` (
|
|
`partid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`uid` tinytext DEFAULT NULL,
|
|
`partnum` tinytext DEFAULT NULL,
|
|
`sernum` tinytext DEFAULT NULL,
|
|
`partname` tinytext DEFAULT NULL,
|
|
PRIMARY KEY (`partid`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `parts`
|
|
--
|
|
|
|
LOCK TABLES `parts` WRITE;
|
|
/*!40000 ALTER TABLE `parts` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `parts` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `shifts`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `shifts`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `shifts` (
|
|
`shiftid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`shiftname` tinytext DEFAULT NULL,
|
|
`status` int(11) NOT NULL,
|
|
PRIMARY KEY (`shiftid`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `shifts`
|
|
--
|
|
|
|
LOCK TABLES `shifts` WRITE;
|
|
/*!40000 ALTER TABLE `shifts` DISABLE KEYS */;
|
|
INSERT INTO `shifts` VALUES
|
|
(1,'First Shift',1);
|
|
/*!40000 ALTER TABLE `shifts` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `styles`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `styles`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `styles` (
|
|
`styleid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`styletype` tinytext DEFAULT NULL,
|
|
`stylename` tinytext DEFAULT NULL,
|
|
PRIMARY KEY (`styleid`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `styles`
|
|
--
|
|
|
|
LOCK TABLES `styles` WRITE;
|
|
/*!40000 ALTER TABLE `styles` DISABLE KEYS */;
|
|
INSERT INTO `styles` VALUES
|
|
(1,'logdisplay','classic'),
|
|
(2,'logdisplay','clean');
|
|
/*!40000 ALTER TABLE `styles` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `subjects`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `subjects`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `subjects` (
|
|
`subjectid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`subjectname` tinytext DEFAULT NULL,
|
|
`status` int(11) NOT NULL,
|
|
PRIMARY KEY (`subjectid`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `subjects`
|
|
--
|
|
|
|
LOCK TABLES `subjects` WRITE;
|
|
/*!40000 ALTER TABLE `subjects` DISABLE KEYS */;
|
|
INSERT INTO `subjects` VALUES
|
|
(1,'Miscellaneous',1);
|
|
/*!40000 ALTER TABLE `subjects` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `tasks`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `tasks`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `tasks` (
|
|
`taskid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`taskname` tinytext DEFAULT NULL,
|
|
`taskdesc` text DEFAULT NULL,
|
|
`frequency` int(11) DEFAULT NULL,
|
|
`period` tinytext DEFAULT NULL,
|
|
`weekdays_only` int(11) DEFAULT NULL,
|
|
`nextdue_relative` int(11) DEFAULT NULL,
|
|
`refdoc_name` tinytext DEFAULT NULL,
|
|
`refdoc_url` tinytext DEFAULT NULL,
|
|
`active_flag` int(11) DEFAULT NULL,
|
|
PRIMARY KEY (`taskid`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `tasks`
|
|
--
|
|
|
|
LOCK TABLES `tasks` WRITE;
|
|
/*!40000 ALTER TABLE `tasks` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `tasks` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `techs`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `techs`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `techs` (
|
|
`techid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`techname` tinytext DEFAULT NULL,
|
|
`admin` int(11) DEFAULT NULL,
|
|
`shift` int(11) DEFAULT NULL,
|
|
`techpass` text DEFAULT NULL,
|
|
`status` int(11) NOT NULL,
|
|
PRIMARY KEY (`techid`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `techs`
|
|
--
|
|
|
|
LOCK TABLES `techs` WRITE;
|
|
/*!40000 ALTER TABLE `techs` DISABLE KEYS */;
|
|
INSERT INTO `techs` VALUES
|
|
(1,'OpenLogAdmin',1,1,'$2y$10$6eCxUFNzoAkycMJpZ.zvaOfoByYhqi0YicQbut3XGc/TRxyxiUwcm',1);
|
|
/*!40000 ALTER TABLE `techs` 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 2024-07-09 14:36:00
|