drnk.me/persistence/migrations/0001_addUrlTable.sql

12 lines
314 B
MySQL
Raw Permalink Normal View History

2023-11-29 21:17:08 +00:00
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`)
);