[GH-ISSUE #818] Feature: [SQL USER INFO] naming incorrect. #387

Closed
opened 2026-02-26 10:32:19 +03:00 by kerem · 1 comment
Owner

Originally created by @wolfiex on GitHub (Jun 18, 2025).
Original GitHub issue: https://github.com/ONLYOFFICE/Docker-DocumentServer/issues/818

This is more for anyone trying to figure out why they cant programativally update the DOB in the SQL db directly.

The birthdate field is actually spelt bithdate.

+-------------------+---------------+------+-----+-------------------+-------------------+
| Field             | Type          | Null | Key | Default           | Extra             |
+-------------------+---------------+------+-----+-------------------+-------------------+
| tenant            | int           | NO   | MUL | NULL              |                   |
| id                | varchar(38)   | NO   | PRI | NULL              |                   |
| username          | varchar(255)  | NO   |     | NULL              |                   |
| firstname         | varchar(64)   | NO   |     | NULL              |                   |
| lastname          | varchar(64)   | NO   |     | NULL              |                   |
| sex               | int           | YES  |     | NULL              |                   |
| bithdate          | datetime      | YES  |     | NULL              |                   |
| status            | int           | NO   |     | 1                 |                   |
| activation_status | int           | NO   |     | 0                 |                   |
| email             | varchar(255)  | YES  | MUL | NULL              |                   |
| workfromdate      | datetime      | YES  |     | NULL              |                   |
| terminateddate    | datetime      | YES  |     | NULL              |                   |
| title             | varchar(64)   | YES  |     | NULL              |                   |
| culture           | varchar(20)   | YES  |     | NULL              |                   |
| contacts          | varchar(1024) | YES  |     | NULL              |                   |
| phone             | varchar(255)  | YES  |     | NULL              |                   |
| phone_activation  | int           | NO   |     | 0                 |                   |
| location          | varchar(255)  | YES  |     | NULL              |                   |
| notes             | varchar(512)  | YES  |     | NULL              |                   |
| sid               | varchar(512)  | YES  |     | NULL              |                   |
| sso_name_id       | varchar(512)  | YES  |     | NULL              |                   |
| sso_session_id    | varchar(512)  | YES  |     | NULL              |                   |
| removed           | int           | NO   |     | 0                 |                   |
| create_on         | timestamp     | NO   |     | CURRENT_TIMESTAMP | DEFAULT_GENERATED |
| last_modified     | datetime      | NO   | MUL | NULL              |                   |
| user_lead         | varchar(36)   | YES  |     | NULL              |                   |
+-------------------+---------------+------+-----+-------------------+-------------------+
26 rows in set (0.01 sec)
Originally created by @wolfiex on GitHub (Jun 18, 2025). Original GitHub issue: https://github.com/ONLYOFFICE/Docker-DocumentServer/issues/818 This is more for anyone trying to figure out why they cant programativally update the DOB in the SQL db directly. The `birthdate` field is actually spelt `bithdate`. ```mysql> SHOW COLUMNS FROM core_user; +-------------------+---------------+------+-----+-------------------+-------------------+ | Field | Type | Null | Key | Default | Extra | +-------------------+---------------+------+-----+-------------------+-------------------+ | tenant | int | NO | MUL | NULL | | | id | varchar(38) | NO | PRI | NULL | | | username | varchar(255) | NO | | NULL | | | firstname | varchar(64) | NO | | NULL | | | lastname | varchar(64) | NO | | NULL | | | sex | int | YES | | NULL | | | bithdate | datetime | YES | | NULL | | | status | int | NO | | 1 | | | activation_status | int | NO | | 0 | | | email | varchar(255) | YES | MUL | NULL | | | workfromdate | datetime | YES | | NULL | | | terminateddate | datetime | YES | | NULL | | | title | varchar(64) | YES | | NULL | | | culture | varchar(20) | YES | | NULL | | | contacts | varchar(1024) | YES | | NULL | | | phone | varchar(255) | YES | | NULL | | | phone_activation | int | NO | | 0 | | | location | varchar(255) | YES | | NULL | | | notes | varchar(512) | YES | | NULL | | | sid | varchar(512) | YES | | NULL | | | sso_name_id | varchar(512) | YES | | NULL | | | sso_session_id | varchar(512) | YES | | NULL | | | removed | int | NO | | 0 | | | create_on | timestamp | NO | | CURRENT_TIMESTAMP | DEFAULT_GENERATED | | last_modified | datetime | NO | MUL | NULL | | | user_lead | varchar(36) | YES | | NULL | | +-------------------+---------------+------+-----+-------------------+-------------------+ 26 rows in set (0.01 sec) ```
kerem closed this issue 2026-02-26 10:32:19 +03:00
Author
Owner

@AntonKashichkin commented on GitHub (Jun 18, 2025):

Hello wolfiex, thank you for your request. We've passed it along for further review.

<!-- gh-comment-id:2983852331 --> @AntonKashichkin commented on GitHub (Jun 18, 2025): Hello wolfiex, thank you for your request. We've passed it along for further review.
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
starred/Docker-DocumentServer-ONLYOFFICE#387
No description provided.