diff options
| author | Andrew Guschin <guschin@altlinux.org> | 2024-11-05 20:50:22 +0400 |
|---|---|---|
| committer | Andrew Guschin <guschin@altlinux.org> | 2024-11-05 20:50:22 +0400 |
| commit | 1aa27fd246639ebe2a3f2c8bcbfe68cdd82ad3d4 (patch) | |
| tree | 930ca7d78d580a36ca3c383d0b80e39d937b01e1 /tables | |
| parent | f6b7e85798590cee4083fee0d40c86fe7b531896 (diff) | |
feat(tables): add sqlite project filenir
Diffstat (limited to 'tables')
| -rw-r--r-- | tables/nirdb.sqbpro | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/tables/nirdb.sqbpro b/tables/nirdb.sqbpro new file mode 100644 index 0000000..5dffb5c --- /dev/null +++ b/tables/nirdb.sqbpro @@ -0,0 +1,7 @@ +<?xml version="1.0" encoding="UTF-8"?><sqlb_project><db path="/home/aguschin/Other/coursework-year3/tables/db.sqlite" readonly="0" foreign_keys="" case_sensitive_like="" temp_store="" wal_autocheckpoint="" synchronous=""/><attached/><window><main_tabs open="structure browser pragmas query" current="1"/></window><tab_structure><column_width id="0" width="300"/><column_width id="1" width="0"/><column_width id="2" width="100"/><column_width id="3" width="1127"/><column_width id="4" width="0"/></tab_structure><tab_browse><current_table name="0,0:"/><default_encoding codec=""/><browse_table_settings/></tab_browse><tab_sql><sql name="SQL 1">update graphs +set ind_dom = dd.ind_dom +from dbupd.graphs as dd +where dd.g6 = graphs.g6;</sql><sql name="SQL 2">select * from dbupd.graphs where g6='CF';</sql><sql name="SQL 3">detach dbupd;</sql><sql name="SQL 4">select g6, ind_dom, forced_geod +from graphs +where g6 in ('C]', 'D]{', 'E?bg', 'ECpo', 'F?rdw', 'F~~~w', 'G?q`qg', 'GCRvP{', 'GCOfvg', 'G???F?', 'G?AFAw', 'HQy~vnn', 'HQhTVbd', 'H??CFz~', 'I????????', 'I?BDDHo@w', 'I?B@cZG@w', 'ICXmfQqBw', 'I?AA@BOZ?', 'I?ABEdl~g', 'I?BcrjMMo', 'I???EB?~w', 'I??CAB{Nw', 'IEhuTxyFw'); +</sql><current_tab id="3"/></tab_sql></sqlb_project> |