+#
+# Database upgrade script Front Accounting
+# Source version: 2.0.x
+# Target version: 2.1.0
+#
+# To make upgrades clean and failsafe:
+# * Precede all CREATE TABLE statment with DROP TABLE IF EXISTS
+# * Precede all ALTER TABLE statements using ADD column with respective
+# ALTER TABLE with DROP column
+# * Move all other DROP queries (e.g. removing obsolete tables) to installer
+# - they are not executed during non-forced upgrade.
+#
+
+DROP TABLE IF EXISTS `0_attachments`;
+
+CREATE TABLE `0_attachments` (
+ `id` int(11) UNSIGNED NOT NULL auto_increment,
+ `description` varchar(60) NOT NULL default '',
+ `type_no` int(11) NOT NULL default '0',
+ `trans_no` int(11) NOT NULL default '0',
+ `unique_name` varchar(60) NOT NULL default '',
+ `tran_date` date NOT NULL default '0000-00-00',
+ `filename` varchar(60) NOT NULL default '',
+ `filesize` int(11) NOT NULL default '0',
+ `filetype` varchar(60) NOT NULL default '',
+ PRIMARY KEY (`id`),
+ KEY `type_no` (`type_no`,`trans_no`)
+) TYPE=MyISAM AUTO_INCREMENT=1 ;
+
+DROP TABLE IF EXISTS `0_groups`;
+
+CREATE TABLE `0_groups` (
+ `id` smallint(6) UNSIGNED NOT NULL auto_increment,
+ `description` varchar(60) NOT NULL default '',
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `description` (`description`)
+) TYPE=MyISAM AUTO_INCREMENT=1 ;
+
+INSERT INTO `0_groups` VALUES ('1', 'Small');
+INSERT INTO `0_groups` VALUES ('2', 'Medium');
+INSERT INTO `0_groups` VALUES ('3', 'Large');
+
+DROP TABLE IF EXISTS `0_recurrent_invoices`;
+
+CREATE TABLE `0_recurrent_invoices` (
+ `id` smallint(6) UNSIGNED NOT NULL auto_increment,
+ `description` varchar(60) NOT NULL default '',
+ `order_no` int(11) UNSIGNED NOT NULL,
+ `debtor_no` int(11) UNSIGNED NULL default NULL,
+ `group_no` smallint(6) UNSIGNED NULL default NULL,
+ `days` int(11) NOT NULL default '0',
+ `monthly` int(11) NOT NULL default '0',
+ `begin` date NOT NULL default '0000-00-00',
+ `end` date NOT NULL default '0000-00-00',
+ `last_sent` date NOT NULL default '0000-00-00',
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `description` (`description`)
+) TYPE=InnoDB AUTO_INCREMENT=1 ;
+
+ALTER TABLE `0_cust_branch` DROP COLUMN `group_no`;
+ALTER TABLE `0_cust_branch` ADD `group_no` int(11) NOT NULL default '0';