weiphpdev / weiphp5.0 Goto Github PK

        $this->numRows = $this->PDOStatement->rowCount();

        return $this->numRows;
    } catch (\PDOException $e) {
        if ($this->isBreak($e)) {
            return $this->close()->execute($sql, $bind, $query);
        }

        throw new PDOException($e, $this->config, $this->getLastsql());
    } catch (\Throwable $e) {
        if ($this->isBreak($e)) {
            return $this->close()->execute($sql, $bind, $query);
        }

        throw $e;
    } catch (\Exception $e) {
        if ($this->isBreak($e)) {
            return $this->close()->execute($sql, $bind, $query);

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '更新时间', notice_erp in' at line 63

Error SQL | CREATE TABLE wp_shop_order ( id int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键', goods_datas text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品序列化数据', uid int(10) UNSIGNED NOT NULL COMMENT '用户id', remark text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '备注', order_number varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '订单编号', cTime int(10) NOT NULL COMMENT '订单时间', total_price decimal(10, 2) NULL DEFAULT NULL COMMENT '总价', openid varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'OpenID', pay_status int(10) NULL DEFAULT NULL COMMENT '支付状态', pay_type tinyint(2) NULL DEFAULT 0 COMMENT '支付类型', address_id int(10) NULL DEFAULT NULL COMMENT '配送信息', is_send int(10) NULL DEFAULT 0 COMMENT '是否发货', send_code varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '快递公司编号', send_number varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '快递单号', send_type char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发货类型', is_new tinyint(2) NULL DEFAULT 1 COMMENT '是否为新订单', wpid int(10) NULL DEFAULT NULL COMMENT 'wpid', status_code char(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '订单跟踪状态码', event_type tinyint(2) NULL DEFAULT 0 COMMENT '订单来源', is_lock int(10) NULL DEFAULT 1 COMMENT '数量是否锁定', erp_lock_code text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT 'ERP锁定商品编号', mail_money float NULL DEFAULT 0 COMMENT '邮费金额', stores_id int(10) NULL DEFAULT NULL COMMENT '门店编号', pay_time int(10) NULL DEFAULT NULL COMMENT '支付时间', send_time int(10) NULL DEFAULT NULL COMMENT '发货时间', extra text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '扩展参数', order_state int(10) NULL DEFAULT 1 COMMENT '订单状态', out_trade_no varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '支付的订单号', event_id int(10) NULL DEFAULT NULL COMMENT '活动ID', is_original tinyint(2) NULL DEFAULT 0 COMMENT '活动中是否原价购买', update_at timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '更新时间', notice_erp int(11) NULL DEFAULT 0 COMMENT '为0时不需要推送，大于0时需要推送', refund tinyint(1) NULL DEFAULT 0 COMMENT '退款状态', refund_content varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '退款原因', pay_money decimal(10, 2) NULL DEFAULT NULL COMMENT '实付价格', dec_money decimal(10, 2) NULL DEFAULT NULL COMMENT '优惠价格', PRIMARY KEY (id) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact