15 lines
530 B
MySQL
15 lines
530 B
MySQL
|
-- Place your SQL code here
|
||
|
|
CREATE TABLE edi.offerRefreshConfig (
|
||
|
|
id int unsigned auto_increment NOT NULL,
|
||
|
|
dayRange int unsigned NULL COMMENT 'range of days to update the photos of an article in seconds',
|
||
|
|
CONSTRAINT NewTable_PK PRIMARY KEY (id)
|
||
|
|
)
|
||
|
|
ENGINE=InnoDB
|
||
|
|
DEFAULT CHARSET=utf8mb3
|
||
|
|
COLLATE=utf8mb3_unicode_ci;
|
||
|
|
|
||
|
|
ALTER TABLE hedera.image MODIFY COLUMN updated bigint unsigned DEFAULT NULL NULL;
|
||
|
|
|
||
|
|
UPDATE hedera.image
|
||
|
|
SET updated = UNIX_TIMESTAMP(util.VN_NOW())
|
||
|
|
WHERE updated > UNIX_TIMESTAMP(util.VN_NOW());
|