fast_admin 添加产品信息后台管理sql

D:\phpstudy_pro\WWW\tp02.com>php think crud -t testlin

============================================================ sql ============================================================ 

CREATE TABLE `fa_category_info` (
`category_id` int(11) NOT NULL,
`parent_id` int(11) NOT NULL DEFAULT '0',
`language_id` int(11) NOT NULL,
`name` varchar(255) NOT NULL,
`description` text NOT NULL,
`meta_title` varchar(255) NOT NULL,
`meta_description` varchar(255) NOT NULL,
`meta_keyword` varchar(255) NOT NULL,
`switch` tinyint(1) DEFAULT '0' COMMENT '开关'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `fa_products_info` (
`product_id` int(11) NOT NULL,
`language_id` int(11) NOT NULL,
`1_cName` text NOT NULL,
`2_pName` varchar(255) NOT NULL,
`3_main_images_URL` varchar(255) NOT NULL,
`4_review_images_URL` text NOT NULL,
`5_desc_and_images_URL` text NOT NULL,
`6_pMeta_title` varchar(255) NOT NULL,
`7_pMeta_keywords` varchar(255) NOT NULL,
`8_pMeta_description` varchar(255) NOT NULL,
`9_price_ori` decimal(15,4) NOT NULL DEFAULT '0.0000',
`10_price_special` decimal(15,4) NOT NULL DEFAULT '0.0000',
`11_property_list01` text NOT NULL,
`12_property_list02` text NOT NULL,
`13_model` varchar(64) NOT NULL,
`switch` tinyint(1) DEFAULT '0' COMMENT '开关'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


ALTER TABLE `fa_category_info`
ADD PRIMARY KEY (`category_id`),
ADD KEY `parent_id` (`parent_id`),
ADD KEY `name` (`name`);

ALTER TABLE `fa_products_info`
ADD PRIMARY KEY (`product_id`,`language_id`),
ADD KEY `name` (`2_pName`);
============================================================ 结束===========================================================================

CREATE TABLE `fa_category` (
`category_id` int(11) NOT NULL,
`image` varchar(255) DEFAULT NULL,
`parent_id` int(11) NOT NULL DEFAULT '0',
`top` tinyint(1) NOT NULL,
`column` int(3) NOT NULL,
`sort_order` int(3) NOT NULL DEFAULT '0',
`status` tinyint(1) NOT NULL,
`date_added` datetime NOT NULL,
`date_modified` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `fa_category_description` (
`category_id` int(11) NOT NULL,
`language_id` int(11) NOT NULL,
`name` varchar(255) NOT NULL,
`description` text NOT NULL,
`meta_title` varchar(255) NOT NULL,
`meta_description` varchar(255) NOT NULL,
`meta_keyword` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

 

CREATE TABLE `fa_product` (
`product_id` int(11) NOT NULL,
`model` varchar(64) NOT NULL,
`sku` varchar(64) NOT NULL,
`upc` varchar(12) NOT NULL,
`ean` varchar(14) NOT NULL,
`jan` varchar(13) NOT NULL,
`isbn` varchar(17) NOT NULL,
`mpn` varchar(64) NOT NULL,
`location` varchar(128) NOT NULL,
`quantity` int(4) NOT NULL DEFAULT '0',
`stock_status_id` int(11) NOT NULL,
`image` varchar(255) DEFAULT NULL,
`manufacturer_id` int(11) NOT NULL,
`shipping` tinyint(1) NOT NULL DEFAULT '1',
`price` decimal(15,4) NOT NULL DEFAULT '0.0000',
`points` int(8) NOT NULL DEFAULT '0',
`tax_class_id` int(11) NOT NULL,
`date_available` date NOT NULL DEFAULT '0000-00-00',
`weight` decimal(15,8) NOT NULL DEFAULT '0.00000000',
`weight_class_id` int(11) NOT NULL DEFAULT '0',
`length` decimal(15,8) NOT NULL DEFAULT '0.00000000',
`width` decimal(15,8) NOT NULL DEFAULT '0.00000000',
`height` decimal(15,8) NOT NULL DEFAULT '0.00000000',
`length_class_id` int(11) NOT NULL DEFAULT '0',
`subtract` tinyint(1) NOT NULL DEFAULT '1',
`minimum` int(11) NOT NULL DEFAULT '1',
`sort_order` int(11) NOT NULL DEFAULT '0',
`status` tinyint(1) NOT NULL DEFAULT '0',
`viewed` int(5) NOT NULL DEFAULT '0',
`date_added` datetime NOT NULL,
`date_modified` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE `fa_product_description` (
`product_id` int(11) NOT NULL,
`language_id` int(11) NOT NULL,
`name` varchar(255) NOT NULL,
`description` text NOT NULL,
`tag` text NOT NULL,
`meta_title` varchar(255) NOT NULL,
`meta_description` varchar(255) NOT NULL,
`meta_keyword` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

posted @ 2021-08-30 16:06  也许明天  阅读(108)  评论(0编辑  收藏  举报