Mysql funkcionalnosti

http://bpp.rs/36-mysql-funkcionalnosti  pozdrav trebam pomoc evo link

-- MySQL Workbench Forward Engineering SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0; SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0; SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES'; -- ----------------------------------------------------- -- Schema mydb -- ----------------------------------------------------- -- ----------------------------------------------------- -- Schema drustvena_mreza -- ----------------------------------------------------- -- ----------------------------------------------------- -- Schema drustvena_mreza -- ----------------------------------------------------- CREATE SCHEMA IF NOT EXISTS `drustvena_mreza` DEFAULT CHARACTER SET utf8 ; USE `drustvena_mreza` ; -- ----------------------------------------------------- -- Table `drustvena_mreza`.`korisnik` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `drustvena_mreza`.`korisnik` ( `korisnik_id` INT(11) NOT NULL AUTO_INCREMENT, `ime` VARCHAR(45) CHARACTER SET 'utf8' NOT NULL, `prezime` VARCHAR(45) CHARACTER SET 'utf8' NOT NULL, `email` VARCHAR(45) CHARACTER SET 'utf8' NOT NULL, `korisnicko_ime` VARCHAR(45) CHARACTER SET 'utf8' NOT NULL, `biografija` TEXT CHARACTER SET 'utf8' NULL DEFAULT NULL, `datum_rodjenja` DATE NULL DEFAULT NULL, `drzava_rodjenja` VARCHAR(45) CHARACTER SET 'utf8' NULL DEFAULT NULL, `fotografija` INT(11) NULL DEFAULT NULL, PRIMARY KEY (`korisnik_id`), UNIQUE INDEX `korisnicko_ime_UNIQUE` (`korisnicko_ime` ASC), INDEX `inx_ime_korisnika` (`ime` ASC, `prezime` ASC), FULLTEXT INDEX `inx_biografija` (`biografija` ASC)) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = 'Ovo je tabela sa informacijama o korisnicima.'; -- ----------------------------------------------------- -- Table `drustvena_mreza`.`statusi` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `drustvena_mreza`.`statusi` ( `status_id` INT(11) NOT NULL AUTO_INCREMENT, `naslov_statusa` VARCHAR(60) CHARACTER SET 'utf8' NOT NULL, `tekst_statusa` TEXT CHARACTER SET 'utf8' NULL DEFAULT NULL, `datum_objave` DATE NULL DEFAULT NULL, PRIMARY KEY (`status_id`)) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = 'Ovo je tabela sa statusima korisnika.'; -- ----------------------------------------------------- -- Table `drustvena_mreza`.`prijateljstvo` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `drustvena_mreza`.`prijateljstvo` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `korisnik_id` INT(11) NOT NULL, `status_id` INT(11) NOT NULL, PRIMARY KEY (`id`), INDEX `fk_korisnik_id_idx` (`korisnik_id` ASC), INDEX `fk_status_id_idx` (`status_id` ASC), CONSTRAINT `fk_korisnik_id` FOREIGN KEY (`korisnik_id`) REFERENCES `drustvena_mreza`.`korisnik` (`korisnik_id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_status_id` FOREIGN KEY (`status_id`) REFERENCES `drustvena_mreza`.`statusi` (`status_id`) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8 COLLATE = utf8_unicode_ci; USE `drustvena_mreza` ; -- ----------------------------------------------------- -- Placeholder table for view `drustvena_mreza`.`moj_pogled` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `drustvena_mreza`.`moj_pogled` (`celo_ime` INT); -- ----------------------------------------------------- -- procedure registracija -- ----------------------------------------------------- DELIMITER $$ USE `drustvena_mreza`$$ CREATE DEFINER=`root`@`localhost` PROCEDURE `registracija`(IN i_ime VARCHAR(255), IN i_prezime VARCHAR(255)) BEGIN INSERT INTO korisnik VALUES (null, i_ime, i_prezime); END$$ DELIMITER ; -- ----------------------------------------------------- -- View `drustvena_mreza`.`moj_pogled` -- ----------------------------------------------------- DROP TABLE IF EXISTS `drustvena_mreza`.`moj_pogled`; USE `drustvena_mreza`; CREATE OR REPLACE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `drustvena_mreza`.`moj_pogled` AS select concat(`drustvena_mreza`.`korisnik`.`ime`,`drustvena_mreza`.`korisnik`.`prezime`) AS `celo_ime` from `drustvena_mreza`.`korisnik`; SET SQL_MODE=@OLD_SQL_MODE; SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS; SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;