test_database.db•32.8 kB
SQLite format 3 @ .~Y
� �
�
;�k� � �77�Otableactivity_participantsactivity_participantsCREATE TABLE activity_participants (
id INTEGER PRIMARY KEY AUTOINCREMENT,
activity_id INTEGER NOT NULL,
user_id INTEGER NOT NULL,
status VARCHAR(20) DEFAULT 'registered',
registration_time DATETIME DEFAULT CURRENT_TIMESTAMP,
notes TEXT,
FOREIGN KEY (activity_id) REFERENCES activities(id),
FOREIGN KEY (user_id) REFERENCES users(id),
UNIQUE(activity_id, user_id)
)I]7 indexsqlite_autoindex_activity_participants_1activity_participants�-�9tableusersusersCREATE TABLE users (
id INTEGER PRIMARY KEY AUTOINCREMENT,
username VARCHAR(50) UNIQUE NOT NULL,
email VARCHAR(100) UNIQUE NOT NULL,
password_hash VARCHAR(255) NOT NULL,
full_name VARCHAR(100),
phone VARCHAR(20),
avatar_url VARCHAR(255),
is_active BOOLEAN DEFAULT 1,
role VARCHAR(20) DEFAULT 'user',
created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
updated_at DATETIME DEFAULT CURRENT_TIMESTAMP
))= indexsqlite_autoindex_users_2users)= indexsqlite_autoindex_users_1users P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)�b!!�tableactivitiesactivitiesCREATE TABLE activities (
id INTEGER PRIMARY KEY AUTOINCREMENT,
title VARCHAR(255) NOT NULL,
description TEXT,
start_time DATETIME NOT NULL,
end_time DATETIME NOT NULL,
location VARCHAR(255),
organizer VARCHAR(100) NOT NULL,
max_participants INTEGER DEFAULT 0,
current_participants INTEGER DEFAULT 0,
status VARCHAR(20) DEFAULT 'active',
category VARCHAR(50),
price DECIMAL(10,2) DEFAULT 0.00,
is_public BOOLEAN DEFAULT 1,
created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
updated_at DATETIME DEFAULT CURRENT_TIMESTAMP
)
� <�
� �+ +I33% 33产品发布会新产品功能介绍和演示2024-02-10 10:00:002024-02-10 12:00:00大会议室产品部dactive产品2025-07-29 05:39:492025-07-29 05:39:49�9 1O331 33团队建设活动户外团队建设和拓展训练2024-02-05 09:00:002024-02-05 18:00:00户外拓展基地人事部active团建 �2025-07-29 05:39:492025-07-29 05:39:49�A 9_33!% 33Python 编程分享会分享 Python 编程技巧和最佳实践2024-02-01 14:00:002024-02-01 17:00:00会议室A技术部2active技术分享2025-07-29 05:39:492025-07-29 05:39:49
� �� users!activities
� �� | !-3)# 33jane_smithjane@example.comhashed_password_789简·史密斯13800138002user2025-07-29 05:39:492025-07-29 05:39:49z -3)# 33john_doejohn@example.comhashed_password_456约翰·多伊13800138001user2025-07-29 05:39:492025-07-29 05:39:49t /3# 33adminadmin@example.comhashed_password_123管理员13800138000admin2025-07-29 05:39:492025-07-29 05:39:49
� ��� !jane_smithjohn_doe admin
� ��� -jane@example.com-john@example.com/ admin@example.com