Akinaolegon7Так нагляднее
Муж, упорный в своих намерениях? ну тоже позиция, чё...
сейчас , таблица kartab
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.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
kartab CREATE TABLE `kartab` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`lic_sch` varchar(16) NOT NULL DEFAULT '',
`fam` varchar(64) DEFAULT NULL,
`name` varchar(64) DEFAULT NULL,
`otch` varchar(64) DEFAULT NULL,
`cod_tn` varchar(8) DEFAULT NULL,
`cod_st` varchar(8) DEFAULT NULL,
`home` varchar(10) DEFAULT NULL,
`kv` varchar(10) DEFAULT NULL,
`kom` int(5) DEFAULT NULL,
`chlenov` int(5) DEFAULT NULL,
`telef` varchar(16) DEFAULT NULL,
`cod_kat` varchar(16) DEFAULT NULL,
`cod_tpr` varchar(16) DEFAULT NULL,
`schlamp` int(1) DEFAULT NULL,
`rabot` int(1) DEFAULT NULL,
`shifr` varchar(15) DEFAULT NULL,
`cod_pd` varchar(10) DEFAULT NULL,
`koment` varchar(128) DEFAULT NULL,
`plit` int(1) DEFAULT NULL,
`yearmon` date DEFAULT NULL,
`errsum` int(11) DEFAULT NULL,
`errsumn` int(11) DEFAULT NULL,
`summa_kn` int(11) DEFAULT NULL,
`summa_kc` int(11) DEFAULT NULL,
`cod_con` varchar(16) DEFAULT NULL,
`srednee` int(11) DEFAULT NULL,
`mesyac` int(11) DEFAULT NULL,
`date_otkpl` date DEFAULT NULL,
`date_otkfk` date DEFAULT NULL,
`nomer_tp` varchar(16) DEFAULT NULL,
`fider` varchar(11) DEFAULT NULL,
`nomer_opor` varchar(16) DEFAULT NULL,
`smena` varchar(16) DEFAULT NULL,
`data_kon` int(11) DEFAULT NULL,
`date_kon` date DEFAULT NULL,
`familiya` varchar(64) DEFAULT NULL,
`pr_opl` varchar(8) DEFAULT NULL,
`akt` int(4) DEFAULT NULL,
`cod_pred` varchar(8) DEFAULT NULL,
`date_zap` date DEFAULT NULL,
`lgota` varchar(4) DEFAULT NULL,
`procent` varchar(11) DEFAULT NULL,
`date_dog` date DEFAULT NULL,
`cod_isp` varchar(8) DEFAULT NULL,
`rachpok` int(10) DEFAULT NULL,
`pokazanie` int(11) DEFAULT NULL,
`dkont` decimal(7,2) DEFAULT NULL,
`date_r` date DEFAULT NULL,
`date_lgt` date DEFAULT NULL,
`reg_nom` varchar(16) DEFAULT NULL,
`cod_tp` varchar(6) DEFAULT NULL,
`date_pr` date DEFAULT NULL,
`priravn` int(6) DEFAULT NULL,
`dog` varchar(8) DEFAULT NULL,
`penya_t` int(11) DEFAULT NULL,
`askue` int(1) DEFAULT NULL,
`summa_vd` int(16) DEFAULT NULL,
`cod_vid` int(4) DEFAULT NULL,
`lg_kvt` int(11) DEFAULT NULL,
`errsumv` int(11) DEFAULT NULL,
`kvt_mes` int(11) DEFAULT NULL,
`summa_mes` int(16) DEFAULT NULL,
`old_lgt` int(1) DEFAULT NULL,
`deti` int(1) DEFAULT NULL,
`pr_erip` int(1) DEFAULT NULL,
`cod_alg` varchar(11) DEFAULT NULL,
`n_sch` varchar(32) DEFAULT NULL,
`cod_tsch` varchar(16) DEFAULT NULL,
`fider_code` varchar(32) DEFAULT NULL,
`tp_code` varchar(32) DEFAULT NULL,
`line_code` varchar(32) DEFAULT NULL,
`del` int(1) DEFAULT NULL,
`base` varchar(16) DEFAULT NULL,
PRIMARY KEY (`id`,`lic_sch`),
UNIQUE KEY `id` (`id`),
UNIQUE KEY `lic_sch` (`lic_sch`) USING BTREE,
KEY `base` (`base`),
KEY `n_tsch` (`n_sch`),
KEY `cod_tsch` (`cod_tsch`)
) ENGINE=MyISAM AUTO_INCREMENT=536243 DEFAULT CHARSET=utf8
сейчас , таблица kartkvgd
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.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
kartkvgd CREATE TABLE `kartkvgd` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`lic_sch` varchar(16) DEFAULT NULL,
`pachka` varchar(10) DEFAULT NULL,
`yearmon` date DEFAULT NULL,
`err` int(1) DEFAULT NULL,
`errsum` int(11) DEFAULT NULL,
`ko` int(4) DEFAULT NULL,
`data_old` int(11) DEFAULT NULL,
`data_new` int(11) DEFAULT NULL,
`razn_kn` int(11) DEFAULT NULL,
`razn_kc` int(11) DEFAULT NULL,
`kft_kn` int(11) DEFAULT NULL,
`kft_kc` int(11) DEFAULT NULL,
`tar_kn` double(9,2) DEFAULT NULL,
`tar_kc` double(9,2) DEFAULT NULL,
`summa_kn` int(11) DEFAULT NULL,
`summa_kc` int(11) DEFAULT NULL,
`penya_k` double(10,2) DEFAULT NULL,
`komiss_k` double(10,2) DEFAULT NULL,
`proc` int(4) DEFAULT NULL,
`razn_rn` int(11) DEFAULT NULL,
`razn_rc` int(11) DEFAULT NULL,
`kft_rn` double(10,5) DEFAULT NULL,
`kft_rc` double(10,5) DEFAULT NULL,
`tar_rn` double(10,2) DEFAULT NULL,
`tar_rc` double(10,2) DEFAULT NULL,
`summa_rn` double(10,2) DEFAULT NULL,
`summa_rc` int(16) DEFAULT NULL,
`penya_r` double(10,2) DEFAULT NULL,
`date_r` date DEFAULT NULL,
`primechanie` varchar(64) DEFAULT NULL,
`norma` int(11) DEFAULT NULL,
`familiya` varchar(64) DEFAULT NULL,
`cod_opl` int(8) DEFAULT NULL,
`prpen` int(4) DEFAULT NULL,
`date_vd` date DEFAULT NULL,
`time_vd` varchar(0) DEFAULT NULL,
`reg_nom` varchar(64) DEFAULT NULL,
`vyp_doh` int(11) DEFAULT NULL,
`no` int(11) DEFAULT NULL,
`raznpen` int(11) DEFAULT NULL,
`del` int(1) DEFAULT NULL,
`base` varchar(16) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`),
KEY `lic_sch` (`lic_sch`),
KEY `base` (`base`),
KEY `date_r` (`date_r`),
KEY `del` (`del`) USING BTREE,
KEY `yearmon` (`yearmon`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=29872212 DEFAULT CHARSET=utf8
|
