knowledge.sql

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

CREATE TABLE Knowledge
(
	ID INTEGER NOT NULL PRIMARY KEY,
	Data VARCHAR(500) NOT NULL,
	Source_ID INTEGER NOT NULL,
	User_ID INTEGER NOT NULL
);

CREATE TABLE Characters
(
	ID INTEGER NOT NULL PRIMARY KEY,
	Character VARCHAR(1) NOT NULL,
	Source_ID INTEGER NOT NULL,
	User_ID INTEGER NOT NULL
);

CREATE UNIQUE INDEX idxCharacters ON Characters (Character ASC);

CREATE TABLE Words
(
	ID INTEGER NOT NULL PRIMARY KEY,
	Word VARCHAR(100) NOT NULL,
	Source_ID INTEGER NOT NULL,
	User_ID INTEGER NOT NULL
);

CREATE UNIQUE INDEX idxWords ON Words (Word ASC);

CREATE TABLE Users
(
	ID INTEGER NOT NULL PRIMARY KEY,
	User_Name VARCHAR(100) NOT NULL
);

CREATE TABLE Sources
(
	ID INTEGER NOT NULL PRIMARY KEY,
	Source VARCHAR(150) NOT NULL
);

INSERT INTO Sources (ID, Source) VALUES (NULL, 'Unknown');
INSERT INTO Sources (ID, Source) VALUES (NULL, 'CMU Dictionary Lex-0.6');
INSERT INTO Sources (ID, Source) VALUES (NULL, 'Knowledge Acquisition');

INSERT INTO Users (ID, User_Name) VALUES (NULL, 'Ovidiu Anghelidi');
INSERT INTO Users (ID, User_Name) VALUES (NULL, 'Michael Schmatz');
INSERT INTO Users (ID, User_Name) VALUES (NULL, 'Maurus Balmer');
INSERT INTO Users (ID, User_Name) VALUES (NULL, 'abuze');
INSERT INTO Users (ID, User_Name) VALUES (NULL, 'Badger');
INSERT INTO Users (ID, User_Name) VALUES (NULL, 'TeeVeeEss');
INSERT INTO Users (ID, User_Name) VALUES (NULL, 'Otto');
INSERT INTO Users (ID, User_Name) VALUES (NULL, 'Tim A. Myers');
INSERT INTO Users (ID, User_Name) VALUES (NULL, 'BlaDe9293');
INSERT INTO Users (ID, User_Name) VALUES (NULL, 'Ludwig Geiger');
INSERT INTO Users (ID, User_Name) VALUES (NULL, 'SEeerS');
INSERT INTO Users (ID, User_Name) VALUES (NULL, 'Bram');
INSERT INTO Users (ID, User_Name) VALUES (NULL, 'RemieJr');
INSERT INTO Users (ID, User_Name) VALUES (NULL, 'Greg');
INSERT INTO Users (ID, User_Name) VALUES (NULL, 'Richard Prins');
INSERT INTO Users (ID, User_Name) VALUES (NULL, 'Matts');
INSERT INTO Users (ID, User_Name) VALUES (NULL, 'Alex');		
INSERT INTO Users (ID, User_Name) VALUES (NULL, 'Jason Goatcher');
INSERT INTO Users (ID, User_Name) VALUES (NULL, 'shinsama');
INSERT INTO Users (ID, User_Name) VALUES (NULL, 'WEKS');
INSERT INTO Users (ID, User_Name) VALUES (NULL, 'Jamous');
INSERT INTO Users (ID, User_Name) VALUES (NULL, 'Don Gatto');
INSERT INTO Users (ID, User_Name) VALUES (NULL, 'Redstone');
INSERT INTO Users (ID, User_Name) VALUES (NULL, 'Carsyn');
INSERT INTO Users (ID, User_Name) VALUES (NULL, 'Viceroy');
INSERT INTO Users (ID, User_Name) VALUES (NULL, 'Barbud [USA]');
INSERT INTO Users (ID, User_Name) VALUES (NULL, 'VieuxLavabo76');
INSERT INTO Users (ID, User_Name) VALUES (NULL, 'RaidZero');
INSERT INTO Users (ID, User_Name) VALUES (NULL, 'Chris');
INSERT INTO Users (ID, User_Name) VALUES (NULL, 'Keck_Komputers');
INSERT INTO Users (ID, User_Name) VALUES (NULL, 'Jeannot Le Tazon');
INSERT INTO Users (ID, User_Name) VALUES (NULL, 'HiveChild');
INSERT INTO Users (ID, User_Name) VALUES (NULL, 'chinookfoehn');
INSERT INTO Users (ID, User_Name) VALUES (NULL, 'George Simeonov');
INSERT INTO Users (ID, User_Name) VALUES (NULL, 'Avatar');
INSERT INTO Users (ID, User_Name) VALUES (NULL, 'comltq');
INSERT INTO Users (ID, User_Name) VALUES (NULL, 'Ageless');
INSERT INTO Users (ID, User_Name) VALUES (NULL, 'Wade Cazabat');
INSERT INTO Users (ID, User_Name) VALUES (NULL, 'KSMarksPsych');
INSERT INTO Users (ID, User_Name) VALUES (NULL, 'Uakey');
INSERT INTO Users (ID, User_Name) VALUES (NULL, 'Eduardo');
INSERT INTO Users (ID, User_Name) VALUES (NULL, 'ArtifexR');
INSERT INTO Users (ID, User_Name) VALUES (NULL, 'GeNoM974');
INSERT INTO Users (ID, User_Name) VALUES (NULL, 'derek704');


INSERT INTO Knowledge (ID, Data, Source_ID, User_ID) VALUES (NULL, '0<1', 3, 1)
INSERT INTO Knowledge (ID, Data, Source_ID, User_ID) VALUES (NULL, '1<2', 3, 1)
INSERT INTO Knowledge (ID, Data, Source_ID, User_ID) VALUES (NULL, '2<3', 3, 1)
INSERT INTO Knowledge (ID, Data, Source_ID, User_ID) VALUES (NULL, '3<4', 3, 1)
INSERT INTO Knowledge (ID, Data, Source_ID, User_ID) VALUES (NULL, '4<5', 3, 1)
INSERT INTO Knowledge (ID, Data, Source_ID, User_ID) VALUES (NULL, '5<6', 3, 1)
INSERT INTO Knowledge (ID, Data, Source_ID, User_ID) VALUES (NULL, '6<7', 3, 1)
INSERT INTO Knowledge (ID, Data, Source_ID, User_ID) VALUES (NULL, '7<8', 3, 1)
INSERT INTO Knowledge (ID, Data, Source_ID, User_ID) VALUES (NULL, '8<9', 3, 1)
INSERT INTO Knowledge (ID, Data, Source_ID, User_ID) VALUES (NULL, '0 is number', 3, 1)
INSERT INTO Knowledge (ID, Data, Source_ID, User_ID) VALUES (NULL, '1 is number', 3, 1)
INSERT INTO Knowledge (ID, Data, Source_ID, User_ID) VALUES (NULL, '2 is number', 3, 1)
INSERT INTO Knowledge (ID, Data, Source_ID, User_ID) VALUES (NULL, '3 is number', 3, 1)
INSERT INTO Knowledge (ID, Data, Source_ID, User_ID) VALUES (NULL, '4 is number', 3, 1)
INSERT INTO Knowledge (ID, Data, Source_ID, User_ID) VALUES (NULL, '5 is number', 3, 1)
INSERT INTO Knowledge (ID, Data, Source_ID, User_ID) VALUES (NULL, '6 is number', 3, 1)
INSERT INTO Knowledge (ID, Data, Source_ID, User_ID) VALUES (NULL, '7 is number', 3, 1)
INSERT INTO Knowledge (ID, Data, Source_ID, User_ID) VALUES (NULL, '8 is number', 3, 1)
INSERT INTO Knowledge (ID, Data, Source_ID, User_ID) VALUES (NULL, '9 is number', 3, 1)
INSERT INTO Knowledge (ID, Data, Source_ID, User_ID) VALUES (NULL, 'a database stores data', 3, 1)
INSERT INTO Knowledge (ID, Data, Source_ID, User_ID) VALUES (NULL, 'person can speak', 3, 1)
INSERT INTO Knowledge (ID, Data, Source_ID, User_ID) VALUES (NULL, 'person can hear', 3, 1)
INSERT INTO Knowledge (ID, Data, Source_ID, User_ID) VALUES (NULL, 'the computer stores information on the hard drive', 3, 1)
INSERT INTO Knowledge (ID, Data, Source_ID, User_ID) VALUES (NULL, 'the harddisk is also called a disk drive', 3, 1)
INSERT INTO Knowledge (ID, Data, Source_ID, User_ID) VALUES (NULL, 'a drive has folders', 3, 1)
INSERT INTO Knowledge (ID, Data, Source_ID, User_ID) VALUES (NULL, 'a folder has files', 3, 1)
INSERT INTO Knowledge (ID, Data, Source_ID, User_ID) VALUES (NULL, 'Jupiter is a planet', 3, 1)
INSERT INTO Knowledge (ID, Data, Source_ID, User_ID) VALUES (NULL, 'Animals are living things', 3, 2)
INSERT INTO Knowledge (ID, Data, Source_ID, User_ID) VALUES (NULL, 'Water is the most common liquid on Earth', 3, 2)
INSERT INTO Knowledge (ID, Data, Source_ID, User_ID) VALUES (NULL, 'Pure water has no smell, taste, or color', 3, 2)
INSERT INTO Knowledge (ID, Data, Source_ID, User_ID) VALUES (NULL, 'Lakes, oceans, and rivers are made of water', 3, 2)
INSERT INTO Knowledge (ID, Data, Source_ID, User_ID) VALUES (NULL, 'Rain is water that falls from clouds in the sky', 3, 2)
INSERT INTO Knowledge (ID, Data, Source_ID, User_ID) VALUES (NULL, 'If water gets very cold, it freezes', 3, 2)
INSERT INTO Knowledge (ID, Data, Source_ID, User_ID) VALUES (NULL, 'Frozen water is called ice', 3, 2)
INSERT INTO Knowledge (ID, Data, Source_ID, User_ID) VALUES (NULL, 'Snow is frozen water', 3, 2)
INSERT INTO Knowledge (ID, Data, Source_ID, User_ID) VALUES (NULL, 'Hail is frozen water', 3, 2)
INSERT INTO Knowledge (ID, Data, Source_ID, User_ID) VALUES (NULL, 'When water becomes very hot, it becomes steam', 3, 2)
INSERT INTO Knowledge (ID, Data, Source_ID, User_ID) VALUES (NULL, 'When ice gets warm, it melts', 3, 2)
INSERT INTO Knowledge (ID, Data, Source_ID, User_ID) VALUES (NULL, 'People need water to live', 3, 2)
INSERT INTO Knowledge (ID, Data, Source_ID, User_ID) VALUES (NULL, 'Animals need water to live', 3, 2)
INSERT INTO Knowledge (ID, Data, Source_ID, User_ID) VALUES (NULL, 'Plants need water to live', 3, 2)
INSERT INTO Knowledge (ID, Data, Source_ID, User_ID) VALUES (NULL, 'All living things need water to live', 3, 2)
INSERT INTO Knowledge (ID, Data, Source_ID, User_ID) VALUES (NULL, 'Evaporation is when water becomes steam', 3, 2)
INSERT INTO Knowledge (ID, Data, Source_ID, User_ID) VALUES (NULL, 'Sublimation is when ice evaporates without becoming water', 3, 2)
INSERT INTO Knowledge (ID, Data, Source_ID, User_ID) VALUES (NULL, 'Water with salt dissolved in it is called saltwater', 3, 2)
INSERT INTO Knowledge (ID, Data, Source_ID, User_ID) VALUES (NULL, 'Water with no salt dissolved in it is called freshwater', 3, 2)
INSERT INTO Knowledge (ID, Data, Source_ID, User_ID) VALUES (NULL, 'People cannot drink saltwater', 3, 2)
INSERT INTO Knowledge (ID, Data, Source_ID, User_ID) VALUES (NULL, 'Fish live underwater', 3, 2)
INSERT INTO Knowledge (ID, Data, Source_ID, User_ID) VALUES (NULL, 'Some plants live underwater', 3, 2)
INSERT INTO Knowledge (ID, Data, Source_ID, User_ID) VALUES (NULL, 'Milk contains water', 3, 2)
INSERT INTO Knowledge (ID, Data, Source_ID, User_ID) VALUES (NULL, 'Orange juice contains water', 3, 2)
INSERT INTO Knowledge (ID, Data, Source_ID, User_ID) VALUES (NULL, 'Many things contain water', 3, 2)
INSERT INTO Knowledge (ID, Data, Source_ID, User_ID) VALUES (NULL, 'When there is lots of water in the air, it is humid.', 3, 2)