AboutDialog About SQLiteStudio and licenses About <html><head/><body>SQLiteStudio v%1Free, open-source, cross-platform SQLite database manager. <a href="https://sqlitestudio.pl">https://sqlitestudio.pl</a> %2 Author and active maintainer: SalSoft (<a href="https://salsoft.com.pl">https://salsoft.com.pl</a>) </body></html> Licenses Environment Icon directories Form directories SQLite extension directories Plugin directories Configuration directory Application directory Qt version: SQLite 3 version: Portable distribution. MacOS X application bundle distribution. Operating system managed distribution. <h3>Table of contents:</h3><ol>%2</ol> BindParamsDialog Query parameters Please provide values for query parameters CodeSnippetEditor Filter snippets <html><head/><body>Optional shortcut, that will work only in context of the active code assistant window. It allows user to use key combinations, that would otherwise be conflicting with other shortcuts. Having the code assistant window as required context makes the choice of keys more versatile.</body></html> <html><head/><body>The name of the snippet will be displayed in the code assistant. To access the list of snippets user has to hit the code assistant shortcut twice.</body></html> Snippet name Code assistant shortcut Snippet code Code Snippets editor window has uncommitted modifications. Code Snippets editor Commit all snippet changes Rollback all snippet changes Create new snippet Delete selected snippet Move the snippet up Move the snippet down Code snippets manual Enter a non-empty, unique name of the snippet. Enter a non-empty snippet content. This hotkey is not unique in context of a code assistant. CollationsEditor Filter collations Databases Register in all databases Register in following databases: Implementation code: Collation name: Implementation language: Collations editor Commit all collation changes Rollback all collation changes Create new collation Delete selected collation Editing collations manual Enter a non-empty, unique name of the collation. Pick the implementation language. Enter a non-empty implementation code. Collations editor window has uncommitted modifications. ColorButton Pick a color ColumnCollatePanel Collation name: Named constraint: Enter a name of the constraint. Enter a collation name. ColumnDefaultPanel Default value: Named constraint: Enter a default value expression. Invalid default value expression: %1. If you want to use simple string as value, remember to surround it with quote characters. Invalid default value expression. If you want to use simple string as value, remember to surround it with quote characters. Enter a name of the constraint. ColumnDialog Column Name and type Scale Precision Data type: Column name: Size: Constraints Generated value Unique Configure Foreign Key Collate Not NULL Check condition Primary Key Default Advanced mode Add constraint column dialog Edit constraint column dialog Delete constraint column dialog Move constraint up column dialog Move constraint down column dialog Add a primary key column dialog Add a foreign key column dialog Add an unique constraint column dialog Add a check constraint column dialog Add a not null constraint column dialog Add a collate constraint column dialog Add a generated value constraint column dialog Add a default constraint column dialog Are you sure you want to delete constraint '%1'? column dialog Correct the constraint's configuration. Scale is not allowed for INTEGER PRIMARY KEY columns. Precision cannot be defined without the scale. Cannot use type other than INTEGER if AUTOINCREMENT is enabled in PRIMARY KEY. INTEGER type was enforced due to enabled AUTOINCREMENT in PRIMARY KEY. Precision is not allowed for INTEGER PRIMARY KEY columns. Could not match valid STRICT table datatype from declared type: %1. ColumnDialogConstraintsModel Type column dialog constraints Name column dialog constraints Details column dialog constraints ColumnForeignKeyPanel Foreign table: Foreign column: Reactions Deferred foreign key Named constraint Constraint name Pick the foreign table. Pick the foreign column. Enter a name of the constraint. ColumnGeneratedPanel Generating code: Explicit type: Use "GENERATED ALWAYS" keywords Named constraint: Enter the column value generating expression. Invalid value generating expression: %1. Invalid value generating expression. Enter a name of the constraint. ColumnPrimaryKeyPanel Autoincrement Sort order: Named constraint: On conflict: Enter a name of the constraint. Descending order is not allowed with AUTOINCREMENT. ColumnUniqueAndNotNullPanel Named constraint: On conflict: Enter a name of the constraint. CompleterWindow Column: %1 completer statusbar Table: %1 completer statusbar Index: %1 completer statusbar Trigger: %1 completer statusbar View: %1 completer statusbar Database: %1 completer statusbar Keyword: %1 completer statusbar Function: %1 completer statusbar Operator: %1 completer statusbar String completer statusbar Number completer statusbar Binary data completer statusbar Collation: %1 completer statusbar Pragma function: %1 completer statusbar Insert a code snippet ConfigDialog Configuration Search General Keyboard shortcuts Look & feel Style Fonts Code colors Database list Code assistant Data browsing Data editors Plugins Code formatters If switched off, then columns will be sorted in the order they are typed in CREATE TABLE statement. Sort table columns alphabetically Expand tables node when connected to a database 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. Display additional labels on the list For regular tables labels will show number of columns, indexes and triggers for each of tables. Display labels for regular tables Virtual tables will be marked with a 'virtual' label. Display labels for virtual tables Expand views node when connected to a database If 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) alphabetically Display system tables and indexes on the list Database dialog window When adding new database it is marked to be "permanent" (stored in configuration) by default. Checking this option makes every new database to NOT be "permanent" by default. Do not mark database to be "permanent" by default When this option is enabled, then files dropped from file manager onto database list will be automatically added to the list, bypassing standard database dialog. If for various reasons automatic process fails, then standard dialog will be presented to the user. Try to bypass dialog completly when dropping database file onto the list Data browsing and editing Maximum number of configurations of Populate Table dialog stored in configuration. Value of 100 should be sufficient. Number of memorized table populating configurations Data column width <html><head/><body>When user enters new value into column and the value is bigger than the current column width, the application will enlarge the column to fit the new value, but not wider than the limit defined in the option above.</body></html> Enlarge column when entering value longer than current width 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. Number of data rows per page: When this is enabled and user holds mouse pointer over a cell in any data view (query results, a table data, a view data) a tooltip will appear with details about the cell - it includes details like column data type, constraints, ROWID and others. Show column and row details tooltip in data view When editing a cell which used to have NULL value and entering empty string as new value, then this option determinates whether the new value should remain NULL (have this option enabled), or should it be overwritten with empty string value (have this option disabled). Keep NULL value when entering empty value <html><head/><body>Enable this to always enforce DEFAULT value when committing a NULL value for a column that has DEFAULT value defined, even though the column is allowed to contain NULL values.Disable this option to use DEFAULT value exclusively when NULL value is committed for column with NOT NULL constraint.</body></html> Use DEFAULT value (if defined), when committing NULL value <html><head/><body>If query results contain dozens (or hundreds) of columns, it is more likely that it will exhaust free memory of your computer by loading several gigabytes of data at once. SQLiteStudio may try to limit number of results displayed on one page in such cases to protect your computer. If you know that you don't work with big values in database, you can disable this limit and you will always see as many rows as defined per page.</body></html> Limit number of rows for in case of dozens of columns Inserting new row in data grid Before currently selected row After currently selected row At the end of data view Table windows When enabled, Table Windows will show up with the data tab, instead of the structure tab. Open Table Windows with the data tab for start When enabled the "Data" tab will be placed as first tab in every Table Window, instead of being at second place. Place data tab as first tab in a Table Window View windows When enabled, View Windows will show up with the data tab, instead of the structure tab. Open View Windows with the data tab for start When enabled the "Data" tab will be placed as first tab in every View Window, instead of being at second place. Place data tab as first tab in a View Window Data types Available editors: Editors selected for this data type: Schema editing Number of DDL changes kept in history. DDL history size: Don't show DDL preview dialog when committing schema changes SQL queries Number of queries kept in the history. <html><head/><body>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. You can also use dedicated shortcuts for executing in one mode or the other (currently configured to %1 for single query execution and %2 for all queries execution).</body></html> History size: Maximum number of query parameters (:param, @param, $param, ?) stored in history. When you re-use parameter with the same name/position, SQLiteStudio will pre-initialize it with most recent memorized value (you will still be able to change it). Value of 1000 should be sufficient. Execute only the query under the cursor Number of memorized query parameters <html><head/><body>By default (when this option is disabled) a real number is displayed in the format of decimals with decimal point. In some cases, when the number is really small (several places after decimal point), the default representation may appear inaccurate. In such case you may want to enable this option to use the scientific notation (i.e. 5.3e-21).</body></html> Use scientific notation for real numbers in the grid view <html><head/><body>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. This value is also used when enlarging column upon new, longer value entered by the user (see option below).</body></html> Limit automatic data column width to (in pixels): <html><head/><body>Initial width of data columns will be set to at least show complete name of the column in the header. This can still be overwritten by the initial limit of column width specified in pixels (the setting above).</body></html> Keep at least the width to show complete column name <html><head/><body>If enabled, lines longer than the editor width will be wrapped, so horizontal scrolling will not be needed.</body></html> Wrap lines in SQL editor <html><head/><body>Highlights entire query that is currently under the insertion cursor. It's the same query that will be executed when you hit "Execute query" hotkey or button (unless configured otherwise).</body></html> Highlight current query Updates Automatically check for updates at startup Session Restore last session (active MDI windows) after startup Allow multiple instances of the application at the same time Status Field When user manually closes the Status panel, this option makes sure that if any new message is printed in the Status panel it will be reopened. If it's disabled, then Status panel can only be open manually by the user from the "View" menu. Always open Status panel when new message is printed Code syntax colors Keyword foreground Regular foreground String foreground Comment foreground Valid objects foreground Current query background Bind parameter foreground Current line background Matched parenthesis background <html><head/><body>You can disable current query highlighting entirely on the General settings page.</body></html> Number foreground BLOB value foreground Matched parenthesis foreground Reset to defaults Filter shortcuts by name or key combination Action Key combination Language Changing language requires application restart to take effect. Compact layout 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. Use compact layout Main window dock areas Left and right areas occupy corners Top and bottom areas occupy corners Hide built-in plugins Current style: Preview Enabled Disabled Active formatter plugin SQL editor font Database list font Database list additional label font Data view font Status field font Code assistant settings <html><head/><body>If this option is enabled, the code assistant will be triggered in cases, when user types for example tableName. to propose columns of the table. If the option is disabled, user will have to hit the assistant hotkey explicitly.</body></html> Automatically trigger the assistant after a dot is typed after an object name Description: plugin details Category: plugin details Version: plugin details Author: plugin details Internal name: plugin details Dependencies: plugin details Conflicts: plugin details Plugin details Plugins 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 dialog Details No plugins in this category. Add new data type Rename selected data type Delete selected data type Help for configuring data type editors Clear hotkey for this action Restore original hotkey for this action Here you can configure colors for code syntax highlighting. They are shared across different languages - not only for SQL, but also JavaScript and others. By default a theme-based color is used. To define your own color, enable a custom color by selecting a checkbox next to a particular color. ConstraintCheckPanel The condition Named constraint: On conflict Enter a valid condition. Enter a name of the constraint. ConstraintDialog New constraint constraint dialog Create constraint dialog Edit constraint dialog window Apply constraint dialog Primary key table constraints Foreign key table constraints Unique table constraints Not NULL table constraints Check table constraints Generated table constraints Collate table constraints Default table constraints ConstraintTabModel Table table constraints Column (%1) table constraints Scope table constraints Type table constraints Details table constraints Name table constraints CssDebugDialog SQLiteStudio CSS console DataView Filter data data view Grid view Form view Refresh table data data view First page data view Previous page data view Next page data view Last page data view Commit changes for selected cells data view Rollback changes for selected cells data view Show grid view of results data view Show form view of results data view Filter by text (if contains) data view Filter strictly by text (if equals) data view Tabs on top data view Tabs at bottom data view Place new rows above selected row data view Place new rows below selected row data view Place new rows at the end of the data view data view Total number of rows is being counted. Browsing other pages will be possible after the row counting is done. Row: %1 Filter Hit Enter key or press "Apply filter" button on toolbar to apply new value. Filter by the Regular Expression data view Filter by SQL expression data view Show filter inputs per column data view Apply filter data view DbDialog Database Database type Database driver File Name (on the list) Options Enable this if you want the database to be stored in configuration file and restored every time SQLiteStudio is started. aasfd Permanent (keep it in configuration) Test connection Select new or existing file on local computer Browse Database type not selected. Database path not specified. Enter an unique database name. This name is already in use. Please enter unique name. Automatic name generation was disabled, because the name was edited manually. To restore automatic generation please erase contents of the name field. Enter a database file path. This database is already on the list under name: %1 Select a database type. DbObjectDialogs Delete table Are you sure you want to delete table %1? Delete index Are you sure you want to delete index %1? Delete trigger Are you sure you want to delete trigger %1? Delete view Are you sure you want to delete view %1? Error while dropping %1: %2 Delete objects Are you sure you want to delete following objects: %1 Cannot start transaction. Details: %1 Cannot commit transaction. Details: %1 DbTree Databases Filter by name Copy Paste Select all Create a group Delete the group Rename the group &Add a database &Edit the database &Remove the database &Connect to the database &Disconnect from the database Import &Export the database Vac&uum &Integrity check Create a &table Edit the t&able Delete the ta&ble Export the table Import into the table Populate table Create similar table Reset autoincrement sequence Create an &index Edit the i&ndex Delete the in&dex Create a trig&ger Edit the trigg&er Delete the trigge&r Create a &view Edit the v&iew Delete the vi&ew Add a column Edit the column Delete the column Delete selected items Clear filter &Refresh all database schemas Re&fresh selected database schema Erase table data Open file's directory Execute SQL from file Increase font size database list Decrease font size database list Database Grouping Generate query for table Create group Group name Entry with name %1 already exists in group %2. Delete group Are you sure you want to delete group %1? All objects from this group will be moved to parent group. Are you sure you want to remove database '%1' from the list? Are you sure you want to remove following databases from the list: %1 Remove database Cannot import, because no import plugin is loaded. Cannot export, because no export plugin is loaded. Vacuum (%1) Integrity check (%1) Reset autoincrement Are you sure you want to reset autoincrement value for table '%1'? An error occurred while trying to reset autoincrement value for table '%1': %2 Autoincrement value for table '%1' has been reset successfully. Are you sure you want to delete all data from table(s): %1? An error occurred while trying to delete data from table '%1': %2 All 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 Are you sure you want to continue? Delete objects DbTreeItemDelegate error dbtree labels (system table) database tree label (virtual) virtual table label (system index) database tree label DbTreeModel Database: %1 dbtree tooltip URI: dbtree tooltip Version: dbtree tooltip File size: dbtree tooltip Encoding: dbtree tooltip Error: dbtree tooltip Table : %1 dbtree tooltip Columns (%1): dbtree tooltip Indexes (%1): dbtree tooltip Triggers (%1): dbtree tooltip Copy Move Include data Include indexes Include triggers Abort Could not add dropped database file '%1' automatically. Manual setup is necessary. Referenced tables Do you want to include following referenced tables as well: %1 Name conflict Following object already exists in the target database. Please enter new, unique name, or press '%1' to abort the operation: SQL statements conversion Following error occurred while converting SQL statements to the target SQLite version: Would you like to ignore those errors and proceed? DdlHistoryWindow Filter by database: Clear entire history -- Queries executed on database %1 (%2) -- Date and time of execution: %3 %4 Clear history Are you sure you want to erase entire DDL history? DDL history DdlPreviewDialog Queries to be executed Don't show again DebugConsole SQLiteStudio Debug Console EditorWindow SQL editor Query History Results in the separate tab Results below the query SQL editor %1 Results Execute query Explain query Clear execution history sql editor Export results sql editor Create view from query sql editor Previous database Next database Show next tab sql editor Show previous tab sql editor Focus results below sql editor Focus SQL editor above sql editor Delete selected SQL history entries sql editor Execute single query under cursor Execute all queries in editor Active database (%1/%2) Query finished in %1 second(s). Rows affected: %2 Query finished in %1 second(s). Clear execution history Are 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 uncommitted data. ErrorsConfirmDialog Errors Following errors occured: Would you like to proceed? ExecFromFileDialog Execute SQL from file Input file Path to file Browse for file Options File encoding Skip failing SQL statements SQL scripts (*.sql);;All files (*) Execute SQL file Please provide file to be executed. Provided file does not exist or cannot be read. ExportDialog Export What do you want to export? A database A single table Query results Table to export Database Table Options When this option is unchecked, then only table DDL (CREATE TABLE statement) is exported. Export table data Export table indexes Export table triggers Note, that exporting table indexes and triggers may be unsupported by some output formats. Select database objects to export Export data from tables Select all Deselect all Database: Query to export results for Query to be executed for results: Export format and options Export format Output Exported file path Clipboard File Exported text encoding: Export format options Cancel Select 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 to Internal error during export. This is a bug. Please report it. FileExecErrorsDialog Execution errors Following errors were encountered during execution of SQL statements from the file: SQL Error Statements that were executed successfully were commited. Statements that were executed successfully were rolled back. FkComboBox Cannot edit this cell. Details: %1 FontEdit Choose font font configuration Form Active SQL formatter plugin FormView Commit row form view Rollback row form view First row form view Previous row form view Next row form view Last row form view Insert new row form view Delete current row form view FunctionsEditor Filter functions Input arguments Undefined Databases Register in all databases Register in following databases: Type: Function name: Implementation language: Deterministic Initialization code: Function implementation code: Final step implementation code: SQL functions editor Commit all function changes Rollback all function changes Create new function Delete selected function Custom SQL functions manual Add function argument Rename function argument Delete function argument Move function argument up Move function argument down Scalar Aggregate Enter a non-empty, unique name of the function. Pick the implementation language. Per step code: Enter a non-empty implementation code. argument new function argument name in function editor window Functions editor window has uncommitted modifications. ImportDialog Import data Table to import to Table Database Data source to import from Data source type Options Text encoding: Input file: 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. Ignore errors Data source options Cancel If you type table name that doesn't exist, it will be created. Enter the table name Select 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 from IndexDialog Index Column Sort Collation On table: Delete selected indexed expression Moves selected index column up in the order, making it more significant in the index. Moves selected index column down in the order, making it less significant in the index. Partial index condition Unique index Index name: Edit selected indexed expression Add indexed expression DDL Tried to open index dialog for closed or inexisting database. Could not process index %1 correctly. Unable to open an index dialog. Unique index cannot have indexed expressions. Either remove expressions from list below, or uncheck this option. Pick the table for the index. Select at least one column. Enter a valid condition. default index dialog Sort order table constraints Error index dialog Cannot 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: %1 IndexExprColumnDialog Indexed expression Expression to index This expression is already indexed by the index. Column should be indexed directly, not by expression. Either extend this expression to contain something more than just column name, or abort and select this column in index dialog directly. Column '%1' does not belong to the table covered by this index. Indexed expressions can refer only to columns from the indexed table. It's forbidden to use 'SELECT' statements in indexed expressions. Enter an indexed expression. Invalid expression. LanguageDialog Language Please choose language: MainWindow Database toolbar Structure toolbar Tools Window list View toolbar Configuration widgets Syntax highlighting engines Data editors Running 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 &editor Open DDL &history Open SQL &functions editor Open code &snippets editor Open &collations editor Open ex&tension manager &Import E&xport Open confi&guration dialog &Tile windows Tile windows &horizontally Tile windows &vertically &Cascade windows Next window Previous window Hide status field Close &all windows Re&store recently closed window Close current &window Close &other windows Close windows on the &left Close windows on the &right Re&name selected window Open Debug Console Open CSS Console Report a &bug D&onate Propose a new &feature &About &Licenses Open home &page User &Manual SQLite &documentation Bugs and feature &requests Quit Check for &updates &Database menubar &Structure menubar &View menubar Window list menubar view menu &Tools menubar &Help Could not set style: %1 main window Cannot export, because no export plugin is loaded. Cannot import, because no import plugin is loaded. Rename window Enter 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: %2 Database passed in command line parameters (%1) has been temporarily added to the list under name: %2 Could not add database %1 to list. MdiWindow Uncommitted changes Close anyway Don't close MultiEditor Null value multieditor Configure editors for this data type Open another tab Foreign Key Data editor plugin '%1' not loaded, while it is defined for editing '%2' data type. Deleted multieditor Read only multieditor MultiEditorBoolPlugin Boolean MultiEditorDatePlugin Date MultiEditorDateTimePlugin Date & time MultiEditorHexPlugin Hex MultiEditorNumericPlugin Number numeric multi editor tab name MultiEditorText Tab changes focus Cut Copy Paste Delete Undo Redo MultiEditorTextPlugin Text MultiEditorTimePlugin Time NewConstraintDialog New constraint Primary Key new constraint dialog Foreign Key new constraint dialog Unique new constraint dialog Check new constraint dialog Not NULL new constraint dialog Collate new constraint dialog Generated new constraint dialog Default new constraint dialog NewVersionDialog SQLiteStudio updates New version is available! Download new version! New version package will be downloaded. It will be up to you to install it whenever you're ready. Open SQLiteStudio home page. Read release notes && download package yourself. Just close this window. Check for updates on startup Not now. PopulateConfigDialog Populating configuration Configuring %1 for column %2 PopulateDialog Populate table Database Table Columns Number of rows to populate: Populate populate dialog button Abort Configure Populating configuration for this column is invalid or incomplete. Select database with table to populate Select table to populate You have to select at least one column. QObject Cannot 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). Cannot edit table generated columns. Cannot edit columns that are result of a view if the executed query reads from any multilevel views (i.e. a view that queries another view). on conflict: %1 data view tooltip references table %1, column %2 data view tooltip condition: %1 data view tooltip collation name: %1 data view tooltip Data grid view Edit current cell inline Copy cell(s) contents to clipboard Copy cell(s) contents together with header to clipboard Paste cell(s) contents from clipboard Set empty value to selected cell(s) Set NULL value to selected cell(s) Commit changes to cell(s) contents Rollback changes to cell(s) contents Delete selected data row Insert new data row Open contents of selected cell in a separate editor Toggle the height adjustment of rows Increase font size data view Decrease font size data view Total pages available: %1 Total rows loaded: %1 Data view (both grid and form) Refresh data Switch to grid view of the data Switch to form view of the data Database list Delete selected item Clear filter contents Refresh schema Refresh all schemas Add database Select all items Copy selected item(s) Paste from clipboard Increase font size database list Decrease font size database list Tables Indexes Triggers Views Columns Data form view Commit changes for current row Rollback changes for current row Go to first row on current page Go to next row Go to previous row Go to last row on current page Insert new row Delete current row Main window Open SQL editor Open DDL history window Open snippets editor window Open function editor window Open collation editor window Open extension manager window Previous window Next window Hide status area Open user manual Open configuration dialog Open Debug Console Open CSS Console Open the About dialog Quit the application Cell text value editor Cut selected text Copy selected text Delete selected text Undo Redo SQL editor input field Select whole editor contents Save contents into a file Load contents from a file Find in text Find next Find previous Replace in text Delete current line Request code assistant Format contents Move selected block of text one line down Move selected block of text one line up Copy selected block of text and paste it a line below Copy selected block of text and paste it a line above Toggle comment Increase font size sql editor Decrease font size sql editor All SQLite databases All files Select database file Select File type SQL editor window Execute query Execute single query under cursor Execute all queries in editor Execute "%1" query Switch current working database to previous on the list Switch current working database to next on the list Go to next editor tab Go to previous editor tab Move keyboard input focus to the results view below Move keyboard input focus to the SQL editor above Delete selected SQL history entries Table window Commit the table structure Rollback pending changes in the table structure Refresh table structure Add new column Edit selected column Delete selected column Export table data Import data to the table Add new table constraint Edit selected table constraint Delete selected table constraint Refresh table index list Add new index Edit selected index Delete selected index Refresh table trigger list Add new trigger Edit selected trigger Delete selected trigger Go to next tab Go to previous tab A view window Commit the view's query Rollback pending changes in the view's query Refresh view trigger list Execute the view's query A code snippets editor window Commit the pending changes Rollback the pending changes A collation editor window A function editor window A SQLite extension editor window QuitConfirmDialog Uncommitted changes Are you sure you want to quit the application? Following items are pending: SearchTextDialog Find or replace Find: Case sensitive Search backwards Regular expression matching Replace && find next Replace with: Replace all Find SortDialog Sort by columns Column Order Sort by: %1 Move column up Move column down SqlEditor Wrap words sql editor Cut sql editor Copy sql editor Paste sql editor Delete sql editor Select all sql editor Undo sql editor Redo sql editor Complete sql editor Format SQL sql editor Save SQL to file sql editor Select file to save SQL sql editor Load SQL from file sql editor Delete line sql editor Move block down sql editor Move block up sql editor Copy block down sql editor Copy up down sql editor Find sql editor Find next sql editor Find previous sql editor Replace sql editor Toggle comment sql editor Increase font size sql editor Decrease font size sql editor Could not open file '%1' for writing: %2 Saved SQL contents to file: %1 Syntax 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 file SQL scripts (*.sql);;All files (*) Open file Could not open file '%1' for reading: %2 Reached the end of document. Hit the find again to restart the search. SqlQueryItem Committing error: data view tooltip Column: data view tooltip Data type: data view Table: data view tooltip Constraints: data view tooltip SqlQueryItemDelegate Cannot edit this cell. Details: %1 The row is marked for deletion. Structure of this table has changed since last data was loaded. Reload the data to proceed. Editing a huge contents in an inline cell editor is not a good idea. It can become slow and inconvenient. It's better to edit such big contents in a Form View, or in popup editor (available under rick-click menu). Foreign key for column %2 has more than %1 possible values. It's too much to display in drop down list. You need to edit value manually. SqlQueryModel Only one query can be executed simultaneously. Cannot execute query on undefined or invalid database. Cannot execute empty query. Uncommitted data There are uncommitted data changes. Do you want to proceed anyway? All uncommitted 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: %1 An error occurred while committing the transaction: %1 An error occurred while rolling back the transaction: %1 Tried 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 committing the data: %1 Number of rows per page was decreased to %1 due to number of columns (%2) in the data view. Error while executing SQL query on database '%1': %2 Error while loading query results: %1 Insert multiple rows Number of rows to insert: Delete rows You're about to delete newly inserted rows that are not committed yet. Row numbers: %1 Such deletion will be permanent. Are you sure you want to delete them? SqlQueryView Go to referenced row in... Copy Copy with headers Copy as... Paste Paste as... Set NULL values Erase values Commit Rollback Commit selected cells Rollback selected cells Edit current cell inline Define columns to sort by Remove custom sorting Insert row Insert multiple rows Delete selected row Adjust height of rows Increase font size data view Decrease font size data view Invert selection data view Edit value in editor Show value in a viewer Generate query for selected cells No items selected to paste clipboard contents to. Cannot paste data. Details: %1 Structure of at least one table used has changed since last data was loaded. Reload the data to proceed. Cannot paste to a cell. Details: %1 The row is marked for deletion. Cannot paste to column %1. Details: %2 Go to referenced row in table '%1' table '%1' Referenced row (%1) Trim pasted text? The pasted text contains leading or trailing white space. Trim it automatically? Paste "NULL" as null value? The pasted text contains "NULL" literals. Do you want to consider them as NULL values? Edit value SqlTableModel Error while committing new row: %1 Error while deleting row from table %1: %2 SqliteExtensionEditor Filter extensions Leave empty to use default function Extension file Initialization function Databases Register in all databases Register in following databases: Extension manager window has uncommitted modifications. Extension manager Commit all extension changes Rollback all extension changes Add new extension Remove selected extension Editing extensions manual File with given path does not exist or is not readable. Unable to load extension: %1 Invalid initialization function name. Function name can contain only alpha-numeric characters and underscore. Dynamic link libraries (*.dll);;All files (*) Shared objects (*.so);;All files (*) Dynamic libraries (*.dylib);;All files (*) All files (*) Open file StatusField Status Copy Clear TableConstraintsModel Type table constraints Details table constraints Name table constraints TableForeignKeyPanel Foreign table: Columns Local column Foreign column Reactions Deferred foreign key Named constraint Constraint name Pick the foreign column. Pick the foreign table. Select at least one foreign column. Enter a name of the constraint. Foreign column table constraints TablePrimaryKeyAndUniquePanel Columns Column Collation Sort Valid only for a single column with INTEGER data type Autoincrement Named constraint Constraint name On conflict Collate table constraints Sort order table constraints Select at least one column. Enter a name of the constraint. TableStructureModel Name table structure columns Data type table structure columns Primary Key table structure columns Foreign Key table structure columns Unique table structure columns Check table structure columns Not NULL table structure columns Collate table structure columns Generated table structure columns Default value table structure columns TableWindow Structure Table name: <html><head/><body>Enables/disabled the WITHOUT ROWID clause on the table. Such table will no longer have the "rowid" hidden column. For such table an explicit PRIMARY KEY column is mandatory. You can read more details on this in SQLite official documentation.</body></html> <html><head/><body>Enables/disables the STRICT clause for the table. Such table makes strict verification of data stored in columns against declared data types for these columns. This is similar to how data types are usually enforced in most other database engines. Keep it disabled to use the classical SQLite bahavior (i.e. no data type enforcement). You can find more details in the official SQLite documentation.</body></html> Data Constraints Indexes Triggers DDL Export table table window Import data to table table window Populate table table window Refresh structure table window Commit structure changes table window Rollback structure changes table window Add column table window Edit column table window Delete column table window Move column up table window Move column down table window Create similar table table window Reset autoincrement value table window Add table constraint table window Edit table constraint table window Delete table constraint table window Move table constraint up table window Move table constraint down table window Add table primary key table window Add table foreign key table window Add table unique constraint table window Add table check constraint table window Refresh index list table window Create index table window Edit index table window Delete index table window Refresh trigger list table window Create trigger table window Edit trigger table window Delete trigger table window Are you sure you want to delete column '%1'? table window Following problems will take place while modifying the table. Would you like to proceed? table window Table modification table window Could not load data for table %1. Error details: %2 Could not process the %1 table correctly. Unable to open a table window. Database 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 %1 Committed changes for table '%1' successfully. Committed changes for table '%1' (named before '%2') successfully. Could not commit table structure. Error message: %1 table window Reset autoincrement Are you sure you want to reset autoincrement value for table '%1'? An error occurred while trying to reset autoincrement value for table '%1': %2 Autoincrement value for table '%1' has been reset successfully. Empty name A 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. Following columns have non-strict data type: %1. Either disable strict mode of the table, or fix column data types. Valid strict data types are: %2 Are you sure you want to delete table constraint '%1'? table window Delete constraint table window Cannot export, because no export plugin is loaded. Cannot import, because no import plugin is loaded. Uncommitted changes There are uncommitted 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 tab Commit modifications and browse data. Name table window indexes Unique table window indexes Columns table window indexes Partial index condition table window indexes Name table window triggers Event table window triggers Condition table window triggers Details table window triggers Table window "%1" has uncommitted structure modifications and data. Table window "%1" has uncommitted data. Table window "%1" has uncommitted structure modifications. TriggerColumnsDialog Trigger columns Triggering columns: Select all Deselect all TriggerDialog Trigger On table: Action: 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. 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. DDL On view: Could not process trigger %1 correctly. Unable to open a trigger dialog. Enter a valid condition. Enter a valid trigger code. Error trigger dialog An error occurred while executing SQL statements: %1 VersionConvertSummaryDialog Database version convert Following changes to the SQL statements will be made: Before After ViewWindow Query View name: Output column names Data Triggers DDL Could 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 %1 Database Refresh the view view window Commit the view changes view window Rollback the view changes view window Explicit column names Generate output column names automatically basing on result columns of the view. Add column view window Edit column view window Delete column view window Move column up view window Move column down view window Refresh trigger list view window Create new trigger view window Edit selected trigger view window Delete selected trigger view window View window "%1" has uncommitted structure modifications and data. View window "%1" has uncommitted data. View window "%1" has uncommitted structure modifications. Could not load data for view %1. Error details: %2 Uncommitted changes There are uncommitted 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 tab Commit modifications and browse data. View '%1' was committed successfully. Committed changes for view '%1' successfully. Committed changes for view '%1' (named before '%2') successfully. Could not commit view changes. Error message: %1 view window Override columns Currently defined columns will be overriden. Do you want to continue? Could not determinate columns returned from the view. The query is problably incomplete or contains errors. Name view window triggers Instead of view window triggers Condition view window triggers Details table window triggers Could not process the %1 view correctly. Unable to open a view window. Empty name A 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: %1 The 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 window View modification view window WidgetCover Interrupt