db.execSQL("create table"+OnlineTable+"("+videoId +" integer primary key autoincrement,"+name+" TEXT,"+type+" text,"+region+" text,"+year+" text,"+actor+" text,"+number+" text,"+television+" text,"+introduction +"text,"+collection+"text ,foreign key ("+number+") references "+JujiTable+"("+number+")))");
db.execSQL("create table"+JujiTable+"("+videoId+" integer primary key autoincrement,"+webside+" text,"+link+" text,"+number+" text"); //创建触发器
db.execSQL("CREATE TRIGGER fk_Movie_deptid before insert on "+JujiTable+" for each row begin" +
"select case when ((select "+number+" from "+OnlineTable+" where "+number+"=new."+number+")is null) then raise " +
"(abort,'Foreign Key Violation') end;end");
//创建视图
db.execSQL("CREATE VIEW"+ viewEmps+" AS SELECT "+JujiTable+"."+videoId+JujiTable+"."+webside+","+JujiTable+"."+link+","+JujiTable+"."+number+" " +
""+OnlineTable+"."+type+","+OnlineTable+"."+number+","+OnlineTable+"."+actor+","+OnlineTable+"."+name+","+OnlineTable+"."+television+","+OnlineTable+"."+year+","+OnlineTable+"."+introduction+","+OnlineTable+"."+collection+","+OnlineTable+"."+region+","+OnlineTable+"."+videoId+"AS _id,"
+" FROM "+JujiTable+" join "+OnlineTable+" ON "+OnlineTable+"."+number+"="+JujiTable+"."+number+""); }