API tools faq
paste
ithoran

Novakao123

ithoran
Jun 5th, 2018
762
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 11.13 KB | None | 0 0
raw download clone embed print report
  1. DROP TABLE `musterija`, `naruceni_proizvod`, `narudzbine`, `proizvod`, `status_kod`, `tip_proizvoda`;
  2.  
  3. CREATE TABLE STATUS_KOD(
  4. ID         INT AUTO_INCREMENT,
  5. Opis         VARCHAR(30),
  6. PRIMARY KEY(ID)
  7. )DEFAULT CHARSET=utf8 ENGINE=INNODB;
  8.  
  9.  
  10. CREATE TABLE PROIZVOD(
  11. ID         INT AUTO_INCREMENT,
  12. Ime         VARCHAR(60) NOT NULL,
  13. Cena         INT NOT NULL,
  14. Opis         TINYTEXT ,
  15. Izdavac_Igre         VARCHAR(30),
  16. Zanr_Igre         VARCHAR(30),
  17. Tip_Konzole         VARCHAR(15) ,
  18. Proizvodjac_Konzole         VARCHAR(30),
  19. Tip_Opreme              VARCHAR(30),
  20. Ostali_detalji        TINYTEXT ,
  21. Tip_proizvoda       VARCHAR(15) NOT NULL,
  22. PRIMARY KEY (ID)
  23. )DEFAULT CHARSET=utf8 ENGINE=INNODB;
  24.  
  25.  
  26. CREATE TABLE MUSTERIJA(
  27. ID         INT AUTO_INCREMENT,
  28. Ime         VARCHAR(30) NOT NULL,
  29. Prezime         VARCHAR(30) NOT NULL,
  30. Adresa         VARCHAR(30) NOT NULL,
  31. Grad          VARCHAR(30) NOT NULL,
  32. God_Rodj    INT NOT NULL,
  33. PRIMARY KEY(ID)
  34. )DEFAULT CHARSET=utf8 ENGINE=INNODB;
  35.  
  36.  
  37. CREATE TABLE NARUDZBINE(
  38. ID         INT AUTO_INCREMENT,
  39. Datum_kreiranja         DATE NOT NULL,
  40. Datum_isporuke         DATE,
  41. Detalji         TINYTEXT,
  42. F_Musterija         INT NOT NULL,
  43. F_Status         INT NOT NULL,
  44. F_Proizvod      INT NOT NULL,
  45. PRIMARY KEY(ID),
  46. FOREIGN KEY (F_Musterija)  REFERENCES MUSTERIJA(ID),
  47. FOREIGN KEY (F_Status)  REFERENCES STATUS_KOD(ID),
  48. FOREIGN KEY (F_Proizvod) REFERENCES PROIZVOD(ID)
  49. )DEFAULT CHARSET=utf8 ENGINE=INNODB;
  50.  
  51.  
  52.  
  53.  
  54. /*-------------------------------------------
  55. ----------------INSERCIJA------------------
  56. -------------------------------------------*/
  57.  
  58. -- Musterija
  59. -- (`ID`, `Ime`, `Prezime`, `Adresa`, `Grad`, `God_Rodj`)
  60.  
  61. INSERT INTO MUSTERIJA VALUES (NULL, 'Čavurko', 'Ostojić', 'Reno Megana 3', 'Beograd', '1984');
  62. INSERT INTO MUSTERIJA VALUES (NULL, 'Mateja', 'Galibabić', 'Sekiranova 5', 'Niš', '1973');
  63. INSERT INTO MUSTERIJA VALUES (NULL, 'Simonida', 'Karnović', 'Ministra Sime 53', 'Kraljevo', '1998');
  64. INSERT INTO MUSTERIJA VALUES (NULL, 'Veljko', 'Kljajić', 'Lisičeva 42', 'Beograd', '2003');
  65. INSERT INTO MUSTERIJA VALUES (NULL, 'Saša', 'Buljaš', 'Frizerska 25', 'Međurovo', '1964');
  66. INSERT INTO MUSTERIJA VALUES (NULL, 'Vlada', 'Jovanović', 'Somborca 11', 'Niš', '1995');
  67. INSERT INTO MUSTERIJA VALUES (NULL, 'Neca', 'Arsenovic', 'Kraljevih Fontana 34', 'Lazarevac', '2007');
  68. INSERT INTO MUSTERIJA VALUES (NULL, 'Kenshiro', 'Ken', 'Suzukijeva 41', 'Ćiba', '1992');
  69. INSERT INTO MUSTERIJA VALUES (NULL, 'Nebojša', 'Tajraramović', 'Siledžijska 38', 'Šabac', '2003');
  70. INSERT INTO MUSTERIJA VALUES (NULL, 'Beki', 'Bekrić', 'Sinanova 15', 'Beograd', '2000');
  71. INSERT INTO MUSTERIJA VALUES (NULL, 'Dušan', 'Nišić', 'Blicova 75', 'Niška Banja', '1996');
  72. INSERT INTO MUSTERIJA VALUES (NULL, 'Manijak', 'Brzi', 'Klintonova 36', 'Pirot', '1998');
  73. INSERT INTO MUSTERIJA VALUES (NULL, 'Irelija', 'Zubović', 'Sejferska 31', 'Leskovac', '1977');
  74. INSERT INTO MUSTERIJA VALUES (NULL, 'Šaban', 'Ćetonijević', 'Trigerska 1', 'Kostolac', '1999');
  75. INSERT INTO MUSTERIJA VALUES (NULL, 'Aširpa', 'Čitatap', 'Sokače 77', 'Matevac', '2002');
  76. INSERT INTO MUSTERIJA VALUES (NULL, 'Tanasije', 'Batinaš', 'Tironova 22', 'Sarajevo', '1975');
  77.  
  78. -- PROIZVOD (ID, IME, CENA, OPIS, Izdavac_Igre, Zanr_Igre, Tip_Konzole, Proizvodjac_Konzole, Tip_Opreme, Ostali_detalji, Tip_proizvoda)
  79.  
  80. INSERT INTO proizvod VALUES
  81. (0, 'Xbox 360', 24000, null, null, null, 'Home', 'Microsoft', null, null, 'Konzola'),
  82. (0, 'Playstation 3', 24000, null, null, null, 'Home', 'Sony', null, null, 'Konzola'),
  83. (0, 'Xbox One', 34000, null, null, null, 'Home', 'Microsoft', null, null, 'Konzola'),
  84. (0, 'Playstation 4', 34000, null, null, null, 'Home', 'Sony', null, null, 'Konzola'),
  85. (0, 'Switch', 44000, null, null, null, 'Handheld', 'Nintendo', null, null, 'Konzola'),
  86. (0, '3DS', 44000, null, null, null, 'Handheld', 'Nintendo', null, null, 'Konzola'),
  87. (0, 'Nintendo 64', 5000, null, null, null, 'Home', 'Nintendo', null, null, 'Konzola'),
  88. (0, 'Dreamcast', 8000, null, null, null, 'Home', 'Sega', null, null, 'Konzola'),
  89. (0, 'Playstation 2', 10000, null, null, null, 'Home', 'Sony', null, null, 'Konzola'),
  90. (0, 'Wii', 12000, null, null, null, 'Home', 'Nintendo', null, null, 'Konzola'),
  91. (0, 'Wii U', 20000, null, null, null, 'Handheld', 'Nintendo', null, null, 'Konzola'),
  92. (0, 'PSP', 15000, null, null, null, 'Handheld', 'Nintendo', null, null, 'Konzola');
  93.  
  94. INSERT INTO proizvod VALUES
  95. (0, 'Age of Empires II', 2400, NULL, 'Microsoft Studios', 'RTS', NULL, null, null, null, 'Igra'),
  96. (0, 'Black Mesa', 1500, NULL, 'Crowbar Collective', 'FPS', NULL, null, null, null, 'Igra'),
  97. (0, 'Borderlands 2', 2400, NULL, 'Gearbox Software', 'FPS', NULL, null, null, null, 'Igra'),
  98. (0, 'Counter-Strike: Global Offensive', 1500, NULL, 'Valve', 'FPS', NULL, null, null, null, 'Igra'),
  99. (0, 'Crysis', 1200, NULL, 'Crytek', 'FPS', NULL, null, null, null, 'Igra'),
  100. (0, 'Deus Ex: Human Revolution', 1200, NULL, 'Square Enix', 'RPG', NULL, null, null, null, 'Igra'),
  101. (0, 'Doom 3', 2000, NULL, 'id Software', 'FPS', NULL, null, null, null, 'Igra'),
  102. (0, 'Dota 2', 0, NULL, 'Valve', 'ARTS', NULL, null, null, null, 'Igra'),
  103. (0, 'Devil May Cry 3', 1700, NULL, 'Konami', 'Action', NULL, null, null, null, 'Igra'),
  104. (0, 'Far Cry 3', 2500, NULL, 'Ubisfot', 'FPS', NULL, null, null, null, 'Igra'),
  105. (0, 'Grand Theft Auto V', 6000, NULL, 'Rockstar Games', 'Action', NULL, null, null, null, 'Igra'),
  106. (0, 'Half-Life 2', 0, NULL, 'Valve', 'FPS', NULL, null, null, null, 'Igra'),
  107. (0, 'HITMAN', 5000, NULL, 'Square Enix', 'Action', NULL, null, null, null, 'Igra'),
  108. (0, 'Quake Champions', 0, NULL, 'id Software', 'FPS', NULL, null, null, null, 'Igra'),
  109. (0, 'Hotline Miami', 900, NULL, 'Devolver Digital', 'Action', NULL, null, null, null, 'Igra'),
  110. (0, 'Serious Sam: The Second Encounter', 800, NULL, 'Croteam', 'FPS', NULL, null, null, null, 'Igra'),
  111. (0, 'Killing Floor 2', 3000, NULL, 'Tripwire Interactive', 'FPS', NULL, null, null, null, 'Igra'),
  112. (0, 'Left 4 Dead 2', 900, NULL, 'Valve', 'FPS', NULL, null, null, null, 'Igra'),
  113. (0, 'Portal 2', 1100, NULL, 'Valve', 'Puzzle', NULL, null, null, null, 'Igra'),
  114. (0, 'Max Payne', 750, NULL, 'Rockstar Games', 'Action', NULL, null, null, null, 'Igra'),
  115. (0, 'Payday 2', 3500, NULL, 'Overkill', 'FPS', NULL, null, null, null, 'Igra'),
  116. (0, 'Resident Evil 4', 2200, NULL, 'Konami', 'Action', NULL, null, null, null, 'Igra'),
  117. (0, 'Rising Storm 2: Vietnam', 2300, NULL, 'Tripwire Interactive', 'FPS', NULL, null, null, null, 'Igra'),
  118. (0, 'Sonic Generations', 0, NULL, 'SEGA', 'Action', NULL, null, null, null, 'Igra'),
  119. (0, 'The Talos Principle', 0, NULL, 'Croteam', 'Puzzle', NULL, null, null, null, 'Igra'),
  120. (0, 'Team Fotress 2', 0, NULL, 'Valve', 'FPS', NULL, null, null, null, 'Igra'),
  121. (0, 'Grim Dawn', 0, NULL, 'Crate Entertainment', 'ARTS', NULL, null, null, null, 'Igra'),
  122. (0, 'Torchlight II', 0, NULL, 'Runic Games', 'ARTS', NULL, null, null, null, 'Igra'),
  123. (0, 'Starcraft 2', 0, NULL, 'Blizzard', 'RTS', NULL, null, null, null, 'Igra'),
  124. (0, 'Chivalry: Medival Warfare', 0, NULL, 'Tom Banner Studios', 'Action', NULL, null, null, null, 'Igra'),
  125. (0, 'Company of Heroes 2', 0, NULL, 'Relic Entertainment', 'RTS', NULL, null, null, null, 'Igra'),
  126. (0, 'Diablo III', 0, NULL, 'Blizzard', 'ARTS', NULL, null, null, null, 'Igra');
  127.  
  128. INSERT INTO proizvod VALUES
  129. (0, 'Logitech G203', 4000, null, null, null, null, null, 'mis', null, 'Oprema'),
  130. (0, 'Logitech K200', 1000, null, null, null, null, null, 'tastatura', null, 'Oprema'),
  131. (0, 'Razer Deathadder', 7000, null, null, null, null, null, 'mis', null, 'Oprema'),
  132. (0, 'Zowie FK2', 8000, null, null, null, null, null, 'mis', null, 'Oprema'),
  133. (0, 'HyperX Cloud II', 12000, null, null, null, null, null, 'slusalice', null, 'Oprema'),
  134. (0, 'Corsair MM200', 4000, null, null, null, null, null, 'podloga', null, 'Oprema'),
  135. (0, 'SteelSeries Siberia', 4000, null, null, null, null, null, 'slusalice', null, 'Oprema'),
  136. (0, 'Razer Kraken', 6500, null, null, null, null, null, 'slusalice', null, 'Oprema'),
  137. (0, 'Logitech G920', 4000, null, null, null, null, null, 'volan', null, 'Oprema'),
  138. (0, 'Logitech F710', 6200, null, null, null, null, null, 'gamepad', null, 'Oprema'),
  139. (0, 'Razer Wolverine', 8000, null, null, null, null, null, 'gamepad', null, 'Oprema'),
  140. (0, 'Speedlink Legatos', 3000, null, null, null, null, null, 'slusalice', null, 'Oprema'),
  141. (0, 'SteelSeries RIVAL 300', 6000, null, null, null, null, null, 'mis', null, 'Oprema'),
  142. (0, 'Logitech Driving Force G29', 9500, null, null, null, null, null, 'volan', null, 'Oprema'),
  143. (0, 'Logitech G403', 8000, null, null, null, null, null, 'mis', null, 'Oprema'),
  144. (0, 'Redragon Kala 557', 5500, null, null, null, null, null, 'tastatura', null, 'Oprema'),
  145. (0, 'Razer Black Widow', 12000, null, null, null, null, null, 'tastatura', null, 'Oprema'),
  146. (0, 'Razer Goliathus Speed', 2500, null, null, null, null, null, 'podloga', null, 'Oprema'),
  147. (0, 'Zowie EC1', 7000, null, null, null, null, null, 'mis', null, 'Oprema');
  148.  
  149.  
  150. -- STATUS_KOD
  151.  
  152. INSERT INTO STATUS_KOD VALUES (NULL, 'U toku');
  153. INSERT INTO STATUS_KOD VALUES (NULL, 'Završeno');
  154. INSERT INTO STATUS_KOD VALUES (NULL, 'Na čekanju');
  155. INSERT INTO STATUS_KOD VALUES (NULL, 'Otkazano');
  156.  
  157. -- Narudzibne (`ID`, `Datum_kreiranja`, `Datum_isporuke`, `Detalji`, `F_Musterija`, `F_Status`) VALUES (NULL, '', NULL, NULL, '', '')
  158.  
  159.  
  160. INSERT INTO NARUDZBINE VALUES (NULL, '2015-06-04', NULL, NULL, '1', '1', 5);
  161. INSERT INTO NARUDZBINE VALUES (NULL, '2018-05-22', NULL, NULL, '3', '1', 33);
  162. INSERT INTO NARUDZBINE VALUES (NULL, '2018-04-30', NULL, NULL, '4', '1', 22);
  163. INSERT INTO NARUDZBINE VALUES (NULL, '2018-05-13', NULL, NULL, '7', '1', 27);
  164. INSERT INTO NARUDZBINE VALUES (NULL, '2018-05-15', NULL, NULL, '11', '1', 2);
  165. INSERT INTO NARUDZBINE VALUES (NULL, '2018-04-22', NULL, NULL, '13', '1', 48);
  166. INSERT INTO NARUDZBINE VALUES (NULL, '2018-05-13', NULL, NULL, '15', '1', 30);
  167. INSERT INTO NARUDZBINE VALUES (NULL, '2018-04-01', NULL, NULL, '16', '1', 29);
  168.  
  169. INSERT INTO NARUDZBINE VALUES (NULL, '2018-02-28', '2018-03-14', NULL, '5', '2', 8);
  170. INSERT INTO NARUDZBINE VALUES (NULL, '2018-01-05', '2018-02-05', NULL, '6', '2', 11);
  171. INSERT INTO NARUDZBINE VALUES (NULL, '2018-03-14', '2018-03-28', NULL, '10', '2', 14);
  172. INSERT INTO NARUDZBINE VALUES (NULL, '2018-05-03', '2018-05-17', NULL, '12', '2', 51);
  173. INSERT INTO NARUDZBINE VALUES (NULL, '2018-04-03', '2018-05-12', NULL, '8', '2', 62);
  174. INSERT INTO NARUDZBINE VALUES (NULL, '2018-01-25', '2018-02-22', NULL, '4', '2', 58);
  175. INSERT INTO NARUDZBINE VALUES (NULL, '2018-02-11', '2018-03-01', NULL, '12', '2', 42);
  176. INSERT INTO NARUDZBINE VALUES (NULL, '2018-02-24', '2018-03-16', NULL, '13', '2', 19);
  177.  
  178. INSERT INTO NARUDZBINE VALUES (NULL, '2016-11-04', NULL, NULL, '2', '3', 55);
  179. INSERT INTO NARUDZBINE VALUES (NULL, '2017-12-24', NULL, NULL, '9', '3', 44);
  180. INSERT INTO NARUDZBINE VALUES (NULL, '2018-01-02', NULL, NULL, '1', '3', 32);
  181. INSERT INTO NARUDZBINE VALUES (NULL, '2014-05-14', NULL, NULL, '16', '3', 13);
  182.  
  183. INSERT INTO NARUDZBINE VALUES (NULL, '2018-02-05', '2018-02-13', NULL, '8', '2', 19);
  184. INSERT INTO NARUDZBINE VALUES (NULL, '2017-03-06', '2017-04-19', NULL, '14', '2', 23);
  185. INSERT INTO NARUDZBINE VALUES (NULL, '2017-10-13', '2017-11-20', NULL, '7', '2', 26);
  186. INSERT INTO NARUDZBINE VALUES (NULL, '2016-08-11', '2016-08-12', NULL, '5', '2', 25);
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!