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;
}