upgrade/0.9.3/70_money.sql

   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