diff options
| author |  Vitaly Takmazov | 2024-10-05 09:24:51 +0300 |
|---|---|---|
| committer | Vitaly Takmazov | 2024-10-05 09:24:51 +0300 |
| commit | 878327ccd0de1794ca5d19f82ef53687b7e19160 (patch) | |
| tree | 3a387ff8d50cf208c255f6af57141f32b30eeb1c /src/main/resources/schema-sqlserver.sql | |
| parent | 63bd3dc532d20143b70adef1fff6c929fb524304 (diff) | |
db: Add `created_at` field to `emails` table
Diffstat (limited to 'src/main/resources/schema-sqlserver.sql')
| -rw-r--r-- | src/main/resources/schema-sqlserver.sql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/src/main/resources/schema-sqlserver.sql b/src/main/resources/schema-sqlserver.sql index 947e5403..9ff21ed2 100644 --- a/src/main/resources/schema-sqlserver.sql +++ b/src/main/resources/schema-sqlserver.sql @@ -56,6 +56,7 @@ CREATE TABLE emails ( user_id bigint NOT NULL, email character varying(128) NOT NULL, subscr_hour smallint, + created_at datetimeoffset DEFAULT CURRENT_TIMESTAMP NOT NULL, FOREIGN KEY (user_id) REFERENCES users(id) ); CREATE TABLE facebook ( |