1
0
mirror of https://github.com/haiwen/seahub.git synced 2025-04-27 11:01:14 +00:00
seahub/sql/README.md
lins05 af12058e08 added sqls for all models
During seafile server setup, it's better to import sqls than running
django "syncdb" command direclty.
2014-07-09 14:43:12 +08:00

660 B

Seahub Schema

This folder contains database schema for seahub.

Maintainence

The sql files in this folder should always correspond to the latest schema, which means it would give you the same database whether you run the django "syncdb" command or directly import the sqls here.

So each time you change some model, you should update each sql file here.

Get the initial database sqls

SQLite3

To get the sqlite3 sqls:

cd seahub
sqlite3 seahub/seahub.db .dump > sql/sqlite3.sql

MySQL

To get the MySQL sqls:

cd seahub
mysqldump -u root -proot --skip-add-lock --skip-add-drop-table --skip-comments seahub  > sql/mysql.sql