salix/db/versions/.archive/10407-blueOak/00-firstScript.sql

6 lines
284 B
MySQL
Raw Permalink Normal View History

use vn;
CREATE TABLE `supplierDebtConfig` (
`dated` DATE NOT NULL DEFAULT '2014-12-31' COMMENT 'date from which we start counting',
`invalidBalances` DOUBLE NOT NULL DEFAULT 0.5 COMMENT 'balances not to be paid'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;