eZLUGqkv

1SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
2SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
3SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
4
5-- -----------------------------------------------------
6-- Schema kuvar
7-- -----------------------------------------------------
8DROP SCHEMA IF EXISTS `kuvar` ;
9
10-- -----------------------------------------------------
11-- Schema kuvar
12-- -----------------------------------------------------
13CREATE SCHEMA IF NOT EXISTS `kuvar` DEFAULT CHARACTER SET utf8 ;
14USE `kuvar` ;
15
16-- -----------------------------------------------------
17-- Table `kuvar`.`recepti`
18-- -----------------------------------------------------
19DROP TABLE IF EXISTS `kuvar`.`recepti` ;
20
21CREATE TABLE IF NOT EXISTS `kuvar`.`recepti` (
22  `id` INT NOT NULL AUTO_INCREMENT,
23  `naziv` VARCHAR(45) NOT NULL,
24  `sastojci` LONGTEXT NOT NULL,
25  `uputstvo` LONGTEXT NOT NULL,
26  PRIMARY KEY (`id`))
27ENGINE = InnoDB;
28
29
30SET SQL_MODE=@OLD_SQL_MODE;
31SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
32SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
33
34-- -----------------------------------------------------
35-- Data for table `kuvar`.`recepti`
36-- -----------------------------------------------------
37START TRANSACTION;
38USE `kuvar`;
39INSERT INTO `kuvar`.`recepti` (`id`, `naziv`, `sastojci`, `uputstvo`) VALUES (DEFAULT, 'Piletina sa struganim dinjama', 'Piletina i dinje', 'stavi dinje na piletinu.');
40INSERT INTO `kuvar`.`recepti` (`id`, `naziv`, `sastojci`, `uputstvo`) VALUES (DEFAULT, 'Cevapi u somunu', 'mleveno meso i somun', 'metni cevape na rostilj pa posle u somun');
41INSERT INTO `kuvar`.`recepti` (`id`, `naziv`, `sastojci`, `uputstvo`) VALUES (DEFAULT, 'Sarma', 'Kupus, mleveno meso i pirinac', 'zamoli babu da ti napravi sarmu');