CREATE TABLE psql (
  id SERIAL primary key,
  path       varchar(256),
  name       varchar(256),
  describe   text,
  code       text
);

CREATE TABLE cpp (
  id SERIAL primary key,
  path       varchar(256),
  name       varchar(256),
  describe   text,
  code       text
);

CREATE TABLE rust (
  id SERIAL primary key,
  path       varchar(256),
  name       varchar(256),
  describe   text,
  code       text
);

CREATE TABLE vim (
  id SERIAL primary key,
  path       varchar(256),
  name       varchar(256),
  describe   text,
  code       text
);

alter table psql add column file_type varchar(256) default 'file';
alter table cpp add column file_type varchar(256) default 'file';
alter table rust add column file_type varchar(256) default 'file';
alter table vim add column file_type varchar(256) default 'file';
alter table cppdoc add column file_type varchar(256) default 'file';

alter table psql add column level int default 0;
alter table cpp add column  level int default 0;
alter table rust add column  level int default 0;
alter table vim add column  level int default 0;
alter table cppdoc add column  level int default 0;

create index cpp_file on cpp (file_type);
create index cppdoc_file on cppdoc (file_type);
create index rust_file on rust (file_type);
create index vim_file on vim (file_type);
create index psql_file on vim (file_type);

CREATE TABLE arm (
  id SERIAL primary key,
  path       varchar(256),
  name       varchar(256),
  describe   text,
  code       text,
  file_type  varchar(256) default 'file',
  level int default 0
);

create index arm_file on arm (file_type);


alter table psql add column cid int default 0;
alter table cpp add column  cid int default 0;
alter table rust add column  cid int default 0;
alter table vim add column  cid int default 0;
alter table cppdoc add column  cid int default 0;
alter table arm add column  cid int default 0;

alter table psql add column pcid int default 0;
alter table cpp add column  pcid int default 0;
alter table rust add column  pcid int default 0;
alter table vim add column  pcid int default 0;
alter table cppdoc add column  pcid int default 0;
alter table arm add column  pcid int default 0;


create index arm_cid on arm (pcid,cid);
create index cpp_cid on cpp (pcid,cid);
create index cppdoc_cid on cppdoc (pcid,cid);
create index rust_cid on rust (pcid,cid);
create index vim_cid on vim (pcid,cid);
create index psql_cid on psql (pcid,cid);