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