aboutsummaryrefslogtreecommitdiffstats
path: root/volumes/mariadb/docker-entrypoint-initdb.d/db-sql-scripts/main-schemas/MySQL-Requests-schema.sql
diff options
context:
space:
mode:
authorRob Daugherty <rd472p@att.com>2017-10-13 10:36:29 -0400
committerRob Daugherty <rd472p@att.com>2017-10-13 10:37:31 -0400
commit038c9abe5dd712b0aacd327436aecacda4430c6f (patch)
treef503d3c35e61bd8433d466f56bba482e3ea95a49 /volumes/mariadb/docker-entrypoint-initdb.d/db-sql-scripts/main-schemas/MySQL-Requests-schema.sql
parentd96a411f783ce400d89056025881a19c1ec3f564 (diff)
Timestamps now in hibernate definitions
We don't need the scripts that add the timestamp columns. Issue: SO-215 Change-Id: I1635874df4f0a34fede96cacdaa4134c89f23e7b Signed-off-by: Rob Daugherty <rd472p@att.com>
Diffstat (limited to 'volumes/mariadb/docker-entrypoint-initdb.d/db-sql-scripts/main-schemas/MySQL-Requests-schema.sql')
-rw-r--r--volumes/mariadb/docker-entrypoint-initdb.d/db-sql-scripts/main-schemas/MySQL-Requests-schema.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/volumes/mariadb/docker-entrypoint-initdb.d/db-sql-scripts/main-schemas/MySQL-Requests-schema.sql b/volumes/mariadb/docker-entrypoint-initdb.d/db-sql-scripts/main-schemas/MySQL-Requests-schema.sql
index c6f070d..83f0b08 100644
--- a/volumes/mariadb/docker-entrypoint-initdb.d/db-sql-scripts/main-schemas/MySQL-Requests-schema.sql
+++ b/volumes/mariadb/docker-entrypoint-initdb.d/db-sql-scripts/main-schemas/MySQL-Requests-schema.sql
@@ -50,7 +50,7 @@
create table SITE_STATUS (
SITE_NAME varchar(255) not null,
STATUS bit,
- CREATION_TIMESTAMP datetime,
+ CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
primary key (SITE_NAME)
);