# Project-PasswdManagement

**Repository Path**: ckorig/project-password-management

## Basic Information

- **Project Name**: Project-PasswdManagement
- **Description**: Project-PasswdManagement
- **Primary Language**: Python
- **License**: MulanPSL-2.0
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2026-01-29
- **Last Updated**: 2026-01-30

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# 界面功能模块

![](pic/001.png)
![](pic/002.png)
![](pic/003.png)
![](pic/004.png)

# database scripts

```
-- 创建数据库
CREATE DATABASE IF NOT EXISTS secret_management CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- 使用数据库
USE secret_management;

-- 用户表
CREATE TABLE IF NOT EXISTS user (
    id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(64) NOT NULL UNIQUE,
    password_hash VARCHAR(128) NOT NULL,
    is_admin BOOLEAN DEFAULT FALSE,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

-- 项目表
CREATE TABLE IF NOT EXISTS project (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(128) NOT NULL UNIQUE,
    description TEXT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

-- 密码表
CREATE TABLE IF NOT EXISTS password (
    id INT AUTO_INCREMENT PRIMARY KEY,
    project_id INT NOT NULL,
    username VARCHAR(128) NOT NULL,
    password VARCHAR(256) NOT NULL,  -- 存储加密后的密码
    host VARCHAR(256),
    notes TEXT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (project_id) REFERENCES project(id) ON DELETE CASCADE
);

-- 用户项目关联表
CREATE TABLE IF NOT EXISTS user_project (
    user_id INT NOT NULL,
    project_id INT NOT NULL,
    can_edit BOOLEAN DEFAULT FALSE,
    PRIMARY KEY (user_id, project_id),
    FOREIGN KEY (user_id) REFERENCES user(id) ON DELETE CASCADE,
    FOREIGN KEY (project_id) REFERENCES project(id) ON DELETE CASCADE
);

-- 插入初始管理员账户
INSERT INTO users (username, password_hash, email, is_admin) 
VALUES ('admin', '$pbkdf2-sha256$29000$Q1xQ8vZ7KJg3Xa6L5k9JFw$d.dQ7dQ8lJ3mK5oN6pQ2rS3tW4xY7zB1vC2eF3gH4j', 'yunwei@irissz.com', TRUE);

UPDATE users 
SET password_hash = '$pbkdf2-sha256$29000$5BxD6N2bM.Ycg5ByTqm1tg$Ff0nulneLPJELQkss6pXFjjlxo1JuiK.aBp2sXNbf3M'
WHERE username = 'admin';

ALTER TABLE users MODIFY COLUMN password_hash VARCHAR(256);
```