Add(MainForm,2953706,35,105)
{
 Point(onClose)
 link(onCreate,11950164:doOpen,[])
 link(onClose,11950164:doClose,[])
}
Add(DS_SQLite,11950164,91,119)
{
 Name="test"
 FileName="Gunnman.db"
 link(onOpen,10508021:doEvent1,[])
}
Add(DSC_Exec,9745875,231,56)
{
 SQL="CREATE TABLE IF NOT EXISTS user(\r\nuserid INTEGER PRIMARY KEY AUTOINCREMENT, \r\nusername TEXT);\r\n\r\nCREATE TABLE IF NOT EXISTS orders(\r\norderid integer primary key autoincrement, \r\niduser integer, \r\nforeign key(iduser) references user(userid));\r\n"
 DSManager="test"
 link(onExec,8283439:doQuery,[])
}
Add(DSC_Query,9441597,231,126)
{
 SQL="select orders.orderid,user.username from orders, user WHERE iduser=userid;"
 DSManager="test"
 link(onQuery,2208233:doStr,[])
 link(onColumns,9187647:doEnum,[(282,139)(282,167)])
}
Add(Hub,10508021,168,119)
{
 link(onEvent1,9745875:doExec,[(206,125)(206,62)])
 link(onEvent2,9441597:doQuery,[])
}
Add(StringTable,13557538,357,126)
{
 Left=10
 Top=20
 Width=360
 Height=235
 Point(doAddColumn)
}
Add(MT_String,2208233,301,126)
{
 link(onResult,13557538:doAdd,[])
}
Add(MT_Enum,9187647,301,161)
{
 link(onItem,13557538:doAddColumn,[])
}
Add(DSC_Query,8283439,301,56)
{
 SQL="SELECT count() FROM user;"
 DSManager="test"
 link(onQuery,11787001:doCompare,[])
}
Add(DSC_Exec,2952501,420,56)
{
 SQL="insert into user values (NULL, 'Vasya');\r\ninsert into user values (NULL, 'Petya');\r\ninsert into user values (NULL, 'Kolya');\r\n\r\ninsert into orders values (NULL, 2);\r\ninsert into orders values (NULL, 1);\r\n"
 DSManager="test"
}
Add(If_else,11787001,357,56)
{
 Op2=Integer(0)
 link(onTrue,2952501:doExec,[])
}