BHHtUgJp

1--
2-- Структура таблицы `assignment`
3--
4
5CREATE TABLE IF NOT EXISTS `assignment` (
6  `assignment_id` int(11) NOT NULL AUTO_INCREMENT,
7  `assignment_create` datetime NOT NULL,
8  `assignment_deadline` datetime NOT NULL,
9  `assignment_type` int(11) NOT NULL,
10  `assignment_name` varchar(255) NOT NULL,
11  `assignment_process` int(11) NOT NULL,
12  `assignment_author` int(11) NOT NULL,
13  `assignment_actionee` int(11) NOT NULL,
14  `assignment_department` int(11) DEFAULT NULL,
15  `assignment_process_group` int(11) DEFAULT NULL,
16  `assignment_process_stage` int(11) DEFAULT NULL,
17  `assignment_process_performer` int(11) NOT NULL,
18  `assignment_grade` int(11) NOT NULL,
19  `assignment_status` int(11) NOT NULL DEFAULT '1',
20  `assignment_from` varchar(255) DEFAULT NULL,
21  `descriptions` text,
22  `send_message` int(11) DEFAULT NULL,
23  `execution_time` datetime DEFAULT NULL,
24  `contragent_id` int(11) DEFAULT NULL,
25  `contractor_id` int(11) DEFAULT [...]
26	
2710 Quit  
28 160916  0:43:53       11 Connect   root@localhost on 
29       11 Connect   Access denied for user 'root'@'localhost' (using    password: YES)
30       12 Connect   root@localhost on 
31       12 Query SET CHARACTER SET 'utf8mb4'
32       12 Query SET collation_connection = 'utf8mb4_unicode_ci'
33       12 Query SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SCHEMATA`
34       12 Init DB   mysql
35 160916  0:43:54       12 Quit  
36 160916  0:44:01       13 Connect   root@localhost on 
37       13 Connect   Access denied for user 'root'@'localhost' (using     password: YES)
38       14 Connect   root@localhost on 
39       14 Query SET CHARACTER SET 'utf8mb4'
40       14 Query SET collation_connection = 'utf8mb4_unicode_ci'
41       14 Query SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SCHEMATA`
42       14 Query SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"
43       14 Query -- phpMyAdmin SQL Dump
44 -- version 4.0.10.10
45 -- http://www.phpmyadmin.net
46 --
47 -- РҐРѕСЃС‚: 127.0.0.1:3306
48 -- Время создания: Авг 14 2016 г., 10:03
49 -- Версия сервера: 5.6.26
50 -- Версия PHP: 5.6.12
51
52 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"
53       14 Query SET time_zone = "+00:00"
54       14 Query /*!40101 SET    @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */
55       14 Query /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */
56       14 Query /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */
57       14 Query /*!40101 SET NAMES utf8 */
58       14 Query SELECT @@lc_messages
59       14 Query SELECT @@lc_messages
60       14 Query SELECT @@lc_messages
61       14 Query SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SCHEMATA`,  (SELECT DB_first_level FROM ( SELECT DISTINCT SUBSTRING_INDEX(SCHEMA_NAME, '_',  1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE TRUE ) t ORDER BY DB_first_level ASC LIMIT 0, 100) t2 WHERE 1 = LOCATE(CONCAT(DB_first_level,   '_'), CONCAT(SCHEMA_NAME, '_')) ORDER BY SCHEMA_NAME ASC
62       14 Query SELECT COUNT(*) FROM ( SELECT DISTINCT  SUBSTRING_INDEX(SCHEMA_NAME, '_', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE TRUE ) t
63       14 Query SELECT COUNT(*) FROM ( SELECT DISTINCT  SUBSTRING_INDEX(SCHEMA_NAME, '_', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE TRUE ) t
64       14 Quit  
65 160916  0:44:02       15 Connect   root@localhost on 
66       15 Connect   Access denied for user 'root'@'localhost' (using  password: YES)
67       16 Connect   root@localhost on 
68       16 Query SET CHARACTER SET 'utf8mb4'
69       16 Query SET collation_connection = 'utf8mb4_unicode_ci'
70       16 Query SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SCHEMATA`
71       16 Query SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SCHEMATA`,  (SELECT DB_first_level FROM ( SELECT DISTINCT SUBSTRING_INDEX(SCHEMA_NAME, '_',  1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE TRUE ) t ORDER BY  DB_first_level ASC LIMIT 0, 100) t2 WHERE 1 = LOCATE(CONCAT(DB_first_level,  '_'), CONCAT(SCHEMA_NAME, '_')) ORDER BY SCHEMA_NAME ASC
72       16 Query SELECT COUNT(*) FROM ( SELECT DISTINCT  SUBSTRING_INDEX(SCHEMA_NAME, '_', 1) DB_first_level FROM  INFORMATION_SCHEMA.SCHEMATA WHERE TRUE ) t
73       16 Query SELECT COUNT(*) FROM ( SELECT DISTINCT  SUBSTRING_INDEX(SCHEMA_NAME, '_', 1) DB_first_level FROM  INFORMATION_SCHEMA.SCHEMATA WHERE TRUE ) t
74       16 Quit
75	
76`assignment_id` int(11) NOT NULL AUTO_INCREMENT