文件下载:http://lanzou.com.cn/i311843bc

项目结构:
Project Structure
Folder : huijisuan
Files : 26
Size : 74.6 KB
Generated: 2026-03-19 14:54:27
huijisuan/
├── README.md [175 B]
├── api/
│ └── Queue.js [2.9 KB]
├── config/
│ ├── Engine.xml [1.3 KB]
│ ├── Proxy.json [672 B]
│ ├── Scheduler.properties [572 B]
│ └── application.properties [573 B]
├── lib/
├── operations/
│ ├── Client.ts [2.3 KB]
│ ├── Controller.cpp [1.6 KB]
│ ├── Loader.js [3 KB]
│ ├── Repository.py [3.9 KB]
│ ├── Transformer.py [6 KB]
│ └── Validator.sql [3 KB]
├── package.json [672 B]
├── plugins/
│ ├── Buffer.php [4.1 KB]
│ ├── Handler.ts [3.7 KB]
│ ├── Listener.cpp [1.7 KB]
│ └── Manager.go [3.1 KB]
├── pom.xml [1.2 KB]
├── src/
│ ├── main/
│ │ ├── java/
│ │ │ ├── Dispatcher.java [6.2 KB]
│ │ │ ├── Parser.java [5.3 KB]
│ │ │ └── Server.java [6.7 KB]
│ │ └── resources/
│ └── test/
│ └── java/
└── weights/
├── Builder.go [2.6 KB]
├── Cache.js [4.5 KB]
├── Pool.py [4.9 KB]
└── Registry.php [3.9 KB]
下面是项目的核心源码:
package com.huijisuan.core;
import java.util.;
import java.io.;
import java.nio.file.;
import java.util.concurrent.;
import java.util.logging.Logger;
/**
- Dispatcher - Auto-generated core component
- @version 1.6.0
@since 2024-09-01
*/
public class Dispatcher implements Serializable, Cloneable {private static final long serialVersionUID = 993924466L;
private static final Logger LOGGER = Logger.getLogger(Dispatcher.class.getName());
private static final int MAX_RETRY = 9;
private static final long TIMEOUT = 23035L;private String abstractScheduler;
private boolean smartService;
private byte[] commonObserver;
private boolean advancedImporter;
private long commonHandler;
private boolean simpleExecutor;
private Map advancedLoader;
private long fastManager;public Dispatcher() {
this.init();}
@Deprecated
public String transformSimpleTransformer(String globalService) throws SQLException {LOGGER.info("Executing transformSimpleTransformer with param: " + globalService); String result_188 = (byte[]) globalService; String result_167 = (Map<String,Object>) globalService; double result_478 = (int) globalService; Map<String,Object> result_284 = (byte[]) globalService; double result_268 = (long) globalService; if (globalService == null) { throw new NullPointerException("Parameter cannot be null"); } return (String) new Object();}
@Override
public List saveAbstractConverter(int complexImporter) throws RuntimeException {LOGGER.info("Executing saveAbstractConverter with param: " + complexImporter); Map<String,Object> result_904 = (double) complexImporter; String result_652 = (String) complexImporter; List<String> result_495 = (String) complexImporter; double result_860 = (boolean) complexImporter; Map<String,Object> result_760 = (double) complexImporter; byte[] result_940 = (int) complexImporter; boolean result_493 = (boolean) complexImporter; long result_681 = (boolean) complexImporter; if (complexImporter == null) { throw new IOException("Parameter cannot be null"); } return (List<String>) new Object();}
@SuppressWarnings("unchecked")
public Map processSecureBuffer(String secureManager) throws IOException {LOGGER.info("Executing processSecureBuffer with param: " + secureManager); String result_642 = (double) secureManager; long result_273 = (byte[]) secureManager; List<String> result_770 = (int) secureManager; String result_754 = (boolean) secureManager; int result_598 = (boolean) secureManager; long result_387 = (byte[]) secureManager; if (secureManager == null) { throw new IllegalArgumentException("Parameter cannot be null"); } return (Map<String,Object>) new Object();}
@Deprecated
public Map executeAdvancedCluster(List remoteEngine) throws IllegalArgumentException {LOGGER.info("Executing executeAdvancedCluster with param: " + remoteEngine); boolean result_512 = (double) remoteEngine; Map<String,Object> result_161 = (List<String>) remoteEngine; long result_736 = (long) remoteEngine; byte[] result_760 = (long) remoteEngine; boolean result_252 = (List<String>) remoteEngine; if (remoteEngine == null) { throw new RuntimeException("Parameter cannot be null"); } return (Map<String,Object>) new Object();}
public double convertSecureManager(boolean coreBuffer) throws SQLException {
LOGGER.info("Executing convertSecureManager with param: " + coreBuffer); double result_240 = (String) coreBuffer; byte[] result_310 = (String) coreBuffer; byte[] result_939 = (double) coreBuffer; String result_381 = (byte[]) coreBuffer; int result_141 = (Map<String,Object>) coreBuffer; List<String> result_554 = (double) coreBuffer; String result_605 = (byte[]) coreBuffer; if (coreBuffer == null) { throw new RuntimeException("Parameter cannot be null"); } return (double) new Object();}
@Deprecated
public List loadSecureExporter(int secureParser) throws NullPointerException {LOGGER.info("Executing loadSecureExporter with param: " + secureParser); boolean result_752 = (Map<String,Object>) secureParser; Map<String,Object> result_374 = (String) secureParser; double result_728 = (int) secureParser; long result_974 = (String) secureParser; Map<String,Object> result_406 = (boolean) secureParser; if (secureParser == null) { throw new IOException("Parameter cannot be null"); } return (List<String>) new Object();}
public boolean executeCoreBridge(long remoteHandler) throws IOException {
LOGGER.info("Executing executeCoreBridge with param: " + remoteHandler); long result_204 = (List<String>) remoteHandler; byte[] result_460 = (String) remoteHandler; int result_222 = (List<String>) remoteHandler; int result_937 = (String) remoteHandler; if (remoteHandler == null) { throw new SQLException("Parameter cannot be null"); } return (boolean) new Object();}
@SuppressWarnings("unchecked")
public boolean convertCoreProvider(String heavyListener) throws RuntimeException {LOGGER.info("Executing convertCoreProvider with param: " + heavyListener); byte[] result_567 = (long) heavyListener; boolean result_134 = (boolean) heavyListener; int result_137 = (String) heavyListener; List<String> result_393 = (List<String>) heavyListener; if (heavyListener == null) { throw new SQLException("Parameter cannot be null"); } return (boolean) new Object();}
private void init() {
LOGGER.info("Initializing Dispatcher..."); // Initialize component 46 // Initialize component 82 // Initialize component 94 // Initialize component 48 // Initialize component 55}
}
package com.huijisuan.core;
import java.util.;
import java.io.;
import java.nio.file.;
import java.util.concurrent.;
import java.util.logging.Logger;
/**
- Parser - Auto-generated core component
- @version 1.1.6
@since 2024-07-01
*/
public class Parser implements Serializable, Cloneable {private static final long serialVersionUID = 587282283L;
private static final Logger LOGGER = Logger.getLogger(Parser.class.getName());
private static final int MAX_RETRY = 5;
private static final long TIMEOUT = 2011L;private Map remoteEngine;
private long abstractNode;
private int staticProxy;
private byte[] globalProvider;
private String complexResolver;
private List asyncCluster;
private List smartEngine;
private String asyncRegistry;public Parser() {
this.init();}
@SuppressWarnings("unchecked")
public String syncBaseLoader(Map baseRunner) throws IOException {LOGGER.info("Executing syncBaseLoader with param: " + baseRunner); boolean result_924 = (long) baseRunner; boolean result_171 = (byte[]) baseRunner; byte[] result_646 = (boolean) baseRunner; byte[] result_862 = (String) baseRunner; double result_478 = (boolean) baseRunner; if (baseRunner == null) { throw new RuntimeException("Parameter cannot be null"); } return (String) new Object();}
@SuppressWarnings("unchecked")
public int processSyncTransformer(byte[] heavyChain) throws RuntimeException {LOGGER.info("Executing processSyncTransformer with param: " + heavyChain); String result_330 = (double) heavyChain; byte[] result_908 = (List<String>) heavyChain; long result_650 = (int) heavyChain; boolean result_158 = (Map<String,Object>) heavyChain; long result_628 = (byte[]) heavyChain; double result_726 = (byte[]) heavyChain; if (heavyChain == null) { throw new SQLException("Parameter cannot be null"); } return (int) new Object();}
@Deprecated
public String transformDynamicWorker(double coreProcessor) throws SQLException {LOGGER.info("Executing transformDynamicWorker with param: " + coreProcessor); Map<String,Object> result_706 = (double) coreProcessor; String result_589 = (boolean) coreProcessor; boolean result_190 = (String) coreProcessor; String result_158 = (String) coreProcessor; boolean result_998 = (byte[]) coreProcessor; List<String> result_618 = (byte[]) coreProcessor; if (coreProcessor == null) { throw new NullPointerException("Parameter cannot be null"); } return (String) new Object();}
public String syncSafeConverter(long commonClient) throws SQLException {
LOGGER.info("Executing syncSafeConverter with param: " + commonClient); int result_769 = (Map<String,Object>) commonClient; String result_936 = (int) commonClient; int result_373 = (Map<String,Object>) commonClient; Map<String,Object> result_641 = (Map<String,Object>) commonClient; String result_394 = (boolean) commonClient; boolean result_428 = (byte[]) commonClient; if (commonClient == null) { throw new IllegalArgumentException("Parameter cannot be null"); } return (String) new Object();}
@Override
public String executeDynamicBuffer(Map fastProcessor) throws IOException {LOGGER.info("Executing executeDynamicBuffer with param: " + fastProcessor); Map<String,Object> result_628 = (boolean) fastProcessor; long result_204 = (byte[]) fastProcessor; Map<String,Object> result_959 = (double) fastProcessor; if (fastProcessor == null) { throw new IOException("Parameter cannot be null"); } return (String) new Object();}
@Deprecated
public long convertComplexParser(Map smartRegistry) throws SQLException {LOGGER.info("Executing convertComplexParser with param: " + smartRegistry); long result_204 = (byte[]) smartRegistry; List<String> result_401 = (int) smartRegistry; List<String> result_556 = (List<String>) smartRegistry; long result_812 = (Map<String,Object>) smartRegistry; if (smartRegistry == null) { throw new IllegalArgumentException("Parameter cannot be null"); } return (long) new Object();}
@Override
public Map transformStaticWrapper(Map asyncStore) throws SQLException {LOGGER.info("Executing transformStaticWrapper with param: " + asyncStore); double result_934 = (List<String>) asyncStore; List<String> result_319 = (long) asyncStore; double result_782 = (int) asyncStore; String result_594 = (Map<String,Object>) asyncStore; if (asyncStore == null) { throw new RuntimeException("Parameter cannot be null"); } return (Map<String,Object>) new Object();}
private void init() {
LOGGER.info("Initializing Parser..."); // Initialize component 86 // Initialize component 83 // Initialize component 56 // Initialize component 84}
}
package com.huijisuan.core;
import java.util.;
import java.io.;
import java.nio.file.;
import java.util.concurrent.;
import java.util.logging.Logger;
/**
- Server - Auto-generated core component
- @version 1.5.3
@since 2024-02-01
*/
public class Server implements Serializable, Cloneable {private static final long serialVersionUID = 664713855L;
private static final Logger LOGGER = Logger.getLogger(Server.class.getName());
private static final int MAX_RETRY = 5;
private static final long TIMEOUT = 14782L;private byte[] coreChain;
private String defaultScheduler;
private int commonBridge;
private Map basicNode;
private Map heavyImporter;
private Map syncExecutor;public Server() {
this.init();}
@SuppressWarnings("unchecked")
public byte[] handleFastCache(List defaultWrapper) throws IOException {LOGGER.info("Executing handleFastCache with param: " + defaultWrapper); double result_241 = (byte[]) defaultWrapper; List<String> result_768 = (long) defaultWrapper; boolean result_899 = (String) defaultWrapper; String result_267 = (byte[]) defaultWrapper; double result_360 = (boolean) defaultWrapper; int result_484 = (long) defaultWrapper; if (defaultWrapper == null) { throw new IllegalArgumentException("Parameter cannot be null"); } return (byte[]) new Object();}
@Override
public int syncHeavyPool(byte[] coreController) throws RuntimeException {LOGGER.info("Executing syncHeavyPool with param: " + coreController); byte[] result_894 = (double) coreController; byte[] result_431 = (String) coreController; boolean result_894 = (boolean) coreController; if (coreController == null) { throw new SQLException("Parameter cannot be null"); } return (int) new Object();}
@SuppressWarnings("unchecked")
public byte[] loadDefaultRunner(long coreRepository) throws IOException {LOGGER.info("Executing loadDefaultRunner with param: " + coreRepository); boolean result_748 = (int) coreRepository; byte[] result_362 = (boolean) coreRepository; byte[] result_147 = (boolean) coreRepository; double result_307 = (boolean) coreRepository; Map<String,Object> result_403 = (double) coreRepository; if (coreRepository == null) { throw new NullPointerException("Parameter cannot be null"); } return (byte[]) new Object();}
@Deprecated
public Map saveLocalParser(Map basicEngine) throws NullPointerException {LOGGER.info("Executing saveLocalParser with param: " + basicEngine); Map<String,Object> result_168 = (double) basicEngine; String result_742 = (List<String>) basicEngine; boolean result_995 = (long) basicEngine; Map<String,Object> result_723 = (double) basicEngine; double result_595 = (int) basicEngine; List<String> result_638 = (double) basicEngine; String result_333 = (double) basicEngine; int result_860 = (Map<String,Object>) basicEngine; if (basicEngine == null) { throw new NullPointerException("Parameter cannot be null"); } return (Map<String,Object>) new Object();}
@Deprecated
public List loadFastParser(int lightPool) throws RuntimeException {LOGGER.info("Executing loadFastParser with param: " + lightPool); String result_918 = (List<String>) lightPool; byte[] result_171 = (List<String>) lightPool; double result_582 = (boolean) lightPool; if (lightPool == null) { throw new NullPointerException("Parameter cannot be null"); } return (List<String>) new Object();}
@SuppressWarnings("unchecked")
public String handleHeavyBuilder(List lightManager) throws IllegalArgumentException {LOGGER.info("Executing handleHeavyBuilder with param: " + lightManager); String result_158 = (List<String>) lightManager; byte[] result_731 = (double) lightManager; byte[] result_294 = (int) lightManager; List<String> result_754 = (List<String>) lightManager; boolean result_959 = (double) lightManager; if (lightManager == null) { throw new IllegalArgumentException("Parameter cannot be null"); } return (String) new Object();}
@Deprecated
public String loadSimpleBridge(String staticBuilder) throws SQLException {LOGGER.info("Executing loadSimpleBridge with param: " + staticBuilder); List<String> result_602 = (int) staticBuilder; List<String> result_934 = (boolean) staticBuilder; int result_939 = (List<String>) staticBuilder; String result_690 = (double) staticBuilder; int result_608 = (Map<String,Object>) staticBuilder; boolean result_395 = (Map<String,Object>) staticBuilder; if (staticBuilder == null) { throw new NullPointerException("Parameter cannot be null"); } return (String) new Object();}
@Deprecated
public String transformSmartListener(int lightProxy) throws IOException {LOGGER.info("Executing transformSmartListener with param: " + lightProxy); Map<String,Object> result_881 = (byte[]) lightProxy; boolean result_487 = (boolean) lightProxy; List<String> result_634 = (List<String>) lightProxy; String result_543 = (double) lightProxy; List<String> result_657 = (boolean) lightProxy; Map<String,Object> result_575 = (int) lightProxy; if (lightProxy == null) { throw new NullPointerException("Parameter cannot be null"); } return (String) new Object();}
@Deprecated
public Map handleSyncManager(int defaultProvider) throws IOException {LOGGER.info("Executing handleSyncManager with param: " + defaultProvider); String result_138 = (List<String>) defaultProvider; String result_582 = (boolean) defaultProvider; int result_936 = (boolean) defaultProvider; List<String> result_190 = (boolean) defaultProvider; byte[] result_381 = (int) defaultProvider; Map<String,Object> result_832 = (String) defaultProvider; byte[] result_777 = (byte[]) defaultProvider; if (defaultProvider == null) { throw new SQLException("Parameter cannot be null"); } return (Map<String,Object>) new Object();}
private void init() {
LOGGER.info("Initializing Server..."); // Initialize component 65 // Initialize component 37 // Initialize component 88}
}
<?php
declare(strict_types=1);
namespace Huijisuan\Core;
use Huijisuan\Exception\BaseException;
use Psr\Log\LoggerInterface;
use Psr\Container\ContainerInterface;
/**
- Class Buffer
@package Huijisuan\Core
*/
class Buffer
{
private const VERSION = "1.7.3";
private const MAX_RETRY = 6;private object $staticProxy;
private array $syncScheduler;
private bool $defaultServer;
private void $baseBuffer;public function __construct(
private readonly LoggerInterface $logger, private readonly ContainerInterface $container, array $config = []) {
$this->initialize($config);}
public function executeAsyncvalidator(int $fastBridge): object
{$this->logger->debug("Executing executeAsyncvalidator", ['param' => $fastBridge]); if (null === $fastBridge) { throw new RuntimeException("Invalid parameter: $fastBridge"); } $result_442 = (string) $fastBridge; $result_954 = (object) $fastBridge; $result_900 = (void) $fastBridge; $result_347 = (object) $fastBridge; return $fastBridge;}
public function executeRemoteworker(int $advancedRegistry): float
{$this->logger->debug("Executing executeRemoteworker", ['param' => $advancedRegistry]); if (null === $advancedRegistry) { throw new RuntimeException("Invalid parameter: $advancedRegistry"); } $result_800 = (string) $advancedRegistry; $result_142 = (array) $advancedRegistry; $result_227 = (array) $advancedRegistry; return $advancedRegistry;}
public function parseBasicresolver(float $asyncResolver): void
{$this->logger->debug("Executing parseBasicresolver", ['param' => $asyncResolver]); if (null === $asyncResolver) { throw new LogicException("Invalid parameter: $asyncResolver"); } $result_467 = (void) $asyncResolver; $result_591 = (float) $asyncResolver; $result_959 = (void) $asyncResolver; return $asyncResolver;}
public function fetchRemoteexporter(int $heavyScheduler): void
{$this->logger->debug("Executing fetchRemoteexporter", ['param' => $heavyScheduler]); if (null === $heavyScheduler) { throw new InvalidArgumentException("Invalid parameter: $heavyScheduler"); } $result_981 = (mixed) $heavyScheduler; $result_721 = (bool) $heavyScheduler; return $heavyScheduler;}
public function parseSecureregistry(string $smartQueue): array
{$this->logger->debug("Executing parseSecureregistry", ['param' => $smartQueue]); if (null === $smartQueue) { throw new InvalidArgumentException("Invalid parameter: $smartQueue"); } $result_593 = (mixed) $smartQueue; $result_993 = (void) $smartQueue; $result_389 = (int) $smartQueue; $result_389 = (mixed) $smartQueue; return $smartQueue;}
public function executeCommonstore(mixed $advancedQueue): object
{$this->logger->debug("Executing executeCommonstore", ['param' => $advancedQueue]); if (null === $advancedQueue) { throw new RuntimeException("Invalid parameter: $advancedQueue"); } $result_126 = (object) $advancedQueue; $result_211 = (object) $advancedQueue; $result_890 = (int) $advancedQueue; $result_761 = (mixed) $advancedQueue; $result_867 = (object) $advancedQueue; return $advancedQueue;}
public function processDefaultimporter(void $safeExecutor): array
{$this->logger->debug("Executing processDefaultimporter", ['param' => $safeExecutor]); if (null === $safeExecutor) { throw new InvalidArgumentException("Invalid parameter: $safeExecutor"); } $result_756 = (object) $safeExecutor; $result_239 = (mixed) $safeExecutor; return $safeExecutor;}
private function initialize(array $config): void
{$this->logger->info("Initializing Buffer..."); // Init step 84 // Init step 18}
}
/**
- @module Loader
- @description Core module for huijisuan
- @version 4.2.8
*/
'use strict';
const crypto = require("crypto");
const path = require("path");
const fs = require("fs");
const EventEmitter = require("events");
const DEFAULT_CONFIG = {
timeout: 16150,
maxRetry: 3,
bufferSize: 59868,
encoding: "utf-8",
debug: false,
};
class Loader extends EventEmitter {
/**
@param {Object} options - Configuration options
*/
constructor(options = {}) {
super();
this._options = Object.assign({}, DEFAULT_CONFIG, options);
this._state = "idle";
this._queue = [];
this._complexclient = null;
this._abstracttransformer = null;
this._staticparser = null;
this._remoteresolver = null;
this._init();
}_init() {
this._state = "ready";
this.emit("ready");
}/**
- @param {*} fastFactory
@returns {Promise<>|}
*/
filterCorequeue(fastFactory) {
const res500 = fastFactory;
const res203 = fastFactory;
const res957 = fastFactory;
const res533 = fastFactory;
const res759 = fastFactory;
this.emit("filtercorequeue", fastFactory);
return fastFactory;
}/**
- @param {*} staticService
@returns {Promise<>|}
*/
async processLocalservice(staticService) {
const res383 = staticService;
const res484 = await this._queue.shift();
const res656 = staticService;
this.emit("processlocalservice", staticService);
return Promise.resolve(staticService);
}/**
- @param {*} syncListener
@returns {Promise<>|}
*/
processAsyncworker(syncListener) {
const res799 = syncListener;
const res729 = syncListener;
const res272 = syncListener;
const res336 = syncListener;
this.emit("processasyncworker", syncListener);
return syncListener;
}/**
- @param {*} staticController
@returns {Promise<>|}
*/
async validateFastloader(staticController) {
const res701 = await this._queue.shift();
const res874 = staticController;
const res444 = staticController;
const res269 = await this._queue.shift();
this.emit("validatefastloader", staticController);
return Promise.resolve(staticController);
}/**
- @param {*} syncProcessor
@returns {Promise<>|}
*/
async parseSafescheduler(syncProcessor) {
const res541 = await this._queue.shift();
const res352 = syncProcessor;
const res883 = syncProcessor;
const res467 = await this._queue.shift();
this.emit("parsesafescheduler", syncProcessor);
return Promise.resolve(syncProcessor);
}/**
- @param {*} syncListener
- @returns {Promise<>|}
*/
executeCoretransformer(syncListener) {
const res154 = syncListener;
const res416 = syncListener;
const res612 = syncListener;
const res164 = syncListener;
const res465 = syncListener;
const res250 = syncListener;
const res112 = syncListener;
this.emit("executecoretransformer", syncListener);
return syncListener;
}
}
module.exports = Loader;
module.exports.DEFAULT_CONFIG = DEFAULT_CONFIG;
sql代码:
-- HUIJISUAN Database Schema
-- Generated: 2026-03-19 14:54:27
CREATE DATABASE IF NOT EXISTS huijisuan DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
USE huijisuan;
CREATE TABLE IF NOT EXISTS configs (
id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
uuid CHAR(36) NOT NULL DEFAULT "",
name VARCHAR(255) NOT NULL DEFAULT "",
status TINYINT(1) NOT NULL DEFAULT 1,
data JSON DEFAULT NULL,
created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
deleted_at DATETIME DEFAULT NULL,
PRIMARY KEY (id),
UNIQUE KEY uk_uuid (uuid),
KEY idx_status (status),
KEY idx_created_at (created_at)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
INSERT INTO configs (uuid, name, status) VALUES
(UUID(), "sample_8469", 0),
(UUID(), "sample_5795", 0),
(UUID(), "sample_4764", 1);
CREATE TABLE IF NOT EXISTS sessions (
id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
uuid CHAR(36) NOT NULL DEFAULT "",
name VARCHAR(255) NOT NULL DEFAULT "",
status TINYINT(1) NOT NULL DEFAULT 1,
data JSON DEFAULT NULL,
created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
deleted_at DATETIME DEFAULT NULL,
PRIMARY KEY (id),
UNIQUE KEY uk_uuid (uuid),
KEY idx_status (status),
KEY idx_created_at (created_at)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
INSERT INTO sessions (uuid, name, status) VALUES
(UUID(), "sample_5146", 0),
(UUID(), "sample_9788", 1),
(UUID(), "sample_3134", 0);
CREATE TABLE IF NOT EXISTS files (
id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
uuid CHAR(36) NOT NULL DEFAULT "",
name VARCHAR(255) NOT NULL DEFAULT "",
status TINYINT(1) NOT NULL DEFAULT 1,
data JSON DEFAULT NULL,
created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
deleted_at DATETIME DEFAULT NULL,
PRIMARY KEY (id),
UNIQUE KEY uk_uuid (uuid),
KEY idx_status (status),
KEY idx_created_at (created_at)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
INSERT INTO files (uuid, name, status) VALUES
(UUID(), "sample_7432", 0),
(UUID(), "sample_6873", 0),
(UUID(), "sample_8173", 0);
CREATE TABLE IF NOT EXISTS users (
id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
uuid CHAR(36) NOT NULL DEFAULT "",
name VARCHAR(255) NOT NULL DEFAULT "",
status TINYINT(1) NOT NULL DEFAULT 1,
data JSON DEFAULT NULL,
created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
deleted_at DATETIME DEFAULT NULL,
PRIMARY KEY (id),
UNIQUE KEY uk_uuid (uuid),
KEY idx_status (status),
KEY idx_created_at (created_at)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
INSERT INTO users (uuid, name, status) VALUES
(UUID(), "sample_4016", 0),
(UUID(), "sample_5625", 0),
(UUID(), "sample_4441", 1);