detailed_cost_simple.sql

CREATE TABLE `detailed_cost` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`net_amount` BIGINT(20) NOT NULL,
	`vat_amount` BIGINT(20) NOT NULL,
	`product_fee_amount` BIGINT(20) NOT NULL,
	`product_fee_vat_amount` BIGINT(20) NOT NULL,
	`coupon_amount` BIGINT(20) NOT NULL,
	`shipping_amount` BIGINT(20) NOT NULL,
	`service_cost_addresses_amount` BIGINT(20) NOT NULL,
	`service_cost_hardproof_amount` BIGINT(20) NOT NULL,
	`service_cost_softproof_amount` BIGINT(20) NOT NULL,
	`service_cost_exemplar_amount` BIGINT(20) NOT NULL,
	`service_cost_postpay_amount` BIGINT(20) NOT NULL,
	`service_cost_tool_amount` BIGINT(20) NOT NULL,
	`service_cost_other_amount` BIGINT(20) NOT NULL,
	`service_cost_design_amount` BIGINT(20) NOT NULL,
	`currency` VARCHAR(3) NOT NULL DEFAULT 'HUF' COMMENT '(DC2Type:currency)' COLLATE 'utf8_unicode_ci',
	PRIMARY KEY (`id`)
)
COLLATE='utf8_unicode_ci'
ENGINE=InnoDB
;