CREATE TABLE 32300 IF NOT EXISTS zapr id int unsigned NOT NULL auto_in

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
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);