root/trunk/database/source/timing_data.sql

Revision 263, 3.5 KB (checked in by dubravko, 3 years ago)

Podaci za bazu (INSERT Query) - vozači, klubovi, timovi, sva natjecanja, grupe i klase za autoslalom, perspektive.

Line 
1INSERT INTO `club` VALUES (1,'HRV','AK Dubrava','Zagreb'),(2,'HRV','AK Delta','Zagreb'),(3,'HRV','Ak Super Trupe','Zagreb'),(5,'HRV','AMK Mihovil Å ibenik','Å ibenik'),(7,'HRV','AK Dubrovnik Racing','Dubrovnik'),(9,'HRV','AK Åœupa Dubrovačka','Dubrovnik'),(11,'HRV','AMK Ragusa Racing','Dubrovnik'),(13,'HRV','AMK Trogir','Trogir'),(15,'HRV','AMK Oneum','Đakovo'),(17,'HRV','AK PeljeÅ¡ac Racing','Orebić');
2INSERT INTO `competition` VALUES (1,'Prvenstvo Hrvatske','PH','2006-01-01','2007-01-01'),(2,'Europsko Prvenstvo','EP','2006-01-01','2007-02-02'),(11,'Prvenstvo Dalamcije','PD','2007-01-01','2007-12-01'),(13,'Prvenstvo Zagreba','PZ','2007-01-01','2007-12-01'),(15,'Srednjoeurposka zona kup','CEZ','2007-01-01','2007-12-01');
3INSERT INTO `driver` VALUES (1,2,'HRV',0,0,0,'Dubravko','Flis'),(2,1,'HRV',0,0,0,'Darko','Drezga'),(3,1,'HRV',0,0,0,'Marko','Bogdanović'),(5,7,'HRV',0,0,0,'Đivo','Franić'),(7,5,'HRV',0,0,1,'Stipe','Todorović'),(9,9,'HRV',0,0,0,'Mato','Kisić'),(11,11,'HRV',0,0,1,'NikÅ¡a','BlaÅŸević'),(13,9,'HRV',0,0,0,'Marijo','Barović'),(15,11,'HRV',0,0,0,'Mato','Milković'),(17,13,'HRV',0,1,0,'Marina','MiÅ¡e'),(19,13,'HRV',0,0,1,'Nikola','RoÅŸić'),(21,11,'HRV',0,0,0,'Pero','Lobrović'),(23,5,'HRV',0,0,0,'Neven','Å kugor'),(25,11,'HRV',0,0,0,'Antun','MatuÅ¡ić'),(27,13,'HRV',0,0,0,'Filip','Bilota'),(29,15,'HRV',0,0,0,'Mate','Lelas'),(31,11,'HRV',0,0,1,'Alen','Hasanović'),(33,11,'HRV',0,0,1,'Damir','Lobrović'),(35,11,'HRV',0,0,0,'Mario','Serden'),(37,17,'HRV',0,0,0,'Patar','RaÅ¡ić'),(39,9,'HRV',0,0,0,'Dario','UroÅ¡ević'),(41,7,'HRV',0,0,0,'Mario','Kraljević'),(43,5,'HRV',0,0,0,'Josip','Todorović'),(45,5,'HRV',0,0,0,'Jure','GaÅ¡perov'),(47,17,'HRV',0,0,0,'BoÅŸo','Prnić'),(49,11,'HRV',0,0,0,'Miho','Jozović');
4INSERT INTO `event` VALUES (1,'HRV','PeljeÅ¡ac','2007-10-16','2007-10-17');
5INSERT INTO `perspective` VALUES ('hr.akdelta.eventmanager.EventPrepPerspective','Priprema Događaja'),('hr.akdelta.eventmanager.MainDataPerspective','Glavni Podaci'),('hr.akdelta.eventmanager.ReportingPerspective','IzvjeÅ¡taji');
6INSERT INTO `raceclass` VALUES (5,4,1,2,'Klasa 1'),(6,4,1,2,'Klasa 2'),(7,0,1,11,'Grupa 1 - Serijski Automobili'),(9,0,1,11,'Grupa 2 - Sprint Automobili'),(11,0,1,11,'Grupa 3 - Å portski Automobili'),(13,7,1,11,'Klasa 1 (do 1200 ccm)'),(15,7,1,11,'Klasa 2 (od 1200 do 1600 ccm)'),(17,7,1,11,'Klasa 3 (viÅ¡e od 1600 ccm )'),(19,9,1,11,'Klasa 4 (do 1200 ccm)'),(21,9,1,11,'Klasa 5 (od 1200 do 1600 ccm)'),(23,9,1,11,'Klasa 6 (viÅ¡e od 1600 ccm )'),(25,11,1,11,'Klasa 7 (do 1200 ccm)'),(27,11,1,11,'Klasa 8 (od 1200 do 1600 ccm )'),(29,11,1,11,'Klasa 9 (viÅ¡e od 1600 ccm)'),(31,0,1,1,'Grupa 1 - Serijski Automobili'),(33,31,1,1,'Klasa 1 (do 1200 ccm)'),(35,31,1,1,'Klasa 2 (od 1200 do 1600 ccm)'),(37,31,1,1,'Klasa 3 (viÅ¡e od 1600 ccm)'),(39,0,1,1,'Grupa 2 - Sprint Automobili'),(41,0,1,1,'Grupa 3 - Å portski Automobili'),(43,39,1,1,'Klasa 4 (do 1200 ccm)'),(45,39,1,1,'Klasa 5 (od 1200 do 1600 ccm)'),(47,39,1,1,'Klasa 6 (viÅ¡e od 1600 ccm)'),(49,41,1,1,'Klasa 7 (do 1200 ccm)'),(51,41,1,1,'Klasa 8 (od 1200 do 1600 ccm)'),(53,41,1,1,'Klasa 9 (viÅ¡e od 1600 ccm)'),(55,0,1,13,'Grupa 1 - Serijski Automobili'),(57,0,1,13,'Grupa 2 - Sprint Automobili'),(59,0,1,13,'Grupa 3 - Å portski Automobili'),(61,0,1,15,'Grupa N'),(63,0,1,15,'Grupa A'),(65,0,1,15,'Grupa E1'),(67,0,1,15,'Grupa SPC');
7INSERT INTO `racetype` VALUES (1,'Auto slalom'),(3,'Rally');
8INSERT INTO `team` VALUES (0,'N/A'),(1,'Črne strele'),(3,'Dupli 390'),(5,'PeljeÅ¡ac Racing Team'),(7,'Ćipe trafika non-stop team');
Note: See TracBrowser for help on using the browser.