| 1 | -- MySQL dump 9.11 |
| 2 | -- |
| 3 | -- Host: localhost Database: trezo |
| 4 | -- ------------------------------------------------------ |
| 5 | -- Server version 4.0.22-log |
| 6 | |
| 7 | -- |
| 8 | -- Table structure for table `operations` |
| 9 | -- |
| 10 | |
| 11 | CREATE TABLE `money_trezo` ( |
| 12 | `id` int(11) NOT NULL auto_increment, |
| 13 | `date` date NOT NULL default '0000-00-00', |
| 14 | `label` varchar(80) NOT NULL default '', |
| 15 | `credit` decimal(10,2) NOT NULL default '0.00', |
| 16 | `debit` decimal(10,2) NOT NULL default '0.00', |
| 17 | PRIMARY KEY (`id`) |
| 18 | ) TYPE=MyISAM COMMENT='Table des comptes de l''assoce'; |
| 19 | |
| 20 | insert into money_trezo |
| 21 | select * from trezo.operations; |
| 22 | |
| 23 | drop table trezo.operations; |
| 24 | drop database trezo; |
| 25 | |