`gender` varchar(10) NOT NULL DEFAULT 'UNKNOWN' COMMENT 'Gender',
`first_name` varchar(100) NOT NULL COMMENT 'First name',
`family_name` varchar(100) NOT NULL COMMENT 'Family name',
- `company_name` varchar(255) DEFAULT NULL COMMENT 'Company name',
`street` varchar(255) DEFAULT NULL COMMENT 'Street name',
`house_number` smallint(5) unsigned DEFAULT NULL COMMENT 'House number',
`city` varchar(100) DEFAULT NULL COMMENT 'City name',
`item_type` VARCHAR(20) NOT NULL COMMENT 'Item type',
`amount` bigint(20) unsigned NOT NULL COMMENT 'Ordered amount',
`added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Record inserted',
- PRIMARY KEY (`id),
+ PRIMARY KEY (`id`),
INDEX (`order_id`),
INDEX (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Ordered items';
`title` varchar(100) NOT NULL COMMENT 'Title of product',
`price` decimal(20,2) unsigned NOT NULL COMMENT 'Product price',
`available` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Whether product is available',
- PRIMARY (`id`),
+ PRIMARY KEY (`id`),
INDEX (`category`)
) ENGINE=InnoDBDEFAULT CHARSET=utf8 COMMENT='Products';