Database tables are missing in the first usage

[RussellLuo]

When using sqlite for storage, there is an error in the first usage:

OperationalError: (sqlite3.OperationalError) no such table: item [SQL: u'SELECT count(*) AS count_1 \nFROM (SELECT item.name AS item_name, item.tag AS item_tag, item.collection_path AS item_collection_path \nFROM item \nWHERE item.collection_path = ?) AS anon_1'] [parameters: ('user',)]

The reason is obvious: in the first usage, the required tables have not been created yet.

As far as I can see, there are two solutions:

1. Use the command-line utility sqilte3 (provided by sqlite):

   $ sqlite3 radicale.db < schema.sql
   

2. Use the create_all() method of SQLAlchemy to create tables automatically, and I think this is a better solution