SET SQL DIALECT 3;

/* CREATE DATABASE 'E:\test\test.gdb' PAGE_SIZE 4096

 DEFAULT CHARACTER SET  */

/* Table: GRUPPA, Owner: SYSDBA */

CREATE TABLE "GRUPPA" 
(
  "NAZVGROUP"	CHAR(18),
  "IDGROUP"	INTEGER NOT NULL,
 PRIMARY KEY ("IDGROUP")
);

/* Table: STUD, Owner: SYSDBA */

CREATE TABLE "STUD" 
(
  "IDKUR"	INTEGER,
  "IDGROUP"	INTEGER,
  "IDSTAT"	INTEGER,
  "FIOSTUD"	VARCHAR(40),
  "TELEFON"	INTEGER,
  "ADRESS"	VARCHAR(25),
  "GODROG"	DATE
);

/* Table: TEST, Owner: SYSDBA */

CREATE TABLE "TEST" 
(
  "ID"	INTEGER
);


/* Grant Roles for this database */


/* Grant permissions for this database */

delete from STUD
where
  ADRESS = :OLD_ADRESS and
  FIOSTUD = :OLD_FIOSTUD and
  GODROG = :OLD_GODROG and
  IDGROUP = :OLD_IDGROUP and
  IDKUR = :OLD_IDKUR and
  IDSTAT = :OLD_IDSTAT and
  TELEFON = :OLD_TELEFON

insert into STUD
  (ADRESS, FIOSTUD, GODROG, IDGROUP, IDKUR, IDSTAT, TELEFON)
values
  (:ADRESS, :FIOSTUD, :GODROG, :IDGROUP, :IDKUR, :IDSTAT, :TELEFON)


update STUD
set
  ADRESS = :ADRESS,
  FIOSTUD = :FIOSTUD,
  GODROG = :GODROG,
  IDGROUP = :IDGROUP,
  IDKUR = :IDKUR,
  IDSTAT = :IDSTAT,
  TELEFON = :TELEFON
where
  ADRESS = :OLD_ADRESS and
  FIOSTUD = :OLD_FIOSTUD and
  GODROG = :OLD_GODROG and
  IDGROUP = :OLD_IDGROUP and
  IDKUR = :OLD_IDKUR and
  IDSTAT = :OLD_IDSTAT and
  TELEFON = :OLD_TELEFON