summaryrefslogtreecommitdiff
path: root/maintenance/locking/file_locks.sql
blob: f51d06b3f6cf9c63b4bde5c2868c68aa0115deff (plain)
1
2
3
4
5
6
7
8
9
10
11
-- Table to handle resource locking (EX) with row-level locking
CREATE TABLE /*_*/filelocks_exclusive (
	fle_key binary(31) NOT NULL PRIMARY KEY
) ENGINE=InnoDB, CHECKSUM=0;

-- Table to handle resource locking (SH) with row-level locking
CREATE TABLE /*_*/filelocks_shared (
	fls_key binary(31) NOT NULL,
	fls_session binary(31) NOT NULL,
	PRIMARY KEY (fls_key,fls_session)
) ENGINE=InnoDB, CHECKSUM=0;