20 lines
573 B
Plaintext
20 lines
573 B
Plaintext
-- MySQL 9 Compatible Database Structure
|
|
-- LJWX System Database Schema
|
|
|
|
SET NAMES utf8mb4;
|
|
SET FOREIGN_KEY_CHECKS = 0;
|
|
|
|
-- Create database if not exists
|
|
CREATE DATABASE IF NOT EXISTS `test` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
|
|
USE `test`;
|
|
|
|
-- Basic table to test MySQL 9 compatibility
|
|
CREATE TABLE `test_table` (
|
|
`id` int NOT NULL AUTO_INCREMENT,
|
|
`name` varchar(100) NOT NULL,
|
|
`created_at` timestamp DEFAULT CURRENT_TIMESTAMP,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
|
|
SET FOREIGN_KEY_CHECKS = 1;
|