· 6 years ago · Jan 26, 2020, 10:30 AM
1-- Adminer 4.3.1 MySQL dump
2
3SET NAMES utf8;
4SET time_zone = '+00:00';
5SET foreign_key_checks = 0;
6SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
7
8DROP TABLE IF EXISTS `projects`;
9CREATE TABLE `projects` (
10 `project_id` int(11) NOT NULL AUTO_INCREMENT,
11 `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE current_timestamp(),
12 `fenix_project_id` varchar(100) COLLATE utf8_czech_ci DEFAULT NULL,
13 `price` int(11) DEFAULT NULL,
14 `user_id` int(11) NOT NULL,
15 `status` enum('10','20','25','30','35','40','50','60','70','80','100','101','102','103','104','105','110','0') COLLATE utf8_czech_ci NOT NULL DEFAULT '10',
16 `description` text COLLATE utf8_czech_ci NOT NULL,
17 `client_id` int(11) NOT NULL,
18 `source_id` int(11) NOT NULL,
19 PRIMARY KEY (`project_id`),
20 KEY `source_id` (`source_id`),
21 KEY `user_id` (`user_id`),
22 KEY `client_id` (`client_id`),
23 CONSTRAINT `projects_ibfk_2` FOREIGN KEY (`source_id`) REFERENCES `source` (`source_id`) ON DELETE NO ACTION,
24 CONSTRAINT `projects_ibfk_4` FOREIGN KEY (`user_id`) REFERENCES `user` (`user_id`),
25 CONSTRAINT `projects_ibfk_5` FOREIGN KEY (`client_id`) REFERENCES `client` (`client_id`) ON DELETE NO ACTION
26) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
27
28INSERT INTO `projects` (`project_id`, `date`, `fenix_project_id`, `price`, `user_id`, `status`, `description`, `client_id`, `source_id`) VALUES
29(5, '2019-06-06 13:19:14', '1/2018/1651', 29632, 10, '40', '<p>Tak co zase jebe :D</p><p><br></p><p>Co je?</p>', 5, 2),
30(11, '2019-06-06 13:13:34', '19236', 35000, 1, '103', '', 11, 7),
31(15, '2019-05-31 16:09:27', NULL, NULL, 1, '10', '', 11, 6),
32(16, '2019-06-06 13:31:28', '19207', 12000, 10, '100', '', 13, 1),
33(17, '2020-01-10 15:44:12', '1/2019/2751', 1212, 7, '20', '', 5, 2),
34(18, '2020-01-10 15:44:12', '1/2019/2140', 69326, 10, '20', '', 5, 2),
35(19, '2020-01-10 15:44:12', '1/2019/2819', 2334, 10, '20', '', 5, 2),
36(20, '2019-07-31 10:48:47', NULL, NULL, 4, '10', '', 14, 19),
37(21, '2019-07-31 11:17:33', '19207', NULL, 1, '10', '', 14, 3),
38(22, '2020-01-10 15:32:52', '1/2020/145', NULL, 10, '10', '', 5, 2),
39(23, '2020-01-10 15:32:53', '1/2020/146', NULL, 10, '10', '', 5, 2);
40
41DROP TABLE IF EXISTS `status_update`;
42CREATE TABLE `status_update` (
43 `status_id` int(11) NOT NULL AUTO_INCREMENT,
44 `project_id` int(11) NOT NULL,
45 `date` datetime DEFAULT NULL ON UPDATE current_timestamp(),
46 `status` enum('10','20','25','30','35','40','50','60','70','80','100','101','102','103','104','105','110','0') COLLATE utf8_czech_ci DEFAULT NULL,
47 `message` text COLLATE utf8_czech_ci DEFAULT NULL,
48 PRIMARY KEY (`status_id`),
49 KEY `project_id` (`project_id`),
50 CONSTRAINT `status_update_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`project_id`) ON DELETE CASCADE
51) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
52
53INSERT INTO `status_update` (`status_id`, `project_id`, `date`, `status`, `message`) VALUES
54(7, 5, '2019-04-12 13:28:13', '10', 'Test, Ano.'),
55(10, 11, '2019-03-04 15:06:23', '10', 'Ano je to nová nabídka.'),
56(14, 5, '2019-03-13 13:42:33', '20', NULL),
57(18, 5, '2019-03-13 13:43:25', '30', NULL),
58(20, 5, '2019-03-13 13:45:50', '20', NULL),
59(22, 5, '2019-03-13 13:48:16', '40', NULL),
60(50, 5, '2019-05-07 11:11:06', '30', NULL),
61(51, 5, '2019-05-07 11:12:43', '30', NULL),
62(52, 5, '2019-05-07 11:24:29', '30', NULL),
63(53, 5, '2019-05-07 11:34:13', '40', NULL),
64(54, 5, '2019-05-07 11:34:42', '40', NULL),
65(55, 11, '2019-05-29 12:44:15', '60', NULL),
66(61, 11, '2019-05-31 15:41:00', '60', NULL),
67(62, 15, '2019-05-31 16:09:27', '10', NULL),
68(63, 16, '2019-06-03 10:01:39', '10', NULL),
69(64, 16, '2019-06-03 10:02:17', '20', NULL),
70(65, 16, '2019-06-03 10:02:43', '100', NULL),
71(66, 11, '2019-06-06 13:13:34', '100', NULL),
72(67, 11, '2019-06-11 11:26:52', '103', NULL),
73(68, 11, '2019-06-16 11:38:09', '104', NULL),
74(69, 11, '2019-06-16 11:38:14', '105', NULL),
75(70, 11, '2019-06-16 11:38:20', '110', NULL),
76(71, 11, '2019-06-16 11:38:25', '104', NULL),
77(72, 11, '2019-06-16 11:38:28', '104', NULL),
78(73, 11, '2019-06-16 11:38:32', '103', NULL),
79(74, 17, '2019-07-08 09:44:35', '10', NULL),
80(75, 18, '2019-07-08 10:23:39', '10', NULL),
81(76, 19, '2019-07-08 10:23:39', '10', NULL),
82(77, 20, '2019-07-31 10:48:47', '10', NULL),
83(78, 21, '2019-07-31 11:17:33', '10', NULL),
84(79, 22, '2020-01-10 15:32:53', '10', NULL),
85(80, 23, '2020-01-10 15:32:53', '10', NULL);
86
87-- 2020-01-26 10:26:04