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
| CREATE TABLE comptage (
id_comptage int(10) NOT NULL auto_increment,
date_lecture date NOT NULL default '0000-00-00',
numero int(5) NOT NULL default '0',
station varchar(20) NOT NULL default '',
`date` varchar(15) NOT NULL default '',
heure varchar(10) NOT NULL default '',
ligne int(5) NOT NULL default '0',
compbrut int(15) NOT NULL default '0',
cptchauf int(15) NOT NULL default '0',
corrige1 int(15) NOT NULL default '0',
bct int(15) NOT NULL default '0',
bruthf int(15) NOT NULL default '0',
brutbf int(15) NOT NULL default '0',
ajoute_chauf int(11) NOT NULL default '0',
ajoute1 int(11) NOT NULL default '0',
ajoute2 int(11) NOT NULL default '0',
p decimal(10,3) NOT NULL default '0.000',
t decimal(10,3) NOT NULL default '0.000',
cf decimal(10,3) NOT NULL default '0.000',
pcs decimal(5,4) NOT NULL default '0.0000',
error int(5) NOT NULL default '0',
defcorr int(15) NOT NULL default '0',
defbrut int(15) NOT NULL default '0',
diaph int(15) NOT NULL default '0',
cptelecj int(15) NOT NULL default '0',
cptelecn int(15) NOT NULL default '0',
cptelecp int(15) NOT NULL default '0',
energie bigint(30) NOT NULL default '0',
message longtext NOT NULL,
over_cor1 int(1) NOT NULL default '0',
overbct int(1) NOT NULL default '0',
over_brut1 int(1) NOT NULL default '0',
over_bruthf int(1) NOT NULL default '0',
over_brutbf int(1) NOT NULL default '0',
over_chauf int(1) NOT NULL default '0',
over_engy int(1) NOT NULL default '0',
factmul decimal(4,3) NOT NULL default '0.000',
teletrans int(11) NOT NULL default '0',
KEY id_comptage (id_comptage)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
Partager