if not exists (select * from systable where LCase(table_name) = LCase('Categories')) then
  create table Categories(
  "N" integer default autoincrement,
  "Category" varchar(100),
  primary key ("N")
)
end if;

GO

if not exists (select * from Categories where N=1) then
  insert into "Categories" ("N", "Category") 
  values(1, 'Студент-редовно обучение');
end if;

GO

if not exists (select * from Categories where N=2) then
insert into "Categories" ("N", "Category") 
values(2, 'Докторант');
end if;

GO

if not exists (select * from Categories where N=3) then
insert into "Categories" ("N", "Category") 
values(3, 'Специализант');
end if;

GO

if not exists (select * from Categories where N=4) then
insert into "Categories" ("N", "Category") 
values(4, 'Неучащ съпруг/съпруга или дете');
end if;

GO

if not exists (select * from Categories where N=5) then
insert into "Categories" ("N", "Category") 
values(5, 'Преподавател');
end if;

GO

if not exists (select * from Categories where N=6) then
insert into "Categories" ("N", "Category") 
values(6, 'Друг неучащ');
end if;

GO

if not exists (select * from Categories where N=7) then
insert into "Categories" ("N", "Category") 
values(7, 'Студент-задочно обучение');
end if;

GO