public NewDatabase(ToolManager tool, UserManager usermanager) { Tool = tool; User = usermanager; InitializeComponent(); Editbox.Lexer = Lexer.Sql; Editbox.Margins[0].Width = 20; Editbox.Styles[Style.Sql.Number].ForeColor = Color.DarkOrange; Editbox.Styles[Style.Sql.String].ForeColor = Color.SaddleBrown; Editbox.Styles[Style.Sql.Character].ForeColor = Color.LimeGreen; Editbox.Styles[Style.Sql.Word].ForeColor = Color.Blue; Editbox.Styles[Style.Sql.Word2].ForeColor = Color.Blue; Editbox.SetKeywords(0, Words.Reserved1); Editbox.SetKeywords(1, Words.Reserved2); this.Editbox.Text = "CREATE SCHEMA 'new_schema' " + "\n"; }
public NewTable(ToolManager tool, UserManager usermanager) { Tool = tool; User = usermanager; InitializeComponent(); Editbox.Lexer = Lexer.Sql; Editbox.Margins[0].Width = 20; Editbox.Styles[Style.Sql.Number].ForeColor = Color.DarkOrange; Editbox.Styles[Style.Sql.String].ForeColor = Color.SaddleBrown; Editbox.Styles[Style.Sql.Character].ForeColor = Color.LimeGreen; Editbox.Styles[Style.Sql.Word].ForeColor = Color.Blue; Editbox.Styles[Style.Sql.Word2].ForeColor = Color.Blue; Editbox.SetKeywords(0, Words.Reserved1); Editbox.SetKeywords(1, Words.Reserved2); this.Editbox.Text ="CREATE TABLE 'TableName' ('Column Name' 'ColumnType' 'NOT NULL' 'AUTO_INCREMENT',Repeat" + ",PRIMARY KEY ('columnName'))"; }
public NewProcedure(ToolManager tool, UserManager usermanager) { Tool = tool; User = usermanager; InitializeComponent(); Editbox.Lexer = Lexer.Sql; Editbox.Margins[0].Width = 20; Editbox.Styles[Style.Sql.Number].ForeColor = Color.DarkOrange; Editbox.Styles[Style.Sql.String].ForeColor = Color.SaddleBrown; Editbox.Styles[Style.Sql.Character].ForeColor = Color.LimeGreen; Editbox.Styles[Style.Sql.Word].ForeColor = Color.Blue; Editbox.Styles[Style.Sql.Word2].ForeColor = Color.Blue; Editbox.SetKeywords(0, Words.Reserved1); Editbox.SetKeywords(1, Words.Reserved2); this.Editbox.Text = "CREATE PROCEDURE 'new_procedure' ()" +"\n"+ "BEGIN" +"\n "+ "END"; }
public NewIndex(ToolManager tool, UserManager usermanager) { Tool = tool; User = usermanager; InitializeComponent(); Editbox.Lexer = Lexer.Sql; Editbox.Margins[0].Width = 20; Editbox.Styles[Style.Sql.Number].ForeColor = Color.DarkOrange; Editbox.Styles[Style.Sql.String].ForeColor = Color.SaddleBrown; Editbox.Styles[Style.Sql.Character].ForeColor = Color.LimeGreen; Editbox.Styles[Style.Sql.Word].ForeColor = Color.Blue; Editbox.Styles[Style.Sql.Word2].ForeColor = Color.Blue; Editbox.SetKeywords(0, Words.Reserved1); Editbox.SetKeywords(1, Words.Reserved2); this.Editbox.Text = "CREATE INDEX 'your_index_name' " + "\n" + "ON 'your_table_name'('your_column_name')" + "\n" + "USING BTREE;"; this.RBNonUnique.Checked = true; }
public NewTrigger(ToolManager tool, UserManager usermanager) { Tool = tool; User = usermanager; InitializeComponent(); Editbox.Lexer = Lexer.Sql; Editbox.Margins[0].Width = 20; Editbox.Styles[Style.Sql.Number].ForeColor = Color.DarkOrange; Editbox.Styles[Style.Sql.String].ForeColor = Color.SaddleBrown; Editbox.Styles[Style.Sql.Character].ForeColor = Color.LimeGreen; Editbox.Styles[Style.Sql.Word].ForeColor = Color.Blue; Editbox.Styles[Style.Sql.Word2].ForeColor = Color.Blue; Editbox.SetKeywords(0, Words.Reserved1); Editbox.SetKeywords(1, Words.Reserved2); this.RBBefore.Checked = true; this.comboBox1.Text = comboBox1.Items[0].ToString(); this.Editbox.Text = "CREATE TRIGGER 'trigger_name' 'trigger_time'" + "\n" + "'trigger_event' ON table_name FOR EACH ROW" + "\n" + "BEGIN" + "\n" + "END"; }
public CreateUser(UserManager user,ToolManager tool) { InitializeComponent(); Usermanager = user; ToolManager = tool; }