1195 lines
2.5 MiB
MySQL
1195 lines
2.5 MiB
MySQL
|
-- MySQL dump 10.13 Distrib 8.4.6, for Linux (aarch64)
|
|||
|
|
--
|
|||
|
|
-- Host: localhost Database: assetx
|
|||
|
|
-- ------------------------------------------------------
|
|||
|
|
-- Server version 8.4.6
|
|||
|
|
|
|||
|
|
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
|
|||
|
|
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
|
|||
|
|
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
|
|||
|
|
/*!50503 SET NAMES utf8mb4 */;
|
|||
|
|
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
|
|||
|
|
/*!40103 SET TIME_ZONE='+00:00' */;
|
|||
|
|
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
|
|||
|
|
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
|
|||
|
|
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
|
|||
|
|
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Table structure for table `alp_snapshots`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
DROP TABLE IF EXISTS `alp_snapshots`;
|
|||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|||
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|||
|
|
CREATE TABLE `alp_snapshots` (
|
|||
|
|
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
|
|||
|
|
`pool_value` decimal(30,18) DEFAULT NULL,
|
|||
|
|
`usdy_supply` decimal(30,18) DEFAULT NULL,
|
|||
|
|
`fee_surplus` decimal(30,18) DEFAULT NULL,
|
|||
|
|
`alp_price` decimal(30,18) DEFAULT NULL,
|
|||
|
|
`snapshot_time` datetime(3) NOT NULL,
|
|||
|
|
`created_at` datetime(3) DEFAULT NULL,
|
|||
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|||
|
|
KEY `idx_alp_snapshots_snapshot_time` (`snapshot_time`) USING BTREE
|
|||
|
|
) ENGINE=InnoDB AUTO_INCREMENT=414 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
|
|||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Dumping data for table `alp_snapshots`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
LOCK TABLES `alp_snapshots` WRITE;
|
|||
|
|
/*!40000 ALTER TABLE `alp_snapshots` DISABLE KEYS */;
|
|||
|
|
INSERT INTO `alp_snapshots` VALUES (1,117.137700000000000000,116.136800000000000000,1.000900000000001500,1.019928999999999900,'2026-02-28 07:17:08.012','2026-02-28 07:17:08.013'),(2,117.137700000000000000,116.136800000000000000,1.000900000000001500,1.019929410285496600,'2026-02-28 07:21:30.475','2026-02-28 07:21:30.475'),(3,118.137700000000000000,117.133800000000000000,1.003900000000001600,1.019955311127762600,'2026-02-28 08:21:31.703','2026-02-28 08:21:31.703'),(4,118.137700000000000000,117.133800000000000000,1.003900000000001600,1.019955311127762600,'2026-02-28 08:22:35.984','2026-02-28 08:22:35.984'),(5,118.137700000000000000,117.133800000000000000,1.003900000000001600,1.019955311127762600,'2026-02-28 08:26:51.784','2026-02-28 08:26:51.784'),(6,118.137700000000000000,117.133800000000000000,1.003900000000001600,1.019955311127762600,'2026-02-28 08:49:08.716','2026-02-28 08:49:08.716'),(7,118.137700000000000000,117.133800000000000000,1.003900000000001600,1.019955311127762600,'2026-02-28 08:59:21.132','2026-02-28 08:59:21.132'),(8,118.137700000000000000,117.133800000000000000,1.003900000000001600,1.019955311127762600,'2026-02-28 09:07:50.145','2026-02-28 09:07:50.146'),(9,118.153076600000000000,117.133800000000000000,1.019276600000012000,1.020088066758159000,'2026-02-28 10:07:51.404','2026-02-28 10:07:51.405'),(10,118.153076600000000000,117.133800000000000000,1.019276600000012000,1.020088066758159000,'2026-02-28 11:07:51.577','2026-02-28 11:07:51.577'),(11,118.153076600000000000,117.133800000000000000,1.019276600000012000,1.020088066758159000,'2026-02-28 12:07:51.452','2026-02-28 12:07:51.452'),(12,118.153076600000000000,117.133800000000000000,1.019276600000012000,1.020088066758159000,'2026-02-28 13:07:51.438','2026-02-28 13:07:51.438'),(13,118.153076600000000000,117.133800000000000000,1.019276600000012000,1.020088066758159000,'2026-02-28 14:07:51.520','2026-02-28 14:07:51.520'),(14,118.153076600000000000,117.133800000000000000,1.019276600000012000,1.020088066758159000,'2026-02-28 15:07:51.541','2026-02-28 15:07:51.542'),(15,118.153076600000000000,117.133800000000000000,1.019276600000012000,1.020088066758159000,'2026-02-28 16:07:51.437','2026-02-28 16:07:51.438'),(16,118.153076600000000000,117.133800000000000000,1.019276600000012000,1.020088066758159000,'2026-02-28 17:07:51.354','2026-02-28 17:07:51.354'),(17,118.153076600000000000,117.133800000000000000,1.019276600000012000,1.020088066758159000,'2026-02-28 18:07:51.442','2026-02-28 18:07:51.443'),(18,118.153076600000000000,117.133800000000000000,1.019276600000012000,1.020088066758159000,'2026-02-28 19:07:51.347','2026-02-28 19:07:51.347'),(19,118.153076600000000000,117.133800000000000000,1.019276600000012000,1.020088066758159000,'2026-02-28 20:07:51.424','2026-02-28 20:07:51.424'),(20,118.153076600000000000,117.133800000000000000,1.019276600000012000,1.020088066758159000,'2026-02-28 21:07:51.451','2026-02-28 21:07:51.451'),(21,118.153076600000000000,117.133800000000000000,1.019276600000012000,1.020088066758159000,'2026-02-28 22:07:51.386','2026-02-28 22:07:51.386'),(22,118.153076600000000000,117.133800000000000000,1.019276600000012000,1.020088066758159000,'2026-02-28 23:07:51.119','2026-02-28 23:07:51.119'),(23,118.153076600000000000,117.133800000000000000,1.019276600000012000,1.020088066758159000,'2026-03-01 00:07:51.468','2026-03-01 00:07:51.468'),(24,118.153076600000000000,117.133800000000000000,1.019276600000012000,1.020088066758159000,'2026-03-01 01:07:51.475','2026-03-01 01:07:51.475'),(25,118.153076600000000000,117.133800000000000000,1.019276600000012000,1.020088066758159000,'2026-03-01 02:07:51.126','2026-03-01 02:07:51.126'),(26,118.153076600000000000,117.133800000000000000,1.019276600000012000,1.020088066758159000,'2026-03-01 03:07:51.449','2026-03-01 03:07:51.449'),(27,118.153076600000000000,117.133800000000000000,1.019276600000012000,1.020088066758159000,'2026-03-01 04:07:51.585','2026-03-01 04:07:51.586'),(28,118.153076600000000000,117.133800000000000000,1.019276600000012000,1.020088066758159000,'2026-03-01 05:07:51.093','2026-03-01 05:07:51.093'),(29,118.1
|
|||
|
|
/*!40000 ALTER TABLE `alp_snapshots` ENABLE KEYS */;
|
|||
|
|
UNLOCK TABLES;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Table structure for table `apy_snapshots`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
DROP TABLE IF EXISTS `apy_snapshots`;
|
|||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|||
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|||
|
|
CREATE TABLE `apy_snapshots` (
|
|||
|
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
|||
|
|
`asset_id` bigint NOT NULL,
|
|||
|
|
`chain_id` bigint NOT NULL,
|
|||
|
|
`contract_address` varchar(42) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
|||
|
|
`apy_value` decimal(10,4) DEFAULT NULL,
|
|||
|
|
`supply_apy` decimal(20,4) DEFAULT NULL,
|
|||
|
|
`borrow_apy` decimal(20,4) DEFAULT NULL,
|
|||
|
|
`total_assets` decimal(30,18) DEFAULT NULL,
|
|||
|
|
`total_supply` decimal(30,18) DEFAULT NULL,
|
|||
|
|
`price` decimal(30,18) DEFAULT NULL,
|
|||
|
|
`snapshot_time` datetime(3) NOT NULL,
|
|||
|
|
`created_at` datetime(3) DEFAULT NULL,
|
|||
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|||
|
|
KEY `idx_asset_time` (`asset_id`,`snapshot_time` DESC) USING BTREE,
|
|||
|
|
CONSTRAINT `apy_snapshots_ibfk_1` FOREIGN KEY (`asset_id`) REFERENCES `assets` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
|
|||
|
|
) ENGINE=InnoDB AUTO_INCREMENT=12664 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='APY快照表（每1-2小时）';
|
|||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Dumping data for table `apy_snapshots`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
LOCK TABLES `apy_snapshots` WRITE;
|
|||
|
|
/*!40000 ALTER TABLE `apy_snapshots` DISABLE KEYS */;
|
|||
|
|
INSERT INTO `apy_snapshots` VALUES (37,7,97,'0x7f9eEA491eE53045594ee4669327f0355aCd0e58',0.0000,0.0000,0.0000,1366.000000000015000000,1365.922801670015000000,1.000000000000000000,'2026-02-28 03:30:20.727','2026-02-28 03:30:20.727'),(38,8,97,'0x20B94C5E5b7361552E0548161a58696aA6FeDBd4',0.0000,0.0000,0.0000,100.000000000000000000,99.983305000000000000,1.000000000000000000,'2026-02-28 03:30:20.850','2026-02-28 03:30:20.850'),(39,9,97,'0x0EF308D70cf35460E26a3Eb42F3442Ff28cbE07C',0.0000,0.0000,0.0000,12.000000000000000000,11.999681040000000000,1.000000000000000000,'2026-02-28 03:30:20.968','2026-02-28 03:30:20.969'),(40,7,97,'0x7f9eEA491eE53045594ee4669327f0355aCd0e58',0.0000,0.0000,0.0000,1366.000000000015000000,1365.922801670015000000,1.000000000000000000,'2026-02-28 03:30:24.096','2026-02-28 03:30:24.096'),(41,8,97,'0x20B94C5E5b7361552E0548161a58696aA6FeDBd4',0.0000,0.0000,0.0000,100.000000000000000000,99.983305000000000000,1.000000000000000000,'2026-02-28 03:30:24.218','2026-02-28 03:30:24.218'),(42,9,97,'0x0EF308D70cf35460E26a3Eb42F3442Ff28cbE07C',0.0000,0.0000,0.0000,12.000000000000000000,11.999681040000000000,1.000000000000000000,'2026-02-28 03:30:24.346','2026-02-28 03:30:24.347'),(43,7,97,'0x7f9eEA491eE53045594ee4669327f0355aCd0e58',0.0000,0.0000,0.0000,1366.000000000015000000,1365.922801670015000000,1.000000000000000000,'2026-02-28 03:30:27.090','2026-02-28 03:30:27.090'),(44,8,97,'0x20B94C5E5b7361552E0548161a58696aA6FeDBd4',0.0000,0.0000,0.0000,100.000000000000000000,99.983305000000000000,1.000000000000000000,'2026-02-28 03:30:27.213','2026-02-28 03:30:27.213'),(45,9,97,'0x0EF308D70cf35460E26a3Eb42F3442Ff28cbE07C',0.0000,0.0000,0.0000,12.000000000000000000,11.999681040000000000,1.000000000000000000,'2026-02-28 03:30:27.332','2026-02-28 03:30:27.332'),(46,7,97,'0x7f9eEA491eE53045594ee4669327f0355aCd0e58',0.0000,0.0000,0.0000,1366.000000000015000000,1365.922801670015000000,1.000000000000000000,'2026-02-28 03:30:30.091','2026-02-28 03:30:30.091'),(47,8,97,'0x20B94C5E5b7361552E0548161a58696aA6FeDBd4',0.0000,0.0000,0.0000,100.000000000000000000,99.983305000000000000,1.000000000000000000,'2026-02-28 03:30:30.213','2026-02-28 03:30:30.213'),(48,9,97,'0x0EF308D70cf35460E26a3Eb42F3442Ff28cbE07C',0.0000,0.0000,0.0000,12.000000000000000000,11.999681040000000000,1.000000000000000000,'2026-02-28 03:30:30.329','2026-02-28 03:30:30.329'),(49,7,97,'0x7f9eEA491eE53045594ee4669327f0355aCd0e58',0.0000,0.0000,0.0000,1366.000000000015000000,1365.922801670015000000,1.000000000000000000,'2026-02-28 03:30:33.090','2026-02-28 03:30:33.090'),(50,8,97,'0x20B94C5E5b7361552E0548161a58696aA6FeDBd4',0.0000,0.0000,0.0000,100.000000000000000000,99.983305000000000000,1.000000000000000000,'2026-02-28 03:30:33.218','2026-02-28 03:30:33.218'),(51,9,97,'0x0EF308D70cf35460E26a3Eb42F3442Ff28cbE07C',0.0000,0.0000,0.0000,12.000000000000000000,11.999681040000000000,1.000000000000000000,'2026-02-28 03:30:33.337','2026-02-28 03:30:33.337'),(52,7,97,'0x7f9eEA491eE53045594ee4669327f0355aCd0e58',0.0000,0.0000,0.0000,1366.000000000015000000,1365.922801670015000000,1.000000000000000000,'2026-02-28 03:30:36.095','2026-02-28 03:30:36.095'),(53,8,97,'0x20B94C5E5b7361552E0548161a58696aA6FeDBd4',0.0000,0.0000,0.0000,100.000000000000000000,99.983305000000000000,1.000000000000000000,'2026-02-28 03:30:36.212','2026-02-28 03:30:36.212'),(54,9,97,'0x0EF308D70cf35460E26a3Eb42F3442Ff28cbE07C',0.0000,0.0000,0.0000,12.000000000000000000,11.999681040000000000,1.000000000000000000,'2026-02-28 03:30:36.332','2026-02-28 03:30:36.332'),(55,7,97,'0x7f9eEA491eE53045594ee4669327f0355aCd0e58',0.0000,0.0000,0.0000,1366.000000000015000000,1365.922801670015000000,1.000000000000000000,'2026-02-28 03:30:39.085','2026-02-28 03:30:39.085'),(56,8,97,'0x20B94C5E5b7361552E0548161a58696aA6FeDBd4',0.0000,0.0000,0.0000,100.000000000000000000,99.983305000000000000,1.000000000000000000,'2026-02-28 03:30:39.205','2026-02-28 03:30:39.205'),(57,9,97,'0x0EF308D70cf35460E26a3Eb42F3442Ff28cbE07C',0.0000,0.0000,0.0000,12.000000000000000000,11.999681040000000000,1.000000000000000000,'2026-02-28 03:30:39.320'
|
|||
|
|
INSERT INTO `apy_snapshots` VALUES (5265,8,97,'0x20B94C5E5b7361552E0548161a58696aA6FeDBd4',0.0000,0.0000,0.0000,100152.000000000000000000,100157.984150900000000000,1.000000000000000000,'2026-03-19 16:06:27.203','2026-03-19 16:06:27.203'),(5266,9,97,'0x0EF308D70cf35460E26a3Eb42F3442Ff28cbE07C',0.0000,0.0000,0.0000,144.000000000000000000,144.002010470000000000,1.000000000000000000,'2026-03-19 16:06:27.306','2026-03-19 16:06:27.306'),(5267,7,97,'0x7f9eEA491eE53045594ee4669327f0355aCd0e58',0.0000,0.0000,0.0000,3366.000000000015000000,3348.042712830015000000,1.010000000000000000,'2026-03-19 16:11:27.115','2026-03-19 16:11:27.115'),(5268,8,97,'0x20B94C5E5b7361552E0548161a58696aA6FeDBd4',0.0000,0.0000,0.0000,100152.000000000000000000,100157.984150900000000000,1.000000000000000000,'2026-03-19 16:11:27.221','2026-03-19 16:11:27.221'),(5269,9,97,'0x0EF308D70cf35460E26a3Eb42F3442Ff28cbE07C',0.0000,0.0000,0.0000,144.000000000000000000,144.002010470000000000,1.000000000000000000,'2026-03-19 16:11:27.328','2026-03-19 16:11:27.328'),(5270,7,97,'0x7f9eEA491eE53045594ee4669327f0355aCd0e58',0.0000,0.0000,0.0000,3366.000000000015000000,3348.042712830015000000,1.010000000000000000,'2026-03-19 16:16:27.115','2026-03-19 16:16:27.115'),(5271,8,97,'0x20B94C5E5b7361552E0548161a58696aA6FeDBd4',0.0000,0.0000,0.0000,100152.000000000000000000,100157.984150900000000000,1.000000000000000000,'2026-03-19 16:16:27.220','2026-03-19 16:16:27.220'),(5272,10,97,'0xfdbFD4656b74aD16F23264121eD9F58219f5C3Cf',0.0000,0.2851,1.9752,2000.185502118826000000,190.107148015740340000,0.000000000000000000,'2026-03-19 16:16:27.276','2026-03-19 16:16:27.276'),(5273,9,97,'0x0EF308D70cf35460E26a3Eb42F3442Ff28cbE07C',0.0000,0.0000,0.0000,144.000000000000000000,144.002010470000000000,1.000000000000000000,'2026-03-19 16:16:27.323','2026-03-19 16:16:27.323'),(5274,7,97,'0x7f9eEA491eE53045594ee4669327f0355aCd0e58',0.0000,0.0000,0.0000,3366.000000000015000000,3348.042712830015000000,1.010000000000000000,'2026-03-19 16:21:27.104','2026-03-19 16:21:27.104'),(5275,8,97,'0x20B94C5E5b7361552E0548161a58696aA6FeDBd4',0.0000,0.0000,0.0000,100152.000000000000000000,100157.984150900000000000,1.000000000000000000,'2026-03-19 16:21:27.200','2026-03-19 16:21:27.200'),(5276,9,97,'0x0EF308D70cf35460E26a3Eb42F3442Ff28cbE07C',0.0000,0.0000,0.0000,144.000000000000000000,144.002010470000000000,1.000000000000000000,'2026-03-19 16:21:27.295','2026-03-19 16:21:27.296'),(5277,7,97,'0x7f9eEA491eE53045594ee4669327f0355aCd0e58',0.0000,0.0000,0.0000,3366.000000000015000000,3348.042712830015000000,1.010000000000000000,'2026-03-19 16:26:27.110','2026-03-19 16:26:27.110'),(5278,8,97,'0x20B94C5E5b7361552E0548161a58696aA6FeDBd4',0.0000,0.0000,0.0000,100152.000000000000000000,100157.984150900000000000,1.000000000000000000,'2026-03-19 16:26:27.208','2026-03-19 16:26:27.208'),(5279,9,97,'0x0EF308D70cf35460E26a3Eb42F3442Ff28cbE07C',0.0000,0.0000,0.0000,144.000000000000000000,144.002010470000000000,1.000000000000000000,'2026-03-19 16:26:27.309','2026-03-19 16:26:27.309'),(5280,7,97,'0x7f9eEA491eE53045594ee4669327f0355aCd0e58',0.0000,0.0000,0.0000,3366.000000000015000000,3348.042712830015000000,1.010000000000000000,'2026-03-19 16:31:27.107','2026-03-19 16:31:27.107'),(5281,8,97,'0x20B94C5E5b7361552E0548161a58696aA6FeDBd4',0.0000,0.0000,0.0000,100152.000000000000000000,100157.984150900000000000,1.000000000000000000,'2026-03-19 16:31:27.207','2026-03-19 16:31:27.207'),(5282,10,97,'0xfdbFD4656b74aD16F23264121eD9F58219f5C3Cf',0.0000,0.2851,1.9752,2000.185502118826000000,190.107148015740340000,0.000000000000000000,'2026-03-19 16:31:27.254','2026-03-19 16:31:27.254'),(5283,9,97,'0x0EF308D70cf35460E26a3Eb42F3442Ff28cbE07C',0.0000,0.0000,0.0000,144.000000000000000000,144.002010470000000000,1.000000000000000000,'2026-03-19 16:31:27.305','2026-03-19 16:31:27.305'),(5284,7,97,'0x7f9eEA491eE53045594ee4669327f0355aCd0e58',0.0000,0.0000,0.0000,3366.000000000015000000,3348.042712830015000000,1.010000000000000000,'2026-03-19 16:36:27.117','2026-03-19 16:36:27.117'),(5285,8,97,'0x20B94C5E5b7361552E0548161a58696aA6FeDBd4',0.0000,0.000
|
|||
|
|
INSERT INTO `apy_snapshots` VALUES (10479,9,97,'0x0EF308D70cf35460E26a3Eb42F3442Ff28cbE07C',0.0000,0.0000,0.0000,144.000000000000000000,144.002010470000000000,1.000000000000000000,'2026-03-25 02:26:27.323','2026-03-25 02:26:27.323'),(10480,7,97,'0x7f9eEA491eE53045594ee4669327f0355aCd0e58',0.0000,0.0000,0.0000,3366.000000000015000000,3348.042712830015000000,1.010000000000000000,'2026-03-25 02:31:27.113','2026-03-25 02:31:27.113'),(10481,8,97,'0x20B94C5E5b7361552E0548161a58696aA6FeDBd4',0.0000,0.0000,0.0000,100152.000000000000000000,100157.984150900000000000,1.000000000000000000,'2026-03-25 02:31:27.228','2026-03-25 02:31:27.228'),(10482,10,97,'0xfdbFD4656b74aD16F23264121eD9F58219f5C3Cf',0.0000,0.2851,1.9752,2000.185502118826000000,190.107148015740340000,0.000000000000000000,'2026-03-25 02:31:27.278','2026-03-25 02:31:27.278'),(10483,9,97,'0x0EF308D70cf35460E26a3Eb42F3442Ff28cbE07C',0.0000,0.0000,0.0000,144.000000000000000000,144.002010470000000000,1.000000000000000000,'2026-03-25 02:31:27.335','2026-03-25 02:31:27.335'),(10484,7,97,'0x7f9eEA491eE53045594ee4669327f0355aCd0e58',0.0000,0.0000,0.0000,3366.000000000015000000,3348.042712830015000000,1.010000000000000000,'2026-03-25 02:36:27.107','2026-03-25 02:36:27.107'),(10485,8,97,'0x20B94C5E5b7361552E0548161a58696aA6FeDBd4',0.0000,0.0000,0.0000,100152.000000000000000000,100157.984150900000000000,1.000000000000000000,'2026-03-25 02:36:27.205','2026-03-25 02:36:27.206'),(10486,9,97,'0x0EF308D70cf35460E26a3Eb42F3442Ff28cbE07C',0.0000,0.0000,0.0000,144.000000000000000000,144.002010470000000000,1.000000000000000000,'2026-03-25 02:36:27.301','2026-03-25 02:36:27.301'),(10487,7,97,'0x7f9eEA491eE53045594ee4669327f0355aCd0e58',0.0000,0.0000,0.0000,3366.000000000015000000,3348.042712830015000000,1.010000000000000000,'2026-03-25 02:41:27.106','2026-03-25 02:41:27.106'),(10488,8,97,'0x20B94C5E5b7361552E0548161a58696aA6FeDBd4',0.0000,0.0000,0.0000,100152.000000000000000000,100157.984150900000000000,1.000000000000000000,'2026-03-25 02:41:27.204','2026-03-25 02:41:27.204'),(10489,9,97,'0x0EF308D70cf35460E26a3Eb42F3442Ff28cbE07C',0.0000,0.0000,0.0000,144.000000000000000000,144.002010470000000000,1.000000000000000000,'2026-03-25 02:41:27.303','2026-03-25 02:41:27.303'),(10490,7,97,'0x7f9eEA491eE53045594ee4669327f0355aCd0e58',0.0000,0.0000,0.0000,3366.000000000015000000,3348.042712830015000000,1.010000000000000000,'2026-03-25 02:46:27.109','2026-03-25 02:46:27.109'),(10491,8,97,'0x20B94C5E5b7361552E0548161a58696aA6FeDBd4',0.0000,0.0000,0.0000,100152.000000000000000000,100157.984150900000000000,1.000000000000000000,'2026-03-25 02:46:27.208','2026-03-25 02:46:27.208'),(10492,10,97,'0xfdbFD4656b74aD16F23264121eD9F58219f5C3Cf',0.0000,0.2851,1.9752,2000.185502118826000000,190.107148015740340000,0.000000000000000000,'2026-03-25 02:46:27.258','2026-03-25 02:46:27.259'),(10493,9,97,'0x0EF308D70cf35460E26a3Eb42F3442Ff28cbE07C',0.0000,0.0000,0.0000,144.000000000000000000,144.002010470000000000,1.000000000000000000,'2026-03-25 02:46:27.312','2026-03-25 02:46:27.313'),(10494,7,97,'0x7f9eEA491eE53045594ee4669327f0355aCd0e58',0.0000,0.0000,0.0000,3366.000000000015000000,3348.042712830015000000,1.010000000000000000,'2026-03-25 02:51:27.111','2026-03-25 02:51:27.111'),(10495,8,97,'0x20B94C5E5b7361552E0548161a58696aA6FeDBd4',0.0000,0.0000,0.0000,100152.000000000000000000,100157.984150900000000000,1.000000000000000000,'2026-03-25 02:51:27.213','2026-03-25 02:51:27.213'),(10496,9,97,'0x0EF308D70cf35460E26a3Eb42F3442Ff28cbE07C',0.0000,0.0000,0.0000,144.000000000000000000,144.002010470000000000,1.000000000000000000,'2026-03-25 02:51:27.321','2026-03-25 02:51:27.321'),(10497,7,97,'0x7f9eEA491eE53045594ee4669327f0355aCd0e58',0.0000,0.0000,0.0000,3366.000000000015000000,3348.042712830015000000,1.010000000000000000,'2026-03-25 02:56:27.109','2026-03-25 02:56:27.110'),(10498,8,97,'0x20B94C5E5b7361552E0548161a58696aA6FeDBd4',0.0000,0.0000,0.0000,100152.000000000000000000,100157.984150900000000000,1.000000000000000000,'2026-03-25 02:56:27.217','2026-03-25 02:56:27.217'),(10499,9,97,'0x0EF308D70cf35460E26a3Eb42F3442Ff2
|
|||
|
|
/*!40000 ALTER TABLE `apy_snapshots` ENABLE KEYS */;
|
|||
|
|
UNLOCK TABLES;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Table structure for table `asset_audit_reports`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
DROP TABLE IF EXISTS `asset_audit_reports`;
|
|||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|||
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|||
|
|
CREATE TABLE `asset_audit_reports` (
|
|||
|
|
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
|||
|
|
`asset_id` bigint NOT NULL COMMENT '关联资产ID（外键 assets.id）',
|
|||
|
|
`report_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '报告类型：attestation=持仓证明，audit=安全审计，compliance=合规审查',
|
|||
|
|
`report_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '报告标题',
|
|||
|
|
`report_date` datetime NOT NULL COMMENT '报告发布日期',
|
|||
|
|
`report_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '报告 PDF 下载链接',
|
|||
|
|
`auditor_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '审计机构名称',
|
|||
|
|
`summary` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '报告摘要，前端详情页展示',
|
|||
|
|
`is_active` tinyint(1) DEFAULT '1' COMMENT '是否展示：1=展示，0=隐藏',
|
|||
|
|
`display_order` int DEFAULT '0' COMMENT '展示排序（数字越小越靠前）',
|
|||
|
|
`created_at` datetime(3) DEFAULT NULL COMMENT '记录创建时间',
|
|||
|
|
`updated_at` datetime(3) DEFAULT NULL COMMENT '记录最后更新时间',
|
|||
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|||
|
|
KEY `idx_asset_date` (`asset_id`,`report_date` DESC) USING BTREE,
|
|||
|
|
KEY `idx_active` (`is_active`) USING BTREE,
|
|||
|
|
KEY `idx_asset_audit_reports_asset_id` (`asset_id`) USING BTREE,
|
|||
|
|
CONSTRAINT `asset_audit_reports_ibfk_1` FOREIGN KEY (`asset_id`) REFERENCES `assets` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
|
|||
|
|
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='资产审计报告表';
|
|||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Dumping data for table `asset_audit_reports`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
LOCK TABLES `asset_audit_reports` WRITE;
|
|||
|
|
/*!40000 ALTER TABLE `asset_audit_reports` DISABLE KEYS */;
|
|||
|
|
INSERT INTO `asset_audit_reports` VALUES (1,7,'attestation','YT-A: SOC 2 Type II Attestation Report','2025-11-30 00:00:00','https://reports.assetx.finance/yt-a/attestation-2025-11.pdf','Ernst & Young LLP','Independent verification of asset custody, security controls, and operational procedures. All controls tested satisfactorily.',1,1,'2026-02-12 15:30:33.000','2026-02-12 15:49:14.000'),(2,7,'attestation','YT-A: Monthly Holdings Verification','2025-10-31 00:00:00','https://reports.assetx.finance/yt-a/attestation-2025-10.pdf','Ernst & Young LLP','Monthly verification of US Treasury holdings and custody arrangements. All holdings verified and match on-chain representations.',1,2,'2026-02-12 15:30:33.000','2026-02-12 15:49:14.000'),(3,7,'audit','YT-A: Smart Contract Security Audit','2025-09-15 00:00:00','https://reports.assetx.finance/yt-a/audit-2025-09.pdf','Trail of Bits','Comprehensive security audit of YT-A smart contracts and custody mechanisms. No critical vulnerabilities found.',1,3,'2026-02-12 15:30:33.000','2026-02-12 15:49:14.000'),(4,8,'attestation','YT-B: Real Estate Valuation and Custody Report','2025-11-30 00:00:00','https://reports.assetx.finance/yt-b/attestation-2025-11.pdf','PricewaterhouseCoopers','Independent property valuation of HK commercial real estate portfolio. All properties professionally valued and custody verified.',1,1,'2026-02-12 15:30:33.000','2026-02-12 15:49:14.000'),(5,8,'compliance','YT-B: Legal Structure and Tokenization Verification','2025-10-31 00:00:00','https://reports.assetx.finance/yt-b/compliance-2025-10.pdf','Baker McKenzie','Legal review of property ownership structure and tokenization framework.',1,2,'2026-02-12 15:30:33.000','2026-02-12 15:49:14.000'),(6,9,'attestation','YT-C: Bond Portfolio Holdings Verification','2025-11-30 00:00:00','https://reports.assetx.finance/yt-c/attestation-2025-11.pdf','Deloitte & Touche LLP','Monthly verification of European bond holdings and custody. All securities verified with custodian.',1,1,'2026-02-12 15:30:33.000','2026-02-12 15:49:14.000'),(7,9,'audit','YT-C: Credit Risk and Portfolio Analysis','2025-10-31 00:00:00','https://reports.assetx.finance/yt-c/audit-2025-10.pdf','Moody\'s Analytics','Independent credit risk assessment of bond portfolio. All holdings meet investment-grade criteria (BBB+ or higher).',1,2,'2026-02-12 15:30:33.000','2026-02-12 15:49:14.000');
|
|||
|
|
/*!40000 ALTER TABLE `asset_audit_reports` ENABLE KEYS */;
|
|||
|
|
UNLOCK TABLES;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Table structure for table `asset_custody`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
DROP TABLE IF EXISTS `asset_custody`;
|
|||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|||
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|||
|
|
CREATE TABLE `asset_custody` (
|
|||
|
|
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
|||
|
|
`asset_id` bigint NOT NULL COMMENT '关联资产ID（外键 assets.id）',
|
|||
|
|
`custodian_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '托管机构名称，如 Morgan Stanley',
|
|||
|
|
`custodian_address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '托管机构实体地址',
|
|||
|
|
`custodian_license` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '托管机构监管牌照编号',
|
|||
|
|
`custody_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '托管类型，如 Prime Broker / Custodian Bank',
|
|||
|
|
`custody_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '资产存放地点，如 New York / Hong Kong',
|
|||
|
|
`auditor_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '审计机构名称，如 Ernst & Young LLP',
|
|||
|
|
`last_audit_date` datetime(3) DEFAULT NULL COMMENT '最近一次审计完成日期',
|
|||
|
|
`audit_report_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '最近审计报告 PDF 链接',
|
|||
|
|
`additional_info` json DEFAULT NULL COMMENT '附加信息（JSON），含 asset_type/custody_value_usd/verification_status 等',
|
|||
|
|
`created_at` datetime(3) DEFAULT NULL COMMENT '记录创建时间',
|
|||
|
|
`updated_at` datetime(3) DEFAULT NULL COMMENT '记录最后更新时间',
|
|||
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|||
|
|
KEY `idx_asset` (`asset_id`) USING BTREE,
|
|||
|
|
KEY `idx_asset_custody_asset_id` (`asset_id`) USING BTREE,
|
|||
|
|
CONSTRAINT `asset_custody_ibfk_1` FOREIGN KEY (`asset_id`) REFERENCES `assets` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
|
|||
|
|
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='Custody托管信息表';
|
|||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Dumping data for table `asset_custody`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
LOCK TABLES `asset_custody` WRITE;
|
|||
|
|
/*!40000 ALTER TABLE `asset_custody` DISABLE KEYS */;
|
|||
|
|
INSERT INTO `asset_custody` VALUES (1,7,'Morgan Stanley','1585 Broadway, New York, NY 10036, USA','SEC License #8-12345','Prime Broker','New York, United States','Ernst & Young LLP','2026-01-15 00:00:00.000','/uploads/custody/1773654301882003900_审计文档.pdf','{\"asset_type\": \"US Treasury Securities\", \"maturity_date\": \"2026-02-05\", \"custody_value_usd\": 12500000, \"verification_status\": \"Verified\"}','2026-02-12 15:20:33.000','2026-03-16 09:45:02.614'),(2,8,'Morgan Stanley修改','1585 Broadway, New York, NY 10036, USA','SEC License #8-12345修改','Prime Broker修改','Hong Kong修改','PricewaterhouseCoopers测试','2026-01-15 00:00:00.000','https://example.com/audit-reports/yt-b-2026-q1.pdf','{\"asset_type\": \"HK Prime Commercial Real Estate\", \"description\": \"Grade-A office properties in Hong Kong CBD\", \"maturity_date\": \"2026-02-05\", \"days_remaining\": 77, \"custody_value_usd\": 1222, \"verification_status\": \"Verified\"}','2026-02-12 15:20:33.000','2026-03-06 17:53:47.436'),(3,9,'Morgan Stanley','1585 Broadway, New York, NY 10036, USA','SEC License #8-12345','Prime Broker','London, United Kingdom','Deloitte & Touche LLP','2026-01-15 00:00:00.000','https://example.com/audit-reports/yt-c-2026-q1.pdf','{\"asset_type\": \"European Investment Grade Bonds\", \"description\": \"Diversified portfolio of European corporate and government bonds\", \"maturity_date\": \"2026-02-05\", \"days_remaining\": 77, \"custody_value_usd\": 12500000.0, \"verification_status\": \"Verified\"}','2026-02-12 15:20:33.000','2026-02-12 15:49:14.000');
|
|||
|
|
/*!40000 ALTER TABLE `asset_custody` ENABLE KEYS */;
|
|||
|
|
UNLOCK TABLES;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Table structure for table `asset_performance`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
DROP TABLE IF EXISTS `asset_performance`;
|
|||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|||
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|||
|
|
CREATE TABLE `asset_performance` (
|
|||
|
|
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
|||
|
|
`asset_id` bigint NOT NULL COMMENT '关联资产ID（外键 assets.id）',
|
|||
|
|
`current_apy` decimal(10,2) DEFAULT NULL COMMENT '当前实际年化收益率（%）',
|
|||
|
|
`tvl_usd` decimal(30,2) DEFAULT NULL COMMENT '总锁仓量（USD）[注：GORM实际写入tvlusd列，此列当前为空；如需使用需加gorm:"column:tvl_usd"标签]',
|
|||
|
|
`total_invested_usd` decimal(30,2) DEFAULT NULL COMMENT '用户总投资金额（USD）',
|
|||
|
|
`investor_count` int DEFAULT '0' COMMENT '当前投资人数',
|
|||
|
|
`cumulative_yield_usd` decimal(30,2) DEFAULT NULL COMMENT '历史累计产生收益（USD）',
|
|||
|
|
`yield_24h_usd` decimal(30,2) DEFAULT NULL COMMENT '过去24小时产生收益（USD）',
|
|||
|
|
`pool_capacity_percent` decimal(10,4) DEFAULT NULL COMMENT '池容量使用率（%），如 75.0000 = 75%',
|
|||
|
|
`circulating_supply` decimal(30,18) DEFAULT NULL COMMENT '代币流通量（含18位小数精度）',
|
|||
|
|
`snapshot_date` date NOT NULL COMMENT '快照日期（每日一条，用于历史数据展示）',
|
|||
|
|
`created_at` datetime(3) DEFAULT NULL COMMENT '记录创建时间',
|
|||
|
|
`tvlusd` decimal(30,2) DEFAULT NULL COMMENT '[GORM实际列] GORM由字段TVLUSD自动映射此列，数据在此，tvl_usd列为空',
|
|||
|
|
`yield24h_usd` decimal(30,2) DEFAULT NULL COMMENT '[GORM实际列] GORM由字段Yield24hUSD自动映射此列，数据在此，yield_24h_usd列为空',
|
|||
|
|
`yt_price` decimal(30,18) DEFAULT '0.000000000000000000',
|
|||
|
|
`volume_24h_usd` decimal(30,2) unsigned DEFAULT '0.00',
|
|||
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|||
|
|
UNIQUE KEY `uk_asset_date` (`asset_id`,`snapshot_date`) USING BTREE,
|
|||
|
|
KEY `idx_asset_performance_asset_id` (`asset_id`) USING BTREE,
|
|||
|
|
CONSTRAINT `asset_performance_ibfk_1` FOREIGN KEY (`asset_id`) REFERENCES `assets` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
|
|||
|
|
) ENGINE=InnoDB AUTO_INCREMENT=82 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='资产性能统计表';
|
|||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Dumping data for table `asset_performance`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
LOCK TABLES `asset_performance` WRITE;
|
|||
|
|
/*!40000 ALTER TABLE `asset_performance` DISABLE KEYS */;
|
|||
|
|
INSERT INTO `asset_performance` VALUES (1,7,22.00,10000000.00,7500000.00,0,0.00,0.00,75.0000,2500000.000000000000000000,'2026-02-12',NULL,NULL,NULL,0.000000000000000000,NULL),(2,8,22.00,10000000.00,7500000.00,0,0.00,0.00,75.0000,2500000.000000000000000000,'2026-02-12',NULL,NULL,NULL,0.000000000000000000,NULL),(3,9,22.00,10000000.00,7500000.00,0,0.00,0.00,75.0000,2500000.000000000000000000,'2026-02-12',NULL,NULL,NULL,0.000000000000000000,NULL),(4,7,0.00,NULL,0.00,0,0.00,NULL,0.0137,1365.922801670015000000,'2026-02-28','2026-02-28 03:14:53.086',1366.00,0.00,1.000000000000000000,NULL),(5,8,0.00,NULL,0.00,0,0.00,NULL,0.0010,99.983305000000000000,'2026-02-28','2026-02-28 03:14:53.207',100.00,0.00,1.000000000000000000,NULL),(6,9,0.00,NULL,0.00,0,0.00,NULL,0.0001,11.999681040000000000,'2026-02-28','2026-02-28 03:14:53.324',12.00,0.00,1.000000000000000000,NULL),(7,7,0.00,NULL,0.00,0,0.00,NULL,0.0137,1365.922801670015000000,'2026-03-01','2026-03-01 00:07:51.248',1366.00,0.00,1.000000000000000000,NULL),(8,8,0.00,NULL,0.00,0,0.00,NULL,0.0010,99.983305000000000000,'2026-03-01','2026-03-01 00:07:51.394',100.00,0.00,1.000000000000000000,NULL),(9,9,0.00,NULL,0.00,0,0.00,NULL,0.0001,11.999681040000000000,'2026-03-01','2026-03-01 00:07:51.529',12.00,0.00,1.000000000000000000,NULL),(10,7,0.00,NULL,0.00,0,0.00,NULL,0.0137,1365.922801670015000000,'2026-03-02','2026-03-02 00:07:51.275',1366.00,0.00,1.000000000000000000,NULL),(11,8,0.00,NULL,0.00,0,0.00,NULL,0.0010,99.983305000000000000,'2026-03-02','2026-03-02 00:07:51.414',100.00,0.00,1.000000000000000000,NULL),(12,9,0.00,NULL,0.00,0,0.00,NULL,0.0001,11.999681040000000000,'2026-03-02','2026-03-02 00:07:51.542',12.00,0.00,1.000000000000000000,NULL),(13,7,0.00,NULL,0.00,0,0.00,NULL,0.0137,1365.922801670015000000,'2026-03-03','2026-03-03 16:43:49.567',1366.00,0.00,1.000000000000000000,NULL),(14,8,0.00,NULL,0.00,0,0.00,NULL,0.0010,99.983305000000000000,'2026-03-03','2026-03-03 16:43:49.737',100.00,0.00,1.000000000000000000,NULL),(15,9,0.00,NULL,0.00,0,0.00,NULL,0.0001,11.999681040000000000,'2026-03-03','2026-03-03 16:43:49.896',12.00,0.00,1.000000000000000000,NULL),(16,7,0.00,NULL,0.00,0,0.00,NULL,0.0137,1367.922832830015000000,'2026-03-04','2026-03-04 10:56:06.140',1368.00,0.00,1.000000000000000000,NULL),(17,8,0.00,NULL,0.00,0,0.00,NULL,0.0010,99.983305000000000000,'2026-03-04','2026-03-04 10:56:06.325',100.00,0.00,1.000000000000000000,NULL),(18,9,0.00,NULL,0.00,0,0.00,NULL,0.0011,112.001239040000000000,'2026-03-04','2026-03-04 10:56:06.596',112.00,0.00,1.000000000000000000,NULL),(19,7,0.00,NULL,0.00,0,0.00,NULL,0.0137,1366.922832830015000000,'2026-03-05','2026-03-05 11:25:06.321',1368.00,0.00,1.000000000000000000,NULL),(20,8,0.00,NULL,0.00,0,0.00,NULL,0.0010,99.983305000000000000,'2026-03-05','2026-03-05 11:25:06.473',100.00,0.00,1.000000000000000000,NULL),(21,9,0.00,NULL,0.00,0,0.00,NULL,0.0011,112.001239040000000000,'2026-03-05','2026-03-05 11:25:06.607',112.00,0.00,1.000000000000000000,NULL),(28,7,365.00,NULL,0.00,0,0.00,NULL,0.0335,3350.042712830015000000,'2026-03-06','2026-03-06 17:14:25.397',3366.00,0.00,1.010000000000000000,0.00),(29,8,0.00,NULL,0.00,0,0.00,NULL,1.0011,100110.983205000000000000,'2026-03-06','2026-03-06 17:14:28.110',100105.00,0.00,1.000000000000000000,5.00),(30,9,0.00,NULL,0.00,0,0.00,NULL,0.0012,115.001179040000000000,'2026-03-06','2026-03-06 17:14:30.815',115.00,0.00,1.000000000000000000,3.00),(31,7,0.00,NULL,0.00,0,0.00,NULL,0.0335,3350.042712830015000000,'2026-03-09','2026-03-09 09:41:30.894',3366.00,0.00,1.010000000000000000,0.00),(32,8,0.00,NULL,0.00,0,0.00,NULL,1.0011,100110.983205000000000000,'2026-03-09','2026-03-09 09:41:33.605',100105.00,0.00,1.000000000000000000,0.00),(33,9,0.00,NULL,0.00,0,0.00,NULL,0.0012,115.001179040000000000,'2026-03-09','2026-03-09 09:41:36.400',115.00,0.00,1.000000000000000000,0.00),(34,7,0.00,NULL,0.00,0,0.00,NULL,0.0335,3350.042712830015000000,'2026-03-10','2026-03-10 09:28:58.469',3366.00,0.00,1.010000000000000000,0.00),(35,8,0.00,NULL,0.00,0,0.00,NULL,1.0014,100142.983488840000000000,'2026-03-10','2026-03-10 09:29:01.185',100137
|
|||
|
|
/*!40000 ALTER TABLE `asset_performance` ENABLE KEYS */;
|
|||
|
|
UNLOCK TABLES;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Table structure for table `assets`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
DROP TABLE IF EXISTS `assets`;
|
|||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|||
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|||
|
|
CREATE TABLE `assets` (
|
|||
|
|
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
|||
|
|
`asset_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|||
|
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|||
|
|
`category` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
|||
|
|
`category_color` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
|||
|
|
`icon_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
|
|||
|
|
`target_apy` decimal(10,2) DEFAULT NULL,
|
|||
|
|
`pool_cap_usd` decimal(30,2) DEFAULT NULL,
|
|||
|
|
`risk_level` bigint DEFAULT NULL,
|
|||
|
|
`risk_label` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
|||
|
|
`is_active` tinyint(1) DEFAULT '1',
|
|||
|
|
`is_featured` tinyint(1) DEFAULT '0',
|
|||
|
|
`created_at` datetime(3) DEFAULT NULL,
|
|||
|
|
`updated_at` datetime(3) DEFAULT NULL,
|
|||
|
|
`subtitle` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
|
|||
|
|
`description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
|
|||
|
|
`underlying_assets` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
|||
|
|
`token_symbol` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
|||
|
|
`decimals` bigint DEFAULT '18',
|
|||
|
|
`chain_id` int DEFAULT '97',
|
|||
|
|
`contract_address` varchar(42) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
|||
|
|
`deploy_block` bigint unsigned DEFAULT NULL,
|
|||
|
|
`token_role` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT 'product',
|
|||
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|||
|
|
UNIQUE KEY `uni_assets_asset_code` (`asset_code`) USING BTREE,
|
|||
|
|
KEY `idx_active` (`is_active`) USING BTREE,
|
|||
|
|
KEY `idx_assets_asset_code` (`asset_code`) USING BTREE
|
|||
|
|
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='资产基本信息表';
|
|||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Dumping data for table `assets`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
LOCK TABLES `assets` WRITE;
|
|||
|
|
/*!40000 ALTER TABLE `assets` DISABLE KEYS */;
|
|||
|
|
INSERT INTO `assets` VALUES (7,'YT-A','YT-A','DeFi','blue','/assets/flags/lr0.svg',11.00,10100000.00,2,'Low',1,1,'2026-02-25 16:05:49.000','2026-03-27 09:01:27.114','US Treasury-Backed Yield Token - Institutional Grade RWA','YT-A is a tokenized yield product backed by US Treasury securities.','US Treasury Securities','YT-A',18,97,'0x7f9eEA491eE53045594ee4669327f0355aCd0e58',83949087,'yt_token'),(8,'YT-B','YT-B','Real Estate','green','/assets/flags/container14.svg',22.00,10000000.00,1,'LOW',1,1,'2026-02-25 16:05:52.000','2026-03-27 09:01:27.222','Hong Kong Real Estate Yield Token - Prime Commercial Assets','YT-B provides tokenized exposure to prime commercial real estate in Hong Kong CBD.\nYT-B provides tokenized exposure to prime commercial real estate in Hong Kong CBD.\nYT-B provides tokenized exposure to prime commercial real estate in Hong Kong CBD.\nYT-B provides tokenized exposure to prime commercial real estate in Hong Kong CBD.\nYT-B provides tokenized exposure to prime commercial real estate in Hong Kong CBD.\nYT-B provides tokenized exposure to prime commercial real estate in Hong Kong CBD.\nYT-B provides tokenized exposure to prime commercial real estate in Hong Kong CBD.\nYT-B provides tokenized exposure to prime commercial real estate in Hong Kong CBD.YT-B provides tokenized exposure to prime commercial real estate in Hong Kong CBD.\nYT-B provides tokenized exposure to prime commercial real estate in Hong Kong CBD.\nYT-B provides tokenized exposure to prime commercial real estate in Hong Kong CBD.\nYT-B provides tokenized exposure to prime commercial real estate in Hong Kong CBD.','HK Commercial Real Estate','YT-B',18,97,'0x20B94C5E5b7361552E0548161a58696aA6FeDBd4',83949096,'yt_token'),(9,'YT-C','YT-C','Fixed Income','orange','/assets/flags/lr0.svg',22.00,10000000.00,1,'Medium',1,1,'2026-02-25 16:05:55.000','2026-03-27 09:01:27.329','European Corporate Bond Yield Token - Investment Grade Fixed Income','YT-C offers diversified exposure to investment-grade European corporate bonds.','European Investment Grade Bonds','YT-C',18,97,'0x0EF308D70cf35460E26a3Eb42F3442Ff28cbE07C',83949101,'yt_token'),(10,'USDC','USD Coin','Stablecoin','blue','/assets/tokens/usd-coin-usdc-logo-10.svg',0.00,0.00,1,'',1,0,'2026-02-28 08:14:33.000','2026-03-03 16:51:38.955','','','','USDC',18,97,'0x939cf46F7A4d05da2a37213E7379a8b04528F590',NULL,'stablecoin'),(11,'YT-D','新增币','RWA','','',0.00,10000000.00,0,'',1,0,'2026-03-06 10:11:38.120','2026-03-16 02:18:30.539','','','','',18,97,'',NULL,'yt_token');
|
|||
|
|
/*!40000 ALTER TABLE `assets` ENABLE KEYS */;
|
|||
|
|
UNLOCK TABLES;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Table structure for table `collateral_buy_records`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
DROP TABLE IF EXISTS `collateral_buy_records`;
|
|||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|||
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|||
|
|
CREATE TABLE `collateral_buy_records` (
|
|||
|
|
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
|
|||
|
|
`chain_id` bigint DEFAULT NULL,
|
|||
|
|
`tx_hash` varchar(66) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
|||
|
|
`buyer_addr` varchar(42) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
|||
|
|
`asset_addr` varchar(42) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
|||
|
|
`asset_symbol` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
|||
|
|
`paid_amount` varchar(78) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
|||
|
|
`received_amount` varchar(78) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
|||
|
|
`gas_used` bigint unsigned DEFAULT NULL,
|
|||
|
|
`block_number` bigint unsigned DEFAULT NULL,
|
|||
|
|
`status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT 'success',
|
|||
|
|
`error_message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
|
|||
|
|
`created_at` datetime(3) DEFAULT NULL,
|
|||
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|||
|
|
UNIQUE KEY `idx_collateral_buy_records_tx_hash` (`tx_hash`) USING BTREE,
|
|||
|
|
KEY `idx_collateral_buy_records_chain_id` (`chain_id`) USING BTREE,
|
|||
|
|
KEY `idx_collateral_buy_records_asset_addr` (`asset_addr`) USING BTREE
|
|||
|
|
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
|
|||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Dumping data for table `collateral_buy_records`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
LOCK TABLES `collateral_buy_records` WRITE;
|
|||
|
|
/*!40000 ALTER TABLE `collateral_buy_records` DISABLE KEYS */;
|
|||
|
|
INSERT INTO `collateral_buy_records` VALUES (1,97,'0x41041474ecebc14d0504bca6764e07a4450cf75bea0fd932b58a53e8c1b396de','0xa013422A5918CD099C63c8CC35283EACa99a705d','0x7f9eEA491eE53045594ee4669327f0355aCd0e58','YT-A','100000000000000000000','102570256410256410256',155321,93906606,'success','','2026-03-05 15:01:50.911'),(2,97,'0xb008fccc27dc16040aeb3793555dc140ffe4460041e1208391df3bc25936697d','0xa013422A5918CD099C63c8CC35283EACa99a705d','0x7f9eEA491eE53045594ee4669327f0355aCd0e58','YT-A','100000000000000000000','102570256410256410256',157474,93906648,'success','','2026-03-05 15:02:08.165'),(3,97,'0x7f9af34be9572fff00fc86c03e838c9ec08d369a4ceaa2827ba68a934bd88218','0xa013422A5918CD099C63c8CC35283EACa99a705d','0x7f9eEA491eE53045594ee4669327f0355aCd0e58','YT-A','100000000000000000000','4859487179487179488',148048,93906678,'success','','2026-03-05 15:02:21.890'),(4,97,'0xc6a4a12db183ca3b851e7125739240ffa18d0dd75b65e06e1d19daeae6058d04','0xa013422A5918CD099C63c8CC35283EACa99a705d','0x7f9eEA491eE53045594ee4669327f0355aCd0e58','YT-A','146','150000000000000000000',148072,93912120,'success','','2026-03-05 15:44:00.995'),(5,97,'0x4c7783ee424b5bd2e9364c629754b1456954328c5146d5426ac795be0d53eb80','0xa013422A5918CD099C63c8CC35283EACa99a705d','0x7f9eEA491eE53045594ee4669327f0355aCd0e58','YT-A','194','200000000000000000000',145919,93913808,'success','','2026-03-05 15:57:12.899'),(6,97,'0xaf7c5d9a94f2af62c906f176e60f9449b2e648e9945a1112666ed03dd8b68d1a','0xa013422A5918CD099C63c8CC35283EACa99a705d','0x7f9eEA491eE53045594ee4669327f0355aCd0e58','YT-A','146241225526468411895','150000000000000000000',145919,93918602,'success','','2026-03-05 16:33:12.790');
|
|||
|
|
/*!40000 ALTER TABLE `collateral_buy_records` ENABLE KEYS */;
|
|||
|
|
UNLOCK TABLES;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Table structure for table `footer_links`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
DROP TABLE IF EXISTS `footer_links`;
|
|||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|||
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|||
|
|
CREATE TABLE `footer_links` (
|
|||
|
|
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
|||
|
|
`section` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '所属分区名称（用于前端分组展示，如 Products/Company）',
|
|||
|
|
`link_text` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|||
|
|
`link_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|||
|
|
`display_order` bigint DEFAULT '0',
|
|||
|
|
`is_active` tinyint(1) DEFAULT '1',
|
|||
|
|
`created_at` datetime(3) DEFAULT NULL,
|
|||
|
|
`updated_at` datetime(3) DEFAULT NULL,
|
|||
|
|
`category` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|||
|
|
`page` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '',
|
|||
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|||
|
|
KEY `idx_section` (`section`) USING BTREE
|
|||
|
|
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='Footer链接配置表';
|
|||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Dumping data for table `footer_links`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
LOCK TABLES `footer_links` WRITE;
|
|||
|
|
/*!40000 ALTER TABLE `footer_links` DISABLE KEYS */;
|
|||
|
|
INSERT INTO `footer_links` VALUES (1,'Products','Fund Market','https://www.baidu.com/',1,1,'2026-02-12 15:20:33.000','2026-02-27 10:20:00.059','测试',''),(2,'Products','ALP Pool','/alp',2,1,'2026-02-12 15:20:33.000','2026-02-12 15:20:33.000','',''),(3,'Products','Lending','/lending',3,1,'2026-02-12 15:20:33.000','2026-02-12 15:20:33.000','',''),(4,'Products','Transparency','/transparency',4,1,'2026-02-12 15:20:33.000','2026-02-12 15:20:33.000','',''),(5,'Resources','Documentation','https://docs.assetx.finance',1,1,'2026-02-12 15:20:33.000','2026-02-12 15:20:33.000','',''),(6,'Resources','Help Center','https://help.assetx.finance',2,1,'2026-02-12 15:20:33.000','2026-02-12 15:20:33.000','',''),(7,'Resources','API Reference','https://api.assetx.finance/docs',3,1,'2026-02-12 15:20:33.000','2026-02-12 15:20:33.000','',''),(8,'Resources','GitHub','https://github.com/assetx',4,1,'2026-02-12 15:20:33.000','2026-02-12 15:20:33.000','',''),(9,'Community','Twitter','https://twitter.com/assetx',1,1,'2026-02-12 15:20:33.000','2026-02-12 15:20:33.000','',''),(10,'Community','Discord','https://discord.gg/assetx',2,1,'2026-02-12 15:20:33.000','2026-02-12 15:20:33.000','',''),(11,'Community','Telegram','https://t.me/assetx',3,1,'2026-02-12 15:20:33.000','2026-02-12 15:20:33.000','',''),(12,'Community','Medium','https://medium.com/@assetx',4,1,'2026-02-12 15:20:33.000','2026-02-12 15:20:33.000','',''),(13,'Legal','Terms of Service','/legal/terms',1,1,'2026-02-12 15:20:33.000','2026-02-12 15:20:33.000','',''),(14,'Legal','Privacy Policy','/legal/privacy',2,1,'2026-02-12 15:20:33.000','2026-02-12 15:20:33.000','',''),(15,'Legal','Risk Disclosure','/legal/risk',3,1,'2026-02-12 15:20:33.000','2026-02-12 15:20:33.000','','');
|
|||
|
|
/*!40000 ALTER TABLE `footer_links` ENABLE KEYS */;
|
|||
|
|
UNLOCK TABLES;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Table structure for table `holder_snapshots`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
DROP TABLE IF EXISTS `holder_snapshots`;
|
|||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|||
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|||
|
|
CREATE TABLE `holder_snapshots` (
|
|||
|
|
`id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
|||
|
|
`holder_address` varchar(42) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|||
|
|
`token_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|||
|
|
`token_address` varchar(42) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|||
|
|
`balance` varchar(78) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|||
|
|
`chain_id` bigint NOT NULL,
|
|||
|
|
`first_seen` bigint NOT NULL,
|
|||
|
|
`last_updated` bigint NOT NULL,
|
|||
|
|
`created_at` datetime(3) DEFAULT NULL,
|
|||
|
|
`updated_at` datetime(3) DEFAULT NULL,
|
|||
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|||
|
|
KEY `idx_holder_token` (`holder_address`,`token_type`) USING BTREE,
|
|||
|
|
KEY `idx_token_time` (`last_updated`) USING BTREE
|
|||
|
|
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
|
|||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Dumping data for table `holder_snapshots`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
LOCK TABLES `holder_snapshots` WRITE;
|
|||
|
|
/*!40000 ALTER TABLE `holder_snapshots` DISABLE KEYS */;
|
|||
|
|
INSERT INTO `holder_snapshots` VALUES (1,'0xa013422A5918CD099C63c8CC35283EACa99a705d','YT-A','0x7f9eEA491eE53045594ee4669327f0355aCd0e58','1228079768402224998455',421614,1770363321,1773042926,'2026-02-27 08:37:25.253','2026-03-09 15:55:26.866'),(2,'0xA6CD153c2fa0C2725605880668538660Ca21a790','YT-A','0x7f9eEA491eE53045594ee4669327f0355aCd0e58','121997484427790000000',421614,1770364639,1773042926,'2026-02-27 08:37:25.486','2026-03-09 15:55:26.432'),(3,'0xfdbFD4656b74aD16F23264121eD9F58219f5C3Cf','YT-A','0x7f9eEA491eE53045594ee4669327f0355aCd0e58','1000000000000000000000',421614,1770630780,1773042926,'2026-02-27 08:37:25.611','2026-03-09 15:55:26.642'),(4,'0x48C80945b2DBc17Bcc05073E51cEDF39b6eEA0d7','YT-A','0x7f9eEA491eE53045594ee4669327f0355aCd0e58','999965460000000000000',421614,1771918100,1773042926,'2026-02-27 08:37:25.724','2026-03-09 15:55:26.753'),(5,'0xA6CD153c2fa0C2725605880668538660Ca21a790','YT-B','0x20B94C5E5b7361552E0548161a58696aA6FeDBd4','20177908853000000000',421614,1770621487,1773042926,'2026-02-27 08:48:06.673','2026-03-09 15:55:27.287'),(6,'0xa013422A5918CD099C63c8CC35283EACa99a705d','YT-B','0x20B94C5E5b7361552E0548161a58696aA6FeDBd4','99838806242047000000000',421614,1770621345,1774602090,'2026-02-27 08:48:06.806','2026-03-27 09:01:30.275'),(7,'0xa013422A5918CD099C63c8CC35283EACa99a705d','YT-C','0x0EF308D70cf35460E26a3Eb42F3442Ff28cbE07C','93991233870000000000',421614,1772161338,1773653482,'2026-02-27 08:58:55.442','2026-03-16 09:31:23.072'),(8,'0xa013422A5918CD099C63c8CC35283EACa99a705d','ytLP','0x17c1100b02d560549b499561dB8d7D48fc391cf3','9957455256217378978098',421614,1770364639,1773042927,'2026-02-27 09:09:29.052','2026-03-09 15:55:27.857'),(9,'0xA6CD153c2fa0C2725605880668538660Ca21a790','YT-C','0x0EF308D70cf35460E26a3Eb42F3442Ff28cbE07C','50010776600000000000',97,1772265334,1774602090,'2026-03-05 17:36:03.752','2026-03-27 09:01:30.376'),(10,'0xfdbFD4656b74aD16F23264121eD9F58219f5C3Cf','YT-B','0x20B94C5E5b7361552E0548161a58696aA6FeDBd4','299000000000000000000',97,1773040737,1774602090,'2026-03-09 15:19:16.823','2026-03-27 09:01:30.177');
|
|||
|
|
/*!40000 ALTER TABLE `holder_snapshots` ENABLE KEYS */;
|
|||
|
|
UNLOCK TABLES;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Table structure for table `holders_snapshots`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
DROP TABLE IF EXISTS `holders_snapshots`;
|
|||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|||
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|||
|
|
CREATE TABLE `holders_snapshots` (
|
|||
|
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
|||
|
|
`wallet_address` varchar(42) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '用户钱包地址',
|
|||
|
|
`token_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|||
|
|
`token_address` varchar(42) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|||
|
|
`chain_id` int NOT NULL,
|
|||
|
|
`balance` decimal(30,18) NOT NULL,
|
|||
|
|
`balance_usd` decimal(30,2) DEFAULT NULL,
|
|||
|
|
`holding_duration_hours` int DEFAULT NULL,
|
|||
|
|
`points_multiplier` decimal(10,4) DEFAULT '1.0000',
|
|||
|
|
`earned_points` int DEFAULT NULL,
|
|||
|
|
`snapshot_time` datetime NOT NULL,
|
|||
|
|
`season_id` bigint DEFAULT NULL COMMENT '当前快照所属赛季 ID（关联 seasons.id），NULL 表示赛季外快照',
|
|||
|
|
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
|
|||
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|||
|
|
KEY `idx_wallet_type_time` (`wallet_address`,`token_type`,`snapshot_time` DESC) USING BTREE,
|
|||
|
|
CONSTRAINT `holders_snapshots_ibfk_1` FOREIGN KEY (`wallet_address`) REFERENCES `users` (`wallet_address`) ON DELETE RESTRICT ON UPDATE CASCADE
|
|||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='Holders持有快照表（每小时）';
|
|||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Dumping data for table `holders_snapshots`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
LOCK TABLES `holders_snapshots` WRITE;
|
|||
|
|
/*!40000 ALTER TABLE `holders_snapshots` DISABLE KEYS */;
|
|||
|
|
/*!40000 ALTER TABLE `holders_snapshots` ENABLE KEYS */;
|
|||
|
|
UNLOCK TABLES;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Table structure for table `invitations`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
DROP TABLE IF EXISTS `invitations`;
|
|||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|||
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|||
|
|
CREATE TABLE `invitations` (
|
|||
|
|
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
|||
|
|
`referrer_wallet` varchar(42) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|||
|
|
`referee_wallet` varchar(42) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|||
|
|
`invite_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '使用的邀请码',
|
|||
|
|
`bind_signature` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
|
|||
|
|
`bind_hash` varchar(66) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
|||
|
|
`status` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT 'active',
|
|||
|
|
`referrer_reward_points` int DEFAULT '0',
|
|||
|
|
`referee_reward_points` int DEFAULT '0',
|
|||
|
|
`bound_at` datetime NOT NULL,
|
|||
|
|
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
|
|||
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|||
|
|
UNIQUE KEY `uk_referee_wallet` (`referee_wallet`) USING BTREE,
|
|||
|
|
KEY `idx_referrer_wallet` (`referrer_wallet`) USING BTREE,
|
|||
|
|
CONSTRAINT `invitations_ibfk_1` FOREIGN KEY (`referrer_wallet`) REFERENCES `users` (`wallet_address`) ON DELETE RESTRICT ON UPDATE CASCADE,
|
|||
|
|
CONSTRAINT `invitations_ibfk_2` FOREIGN KEY (`referee_wallet`) REFERENCES `users` (`wallet_address`) ON DELETE RESTRICT ON UPDATE CASCADE
|
|||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='邀请关系表';
|
|||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Dumping data for table `invitations`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
LOCK TABLES `invitations` WRITE;
|
|||
|
|
/*!40000 ALTER TABLE `invitations` DISABLE KEYS */;
|
|||
|
|
/*!40000 ALTER TABLE `invitations` ENABLE KEYS */;
|
|||
|
|
UNLOCK TABLES;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Table structure for table `invite_codes`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
DROP TABLE IF EXISTS `invite_codes`;
|
|||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|||
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|||
|
|
CREATE TABLE `invite_codes` (
|
|||
|
|
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
|||
|
|
`wallet_address` varchar(42) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|||
|
|
`code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '邀请码（系统生成，8位大写字母+数字，全局唯一）',
|
|||
|
|
`max_uses` int DEFAULT '-1' COMMENT '最大使用次数，-1 表示无限制',
|
|||
|
|
`used_count` int DEFAULT '0' COMMENT '已使用次数',
|
|||
|
|
`expires_at` datetime DEFAULT NULL COMMENT '过期时间，NULL 表示永不过期',
|
|||
|
|
`is_active` tinyint(1) DEFAULT '1' COMMENT '是否有效：1=有效，0=已禁用',
|
|||
|
|
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
|||
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|||
|
|
UNIQUE KEY `uk_code` (`code`) USING BTREE,
|
|||
|
|
UNIQUE KEY `uk_wallet` (`wallet_address`) USING BTREE COMMENT '每个钱包只有一个邀请码',
|
|||
|
|
CONSTRAINT `invite_codes_ibfk_1` FOREIGN KEY (`wallet_address`) REFERENCES `users` (`wallet_address`) ON DELETE RESTRICT ON UPDATE CASCADE
|
|||
|
|
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='邀请码表';
|
|||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Dumping data for table `invite_codes`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
LOCK TABLES `invite_codes` WRITE;
|
|||
|
|
/*!40000 ALTER TABLE `invite_codes` DISABLE KEYS */;
|
|||
|
|
INSERT INTO `invite_codes` VALUES (1,'0x1234567890123456789012345678901234567890','PR0T0-8821',-1,0,'2026-02-25 16:17:07',1,'2026-02-12 15:20:33'),(2,'0x8a00000000000000000000000000000000002291','TOP1-0001',-1,15,'2026-02-25 16:17:10',1,'2026-02-12 15:20:33'),(3,'0x1100000000000000000000000000000000f92a','TOP2-0002',-1,12,'2026-02-25 16:17:12',1,'2026-02-12 15:20:33'),(4,'0x9c00000000000000000000000000000000003310','TOP3-0003',-1,10,'2026-02-25 16:17:14',1,'2026-02-12 15:20:33'),(5,'0x4200000000000000000000000000000000119a','TOP4-0004',-1,8,'2026-02-25 16:17:17',1,'2026-02-12 15:20:33'),(6,'0x7700000000000000000000000000000000882b','TOP5-0005',-1,5,'2026-02-25 16:17:18',1,'2026-02-12 15:20:33'),(7,'0xa013422a5918cd099c63c8cc35283eaca99a705d','MJGYDORD',-1,0,'2100-01-01 07:59:59',1,'2026-02-27 10:29:22');
|
|||
|
|
/*!40000 ALTER TABLE `invite_codes` ENABLE KEYS */;
|
|||
|
|
UNLOCK TABLES;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Table structure for table `kline_data`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
DROP TABLE IF EXISTS `kline_data`;
|
|||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|||
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|||
|
|
CREATE TABLE `kline_data` (
|
|||
|
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
|||
|
|
`asset_id` bigint NOT NULL,
|
|||
|
|
`chain_id` int NOT NULL,
|
|||
|
|
`contract_address` varchar(42) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '快照来源合约地址',
|
|||
|
|
`open_price` decimal(30,18) DEFAULT NULL,
|
|||
|
|
`high_price` decimal(30,18) DEFAULT NULL,
|
|||
|
|
`low_price` decimal(30,18) DEFAULT NULL,
|
|||
|
|
`close_price` decimal(30,18) DEFAULT NULL,
|
|||
|
|
`volume` decimal(30,18) DEFAULT NULL,
|
|||
|
|
`interval_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
|||
|
|
`period_start` datetime NOT NULL,
|
|||
|
|
`period_end` datetime NOT NULL,
|
|||
|
|
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
|
|||
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|||
|
|
UNIQUE KEY `uk_kline` (`asset_id`,`chain_id`,`interval_type`,`period_start`) USING BTREE,
|
|||
|
|
CONSTRAINT `kline_data_ibfk_1` FOREIGN KEY (`asset_id`) REFERENCES `assets` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
|
|||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='K线数据表';
|
|||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Dumping data for table `kline_data`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
LOCK TABLES `kline_data` WRITE;
|
|||
|
|
/*!40000 ALTER TABLE `kline_data` DISABLE KEYS */;
|
|||
|
|
/*!40000 ALTER TABLE `kline_data` ENABLE KEYS */;
|
|||
|
|
UNLOCK TABLES;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Table structure for table `known_borrowers`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
DROP TABLE IF EXISTS `known_borrowers`;
|
|||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|||
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|||
|
|
CREATE TABLE `known_borrowers` (
|
|||
|
|
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
|
|||
|
|
`chain_id` bigint DEFAULT NULL,
|
|||
|
|
`address` varchar(42) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
|||
|
|
`first_seen_at` datetime(3) DEFAULT NULL,
|
|||
|
|
`last_seen_at` datetime(3) DEFAULT NULL,
|
|||
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|||
|
|
UNIQUE KEY `idx_known_borrower` (`chain_id`,`address`) USING BTREE
|
|||
|
|
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
|
|||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Dumping data for table `known_borrowers`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
LOCK TABLES `known_borrowers` WRITE;
|
|||
|
|
/*!40000 ALTER TABLE `known_borrowers` DISABLE KEYS */;
|
|||
|
|
INSERT INTO `known_borrowers` VALUES (1,97,'0xa013422A5918CD099C63c8CC35283EACa99a705d','2026-03-05 15:53:18.051','2026-03-09 16:28:42.214');
|
|||
|
|
/*!40000 ALTER TABLE `known_borrowers` ENABLE KEYS */;
|
|||
|
|
UNLOCK TABLES;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Table structure for table `liquidation_records`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
DROP TABLE IF EXISTS `liquidation_records`;
|
|||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|||
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|||
|
|
CREATE TABLE `liquidation_records` (
|
|||
|
|
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
|
|||
|
|
`chain_id` bigint DEFAULT NULL,
|
|||
|
|
`tx_hash` varchar(66) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
|||
|
|
`liquidator_addr` varchar(42) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
|||
|
|
`account_count` bigint DEFAULT NULL,
|
|||
|
|
`accounts` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
|
|||
|
|
`gas_used` bigint unsigned DEFAULT NULL,
|
|||
|
|
`block_number` bigint unsigned DEFAULT NULL,
|
|||
|
|
`status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT 'success',
|
|||
|
|
`error_message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
|
|||
|
|
`created_at` datetime(3) DEFAULT NULL,
|
|||
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|||
|
|
UNIQUE KEY `idx_liquidation_records_tx_hash` (`tx_hash`) USING BTREE,
|
|||
|
|
KEY `idx_liquidation_records_chain_id` (`chain_id`) USING BTREE
|
|||
|
|
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
|
|||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Dumping data for table `liquidation_records`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
LOCK TABLES `liquidation_records` WRITE;
|
|||
|
|
/*!40000 ALTER TABLE `liquidation_records` DISABLE KEYS */;
|
|||
|
|
INSERT INTO `liquidation_records` VALUES (1,97,'0xf26348d4ca79ea5b33e274fa9963af4b1333bed55643d524c3b4b683fe20594f','0xa013422A5918CD099C63c8CC35283EACa99a705d',1,'[\"0xa013422A5918CD099C63c8CC35283EACa99a705d\"]',174620,93899858,'success','','2026-03-05 14:10:22.763'),(2,97,'0xe7d67ef3123fba05da7b26f6904d107ae312129163de6b2a9d18f62294d65bde','0xa013422A5918CD099C63c8CC35283EACa99a705d',1,'[\"0xa013422A5918CD099C63c8CC35283EACa99a705d\"]',174620,93912108,'success','','2026-03-05 15:43:55.994'),(3,97,'0x8c941c89c31c3eecbd541e8dbfe5a35135f9cc1674cdaba1c0628325f5c25a73','0xa013422A5918CD099C63c8CC35283EACa99a705d',1,'[\"0xa013422A5918CD099C63c8CC35283EACa99a705d\"]',174620,93913786,'success','','2026-03-05 15:57:02.818'),(4,97,'0x1123f39fab19e429ce1e75b26da4621f5386f569ff272dec4bffe74ab350f0d8','0xa013422A5918CD099C63c8CC35283EACa99a705d',1,'[\"0xa013422A5918CD099C63c8CC35283EACa99a705d\"]',174620,93918578,'success','','2026-03-05 16:33:01.852');
|
|||
|
|
/*!40000 ALTER TABLE `liquidation_records` ENABLE KEYS */;
|
|||
|
|
UNLOCK TABLES;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Table structure for table `operation_logs`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
DROP TABLE IF EXISTS `operation_logs`;
|
|||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|||
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|||
|
|
CREATE TABLE `operation_logs` (
|
|||
|
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
|||
|
|
`wallet_address` varchar(42) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '操作者钱包地址（可为空）',
|
|||
|
|
`operation_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|||
|
|
`method` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|||
|
|
`path` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|||
|
|
`query_params` json DEFAULT NULL,
|
|||
|
|
`body_params` json DEFAULT NULL,
|
|||
|
|
`status_code` int DEFAULT NULL,
|
|||
|
|
`duration_ms` int DEFAULT NULL,
|
|||
|
|
`error_message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
|
|||
|
|
`ip_address` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
|||
|
|
`user_agent` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
|
|||
|
|
`detail` json DEFAULT NULL,
|
|||
|
|
`created_at` datetime(3) DEFAULT NULL,
|
|||
|
|
`user_id` bigint unsigned DEFAULT NULL,
|
|||
|
|
`target_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
|||
|
|
`target_id` bigint unsigned DEFAULT NULL,
|
|||
|
|
`action` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|||
|
|
`changes` json DEFAULT NULL,
|
|||
|
|
`status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|||
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|||
|
|
KEY `idx_wallet` (`wallet_address`) USING BTREE,
|
|||
|
|
KEY `idx_operation` (`operation_type`,`created_at` DESC) USING BTREE,
|
|||
|
|
KEY `idx_created` (`created_at` DESC) USING BTREE,
|
|||
|
|
KEY `idx_operation_logs_user_id` (`user_id`) USING BTREE,
|
|||
|
|
KEY `idx_operation_logs_created_at` (`created_at`) USING BTREE,
|
|||
|
|
CONSTRAINT `operation_logs_ibfk_1` FOREIGN KEY (`wallet_address`) REFERENCES `users` (`wallet_address`) ON DELETE SET NULL ON UPDATE CASCADE
|
|||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='操作日志表';
|
|||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Dumping data for table `operation_logs`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
LOCK TABLES `operation_logs` WRITE;
|
|||
|
|
/*!40000 ALTER TABLE `operation_logs` DISABLE KEYS */;
|
|||
|
|
/*!40000 ALTER TABLE `operation_logs` ENABLE KEYS */;
|
|||
|
|
UNLOCK TABLES;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Table structure for table `points_rules`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
DROP TABLE IF EXISTS `points_rules`;
|
|||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|||
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|||
|
|
CREATE TABLE `points_rules` (
|
|||
|
|
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
|||
|
|
`rule_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|||
|
|
`rule_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|||
|
|
`base_points` bigint NOT NULL,
|
|||
|
|
`multiplier` decimal(10,4) DEFAULT '1.0000',
|
|||
|
|
`conditions` json DEFAULT NULL,
|
|||
|
|
`valid_from` datetime(3) DEFAULT NULL,
|
|||
|
|
`valid_until` datetime(3) DEFAULT NULL,
|
|||
|
|
`is_active` tinyint(1) DEFAULT '1',
|
|||
|
|
`priority` bigint DEFAULT '0',
|
|||
|
|
`created_at` datetime(3) DEFAULT NULL,
|
|||
|
|
`updated_at` datetime(3) DEFAULT NULL,
|
|||
|
|
`description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
|
|||
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|||
|
|
UNIQUE KEY `uni_points_rules_rule_name` (`rule_name`) USING BTREE,
|
|||
|
|
KEY `idx_type` (`rule_type`) USING BTREE
|
|||
|
|
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='积分规则配置表';
|
|||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Dumping data for table `points_rules`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
LOCK TABLES `points_rules` WRITE;
|
|||
|
|
/*!40000 ALTER TABLE `points_rules` DISABLE KEYS */;
|
|||
|
|
INSERT INTO `points_rules` VALUES (1,'持有YT-A代币','holding',10,1.5000,'{\"token_type\": \"YT-A\", \"min_holding_hours\": 24}',NULL,NULL,1,0,'2026-02-12 10:00:03.000','2026-02-12 10:00:03.000',NULL),(2,'持有YT-B代币','holding',12,1.8000,'{\"token_type\": \"YT-B\", \"min_holding_hours\": 24}',NULL,NULL,1,0,'2026-02-12 10:00:03.000','2026-02-12 10:00:03.000',NULL),(3,'持有YT-C代币','holding',15,2.0000,'{\"token_type\": \"YT-C\", \"min_holding_hours\": 24}',NULL,NULL,1,0,'2026-02-12 10:00:03.000','2026-02-12 10:00:03.000',NULL),(4,'持有LP代币','holding',15,2.0000,'{\"token_type\": \"ytLP\", \"min_holding_hours\": 24}',NULL,NULL,1,0,'2026-02-12 10:00:03.000','2026-02-12 10:00:03.000',NULL),(5,'借贷供应','lending',20,1.2000,'{\"action\": \"supply\", \"min_amount_usd\": 500}',NULL,NULL,1,0,'2026-02-12 10:00:03.000','2026-02-12 10:00:03.000',NULL),(6,'直推邀请奖励','invitation',100,1.0000,'{\"direct_invite\": true}',NULL,NULL,1,0,'2026-02-12 10:00:03.000','2026-02-12 10:00:03.000',NULL),(7,'大额交易','trading',50,1.0000,'{\"min_amount_usd\": 5000}',NULL,NULL,1,0,'2026-02-12 10:00:03.000','2026-02-12 10:00:03.000',NULL);
|
|||
|
|
/*!40000 ALTER TABLE `points_rules` ENABLE KEYS */;
|
|||
|
|
UNLOCK TABLES;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Table structure for table `product_links`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
DROP TABLE IF EXISTS `product_links`;
|
|||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|||
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|||
|
|
CREATE TABLE `product_links` (
|
|||
|
|
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
|
|||
|
|
`asset_id` bigint unsigned NOT NULL,
|
|||
|
|
`link_text` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
|
|||
|
|
`link_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
|
|||
|
|
`description` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|||
|
|
`display_area` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'protocol',
|
|||
|
|
`display_order` int NOT NULL DEFAULT '0',
|
|||
|
|
`is_active` tinyint(1) NOT NULL DEFAULT '1',
|
|||
|
|
`created_at` datetime(3) DEFAULT NULL,
|
|||
|
|
`updated_at` datetime(3) DEFAULT NULL,
|
|||
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|||
|
|
KEY `idx_product_links_asset_id` (`asset_id`) USING BTREE
|
|||
|
|
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
|
|||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Dumping data for table `product_links`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
LOCK TABLES `product_links` WRITE;
|
|||
|
|
/*!40000 ALTER TABLE `product_links` DISABLE KEYS */;
|
|||
|
|
INSERT INTO `product_links` VALUES (1,7,'Smart Contract','https://github.com/assetx/yt-c-contracts','Audited by OpenZeppelin & Certik for security and reliability.','verification',1,1,'2026-02-27 13:14:14.656','2026-02-28 02:35:29.520'),(2,7,'Compliance','https://www.baidu.com','SEC-regulated structure & bankruptcy remote legal framework.','verification',2,1,'2026-02-27 13:48:16.692','2026-02-28 02:35:35.076'),(3,7,'Proof of Reserves','https://www.baidu.com','Real-time on-chain verification via Chainlink Oracle.','verification',3,1,'2026-02-27 13:48:20.323','2026-02-27 13:48:20.323'),(5,8,'Smart Contract','https://www.baidu.com','Smart contract security audit by Trail of Bits and Certik.','verification',1,1,'2026-02-27 13:48:28.878','2026-02-27 13:48:28.878'),(6,8,'Compliance','https://www.baidu.com','Fully compliant with Hong Kong SFC regulations and FATF guidelines.','verification',2,1,'2026-02-27 13:48:36.351','2026-02-27 13:48:36.351'),(7,8,'Proof of Reserves','https://www.baidu.com','Monthly third-party property valuation by PricewaterhouseCoopers.','verification',3,1,'2026-02-27 13:48:46.870','2026-02-27 13:48:46.870'),(8,8,'Protocol Information','https://www.baidu.com',NULL,'protocol',4,0,NULL,NULL),(9,9,'Smart Contract','https://www.baidu.com','Smart contract formally verified and audited by Certik.','verification',1,1,'2026-02-27 13:49:07.694','2026-02-27 13:49:07.695'),(10,9,'Compliance','https://www.baidu.com','EU MiFID II compliant investment structure with regulated custodians.','verification',2,1,'2026-02-27 13:48:58.615','2026-02-27 13:48:58.615'),(11,9,'Proof of Reserves','https://www.baidu.com','Independent monthly bond portfolio verification by Deloitte & Touche.','verification',3,1,'2026-02-27 13:49:03.229','2026-02-27 13:49:03.230'),(12,9,'Protocol Information','https://www.baidu.com',NULL,'protocol',4,0,NULL,NULL),(13,7,'GitHub','https://github.com/assetx/yt-a-contracts','Smart contract source code and audit history on GitHub.','protocol',4,1,'2026-02-27 13:21:44.000','2026-02-28 02:29:58.142'),(14,7,'Whitepaper','https://docs.assetx.finance/whitepaper-yt-a.pdf','Full product whitepaper detailing structure and mechanics.','protocol',5,1,'2026-02-27 13:21:44.000','2026-02-27 13:21:44.000'),(15,7,'Documentation','https://docs.assetx.finance/products/yt-a','Official product documentation and integration guides.','protocol',6,1,'2026-02-27 13:21:44.000','2026-02-27 13:21:44.000'),(16,8,'GitHub','https://github.com/assetx/yt-b-contracts','Smart contract source code and audit history on GitHub.','protocol',5,1,'2026-02-27 13:21:44.000','2026-02-27 13:21:44.000'),(17,8,'Whitepaper','https://docs.assetx.finance/whitepaper-yt-b.pdf','Full product whitepaper detailing structure and mechanics.','protocol',6,1,'2026-02-27 13:21:44.000','2026-02-27 13:21:44.000'),(18,8,'Documentation','https://docs.assetx.finance/products/yt-b','Official product documentation and integration guides.','protocol',7,1,'2026-02-27 13:21:44.000','2026-02-27 13:21:44.000'),(19,9,'GitHub','https://github.com/assetx/yt-c-contracts','Smart contract source code and audit history on GitHub.','protocol',5,1,'2026-02-27 13:21:45.000','2026-02-27 13:21:45.000'),(20,9,'Whitepaper','https://docs.assetx.finance/whitepaper-yt-c.pdf','Full product whitepaper detailing structure and mechanics.','protocol',6,1,'2026-02-27 13:21:45.000','2026-02-27 13:21:45.000'),(21,9,'Documentation','https://docs.assetx.finance/products/yt-c','Official product documentation and integration guides.','protocol',7,1,'2026-02-27 13:21:45.000','2026-02-27 13:21:45.000');
|
|||
|
|
/*!40000 ALTER TABLE `product_links` ENABLE KEYS */;
|
|||
|
|
UNLOCK TABLES;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Table structure for table `roles`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
DROP TABLE IF EXISTS `roles`;
|
|||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|||
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|||
|
|
CREATE TABLE `roles` (
|
|||
|
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
|||
|
|
`role_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|||
|
|
`role_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|||
|
|
`description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
|
|||
|
|
`level` int DEFAULT '0',
|
|||
|
|
`is_system` tinyint(1) DEFAULT '0',
|
|||
|
|
`is_active` tinyint(1) DEFAULT '1',
|
|||
|
|
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
|
|||
|
|
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
|||
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|||
|
|
UNIQUE KEY `role_code` (`role_code`) USING BTREE
|
|||
|
|
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='本地业务角色定义';
|
|||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Dumping data for table `roles`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
LOCK TABLES `roles` WRITE;
|
|||
|
|
/*!40000 ALTER TABLE `roles` DISABLE KEYS */;
|
|||
|
|
INSERT INTO `roles` VALUES (1,'admin','管理员','系统管理员',100,1,1,'2026-02-12 10:00:03','2026-02-12 10:00:03'),(2,'moderator','版主','内容管理员',50,1,1,'2026-02-12 10:00:03','2026-02-12 10:00:03'),(3,'vip','VIP用户','VIP会员',20,1,1,'2026-02-12 10:00:03','2026-02-12 10:00:03');
|
|||
|
|
/*!40000 ALTER TABLE `roles` ENABLE KEYS */;
|
|||
|
|
UNLOCK TABLES;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Table structure for table `scanner_state`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
DROP TABLE IF EXISTS `scanner_state`;
|
|||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|||
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|||
|
|
CREATE TABLE `scanner_state` (
|
|||
|
|
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
|
|||
|
|
`chain_id` bigint NOT NULL,
|
|||
|
|
`last_scanned_block` bigint unsigned NOT NULL DEFAULT '0',
|
|||
|
|
`updated_at` datetime(3) DEFAULT NULL,
|
|||
|
|
`scanner_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT 'holder',
|
|||
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|||
|
|
UNIQUE KEY `idx_chain_scanner` (`scanner_type`,`chain_id`) USING BTREE
|
|||
|
|
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
|
|||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Dumping data for table `scanner_state`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
LOCK TABLES `scanner_state` WRITE;
|
|||
|
|
/*!40000 ALTER TABLE `scanner_state` DISABLE KEYS */;
|
|||
|
|
INSERT INTO `scanner_state` VALUES (2,97,98138208,'2026-03-27 09:01:56.433','liquidation'),(3,97,98138208,'2026-03-27 09:01:56.217','collateral_buyer'),(5,97,98138141,'2026-03-27 09:01:30.078','holder');
|
|||
|
|
/*!40000 ALTER TABLE `scanner_state` ENABLE KEYS */;
|
|||
|
|
UNLOCK TABLES;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Table structure for table `seasons`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
DROP TABLE IF EXISTS `seasons`;
|
|||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|||
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|||
|
|
CREATE TABLE `seasons` (
|
|||
|
|
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
|||
|
|
`season_number` bigint NOT NULL,
|
|||
|
|
`season_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|||
|
|
`start_time` datetime(3) NOT NULL,
|
|||
|
|
`end_time` datetime(3) NOT NULL,
|
|||
|
|
`status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT 'upcoming',
|
|||
|
|
`total_rewards` decimal(30,2) DEFAULT NULL,
|
|||
|
|
`multiplier` decimal(10,4) DEFAULT '1.0000',
|
|||
|
|
`description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
|
|||
|
|
`is_active` tinyint(1) DEFAULT '1',
|
|||
|
|
`created_at` datetime(3) DEFAULT NULL,
|
|||
|
|
`updated_at` datetime(3) DEFAULT NULL,
|
|||
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|||
|
|
UNIQUE KEY `uni_seasons_season_number` (`season_number`) USING BTREE,
|
|||
|
|
KEY `idx_status` (`status`) USING BTREE,
|
|||
|
|
KEY `idx_seasons_season_number` (`season_number`) USING BTREE
|
|||
|
|
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='赛季配置表';
|
|||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Dumping data for table `seasons`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
LOCK TABLES `seasons` WRITE;
|
|||
|
|
/*!40000 ALTER TABLE `seasons` DISABLE KEYS */;
|
|||
|
|
INSERT INTO `seasons` VALUES (1,1,'Season 1','2026-01-01 00:00:00.000','2026-12-31 23:59:59.000','active',1000000.00,1.0000,'First season with 7x points multiplier',1,'2026-02-13 14:46:55.000','2026-02-13 14:46:55.000');
|
|||
|
|
/*!40000 ALTER TABLE `seasons` ENABLE KEYS */;
|
|||
|
|
UNLOCK TABLES;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Table structure for table `sessions`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
DROP TABLE IF EXISTS `sessions`;
|
|||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|||
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|||
|
|
CREATE TABLE `sessions` (
|
|||
|
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
|||
|
|
`wallet_address` varchar(42) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '用户钱包地址',
|
|||
|
|
`nonce` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '登录随机数（用于签名验证）',
|
|||
|
|
`sign_message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '用户签名的原始消息（含 nonce 和 timestamp），用于重放攻击防护',
|
|||
|
|
`signature` varchar(132) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '用户钱包签名的十六进制值（65字节 = 132字符）',
|
|||
|
|
`expires_at` datetime DEFAULT NULL COMMENT '签名会话过期时间，默认签名后7天，客户端 localStorage 存储同一截止时间',
|
|||
|
|
`device_info` json DEFAULT NULL,
|
|||
|
|
`ip_address` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
|||
|
|
`user_agent` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
|
|||
|
|
`last_active_at` datetime NOT NULL,
|
|||
|
|
`session_end_at` datetime DEFAULT NULL,
|
|||
|
|
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
|
|||
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|||
|
|
KEY `idx_wallet` (`wallet_address`) USING BTREE,
|
|||
|
|
KEY `idx_created` (`created_at` DESC) USING BTREE,
|
|||
|
|
CONSTRAINT `sessions_ibfk_1` FOREIGN KEY (`wallet_address`) REFERENCES `users` (`wallet_address`) ON DELETE CASCADE ON UPDATE CASCADE
|
|||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='会话记录表';
|
|||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Dumping data for table `sessions`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
LOCK TABLES `sessions` WRITE;
|
|||
|
|
/*!40000 ALTER TABLE `sessions` DISABLE KEYS */;
|
|||
|
|
/*!40000 ALTER TABLE `sessions` ENABLE KEYS */;
|
|||
|
|
UNLOCK TABLES;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Table structure for table `system_contracts`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
DROP TABLE IF EXISTS `system_contracts`;
|
|||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|||
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|||
|
|
CREATE TABLE `system_contracts` (
|
|||
|
|
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
|
|||
|
|
`name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
|
|||
|
|
`chain_id` bigint NOT NULL,
|
|||
|
|
`address` varchar(42) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|||
|
|
`deploy_block` bigint unsigned DEFAULT NULL,
|
|||
|
|
`description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
|
|||
|
|
`is_active` tinyint(1) NOT NULL DEFAULT '1',
|
|||
|
|
`created_at` datetime(3) DEFAULT NULL,
|
|||
|
|
`updated_at` datetime(3) DEFAULT NULL,
|
|||
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|||
|
|
UNIQUE KEY `uk_name_chain` (`name`,`chain_id`) USING BTREE
|
|||
|
|
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
|
|||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Dumping data for table `system_contracts`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
LOCK TABLES `system_contracts` WRITE;
|
|||
|
|
/*!40000 ALTER TABLE `system_contracts` DISABLE KEYS */;
|
|||
|
|
INSERT INTO `system_contracts` VALUES (1,'YTLPToken',97,'0x17c1100b02d560549b499561dB8d7D48fc391cf3',83948864,'ALP Pool: ytLP Pool',1,'2026-02-13 17:51:29.000','2026-02-13 17:52:47.000'),(2,'lendingProxy',97,'0xfdbFD4656b74aD16F23264121eD9F58219f5C3Cf',82970255,'Lending Market: Main Lending Market',1,'2026-02-13 17:51:29.000','2026-02-13 17:53:02.000'),(4,'YTAssetFactory',97,'0x37B2CD7D94ba1400a6FEB34804a32EfD555bbfc8',NULL,'YT Asset Factory',1,'2026-03-03 07:48:57.000','2026-03-03 07:48:57.000'),(5,'YTVault',97,'0xA6CD153c2fa0C2725605880668538660Ca21a790',NULL,'YT Vault',1,'2026-03-03 07:48:57.000','2026-03-03 07:48:57.000'),(6,'YTPriceFeed',97,'0x293d00fB683f15eA5a3143ecb551a0aCCbEC42Be',NULL,'YT Price Feed',1,'2026-03-03 07:48:57.000','2026-03-03 07:48:57.000'),(7,'YTPoolManager',97,'0xb11824eAA659F8A4648711709dA60720d5Cdabd2',NULL,'YT Liquidity Pool Manager',1,'2026-03-03 07:48:57.000','2026-03-03 07:48:57.000'),(8,'YTRewardRouter',97,'0x5af5A51F7702024E7387bba7497DC9965C00F16E',NULL,'YT Reward Router',1,'2026-03-03 07:48:57.000','2026-03-03 07:48:57.000');
|
|||
|
|
/*!40000 ALTER TABLE `system_contracts` ENABLE KEYS */;
|
|||
|
|
UNLOCK TABLES;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Table structure for table `transactions`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
DROP TABLE IF EXISTS `transactions`;
|
|||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|||
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|||
|
|
CREATE TABLE `transactions` (
|
|||
|
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
|||
|
|
`wallet_address` varchar(42) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '发起交易的钱包地址',
|
|||
|
|
`tx_hash` varchar(66) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '链上交易哈希',
|
|||
|
|
`tx_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|||
|
|
`asset_id` bigint DEFAULT NULL,
|
|||
|
|
`token_in` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
|||
|
|
`token_out` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
|||
|
|
`amount_in` decimal(30,18) DEFAULT NULL,
|
|||
|
|
`amount_out` decimal(30,18) DEFAULT NULL,
|
|||
|
|
`amount_usd` decimal(30,2) DEFAULT NULL,
|
|||
|
|
`chain_id` int NOT NULL,
|
|||
|
|
`block_number` bigint DEFAULT NULL,
|
|||
|
|
`block_timestamp` datetime DEFAULT NULL,
|
|||
|
|
`gas_used` bigint DEFAULT NULL,
|
|||
|
|
`gas_price` decimal(30,18) DEFAULT NULL,
|
|||
|
|
`status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT 'pending',
|
|||
|
|
`error_message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
|
|||
|
|
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
|
|||
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|||
|
|
UNIQUE KEY `tx_hash` (`tx_hash`) USING BTREE,
|
|||
|
|
KEY `asset_id` (`asset_id`) USING BTREE,
|
|||
|
|
KEY `idx_wallet_time` (`wallet_address`,`created_at` DESC) USING BTREE,
|
|||
|
|
CONSTRAINT `transactions_ibfk_1` FOREIGN KEY (`wallet_address`) REFERENCES `users` (`wallet_address`) ON DELETE RESTRICT ON UPDATE CASCADE,
|
|||
|
|
CONSTRAINT `transactions_ibfk_2` FOREIGN KEY (`asset_id`) REFERENCES `assets` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
|
|||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='交易记录表';
|
|||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Dumping data for table `transactions`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
LOCK TABLES `transactions` WRITE;
|
|||
|
|
/*!40000 ALTER TABLE `transactions` DISABLE KEYS */;
|
|||
|
|
/*!40000 ALTER TABLE `transactions` ENABLE KEYS */;
|
|||
|
|
UNLOCK TABLES;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Table structure for table `user_activities`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
DROP TABLE IF EXISTS `user_activities`;
|
|||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|||
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|||
|
|
CREATE TABLE `user_activities` (
|
|||
|
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
|||
|
|
`wallet_address` varchar(42) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|||
|
|
`activity_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|||
|
|
`activity_data` json DEFAULT NULL,
|
|||
|
|
`ip_address` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
|||
|
|
`user_agent` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
|
|||
|
|
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
|
|||
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|||
|
|
KEY `idx_wallet_time` (`wallet_address`,`created_at` DESC) USING BTREE,
|
|||
|
|
KEY `idx_type` (`activity_type`) USING BTREE,
|
|||
|
|
CONSTRAINT `user_activities_ibfk_1` FOREIGN KEY (`wallet_address`) REFERENCES `users` (`wallet_address`) ON DELETE RESTRICT ON UPDATE CASCADE
|
|||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='用户活动日志';
|
|||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Dumping data for table `user_activities`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
LOCK TABLES `user_activities` WRITE;
|
|||
|
|
/*!40000 ALTER TABLE `user_activities` DISABLE KEYS */;
|
|||
|
|
/*!40000 ALTER TABLE `user_activities` ENABLE KEYS */;
|
|||
|
|
UNLOCK TABLES;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Table structure for table `user_points_records`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
DROP TABLE IF EXISTS `user_points_records`;
|
|||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|||
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|||
|
|
CREATE TABLE `user_points_records` (
|
|||
|
|
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
|||
|
|
`wallet_address` varchar(42) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|||
|
|
`points_change` bigint NOT NULL,
|
|||
|
|
`points_before` bigint NOT NULL,
|
|||
|
|
`points_after` bigint NOT NULL,
|
|||
|
|
`source_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|||
|
|
`multiplier_applied` decimal(10,4) DEFAULT '1.0000',
|
|||
|
|
`source_id` bigint unsigned DEFAULT NULL,
|
|||
|
|
`rule_id` bigint DEFAULT NULL COMMENT '触发此次积分变动的规则 ID（关联 points_rules.id）',
|
|||
|
|
`description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '积分变动说明文字',
|
|||
|
|
`metadata` json DEFAULT NULL COMMENT '附加数据（JSON），含具体触发参数',
|
|||
|
|
`created_at` datetime(3) DEFAULT NULL COMMENT '记录创建时间',
|
|||
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|||
|
|
KEY `rule_id` (`rule_id`) USING BTREE,
|
|||
|
|
KEY `idx_wallet_time` (`wallet_address`,`created_at` DESC) USING BTREE,
|
|||
|
|
KEY `idx_user_points_records_wallet_address` (`wallet_address`) USING BTREE,
|
|||
|
|
CONSTRAINT `user_points_records_ibfk_1` FOREIGN KEY (`wallet_address`) REFERENCES `users` (`wallet_address`) ON DELETE RESTRICT ON UPDATE CASCADE,
|
|||
|
|
CONSTRAINT `user_points_records_ibfk_2` FOREIGN KEY (`rule_id`) REFERENCES `points_rules` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
|
|||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='积分变动记录表';
|
|||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Dumping data for table `user_points_records`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
LOCK TABLES `user_points_records` WRITE;
|
|||
|
|
/*!40000 ALTER TABLE `user_points_records` DISABLE KEYS */;
|
|||
|
|
/*!40000 ALTER TABLE `user_points_records` ENABLE KEYS */;
|
|||
|
|
UNLOCK TABLES;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Table structure for table `user_points_summary`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
DROP TABLE IF EXISTS `user_points_summary`;
|
|||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|||
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|||
|
|
CREATE TABLE `user_points_summary` (
|
|||
|
|
`wallet_address` varchar(42) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '用户钱包地址（主键）',
|
|||
|
|
`total_points` bigint DEFAULT '0',
|
|||
|
|
`holding_points` bigint DEFAULT '0',
|
|||
|
|
`lp_points` bigint DEFAULT '0',
|
|||
|
|
`lending_points` bigint DEFAULT '0',
|
|||
|
|
`trading_points` bigint DEFAULT '0',
|
|||
|
|
`invitation_points` bigint DEFAULT '0',
|
|||
|
|
`bonus_points` bigint DEFAULT '0',
|
|||
|
|
`global_rank` bigint DEFAULT NULL,
|
|||
|
|
`season_rank` bigint DEFAULT NULL,
|
|||
|
|
`current_season` bigint DEFAULT '1',
|
|||
|
|
`total_trades` bigint DEFAULT '0',
|
|||
|
|
`total_holding_days` bigint DEFAULT '0',
|
|||
|
|
`total_invites` bigint DEFAULT '0',
|
|||
|
|
`last_calculated_at` datetime(3) DEFAULT NULL,
|
|||
|
|
`updated_at` datetime(3) DEFAULT NULL,
|
|||
|
|
PRIMARY KEY (`wallet_address`) USING BTREE,
|
|||
|
|
KEY `idx_total_points` (`total_points` DESC) USING BTREE,
|
|||
|
|
CONSTRAINT `user_points_summary_ibfk_1` FOREIGN KEY (`wallet_address`) REFERENCES `users` (`wallet_address`) ON DELETE RESTRICT ON UPDATE CASCADE
|
|||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='积分汇总表';
|
|||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Dumping data for table `user_points_summary`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
LOCK TABLES `user_points_summary` WRITE;
|
|||
|
|
/*!40000 ALTER TABLE `user_points_summary` DISABLE KEYS */;
|
|||
|
|
INSERT INTO `user_points_summary` VALUES ('0x1100000000000000000000000000000000f92a',48000,28000,0,0,14000,6000,0,2,2,1,140,85,12,'2026-02-12 15:20:33.000','2026-02-12 15:20:33.000'),('0x1234567890123456789012345678901234567890',2450,1200,0,0,800,450,0,8204,8204,1,5,30,0,'2026-02-12 15:20:33.000','2026-02-12 15:20:33.000'),('0x4200000000000000000000000000000000119a',32000,20000,0,0,9000,3000,0,4,4,1,100,70,8,'2026-02-12 15:20:33.000','2026-02-12 15:20:33.000'),('0x7700000000000000000000000000000000882b',28000,18000,0,0,7000,3000,0,5,5,1,80,65,5,'2026-02-12 15:20:33.000','2026-02-12 15:20:33.000'),('0x8a00000000000000000000000000000000002291',52000,30000,0,0,15000,7000,0,1,1,1,150,90,15,'2026-02-12 15:20:33.000','2026-02-12 15:20:33.000'),('0x9c00000000000000000000000000000000003310',41000,25000,0,0,11000,5000,0,3,3,1,120,80,10,'2026-02-12 15:20:33.000','2026-02-12 15:20:33.000');
|
|||
|
|
/*!40000 ALTER TABLE `user_points_summary` ENABLE KEYS */;
|
|||
|
|
UNLOCK TABLES;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Table structure for table `user_roles`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
DROP TABLE IF EXISTS `user_roles`;
|
|||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|||
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|||
|
|
CREATE TABLE `user_roles` (
|
|||
|
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
|||
|
|
`wallet_address` varchar(42) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|||
|
|
`role_id` bigint NOT NULL,
|
|||
|
|
`expires_at` datetime DEFAULT NULL,
|
|||
|
|
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
|
|||
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|||
|
|
UNIQUE KEY `uk_wallet_role` (`wallet_address`,`role_id`) USING BTREE,
|
|||
|
|
KEY `role_id` (`role_id`) USING BTREE,
|
|||
|
|
CONSTRAINT `user_roles_ibfk_1` FOREIGN KEY (`wallet_address`) REFERENCES `users` (`wallet_address`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|||
|
|
CONSTRAINT `user_roles_ibfk_2` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
|
|||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='用户角色关联表';
|
|||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Dumping data for table `user_roles`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
LOCK TABLES `user_roles` WRITE;
|
|||
|
|
/*!40000 ALTER TABLE `user_roles` DISABLE KEYS */;
|
|||
|
|
/*!40000 ALTER TABLE `user_roles` ENABLE KEYS */;
|
|||
|
|
UNLOCK TABLES;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Table structure for table `user_teams`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
DROP TABLE IF EXISTS `user_teams`;
|
|||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|||
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|||
|
|
CREATE TABLE `user_teams` (
|
|||
|
|
`wallet_address` varchar(42) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '团队长钱包地址（主键，即邀请树的根节点）',
|
|||
|
|
`team_tvl_usd` decimal(30,2) DEFAULT '0.00' COMMENT '团队总锁仓量（USD），含所有下级成员',
|
|||
|
|
`team_target_tvl_usd` decimal(30,2) DEFAULT '10000000.00' COMMENT '团队 TVL 达标目标（USD）',
|
|||
|
|
`team_members_count` bigint DEFAULT '0',
|
|||
|
|
`whales_count` bigint DEFAULT '0',
|
|||
|
|
`whales_target` bigint DEFAULT '3',
|
|||
|
|
`traders_count` bigint DEFAULT '0',
|
|||
|
|
`traders_target` bigint DEFAULT '3',
|
|||
|
|
`users_count` bigint DEFAULT '0',
|
|||
|
|
`users_target` bigint DEFAULT '3',
|
|||
|
|
`last_calculated_at` datetime(3) DEFAULT NULL,
|
|||
|
|
`created_at` datetime(3) DEFAULT NULL,
|
|||
|
|
`updated_at` datetime(3) DEFAULT NULL,
|
|||
|
|
`team_tvlusd` decimal(30,2) DEFAULT '0.00',
|
|||
|
|
`team_target_tvlusd` decimal(30,2) DEFAULT '10000000.00',
|
|||
|
|
PRIMARY KEY (`wallet_address`) USING BTREE,
|
|||
|
|
KEY `idx_team_tvl` (`team_tvl_usd` DESC) USING BTREE,
|
|||
|
|
CONSTRAINT `fk_team_user` FOREIGN KEY (`wallet_address`) REFERENCES `users` (`wallet_address`) ON DELETE RESTRICT ON UPDATE CASCADE
|
|||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='用户团队统计表';
|
|||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Dumping data for table `user_teams`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
LOCK TABLES `user_teams` WRITE;
|
|||
|
|
/*!40000 ALTER TABLE `user_teams` DISABLE KEYS */;
|
|||
|
|
INSERT INTO `user_teams` VALUES ('0x1234567890123456789012345678901234567890',8500000.00,10000000.00,12,3,3,0,3,5,3,'2026-02-13 14:46:55.000','2026-02-13 14:46:55.000','2026-02-13 14:46:55.000',0.00,10000000.00);
|
|||
|
|
/*!40000 ALTER TABLE `user_teams` ENABLE KEYS */;
|
|||
|
|
UNLOCK TABLES;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Table structure for table `users`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
DROP TABLE IF EXISTS `users`;
|
|||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|||
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|||
|
|
CREATE TABLE `users` (
|
|||
|
|
`wallet_address` varchar(42) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '以太坊钱包地址，Web3 唯一身份标识（主键）',
|
|||
|
|
`nickname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
|||
|
|
`avatar` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
|
|||
|
|
`bio` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
|
|||
|
|
`referrer_wallet` varchar(42) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
|||
|
|
`invite_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
|||
|
|
`direct_invites_count` bigint DEFAULT '0',
|
|||
|
|
`member_tier` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT 'Bronze',
|
|||
|
|
`vip_level` int DEFAULT '1' COMMENT 'VIP 等级数值，与 vip_tiers.tier_level 对应',
|
|||
|
|
`total_points` bigint DEFAULT '0',
|
|||
|
|
`global_rank` bigint DEFAULT NULL,
|
|||
|
|
`created_at` datetime(3) DEFAULT NULL,
|
|||
|
|
`updated_at` datetime(3) DEFAULT NULL,
|
|||
|
|
`v_ip_level` bigint DEFAULT '1',
|
|||
|
|
PRIMARY KEY (`wallet_address`) USING BTREE,
|
|||
|
|
UNIQUE KEY `uni_users_invite_code` (`invite_code`) USING BTREE,
|
|||
|
|
KEY `idx_referrer_wallet` (`referrer_wallet`) USING BTREE,
|
|||
|
|
KEY `idx_rank` (`global_rank`) USING BTREE,
|
|||
|
|
KEY `idx_users_referrer_wallet` (`referrer_wallet`) USING BTREE,
|
|||
|
|
KEY `idx_users_invite_code` (`invite_code`) USING BTREE,
|
|||
|
|
KEY `idx_users_global_rank` (`global_rank`) USING BTREE,
|
|||
|
|
CONSTRAINT `users_ibfk_1` FOREIGN KEY (`referrer_wallet`) REFERENCES `users` (`wallet_address`) ON DELETE SET NULL ON UPDATE CASCADE
|
|||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='用户账户表（以钱包地址为唯一标识）';
|
|||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Dumping data for table `users`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
LOCK TABLES `users` WRITE;
|
|||
|
|
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
|
|||
|
|
INSERT INTO `users` VALUES ('0x1100000000000000000000000000000000f92a','Top Performer 2',NULL,NULL,NULL,'TOP2-0002',12,'Gold',4,48000,2,'2026-02-12 15:20:33.000','2026-02-12 15:20:33.000',1),('0x1234567890123456789012345678901234567890','Demo User',NULL,NULL,NULL,'PR0T0-8821',0,'Silver',2,2450,8204,'2026-02-12 15:20:33.000','2026-02-12 15:20:33.000',1),('0x4200000000000000000000000000000000119a','Top Performer 4',NULL,NULL,NULL,'TOP4-0004',8,'Silver',2,32000,4,'2026-02-12 15:20:33.000','2026-02-12 15:20:33.000',1),('0x7700000000000000000000000000000000882b','Top Performer 5',NULL,NULL,NULL,'TOP5-0005',5,'Bronze',1,28000,5,'2026-02-12 15:20:33.000','2026-02-12 15:20:33.000',1),('0x8a00000000000000000000000000000000002291','Top Performer 1',NULL,NULL,NULL,'TOP1-0001',15,'Gold',5,52000,1,'2026-02-12 15:20:33.000','2026-02-12 15:20:33.000',1),('0x9c00000000000000000000000000000000003310','Top Performer 3',NULL,NULL,NULL,'TOP3-0003',10,'Silver',3,41000,3,'2026-02-12 15:20:33.000','2026-02-12 15:20:33.000',1),('0xa013422a5918cd099c63c8cc35283eaca99a705d','','','',NULL,'MJGYDORD',0,'Bronze',1,0,NULL,'2026-02-27 10:29:22.197','2026-02-27 10:29:22.197',1);
|
|||
|
|
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
|
|||
|
|
UNLOCK TABLES;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Table structure for table `vip_tiers`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
DROP TABLE IF EXISTS `vip_tiers`;
|
|||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|||
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|||
|
|
CREATE TABLE `vip_tiers` (
|
|||
|
|
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
|||
|
|
`tier_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|||
|
|
`tier_level` bigint NOT NULL,
|
|||
|
|
`min_points` bigint NOT NULL,
|
|||
|
|
`max_points` bigint DEFAULT NULL,
|
|||
|
|
`multiplier` decimal(10,4) DEFAULT '1.0000',
|
|||
|
|
`perks` json DEFAULT NULL,
|
|||
|
|
`icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
|||
|
|
`color` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
|||
|
|
`display_order` bigint DEFAULT '0',
|
|||
|
|
`is_active` tinyint(1) DEFAULT '1',
|
|||
|
|
`created_at` datetime(3) DEFAULT NULL,
|
|||
|
|
`updated_at` datetime(3) DEFAULT NULL,
|
|||
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|||
|
|
UNIQUE KEY `uni_vip_tiers_tier_level` (`tier_level`) USING BTREE,
|
|||
|
|
KEY `idx_min_points` (`min_points`) USING BTREE,
|
|||
|
|
KEY `idx_vip_tiers_tier_level` (`tier_level`) USING BTREE,
|
|||
|
|
KEY `idx_vip_tiers_min_points` (`min_points`) USING BTREE
|
|||
|
|
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='VIP等级配置表';
|
|||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Dumping data for table `vip_tiers`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
LOCK TABLES `vip_tiers` WRITE;
|
|||
|
|
/*!40000 ALTER TABLE `vip_tiers` DISABLE KEYS */;
|
|||
|
|
INSERT INTO `vip_tiers` VALUES (1,'Bronze',1,0,999,1.0000,'{\"perks\": [\"Basic rewards\", \"Standard support\"]}','/icons/vip/bronze.svg','#CD7F32',1,1,'2026-02-13 14:46:55.000','2026-02-13 14:46:55.000'),(2,'Silver',2,1000,2999,1.2000,'{\"perks\": [\"1.2x multiplier\", \"Priority support\", \"Exclusive events\"]}','/icons/vip/silver.svg','#C0C0C0',2,1,'2026-02-13 14:46:55.000','2026-02-13 14:46:55.000'),(3,'Gold',3,3000,9999,1.5000,'{\"perks\": [\"1.5x multiplier\", \"VIP support\", \"Early access\", \"Monthly airdrops\"]}','/icons/vip/gold.svg','#FFD700',3,1,'2026-02-13 14:46:55.000','2026-02-13 14:46:55.000'),(4,'Platinum',4,10000,NULL,2.0000,'{\"perks\": [\"2x multiplier\", \"Dedicated manager\", \"All gold perks\", \"Governance rights\"]}','/icons/vip/platinum.svg','#E5E4E2',4,1,'2026-02-13 14:46:55.000','2026-02-13 14:46:55.000');
|
|||
|
|
/*!40000 ALTER TABLE `vip_tiers` ENABLE KEYS */;
|
|||
|
|
UNLOCK TABLES;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Table structure for table `yt_swap_records`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
DROP TABLE IF EXISTS `yt_swap_records`;
|
|||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|||
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|||
|
|
CREATE TABLE `yt_swap_records` (
|
|||
|
|
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
|
|||
|
|
`tx_hash` varchar(66) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
|||
|
|
`log_index` bigint unsigned DEFAULT NULL,
|
|||
|
|
`chain_id` bigint DEFAULT NULL,
|
|||
|
|
`block_number` bigint unsigned DEFAULT NULL,
|
|||
|
|
`block_time` datetime(3) DEFAULT NULL,
|
|||
|
|
`vault_addr` varchar(42) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
|||
|
|
`account` varchar(42) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
|||
|
|
`token_in` varchar(42) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
|||
|
|
`token_out` varchar(42) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
|||
|
|
`amount_in` varchar(78) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
|||
|
|
`amount_out` varchar(78) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
|||
|
|
`created_at` datetime(3) DEFAULT NULL,
|
|||
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|||
|
|
UNIQUE KEY `uk_tx_log` (`tx_hash`,`log_index`) USING BTREE,
|
|||
|
|
KEY `idx_yt_swap_records_chain_id` (`chain_id`) USING BTREE,
|
|||
|
|
KEY `idx_yt_swap_records_block_time` (`block_time`) USING BTREE,
|
|||
|
|
KEY `idx_yt_swap_records_vault_addr` (`vault_addr`) USING BTREE,
|
|||
|
|
KEY `idx_yt_swap_records_account` (`account`) USING BTREE
|
|||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
|
|||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Dumping data for table `yt_swap_records`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
LOCK TABLES `yt_swap_records` WRITE;
|
|||
|
|
/*!40000 ALTER TABLE `yt_swap_records` DISABLE KEYS */;
|
|||
|
|
/*!40000 ALTER TABLE `yt_swap_records` ENABLE KEYS */;
|
|||
|
|
UNLOCK TABLES;
|
|||
|
|
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
|
|||
|
|
|
|||
|
|
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
|
|||
|
|
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
|
|||
|
|
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
|
|||
|
|
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
|
|||
|
|
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
|
|||
|
|
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
|||
|
|
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
|||
|
|
|
|||
|
|
-- Dump completed on 2026-03-27 17:01:58
|