×

Welcome to TagMyCode

Please login or create account to add a snippet.
0
0
 
0
Language: SQL
Posted by: Randy Marsh
Added: Jan 15, 2014 10:37 AM
Views: 12
Tags: no tags
  1. SQL query:
  2.  
  3. --
  4. -- Database: `skola`
  5. --
  6. -- --------------------------------------------------------
  7. --
  8. -- Table structure for table `grupa`
  9. --
  10. CREATE TABLE IF NOT EXISTS  `grupa` (
  11.  
  12.  `ID_grupa` INT( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
  13.  `oznaka_grupa` VARCHAR( 20 ) NOT NULL ,
  14.  `cijena` DECIMAL( 18, 2 ) NOT NULL ,
  15.  `datum_pocetak` DATE NOT NULL ,
  16.  `datum_zavrsetak` DATE NOT NULL ,
  17.  `ID_smjer_fk` INT( 11 ) UNSIGNED NOT NULL ,
  18. PRIMARY KEY (  `ID_grupa` )
  19. ) ENGINE = INNODB DEFAULT CHARSET = utf8 AUTO_INCREMENT =5;
  20.