distpano/current.sql at master · xprilion/distpano · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
-- Adminer 4.6.2 MySQL dump

SET NAMES utf8;
SET time_zone = '+00:00';
SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

DROP DATABASE IF EXISTS `sih`;
CREATE DATABASE `sih` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `sih`;

DROP TABLE IF EXISTS `action`;
CREATE TABLE `action` (
  `actionid` int(10) NOT NULL AUTO_INCREMENT,
  `taskid` int(10) NOT NULL,
  `imgid1` int(10) NOT NULL,
  `imgid2` int(10) NOT NULL,
  `h` int(3) NOT NULL,
  `v` int(3) NOT NULL,
  `status` int(3) NOT NULL,
  `result` text NOT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`actionid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


DROP TABLE IF EXISTS `clients`;
CREATE TABLE `clients` (
  `cid` int(10) NOT NULL AUTO_INCREMENT,
  `chash` varchar(40) NOT NULL,
  `last_active` varchar(15) NOT NULL,
  `status` int(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`cid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


DROP TABLE IF EXISTS `client_action`;
CREATE TABLE `client_action` (
  `caid` bigint(30) NOT NULL AUTO_INCREMENT,
  `cid` bigint(20) NOT NULL,
  `aid` bigint(20) NOT NULL,
  `started` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `stopped` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`caid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


DROP TABLE IF EXISTS `outputs`;
CREATE TABLE `outputs` (
  `did` bigint(20) NOT NULL AUTO_INCREMENT,
  `taskid` bigint(20) NOT NULL,
  `imgid1` bigint(20) NOT NULL,
  `imgid2` bigint(20) NOT NULL,
  `actid` bigint(20) NOT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `isfinal` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`did`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


DROP TABLE IF EXISTS `pending`;
CREATE TABLE `pending` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `task_id` int(10) NOT NULL,
  `oname` varchar(100) NOT NULL,
  `name_hash` varchar(33) NOT NULL,
  `time` int(10) NOT NULL,
  `ext` varchar(10) NOT NULL,
  `staged` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


DROP TABLE IF EXISTS `staged`;
CREATE TABLE `staged` (
  `stage_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `task_id` bigint(20) NOT NULL,
  `img_id` bigint(20) NOT NULL,
  `h_splits` bigint(20) NOT NULL DEFAULT '9',
  `v_splits` bigint(20) NOT NULL DEFAULT '9',
  `status` tinyint(1) NOT NULL,
  PRIMARY KEY (`stage_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


DROP TABLE IF EXISTS `tasks`;
CREATE TABLE `tasks` (
  `taskid` int(10) NOT NULL AUTO_INCREMENT,
  `oname` varchar(500) NOT NULL,
  `hashname` varchar(32) NOT NULL,
  `created` int(10) NOT NULL,
  `completed` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`taskid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


-- 2018-03-31 02:17:25