CREATE TABLE `STUDENT` (
  `PINDEX`  INTEGER  NOT NULL,
  `LASTNAME`  VARCHAR(50)  DEFAULT '',
  `FIRSTNAME`  VARCHAR(50)  DEFAULT '',
  `MNR`  INTEGER  DEFAULT 1  NOT NULL  UNIQUE,
  `UNR`  INTEGER  DEFAULT 1  NOT NULL  UNIQUE,

  CONSTRAINT `PK_STUDENT`  PRIMARY KEY (`PINDEX`)
);





ALTER TABLE STUDENT
     ADD CONSTRAINT CH_MNR CHECK (
  MNR >0
);


ALTER TABLE STUDENT
     ADD CONSTRAINT CH_UNR CHECK (
  UNR >0
);





   create table sequence(
     id INT not null
   );
   
   insert into sequence values(30);




Insert into student(pindex,  lastname, firstname, mnr, unr)
Values(1, 'Meier', 'Hans', 12345, 22345);

Insert into student(pindex,  lastname, firstname, mnr, unr)
Values(2, 'Schulze', 'Anton', 12346, 22347);

Insert into student(pindex,  lastname, firstname, mnr, unr)
Values(4, 'Meyer', 'Susanne', 12347, 22349);

Insert into student(pindex,  lastname, firstname, mnr, unr)
Values(6, 'Brandt', 'Ute', 12349, 22351);

Insert into student(pindex,  lastname, firstname, mnr, unr)
Values(8, 'Neumann', 'Gesine', 12355, 22354);

Insert into student(pindex,  lastname, firstname, mnr, unr)
Values(9, 'Sebastian', 'Dorethea', 12365, 22355);

Insert into student(pindex,  lastname, firstname, mnr, unr)
Values(10, 'Kraft', 'Udo', 12367, 22357);

Insert into student(pindex,  lastname, firstname, mnr, unr)
Values(13, 'Opel', 'Sascha', 12368, 22359);

Insert into student(pindex,  lastname, firstname, mnr, unr)
Values(15, 'Schulz', 'Andrea', 12370, 22361);

Insert into student(pindex,  lastname, firstname, mnr, unr)
Values(20, 'Imbiel', 'Michaela', 12373, 22363);