-- Customers table schema (extracted from existing database)
CREATE TABLE IF NOT EXISTS `customers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(400) NOT NULL COMMENT 'Company Name',
  `trading_name` varchar(400) NOT NULL DEFAULT '',
  `abn` varchar(255) DEFAULT NULL,
  `created` datetime NOT NULL,
  `notes` text NOT NULL,
  `discount_pricing_policies` text NOT NULL,
  `payment_terms` varchar(255) NOT NULL,
  `customer_category_id` int(11) NOT NULL,
  `url` varchar(300) NOT NULL,
  `country_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;