Resetting the app windows/UI to defaults

[audiomuze]

I accidentally undocked the Database window from the main app and cannot get it to dock again. At the same time the settings database file contains years of code I don't want to lose.

What group, key rows do I need to delete from the settings table to restore defaults without losing any of the many code windows and snippets I have?

[pawelsalawa]

You should be able to drag the popped window over the left or right edge of main SQLiteStudio window and it will show you the drop area (blue square on the edge). Doesn't it?

[audiomuze]

Nope, I can drag it past the main SQLiteStudio window and float it outside that, it has seemingly no affinity.

So the key I think is knowing which of these records to delete?

group	key
CodeAssistant	AutoTrigger
Colors	SyntaxBindParamFg
Colors	SyntaxBindParamFgCustom
Colors	SyntaxBlobFg
Colors	SyntaxBlobFgCustom
Colors	SyntaxCommentFg
Colors	SyntaxCommentFgCustom
Colors	SyntaxCurrentLineBg
Colors	SyntaxCurrentLineBgCustom
Colors	SyntaxCurrentQueryBg
Colors	SyntaxCurrentQueryBgCustom
Colors	SyntaxForeground
Colors	SyntaxForegroundCustom
Colors	SyntaxKeywordFg
Colors	SyntaxKeywordFgCustom
Colors	SyntaxNumberFg
Colors	SyntaxNumberFgCustom
Colors	SyntaxParenthesisBg
Colors	SyntaxParenthesisBgCustom
Colors	SyntaxParenthesisFg
Colors	SyntaxParenthesisFgCustom
Colors	SyntaxStringFg
Colors	SyntaxStringFgCustom
Colors	SyntaxValidObject
Colors	SyntaxValidObjectCustom
CsvExport	ColumnsInFirstRow
CsvExport	CustomSeparator
CsvExport	NullValueString
CsvExport	Separator
CsvImport	CustomSeparator
CsvImport	FirstRowAsColumns
CsvImport	NullValueString
CsvImport	QuotationMark
CsvImport	Separator
DialogDimensions	ColumnDialog
DialogDimensions	ConfigDialog
DialogDimensions	ExportDialog
DialogDimensions	ImportDialog
DialogDimensions	IndexDialog
DialogDimensions	SearchTextDialog
ExportDialog	codec
ExportDialog	exportData
ExportDialog	exportTableIndexes
ExportDialog	exportTableTriggers
ExportDialog	format
ExportDialog	intoClipboard
ExportDialog	outputFileName
Fonts	DbTreeLabel
Fonts	SqlEditor
General	ActiveCodeFormatter
General	AutoOpenStatusField
General	BindParamsCacheSize
General	BypassDbDialogWhenDropped
General	CheckUpdatesOnStartup
General	ColumnWidthForName
General	DataEditorsOrder
General	DataTabAsFirstInTables
General	DataTabAsFirstInViews
General	DdlHistorySize
General	DontShowDdlPreview
General	EnlargeColumnForValue
General	ExecuteCurrentQueryOnly
General	ExpandTables
General	ExpandViews
General	FileDialogLastPath
General	KeepNullWhenEmptyValue
General	LanguageAsked
General	LimitRowsForManyColumns
General	LoadedPlugins
General	MaxInitialColumnWith
General	NewDbNotPermanentByDefault
General	OpenMaximized
General	OpenTablesOnData
General	OpenViewsOnData
General	PopulateHistorySize
General	Session
General	ShowDataViewTooltips
General	ShowRegularTableLabels
General	ShowSystemObjects
General	ShowVirtualTableLabels
General	SortColumns
General	SortObjects
General	SqlEditorTabs
General	SqlEditorWrapWords
General	SqlHistorySize
General	Style
General	UseDefaultValueForNull
General	UseSciFormatForDoubles
ImportDialog	codec
ImportDialog	format
ImportDialog	ignoreErrors
ImportDialog	inputFileName
Internal	CodeSnippets
Internal	DefaultSnippetsCreated
ShortcutsCategoryCodeSnippetEditor	COMMIT
ShortcutsCategoryCodeSnippetEditor	ROLLBACK
ShortcutsCategoryCollationsEditor	COMMIT
ShortcutsCategoryCollationsEditor	ROLLBACK
ShortcutsCategoryFunctionsEditor	COMMIT
ShortcutsCategoryFunctionsEditor	ROLLBACK
ShortcutsCategorySqliteExtensionEditor	COMMIT
ShortcutsCategorySqliteExtensionEditor	ROLLBACK
ShortcutsCategoryTableWindow	ADD_COLUMN
ShortcutsCategoryTableWindow	ADD_INDEX
ShortcutsCategoryTableWindow	ADD_TABLE_CONSTRAINT
ShortcutsCategoryTableWindow	ADD_TRIGGER
ShortcutsCategoryTableWindow	COMMIT_STRUCTURE
ShortcutsCategoryTableWindow	DEL_COLUMN
ShortcutsCategoryTableWindow	DEL_INDEX
ShortcutsCategoryTableWindow	DEL_TABLE_CONSTRAINT
ShortcutsCategoryTableWindow	DEL_TRIGGER
ShortcutsCategoryTableWindow	EDIT_COLUMN
ShortcutsCategoryTableWindow	EDIT_INDEX
ShortcutsCategoryTableWindow	EDIT_TABLE_CONSTRAINT
ShortcutsCategoryTableWindow	EDIT_TRIGGER
ShortcutsCategoryTableWindow	EXPORT
ShortcutsCategoryTableWindow	IMPORT
ShortcutsCategoryTableWindow	NEXT_TAB
ShortcutsCategoryTableWindow	PREV_TAB
ShortcutsCategoryTableWindow	REFRESH_INDEXES
ShortcutsCategoryTableWindow	REFRESH_STRUCTURE
ShortcutsCategoryTableWindow	REFRESH_TRIGGERS
ShortcutsCategoryTableWindow	ROLLBACK_STRUCTURE
ShortcutsCategoryViewWindow	ADD_TRIGGER
ShortcutsCategoryViewWindow	COMMIT_QUERY
ShortcutsCategoryViewWindow	DEL_TRIGGER
ShortcutsCategoryViewWindow	EDIT_TRIGGER
ShortcutsCategoryViewWindow	EXECUTE_QUERY
ShortcutsCategoryViewWindow	NEXT_TAB
ShortcutsCategoryViewWindow	PREV_TAB
ShortcutsCategoryViewWindow	REFRESH_TRIGGERS
ShortcutsCategoryViewWindow	ROLLBACK_QUERY

[pawelsalawa]

General / Session is the one. Just be aware, that it will also erase your currently open SQL Editor windows, so if you have some precious SQLs in them, copy them.

[audiomuze]

Thanks. Here's a screenshot so you can see what I'm describing. Is it not a bug rather than a discussion point?