<ruby id="bdb3f"></ruby>

    <p id="bdb3f"><cite id="bdb3f"></cite></p>

      <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
        <p id="bdb3f"><cite id="bdb3f"></cite></p>

          <pre id="bdb3f"></pre>
          <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

          <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
          <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

          <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                <ruby id="bdb3f"></ruby>

                ??碼云GVP開源項目 12k star Uniapp+ElementUI 功能強大 支持多語言、二開方便! 廣告
                ## 1.商品主表 ``` CREATE TABLE `ims_goods`(`goods_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,`cat_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '分類id',`goods_sn` varchar(60) NOT NULL DEFAULT '' COMMENT '商品貨號', `goods_name` varchar(120) NOT NULL DEFAULT '' COMMENT '商品名',`click_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '瀏覽量', `brand_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '品牌id', `suppliers_id` varchar(100) NOT NULL DEFAULT '' COMMENT '供應商id', `market_price` decimal(9,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '市場價格', `shop_price` decimal(9,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '本店售價', `promote_price` decimal(9,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '促銷價格', `promote_start_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '促銷開始日期', `promote_end_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '促銷結束日期', `keywords` varchar(255) NOT NULL DEFAULT '' COMMENT '商品關鍵字', `goods_brief` varchar(255) NOT NULL DEFAULT '' COMMENT '商品簡介', `goods_desc` text NOT NULL COMMENT '商品詳情', `goods_img` varchar(255) NOT NULL DEFAULT '' COMMENT '商品圖' , `is_putaway` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否上架', `putaway_time` timestamp NOT NULL COMMENT '上架時間', `create_time` timestamp NOT NULL COMMENT '添加時間', `sort_order` smallint(4) unsigned NOT NULL DEFAULT '100' COMMENT '排序', `is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否被刪除', `is_best` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '精品', `is_new` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '新品', `is_hot` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '熱銷', `is_promote` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '促銷', `goods_for` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '商品歸屬于哪個活動', `give_integral` int(11) NOT NULL DEFAULT '-1' COMMENT '贈送積分', `rank_integral` int(11) NOT NULL DEFAULT '-1' COMMENT '贈送等級經驗', `rest_count` mediumint(5) NOT NULL DEFAULT '0' COMMENT '庫存', `sell_count` mediumint(5) NOT NULL DEFAULT '0' COMMENT '銷量', PRIMARY KEY(`goods_id`), KEY`goods_sn`(`goods_sn`), KEY`cat_id`(`cat_id`), KEY`brand_id`(`brand_id`), KEY`promote_end_date`(`promote_end_date`), KEY`promote_start_date`(`promote_start_date`) )ENGINE=MyISAM DEFAULT CHARSET=utf8 ```
                  <ruby id="bdb3f"></ruby>

                  <p id="bdb3f"><cite id="bdb3f"></cite></p>

                    <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
                      <p id="bdb3f"><cite id="bdb3f"></cite></p>

                        <pre id="bdb3f"></pre>
                        <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

                        <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
                        <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

                        <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                              <ruby id="bdb3f"></ruby>

                              哎呀哎呀视频在线观看