diff options
Diffstat (limited to 'docs/dev')
| -rw-r--r-- | docs/dev/database_schema.md | 17 |
1 files changed, 9 insertions, 8 deletions
diff --git a/docs/dev/database_schema.md b/docs/dev/database_schema.md index bce1120b..82070f7e 100644 --- a/docs/dev/database_schema.md +++ b/docs/dev/database_schema.md @@ -14,14 +14,15 @@ Primary keys: id # 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 + 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 + SHA256 | sha256 | VARCHAR(64) NOT NULL UNIQUE | VARCHAR(64) NOT NULL UNIQUE | VARCHAR(64) NOT NULL UNIQUE + CreatedUnix | created_unix | BIGINT | BIGINT | INTEGER + UpdatedUnix | updated_unix | BIGINT | BIGINT | INTEGER Primary keys: id ``` |