-
Notifications
You must be signed in to change notification settings - Fork 2
/
database.sql
31 lines (25 loc) · 1010 Bytes
/
database.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
-- Adminer 4.8.1 MySQL 8.0.29-0ubuntu0.21.10.2 dump
SET NAMES utf8;
SET time_zone = '+00:00';
SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
SET NAMES utf8mb4;
CREATE DATABASE `maling_it` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;
USE `maling_it`;
DROP TABLE IF EXISTS `pdf`;
CREATE TABLE `pdf` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`gd_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
`size` bigint unsigned NOT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `gd_id` (`gd_id`),
KEY `name` (`name`),
KEY `size` (`size`),
KEY `created_at` (`created_at`),
KEY `updated_at` (`updated_at`),
FULLTEXT KEY `name_fulltext` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
-- 2022-06-01 16:36:10