OceanBase Deploy: 3.1.1
REVISION: 94b5853a18ad1ad09d5afc30d9edb44643dd488c
BUILD_BRANCH: HEAD
BUILD_TIME: Jan 06 2025 11:35:49OURCE
【备注】基于 LLM 和开源文档 RAG 的论坛小助手已开放测试,在发帖时输入 [@论坛小助手] 即可召唤小助手,欢迎试用!
CREATE TABLE IF NOT EXISTS type
(
id
BIGINT auto_increment COMMENT ‘ID’,
name
VARCHAR(32) NOT NULL COMMENT ‘设备类型’,
UNIQUE unique_indexes
(name
),
PRIMARY KEY (id
)
) ENGINE=InnoDB COMMENT ‘设备类型’;
CREATE TABLE IF NOT EXISTS device
(
id
BIGINT auto_increment COMMENT ‘ID’,
name
VARCHAR(32) NOT NULL COMMENT ‘设备名称’,
sn
VARCHAR(32) COMMENT ‘设备编号’,
type_id
BIGINT,
UNIQUE unique_indexes
(type_id
, sn
),
PRIMARY KEY (id
),
CONSTRAINT fk_device_type
FOREIGN KEY (type_id
)
REFERENCES type
(id
)
ON DELETE CASCADE
ON UPDATE CASCADE
) ENGINE=InnoDB COMMENT ‘设备’;
创建第二个表报错
ERROR 4034 (HY000): Deserialize error