delete from dm_bins where BIN > 1;
UPDATE dm_bins set LAST_REC=0 where BIN = 1;
ALTER TABLE dm_bins  AUTO_INCREMENT=1 ;
--
-- Dumping data for table `dm_bins`
--
ALTER TABLE dm_customer  AUTO_INCREMENT=1 ;
delete from dm_locs where REC_NO > 21;
ALTER TABLE dm_locs  AUTO_INCREMENT=1 ;
--
delete from Cimage where REC_NO > 21;
ALTER TABLE Cimage  AUTO_INCREMENT=1 ;
--
delete from dm_locs where REC_NO > 21;
ALTER TABLE dm_locs  AUTO_INCREMENT=1 ;
--
## delete from doc_link;
ALTER TABLE doc_link  AUTO_INCREMENT=1 ;
--
## delete from dwgtype;
ALTER TABLE dwgtype  AUTO_INCREMENT=1 ;
--
delete from lnch_id where REC_NO > 21;
ALTER TABLE lnch_id  AUTO_INCREMENT=1 ;
--
delete from tab_locs where REC_NO > 21;
ALTER TABLE tab_locs  AUTO_INCREMENT=1 ;
--
delete from user_ctl;
ALTER TABLE user_ctl  AUTO_INCREMENT=1 ;
--
delete from user_gr;
ALTER TABLE user_gr  AUTO_INCREMENT=1 ;
--
delete from walk_gr;
ALTER TABLE walk_gr  AUTO_INCREMENT=1 ;
--
## delete from dwgtype;
ALTER TABLE DOC_GROUP  AUTO_INCREMENT=1 ;
--
--
