AboutDialogAbout SQLiteStudio and licensesAbout<html><head/><body><p align="center"><span style=" font-size:11pt; font-weight:600;">SQLiteStudio v%1</span></p><p align="center">Free, open-source, cross-platform SQLite database manager.<br/><a href="http://sqlitestudio.pl"><span style=" text-decoration: underline; color:#0000ff;">http://sqlitestudio.pl</span></a><br/></p><p align="center">%2<br/></p><p align="center">Author and active maintainer:<br/>SalSoft (<a href="http://salsoft.com.pl"><span style=" text-decoration: underline; color:#0000ff;">http://salsoft.com.pl</span></a>)<br/></p></body></html>LicensesEnvironmentIcon directoriesForm directoriesPlugin directoriesApplication directorySQLite 3 version:Configuration directoryQt version:Portable distribution.MacOS X application boundle distribution.Operating system managed distribution.Copy<h3>Table of contents:</h3><ol>%2</ol>BugDialogBugs and ideasReporterE-mail addressLog inShort descriptionDetailed descriptionShow more detailsSQLiteStudio versionOperating systemLoaded pluginsSendYou can see all your reported bugs and ideas by selecting menu '%1' and then '%2'.A bug report sent successfully.An error occurred while sending a bug report: %1
%2You can retry sending. The contents will be restored when you open a report dialog after an error like this.An idea proposal sent successfully.An error occurred while sending an idea proposal: %1
%2A bug reportDescribe problem in few wordsDescribe problem and how to reproduce itA new feature ideaA title for your ideaDescribe your idea in more detailsReporting as an unregistered user, using e-mail address.Reporting as a registered user.Log outProviding true email address will make it possible to contact you regarding your report. To learn more, press 'help' button on the right side.Enter vaild e-mail address, or log in.Short description requires at least 10 characters, but not more than 100. Longer description can be entered in the field below.Long description requires at least 30 characters.BugReportHistoryWindowTitleReported atURLReports historyClear reports historyDelete selected entryInvalid response from server.BugReportLoginDialogLog inCredentialsLogin:Password:ValidationValidateValidation result messageAbortA login must be at least 2 characters long.A password must be at least 5 characters long.ValidCollationsEditorFilter collationsCollation name:Implementation language:DatabasesRegister in all databasesRegister in following databases:Implementation code:Collations editorCommit all collation changesRollback all collation changesCreate new collationDelete selected collationEditing collations manualEnter a non-empty, unique name of the collation.Pick the implementation language.Enter a non-empty implementation code.Collations editor window has uncommited modifications.ColorButtonPick a colorColumnCollatePanelCollation name:Named constraint:Enter a name of the constraint.Enter a collation name.ColumnDefaultPanelDefault value:Named constraint:Enter a default value expression.Invalid default value expression: %1Enter a name of the constraint.ColumnDialogColumnName and typeScalePrecisionData type:Column name:Size:ConstraintsUniqueConfigureForeign KeyCollateNot NULLCheck conditionPrimary KeyDefaultAdvanced modeAdd constraintcolumn dialogEdit constraintcolumn dialogDelete constraintcolumn dialogMove constraint upcolumn dialogMove constraint downcolumn dialogAdd a primary keycolumn dialogAdd a foreign keycolumn dialogAdd an unique constraintcolumn dialogAdd a check constraintcolumn dialogAdd a not null constraintcolumn dialogAdd a collate constraintcolumn dialogAdd a default constraintcolumn dialogAre you sure you want to delete constraint '%1'?column dialogCorrect the constraint's configuration.This constraint is not officially supported by SQLite 2,
but it's okay to use it.ColumnDialogConstraintsModelTypecolumn dialog constraintsNamecolumn dialog constraintsDetailscolumn dialog constraintsColumnForeignKeyPanelForeign table:Foreign column:ReactionsDeferred foreign keyNamed constraintConstraint namePick the foreign table.Pick the foreign column.Enter a name of the constraint.ColumnPrimaryKeyPanelAutoincrementSort order:Named constraint:On conflict:Enter a name of the constraint.Autoincrement (only for %1 type columns)column primary keyColumnUniqueAndNotNullPanelNamed constraint:On conflict:Enter a name of the constraint.CompleterWindowColumn: %1completer statusbarTable: %1completer statusbarIndex: %1completer statusbarTrigger: %1completer statusbarView: %1completer statusbarDatabase: %1completer statusbarKeyword: %1completer statusbarFunction: %1completer statusbarOperator: %1completer statusbarStringcompleter statusbarNumbercompleter statusbarBinary datacompleter statusbarCollation: %1completer statusbarPragma function: %1completer statusbarConfigDialogConfigurationSearchGeneralKeyboard shortcutsLook & feelStyleFontsColorsPluginsCode formattersData browsingData editorsData browsing and editingNumber of data rows per page:<p>When the data is read into grid view columns width is automatically adjusted. This value limits the initial width for the adjustment, but user can still resize the column manually over this limit.</p>Limit initial data column width to (in pixels):Data typesAvailable editors:Editors selected for this data type:Schema editingNumber of DDL changes kept in history.DDL history size:Don't show DDL preview dialog when commiting schema changesSQL queriesNumber of queries kept in the history.History size:<p>If there is more than one query in the SQL editor window, then (if this option is enabled) only a single query will be executed - the one under the keyboard insertion cursor. Otherwise all queries will be executed. You can always limit queries to be executed by selecting those queries before calling to execute.</p>Execute only the query under the cursorUpdatesAutomatically check for updates at startupSessionRestore last session (active MDI windows) after startupFilter shortcuts by name or key combinationActionKey combinationLanguageChanging language requires application restart to take effect.Compact layout<p>Compact layout reduces all margins and spacing on the UI to minimum, making space for displaying more data. It makes the interface a little bit less aesthetic, but allows to display more data at once.</p>Use compact layoutGeneral.CompactLayoutDatabase listIf switched off, then columns will be sorted in the order they are typed in CREATE TABLE statement.Sort table columns alphabeticallyExpand tables node when connected to a database<p>Additional labels are those displayed next to the names on the databases list (they are blue, unless configured otherwise). Enabling this option will result in labels for databases, invalid databases and aggregated nodes (column group, index group, trigger group). For more labels see options below.<p>Display additional labels on the listFor regular tables labels will show number of columns, indexes and triggers for each of tables.Display labels for regular tablesVirtual tables will be marked with a 'virtual' label.Display labels for virtual tablesExpand views node when connected to a databaseIf this option is switched off, then objects will be sorted in order they appear in sqlite_master table (which is in order they were created)Sort objects (tables, indexes, triggers and views) alphabeticallyDisplay system tables and indexes on the listTable windowsWhen enabled, Table Windows will show up with the data tab, instead of the structure tab.Open Table Windows with the data tab for startView windowsWhen enabled, View Windows will show up with the data tab, instead of the structure tab.Open View Windows with the data tab for startMain window dock areasLeft and right areas occupy cornersTop and bottom areas occupy cornersHide built-in pluginsCurrent style:PreviewEnabledDisabledActive formatter pluginSQL editor fontDatabase list fontDatabase list additional label fontData view fontStatus field fontSQL editor colorsCurrent line background<p>SQL strings are enclosed with single quote characters.</p>String foreground<p>Bind parameters are placeholders for values yet to be provided by the user. They have one of the forms:</p><ul><li>:param_name</li><li>$param_name</li><li>@param_name</li><li>?</li></ul>Bind parameter foregroundHighlighted parenthesis background<p>BLOB values are binary values represented as hexadecimal numbers, like:</p><ul><li>X'12B4'</li><li>x'46A2F4'</li></ul>BLOB value foregroundRegular foregroundLine numbers area backgroundKeyword foregroundNumber foregroundComment foreground<p>Valid objects are name of tables, indexes, triggers, or views that exist in the SQLite database.</p>Valid objects foregroundData view colors<p>Any data changes will be outlined with this color, until they're commited to the database.</p>Uncommited data outline color<p>In case of error while commiting data changes, the problematic cell will be outlined with this color.</p>Commit error outline colorNULL value foregroundDeleted row backgroundDatabase list colors<p>Additional labels are those which tell you SQLite version, number of objects deeper in the tree, etc.</p>Additional labels foregroundStatus field colorsInformation message foregroundWarning message foregroundError message foregroundDescription:plugin detailsCategory:plugin detailsVersion:plugin detailsAuthor:plugin detailsInternal name:plugin detailsDependencies:plugin detailsConflicts:plugin detailsPlugin detailsPlugins are loaded/unloaded immediately when checked/unchecked, but modified list of plugins to load at startup is not saved until you commit the whole configuration dialog.%1 (built-in)plugins manager in configuration dialogDetailsNo plugins in this category.Add new data typeRename selected data typeDelete selected data typeHelp for configuring data type editorsConstraintCheckPanelThe conditionNamed constraint:On conflictEnter a valid condition.Enter a name of the constraint.ConstraintDialogNew constraintconstraint dialogCreateconstraint dialogEdit constraintdialog windowApplyconstraint dialogPrimary keytable constraintsForeign keytable constraintsUniquetable constraintsNot NULLtable constraintsChecktable constraintsCollatetable constraintsDefaulttable constraintsConstraintTabModelTabletable constraintsColumn (%1)table constraintsScopetable constraintsTypetable constraintsDetailstable constraintsNametable constraintsCssDebugDialogSQLiteStudio CSS consoleDataViewFilter datadata viewGrid viewForm viewRefresh table datadata viewFirst pagedata viewPrevious pagedata viewNext pagedata viewLast pagedata viewApply filterdata viewCommit changes for selected cellsdata viewRollback changes for selected cellsdata viewShow grid view of resultssql editorShow form view of resultssql editorFilter by textdata viewFilter by the Regular Expressiondata viewFilter by SQL expressiondata viewTabs on topdata viewTabs at bottomdata viewTotal number of rows is being counted.
Browsing other pages will be possible after the row counting is done.Row: %1DbConverterDialogConvert databaseSource databaseSource database version:Target databaseTarget version:This is the file that will be created as a result of the conversion.Target file:Name of the new database:This is the name that the converted database will be added to SQLiteStudio with.Select source databaseEnter valid and writable file path.Entered file exists and will be overwritten.Enter a not empty, unique name (as in the list of databases on the left).No valid target dialect available. Conversion not possible.Select valid target dialect.Database %1 has been successfully converted and now is available under new name: %2SQL statements conversionFollowing error occurred while converting SQL statements to the target SQLite version:Would you like to ignore those errors and proceed?DbDialogDatabaseDatabase typeDatabase driverGenerate automaticallyOptionsPermanent (keep it in configuration)Test connectionCreate new database fileFileName (on the list)Generate name basing on file path<p>Enable this if you want the database to be stored in configuration file and restored every time SQLiteStudio is started.</p>aasfdBrowse for existing database file on local computerBrowseEnter an unique database name.This name is already in use. Please enter unique name.Enter a database file path.This database is already on the list under name: %1Select a database type.Auto-generatedType the nameDbObjectDialogsDelete tableAre you sure you want to delete table %1?Delete indexAre you sure you want to delete index %1?Delete triggerAre you sure you want to delete trigger %1?Delete viewAre you sure you want to delete view %1?Error while dropping %1: %2DbTreeDatabasesFilter by nameCopyPasteSelect allCreate a groupDelete the groupRename the groupAdd a databaseEdit the databaseRemove the databaseConnect to the databaseDisconnect from the databaseImportExport the databaseConvert database typeVacuumIntegrity checkCreate a tableEdit the tableDelete the tableExport the tableImport into the tablePopulate tableCreate similar tableReset autoincrement sequenceCreate an indexEdit the indexDelete the indexCreate a triggerEdit the triggerDelete the triggerCreate a viewEdit the viewDelete the viewAdd a columnEdit the columnDelete the columnDelete selected itemsClear filterRefresh all database schemasRefresh selected database schemaErase table dataDatabaseGroupingCreate groupGroup nameEntry with name %1 already exists in group %2.Delete groupAre you sure you want to delete group %1?
All objects from this group will be moved to parent group.Delete databaseAre you sure you want to delete database '%1'?Cannot import, because no import plugin is loaded.Cannot export, because no export plugin is loaded.Error while executing VACUUM on the database %1: %2VACUUM execution finished successfully.Integrity check (%1)Reset autoincrementAre you sure you want to reset autoincrement value for table '%1'?An error occurred while trying to reset autoincrement value for table '%1': %2Autoincrement value for table '%1' has been reset successfly.Are you sure you want to delete all data from table '%1'?An error occurred while trying to delete data from table '%1': %2All data has been deleted for table '%1'.Following objects will be deleted: %1.Following databases will be removed from list: %1.Remainig objects from deleted group will be moved in place where the group used to be.%1<br><br>Are you sure you want to continue?Delete objectsDbTreeItemDelegateerrordbtree labels(system table)database tree label(virtual)virtual table label(system index)database tree labelDbTreeModelDatabase: %1dbtree tooltipVersion:dbtree tooltipFile size:dbtree tooltipEncoding:dbtree tooltipError:dbtree tooltipTable : %1dbtree tooltipColumns (%1):dbtree tooltipIndexes (%1):dbtree tooltipTriggers (%1):dbtree tooltipCopyMoveInclude dataInclude indexesInclude triggersAbortReferenced tablesDo you want to include following referenced tables as well:
%1Name conflictFollowing object already exists in the target database.
Please enter new, unique name, or press '%1' to abort the operation:SQL statements conversionFollowing error occurred while converting SQL statements to the target SQLite version:Would you like to ignore those errors and proceed?DdlHistoryWindowFilter by database:-- Queries executed on database %1 (%2)
-- Date and time of execution: %3
%4DDL historyDdlPreviewDialogQueries to be executedDon't show againDebugConsoleSQLiteStudio Debug ConsoleEditorWindowQueryHistoryResults in the separate tabResults below the querySQL editor %1ResultsExecute queryExplain queryClear execution historysql editorExport resultssql editorCreate view from querysql editorPrevious databaseNext databaseShow next tabsql editorShow previous tabsql editorFocus results belowsql editorFocus SQL editor abovesql editorActive database (%1/%2)Query finished in %1 second(s). Rows affected: %2Query finished in %1 second(s).Clear execution historyAre you sure you want to erase the entire SQL execution history? This cannot be undone.Cannot export, because no export plugin is loaded.No database selected in the SQL editor. Cannot create a view for unknown database.Editor window "%1" has uncommited data.ErrorsConfirmDialogErrorsFollowing errors occured:Would you like to proceed?ExportDialogExportWhat do you want to export?A databaseA single tableQuery resultsTable to exportDatabaseTableOptionsWhen this option is unchecked, then only table DDL (CREATE TABLE statement) is exported.Export table dataExport table indexesExport table triggersNote, that exporting table indexes and triggers may be unsupported by some output formats.Select database objects to exportExport data from tablesSelect allDeselect allDatabase:Query to export results forQuery to be executed for results:Export format and optionsExport formatOutputExported file pathClipboardFileExported text encoding:Export format optionsCancelSelect database to export.Select table to export.Enter valid query to export.Select at least one object to export.You must provide a file name to export to.Path you provided is an existing directory. You cannot overwrite it.The directory '%1' does not exist.The file '%1' exists and will be overwritten.All files (*)Pick file to export toInternal error during export. This is a bug. Please report it.FontEditChoose fontfont configurationFormActive SQL formatter pluginFormViewCommit rowform viewRollback rowform viewFirst rowform viewPrevious rowform viewNext rowform viewLast rowform viewInsert new rowform viewDelete current rowform viewFunctionsEditorFilter funtionsFunction name:Implementation language:Type:Input argumentsUndefinedDatabasesRegister in all databasesRegister in following databases:Initialization code:Function implementation code:Final step implementation code:SQL function editorCommit all function changesRollback all function changesCreate new functionDelete selected functionCustom SQL functions manualAdd function argumentRename function argumentDelete function argumentMove function argument upMove function argument downScalarAggregateEnter a non-empty, unique name of the function.Pick the implementation language.Per step code:Enter a non-empty implementation code.argumentnew function argument name in function editor windowFunctions editor window has uncommited modifications.ImportDialogImport dataTable to import toTableDatabaseData source to import fromData source typeOptionsInput file:Text encoding:<p>If enabled, any constraint violation, or invalid data format (wrong column count), or any other problem encountered during import will be ignored and the importing will be continued.</p>Ignore errorsData source optionsCancelIf you type table name that doesn't exist, it will be created.Enter the table nameSelect import plugin.You must provide a file to import from.The file '%1' does not exist.Path you provided is a directory. A regular file is required.Pick file to import fromIndexDialogIndexOn table:Index name:Partial index conditionUnique indexColumnCollationSortDDLTried to open index dialog for closed or inexisting database.Could not process index %1 correctly. Unable to open an index dialog.Pick the table for the index.Select at least one column.Enter a valid condition.defaultindex dialogSort ordertable constraintsErrorindex dialogCannot create unique index, because values in selected columns are not unique. Would you like to execute SELECT query to see problematic values?An error occurred while executing SQL statements:
%1LanguageDialogLanguagePlease choose language:MainWindowDatabase toolbarStructure toolbarToolsWindow listView toolbarConfiguration widgetsSyntax highlighting enginesData editorsRunning in debug mode. Press %1 or use 'Help / Open debug console' menu entry to open the debug console.Running in debug mode. Debug messages are printed to the standard output.You need to restart application to make the language change take effect.Open SQL editorOpen DDL historyOpen SQL functions editorOpen collations editorImportExportOpen configuration dialogTile windowsTile windows horizontallyTile windows verticallyCascade windowsNext windowPrevious windowHide status fieldClose selected windowClose all windows but selectedClose all windowsRestore recently closed windowRename selected windowOpen Debug ConsoleOpen CSS ConsoleReport a bugPropose a new featureAboutLicensesOpen home pageOpen forum pageUser ManualSQLite documentationReport historyCheck for updatesDatabasemenubarStructuremenubarViewmenubarWindow listmenubar view menuToolsmenubarHelpCould not set style: %1main windowCannot export, because no export plugin is loaded.Cannot import, because no import plugin is loaded.Rename windowEnter new name for the window:New updates are available. <a href="%1">Click here for details</a>.You're running the most recent version. No updates are available.Database passed in command line parameters (%1) was already on the list under name: %2Database passed in command line parameters (%1) has been temporarily added to the list under name: %2Could not add database %1 to list.MdiWindowUncommited changesClose anywayDon't closeMultiEditorNull valuemultieditorConfigure editors for this data typeData editor plugin '%1' not loaded, while it is defined for editing '%1' data type.DeletedmultieditorRead onlymultieditorMultiEditorBoolBooleanMultiEditorDateDateMultiEditorDateTimeDate & timeMultiEditorHexHexMultiEditorNumericNumbernumeric multi editor tab nameMultiEditorTextTextTab changes focusCutCopyPasteDeleteUndoRedoMultiEditorTimeTimeNewConstraintDialogNew constraintPrimary Keynew constraint dialogForeign Keynew constraint dialogUniquenew constraint dialogChecknew constraint dialogNot NULLnew constraint dialogCollatenew constraint dialogDefaultnew constraint dialogNewVersionDialogSQLiteStudio updatesNew updates are available!ComponentCurrent versionUpdate versionCheck for updates on startupUpdate to new version!The update will be automatically downloaded and installed. This will also restart application at the end.Not now.Don't install the update and close this window.PopulateConfigDialogPopulating configurationConfiguring <b>%1</b> for column <b>%2</b>PopulateDialogPopulate tableDatabaseTableColumnsNumber of rows to populate:Populatepopulate dialog buttonAbortConfigurePopulating configuration for this column is invalid or incomplete.Select database with table to populateSelect table to populateYou have to select at least one column.QObjectCannot edit columns that are result of compound %1 statements (one that includes %2, %3 or %4 keywords).The query execution mechanism had problems with extracting ROWID's properly. This might be a bug in the application. You may want to report this.Requested column is a result of SQL expression, instead of a simple column selection. Such columns cannot be edited.Requested column belongs to restricted SQLite table. Those tables cannot be edited directly.Cannot edit results of query other than %1.Cannot edit columns that are result of aggregated %1 statements.Cannot edit columns that are result of %1 statement.Cannot edit columns that are result of common table expression statement (%1).on conflict: %1data view tooltipreferences table %1, column %2data view tooltipcondition: %1data view tooltipcollation name: %1data view tooltipData grid viewCopy cell(s) contents to clipboardPaste cell(s) contents from clipboardSet empty value to selected cell(s)Set NULL value to selected cell(s)Commit changes to cell(s) contentsRollback changes to cell(s) contentsDelete selected data rowInsert new data rowOpen contents of selected cell in a separate editorTotal pages available: %1Total rows loaded: %1Data view (both grid and form)Refresh dataSwitch to grid view of the dataSwitch to form view of the dataDatabase listDelete selected itemClear filter contentsRefresh schemaRefresh all schemasAdd databaseSelect all itemsCopy selected item(s)Paste from clipboardTablesIndexesTriggersViewsColumnsData form viewCommit changes for current rowRollback changes for current rowGo to first row on current pageGo to next rowGo to previous rowGo to last row on current pageInsert new rowDelete current rowMain windowOpen SQL editorPrevious windowNext windowHide status areaOpen configuration dialogOpen Debug ConsoleOpen CSS ConsoleCell text value editorCut selected textCopy selected textDelete selected textUndoRedoSQL editor input fieldSelect whole editor contentsSave contents into a fileLoad contents from a fileFind in textFind nextFind previousReplace in textDelete current lineRequest code assistantFormat contentsMove selected block of text one line downMove selected block of text one line upCopy selected block of text and paste it a line belowCopy selected block of text and paste it a line aboveAll SQLite databasesAll filesDatabase fileReports history windowDelete selected entrySQL editor windowExecute queryExecute "%1" querySwitch current working database to previous on the listSwitch current working database to next on the listGo to next editor tabGo to previous editor tabMove keyboard input focus to the results view belowMove keyboard input focus to the SQL editor aboveTable windowRefresh table structureAdd new columnEdit selected columnDelete selected columnExport table dataImport data to the tableAdd new table constraintEdit selected table constraintDelete selected table constraintRefresh table index listAdd new indexEdit selected indexDelete selected indexRefresh table trigger listAdd new triggerEdit selected triggerDelete selected triggerGo to next tabGo to previous tabA view windowRefresh view trigger listQuitConfirmDialogUncommited changesAre you sure you want to quit the application?
Following items are pending:SearchTextDialogFind or replaceFind:Case sensitiveSearch backwardsRegular expression matchingReplace &&
find nextReplace with:Replace allFindSortDialogSort by columnsColumnOrderSort by: %1Move column upMove column downSqlEditorCutsql editorCopysql editorPastesql editorDeletesql editorSelect allsql editorUndosql editorRedosql editorCompletesql editorFormat SQLsql editorSave SQL to filesql editorSelect file to save SQLsql editorLoad SQL from filesql editorDelete linesql editorMove block downsql editorMove block upsql editorCopy block downsql editorCopy up downsql editorFindsql editorFind nextsql editorFind previoussql editorReplacesql editorSaved SQL contents to file: %1Syntax completion can be used only when a valid database is set for the SQL editor.Contents of the SQL editor are huge, so errors detecting and existing objects highlighting are temporarily disabled.Save to fileCould not open file '%1' for writing: %2SQL scripts (*.sql);;All files (*)Open fileCould not open file '%1' for reading: %2Reached the end of document. Hit the find again to restart the search.SqlQueryItemColumn:data view tooltipData type:data viewTable:data view tooltipConstraints:data view tooltipThis cell is not editable, because: %1Cannot load the data for a cell that refers to the already closed database.SqlQueryItemDelegateCannot edit this cell. Details: %2The row is marked for deletion.SqlQueryModelOnly one query can be executed simultaneously.Uncommited dataThere are uncommited data changes. Do you want to proceed anyway? All uncommited changes will be lost.Cannot commit the data for a cell that refers to the already closed database.Could not begin transaction on the database. Details: %1An error occurred while commiting the transaction: %1An error occurred while rolling back the transaction: %1Tried to commit a cell which is not editable (yet modified and waiting for commit)! This is a bug. Please report it.An error occurred while commiting the data: %1Error while executing SQL query on database '%1': %2Error while loading query results: %1Insert multiple rowsNumber of rows to insert:SqlQueryViewCopyCopy as...PastePaste as...Set NULL valuesErase valuesEdit value in editorCommitRollbackCommit selected cellsRollback selected cellsDefine columns to sort byRemove custom sortingInsert rowInsert multiple rowsDelete selected rowNo items selected to paste clipboard contents to.Edit valueSqlTableModelError while commiting new row: %1Error while deleting row from table %1: %2StatusFieldStatusCopyClearTableConstraintsModelTypetable constraintsDetailstable constraintsNametable constraintsTableForeignKeyPanelForeign table:SQLite 2 does not support foreign keys officially,
but it's okay to use them anyway.ColumnsLocal columnForeign columnReactionsDeferred foreign keyNamed constraintConstraint namePick the foreign column.Pick the foreign table.Select at least one foreign column.Enter a name of the constraint.Foreign columntable constraintsTablePrimaryKeyAndUniquePanelColumnsColumnCollationSortValid only for a single column with INTEGER data typeAutoincrementNamed constraintConstraint nameOn conflictCollatetable constraintsSort ordertable constraintsSelect at least one column.Enter a name of the constraint.TableStructureModelNametable structure columnsData typetable structure columnsDefault valuetable structure columnsTableWindowStructureTable name:DataConstraintsIndexesTriggersDDLExport tabletable windowImport data to tabletable windowPopulate tabletable windowRefresh structuretable windowCommit structure changestable windowRollback structure changestable windowAdd columntable windowEdit columntable windowDelete columntable windowMove column uptable windowMove column downtable windowCreate similar tabletable windowReset autoincrement valuetable windowAdd table constrainttable windowEdit table constrainttable windowDelete table constrainttable windowMove table constraint uptable windowMove table constraint downtable windowAdd table primary keytable windowAdd table foreign keytable windowAdd table unique constrainttable windowAdd table check constrainttable windowRefresh index listtable windowCreate indextable windowEdit indextable windowDelete indextable windowRefresh trigger listtable windowCreate triggertable windowEdit triggertable windowDelete triggertable windowAre you sure you want to delete column '%1'?table windowFollowing problems will take place while modifying the table.
Would you like to proceed?table windowTable modificationtable windowCould not load data for table %1. Error details: %2Could not process the %1 table correctly. Unable to open a table window.Could not restore window %1, because no database or table was stored in session for this window.Could not restore window '%1', because no database or table was stored in session for this window.Could not restore window '%1', because database %2 could not be resolved.Could not restore window '%1'', because the table %2 doesn't exist in the database %3.New table %1Could not commit table structure. Error message: %1table windowReset autoincrementAre you sure you want to reset autoincrement value for table '%1'?An error occurred while trying to reset autoincrement value for table '%1': %2Autoincrement value for table '%1' has been reset successfly.Empty nameA blank name for the table is allowed in SQLite, but it is not recommended.
Are you sure you want to create a table with blank name?Cannot create a table without at least one column.Cannot create table %1, if it has no primary key defined. Either uncheck the %2, or define a primary key.Cannot use autoincrement for primary key when %1 clause is used. Either uncheck the %2, or the autoincrement in a primary key.Are you sure you want to delete table constraint '%1'?table windowDelete constrainttable windowCannot export, because no export plugin is loaded.Cannot import, because no import plugin is loaded.Uncommited changesThere are uncommited structure modifications. You cannot browse or edit data until you have table structure settled.
Do you want to commit the structure, or do you want to go back to the structure tab?Go back to structure tabCommit modifications and browse data.Nametable window indexesUniquetable window indexesColumnstable window indexesPartial index conditiontable window indexesNametable window triggersEventtable window triggersConditiontable window triggersDetailstable window triggersTable window "%1" has uncommited structure modifications and data.Table window "%1" has uncommited data.Table window "%1" has uncommited structure modifications.TriggerColumnsDialogTrigger columnsTriggering columns:TriggerDialogTriggerOn table:Action:<p>SQL condition that will be evaluated before the actual trigger code. In case the condition returns false, the trigger will not be fired for that row.</p>Pre-condition:The scope is still not fully supported by the SQLite database.Trigger name:When:List of columns for UPDATE OF action.Scope:Code:Trigger statements to be executed.DDLOn view:Could not process trigger %1 correctly. Unable to open a trigger dialog.Enter a valid condition.Enter a valid trigger code.Errortrigger dialogAn error occurred while executing SQL statements:
%1VersionConvertSummaryDialogDatabase version convertFollowing changes to the SQL statements will be made:BeforeAfterViewWindowQueryView name:DataTriggersDDLCould not restore window '%1', because no database or view was stored in session for this window.Could not restore window '%1', because database %2 could not be resolved.Could not restore window '%1', because database %2 could not be open.Could not restore window '%1', because the view %2 doesn't exist in the database %3.New view %1Refresh the viewview windowCommit the view changesview windowRollback the view changesview windowRefresh trigger listview windowCreate new triggerview windowEdit selected triggerview windowDelete selected triggerview windowView window "%1" has uncommited structure modifications and data.View window "%1" has uncommited data.View window "%1" has uncommited structure modifications.Could not load data for view %1. Error details: %2Uncommited changesThere are uncommited structure modifications. You cannot browse or edit data until you have the view structure settled.
Do you want to commit the structure, or do you want to go back to the structure tab?Go back to structure tabCommit modifications and browse data.Could not commit view changes. Error message: %1view windowNameview window triggersInstead ofview window triggersConditionview window triggersDetailstable window triggersCould not process the %1 view correctly. Unable to open a view window.Empty nameA blank name for the view is allowed in SQLite, but it is not recommended.
Are you sure you want to create a view with blank name?The SELECT statement could not be parsed. Please correct the query and retry.
Details: %1The view could not be modified due to internal SQLiteStudio error. Please report this!The view code could not be parsed properly for execution. This is a SQLiteStudio's bug. Please report it.Following problems will take place while modifying the view.
Would you like to proceed?view windowView modificationview windowWidgetCoverInterrupt