[moira.git] / db / schema

CREATE TABLE users 
(
        login           CHAR( 8 ),
        users_id        INTEGER,
        uid             SMALLINT,
        shell           CHAR( 32 ),
        last            CHAR( 16 ),
        first           CHAR( 16 ),
        middle          CHAR( 16 ),
        status          SMALLINT,
        mit_id          CHAR( 13 ),
        mit_year        CHAR( 8 ), 
        modtime         DATE,
        modby           INTEGER,
        modwith         CHAR( 8 ),
        fullname        CHAR( 32 ),
        nickname        CHAR( 16 ),
        home_addr       CHAR( 80 ),
        home_phone      CHAR( 16 ),
        office_addr     CHAR( 16 ),
        office_phone    CHAR( 12 ),
        mit_dept        CHAR( 12 ),
        mit_affil       CHAR( 4 ),
        fmodtime        DATE,
        fmodby          INTEGER,
        fmodwith        CHAR( 8 ),
        potype          CHAR( 8 ),
        pop_id          INTEGER,
        box_id          INTEGER,
        pmodtime        DATE,
        pmodby          INTEGER,
        pmodwith        CHAR( 8 ),
        gid             SMALLINT,
        ugdefault       SMALLINT
)

CREATE TABLE krbmap
(
        users_id        INTEGER,
        string_id       INTEGER
)

CREATE TABLE machine 
(
        name            CHAR( 32 ),
        mach_id         INTEGER,
        type            CHAR( 8 ),
        modtime         DATE,
        modby           INTEGER,
        modwith         CHAR( 8 )
)

CREATE TABLE cluster 
(
        name            CHAR( 32 ),
        clu_id          INTEGER,
        desc            CHAR( 32 ),
        location        CHAR( 64 ),
        modtime         DATE,
        modby           INTEGER,
        modwith         CHAR( 8 )
)

CREATE TABLE mcmap 
(
        mach_id         INTEGER,
        clu_id          INTEGER
)

CREATE TABLE svc 
(
        clu_id          INTEGER,
        serv_label      CHAR( 16 ),
        serv_cluster    CHAR( 32 )
)

CREATE TABLE list 
(
        name            CHAR( 32 ),
        list_id         INTEGER,
        active          SMALLINT,
        public          SMALLINT,
        hidden          SMALLINT,
        maillist        SMALLINT,
        grp             SMALLINT,
        gid             SMALLINT,
        desc            CHAR( 255 ),
        acl_type        CHAR( 8 ),
        acl_id          INTEGER,
        modtime         DATE,
        modby           INTEGER,
        modwith         CHAR( 8 )
)
CREATE TABLE imembers 
(
        list_id         INTEGER,
        member_type     CHAR( 8 ),
        member_id       INTEGER,
        ref_count       SMALLINT,
        direct          SMALLINT
)

CREATE TABLE servers 
(
        name            CHAR( 16 ),
        update_int      INTEGER,
        target_file     CHAR( 64 ),
        script          CHAR( 128 ),
        dfgen           INTEGER,
        dfcheck         INTEGER,
        type            CHAR( 8 ),
        enable          SMALLINT,
        inprogress      SMALLINT,
        harderror       INTEGER,
        errmsg          CHAR( 80 ),
        acl_type        CHAR( 8 ),
        acl_id          INTEGER,
        modtime         DATE,
        modby           INTEGER,
        modwith         CHAR( 8 )
)

CREATE TABLE serverhosts 
(
        service          CHAR( 16 ),
        mach_id          INTEGER,
        success          SMALLINT,
        enable           SMALLINT,
        override         SMALLINT,
        inprogress       SMALLINT,
        hosterror        INTEGER,
        hosterrmsg       CHAR( 80 ),
        ltt              INTEGER,
        lts              INTEGER,
        value1           INTEGER,
        value2           INTEGER,
        value3           CHAR( 32 ),
        modtime          DATE,
        modby            INTEGER,
        modwith          CHAR( 8 )
)

CREATE TABLE filesys 
(
        filsys_id        INTEGER,
        phys_id          INTEGER,
        label            CHAR( 32 ),
        order            SMALLINT,
        type             CHAR( 8 ),
        mach_id          INTEGER,
        name             CHAR( 80 ),
        mount            CHAR( 32 ),
        access           CHAR( 1 ),
        comments         CHAR( 64 ),
        owner            INTEGER,
        owners           INTEGER,
        createflg        SMALLINT,
        lockertype       CHAR( 8 ),
        modtime          DATE,
        modby            INTEGER,
        modwith          CHAR( 8 )
)

CREATE TABLE fsgroup
(
        group_id         INTEGER,
        filsys_id        INTEGER,
        key              CHAR( 8 )
)

CREATE TABLE nfsphys 
(
        nfsphys_id       INTEGER,
        mach_id          INTEGER,
        device           CHAR( 16 ),
        dir              CHAR( 16 ),
        status           SMALLINT,
        allocated        INTEGER,
        size             INTEGER,
        modtime          DATE,
        modby            INTEGER,
        modwith          CHAR( 8 )
)

CREATE TABLE quota 
(
        filsys_id        INTEGER,
        type             CHAR( 8 ),
        entity_id        INTEGER,
        phys_id          INTEGER,
        quota_value      INTEGER,
        modtime          DATE,
        modby            INTEGER,
        modwith          CHAR( 8 )
)

CREATE TABLE zephyr 
(
        class            CHAR( 16 ),
        xmt_type         CHAR( 8 ),
        xmt_id           INTEGER,
        sub_type         CHAR( 8 ),
        sub_id           INTEGER,
        iws_type         CHAR( 8 ),
        iws_id           INTEGER,
        iui_type         CHAR( 8 ),
        iui_id           INTEGER,
        modtime          DATE,
        modby            INTEGER,
        modwith          CHAR( 8 )
)

CREATE TABLE hostaccess 
(
        mach_id          INTEGER,
        acl_type         CHAR( 8 ),
        acl_id           INTEGER,
        modtime          DATE,
        modby            INTEGER,
        modwith          CHAR( 8 )
)

CREATE TABLE strings 
(
        string_id        INTEGER,
        string           CHAR( 128 )
)

CREATE TABLE services 
(
        name             CHAR( 16 ),
        protocol         CHAR( 8 ),
        port             SMALLINT,
        desc             CHAR( 64 ),
        modtime          DATE,
        modby            INTEGER,
        modwith          CHAR( 8 )
)

CREATE TABLE printcap 
(
        name             CHAR( 16 ),
        mach_id          INTEGER,
        dir              CHAR( 32 ),
        rp               CHAR( 16 ),
        comments         CHAR( 64,
        modtime          DATE,
        modby            INTEGER,
        modwith          CHAR( 8 )
)

CREATE TABLE palladium
(
        name             CHAR( 32 ),
        ident            INTEGER,
        mach_id          INTEGER,
        modtime          DATE,
        modby            INTEGER,
        modwith          CHAR( 8 )
)

CREATE TABLE capacls 
(
        capability       CHAR( 32 ),
        tag              CHAR( 4 ),
        list_id          INTEGER
)

CREATE TABLE alias 
(
        name             CHAR( 32 ),
        type             CHAR( 16 ),
        trans            CHAR( 128 )
)

CREATE TABLE values_tbl 
(
        name             CHAR( 32 ),
        value            INTEGER
)

CREATE TABLE tblstats 
(
        table_name       CHAR( 12 ),
        modtime          DATE,
        retrieves        INTEGER,
        appends          INTEGER,
        updates          INTEGER,
        deletes          INTEGER
)

CREATE TABLE incremental
(
        table            CHAR( 16 ),
        service          CHAR( 16 )
)
Commit	Line	Data
9e82c8c4	1	CREATE TABLE users
fba90e28	2	(
	3	login CHAR( 8 ),
	4	users_id INTEGER,
	5	uid SMALLINT,
	6	shell CHAR( 32 ),
	7	last CHAR( 16 ),
	8	first CHAR( 16 ),
	9	middle CHAR( 16 ),
	10	status SMALLINT,
	11	mit_id CHAR( 13 ),
	12	mit_year CHAR( 8 ),
	13	modtime DATE,
	14	modby INTEGER,
	15	modwith CHAR( 8 ),
	16	fullname CHAR( 32 ),
	17	nickname CHAR( 16 ),
	18	home_addr CHAR( 80 ),
	19	home_phone CHAR( 16 ),
	20	office_addr CHAR( 16 ),
	21	office_phone CHAR( 12 ),
	22	mit_dept CHAR( 12 ),
	23	mit_affil CHAR( 4 ),
	24	fmodtime DATE,
	25	fmodby INTEGER,
	26	fmodwith CHAR( 8 ),
	27	potype CHAR( 8 ),
	28	pop_id INTEGER,
	29	box_id INTEGER,
	30	pmodtime DATE,
	31	pmodby INTEGER,
	32	pmodwith CHAR( 8 ),
	33	gid SMALLINT,
fba90e28	34	ugdefault SMALLINT
	35	)
	36
9e82c8c4	37	CREATE TABLE krbmap
fba90e28	38	(
	39	users_id INTEGER,
	40	string_id INTEGER
	41	)
	42
9e82c8c4	43	CREATE TABLE machine
fba90e28	44	(
	45	name CHAR( 32 ),
	46	mach_id INTEGER,
	47	type CHAR( 8 ),
	48	modtime DATE,
	49	modby INTEGER,
	50	modwith CHAR( 8 )
	51	)
	52
9e82c8c4	53	CREATE TABLE cluster
fba90e28	54	(
	55	name CHAR( 32 ),
	56	clu_id INTEGER,
	57	desc CHAR( 32 ),
	58	location CHAR( 64 ),
	59	modtime DATE,
	60	modby INTEGER,
	61	modwith CHAR( 8 )
	62	)
	63
9e82c8c4	64	CREATE TABLE mcmap
fba90e28	65	(
	66	mach_id INTEGER,
	67	clu_id INTEGER
	68	)
	69
9e82c8c4	70	CREATE TABLE svc
fba90e28	71	(
	72	clu_id INTEGER,
	73	serv_label CHAR( 16 ),
	74	serv_cluster CHAR( 32 )
	75	)
	76
9e82c8c4	77	CREATE TABLE list
fba90e28	78	(
	79	name CHAR( 32 ),
	80	list_id INTEGER,
	81	active SMALLINT,
	82	public SMALLINT,
	83	hidden SMALLINT,
	84	maillist SMALLINT,
f4a3ba63	85	grp SMALLINT,
fba90e28	86	gid SMALLINT,
	87	desc CHAR( 255 ),
	88	acl_type CHAR( 8 ),
	89	acl_id INTEGER,
	90	modtime DATE,
	91	modby INTEGER,
	92	modwith CHAR( 8 )
	93	)
9e82c8c4	94	CREATE TABLE imembers
fba90e28	95	(
	96	list_id INTEGER,
	97	member_type CHAR( 8 ),
	98	member_id INTEGER,
	99	ref_count SMALLINT,
	100	direct SMALLINT
	101	)
	102
9e82c8c4	103	CREATE TABLE servers
fba90e28	104	(
	105	name CHAR( 16 ),
	106	update_int INTEGER,
	107	target_file CHAR( 64 ),
	108	script CHAR( 128 ),
	109	dfgen INTEGER,
	110	dfcheck INTEGER,
	111	type CHAR( 8 ),
	112	enable SMALLINT,
	113	inprogress SMALLINT,
	114	harderror INTEGER,
	115	errmsg CHAR( 80 ),
	116	acl_type CHAR( 8 ),
	117	acl_id INTEGER,
	118	modtime DATE,
	119	modby INTEGER,
	120	modwith CHAR( 8 )
	121	)
	122
9e82c8c4	123	CREATE TABLE serverhosts
fba90e28	124	(
	125	service CHAR( 16 ),
	126	mach_id INTEGER,
	127	success SMALLINT,
	128	enable SMALLINT,
	129	override SMALLINT,
	130	inprogress SMALLINT,
	131	hosterror INTEGER,
	132	hosterrmsg CHAR( 80 ),
	133	ltt INTEGER,
	134	lts INTEGER,
	135	value1 INTEGER,
	136	value2 INTEGER,
	137	value3 CHAR( 32 ),
	138	modtime DATE,
	139	modby INTEGER,
	140	modwith CHAR( 8 )
	141	)
	142
9e82c8c4	143	CREATE TABLE filesys
fba90e28	144	(
	145	filsys_id INTEGER,
	146	phys_id INTEGER,
	147	label CHAR( 32 ),
	148	order SMALLINT,
	149	type CHAR( 8 ),
	150	mach_id INTEGER,
	151	name CHAR( 80 ),
	152	mount CHAR( 32 ),
	153	access CHAR( 1 ),
	154	comments CHAR( 64 ),
	155	owner INTEGER,
	156	owners INTEGER,
	157	createflg SMALLINT,
	158	lockertype CHAR( 8 ),
	159	modtime DATE,
	160	modby INTEGER,
	161	modwith CHAR( 8 )
	162	)
	163
9e82c8c4	164	CREATE TABLE fsgroup
fba90e28	165	(
	166	group_id INTEGER,
	167	filsys_id INTEGER,
	168	key CHAR( 8 )
	169	)
	170
9e82c8c4	171	CREATE TABLE nfsphys
fba90e28	172	(
	173	nfsphys_id INTEGER,
	174	mach_id INTEGER,
	175	device CHAR( 16 ),
	176	dir CHAR( 16 ),
	177	status SMALLINT,
	178	allocated INTEGER,
	179	size INTEGER,
	180	modtime DATE,
	181	modby INTEGER,
	182	modwith CHAR( 8 )
	183	)
	184
9e82c8c4	185	CREATE TABLE quota
fba90e28	186	(
	187	filsys_id INTEGER,
	188	type CHAR( 8 ),
	189	entity_id INTEGER,
	190	phys_id INTEGER,
b063a1a1	191	quota_value INTEGER,
fba90e28	192	modtime DATE,
	193	modby INTEGER,
	194	modwith CHAR( 8 )
	195	)
	196
9e82c8c4	197	CREATE TABLE zephyr
fba90e28	198	(
	199	class CHAR( 16 ),
	200	xmt_type CHAR( 8 ),
	201	xmt_id INTEGER,
	202	sub_type CHAR( 8 ),
	203	sub_id INTEGER,
	204	iws_type CHAR( 8 ),
	205	iws_id INTEGER,
	206	iui_type CHAR( 8 ),
	207	iui_id INTEGER,
	208	modtime DATE,
	209	modby INTEGER,
	210	modwith CHAR( 8 )
	211	)
	212
9e82c8c4	213	CREATE TABLE hostaccess
fba90e28	214	(
	215	mach_id INTEGER,
	216	acl_type CHAR( 8 ),
	217	acl_id INTEGER,
	218	modtime DATE,
	219	modby INTEGER,
	220	modwith CHAR( 8 )
	221	)
	222
9e82c8c4	223	CREATE TABLE strings
fba90e28	224	(
	225	string_id INTEGER,
	226	string CHAR( 128 )
	227	)
	228
9e82c8c4	229	CREATE TABLE services
fba90e28	230	(
	231	name CHAR( 16 ),
	232	protocol CHAR( 8 ),
	233	port SMALLINT,
	234	desc CHAR( 64 ),
	235	modtime DATE,
	236	modby INTEGER,
	237	modwith CHAR( 8 )
	238	)
	239
9e82c8c4	240	CREATE TABLE printcap
fba90e28	241	(
	242	name CHAR( 16 ),
	243	mach_id INTEGER,
	244	dir CHAR( 32 ),
	245	rp CHAR( 16 ),
	246	comments CHAR( 64,
	247	modtime DATE,
	248	modby INTEGER,
	249	modwith CHAR( 8 )
	250	)
	251
9e82c8c4	252	CREATE TABLE palladium
fba90e28	253	(
	254	name CHAR( 32 ),
	255	ident INTEGER,
	256	mach_id INTEGER,
	257	modtime DATE,
	258	modby INTEGER,
	259	modwith CHAR( 8 )
	260	)
	261
9e82c8c4	262	CREATE TABLE capacls
fba90e28	263	(
	264	capability CHAR( 32 ),
	265	tag CHAR( 4 ),
	266	list_id INTEGER
	267	)
	268
9e82c8c4	269	CREATE TABLE alias
fba90e28	270	(
	271	name CHAR( 32 ),
	272	type CHAR( 16 ),
	273	trans CHAR( 128 )
	274	)
	275
b063a1a1	276	CREATE TABLE values_tbl
fba90e28	277	(
	278	name CHAR( 32 ),
	279	value INTEGER
	280	)
	281
9e82c8c4	282	CREATE TABLE tblstats
fba90e28	283	(
b063a1a1	284	table_name CHAR( 12 ),
fba90e28	285	modtime DATE,
f4a3ba63	286	retrieves INTEGER,
fba90e28	287	appends INTEGER,
	288	updates INTEGER,
	289	deletes INTEGER
	290	)
	291
9e82c8c4	292	CREATE TABLE incremental
fba90e28	293	(
f4a3ba63	294	table CHAR( 16 ),
fba90e28	295	service CHAR( 16 )
fba90e28	296	)