From: kostas <kostas>
Date: Fri, 7 Sep 1990 09:16:14 +0000 (+0000)
Subject: changed table to tbl, group to grp and removed users.uglist_id
X-Git-Tag: release77~800
X-Git-Url: http://andersk.mit.edu/gitweb/moira.git/commitdiff_plain/f4a3ba63f6565a3f0a227dd5bb0eac918d5a579c

changed table to tbl, group to grp and removed users.uglist_id
---

diff --git a/db/schema b/db/schema
index d9cbaa79..339d9a0c 100644
--- a/db/schema
+++ b/db/schema
@@ -31,7 +31,6 @@ create table users
         pmodby          INTEGER,
         pmodwith        CHAR( 8 ),
         gid             SMALLINT,
-        uglist_id       INTEGER,
         ugdefault       SMALLINT
 )
 
@@ -83,7 +82,7 @@ create table list
         public          SMALLINT,
         hidden          SMALLINT,
         maillist        SMALLINT,
-        group           SMALLINT,
+        grp             SMALLINT,
         gid             SMALLINT,
         desc            CHAR( 255 ),
         acl_type        CHAR( 8 ),
@@ -274,7 +273,7 @@ create table alias
         trans            CHAR( 128 )
 )
 
-create table values_tbl
+create table values 
 (
         name             CHAR( 32 ),
         value            INTEGER
@@ -282,8 +281,9 @@ create table values_tbl
 
 create table tblstats 
 (
-        tbl              CHAR( 12 ),
+        table            CHAR( 12 ),
         modtime          DATE,
+        retrieves        INTEGER,
         appends          INTEGER,
         updates          INTEGER,
         deletes          INTEGER
@@ -291,6 +291,6 @@ create table tblstats
 
 create table incremental
 (
-        tbl              CHAR( 16 ),
+        table            CHAR( 16 ),
         service          CHAR( 16 )
 )