-------------------------------------------
TABLE   | Create Table
-------------------------------------------

CPT_MVT | CREATE TABLE `CPT_MVT` (
  `ID_CPT` int(11) default NULL,
  `ID_MVT` int(11) NOT NULL auto_increment,
  `ID_DEVISE` int(11) default NULL,
  `CODE_OPE` varchar(4) default NULL,
  `CODE_FAMILLE` varchar(4) default NULL,
  `MNT_DEV` decimal(28,6) default NULL,
  `MNT_EUR` decimal(28,6) default NULL,
  `DATE_OPE` datetime default NULL,
  `DATE_VALEUR` datetime default NULL,
  `NUM_ECR` varchar(7) default NULL,
  `LIBELLE` varchar(200) default NULL,
  `CODE_EXO` char(1) default NULL,
  `DEVISE_ORIGINE` char(1) default NULL,
  PRIMARY KEY  (`ID_MVT`),
  KEY `ID_DEVISE` (`ID_DEVISE`),
  KEY `ID_CPT` (`ID_CPT`),
  KEY `ID_CPT_DATEOPE` (`ID_CPT`,`DATE_OPE`),
  KEY `ID_CPT_DATEVAL` USING BTREE (`ID_CPT`,`DATE_VALEUR`)
) ENGINE=MyISAM AUTO_INCREMENT=6414155 DEFAULT CHARSET=latin1 


---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Name              | Engine | Version | Row_format | Rows   | Avg_row_length | Data_length | Max_data_length   | Index_length | Data_free | Auto_increment | Create_time         | Update_time         | Check_time          | Collation         | Checksum | Create_options | Comment |
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
CPT_MVT           | MyISAM |      10 | Dynamic    | 463996 |            121 |    57774296 |   281474976710655 |     55699456 |   1403256 |        6414155 | 2006-10-03 13:58:47 | 2007-03-09 04:47:05 | 2006-10-03 13:59:11 | latin1_swedish_ci |     NULL |                |         |         
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------