drnk.me/persistence/migrations/0001_addUrlTable.sql
2023-11-29 22:17:08 +01:00

12 lines
No EOL
314 B
SQL

CREATE TABLE `dm_urls` (
`id` BIGINT AUTO_INCREMENT PRIMARY KEY,
`created` DATETIME DEFAULT CURRENT_TIMESTAMP,
`updated` DATETIME DEFAULT CURRENT_TIMESTAMP,
`deleted` DATETIME,
`slug` VARCHAR(100) NOT NULL,
`url` VARCHAR(255) NOT NULL,
`access_key` VARCHAR(255),
INDEX (`slug`)
);