2 CREATE TABLE core_locking (
3 id int(11) NOT NULL AUTO_INCREMENT,
6 ALTER TABLE core_locking ADD COLUMN on_table varchar(64) NOT NULL DEFAULT '';
7 ALTER TABLE core_locking ADD COLUMN on_id int(11) NOT NULL DEFAULT 0;
8 ALTER TABLE core_locking ADD COLUMN person_id int(11) NOT NULL DEFAULT 0;
9 ALTER TABLE core_locking ADD COLUMN created datetime ;
11 alter table core_locking ADD INDEX lookup(on_table, on_id, person_id, created);
12 -- oops... - wrong name of pid.
13 alter table core_locking change column `int` id int(11) auto_increment not null;