0337d704 |
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 | |