create sequence seq_article increment by 1 start with 1;
create table article(
id int primary key not null,
pid int,
rootid int,
title varchar2(255),
cont varchar2(4000),
pdate date,
isleaf int
);


insert into article (id,pid,rootid,title,cont,pdate,isleaf) values(seq_article.nextval, 0,1,'蚂蚁大战大象','蚂蚁大战大象',sysdate,1);
insert into article (id,pid,rootid,title,cont,pdate,isleaf) values(seq_article.nextval, 1,1,'大象被打趴下了','大象被打趴下了',sysdate,1);
insert into article (id,pid,rootid,title,cont,pdate,isleaf) values(seq_article.nextval, 2,1,'蚂蚁也不好过','蚂蚁也不好过',sysdate,0);
insert into article (id,pid,rootid,title,cont,pdate,isleaf) values(seq_article.nextval, 2,1,'瞎说','瞎说',sysdate,1);
insert into article (id,pid,rootid,title,cont,pdate,isleaf) values(seq_article.nextval, 4,1,'没有瞎说','没有瞎说',sysdate,0);
insert into article (id,pid,rootid,title,cont,pdate,isleaf) values(seq_article.nextval, 1,1,'怎么可能','怎么可能',sysdate,1);
insert into article (id,pid,rootid,title,cont,pdate,isleaf) values(seq_article.nextval, 6,1,'怎么没有可能','怎么没有可能',sysdate,0);
insert into article (id,pid,rootid,title,cont,pdate,isleaf) values(seq_article.nextval, 6,1,'可能性是很大的','可能性是很大的',sysdate,0);
insert into article (id,pid,rootid,title,cont,pdate,isleaf) values(seq_article.nextval, 2,1,'大象进医院了','大象进医院了',sysdate,1);
insert into article (id,pid,rootid,title,cont,pdate,isleaf) values(seq_article.nextval, 9,1,'护士是蚂蚁','护士是蚂蚁',sysdate,0);
COMMIT;