37b14a996b1c495b952de81294beed47.sql

利用C语言实现的人工智能系统

CREATE TABLE Object_Properties
(
	ID INTEGER NOT NULL PRIMARY KEY,
	Object_ID INTEGER NOT NULL,
	Property_ID INTEGER NOT NULL,
	Unit_ID INTEGER NOT NULL 
);

INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 1, 10, 8);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 1, 12, 8);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 1, 7, 4);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 1, 15, 11);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 2, 10, 8);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 2, 12, 8);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 2, 7, 4);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 2, 14, 11);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 3, 17, 4);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 1, 22, 4);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 1, 23, 14);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 1, 24, 13);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 1, 25, 15);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 1, 26, 4);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 1, 27, 4);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 1, 28, 16);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 1, 29, 5);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 2, 22, 4);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 2, 23, 14);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 2, 24, 13);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 2, 25, 15);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 2, 26, 4);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 2, 27, 4);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 2, 28, 16);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 2, 29, 5);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 1, 31, 4);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 2, 31, 4);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 1, 32, 1);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 3, 32, 1);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 4, 32, 1);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 4, 33, 9);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 3, 15, 11);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 34, 17);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 35, 17);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 37, 4);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 38, 4);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 7, 4);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 40, 18);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 41, 18);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 39, 18);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 36, 18);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 42, 4);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 43, 4);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 44, 18);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 45, 18);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 46, 19);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 47, 19);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 48, 19);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 49, 19);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 50, 19);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 51, 19);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 52, 4);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 53, 19);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 54, 19);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 55, 4);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 56, 19);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 57, 19);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 58, 4);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 59, 19);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 60, 19);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 61, 4);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 62, 19);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 63, 19);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 64, 4);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 65, 19);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 66, 19);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 67, 4);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 34, 17);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 35, 17);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 37, 4);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 38, 4);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 7, 4);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 40, 18);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 41, 18);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 39, 18);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 36, 18);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 42, 4);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 43, 4);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 44, 18);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 45, 18);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 46, 19);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 47, 19);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 48, 19);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 49, 19);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 50, 19);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 51, 19);


INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 51, 3);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 52, 18);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 53, 18);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 54, 3);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 55, 18);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 56, 18);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 57, 3);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 58, 18);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 59, 18);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 60, 3);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 61, 18);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 62, 18);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 63, 3);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 64, 18);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 65, 18);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 66, 3);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 6, 3);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 6, 68, 8);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 6, 69, 3);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 7, 6, 3);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 4, 31, 0);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 31, 0);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 6, 31, 0);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 7, 31, 0);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 6, 67, 16);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 1, 17, 16);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 2, 17, 16);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 3, 17, 16);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 4, 17, 16);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 5, 17, 16);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 6, 17, 16);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 7, 17, 16);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 7, 70, 8);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 8, 38, 17);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 8, 17, 16);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 8, 31, 0);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 8, 72, 3);
INSERT INTO Object_Properties (ID, Object_ID, Property_ID, Unit_ID) VALUES (NULL, 7, 73, 16);

CREATE UNIQUE INDEX idxObjectProperties ON Object_Properties (ID ASC);
CREATE INDEX idxObjects ON Object_Properties (Object_ID ASC);