aboutsummaryrefslogblamecommitdiffstats
path: root/vendor/examples/sql/mysql.locks.sql
blob: 96a3a88d95ceb6d3fb3c9417f248423db6bf45e9 (plain) (tree)
1
2
3
4
5
6
7
8
9




                                                            
                         

                  
                        
                 

                                        
CREATE TABLE locks (
    id INTEGER UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
    owner VARCHAR(100),
    timeout INTEGER UNSIGNED,
    created INTEGER,
    token VARBINARY(100),
    scope TINYINT,
    depth TINYINT,
    uri VARBINARY(1000),
    INDEX(token),
    INDEX(uri(100))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;