MariaDB 10.5

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();


version()


10.5.11-MariaDB


create table mview_state
(
	state_id int unsigned auto_increment comment 'View State ID'
		primary key,
	view_id varchar(255) null comment 'View ID',
	mode varchar(16) default 'disabled' null comment 'View Mode',
	status varchar(16) default 'idle' null comment 'View Status',
	updated datetime null comment 'View updated time',
	version_id int unsigned null comment 'View Version ID'
)
comment 'View State';

create index MVIEW_STATE_MODE
	on mview_state (mode);

create index MVIEW_STATE_VIEW_ID
	on mview_state (view_id);
	

SHOW GRANTS;


Grants for u_1479398063@localhost


GRANT USAGE ON *.* TO `u_1479398063`@`localhost` IDENTIFIED BY PASSWORD '*8A29E9359A67694BB1CA96883B65825E0CFAA7F3'


INSERT INTO mview_state (state_id, view_id, mode, status, updated, version_id) VALUES (1, 'design_config_dummy', 'enabled', 'idle', '2021-06-29 22:30:05', 0);
INSERT INTO mview_state (state_id, view_id, mode, status, updated, version_id) VALUES (2, 'customer_dummy', 'disabled', 'idle', '2021-03-03 12:06:23', 0);
INSERT INTO mview_state (state_id, view_id, mode, status, updated, version_id) VALUES (3, 'catalog_category_product', 'enabled', 'idle', '2021-06-29 22:30:05', 461);
INSERT INTO mview_state (state_id, view_id, mode, status, updated, version_id) VALUES (4, 'catalog_product_category', 'enabled', 'idle', '2021-06-29 22:29:03', 98015);
INSERT INTO mview_state (state_id, view_id, mode, status, updated, version_id) VALUES (5, 'catalogrule_rule', 'enabled', 'idle', '2021-06-29 22:30:05', 0);
INSERT INTO mview_state (state_id, view_id, mode, status, updated, version_id) VALUES (6, 'catalog_product_attribute', 'enabled', 'idle', '2021-06-29 22:30:05', 2310051);
INSERT INTO mview_state (state_id, view_id, mode, status, updated, version_id) VALUES (7, 'cataloginventory_stock', 'enabled', 'idle', '2021-06-29 22:30:05', 90478);
INSERT INTO mview_state (state_id, view_id, mode, status, updated, version_id) VALUES (8, 'inventory', 'enabled', 'idle', '2021-06-29 22:30:05', 271476);
INSERT INTO mview_state (state_id, view_id, mode, status, updated, version_id) VALUES (9, 'catalogrule_product', 'enabled', 'idle', '2021-06-29 22:29:03', 2505904);
INSERT INTO mview_state (state_id, view_id, mode, status, updated, version_id) VALUES (10, 'catalog_product_price', 'enabled', 'working', '2021-06-29 22:30:05', 56676992);
INSERT INTO mview_state (state_id, view_id, mode, status, updated, version_id) VALUES (11, 'amasty_xsearch_category_fulltext', 'enabled', 'idle', '2021-06-29 22:29:03', 54687);
INSERT INTO mview_state (state_id, view_id, mode, status, updated, version_id) VALUES (12, 'catalogsearch_fulltext', 'enabled', 'idle', '2021-06-29 22:29:03', 2547077);
INSERT INTO mview_state (state_id, view_id, mode, status, updated, version_id) VALUES (33, 'amasty_mostviewed_rule_product', 'enabled', 'idle', '2021-06-29 22:29:03', 2);
INSERT INTO mview_state (state_id, view_id, mode, status, updated, version_id) VALUES (34, 'amasty_mostviewed_product_rule', 'enabled', 'idle', '2021-06-29 22:29:03', 17980739);
INSERT INTO mview_state (state_id, view_id, mode, status, updated, version_id) VALUES (35, 'amasty_sorting_bestseller', 'enabled', 'idle', '2021-06-29 22:29:03', 0);
INSERT INTO mview_state (state_id, view_id, mode, status, updated, version_id) VALUES (36, 'amasty_sorting_most_viewed', 'enabled', 'idle', '2021-06-29 22:29:03', 0);
INSERT INTO mview_state (state_id, view_id, mode, status, updated, version_id) VALUES (37, 'amasty_sorting_wished', 'enabled', 'idle', '2021-06-29 22:29:03', 0);
INSERT INTO mview_state (state_id, view_id, mode, status, updated, version_id) VALUES (38, 'amasty_yotpo_review', 'enabled', 'idle', '2021-06-29 22:30:16', 0);
INSERT INTO mview_state (state_id, view_id, mode, status, updated, version_id) VALUES (43, 'amasty_elastic_relevance_rule_rule', 'enabled', 'idle', '2021-06-29 22:29:03', 0);
INSERT INTO mview_state (state_id, view_id, mode, status, updated, version_id) VALUES (44, 'amasty_elastic_relevance_rule_product', 'enabled', 'idle', '2021-06-29 22:29:03', 18507058);
INSERT INTO mview_state (state_id, view_id, mode, status, updated, version_id) VALUES (45, 'amasty_elastic_popup_data', 'enabled', 'idle', '2021-06-29 22:29:03', 0);
INSERT INTO mview_state (state_id, view_id, mode, status, updated, version_id) VALUES (46, 'amasty_xlanding_product_page', 'enabled', 'idle', '2021-06-29 22:29:03', 13596598);
INSERT INTO mview_state (state_id, view_id, mode, status, updated, version_id) VALUES (47, 'amasty_xlanding_page_product', 'enabled', 'idle', '2021-06-29 22:29:03', 0);
INSERT INTO mview_state (state_id, view_id, mode, status, updated, version_id) VALUES (48, 'merchandiser_product_attribute', 'enabled', 'idle', '2021-06-29 22:29:03', 3027849);
select * from mview_state;


state_id
view_id
mode
status
updated
version_id


1
design_config_dummy
enabled
idle
2021-06-29 22:30:05
0

2
customer_dummy
disabled
idle
2021-03-03 12:06:23
0

3
catalog_category_product
enabled
idle
2021-06-29 22:30:05
461

4
catalog_product_category
enabled
idle
2021-06-29 22:29:03
98015

5
catalogrule_rule
enabled
idle
2021-06-29 22:30:05
0

6
catalog_product_attribute
enabled
idle
2021-06-29 22:30:05
2310051

7
cataloginventory_stock
enabled
idle
2021-06-29 22:30:05
90478

8
inventory
enabled
idle
2021-06-29 22:30:05
271476

9
catalogrule_product
enabled
idle
2021-06-29 22:29:03
2505904

10
catalog_product_price
enabled
working
2021-06-29 22:30:05
56676992

11
amasty_xsearch_category_fulltext
enabled
idle
2021-06-29 22:29:03
54687

12
catalogsearch_fulltext
enabled
idle
2021-06-29 22:29:03
2547077

33
amasty_mostviewed_rule_product
enabled
idle
2021-06-29 22:29:03
2

34
amasty_mostviewed_product_rule
enabled
idle
2021-06-29 22:29:03
17980739

35
amasty_sorting_bestseller
enabled
idle
2021-06-29 22:29:03
0

36
amasty_sorting_most_viewed
enabled
idle
2021-06-29 22:29:03
0

37
amasty_sorting_wished
enabled
idle
2021-06-29 22:29:03
0

38
amasty_yotpo_review
enabled
idle
2021-06-29 22:30:16
0

43
amasty_elastic_relevance_rule_rule
enabled
idle
2021-06-29 22:29:03
0

44
amasty_elastic_relevance_rule_product
enabled
idle
2021-06-29 22:29:03
18507058

45
amasty_elastic_popup_data
enabled
idle
2021-06-29 22:29:03
0

46
amasty_xlanding_product_page
enabled
idle
2021-06-29 22:29:03
13596598

47
amasty_xlanding_page_product
enabled
idle
2021-06-29 22:29:03
0

48
merchandiser_product_attribute
enabled
idle
2021-06-29 22:29:03
3027849

state_id	view_id	mode	status	updated	version_id
1	design_config_dummy	enabled	idle	2021-06-29 22:30:05	0
2	customer_dummy	disabled	idle	2021-03-03 12:06:23	0
3	catalog_category_product	enabled	idle	2021-06-29 22:30:05	461
4	catalog_product_category	enabled	idle	2021-06-29 22:29:03	98015
5	catalogrule_rule	enabled	idle	2021-06-29 22:30:05	0
6	catalog_product_attribute	enabled	idle	2021-06-29 22:30:05	2310051
7	cataloginventory_stock	enabled	idle	2021-06-29 22:30:05	90478
8	inventory	enabled	idle	2021-06-29 22:30:05	271476
9	catalogrule_product	enabled	idle	2021-06-29 22:29:03	2505904
10	catalog_product_price	enabled	working	2021-06-29 22:30:05	56676992
11	amasty_xsearch_category_fulltext	enabled	idle	2021-06-29 22:29:03	54687
12	catalogsearch_fulltext	enabled	idle	2021-06-29 22:29:03	2547077
33	amasty_mostviewed_rule_product	enabled	idle	2021-06-29 22:29:03	2
34	amasty_mostviewed_product_rule	enabled	idle	2021-06-29 22:29:03	17980739
35	amasty_sorting_bestseller	enabled	idle	2021-06-29 22:29:03	0
36	amasty_sorting_most_viewed	enabled	idle	2021-06-29 22:29:03	0
37	amasty_sorting_wished	enabled	idle	2021-06-29 22:29:03	0
38	amasty_yotpo_review	enabled	idle	2021-06-29 22:30:16	0
43	amasty_elastic_relevance_rule_rule	enabled	idle	2021-06-29 22:29:03	0
44	amasty_elastic_relevance_rule_product	enabled	idle	2021-06-29 22:29:03	18507058
45	amasty_elastic_popup_data	enabled	idle	2021-06-29 22:29:03	0
46	amasty_xlanding_product_page	enabled	idle	2021-06-29 22:29:03	13596598
47	amasty_xlanding_page_product	enabled	idle	2021-06-29 22:29:03	0
48	merchandiser_product_attribute	enabled	idle	2021-06-29 22:29:03	3027849