· 8 years ago · Mar 01, 2018, 02:34 PM
1-- Adminer 4.6.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
8SET NAMES utf8mb4;
9
10DROP TABLE IF EXISTS `fields_values`;
11CREATE TABLE `fields_values` (
12 `id` bigint(20) NOT NULL AUTO_INCREMENT,
13 `field_id` bigint(20) DEFAULT NULL,
14 `entity_id` bigint(20) NOT NULL,
15 `enum_id` bigint(20) DEFAULT NULL,
16 `_extra` json DEFAULT NULL,
17 `production_start_date` timestamp GENERATED ALWAYS AS (if((`field_id` = 7),if((json_unquote(json_extract(`_extra`,'$[0].value')) regexp '([0-9]{4}-[0-9]{2}-[0-9]{2})'),json_unquote(json_extract(`_extra`,'$[0].value')),'0000-00-00 00:00:00'),'0000-00-00 00:00:00')) VIRTUAL NOT NULL,
18 PRIMARY KEY (`id`),
19 KEY `field_id` (`field_id`),
20 KEY `entity_id` (`entity_id`),
21 KEY `enum_id` (`enum_id`)
22) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
23
24
25-- 2018-03-01 14:31:37