话不多说 先上最终成品-----脚本
.open videoDB
drop table if exists tbl_inf;
create table if not exists tbl_inf
(
inf_id int primary key,
inf_name varchar(20) not null,
inf_epi int check (inf_epi >= 1 and inf_epi <= 500),
inf_minute int check (inf_minute >= 1 and inf_minute <= 180),
inf_synopsis varchar(100) not null,
inf_channel varchar(10)