object MainForm: TMainForm
  Left = 0
  Top = 0
  BorderStyle = bsSingle
  Caption = 'MySQL Delphi Experiments'
  ClientHeight = 555
  ClientWidth = 721
  Color = clBtnFace
  DefaultMonitor = dmDesktop
  Font.Charset = DEFAULT_CHARSET
  Font.Color = clWindowText
  Font.Height = -11
  Font.Name = 'Tahoma'
  Font.Style = []
  OldCreateOrder = False
  OnClose = FormClose
  OnCreate = FormCreate
  PixelsPerInch = 96
  TextHeight = 13
  object sPageControl1: TsPageControl
    Left = 0
    Top = 0
    Width = 721
    Height = 536
    ActivePage = sTabSheet2
    Align = alClient
    TabOrder = 0
    SkinData.SkinSection = 'PAGECONTROL'
    object sTabSheet1: TsTabSheet
      Caption = 'MySQL Connection'
      SkinData.CustomColor = False
      SkinData.CustomFont = False
      ExplicitLeft = 0
      ExplicitTop = 0
      ExplicitWidth = 0
      ExplicitHeight = 0
      object Label1: TLabel
        Left = 40
        Top = 152
        Width = 52
        Height = 13
        Caption = 'DATABASE'
      end
      object Button1: TButton
        Left = 384
        Top = 160
        Width = 193
        Height = 41
        Caption = 'Connect'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Height = -14
        Font.Name = 'Tahoma'
        Font.Style = []
        ParentFont = False
        TabOrder = 0
        OnClick = Button1Click
      end
      object Button2: TButton
        Left = 384
        Top = 207
        Width = 193
        Height = 41
        Caption = 'Disconnect'
        TabOrder = 1
        OnClick = Button2Click
      end
      object LabeledEdit3: TLabeledEdit
        Left = 384
        Top = 40
        Width = 193
        Height = 21
        EditLabel.Width = 31
        EditLabel.Height = 13
        EditLabel.Caption = 'LOGIN'
        TabOrder = 2
        Text = 'root'
      end
      object LabeledEdit4: TLabeledEdit
        Left = 384
        Top = 96
        Width = 193
        Height = 21
        EditLabel.Width = 57
        EditLabel.Height = 13
        EditLabel.Caption = 'PASSWORD'
        TabOrder = 3
        Text = 'masterkey'
      end
      object LabeledEdit1: TLabeledEdit
        Left = 40
        Top = 40
        Width = 193
        Height = 21
        EditLabel.Width = 27
        EditLabel.Height = 13
        EditLabel.Caption = 'HOST'
        TabOrder = 4
        Text = 'localhost'
      end
      object LabeledEdit2: TLabeledEdit
        Left = 40
        Top = 104
        Width = 193
        Height = 21
        EditLabel.Width = 27
        EditLabel.Height = 13
        EditLabel.Caption = 'PORT'
        TabOrder = 5
        Text = '3306'
      end
      object ComboBox1: TComboBox
        Left = 40
        Top = 171
        Width = 193
        Height = 21
        TabOrder = 6
        Text = 'ComboBox1'
      end
    end
    object sTabSheet2: TsTabSheet
      Caption = 'DBGrid'
      SkinData.CustomColor = False
      SkinData.CustomFont = False
      object sPanel1: TsPanel
        Left = 0
        Top = 0
        Width = 226
        Height = 508
        Align = alLeft
        TabOrder = 0
        SkinData.SkinSection = 'PANEL'
        object Label2: TLabel
          Left = 9
          Top = 32
          Width = 75
          Height = 13
          Caption = #1058#1072#1073#1083#1080#1094#1099' '#1080#1079' '#1041#1044
        end
        object Label3: TLabel
          Left = 9
          Top = 13
          Width = 3
          Height = 13
        end
        object ComboBox2: TComboBox
          Left = 9
          Top = 51
          Width = 208
          Height = 21
          TabOrder = 0
          Text = 'ComboBox2'
        end
        object BtnShowTable: TButton
          Left = 5
          Top = 78
          Width = 216
          Height = 25
          Caption = #1055#1086#1082#1072#1079#1072#1090#1100' '#1090#1072#1073#1083#1080#1094#1091
          TabOrder = 1
          OnClick = BtnShowTableClick
        end
        object Button3: TButton
          Left = 5
          Top = 115
          Width = 216
          Height = 25
          Caption = 'INSERT ('#1042#1089#1090#1072#1074#1082#1072' '#1074' '#1090#1077#1082#1091#1097#1091#1102' '#1087#1086#1079#1080#1094#1080#1102')'
          TabOrder = 2
          OnClick = Button3Click
        end
        object Button4: TButton
          Left = 5
          Top = 146
          Width = 216
          Height = 25
          Caption = 'SAVE ('#1057#1086#1093#1088#1072#1085#1080#1090#1100' '#1074' '#1092#1080#1079#1080#1095#1077#1089#1082#1091#1102' '#1041#1044')'
          TabOrder = 3
          OnClick = Button4Click
        end
        object Add: TButton
          Left = 7
          Top = 192
          Width = 213
          Height = 25
          Caption = 'ADD ('#1044#1086#1073#1072#1074#1080#1090#1100' '#1079#1072#1087#1080#1089#1100' '#1074' '#1082#1086#1085#1077#1094')'
          TabOrder = 4
        end
        object Edit: TButton
          Left = 7
          Top = 223
          Width = 213
          Height = 25
          Caption = 'Edit ('#1056#1077#1076#1072#1082#1090#1080#1088#1086#1074#1072#1090#1100' '#1090#1077#1082#1091#1097#1091#1102' '#1079#1072#1087#1080#1089#1100')'
          TabOrder = 5
        end
        object Button5: TButton
          Left = 7
          Top = 254
          Width = 213
          Height = 25
          Caption = 'Delete ('#1059#1076#1072#1083#1080#1090#1100' '#1090#1077#1082#1091#1097#1091#1102' '#1079#1072#1087#1080#1089#1100')'
          TabOrder = 6
        end
        object Button6: TButton
          Left = 7
          Top = 304
          Width = 213
          Height = 25
          Caption = 'Next ('#1057#1083#1077#1076#1091#1102#1097#1072#1103' '#1079#1072#1087#1080#1089#1100')'
          TabOrder = 7
        end
        object Button7: TButton
          Left = 7
          Top = 335
          Width = 213
          Height = 25
          Caption = 'Prior ('#1055#1088#1077#1076#1099#1076#1091#1097#1072#1103' '#1079#1072#1087#1080#1089#1100')'
          TabOrder = 8
        end
        object Button8: TButton
          Left = 7
          Top = 384
          Width = 213
          Height = 25
          Caption = 'Refresh ('#1054#1073#1085#1086#1074#1080#1090#1100' '#1076#1072#1085#1085#1099#1077')'
          TabOrder = 9
        end
        object Button9: TButton
          Left = 8
          Top = 415
          Width = 213
          Height = 25
          Caption = 'UNDO ('#1054#1090#1084#1077#1085#1080#1090#1100' '#1080#1079#1084#1077#1085#1077#1085#1080#1103')'
          TabOrder = 10
        end
      end
      object sPanel2: TsPanel
        Left = 226
        Top = 0
        Width = 487
        Height = 508
        Align = alClient
        TabOrder = 1
        SkinData.SkinSection = 'PANEL'
        object DBGrid1: TDBGrid
          Left = 1
          Top = 26
          Width = 485
          Height = 481
          Align = alClient
          DataSource = DataSource1
          TabOrder = 0
          TitleFont.Charset = DEFAULT_CHARSET
          TitleFont.Color = clWindowText
          TitleFont.Height = -11
          TitleFont.Name = 'Tahoma'
          TitleFont.Style = []
        end
        object DBNavigator1: TDBNavigator
          Left = 1
          Top = 1
          Width = 485
          Height = 25
          DataSource = DataSource1
          Align = alTop
          TabOrder = 1
        end
      end
    end
  end
  object StatusBar1: TStatusBar
    Left = 0
    Top = 536
    Width = 721
    Height = 19
    Panels = <
      item
        Width = 250
      end
      item
        Width = 100
      end>
  end
  object SQLConnection1: TSQLConnection
    DriverName = 'MySQL'
    LoginPrompt = False
    Params.Strings = (
      'DriverUnit=Data.DBXMySQL'
      
        'DriverPackageLoader=TDBXDynalinkDriverLoader,DbxCommonDriver210.' +
        'bpl'
      
        'DriverAssemblyLoader=Borland.Data.TDBXDynalinkDriverLoader,Borla' +
        'nd.Data.DbxCommonDriver,Version=21.0.0.0,Culture=neutral,PublicK' +
        'eyToken=91d62ebb5b0d1b1b'
      
        'MetaDataPackageLoader=TDBXMySqlMetaDataCommandFactory,DbxMySQLDr' +
        'iver210.bpl'
      
        'MetaDataAssemblyLoader=Borland.Data.TDBXMySqlMetaDataCommandFact' +
        'ory,Borland.Data.DbxMySQLDriver,Version=21.0.0.0,Culture=neutral' +
        ',PublicKeyToken=91d62ebb5b0d1b1b'
      'GetDriverFunc=getSQLDriverMYSQL'
      'LibraryName=dbxmys.dll'
      'LibraryNameOsx=libsqlmys.dylib'
      'VendorLib=LIBMYSQL.dll'
      'VendorLibWin64=libmysql.dll'
      'VendorLibOsx=libmysqlclient.dylib'
      'HostName=ServerName'
      'Database=DBNAME'
      'User_Name=user'
      'Password=password'
      'MaxBlobSize=-1'
      'LocaleCode=0000'
      'Compressed=False'
      'Encrypted=False'
      'BlobSize=-1'
      'ErrorResourceFile=')
    Left = 628
    Top = 336
  end
  object SimpleDataSet1: TSimpleDataSet
    Aggregates = <>
    DataSet.MaxBlobSize = -1
    DataSet.Params = <>
    Params = <>
    Left = 484
    Top = 400
  end
  object DataSource1: TDataSource
    DataSet = SimpleDataSet1
    Left = 560
    Top = 368
  end
  object SQLQuery1: TSQLQuery
    MaxBlobSize = -1
    ParamCheck = False
    Params = <>
    SQL.Strings = (
      'CREATE  TABLE IF NOT EXISTS `test_db`.`Departments` ('
      '  `Primary_key` INT NOT NULL AUTO_INCREMENT ,'
      '  `Name` VARCHAR(45) NOT NULL ,'
      '  PRIMARY KEY (`Primary_key`) )'
      'ENGINE = InnoDB;'
      ''
      ''
      ''
      ''
      'CREATE  TABLE IF NOT EXISTS `test_db`.`Employee` ('
      '  `Primary_key` INT NOT NULL AUTO_INCREMENT ,'
      '  `Name` VARCHAR(45) NOT NULL DEFAULT '#39'Default_Name'#39' ,'
      '  `Family` VARCHAR(45) NOT NULL DEFAULT '#39'Default_Family'#39' ,'
      '  `Age` INT NOT NULL DEFAULT 32 ,'
      '  `Salary` VARCHAR(45) NOT NULL DEFAULT '#39'50000'#39' ,'
      '  `Department_key` INT NOT NULL ,'
      '  PRIMARY KEY (`Primary_key`) ,'
      '  INDEX `FKDapartment_idx` (`Department_key` ASC) ,'
      '  CONSTRAINT `FKDapartment`'
      '    FOREIGN KEY (`Department_key` )'
      '    REFERENCES `test_db`.`Departments` (`Primary_key` )'
      '    ON DELETE NO ACTION'
      '    ON UPDATE NO ACTION)'
      'ENGINE = InnoDB;'
      ''
      'USE `test_db` ;'
      '')
    SQLConnection = SQLConnection1
    Left = 404
    Top = 440
  end
  object SQLTable1: TSQLTable
    Left = 316
    Top = 392
  end
end
