openant电商-商品

-- 数据库大全：openant电商-商品
-- 来源：YesApi.cn
CREATE TABLE `yesapi_openant_product` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `product_id` int(11) NOT NULL COMMENT '',
    `address_id` int(11) NOT NULL COMMENT '',
    `stock_status_id` int(11) NOT NULL COMMENT '',
    `freight_template_id` int(11) NOT NULL COMMENT '',
    `image` varchar(255) NOT NULL COMMENT '',
    `manufacturer_id` int(11) NOT NULL COMMENT '',
    `shipping` tinyint(1) NOT NULL DEFAULT '1' COMMENT '',
    `price` decimal(15,4) NOT NULL DEFAULT '0.0000' COMMENT '',
    `points` int(8) NOT NULL DEFAULT '0' COMMENT '',
    `user_points` int(11) NOT NULL COMMENT '',
    `tax_class_id` int(11) NOT NULL COMMENT '',
    `weight` decimal(15,8) NOT NULL DEFAULT '0.00000000' COMMENT '',
    `weight_class_id` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `length` decimal(15,8) NOT NULL DEFAULT '0.00000000' COMMENT '',
    `width` decimal(15,8) NOT NULL DEFAULT '0.00000000' COMMENT '',
    `height` decimal(15,8) NOT NULL DEFAULT '0.00000000' COMMENT '',
    `length_class_id` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `subtract` tinyint(1) NOT NULL DEFAULT '1' COMMENT '',
    `maximum` int(3) NOT NULL COMMENT '',
    `commission_rate` int(11) NOT NULL DEFAULT '1' COMMENT '',
    `store_id` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `sort_order` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `seo_order` float(11,4) NOT NULL DEFAULT '0.0000' COMMENT '',
    `yesapi_openant_product_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '上下架',
    `viewed` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `quantity` int(11) NOT NULL COMMENT '',
    `invalid` tinyint(1) NOT NULL DEFAULT '0' COMMENT '永久屏蔽',
    `date_added` datetime NOT NULL COMMENT '',
    `date_modified` datetime NOT NULL COMMENT '',
    `date_invalid` datetime NOT NULL COMMENT '',
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'openant电商-商品';

复制后，到数据库执行，即可创建此数据库表。