useful-api.org/persistence/migrations/0001_addLoggingTable.sql
2023-11-25 14:27:39 +01:00

14 lines
No EOL
366 B
SQL

CREATE TABLE `ua_logs` (
`id` BIGINT AUTO_INCREMENT PRIMARY KEY,
`timestamp` DATETIME DEFAULT CURRENT_TIMESTAMP,
`endpoint` VARCHAR(100),
`endpoint_details` VARCHAR(100),
`client_address` VARCHAR(46),
`access_key` VARCHAR(255),
`clean` BOOLEAN DEFAULT 0,
INDEX (`endpoint`),
INDEX (`client_address`),
INDEX (`access_key`)
);