7ab445e081614ee49b5db83108297ecc.sql

来自「利用C语言实现的人工智能系统」· SQL 代码 · 共 18 行

CREATE TABLE Object_Interactions
(
	ID INTEGER NOT NULL PRIMARY KEY,
	Object_ID INTEGER NOT NULL,
	Interaction_Object_ID INTEGER NOT NULL
);

INSERT INTO Object_Interactions (ID, Object_ID, Interaction_Object_ID) VALUES (NULL, 1, 2);
INSERT INTO Object_Interactions (ID, Object_ID, Interaction_Object_ID) VALUES (NULL, 3, 2);
INSERT INTO Object_Interactions (ID, Object_ID, Interaction_Object_ID) VALUES (NULL, 4, 2);
INSERT INTO Object_Interactions (ID, Object_ID, Interaction_Object_ID) VALUES (NULL, 5, 1);
INSERT INTO Object_Interactions (ID, Object_ID, Interaction_Object_ID) VALUES (NULL, 6, 7);
INSERT INTO Object_Interactions (ID, Object_ID, Interaction_Object_ID) VALUES (NULL, 6, 1);
INSERT INTO Object_Interactions (ID, Object_ID, Interaction_Object_ID) VALUES (NULL, 8, 6);

CREATE UNIQUE INDEX idxObjectInteractions ON Object_Interactions (Object_ID ASC, Interaction_Object_ID ASC);