diff options
| author | Runxi Yu <me@runxiyu.org> | 2025-04-05 12:46:21 +0800 |
|---|---|---|
| committer | Runxi Yu <me@runxiyu.org> | 2025-04-05 12:46:21 +0800 |
| commit | ff58c1200bb7e787918a48bfc309b8268257546d (patch) | |
| tree | f12443cec0b1f36cdb6d05d18ce5f67a96da8006 /sql | |
| parent | HTTP: Make the tree and raw endpoints use git2d (diff) | |
| download | forge-ff58c1200bb7e787918a48bfc309b8268257546d.tar.gz forge-ff58c1200bb7e787918a48bfc309b8268257546d.tar.zst forge-ff58c1200bb7e787918a48bfc309b8268257546d.zip | |
SQL: Remove purge.sql and test.sql as outdated and unnecessaryv0.1.18
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/purge.sql | 5 | ||||
| -rw-r--r-- | sql/test.sql | 40 |
2 files changed, 0 insertions, 45 deletions
diff --git a/sql/purge.sql b/sql/purge.sql deleted file mode 100644 index 6699817..0000000 --- a/sql/purge.sql +++ /dev/null @@ -1,5 +0,0 @@ --- SPDX-License-Identifier: AGPL-3.0-only --- SPDX-FileCopyrightText: Copyright (c) 2025 Runxi Yu <https://runxiyu.org> - -DROP SCHEMA public CASCADE; -CREATE SCHEMA public; diff --git a/sql/test.sql b/sql/test.sql deleted file mode 100644 index a016df9..0000000 --- a/sql/test.sql +++ /dev/null @@ -1,40 +0,0 @@ --- SPDX-License-Identifier: AGPL-3.0-only --- SPDX-FileCopyrightText: Copyright (c) 2025 Runxi Yu <https://runxiyu.org> - -WITH parent_group AS ( - INSERT INTO groups (name, description) - VALUES ('lindenii', 'The Lindenii Project') - RETURNING id -), -child_group AS ( - INSERT INTO groups (name, description, parent_group) - SELECT 'forge', 'Lindenii Forge', id - FROM parent_group - RETURNING id -), -create_repos AS ( - INSERT INTO repos (name, group_id, contrib_requirements, filesystem_path) - SELECT 'server', id, 'public', '/home/runxiyu/Lindenii/forge/server/.git' - FROM child_group -), -new_user AS ( - INSERT INTO users (username, type, password) - VALUES ('test', 'registered', '$argon2id$v=19$m=4096,t=3,p=1$YWFhYWFhYWFhYWFh$i40k7TPFHqXRH4eQOAYGH3LvzwQ38jqqlfap9Rtiy3c') - RETURNING id -), -new_ssh AS ( - INSERT INTO ssh_public_keys (key_string, user_id) - SELECT 'ssh-ed25519 AAAAC3NzaC1lZDI1NTE5AAAAIAuavKDhEM1L6CufIecy2P712gp151CqZuwSYahTWvmq', id - FROM new_user - RETURNING user_id -) -INSERT INTO user_group_roles (group_id, user_id) -SELECT child_group.id, new_ssh.user_id -FROM child_group, new_ssh; - -SELECT * FROM groups; -SELECT * FROM repos; -SELECT * FROM users; -SELECT * FROM ssh_public_keys; -SELECT * FROM user_group_roles; - |