Advertisement
Guest User

Untitled

a guest
Nov 23rd, 2014
166
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.34 KB | None | 0 0
  1. CREATE TABLE KRAJ (
  2. ID_KRAJ INTEGER NOT NULL,
  3. KRAJ VARCHAR2 (20) NOT NULL,
  4. POSTNA_STEVILKA NUMBER(10) NOT NULL
  5. );
  6.  
  7. ALTER TABLE KRAJ
  8. ADD (CONSTRAINT PK_KRAJ PRIMARY KEY (ID_KRAJ));
  9.  
  10. CREATE TABLE NASLOV (
  11. ID_NASLOV INTEGER NOT NULL,
  12. ULICA VARCHAR2 (20) NOT NULL,
  13. HISNA_STEVILKA NUMBER(10) NOT NULL,
  14. TK_ID_KRAJ NUMBER(10) NOT NULL
  15. );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement