3T1yZDF5

1/**
2 * Author:  Chris Mancuso
3 * Created: February 21, 2017
4 */
5
6SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
7SET time_zone = "+00:00";
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
14--
15-- Database: `timerboard`
16--
17
18--
19-- Table structure for `sessions`
20--
21
22CREATE TABLE IF NOT EXISTS `sessions` (
23    `id` varchar(32) NOT NULL,
24    `access` int(10) unsigned DEFAULT NULL,
25    `data` text,
26    PRIMARY KEY (`id`)
27) ENGINE=InnoDB DEFAULT CHARSET=latin1;
28
29--
30-- Table structure for `Timers`1
31--
32
33CREATE TABLE IF NOT EXISTS `Timers` (
34    `id` int(20) AUTO_INCREMENT,
35    `Type` varchar(50),
36    `Stage` varchar(50),
37    `Region` varchar(50),
38    `System` varchar(50),
39    `Planet` varchar(50),
40    `Moon` varchar(50),
41    `Owner` varchar(50),
42    `EVETime` int(20),
43    `Notes` text,
44    `User` varchar(100),
45    PRIMARY KEY (`id`),
46    UNIQUE KEY `id` (`id`)
47) ENGINE=InnoDB DEFAULT CHARSET=latin1;
48
49--
50-- Table structure for `Characters`
51--
52
53CREATE TABLE IF NOT EXISTS `Characters` (
54    `id` int(20) AUTO_INCREMENT,
55    `CharacterID` varchar(12),
56    `Name` varchar(100),
57    `CorporationID` varchar(12),
58    `AccessLevel` int(1) DEFAULT 0,
59    PRIMARY KEY (`id`),
60    UNIQUE KEY `id` (`id`)
61) ENGINE=InnoDB DEFAULT CHARSET=latin1;
62
63--
64-- Table structure for `Corporations`
65--
66
67CREATE TABLE IF NOT EXISTS `Corporations` (
68    `id` int(20) AUTO_INCREMENT,
69    `CorporationID` varchar(12),
70    `Name` varchar(100),
71    `AllianceID` varchar(12),
72    `AccessLevel` int(1) DEFAULT 0,
73    PRIMARY KEY (`id`),
74    UNIQUE KEY `id` (`id`)
75) ENGINE=InnoDB DEFAULT CHARSET=latin1;
76
77--
78-- Table structure for `Alliances`
79--
80
81CREATE TABLE IF NOT EXISTS `Alliances` (
82    `id` int(20) AUTO_INCREMENT,
83    `AllianceID` varchar(12),
84    `Name` varchar(100),
85    `AccessLevel` int(1) DEFAULT 0,
86    PRIMARY KEY (`id`),
87    UNIQUE KEY `id` (`id`)
88) ENGINE=InnoDB DEFAULT CHARSET=latin1;
89
90--
91-- Table structure for `AllianceNames`
92--
93
94CREATE TABLE IF NOT EXISTS `AllianceNames` (
95    `AllianceID` varchar(12),
96    `Name` varchar(100),
97    PRIMARY KEY (`AllianceID`),
98    UNIQUE KEY `AllianceID` (`AllianceID`)
99) ENGINE=InnoDB DEFAULT CHARSET=latin1;
100
101--
102-- Table structure for `CorporationNames`
103--
104
105CREATE TABLE IF NOT EXISTS `CorporationNames` (
106    `CorporationID` varchar(12),
107    `Name` varchar(100),
108    PRIMARY KEY (`CorporationID`),
109    UNIQUE KEY `CorporationID` (`CorporationID`)
110) ENGINE=InnoDB DEFAULT CHARSET=latin1;
111
112--
113-- Table structure for `Logs`
114-- 
115
116CREATE TABLE IF NOT EXISTS `Logs` (
117    `id` int(20) AUTO_INCREMENT,
118    `User` varchar(100),
119    `Entry` text,
120    `Timestamp` timestamp,
121    PRIMARY KEY (`id`),
122    UNIQUE KEY `id` (`id`)
123) ENGINE=InnoDB DEFAULT CHARSET=latin1;
124
125--
126-- Table structure for `Install`
127--
128
129CREATE TABLE IF NOT EXISTS `Install` (
130    `Installed` tinyint(1),
131    PRIMARY KEY (`Installed`),
132    UNIQUE KEY `Installed` (`Installed`)
133) ENGINE=InnoDB DEFAULT CHARSET=latin1;
134
135INSERT INTO `Install` (`Installed`) VALUES (0);