From 68e18ad1f44e9a6fab66adc38e97d027a58de8a4 Mon Sep 17 00:00:00 2001
From: Rob Austein <sra@hactrn.net>
Date: Sun, 14 Feb 2021 16:56:57 +0000
Subject: Another reorg, and pelican samples

---
 tools/references/schema.sql | 177 --------------------------------------------
 1 file changed, 177 deletions(-)
 delete mode 100644 tools/references/schema.sql

(limited to 'tools/references/schema.sql')

diff --git a/tools/references/schema.sql b/tools/references/schema.sql
deleted file mode 100644
index 1515dbb..0000000
--- a/tools/references/schema.sql
+++ /dev/null
@@ -1,177 +0,0 @@
-CREATE TABLE system (
-    name text PRIMARY KEY,
-    value text
-);
-CREATE TABLE permission (
-    username text,
-    action text,
-    UNIQUE (username,action)
-);
-CREATE TABLE auth_cookie (
-    cookie text,
-    name text,
-    ipnr text,
-    time integer,
-    UNIQUE (cookie,ipnr,name)
-);
-CREATE TABLE session (
-    sid text,
-    authenticated integer,
-    last_visit integer,
-    UNIQUE (sid,authenticated)
-);
-CREATE INDEX session_last_visit_idx ON session (last_visit);
-CREATE INDEX session_authenticated_idx ON session (authenticated);
-CREATE TABLE session_attribute (
-    sid text,
-    authenticated integer,
-    name text,
-    value text,
-    UNIQUE (sid,authenticated,name)
-);
-CREATE TABLE cache (
-    id integer PRIMARY KEY,
-    generation integer,
-    key text
-);
-CREATE TABLE attachment (
-    type text,
-    id text,
-    filename text,
-    size integer,
-    time integer,
-    description text,
-    author text,
-    ipnr text,
-    UNIQUE (type,id,filename)
-);
-CREATE TABLE wiki (
-    name text,
-    version integer,
-    time integer,
-    author text,
-    ipnr text,
-    text text,
-    comment text,
-    readonly integer,
-    UNIQUE (name,version)
-);
-CREATE INDEX wiki_time_idx ON wiki (time);
-CREATE TABLE repository (
-    id integer,
-    name text,
-    value text,
-    UNIQUE (id,name)
-);
-CREATE TABLE revision (
-    repos integer,
-    rev text,
-    time integer,
-    author text,
-    message text,
-    UNIQUE (repos,rev)
-);
-CREATE INDEX revision_repos_time_idx ON revision (repos,time);
-CREATE TABLE ticket (
-    id integer PRIMARY KEY,
-    type text,
-    time integer,
-    changetime integer,
-    component text,
-    severity text,
-    priority text,
-    owner text,
-    reporter text,
-    cc text,
-    version text,
-    milestone text,
-    status text,
-    resolution text,
-    summary text,
-    description text,
-    keywords text
-);
-CREATE INDEX ticket_time_idx ON ticket (time);
-CREATE INDEX ticket_status_idx ON ticket (status);
-CREATE TABLE ticket_change (
-    ticket integer,
-    time integer,
-    author text,
-    field text,
-    oldvalue text,
-    newvalue text,
-    UNIQUE (ticket,time,field)
-);
-CREATE INDEX ticket_change_ticket_idx ON ticket_change (ticket);
-CREATE INDEX ticket_change_time_idx ON ticket_change (time);
-CREATE TABLE ticket_custom (
-    ticket integer,
-    name text,
-    value text,
-    UNIQUE (ticket,name)
-);
-CREATE TABLE enum (
-    type text,
-    name text,
-    value text,
-    UNIQUE (type,name)
-);
-CREATE TABLE component (
-    name text PRIMARY KEY,
-    owner text,
-    description text
-);
-CREATE TABLE milestone (
-    name text PRIMARY KEY,
-    due integer,
-    completed integer,
-    description text
-);
-CREATE TABLE version (
-    name text PRIMARY KEY,
-    time integer,
-    description text
-);
-CREATE TABLE report (
-    id integer PRIMARY KEY,
-    author text,
-    title text,
-    query text,
-    description text
-);
-CREATE TABLE notify_subscription (
-    id integer PRIMARY KEY,
-    time integer,
-    changetime integer,
-    class text,
-    sid text,
-    authenticated integer,
-    distributor text,
-    format text,
-    priority integer,
-    adverb text
-);
-CREATE INDEX notify_subscription_sid_authenticated_idx ON notify_subscription (sid,authenticated);
-CREATE INDEX notify_subscription_class_idx ON notify_subscription (class);
-CREATE TABLE notify_watch (
-    id integer PRIMARY KEY,
-    sid text,
-    authenticated integer,
-    class text,
-    realm text,
-    target text
-);
-CREATE INDEX notify_watch_sid_authenticated_class_idx ON notify_watch (sid,authenticated,class);
-CREATE INDEX notify_watch_class_realm_target_idx ON notify_watch (class,realm,target);
-CREATE TABLE node_change (
-    id integer PRIMARY KEY,
-    repos integer,
-    rev text,
-    path text,
-    node_type text,
-    change_type text,
-    base_path text,
-    base_rev text
-);
-CREATE INDEX node_change_repos_rev_path_idx ON node_change (repos,rev,path);
-CREATE INDEX node_change_repos_path_rev_idx ON node_change (repos,path,rev);
-- 
cgit v1.2.3