BEHcxLus

1DROP TABLE IF EXISTS LOCK;
2CREATE TABLE LOCK (LOCK_NAME varchar(100),CREATOR varchar(100),APP_NAME varchar(100),EXPIRED_TIME bigint,CREATE_TIME bigint,DURATION bigint);
3ALTER TABLE LOCK ALTER LOCK_NAME SET NOT NULL;
4ALTER TABLE LOCK ALTER APP_NAME SET NOT NULL;
5ALTER TABLE LOCK ADD PRIMARY KEY (LOCK_NAME, APP_NAME)