diff options
Diffstat (limited to 'pkgs/development/lisp-modules-new-obsolete/import/init.sql')
-rw-r--r-- | pkgs/development/lisp-modules-new-obsolete/import/init.sql | 41 |
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; |