CREATE TABLE /*!32300 IF NOT EXISTS*/ zapr (
  id int(6) unsigned NOT NULL auto_increment,
  KOD int(4) NOT NULL DEFAULT '0' ,
  ZDATA date NOT NULL DEFAULT '2006-01-01' ,
  FAM varchar(20) NOT NULL DEFAULT '' ,
  NAM varchar(20) NOT NULL DEFAULT '' ,
  OTCH varchar(20) NOT NULL DEFAULT '' ,
  IDATA date NOT NULL DEFAULT '2006-01-01' ,
  ISPOL varchar(20) NOT NULL DEFAULT '' ,
  ICHAR varchar(100) NOT NULL DEFAULT '' ,
  ZCHAR varchar(100) NOT NULL DEFAULT '' ,
  DOC longtext ,
  nal_kser tinyint(3) unsigned ,
  count_kser tinyint(3) unsigned ,
  plus tinyint(3) unsigned ,
  PRIMARY KEY (id)
);


#
# Dumping data for table 'zapr'
#
INSERT INTO zapr VALUES("1","117","2005-04-20","Осколкова","Ирина","Владимировна","2005-04-20","Охапкина О.В.","награждение
медалью","Архивная справка","ф.
12680
",NULL,NULL,NULL);
INSERT INTO zapr VALUES("2","118","2005-02-07","Обжирина","Валентина","Ивановна","2005-02-08","Жданова Н.В.","зарплата
1987-1991
","Архивная справка","ф.6833, оп.23, д.2198, лл.21-24,58-61,95-98,134-13",NULL,NULL,NULL);
INSERT INTO zapr VALUES("3","120","2005-02-07","Кольцов","Валерий","Васильевич","2005-02-18","Ахрамеева М.П.","стаж
","Архивная справка","ф.6900, оп.1, л.180, 283; д.1046, л.341.
",NULL,NULL,NULL);
INSERT INTO zapr VALUES("4","123","2005-02-07","Ушаков","Ушаков","Викторович","2005-02-07","Чудиновских Е.Н.","удостоверение","Чудиновских Е.Н.","",NULL,NULL,NULL);
INSERT INTO zapr VALUES("5","133","2005-02-08","Мачехин А.И.","Константин","Николаевич","2005-02-08","Чудиновских Е.Н.","сведения о прадеде Мелашко К.Н.","сведения","ф.98, оп.2, д.1804; ф.4112, оп.17, д.7980; ф.879,",NULL,NULL,NULL);
INSERT INTO zapr VALUES("6","124","2005-02-07","Мухлисов","Гафеван","","2005-02-07","Чудиновских Е.Н.","награждение
поб.соц","Письмо об уточнении","",NULL,NULL,NULL);
INSERT INTO zapr VALUES("7","127","2005-02-08","Копанен","Нина","Ивановна","2005-02-15","Охапкина О.В.","стаж","Архивная справка","Личная карточка: ф. 6833, оп. 23, д.2974, л. 383
",NULL,NULL,NULL);