about summary refs log tree commit diff
path: root/pkgs/development/lisp-modules-new-obsolete/import/init.sql
diff options
context:
space:
mode:
Diffstat (limited to 'pkgs/development/lisp-modules-new-obsolete/import/init.sql')
-rw-r--r--pkgs/development/lisp-modules-new-obsolete/import/init.sql41
1 files changed, 0 insertions, 41 deletions
diff --git a/pkgs/development/lisp-modules-new-obsolete/import/init.sql b/pkgs/development/lisp-modules-new-obsolete/import/init.sql
deleted file mode 100644
index 872d51d598ffb..0000000000000
--- a/pkgs/development/lisp-modules-new-obsolete/import/init.sql
+++ /dev/null
@@ -1,41 +0,0 @@
-CREATE TABLE IF NOT EXISTS sha256 (
-       id        integer PRIMARY KEY AUTOINCREMENT,
-       url       text    UNIQUE,
-       hash      text    NOT NULL,
-       created   real    DEFAULT (julianday('now'))
-);
-
-CREATE TABLE IF NOT EXISTS system (
-       id        integer PRIMARY KEY AUTOINCREMENT,
-       name      text NOT NULL,
-       version   text NOT NULL,
-       asd       text NOT NULL,
-       created   real    DEFAULT (julianday('now')),
-       UNIQUE(name, version)
-);
-
-CREATE TABLE IF NOT EXISTS dep (
-       system_id integer NOT NULL REFERENCES system(id),
-       dep_id    integer NOT NULL REFERENCES system(id),
-       PRIMARY KEY (system_id, dep_id)
-);
-
-CREATE TABLE IF NOT EXISTS src (
-       sha256_id integer REFERENCES sha256(id),
-       system_id integer UNIQUE REFERENCES system(id)
-);
-
-DROP VIEW IF EXISTS system_view;
-CREATE VIEW IF NOT EXISTS system_view AS
-  SELECT
-    sys.name,
-    sys.version,
-    sys.asd,
-    sha.url,
-    sha.hash,
-    group_concat((SELECT name FROM system WHERE id = dep.dep_id)) as deps
-  FROM system sys
-  JOIN src ON src.system_id = sys.id
-  JOIN sha256 sha ON sha.id = src.sha256_id
-  LEFT JOIN dep ON dep.system_id = sys.id
-  GROUP BY sys.name;