android - Trying to save an SQLite database from command line but it's not giving *.sqlite nor *.db, just saves a filename without any extension -

so go directory sqlite3.exe , open double click type in following commands (i'm including foreign keys pragma need in future):

pragma foreign_keys=on;  create table `countries` (     `country_id`    integer not null,     `name`  text not null unique,      primary key(country_id) );  insert `countries` values   (1,'japan'),  (2,'china');  .save countries 

this gives me file no extension type, only: countries

but tutorials see opening pre-made/existing database in android use open file extensions such example.db or example.sqlite

what missing? when try open file ormlite get:

java.sql.sqlexception: problems executing runexecute android statement:     create table `countries` (`name` varchar ,        `country_id` integer primary key autoincrement )