Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- MySqlCommand cmdDatabase;
- try
- {
- cmdDatabase = new MySqlCommand("CREATE DATABASE IF NOT EXISTS NOVAbazaROBOT1;", conDatabase);
- if (conDatabase.State == ConnectionState.Closed || conDatabase.State == ConnectionState.Connecting)
- conDatabase.Open();
- cmdDatabase.ExecuteNonQuery();
- cmdDatabase = new MySqlCommand("USE NOVAbazaROBOT1;", conDatabase);
- cmdDatabase.ExecuteNonQuery();
- //"CREATE TABLE IF NOT EXISTS
- cmdDatabase = new MySqlCommand("CREATE TABLE IF NOT EXISTS NOVAbazaROBOT1_TabelaStanja (" +
- "PK_Orig INT NOT NULL auto_increment," +
- "Ime_Stanja CHAR(100)," +
- "Glava FLOAT," +
- "Prvi_Zglob_Levi FLOAT," +
- "Drugi_Zglob_Levi FLOAT," +
- "Treci_Zglob_Levi FLOAT," +
- "Prvi_Zglob_Desni FLOAT," +
- "Drugi_Zglob_Desni FLOAT," +
- "Treci_Zglob_Desni FLOAT," +
- "PRIMARY KEY (PK_Orig));", conDatabase);
- cmdDatabase.ExecuteNonQuery();
- cmdDatabase = new MySqlCommand("CREATE TABLE IF NOT EXISTS NOVAbazaROBOT1_spisakSvihScenarija (" +
- "PK_Orig INT NOT NULL auto_increment," +
- "Ime_Scenarija CHAR(100)," +
- "PRIMARY KEY (PK_Orig));", conDatabase);
- cmdDatabase.ExecuteNonQuery();
- cmdDatabase = new MySqlCommand("CREATE TABLE IF NOT EXISTS NOVAbazaROBOT1_tabelaTip (" +
- "PK_Orig INT NOT NULL auto_increment," +
- "Ime_Tipa CHAR(100)," +
- "PRIMARY KEY (PK_Orig));", conDatabase);
- cmdDatabase.ExecuteNonQuery();
- cmdDatabase = new MySqlCommand("CREATE TABLE IF NOT EXISTS NOVAbazaROBOT1_tabelaPokret (" +
- "PK_Orig INT NOT NULL auto_increment," +
- "Ime_Pokreta CHAR(100)," +
- "PRIMARY KEY (PK_Orig));", conDatabase);
- cmdDatabase.ExecuteNonQuery();
- cmdDatabase = new MySqlCommand("CREATE TABLE IF NOT EXISTS NOVAbazaROBOT1_spisakScenarijaZaIzvrsavanje (" +
- "PK_Orig INT NOT NULL auto_increment," +
- "Foreign_Key_SpisakSvihScenarija INT," +
- "PRIMARY KEY (PK_Orig));", conDatabase);
- cmdDatabase.ExecuteNonQuery();
- cmdDatabase = new MySqlCommand("CREATE TABLE IF NOT EXISTS NOVAbazaROBOT1_definicijeScenarija (" +
- "PK_Orig INT NOT NULL auto_increment," +
- "FK_Spisak_Svih_Scenarija INT," +
- "FK_Tabela_Tip INT DEFAULT NULL," +
- "FK_Stanja INT," +
- "FK_Tabela_Pokret INT DEFAULT NULL," +
- "Brzina_izvodjenja INT," +
- "Preorder INT," +
- "Postorder INT," +
- "Parent INT," +
- "Level INT," +
- "PRIMARY KEY (PK_Orig)," +
- "FOREIGN KEY (FK_Spisak_Svih_Scenarija) REFERENCES NOVAbazaROBOT1_spisakSvihScenarija(PK_Orig)," +
- "FOREIGN KEY (FK_Tabela_Tip) REFERENCES NOVAbazaROBOT1_tabelaTip(PK_Orig)," +
- "FOREIGN KEY (FK_Stanja) REFERENCES NOVAbazaROBOT1_TabelaStanja(PK_Orig)," +
- "FOREIGN KEY (FK_Tabela_Pokret) REFERENCES NOVAbazaROBOT1_tabelaPokret(PK_Orig)" +
- ");", conDatabase);
- cmdDatabase.ExecuteNonQuery();
- }
- catch (Exception ex) //(NullReferenceException ex)
- {
- MessageBox.Show(ex.Message);
- }
- if (conDatabase.State == ConnectionState.Open)
- {
- conDatabase.Close();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement