The SQL/DS tables for the new group are created by editting the SQL statements below, replacing throng by the group name in question.
Creation of the SQL/DS tables for a new throng
INSERT INTO Fatmen VALUES ('CERN', 'throng') CREATE TABLE GNames_throng ( GName CHAR(240) NOT NULL, - GN# INTEGER NOT NULL) CREATE TABLE Files_throng ( File# INTEGER NOT NULL, - GN# INTEGER NOT NULL, - Copylevel INTEGER NOT NULL, - Location INTEGER NOT NULL, - Hostname CHAR(8) NOT NULL, - Fullname CHAR(240) NOT NULL, - Hosttype CHAR(16), - Opersys CHAR(12), - Fileformat CHAR(4) NOT NULL, - Userformat CHAR(4), - Startrec# INTEGER, - Endrec# INTEGER, - Startblk# INTEGER, - Endblk# INTEGER, - Recformat CHAR(4), - Reclength INTEGER, - Blklength INTEGER, - Creation DATE, - Catalogation DATE, - Lastaccess DATE, - Active CHAR(1) NOT NULL - Creatorname CHAR(8), - Creatoraccount CHAR(8), - Creatornode CHAR(8), - Creatorjob CHAR(8), - Protection INTEGER(2))
Alter table files_throng add (Userword0 INTEGER, - - Userword1 INTEGER, - Userword2 INTEGER, - Userword3 INTEGER, - Userword4 INTEGER, - Userword5 INTEGER, - Userword6 INTEGER, - Userword7 INTEGER, - Userword8 INTEGER, - Userword9 INTEGER, - Sysword0 INTEGER, - Sysword1 INTEGER, - Sysword2 INTEGER, - Sysword3 INTEGER, - Sysword4 INTEGER, - Sysword5 INTEGER, - Sysword6 INTEGER, - Sysword7 INTEGER, - Sysword8 INTEGER, - Sysword9 INTEGER, - Comments CHAR(80), - Mediatype CHAR(1)) CREATE TABLE FXV_throng ( File# INTEGER NOT NULL, - Fileseq# INTEGER NOT NULL, - Vol# INTEGER NOT NULL, - Volseq# INTEGER) CREATE TABLE Volumes_throng ( Vol# INTEGER NOT NULL, - VSN CHAR(6) NOT NULL, - VID CHAR(6) NOT NULL, - VIDprefix INTEGER, - Density INTEGER)