SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";
CREATE TABLE `sites` (
`id` int UNSIGNED NOT NULL,
`title` text NOT NULL,
`blurb` text NOT NULL,
`keywords` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
`url` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
ALTER TABLE `sites`
ADD PRIMARY KEY (`id`);
ALTER TABLE `sites`
MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;
COMMIT;
|