65 lines
9.1 KiB
SQL
65 lines
9.1 KiB
SQL
-- 本地演示数据：4 条已上架商品（仅用于开发环境，禁止在生产执行）。
|
||
-- 依赖：MySQL 8；phone 前缀 138000090 用于重复执行时清理。
|
||
|
||
DELETE l FROM rental_listings l JOIN users u ON u.id = l.owner_id WHERE u.phone LIKE '138000090%';
|
||
DELETE ga FROM game_accounts ga JOIN users u ON u.id = ga.owner_id WHERE u.phone LIKE '138000090%';
|
||
DELETE FROM users WHERE phone LIKE '138000090%';
|
||
|
||
INSERT INTO users (phone, password_hash, nickname, realname_status, status) VALUES
|
||
('13800009001', '$2a$10$demo.demo.demo.demo.demo.demo.demo.demo.demo.demo', '号主·老白', 'verified', 'active'),
|
||
('13800009002', '$2a$10$demo.demo.demo.demo.demo.demo.demo.demo.demo.demo', '号主·阿岚', 'verified', 'active'),
|
||
('13800009003', '$2a$10$demo.demo.demo.demo.demo.demo.demo.demo.demo.demo', '号主·北屿', 'verified', 'active'),
|
||
('13800009004', '$2a$10$demo.demo.demo.demo.demo.demo.demo.demo.demo.demo', '号主·临江', 'verified', 'active');
|
||
|
||
-- 1) 53M / 3*3 / 黑鹰
|
||
SET @u1 = (SELECT id FROM users WHERE phone = '13800009001');
|
||
INSERT INTO game_accounts
|
||
(owner_id, game_name, server_region, login_platform, title, description, rank_level, haf_coin_amount, asset_summary, screenshot_urls, status)
|
||
VALUES
|
||
(@u1, 'delta_force', 'QQ', '扫码', '解忧柜选 · 三角洲行动 高资产账号',
|
||
'哈夫币 53M，保险 3*3，刀皮坠星者，红皮四件，适合稳定上分与搬砖。', '黑鹰', 53000000,
|
||
CAST('{"season_insurance":"3*3","stamina_level":"7级","load_level":"7级","fire_level":60,"daily_loss_m":10,"secret_kd":3.2,"early_morning_response":"是","modifiable_name":"是","all_heroes":"是","online_time":{"start":"12点","end":"次日02点"},"skin_groups":{"melee":["坠星者"],"operatorRed":["红狼-电锯惊魂","蜂医-危险物质","蜂医-迷葬人","无名-夜鹰"],"operatorGold":["蚀金玫瑰"],"weapon":["AKM-群星"]},"screenshot_groups":{"coin":["https://picsum.photos/seed/jieyou-1-coin/1200/750"],"gameId":["https://picsum.photos/seed/jieyou-1-game/1200/750"],"totalAsset":["https://picsum.photos/seed/jieyou-1-asset/1200/750"],"tencentSecurity":["https://picsum.photos/seed/jieyou-1-safe/1200/750"],"skin":["https://picsum.photos/seed/jieyou-1-skin/1200/750"]},"publish_ratio":35,"resources":[{"key":"level6Ammo","label":"6级弹","quantity":99,"mode":"付费"},{"key":"awmAmmo","label":"AWM子弹","quantity":6,"mode":"付费"},{"key":"armor6","label":"6甲","quantity":8,"mode":"付费"},{"key":"helmet6","label":"6头","quantity":8,"mode":"付费"},{"key":"coffeeBean","label":"高级咖啡豆","quantity":23,"mode":"付费"}]}' AS JSON),
|
||
CAST('["https://picsum.photos/seed/jieyou-1-coin/1200/750","https://picsum.photos/seed/jieyou-1-game/1200/750","https://picsum.photos/seed/jieyou-1-asset/1200/750","https://picsum.photos/seed/jieyou-1-safe/1200/750","https://picsum.photos/seed/jieyou-1-skin/1200/750"]' AS JSON), 'published');
|
||
SET @a1 = LAST_INSERT_ID();
|
||
INSERT INTO rental_listings (listing_no, account_id, owner_id, price_cent, deposit_amount_cent, status, review_status, published_at)
|
||
VALUES ('202610310001', @a1, @u1, 25580, 75000, 'published', 'approved', NOW() - INTERVAL 6 MINUTE);
|
||
|
||
-- 2) 800M / 2*3 / 铂金（含赠送物资，进入赠送专区）
|
||
SET @u2 = (SELECT id FROM users WHERE phone = '13800009002');
|
||
INSERT INTO game_accounts
|
||
(owner_id, game_name, server_region, login_platform, title, description, rank_level, haf_coin_amount, asset_summary, screenshot_urls, status)
|
||
VALUES
|
||
(@u2, 'delta_force', '微信', '扫码', '解忧柜选 · 800M 顶配红皮账号',
|
||
'哈夫币 800M，红皮与金皮齐全，适合高强度对局与直播。', '铂金', 800000000,
|
||
CAST('{"season_insurance":"2*3","stamina_level":"7级","load_level":"7级","fire_level":62,"daily_loss_m":20,"secret_kd":4.1,"early_morning_response":"是","modifiable_name":"否","all_heroes":"是","online_time":{"start":"13点","end":"次日01点"},"skin_groups":{"melee":["暗星"],"operatorRed":["红狼-电锯惊魂","蜂医-危险物质","威龙-吴彦祖","疾风-西部往事"],"operatorGold":["露娜-金牌射手"],"weapon":["AKM-群星"]},"screenshot_groups":{"coin":["https://picsum.photos/seed/jieyou-2-coin/1200/750"],"gameId":["https://picsum.photos/seed/jieyou-2-game/1200/750"],"totalAsset":["https://picsum.photos/seed/jieyou-2-asset/1200/750"],"tencentSecurity":["https://picsum.photos/seed/jieyou-2-safe/1200/750"],"skin":["https://picsum.photos/seed/jieyou-2-skin/1200/750"]},"publish_ratio":46,"resources":[{"key":"level6Ammo","label":"6级弹","quantity":217,"mode":"付费"},{"key":"armor6","label":"6甲","quantity":6,"mode":"付费"},{"key":"helmet6","label":"6头","quantity":5,"mode":"付费"},{"key":"gridCard9","label":"9格体验卡","quantity":2,"mode":"赠送"}]}' AS JSON),
|
||
CAST('["https://picsum.photos/seed/jieyou-2-coin/1200/750","https://picsum.photos/seed/jieyou-2-game/1200/750","https://picsum.photos/seed/jieyou-2-asset/1200/750","https://picsum.photos/seed/jieyou-2-safe/1200/750","https://picsum.photos/seed/jieyou-2-skin/1200/750"]' AS JSON), 'published');
|
||
SET @a2 = LAST_INSERT_ID();
|
||
INSERT INTO rental_listings (listing_no, account_id, owner_id, price_cent, deposit_amount_cent, status, review_status, published_at)
|
||
VALUES ('202610310002', @a2, @u2, 191350, 30000, 'published', 'approved', NOW() - INTERVAL 5 MINUTE);
|
||
|
||
-- 3) 220M / 3*3 / 黑鹰
|
||
SET @u3 = (SELECT id FROM users WHERE phone = '13800009003');
|
||
INSERT INTO game_accounts
|
||
(owner_id, game_name, server_region, login_platform, title, description, rank_level, haf_coin_amount, asset_summary, screenshot_urls, status)
|
||
VALUES
|
||
(@u3, 'delta_force', 'QQ', '扫码', '解忧柜选 · 220M 性价比账号',
|
||
'哈夫币 220M，AWM 子弹充足，适合狙击位玩家。', '黑鹰', 220000000,
|
||
CAST('{"season_insurance":"3*3","stamina_level":"7级","load_level":"7级","fire_level":58,"daily_loss_m":15,"secret_kd":2.8,"early_morning_response":"是","modifiable_name":"否","all_heroes":"是","online_time":{"start":"08点","end":"次日01点"},"skin_groups":{"melee":["北极星"],"operatorRed":["红狼-电锯惊魂","维什戴尔"],"weapon":["AKM-群星"]},"screenshot_groups":{"coin":["https://picsum.photos/seed/jieyou-3-coin/1200/750"],"gameId":["https://picsum.photos/seed/jieyou-3-game/1200/750"],"totalAsset":["https://picsum.photos/seed/jieyou-3-asset/1200/750"],"tencentSecurity":["https://picsum.photos/seed/jieyou-3-safe/1200/750"],"skin":["https://picsum.photos/seed/jieyou-3-skin/1200/750"]},"publish_ratio":40,"resources":[{"key":"awmAmmo","label":"AWM子弹","quantity":77,"mode":"付费"},{"key":"armor6","label":"6甲","quantity":1,"mode":"付费"},{"key":"helmet6","label":"6头","quantity":2,"mode":"付费"}]}' AS JSON),
|
||
CAST('["https://picsum.photos/seed/jieyou-3-coin/1200/750","https://picsum.photos/seed/jieyou-3-game/1200/750","https://picsum.photos/seed/jieyou-3-asset/1200/750","https://picsum.photos/seed/jieyou-3-safe/1200/750","https://picsum.photos/seed/jieyou-3-skin/1200/750"]' AS JSON), 'published');
|
||
SET @a3 = LAST_INSERT_ID();
|
||
INSERT INTO rental_listings (listing_no, account_id, owner_id, price_cent, deposit_amount_cent, status, review_status, published_at)
|
||
VALUES ('202610310003', @a3, @u3, 60940, 50000, 'published', 'approved', NOW() - INTERVAL 4 MINUTE);
|
||
|
||
-- 4) 508M / 3*3 / 黑鹰 / 账密登录
|
||
SET @u4 = (SELECT id FROM users WHERE phone = '13800009004');
|
||
INSERT INTO game_accounts
|
||
(owner_id, game_name, server_region, login_platform, title, description, rank_level, haf_coin_amount, asset_summary, screenshot_urls, status)
|
||
VALUES
|
||
(@u4, 'delta_force', 'Steam', '账号密码', '解忧柜选 · 508M 账密直登账号',
|
||
'哈夫币 508M，支持账密直登，仓库物资齐全。', '黑鹰', 508000000,
|
||
CAST('{"season_insurance":"3*3","stamina_level":"7级","load_level":"7级","fire_level":60,"daily_loss_m":12,"secret_kd":3.6,"early_morning_response":"是","modifiable_name":"是","all_heroes":"是","online_time":{"start":"全天","end":"全天"},"skin_groups":{"melee":["重塑"],"operatorRed":["红狼-电锯惊魂"],"weapon":["AKM-群星"]},"screenshot_groups":{"coin":["https://picsum.photos/seed/jieyou-4-coin/1200/750"],"gameId":["https://picsum.photos/seed/jieyou-4-game/1200/750"],"totalAsset":["https://picsum.photos/seed/jieyou-4-asset/1200/750"],"tencentSecurity":["https://picsum.photos/seed/jieyou-4-safe/1200/750"],"skin":["https://picsum.photos/seed/jieyou-4-skin/1200/750"]},"publish_ratio":46,"resources":[{"key":"awmAmmo","label":"AWM子弹","quantity":50,"mode":"付费"},{"key":"armor6","label":"6甲","quantity":7,"mode":"付费"},{"key":"helmet6","label":"6头","quantity":5,"mode":"付费"},{"key":"coffeeBean","label":"高级咖啡豆","quantity":3,"mode":"付费"}]}' AS JSON),
|
||
CAST('["https://picsum.photos/seed/jieyou-4-coin/1200/750","https://picsum.photos/seed/jieyou-4-game/1200/750","https://picsum.photos/seed/jieyou-4-asset/1200/750","https://picsum.photos/seed/jieyou-4-safe/1200/750","https://picsum.photos/seed/jieyou-4-skin/1200/750"]' AS JSON), 'published');
|
||
SET @a4 = LAST_INSERT_ID();
|
||
INSERT INTO rental_listings (listing_no, account_id, owner_id, price_cent, deposit_amount_cent, status, review_status, published_at)
|
||
VALUES ('202610310004', @a4, @u4, 117180, 60000, 'published', 'approved', NOW() - INTERVAL 3 MINUTE);
|