942 lines
21 KiB
SQL
942 lines
21 KiB
SQL
/*M!999999\- enable the sandbox mode */
|
|
-- MariaDB dump 10.19-11.8.3-MariaDB, for debian-linux-gnu (x86_64)
|
|
--
|
|
-- Host: localhost Database: openlog
|
|
-- ------------------------------------------------------
|
|
-- Server version 11.8.3-MariaDB-0+deb13u1 from Debian
|
|
|
|
/*!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' */
|
|
;
|
|
/*M!100616 SET @OLD_NOTE_VERBOSITY=@@NOTE_VERBOSITY, NOTE_VERBOSITY=0 */
|
|
;
|
|
|
|
--
|
|
-- Table structure for table `banners`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `banners`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */
|
|
;
|
|
/*!40101 SET character_set_client = utf8mb4 */
|
|
;
|
|
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 */
|
|
;
|
|
set autocommit = 0;
|
|
|
|
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;
|
|
|
|
commit;
|
|
|
|
--
|
|
-- Table structure for table `configs`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `configs`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */
|
|
;
|
|
/*!40101 SET character_set_client = utf8mb4 */
|
|
;
|
|
CREATE TABLE `configs` (
|
|
`confid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`confname` text DEFAULT NULL,
|
|
`confvalue` text DEFAULT NULL,
|
|
PRIMARY KEY (`confid`),
|
|
UNIQUE KEY `confname` (`confname`) USING HASH
|
|
) 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 */
|
|
;
|
|
set autocommit = 0;
|
|
|
|
INSERT INTO
|
|
`configs`
|
|
VALUES (1, 'ol_version', '5.3.0'),
|
|
(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;
|
|
|
|
commit;
|
|
|
|
--
|
|
-- Table structure for table `customs`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `customs`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */
|
|
;
|
|
/*!40101 SET character_set_client = utf8mb4 */
|
|
;
|
|
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 */
|
|
;
|
|
set autocommit = 0;
|
|
/*!40000 ALTER TABLE `customs` ENABLE KEYS */
|
|
;
|
|
UNLOCK TABLES;
|
|
|
|
commit;
|
|
|
|
--
|
|
-- Table structure for table `devicegroups`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `devicegroups`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */
|
|
;
|
|
/*!40101 SET character_set_client = utf8mb4 */
|
|
;
|
|
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 */
|
|
;
|
|
set autocommit = 0;
|
|
/*!40000 ALTER TABLE `devicegroups` ENABLE KEYS */
|
|
;
|
|
UNLOCK TABLES;
|
|
|
|
commit;
|
|
|
|
--
|
|
-- Table structure for table `devices`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `devices`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */
|
|
;
|
|
/*!40101 SET character_set_client = utf8mb4 */
|
|
;
|
|
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 */
|
|
;
|
|
set autocommit = 0;
|
|
/*!40000 ALTER TABLE `devices` ENABLE KEYS */
|
|
;
|
|
UNLOCK TABLES;
|
|
|
|
commit;
|
|
|
|
--
|
|
-- Table structure for table `events`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `events`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */
|
|
;
|
|
/*!40101 SET character_set_client = utf8mb4 */
|
|
;
|
|
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 */
|
|
;
|
|
set autocommit = 0;
|
|
/*!40000 ALTER TABLE `events` ENABLE KEYS */
|
|
;
|
|
UNLOCK TABLES;
|
|
|
|
commit;
|
|
|
|
--
|
|
-- Table structure for table `flagmap`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `flagmap`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */
|
|
;
|
|
/*!40101 SET character_set_client = utf8mb4 */
|
|
;
|
|
CREATE TABLE `flagmap` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`flagid` int(11) NOT NULL,
|
|
`lognoteid` int(11) DEFAULT NULL,
|
|
`maintformid` int(11) DEFAULT NULL,
|
|
`notetemplateid` int(11) DEFAULT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */
|
|
;
|
|
|
|
--
|
|
-- Dumping data for table `flagmap`
|
|
--
|
|
|
|
LOCK TABLES `flagmap` WRITE;
|
|
/*!40000 ALTER TABLE `flagmap` DISABLE KEYS */
|
|
;
|
|
set autocommit = 0;
|
|
/*!40000 ALTER TABLE `flagmap` ENABLE KEYS */
|
|
;
|
|
UNLOCK TABLES;
|
|
|
|
commit;
|
|
|
|
--
|
|
-- Table structure for table `flags`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `flags`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */
|
|
;
|
|
/*!40101 SET character_set_client = utf8mb4 */
|
|
;
|
|
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 */
|
|
;
|
|
set autocommit = 0;
|
|
/*!40000 ALTER TABLE `flags` ENABLE KEYS */
|
|
;
|
|
UNLOCK TABLES;
|
|
|
|
commit;
|
|
|
|
--
|
|
-- Table structure for table `links`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `links`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */
|
|
;
|
|
/*!40101 SET character_set_client = utf8mb4 */
|
|
;
|
|
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 */
|
|
;
|
|
set autocommit = 0;
|
|
/*!40000 ALTER TABLE `links` ENABLE KEYS */
|
|
;
|
|
UNLOCK TABLES;
|
|
|
|
commit;
|
|
|
|
--
|
|
-- Table structure for table `lognotes`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `lognotes`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */
|
|
;
|
|
/*!40101 SET character_set_client = utf8mb4 */
|
|
;
|
|
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,
|
|
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 */
|
|
;
|
|
set autocommit = 0;
|
|
/*!40000 ALTER TABLE `lognotes` ENABLE KEYS */
|
|
;
|
|
UNLOCK TABLES;
|
|
|
|
commit;
|
|
|
|
--
|
|
-- Table structure for table `logpartactions`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `logpartactions`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */
|
|
;
|
|
/*!40101 SET character_set_client = utf8mb4 */
|
|
;
|
|
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 */
|
|
;
|
|
set autocommit = 0;
|
|
|
|
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;
|
|
|
|
commit;
|
|
|
|
--
|
|
-- Table structure for table `logparts`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `logparts`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */
|
|
;
|
|
/*!40101 SET character_set_client = utf8mb4 */
|
|
;
|
|
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 */
|
|
;
|
|
set autocommit = 0;
|
|
/*!40000 ALTER TABLE `logparts` ENABLE KEYS */
|
|
;
|
|
UNLOCK TABLES;
|
|
|
|
commit;
|
|
|
|
--
|
|
-- Table structure for table `maintactions`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `maintactions`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */
|
|
;
|
|
/*!40101 SET character_set_client = utf8mb4 */
|
|
;
|
|
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 */
|
|
;
|
|
set autocommit = 0;
|
|
/*!40000 ALTER TABLE `maintactions` ENABLE KEYS */
|
|
;
|
|
UNLOCK TABLES;
|
|
|
|
commit;
|
|
|
|
--
|
|
-- Table structure for table `maintforms`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `maintforms`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */
|
|
;
|
|
/*!40101 SET character_set_client = utf8mb4 */
|
|
;
|
|
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 */
|
|
;
|
|
set autocommit = 0;
|
|
/*!40000 ALTER TABLE `maintforms` ENABLE KEYS */
|
|
;
|
|
UNLOCK TABLES;
|
|
|
|
commit;
|
|
|
|
--
|
|
-- Table structure for table `notetemplates`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `notetemplates`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */
|
|
;
|
|
/*!40101 SET character_set_client = utf8mb4 */
|
|
;
|
|
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 */
|
|
;
|
|
set autocommit = 0;
|
|
/*!40000 ALTER TABLE `notetemplates` ENABLE KEYS */
|
|
;
|
|
UNLOCK TABLES;
|
|
|
|
commit;
|
|
|
|
--
|
|
-- Table structure for table `parts`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `parts`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */
|
|
;
|
|
/*!40101 SET character_set_client = utf8mb4 */
|
|
;
|
|
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 */
|
|
;
|
|
set autocommit = 0;
|
|
/*!40000 ALTER TABLE `parts` ENABLE KEYS */
|
|
;
|
|
UNLOCK TABLES;
|
|
|
|
commit;
|
|
|
|
--
|
|
-- Table structure for table `reflinks`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `reflinks`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */
|
|
;
|
|
/*!40101 SET character_set_client = utf8mb4 */
|
|
;
|
|
CREATE TABLE `reflinks` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`noteid` int(11) DEFAULT NULL,
|
|
`templateid` int(11) DEFAULT NULL,
|
|
`target` int(11) NOT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */
|
|
;
|
|
|
|
--
|
|
-- Dumping data for table `reflinks`
|
|
--
|
|
|
|
LOCK TABLES `reflinks` WRITE;
|
|
/*!40000 ALTER TABLE `reflinks` DISABLE KEYS */
|
|
;
|
|
set autocommit = 0;
|
|
/*!40000 ALTER TABLE `reflinks` ENABLE KEYS */
|
|
;
|
|
UNLOCK TABLES;
|
|
|
|
commit;
|
|
|
|
--
|
|
-- Table structure for table `shifts`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `shifts`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */
|
|
;
|
|
/*!40101 SET character_set_client = utf8mb4 */
|
|
;
|
|
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 */
|
|
;
|
|
set autocommit = 0;
|
|
|
|
INSERT INTO `shifts` VALUES (1, 'First Shift', 1);
|
|
/*!40000 ALTER TABLE `shifts` ENABLE KEYS */
|
|
;
|
|
UNLOCK TABLES;
|
|
|
|
commit;
|
|
|
|
--
|
|
-- Table structure for table `styles`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `styles`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */
|
|
;
|
|
/*!40101 SET character_set_client = utf8mb4 */
|
|
;
|
|
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 */
|
|
;
|
|
set autocommit = 0;
|
|
|
|
INSERT INTO
|
|
`styles`
|
|
VALUES (1, 'logdisplay', 'classic'),
|
|
(2, 'logdisplay', 'clean');
|
|
/*!40000 ALTER TABLE `styles` ENABLE KEYS */
|
|
;
|
|
UNLOCK TABLES;
|
|
|
|
commit;
|
|
|
|
--
|
|
-- Table structure for table `subjects`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `subjects`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */
|
|
;
|
|
/*!40101 SET character_set_client = utf8mb4 */
|
|
;
|
|
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 */
|
|
;
|
|
set autocommit = 0;
|
|
|
|
INSERT INTO `subjects` VALUES (1, 'Miscellaneous', 1);
|
|
/*!40000 ALTER TABLE `subjects` ENABLE KEYS */
|
|
;
|
|
UNLOCK TABLES;
|
|
|
|
commit;
|
|
|
|
--
|
|
-- Table structure for table `tasks`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `tasks`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */
|
|
;
|
|
/*!40101 SET character_set_client = utf8mb4 */
|
|
;
|
|
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 */
|
|
;
|
|
set autocommit = 0;
|
|
/*!40000 ALTER TABLE `tasks` ENABLE KEYS */
|
|
;
|
|
UNLOCK TABLES;
|
|
|
|
commit;
|
|
|
|
--
|
|
-- Table structure for table `techs`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `techs`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */
|
|
;
|
|
/*!40101 SET character_set_client = utf8mb4 */
|
|
;
|
|
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 */
|
|
;
|
|
set autocommit = 0;
|
|
|
|
INSERT INTO
|
|
`techs`
|
|
VALUES (
|
|
1,
|
|
'OpenLogAdmin',
|
|
1,
|
|
1,
|
|
'$2y$10$6eCxUFNzoAkycMJpZ.zvaOfoByYhqi0YicQbut3XGc/TRxyxiUwcm',
|
|
1
|
|
);
|
|
/*!40000 ALTER TABLE `techs` ENABLE KEYS */
|
|
;
|
|
UNLOCK TABLES;
|
|
|
|
commit;
|
|
/*!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 */
|
|
;
|
|
/*M!100616 SET NOTE_VERBOSITY=@OLD_NOTE_VERBOSITY */
|
|
;
|
|
|
|
-- Dump completed on 2026-02-19 14:18:01 |