Table: nornix_site.lock

Structure
Name	Type	Null	Key	Default
DocumentNo	int(10) unsigned	NO	PRI
User	varchar(64)	NO
TS	timestamp	NO		CURRENT_TIMESTAMP

Indexes
Non-unique	Key	Seq	Column	Collation	Cardinality	Sub part	Packed	Null	Type	Comment
0	PRIMARY	1	DocumentNo	A	0				BTREE

Information
Engine	Row format	Table collation	Create options
MyISAM	Fixed	utf8_general_ci	row_format=FIXED

CREATE TABLE `lock` (
  `DocumentNo` int(10) unsigned NOT NULL,
  `User` varchar(64) NOT NULL,
  `TS` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`DocumentNo`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED