[platal.git] / upgrade / 0.9.3 / 70_money.sql

-- MySQL dump 9.11
--
-- Host: localhost    Database: trezo
-- ------------------------------------------------------
-- Server version	4.0.22-log

--
-- Table structure for table `operations`
--

CREATE TABLE `money_trezo` (
  `id` int(11) NOT NULL auto_increment,
  `date` date NOT NULL default '0000-00-00',
  `label` varchar(80) NOT NULL default '',
  `credit` decimal(10,2) NOT NULL default '0.00',
  `debit` decimal(10,2) NOT NULL default '0.00',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM COMMENT='Table des comptes de l''assoce';

insert into money_trezo
   select * from trezo.operations;

drop table trezo.operations;
drop database trezo;
Commit	Line	Data
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