[手工架设] 十二之天贰手工端

Issue #397: Add support for logging DML queries, and make log file path fully customizable. Requires to move some session settings to a new SSL tab, to reduce the required dialog height.

Issue #397: Implement logging of DDL queries to migration files

Issue #397: simplify synchronized code calls in query threads, especially wrt LogFromOutside()

Fix %db in file pattern being replaced like a %d (current day) with a literal "b" after it.

Update year in license text

Fix empty query body when deleting grid rows in MSSQL mode, broken in b9b5976413dc6ff35e9e947816cc7264161b88f1. Closes#1294

Bump version for v11.2 release

Follow up to e66121a1c3cfe00c3ddbaca27ac11a052f4f4f6a: extend warning message to point the user in the right direction. See https://www.heidisql.com/forum.php?t=37505#p37514

Simplify bug report template to make it more likely users don't remove the template. Also, move preconditions to top, to give them more priority.

Separate Create > "Stored routine" menu item into two, one for procedures and one for functions. Closes#987

Simplify more code using the new PopupComponent() function

Simplify some code which checks where user has clicked, using the new PopupComponent()

Issue #75: pimp up context menu for indexes tab, and assign to foreign keys tab and check constraints tab as well

Issue #75: get "Add constraint" and "Delete constraint" buttons working, provide function list when editing check clause, and fix some more issues

Issue #75:
* detect table names in IS dynamically, on PostgreSQL and MySQL/MariaDB. This prevents me from using too complex version conditionals for detecting whether CHECK_CONSTRAINTS table is there
* even if CHECK_CONSTRAINTS table is there, the detection might fail due to the missing column TABLE_NAME, on MySQL, MSSQL and PostgreSQL. Catch SQL errors in that query and disable further detection of check constraints.

Issue #75: CHECK_CONSTRAINTS is there on MSSQL, but does not work due to missing TABLE_NAME column: https://www.heidisql.com/forum.php?t=37462

Issue #75: create editable list for check constraints in table editor

Add menu items for inserting lowercase GUID's into grid cell. Closes#1268

Fix crash in SynMemoQueryStatusChange when resizing main window with no active query tab

Update gnugettext unit to rev 134 from http://svn.code.sf.net/p/dxgettext/code/trunk/dxgettext/sample/gnugettext.pas

Update sqlite3 libraries from v3.30.1 to v3.34.0 from Dec 01 2020

Outsource a local function into TDBObject.SchemaClauseIS, and use it in GetTableColumns

Display number of indexes and foreign keys in caption of their tabs within the table editor. Helpful for knowing the number without having to activate their tab.

Rename TTableColumn.Expression field to the more unique and clear .GenerationExpression, also for distinction from the upcoming CHECK expression.

Fix scope for FStatus symbol of TTableColumn

Fix access violation in WalkNode.Parent in 32 bit mode. Not sure why but that happens after 67e3dc0a5181b2d053e15b9ce32822cf7a8a6814 . Closes#1270

Issue #477: Translate controls on CSV layout detector

Activate AutoSize and disable WordWrap on the replace hint in the search/replace dialog, so the height is auto-adjusted (especially with chars like g), and the words are not tried to be wrapped into a hidden second line.

Fix crash in SetupSynEditors after CSV layout detector was opened and closed once.

Widen status bar panels for big screens

Fix non working inheritance of font for completion proposal in trigger editor

Apply data type colors to column names in completion proposal, and move formatting code to new apphelpers.SynCompletionProposalPrettyText()

Rename two forms so these comply to my own code convention: TDataSortingForm=>TfrmDataSorting and TColumnSelectionForm=>TfrmColumnSelection

Warn the user about potential data loss when loading a (sql) file with encoding set to "auto-detect". That auto-detection has caused several data loss situations already.

Call SynUnicode.GetEncoding instead of our own old copied code in apphelpers.DetectEncoding. Probably enhances the "auto-detect encoding" option in file-open dialogs.

Code cleanup: rename options unit to preferences. And follow a naming convention for the form name, which I already have in some of the other forms: TfrmPreferences

Issue #744: Suspend action list on mainform while preferences dialog is open, so changes on the Shortcuts tab do not trigger some action, probably even with a crash

Issue #744: Shortcut settings: Let user know whether a wanted shortcut is assigned to another action, and prompt for confirmation in such cases.

Update bundled plink.exe to v0.74 from https://www.chiark.greenend.org.uk/~sgtatham/putty/latest.html . closes#1218

Move upper controls on view editor into a first tab of a new page control, and show CREATE code on a second tab. Closes#1135

Add support for JSONB column types in PostgreSQL. Closes#606

Auto-create directory path specified in SQL export target filename. Closes#1086

Issue #1241: Remove theme selection from installer

Catch file creation errors in TQueryTab.SaveContents, when an opened file was removed with its directory, from outside. And auto-create missing folder when user presses Ctrl+S then. Also, if tabs.ini has a tab entry with a no longer existing file, don't watch that non-existent file for changes, which fixes RestoreTabs showing an error on startup.

Try to prevent inner exception at the end of TMySQLQuery.Col. Hopefully reveals a more meaningful error message for issue #904

Enable cancel button after setting grid cell to NULL. Closes#1146

Limit rows per exported INSERT to 1000 for MSSQL. Introduced MaxRowsPerInsert property per connection type. 10000 for all other types. Closes#1189

Code cleanup: move some node index constants to TQueryTab, and probably prevent AV in treeQueryHelpersInitChildren

Support binary values in "More values" quick filter menu

Support regproc and regprocedure types on PostgreSQL, so these don't use SUBSTR() in data grid