added prefix field to subnet table

[moira.git] / db / newdb

diff --git a/db/newdb b/db/newdb
index d69403f341888197e5b797ccf5c9eb2f03f25c86..692582f9e41a417710dcb0150404f2bbc9910f70 100644 (file)
--- a/db/newdb
+++ b/db/newdb
@@ -34,6 +34,11 @@ create users
        uglist_id       = i4,
        ugdefault       = i1
 )
+create krbmap
+(
+       users_id        = i4,
+       string_id       = i4
+)
 create machine 
 (
        name            = c32,
@@ -81,23 +86,26 @@ create list
        modby           = i4,
        modwith         = c8
 )
-create members 
+create imembers 
 (
        list_id         = i4,
        member_type     = c8,
-       member_id       = i4
+       member_id       = i4,
+       ref_count       = i2,
+       direct          = i2
 )
 create servers 
 (
-       service         = c16,
+       name            = c16,
        update_int      = i4,
        target_file     = c64,
        script          = c128,
-       dfgen           = date,
+       dfgen           = i4,
+       dfcheck         = i4,
        type            = c8,
        enable          = i1,
        inprogress      = i1,
-       harderror       = i1,
+       harderror       = i4,
        errmsg          = c80,
        acl_type        = c8,
        acl_id          = i4,
@@ -113,10 +121,10 @@ create serverhosts
        enable          = i1,
        override        = i1,
        inprogress      = i1,
-       hosterror       = i1,
+       hosterror       = i4,
        hosterrmsg      = c80,
-       ltt             = date,
-       lts             = date,
+       ltt             = i4,
+       lts             = i4,
        value1          = i4,
        value2          = i4,
        value3          = c32,
@@ -127,11 +135,12 @@ create serverhosts
 create filesys 
 (
        filsys_id       = i4,
-       label           = c16,
+       phys_id         = i4,
+       label           = c32,
        order           = i2,
        type            = c8,
        mach_id         = i4,
-       name            = c32,
+       name            = c80,
        mount           = c32,
        access          = c1,
        comments        = c64,
@@ -143,9 +152,15 @@ create filesys
        modby           = i4,
        modwith         = c8
 )
+create fsgroup
+(
+       group_id        = i4,
+       filsys_id       = i4,
+       key             = c8
+)
 create nfsphys 
 (
-       nfspys_id       = i4,
+       nfsphys_id      = i4,
        mach_id         = i4,
        device          = c16,
        dir             = c16,
@@ -156,11 +171,12 @@ create nfsphys
        modby           = i4,
        modwith         = c8
 )
-create nfsquota 
+create quota 
 (
-       users_id        = i4,
-       mach_id         = i4,
-       device          = c16,
+       filsys_id       = i4,
+       type            = c8,
+       entity_id       = i4,
+       phys_id         = i4,
        quota           = i4,
        modtime         = date,
        modby           = i4,
@@ -208,7 +224,25 @@ create services
 create printcap 
 (
        name            = c16,
-       pcap            = text(512)
+       mach_id         = i4,
+       dir             = c32,
+       rp              = c16,
+       quotaserver     = i4,
+       auth            = i1,
+       price           = i2,
+       comments        = c64,
+       modtime         = date,
+       modby           = i4,
+       modwith         = c8
+)
+create palladium
+(
+       name            = c32,
+       ident           = i4,
+       mach_id         = i4,
+       modtime         = date,
+       modby           = i4,
+       modwith         = c8
 )
 create capacls 
 (
@@ -236,3 +270,8 @@ create tblstats
        updates         = i4,
        deletes         = i4
 )
+create incremental
+(
+       table           = c16,
+       service         = c16
+)