CREATE TABLE `testDB`.`korisnici` (
   `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
   `ime` VARCHAR(45) NOT NULL DEFAULT '',
   `iznos` DOUBLE(10,2),
   `prezime` VARCHAR(45) NOT NULL DEFAULT '',
   `email` VARCHAR(100),
   PRIMARY KEY(`id`),
   UNIQUE INDEX (`email`)
 )
 ENGINE = InnoDB
 CHARACTER SET utf8
 COLLATE utf8_general_ci
 COMMENT = 'Test tabela za Stored Proceduru';

CREATE TABLE `testDB`.`transakcije` (
  `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  `ovome_oduzmi` INTEGER UNSIGNED,
  `ovome_dodaj` INTEGER UNSIGNED,
  `iznos` DOUBLE(10,2),
  `opis_transakcije` VARCHAR(255),
  PRIMARY KEY(`id`),
  CONSTRAINT `FK_transakcije_oduzmi` FOREIGN KEY `FK_transakcije_oduzmi` (`ovome_oduzmi`)
    REFERENCES `korisnici` (`id`)
    ON DELETE SET NULL,
  CONSTRAINT `FK_transakcije_dodaj` FOREIGN KEY `FK_transakcije_dodaj` (`ovome_dodaj`)
    REFERENCES `korisnici` (`id`)
    ON DELETE SET NULL
)
ENGINE = InnoDB
CHARACTER SET utf8 
COLLATE utf8_general_ci
COMMENT = 'Lookup tabela sa transakcijama';