fa3ec39fe0334231937ebb70643b6582.sql

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

CREATE TABLE Interaction_Properties 
(
	Object_Interaction_ID INTEGER NOT NULL, 
	Property_ID INTEGER NOT NULL
);

INSERT INTO Interaction_Properties (Object_Interaction_ID, Property_ID) VALUES (1, 7);
INSERT INTO Interaction_Properties (Object_Interaction_ID, Property_ID) VALUES (1, 14);
INSERT INTO Interaction_Properties (Object_Interaction_ID, Property_ID) VALUES (1, 15);
INSERT INTO Interaction_Properties (Object_Interaction_ID, Property_ID) VALUES (2, 17);
INSERT INTO Interaction_Properties (Object_Interaction_ID, Property_ID) VALUES (3, 7);
INSERT INTO Interaction_Properties (Object_Interaction_ID, Property_ID) VALUES (3, 39);
INSERT INTO Interaction_Properties (Object_Interaction_ID, Property_ID) VALUES (3, 36);
INSERT INTO Interaction_Properties (Object_Interaction_ID, Property_ID) VALUES (4, 7);
INSERT INTO Interaction_Properties (Object_Interaction_ID, Property_ID) VALUES (4, 39);
INSERT INTO Interaction_Properties (Object_Interaction_ID, Property_ID) VALUES (4, 36);
INSERT INTO Interaction_Properties (Object_Interaction_ID, Property_ID) VALUES (5, 7);
INSERT INTO Interaction_Properties (Object_Interaction_ID, Property_ID) VALUES (6, 7);
INSERT INTO Interaction_Properties (Object_Interaction_ID, Property_ID) VALUES (7, 7);

CREATE UNIQUE INDEX idxInteractionProperties ON Interaction_Properties (Object_Interaction_ID ASC, Property_ID ASC);