   `retail_price` decimal(9,2) NOT NULL DEFAULT '0.00',
   `discount_type` enum('percentage','relative','fixed') DEFAULT NULL,
   `discount` decimal(9,2) DEFAULT NULL,
-  `taxfree` tinyint(1) NOT NULL,
-  `minimum_quantity` int(10) unsigned NOT NULL,
+  `taxfree` tinyint(4) NOT NULL DEFAULT '0',
+  `minimum_quantity` int(10) unsigned NOT NULL DEFAULT '1',
   `active` tinyint(1) NOT NULL,
-  `deleted` tinyint(1) NOT NULL,
+  `deleted` tinyint(4) NOT NULL DEFAULT '0',
   PRIMARY KEY (`id`),
   UNIQUE KEY `code` (`code`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `person` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `company` varchar(255) DEFAULT NULL,
  `address` text,

  `tax_id` varchar(255) DEFAULT NULL,
  `payment_account_id` varchar(50) DEFAULT NULL,
  `active` tinyint(1) NOT NULL,
  `deleted` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
