-- xx表
CREATE TABLE n_device (
id varchar(36) COLLATE Chinese_PRC_CI_AS NOT NULL,
name varchar(128) COLLATE Chinese_PRC_CI_AS NULL,
code varchar(36) COLLATE Chinese_PRC_CI_AS NULL,
device_type varchar(36) COLLATE Chinese_PRC_CI_AS NULL,
mobile varchar(36) COLLATE Chinese_PRC_CI_AS NULL,
market_key varchar(36) COLLATE Chinese_PRC_CI_AS NULL,
market_name varchar(36) COLLATE Chinese_PRC_CI_AS NULL,
merchant_pkey varchar(36) COLLATE Chinese_PRC_CI_AS NULL,
merchant_shop_num varchar(36) COLLATE Chinese_PRC_CI_AS NULL,
merchant_name varchar(128) COLLATE Chinese_PRC_CI_AS NULL,
status int DEFAULT 0,
last_online_time datetime NULL,
last_connect_time int NULL,
extra varchar(2000) COLLATE Chinese_PRC_CI_AS NULL,
pkey varchar(36) COLLATE Chinese_PRC_CI_AS NULL,
soft_version varchar(36) COLLATE Chinese_PRC_CI_AS NULL,
user_pk varchar(36) COLLATE Chinese_PRC_CI_AS NULL,
create_time datetime NULL,
update_time datetime NULL,
version int DEFAULT 0,
deleted int DEFAULT 0,
CONSTRAINT pk_n_device PRIMARY KEY (id)
);
CREATE INDEX idx_n_device_code ON n_device (code);
CREATE INDEX idx_n_device_mobile ON n_device (mobile);
CREATE INDEX idx_n_device_market_key ON n_device (market_key);
CREATE INDEX idx_n_device_market_name ON n_device (market_name);
数据库创建索引
最新推荐文章于 2022-07-17 09:53:04 发布