1 -- Table to handle resource locking (EX) with row-level locking
2 CREATE TABLE /*_*/filelocks_exclusive (
3 fle_key
binary(31) NOT NULL PRIMARY KEY
4 ) ENGINE
=InnoDB
, CHECKSUM
=0;
6 -- Table to handle resource locking (SH) with row-level locking
7 CREATE TABLE /*_*/filelocks_shared (
8 fls_key
binary(31) NOT NULL,
9 fls_session
binary(31) NOT NULL,
10 PRIMARY KEY (fls_key
,fls_session
)
11 ) ENGINE
=InnoDB
, CHECKSUM
=0;