+ 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