ai.sql

基于web的动物识别系统

CREATE TABLE fact
(
  id int(11) not null auto_increment,
  factid int(11) default null,
  detail varchar(255) default null,
  flag int(1) default null,
  primary key(id)
)

CREATE TABLE rule
(
   id int(11) not null auto_increment,
   ruleid int(11) default null,
   ftype int(1) default null,
   factid int(11) default null,
   used int(1) default null,
   primary key  (id)
)

CREATE TABLE current 
(
  id int(11) not null auto_increment,
  factid int(11) default null,
  primary key  (id)
)
INSERT INTO fact (factid,detail,flag) values (1,'该动物有毛发',0);
INSERT INTO fact (factid,detail,flag) values (2,'该动物有奶',0);
INSERT INTO fact (factid,detail,flag) values (3,'该动物有羽毛',0);
INSERT INTO fact (factid,detail,flag) values (4,'该动物会飞',0);
INSERT INTO fact (factid,detail,flag) values (5,'该动物会下蛋',0);
INSERT INTO fact (factid,detail,flag) values (6,'该动物吃肉',0);
INSERT INTO fact (factid,detail,flag) values (7,'该动物有犬齿',0);
INSERT INTO fact (factid,detail,flag) values (8,'该动物有爪',0);
INSERT INTO fact (factid,detail,flag) values (9,'该动物眼盯前方',0);
INSERT INTO fact (factid,detail,flag) values (10,'该动物是哺乳动物',0);
INSERT INTO fact (factid,detail,flag) values (11,'该动物是鸟',0);
INSERT INTO fact (factid,detail,flag) values (12,'该动物是肉食动物',0);
INSERT INTO fact (factid,detail,flag) values (13,'该动物有蹄',0);
INSERT INTO fact (factid,detail,flag) values (14,'该动物是有蹄类动物',0);
INSERT INTO fact (factid,detail,flag) values (15,'该动物是嚼反刍动物',0);
INSERT INTO fact (factid,detail,flag) values (16,'该动物是黄褐色',0);
INSERT INTO fact (factid,detail,flag) values (17,'该动物身上有暗斑点',0);
INSERT INTO fact (factid,detail,flag) values (18,'该动物身上有黑色条纹',0);
INSERT INTO fact (factid,detail,flag) values (19,'该动物有长脖子',0);
INSERT INTO fact (factid,detail,flag) values (20,'该动物有长腿',0);
INSERT INTO fact (factid,detail,flag) values (21,'该动物不会飞',0);
INSERT INTO fact (factid,detail,flag) values (22,'该动物会游泳',0);
INSERT INTO fact (factid,detail,flag) values (23,'该动物有黑白二色',0);
INSERT INTO fact (factid,detail,flag) values (24,'该动物善飞',0);
INSERT INTO fact (factid,detail,flag) values (25,'该动物是虎',1);
INSERT INTO fact (factid,detail,flag) values (26,'该动物是金钱豹',1);
INSERT INTO fact (factid,detail,flag) values (27,'该动物是鸵鸟',1);
INSERT INTO fact (factid,detail,flag) values (28,'该动物是长颈鹿',1);
INSERT INTO fact (factid,detail,flag) values (29,'该动物是企鹅',1);
INSERT INTO fact (factid,detail,flag) values (30,'该动物是信天翁',1);
INSERT INTO fact (factid,detail,flag) values (31,'该动物是斑马',1);

INSERT INTO rule (ruleid,ftype,factid) values(1,0,1);
INSERT INTO rule (ruleid,ftype,factid) values(1,1,10);
INSERT INTO rule (ruleid,ftype,factid) values(2,0,2);
INSERT INTO rule (ruleid,ftype,factid) values(2,1,10);
INSERT INTO rule (ruleid,ftype,factid) values(3,0,3);
INSERT INTO rule (ruleid,ftype,factid) values(3,1,11);
INSERT INTO rule (ruleid,ftype,factid) values(4,0,4);
INSERT INTO rule (ruleid,ftype,factid) values(4,0,5);
INSERT INTO rule (ruleid,ftype,factid) values(4,1,11);
INSERT INTO rule (ruleid,ftype,factid) values(5,0,6);
INSERT INTO rule (ruleid,ftype,factid) values(5,1,12);
INSERT INTO rule (ruleid,ftype,factid) values(6,0,7);
INSERT INTO rule (ruleid,ftype,factid) values(6,0,8);
INSERT INTO rule (ruleid,ftype,factid) values(6,0,9);
INSERT INTO rule (ruleid,ftype,factid) values(6,1,12);
INSERT INTO rule (ruleid,ftype,factid) values(7,0,10);
INSERT INTO rule (ruleid,ftype,factid) values(7,0,13);
INSERT INTO rule (ruleid,ftype,factid) values(7,1,14);
INSERT INTO rule (ruleid,ftype,factid) values(8,0,10);
INSERT INTO rule (ruleid,ftype,factid) values(8,0,15);
INSERT INTO rule (ruleid,ftype,factid) values(8,1,14);
INSERT INTO rule (ruleid,ftype,factid) values(9,0,10);
INSERT INTO rule (ruleid,ftype,factid) values(9,0,12);
INSERT INTO rule (ruleid,ftype,factid) values(9,0,16);
INSERT INTO rule (ruleid,ftype,factid) values(9,0,17);
INSERT INTO rule (ruleid,ftype,factid) values(9,1,26);
INSERT INTO rule (ruleid,ftype,factid) values(10,0,10);
INSERT INTO rule (ruleid,ftype,factid) values(10,0,12);
INSERT INTO rule (ruleid,ftype,factid) values(10,0,16);
INSERT INTO rule (ruleid,ftype,factid) values(10,0,18);
INSERT INTO rule (ruleid,ftype,factid) values(10,1,25);
INSERT INTO rule (ruleid,ftype,factid) values(11,0,14);
INSERT INTO rule (ruleid,ftype,factid) values(11,0,19);
INSERT INTO rule (ruleid,ftype,factid) values(11,0,20);
INSERT INTO rule (ruleid,ftype,factid) values(11,0,17);
INSERT INTO rule (ruleid,ftype,factid) values(11,1,28);
INSERT INTO rule (ruleid,ftype,factid) values(12,0,14);
INSERT INTO rule (ruleid,ftype,factid) values(12,0,18);
INSERT INTO rule (ruleid,ftype,factid) values(12,1,31);
INSERT INTO rule (ruleid,ftype,factid) values(13,0,11);
INSERT INTO rule (ruleid,ftype,factid) values(13,0,19);
INSERT INTO rule (ruleid,ftype,factid) values(13,0,20);
INSERT INTO rule (ruleid,ftype,factid) values(13,0,21);
INSERT INTO rule (ruleid,ftype,factid) values(13,1,27);
INSERT INTO rule (ruleid,ftype,factid) values(14,0,11);
INSERT INTO rule (ruleid,ftype,factid) values(14,0,22);
INSERT INTO rule (ruleid,ftype,factid) values(14,0,21);
INSERT INTO rule (ruleid,ftype,factid) values(14,0,23);
INSERT INTO rule (ruleid,ftype,factid) values(14,1,29);
INSERT INTO rule (ruleid,ftype,factid) values(15,0,11);
INSERT INTO rule (ruleid,ftype,factid) values(15,0,24);
INSERT INTO rule (ruleid,ftype,factid) values(15,0,30);