diff options
| author | ᴜɴᴋɴᴡᴏɴ <u@gogs.io> | 2020-09-06 17:02:25 +0800 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2020-09-06 17:02:25 +0800 |
| commit | 06193ed825094581da4fb5550804d7445fc5ae13 (patch) | |
| tree | bd2d966235a224b9d28d316ef915481a63fac5f9 /docs/dev/database_schema.md | |
| parent | 519e59b5778571ace3f681b81a21b92a38ede890 (diff) | |
schemadoc: add go:generate to output database schema (#6310)
* schemadoc: add go:generate to output database schema
* Check errors
* Revert string renames
Diffstat (limited to 'docs/dev/database_schema.md')
| -rw-r--r-- | docs/dev/database_schema.md | 46 |
1 files changed, 46 insertions, 0 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 +``` + |