2.3.0.5427
and 2.4.0.369
it can found at C:\Program Files\Starcounter\stardump
.stardump unload
command to unload the database. For example, to unload the default
database to the Desktop, the following would be used:Dump.sqlite3
on the desktop.sqlite3
file, it is recommended to use DB Browser for SQLite. Using this tool, the schema of the database can be modified. The following examples displays the methods to do almost any schema modification:Person
, Teenager
and Child
, are at the top followed by the Simplified
tables. The Simplified
tables can in most cases be disregarded.Teenager
to Teen
requires two changes, renaming the table itself, and modifying the metadata accordingly. To rename the table itself, right click on the table in the view above and choose Modify table...
. Then, simply change [ApplicationName].Teenager
to [ApplicationName].Teen
. To make this change in the metadata, go to the tab Browse Data
and find the table Starcounter.Metadata.Table
. There, click on [ApplicationName].Teenager
and rename it to [ApplicationName].Teen
.Simplified
tables to go by the name of Custom
, the following SQL query can be used:FirstName
to Name
in the following model:Person
and choose Modify Table...
. Double click on the field FirstName
and enter Name
. Repeat this step for all the tables that inherits this column, in this example, they are Teenager
and Child
.Starcounter.Metadata.Column
by finding the columns FirstName
and rename them to Name
. If it's not completely clear which columns that should be renamed, use the TableId to find the right columns.Teenager
table was renamed to Teen
, the code would be changed from this:stardump reload
command. For example, to reload the sqlite3
file "Dump" into the default database, the following would be used: