diff options
Diffstat (limited to 'docs')
| -rw-r--r-- | docs/dev/database_schema.md | 46 | ||||
| -rw-r--r-- | docs/dev/import_locale.md | 2 |
2 files changed, 47 insertions, 1 deletions
diff --git a/docs/dev/database_schema.md b/docs/dev/database_schema.md new file mode 100644 index 00000000..39e1be77 --- /dev/null +++ b/docs/dev/database_schema.md @@ -0,0 +1,46 @@ +# Table "access_token" + +``` + FIELD | COLUMN | POSTGRESQL | MYSQL | SQLITE3 ++-------------+--------------+--------------------+-----------------------+--------------------+ + ID | id | BIGSERIAL | BIGINT AUTO_INCREMENT | INTEGER + UserID | uid | BIGINT | BIGINT | INTEGER + Name | name | TEXT | LONGTEXT | TEXT + Sha1 | sha1 | VARCHAR(40) UNIQUE | VARCHAR(40) UNIQUE | VARCHAR(40) UNIQUE + CreatedUnix | created_unix | BIGINT | BIGINT | INTEGER + UpdatedUnix | updated_unix | BIGINT | BIGINT | INTEGER + +Primary keys: id +``` + +# Table "lfs_object" + +``` + FIELD | COLUMN | POSTGRESQL | MYSQL | SQLITE3 ++-----------+------------+----------------------+----------------------+-------------------+ + RepoID | repo_id | BIGINT | BIGINT | INTEGER + OID | oid | TEXT | VARCHAR(191) | TEXT + Size | size | BIGINT NOT NULL | BIGINT NOT NULL | INTEGER NOT NULL + Storage | storage | TEXT NOT NULL | LONGTEXT NOT NULL | TEXT NOT NULL + CreatedAt | created_at | TIMESTAMPTZ NOT NULL | DATETIME(3) NOT NULL | DATETIME NOT NULL + +Primary keys: repo_id, oid +``` + +# Table "login_source" + +``` + FIELD | COLUMN | POSTGRESQL | MYSQL | SQLITE3 ++-------------+--------------+------------------+-----------------------+------------------+ + ID | id | BIGSERIAL | BIGINT AUTO_INCREMENT | INTEGER + Type | type | BIGINT | BIGINT | INTEGER + Name | name | TEXT UNIQUE | VARCHAR(191) UNIQUE | TEXT UNIQUE + IsActived | is_actived | BOOLEAN NOT NULL | BOOLEAN NOT NULL | NUMERIC NOT NULL + IsDefault | is_default | BOOLEAN | BOOLEAN | NUMERIC + RawConfig | cfg | TEXT | TEXT | TEXT + CreatedUnix | created_unix | BIGINT | BIGINT | INTEGER + UpdatedUnix | updated_unix | BIGINT | BIGINT | INTEGER + +Primary keys: id +``` + diff --git a/docs/dev/import_locale.md b/docs/dev/import_locale.md index 156cedc5..ab93a92c 100644 --- a/docs/dev/import_locale.md +++ b/docs/dev/import_locale.md @@ -9,7 +9,7 @@ Locale files has been successfully imported! ``` -1. Run `task generate` to generate corresponding bindata. +1. Run `task generate-bindata` to generate corresponding bindata. 1. Run `task web` to start the web server, then visit the site in the browser to make sure nothing blows up. 1. Check out a new branch using `git checkout -b update-locales`. 1. Stash changes then run `git commit -m "locale: sync from Crowdin"`. |