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)