-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 CHAR(8),
+ users_id INTEGER,
+ uid SMALLINT,
+ shell CHAR(32),
+ last CHAR(16),
+ first CHAR(16),
+ middle CHAR(16),
+ status SMALLINT,
+ clearid CHAR(16),
+ encryptid CHAR(16),
+ type CHAR(8),
+ modtime DATE,
+ modby INTEGER,
+ modwith CHAR(8),
+ fullname CHAR(32),
+ nickname CHAR(16),
+ home_addr CHAR(82),
+ home_phone CHAR(16),
+ office_addr CHAR(16),
+ office_phone CHAR(12),
+ deptartment CHAR(20),
+ affiliation CHAR(50),
+ fmodtime DATE,
+ fmodby INTEGER,
+ fmodwith CHAR(8),
+ potype CHAR(8),
+ pop_id INTEGER,
+ box_id INTEGER,
+ pmodtime DATE,
+ pmodby INTEGER,
+ pmodwith CHAR(8),
+ misc SMALLINT
+);
+create table krbmap
(
- users_id INTEGER,
- string_id INTEGER
-)
-
-CREATE TABLE machine
+ 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),
+ mach_id INTEGER,
+ type CHAR(8),
+ modtime DATE,
+ modby INTEGER,
+ modwith CHAR(8)
+);
+create table clusters
(
- name CHAR( 32 ),
- clu_id INTEGER,
- desc CHAR( 32 ),
- location CHAR( 64 ),
- modtime DATE,
- modby INTEGER,
- modwith CHAR( 8 )
-)
-
-CREATE TABLE mcmap
+ name CHAR(32),
+ clu_id INTEGER,
+ description CHAR(32),
+ location CHAR(64),
+ modtime DATE,
+ modby INTEGER,
+ modwith CHAR(8)
+);
+create table mcmap
(
- mach_id INTEGER,
- clu_id INTEGER
-)
-
-CREATE TABLE svc
+ mach_id INTEGER,
+ clu_id INTEGER
+);
+create table cludata
(
- clu_id INTEGER,
- serv_label CHAR( 16 ),
- serv_cluster CHAR( 32 )
-)
-
-CREATE TABLE list
+ clu_id INTEGER,
+ label CHAR(16),
+ data 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
+ name CHAR(32),
+ list_id INTEGER,
+ active SMALLINT,
+ publicflg SMALLINT,
+ hidden SMALLINT,
+ maillist SMALLINT,
+ grouplist SMALLINT,
+ gid SMALLINT,
+ description 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
+ 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
+ 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
+ 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
+ filsys_id INTEGER,
+ phys_id INTEGER,
+ label CHAR(32),
+ 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
+ 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
+ nfsphys_id INTEGER,
+ mach_id INTEGER,
+ device CHAR(16),
+ dir CHAR(16),
+ status SMALLINT,
+ allocated INTEGER,
+ partsize 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
+ filsys_id INTEGER,
+ type CHAR(8),
+ entity_id INTEGER,
+ phys_id INTEGER,
+ quota 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
+ 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
+ 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
+ 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),
+ protocol CHAR(8),
+ port SMALLINT,
+ description 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(16),
+ mach_id INTEGER,
+ dir CHAR(32),
+ rp CHAR(16),
+ quotaserver INTEGER,
+ auth SMALLINT,
+ price SMALLINT,
+ 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
+ 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
+ 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),
+ type CHAR(16),
+ trans CHAR(128)
+);
+create table numvalues
(
- name CHAR( 32 ),
- value INTEGER
-)
-
-CREATE TABLE tblstats
+ 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_name CHAR(12),
+ modtime DATE,
+ retrieves INTEGER,
+ appends INTEGER,
+ updates INTEGER,
+ deletes INTEGER
+);
+create table incremental
(
- table CHAR( 16 ),
- service CHAR( 16 )
-)
+ tablename CHAR(16),
+ service CHAR(16)
+);
andersk / moira.git / commitdiff
