X-Git-Url: http://andersk.mit.edu/gitweb/moira.git/blobdiff_plain/9e82c8c4cb6c509e17f47620a53b2d3e3202c4bf..ac5e3058126921c30f2bd755db46736ffb0abdb7:/db/schema

diff --git a/db/schema b/db/schema
index 2668776c..cb276f5c 100644
--- a/db/schema
+++ b/db/schema
@@ -1,296 +1,323 @@
-CREATE TABLE users 
+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
+        login		VARCHAR(8) 	NOT NULL WITH DEFAULT,
+	users_id	INTEGER 	NOT NULL WITH DEFAULT,
+	uid		SMALLINT 	NOT NULL WITH DEFAULT,
+	shell		CHAR(32) 	NOT NULL WITH DEFAULT,
+	last		VARCHAR(16) 	NOT NULL WITH DEFAULT,
+	first		VARCHAR(16) 	NOT NULL WITH DEFAULT,
+	middle		CHAR(16) 	NOT NULL WITH DEFAULT,
+	status		SMALLINT 	NOT NULL WITH DEFAULT,
+	clearid		VARCHAR(16) 	NOT NULL WITH DEFAULT,
+	type		CHAR(8) 	NOT NULL WITH DEFAULT,
+	comment         INTEGER  	NOT NULL WITH DEFAULT,
+	modtime		DATE    	NOT NULL WITH DEFAULT,
+	modby		INTEGER 	NOT NULL WITH DEFAULT,
+	modwith		CHAR(8) 	NOT NULL WITH DEFAULT,
+	fullname	CHAR(32) 	NOT NULL WITH DEFAULT,
+	nickname	CHAR(16) 	NOT NULL WITH DEFAULT,
+	home_addr	CHAR(82) 	NOT NULL WITH DEFAULT,
+	home_phone	CHAR(16) 	NOT NULL WITH DEFAULT,
+	office_addr	CHAR(16) 	NOT NULL WITH DEFAULT,
+	office_phone	CHAR(12) 	NOT NULL WITH DEFAULT,
+	department	CHAR(20) 	NOT NULL WITH DEFAULT,
+	affiliation	CHAR(50) 	NOT NULL WITH DEFAULT,
+	fmodtime	DATE    	NOT NULL WITH DEFAULT,
+	fmodby		INTEGER 	NOT NULL WITH DEFAULT,
+	fmodwith	CHAR(8) 	NOT NULL WITH DEFAULT,
+	potype		CHAR(8) 	NOT NULL WITH DEFAULT,
+	pop_id		INTEGER 	NOT NULL WITH DEFAULT,
+	box_id		INTEGER 	NOT NULL WITH DEFAULT,
+	pmodtime	DATE    	NOT NULL WITH DEFAULT,
+	pmodby		INTEGER 	NOT NULL WITH DEFAULT,
+	pmodwith	CHAR(8) 	NOT NULL WITH DEFAULT,
+	xname           CHAR(30)        NOT NULL WITH DEFAULT,
+	xdept        	CHAR(20)        NOT NULL WITH DEFAULT,
+	xtitle       	CHAR(50)	NOT NULL WITH DEFAULT,
+	xaddress     	CHAR(82)	NOT NULL WITH DEFAULT,
+	xphone1      	CHAR(12)	NOT NULL WITH DEFAULT,
+	xphone2      	CHAR(12)	NOT NULL WITH DEFAULT,
+	xmodtime     	DATE         	NOT NULL WITH DEFAULT,
+	sigdate      	INTEGER		NOT NULL WITH DEFAULT,
+	sigwho       	INTEGER		NOT NULL WITH DEFAULT,
+	signature    	VARCHAR(68)	NOT NULL WITH DEFAULT,
+	secure       	INTEGER		NOT NULL WITH DEFAULT,       
+	flag         	INTEGER1	NOT NULL WITH DEFAULT
+);
+create table krbmap
 (
-        users_id        INTEGER,
-        string_id       INTEGER
-)
-
-CREATE TABLE machine 
+	users_id	INTEGER 	NOT NULL WITH DEFAULT,
+	string_id	INTEGER 	NOT NULL WITH DEFAULT
+);
+create table machine
 (
-        name            CHAR( 32 ),
-        mach_id         INTEGER,
-        type            CHAR( 8 ),
-        modtime         DATE,
-        modby           INTEGER,
-        modwith         CHAR( 8 )
-)
-
-CREATE TABLE cluster 
+	name		VARCHAR(40) 	NOT NULL WITH DEFAULT,
+	mach_id		INTEGER 	NOT NULL WITH DEFAULT,
+	vendor		CHAR(16) 	NOT NULL WITH DEFAULT,
+	model		CHAR(24) 	NOT NULL WITH DEFAULT,
+	os		CHAR(16) 	NOT NULL WITH DEFAULT,
+	location	CHAR(16) 	NOT NULL WITH DEFAULT,
+	contact		CHAR(32) 	NOT NULL WITH DEFAULT,
+	use		INTEGER		NOT NULL WITH DEFAULT,
+	status		INTEGER1	NOT NULL WITH DEFAULT,
+	statuschange	DATE    	NOT NULL WITH DEFAULT,
+	snet_id		INTEGER 	NOT NULL WITH DEFAULT,
+	address		CHAR(16)	NOT NULL WITH DEFAULT,
+	owner_type	CHAR(8) 	NOT NULL WITH DEFAULT,
+	owner_id	INTEGER 	NOT NULL WITH DEFAULT,
+	acomment	INTEGER 	NOT NULL WITH DEFAULT,
+	ocomment	INTEGER 	NOT NULL WITH DEFAULT,
+	created		DATE 		NOT NULL WITH DEFAULT,
+	creator		INTEGER 	NOT NULL WITH DEFAULT,
+	inuse		DATE		NOT NULL WITH DEFAULT,
+	modtime		DATE    	NOT NULL WITH DEFAULT,
+	modby		INTEGER 	NOT NULL WITH DEFAULT,
+	modwith		CHAR(8) 	NOT NULL WITH DEFAULT
+);
+create table hostalias
 (
-        name            CHAR( 32 ),
-        clu_id          INTEGER,
-        desc            CHAR( 32 ),
-        location        CHAR( 64 ),
-        modtime         DATE,
-        modby           INTEGER,
-        modwith         CHAR( 8 )
-)
-
-CREATE TABLE mcmap 
+	name		VARCHAR(40) 	NOT NULL WITH DEFAULT,
+	mach_id		INTEGER	 	NOT NULL WITH DEFAULT
+);
+create table subnet
 (
-        mach_id         INTEGER,
-        clu_id          INTEGER
-)
-
-CREATE TABLE svc 
+	name		CHAR(16) 	NOT NULL WITH DEFAULT,
+	snet_id		INTEGER		NOT NULL WITH DEFAULT,
+	description	VARCHAR(48) 	NOT NULL WITH DEFAULT,
+	saddr		INTEGER		NOT NULL WITH DEFAULT,
+	mask		INTEGER 	NOT NULL WITH DEFAULT,
+	low		INTEGER 	NOT NULL WITH DEFAULT,
+	high		INTEGER 	NOT NULL WITH DEFAULT,
+	prefix		CHAR(8)		NOT NULL WITH DEFAULT,
+	owner_type	CHAR(8) 	NOT NULL WITH DEFAULT,
+	owner_id	INTEGER 	NOT NULL WITH DEFAULT,
+	modtime		DATE 		NOT NULL WITH DEFAULT,
+	modby		INTEGER 	NOT NULL WITH DEFAULT,
+	modwith		CHAR(8) 	NOT NULL WITH DEFAULT
+);
+create table cluster
 (
-        clu_id          INTEGER,
-        serv_label      CHAR( 16 ),
-        serv_cluster    CHAR( 32 )
-)
-
-CREATE TABLE list 
+	name		VARCHAR(32) 	NOT NULL WITH DEFAULT,
+	clu_id		INTEGER 	NOT NULL WITH DEFAULT,
+	description	CHAR(32) 	NOT NULL WITH DEFAULT,
+	location	CHAR(64) 	NOT NULL WITH DEFAULT,
+	modtime	 	DATE    	NOT NULL WITH DEFAULT,
+	modby		INTEGER 	NOT NULL WITH DEFAULT,
+	modwith		CHAR(8) 	NOT NULL WITH DEFAULT
+);
+create table mcmap
 (
-        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 
+	mach_id		INTEGER 	NOT NULL WITH DEFAULT,
+	clu_id		INTEGER 	NOT NULL WITH DEFAULT
+);
+create table svc
 (
-        list_id         INTEGER,
-        member_type     CHAR( 8 ),
-        member_id       INTEGER,
-        ref_count       SMALLINT,
-        direct          SMALLINT
-)
-
-CREATE TABLE servers 
+	clu_id		INTEGER 	NOT NULL WITH DEFAULT,
+	serv_label	VARCHAR(16) 	NOT NULL WITH DEFAULT,
+	serv_cluster	CHAR(32) 	NOT NULL WITH DEFAULT
+);
+create table list
 (
-        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 
+	name		VARCHAR(32) 	NOT NULL WITH DEFAULT,
+	list_id		INTEGER 	NOT NULL WITH DEFAULT,
+	active		INTEGER1 	NOT NULL WITH DEFAULT,
+	publicflg	INTEGER1 	NOT NULL WITH DEFAULT,
+	hidden		INTEGER1 	NOT NULL WITH DEFAULT,
+	maillist	INTEGER1 	NOT NULL WITH DEFAULT,
+	grouplist	INTEGER1 	NOT NULL WITH DEFAULT,
+	gid		SMALLINT 	NOT NULL WITH DEFAULT,
+	description	CHAR(255) 	NOT NULL WITH DEFAULT,
+	acl_type	CHAR(8) 	NOT NULL WITH DEFAULT,
+	acl_id		INTEGER 	NOT NULL WITH DEFAULT,
+	modtime		DATE    	NOT NULL WITH DEFAULT,
+	modby		INTEGER 	NOT NULL WITH DEFAULT,
+	modwith		CHAR(8) 	NOT NULL WITH DEFAULT
+);
+create table imembers 
 (
-        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 
+	list_id		INTEGER 	NOT NULL WITH DEFAULT,
+	member_type	CHAR(8) 	NOT NULL WITH DEFAULT,
+	member_id	INTEGER 	NOT NULL WITH DEFAULT,
+	ref_count	SMALLINT 	NOT NULL WITH DEFAULT,
+	direct		SMALLINT 	NOT NULL WITH DEFAULT
+);
+create table servers 
 (
-        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
+	name		VARCHAR(16) 	NOT NULL WITH DEFAULT,
+	update_int	INTEGER 	NOT NULL WITH DEFAULT,
+	target_file	CHAR(64) 	NOT NULL WITH DEFAULT,
+	script		CHAR(128) 	NOT NULL WITH DEFAULT,
+	dfgen		INTEGER 	NOT NULL WITH DEFAULT,
+	dfcheck		INTEGER 	NOT NULL WITH DEFAULT,
+	type		CHAR(8) 	NOT NULL WITH DEFAULT,
+	enable		INTEGER1 	NOT NULL WITH DEFAULT,
+	inprogress	INTEGER1 	NOT NULL WITH DEFAULT,
+	harderror	INTEGER 	NOT NULL WITH DEFAULT,
+	errmsg		CHAR(80) 	NOT NULL WITH DEFAULT,
+	acl_type	CHAR(8) 	NOT NULL WITH DEFAULT,
+	acl_id		INTEGER 	NOT NULL WITH DEFAULT,
+	modtime		DATE    	NOT NULL WITH DEFAULT,
+	modby		INTEGER 	NOT NULL WITH DEFAULT,
+	modwith		CHAR(8) 	NOT NULL WITH DEFAULT 
+);
+create table serverhosts 
 (
-        group_id         INTEGER,
-        filsys_id        INTEGER,
-        key              CHAR( 8 )
-)
-
-CREATE TABLE nfsphys 
+	service		VARCHAR(16) 	NOT NULL WITH DEFAULT,
+	mach_id		INTEGER 	NOT NULL WITH DEFAULT,
+	success		INTEGER1 	NOT NULL WITH DEFAULT,
+	enable		INTEGER1 	NOT NULL WITH DEFAULT,
+	override	INTEGER1 	NOT NULL WITH DEFAULT,
+	inprogress	INTEGER1 	NOT NULL WITH DEFAULT,
+	hosterror	INTEGER 	NOT NULL WITH DEFAULT,
+	hosterrmsg	CHAR(80) 	NOT NULL WITH DEFAULT,
+	ltt		INTEGER 	NOT NULL WITH DEFAULT,
+	lts		INTEGER 	NOT NULL WITH DEFAULT,
+	value1		INTEGER 	NOT NULL WITH DEFAULT,
+	value2		INTEGER 	NOT NULL WITH DEFAULT,
+	value3		CHAR(32) 	NOT NULL WITH DEFAULT,
+	modtime		DATE    	NOT NULL WITH DEFAULT,
+	modby		INTEGER 	NOT NULL WITH DEFAULT,
+	modwith		CHAR(8) 	NOT NULL WITH DEFAULT
+);
+create table filesys 
 (
-        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 	NOT NULL WITH DEFAULT,
+	phys_id		INTEGER 	NOT NULL WITH DEFAULT,
+	label		VARCHAR(32) 	NOT NULL WITH DEFAULT,
+	fs_order	INTEGER2	NOT NULL WITH DEFAULT,
+	type		CHAR(8) 	NOT NULL WITH DEFAULT,
+	mach_id		INTEGER 	NOT NULL WITH DEFAULT,
+	name		VARCHAR(80) 	NOT NULL WITH DEFAULT,
+	mount		CHAR(32) 	NOT NULL WITH DEFAULT,
+	access		CHAR(1) 	NOT NULL WITH DEFAULT,
+	comments	CHAR(64) 	NOT NULL WITH DEFAULT,
+	owner		INTEGER 	NOT NULL WITH DEFAULT,
+	owners		INTEGER 	NOT NULL WITH DEFAULT,
+	createflg	INTEGER1 	NOT NULL WITH DEFAULT,
+	lockertype	CHAR(8) 	NOT NULL WITH DEFAULT,
+	modtime		DATE    	NOT NULL WITH DEFAULT,
+	modby		INTEGER 	NOT NULL WITH DEFAULT,
+	modwith		CHAR(8) 	NOT NULL WITH DEFAULT 
+);
+create table fsgroup
 (
-        filsys_id        INTEGER,
-        type             CHAR( 8 ),
-        entity_id        INTEGER,
-        phys_id          INTEGER,
-        quota            INTEGER,
-        modtime          DATE,
-        modby            INTEGER,
-        modwith          CHAR( 8 )
-)
-
-CREATE TABLE zephyr 
+	group_id	INTEGER 	NOT NULL WITH DEFAULT,
+	filsys_id	INTEGER 	NOT NULL WITH DEFAULT,
+	key		CHAR(8) 	NOT NULL WITH DEFAULT
+);
+create table nfsphys 
 (
-        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 
+	nfsphys_id	INTEGER 	NOT NULL WITH DEFAULT,
+	mach_id		INTEGER 	NOT NULL WITH DEFAULT,
+	device		CHAR(16) 	NOT NULL WITH DEFAULT,
+	dir		VARCHAR(16) 	NOT NULL WITH DEFAULT,
+	status		SMALLINT 	NOT NULL WITH DEFAULT,
+	allocated	INTEGER 	NOT NULL WITH DEFAULT,
+	partsize	INTEGER 	NOT NULL WITH DEFAULT,
+	modtime		DATE    	NOT NULL WITH DEFAULT,
+	modby		INTEGER 	NOT NULL WITH DEFAULT,
+	modwith		CHAR(8) 	NOT NULL WITH DEFAULT
+);
+create table quota 
 (
-        mach_id          INTEGER,
-        acl_type         CHAR( 8 ),
-        acl_id           INTEGER,
-        modtime          DATE,
-        modby            INTEGER,
-        modwith          CHAR( 8 )
-)
-
-CREATE TABLE strings 
+	filsys_id	INTEGER 	NOT NULL WITH DEFAULT,
+	type		CHAR(8) 	NOT NULL WITH DEFAULT,
+	entity_id	INTEGER 	NOT NULL WITH DEFAULT,
+	phys_id		INTEGER 	NOT NULL WITH DEFAULT,
+	quota		INTEGER 	NOT NULL WITH DEFAULT,
+	modtime		DATE    	NOT NULL WITH DEFAULT,
+	modby		INTEGER 	NOT NULL WITH DEFAULT,
+	modwith		CHAR(8) 	NOT NULL WITH DEFAULT 
+);
+create table zephyr 
 (
-        string_id        INTEGER,
-        string           CHAR( 128 )
-)
-
-CREATE TABLE services 
+	class		VARCHAR(16) 	NOT NULL WITH DEFAULT,
+	xmt_type	CHAR(8) 	NOT NULL WITH DEFAULT,
+	xmt_id		INTEGER 	NOT NULL WITH DEFAULT,
+	sub_type	CHAR(8) 	NOT NULL WITH DEFAULT,
+	sub_id		INTEGER 	NOT NULL WITH DEFAULT,
+	iws_type	CHAR(8) 	NOT NULL WITH DEFAULT,
+	iws_id		INTEGER 	NOT NULL WITH DEFAULT,
+	iui_type	CHAR(8) 	NOT NULL WITH DEFAULT,
+	iui_id		INTEGER 	NOT NULL WITH DEFAULT,
+	modtime 	DATE    	NOT NULL WITH DEFAULT,
+	modby		INTEGER 	NOT NULL WITH DEFAULT,
+	modwith		CHAR(8) 	NOT NULL WITH DEFAULT 
+);
+create table hostaccess 
 (
-        name             CHAR( 16 ),
-        protocol         CHAR( 8 ),
-        port             SMALLINT,
-        desc             CHAR( 64 ),
-        modtime          DATE,
-        modby            INTEGER,
-        modwith          CHAR( 8 )
-)
-
-CREATE TABLE printcap 
+	mach_id		INTEGER 	NOT NULL WITH DEFAULT,
+	acl_type	CHAR(8) 	NOT NULL WITH DEFAULT,
+	acl_id		INTEGER 	NOT NULL WITH DEFAULT,
+	modtime		DATE    	NOT NULL WITH DEFAULT,
+	modby		INTEGER 	NOT NULL WITH DEFAULT,
+	modwith		CHAR(8) 	NOT NULL WITH DEFAULT
+);
+create table strings 
 (
-        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
+	string_id	INTEGER 	NOT NULL WITH DEFAULT,
+	string		VARCHAR(128)	NOT NULL WITH DEFAULT
+);
+create table services 
 (
-        name             CHAR( 32 ),
-        ident            INTEGER,
-        mach_id          INTEGER,
-        modtime          DATE,
-        modby            INTEGER,
-        modwith          CHAR( 8 )
-)
-
-CREATE TABLE capacls 
+	name		VARCHAR(16) 	NOT NULL WITH DEFAULT,
+	protocol	CHAR(8) 	NOT NULL WITH DEFAULT,
+	port		SMALLINT 	NOT NULL WITH DEFAULT,
+	description	CHAR(64) 	NOT NULL WITH DEFAULT,
+	modtime		DATE    	NOT NULL WITH DEFAULT,
+	modby		INTEGER 	NOT NULL WITH DEFAULT,
+	modwith		CHAR(8) 	NOT NULL WITH DEFAULT 
+);
+create table printcap 
 (
-        capability       CHAR( 32 ),
-        tag              CHAR( 4 ),
-        list_id          INTEGER
-)
-
-CREATE TABLE alias 
+	name		VARCHAR(16) 	NOT NULL WITH DEFAULT,
+	mach_id		INTEGER 	NOT NULL WITH DEFAULT,
+	dir		CHAR(32) 	NOT NULL WITH DEFAULT,
+	rp		CHAR(16) 	NOT NULL WITH DEFAULT,
+	quotaserver	INTEGER 	NOT NULL WITH DEFAULT,
+	auth		INTEGER1 	NOT NULL WITH DEFAULT,
+	price		SMALLINT 	NOT NULL WITH DEFAULT,
+	comments	CHAR(64) 	NOT NULL WITH DEFAULT,
+	modtime		DATE    	NOT NULL WITH DEFAULT,
+	modby		INTEGER 	NOT NULL WITH DEFAULT,
+	modwith		CHAR(8) 	NOT NULL WITH DEFAULT
+);
+create table palladium
 (
-        name             CHAR( 32 ),
-        type             CHAR( 16 ),
-        trans            CHAR( 128 )
-)
-
-CREATE TABLE values 
+	name		VARCHAR(32) 	NOT NULL WITH DEFAULT,
+	ident		INTEGER 	NOT NULL WITH DEFAULT,
+	mach_id		INTEGER 	NOT NULL WITH DEFAULT,
+	modtime		DATE    	NOT NULL WITH DEFAULT,
+	modby		INTEGER 	NOT NULL WITH DEFAULT,
+	modwith		CHAR(8) 	NOT NULL WITH DEFAULT
+);
+create table capacls 
 (
-        name             CHAR( 32 ),
-        value            INTEGER
-)
-
-CREATE TABLE tblstats 
+	capability	CHAR(32) 	NOT NULL WITH DEFAULT,
+	tag		CHAR(4) 	NOT NULL WITH DEFAULT,
+	list_id		INTEGER 	NOT NULL WITH DEFAULT
+);
+create table alias 
 (
-        table            CHAR( 12 ),
-        modtime          DATE,
-        retrieves        INTEGER,
-        appends          INTEGER,
-        updates          INTEGER,
-        deletes          INTEGER
-)
-
-CREATE TABLE incremental
+	name		VARCHAR(32) 	NOT NULL WITH DEFAULT,
+	type		VARCHAR(16) 	NOT NULL WITH DEFAULT,
+	trans		VARCHAR(128) 	NOT NULL WITH DEFAULT
+);
+create table numvalues 
 (
-        table            CHAR( 16 ),
-        service          CHAR( 16 )
-)
+	name		VARCHAR(32) 	NOT NULL WITH DEFAULT,
+	value		INTEGER 	NOT NULL WITH DEFAULT
+);
+create table tblstats 
+(
+	table_name	CHAR(12) 	NOT NULL WITH DEFAULT,
+	modtime		DATE    	NOT NULL WITH DEFAULT,
+	appends		INTEGER 	NOT NULL WITH DEFAULT,
+	updates		INTEGER 	NOT NULL WITH DEFAULT,
+	deletes		INTEGER 	NOT NULL WITH DEFAULT
+);
+create table incremental
+(
+	tablename	CHAR(16) 	NOT NULL WITH DEFAULT,
+	service		CHAR(16) 	NOT NULL WITH DEFAULT
+);