2 files changed, 19 insertions, 0 deletions
diff --git a/purge.sql b/purge.sql
new file mode 100644
index 0000000..03eecc3
--- /dev/null
+++ b/purge.sql
@@ -0,0 +1,2 @@
+DROP SCHEMA public CASCADE;
+CREATE SCHEMA public;
diff --git a/test.sql b/test.sql
new file mode 100644
index 0000000..43c898f
--- /dev/null
+++ b/test.sql
@@ -0,0 +1,17 @@
+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
+)
+INSERT INTO repos (name, group_id, contrib_requirements, filesystem_path)
+SELECT 'server', id, 'public', '/home/runxiyu/Lindenii/forge/server/.git'
+FROM child_group;
+
+SELECT * FROM groups;
+SELECT * FROM repos;