040326   9 : 56 : 05  

 32  Query begin 
 56  Query begin 
 56  Query insert into firm (dir,old)values( 1 , 0 ) 
 56  Query select last_insert_id() as id 
 56  Query update firm set id= 5799 , parentid= 0 , dir= 1 , old= 0 , short= "XXXXXXX" , full= "XXXXXXXXX" , address= "", postaddres="  ", phone="  ", director="  ", inn="  ", kpp="  ", okpo="  ", okonh="  ", rascount="  ", bank="  ", korcount="  ", bik="  ", city=331 , pers= 52 , city1= 331 , ip62av=" 62 /АВ/ПРОЧ/ 000  ", ip62p="  62 /П/ПРОЧ/ 000  ", type="  00  ", email=" ", wp= 125  where id= 5799  
 56  Query update firm set dir= 0  where id= 5799  
 56  Query update firm set parentid= 0  where id= 5799  

 040326   10 : 06 : 37  

 56  Query select short as name from firm where _rowid=  5799  LOCK IN SHARE MODE 

 040326   11 : 08 : 33  

 6  Query begin 
 6  Query select short as name from firm where _rowid=  3969  LOCK IN SHARE MODE 

 040326   11 : 09 : 48  

 58  Query begin 
 58  Query select short as name from firm where _rowid=  0  LOCK IN SHARE MODE 
 58  Query select short as name from firm where _rowid=  0  LOCK IN SHARE MODE 
 58  Query select short as name from firm where _rowid=  375  LOCK IN SHARE MODE 
 58  Query select short as name from firm where _rowid=  375  LOCK IN SHARE MODE 
 77  Query begin 
 77  Query insert into firm (dir,old)values( 1 , 0 ) 
 77  Query select last_insertid() as id 
 78  Query begin 
 78  Query insert into firm (dir,old)values( 1 , 0 ) 
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 
Connectivity error: [TCX][MyODBC]Lock wait timeout exceeded; Try restarting transaction 

CREATE TABLE `firm` ( 
`id` int( 11 ) NOT NULL auto_increment, 
`parentid` int( 11 ) NOT NULL default '0', 
`dir` tinyint( 4 ) NOT NULL default '0', 
`old` tinyint( 4 ) NOT NULL default '0', 
`short` char( 50 ) NOT NULL default '', 
`full` char( 50 ) NOT NULL default '', 
`address` char( 80 ) NOT NULL default '', 
`postaddres` char( 80 ) NOT NULL default '', 
`phone` char( 50 ) NOT NULL default '', 
`director` char( 50 ) NOT NULL default '', 
`inn` char( 13 ) NOT NULL default '', 
`kpp` char( 13 ) NOT NULL default '', 
`okpo` char( 15 ) NOT NULL default '', 
`okonh` char( 15 ) NOT NULL default '', 
`rascount` char( 20 ) NOT NULL default '', 
`bank` char( 60 ) NOT NULL default '', 
`korcount` char( 20 ) NOT NULL default '', 
`bik` char( 15 ) NOT NULL default '', 
`city` int( 11 ) default NULL, 
`pers` int( 11 ) default NULL, 
`city1` int( 11 ) default NULL, 
`ip62av` char( 20 ) NOT NULL default '62/á÷/ðòïþ/000', 
`ip62p` char( 20 ) NOT NULL default '62/ð/ðòïþ/000', 
`type` enum('00','01','10','11') NOT NULL default '00', 
`email` char( 100 ) NOT NULL default '', 
`wp` int( 11 ) default NULL, 
PRIMARY KEY (`id`), 
KEY `dir` (`dir`), 
KEY `old` (`old`), 
KEY `city` (`city`), 
KEY `short` (`short`), 
KEY `pers` (`pers`), 
KEY `city1` (`city1`), 
KEY `parentid` (`parentid`), 
KEY `wp` (`wp`), 
CONSTRAINT `0_7481` FOREIGN KEY (`city`) REFERENCES `city` (`id`), 
CONSTRAINT `0_7482` FOREIGN KEY (`pers`) REFERENCES `pers` (`id`), 
CONSTRAINT `0_7483` FOREIGN KEY (`city1`) REFERENCES `city` (`id`), 
CONSTRAINT `firm_ibfk_1` FOREIGN KEY (`wp`) REFERENCES `wp` (`id`) 
) TYPE=InnoDB