Add(MainForm,2953706,42,105)
{
 Width=242
 Height=245
 BorderStyle=1
 Position=1
 Point(onQueryEndSession)
 link(onCreate,403521:doOpen,[])
 link(onQueryEndSession,403521:doClose,[])
}
Add(DS_SQLite,403521,84,119)
{
 Name="mydb"
 FileName=":memory:"
 link(onOpen,8291282:doExec,[])
}
Add(DSC_Exec,8291282,126,119)
{
 SQL="CREATE TABLE IF NOT EXISTS city_list \r\n(\r\n city_id INTEGER PRIMARY KEY,\r\n city_name TEXT NOT NULL UNIQUE,\r\n city_code TEXT NOT NULL\r\n);\r\n\r\nCREATE TABLE IF NOT EXISTS users\r\n(\r\n users_id INTEGER PRIMARY KEY,\r\n users_name TEXT,\r\n id_city INTEGER \r\n);"
 DSManager="mydb"
 link(onExec,8323013:doEvent1,[])
}
Add(DSC_Query,10548812,196,119)
{
 SQL="SELECT count() FROM city_list;"
 DSManager="mydb"
 link(onQuery,5225380:doEvent,[])
}
Add(IndexToChanel,5225380,238,119)
{
 link(onEvent1,6287214:doExec,[])
}
Add(DSC_Exec,6287214,280,119)
{
 SQL="INSERT INTO city_list(city_name,city_code) values ("Москва","495");\r\nINSERT INTO city_list(city_name,city_code) values ("Сочи","8622");\r\nINSERT INTO city_list(city_name,city_code) values ("Иваново","0932");\r\nINSERT INTO city_list(city_name,city_code) values ("Самара","8462");\r\n\r\nINSERT INTO users values (1,"Сергей",1);\r\nINSERT INTO users values (2,"Виктор",2);\r\nINSERT INTO users values (3,"Сергей",4);\r\nINSERT INTO users values (4,"Иван",3);\r\nINSERT INTO users values (5,"Андрей",1); "
 DSManager="mydb"
}
Add(Hub,8323013,168,119)
{
 OutCount=3
 link(onEvent1,10548812:doQuery,[])
 link(onEvent2,16123899:doEvent1,[(186,132)(186,167)])
}
Add(DSC_Query,14879997,217,161)
{
 SQL="SELECT users_id, city_name, users_name \r\n FROM users, city_list \r\n WHERE city_id=id_city\r\n ORDER BY city_name, users_name; "
 DSManager="mydb"
 link(onQuery,13786266:doStr,[])
 link(onColumns,6261402:doClear,[])
}
Add(StringTable,6261402,301,161)
{
 Top=50
 Width=236
 Height=166
 Align=5
 WinStyle=2
 Columns=#5:id=30|5:Город|5:И м я|
 Grid=0
}
Add(MT_String,13786266,259,161)
{
 link(onResult,6261402:doAdd,[])
}
Add(ChildGroupBox,8795023,217,203)
{
 link(onEvent1,16123899:doEvent2,[(262,209)(262,243)(177,243)(177,174)])
}
BEGIN_SDK
  Add(EditMulti,2461057,21,21)
  {
   EventCount=1
   WorkCount=1
   Width=615
   link(doWork1,14692575:doQuery,[(73,27)(73,55)])
  }
  Add(Label,6106886,35,56)
  {
   Left=5
   Top=17
   Width=128
   Height=17
   Caption="Имя                        Город"
   AutoSize=1
  }
  Add(GroupBox,1868920,35,105)
  {
   Width=236
   Height=43
   Align=2
   Font=[MS Sans Serif,8,1,255,1]
   Caption="Добавить клиента."
  }
  Add(Edit,3931220,182,105)
  {
   Left=30
   Top=15
   Width=60
   Text=""
  }
  Add(ComboBox,12782292,210,49)
  {
   Left=130
   Top=15
   Width=70
   Height=21
   ReadOnly=0
   Point(Data)
  }
  Add(Button,4558982,84,168)
  {
   Left=205
   Top=15
   Width=20
   Caption="+"
   link(onClick,12168828:doString,[])
  }
  Add(InfoTip,11821466,427,35)
  {
   Info=#6: users|29:users_id INTEGER PRIMARY KEY,|16:users_name TEXT,|15:id_city INTEGER|
   HAlign=0
   Width=190
   Height=67
   Margin=5
  }
  Add(DSC_Query,14692575,126,49)
  {
   SQL="SELECT city_name, city_id FROM city_list ORDER BY city_name;"
   DSManager="parent.mydb"
   link(onQuery,12782292:doAdd,[])
   link(onColumns,12782292:doClear,[])
  }
  Add(DSC_Exec,11397422,259,168)
  {
   DSManager="parent.mydb"
   link(onExec,2461057:onEvent1,[(425,174)(425,27)])
  }
  Add(FormatStr,12168828,140,168)
  {
   DataCount=3
   Mask="INSERT INTO users values(%1,"%2",%3);"
   link(onFString,11397422:doExec,[])
   link(Str1,13202391:Value,[])
   link(Str2,3931220:Text,[(153,152)(188,152)])
   link(Str3,12782292:Data,[(160,159)(230,159)])
  }
  Add(Memory,13202391,140,105)
  {
   Default=String(NULL)
  }
END_SDK
Add(Hub,16123899,189,161)
{
 InCount=2
 link(onEvent1,14879997:doQuery,[])
 link(onEvent2,8795023:doWork1,[(210,174)(210,209)])
}

$updateTime = $mysqli->query("SELECT `update_time`
FROM   information_schema.tables
WHERE  `table_name` = '_workers'");

SELECT `update_time`
FROM   information_schema.tables
WHERE  `table_name` = '_workers' or `table_name` = '_apps'

SELECT `update_time`
FROM   information_schema.tables
WHERE  `table_name` = '_workers' or `table_name` = '_apps'

SELECT table_name,update_time
FROM   information_schema.tables
WHERE  (table_name = '_workers') or (table_name = '_apps');

SELECT users_id, city_name, city_code, users_name 
 FROM users, city_list 
 WHERE city_id=id_city
 ORDER BY city_name, users_name; 

             SELECT _apps.id, `time`, `address`, `sum`, `type`, _apps.city,`worker`,_apps.status as status, _workers.name,_workers.status AS w_status
             FROM `_workers`, `_apps`
             WHERE _apps.worker = _workers.vk_id
             ORDER BY `id` DESC LIMIT 9

SELECT users_id, city_name, city_code, users_name 
 FROM `users` LEFT JOIN city_list ON `users`.`id_city` = city_list.city_id
 ORDER BY city_name, users_name; 

SELECT _apps.id, `time`, `address`, `sum`, `type`, _apps.city,`worker`,_apps.status as status, _workers.name,_workers.status AS w_status
             FROM `_apps` LEFT JOIN _workers ON `_apps`.`worker` = _workers.vk_id
                          ORDER BY `id` DESC LIMIT 9