This repository has been archived on 2023-11-14. You can view files and clone it, but cannot push or open issues/pull-requests.
viscord/packages/server/public/migrations/1-chat-persistence.sql

21 lines
511 B
MySQL
Raw Permalink Normal View History

2022-07-21 05:38:58 -04:00
-- SET NAMES utf8;
-- SET time_zone = '+00:00';
-- SET foreign_key_checks = 0;
-- SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
2022-07-21 04:18:39 -04:00
2022-07-21 05:38:58 -04:00
-- SET NAMES utf8mb4;
2022-07-21 04:18:39 -04:00
CREATE TABLE `messages` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` tinytext NOT NULL,
`from` tinytext NOT NULL,
`text` longtext NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE `migrations` (
`id` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- 2022-07-21 01:27:49