- poolid integer not null default pool_seq.nextval,
- name varchar(256) not null,
- numvols integer default 0,
- maxvols integer default 0,
- useonce smallint default 0,
- usecatalog smallint default 0,
- acceptanyvolume smallint default 0,
- volretention bigint default 0,
- voluseduration bigint default 0,
- maxvoljobs integer default 0,
- maxvolfiles integer default 0,
- maxvolbytes bigint default 0,
- autoprune smallint default 0,
- recycle smallint default 0,
- ActionOnPurge smallint default 0,
- pooltype varchar(256)
- check (pooltype in ('Backup','Copy','Cloned','Archive','Migration','Scratch')),
- labeltype integer default 0,
- labelformat varchar(256) not null,
- enabled smallint default 1,
- scratchpoolid integer default 0,
- recyclepoolid integer default 0,
- NextPoolId integer default 0,
- MigrationHighBytes BIGINT DEFAULT 0,
- MigrationLowBytes BIGINT DEFAULT 0,
- MigrationTime BIGINT DEFAULT 0,
- primary key (poolid)
+ PoolId INTEGER NOT NULL DEFAULT pool_Seq.nextval,
+ Name VARBYTE(128) NOT NULL,
+ NumVols INTEGER DEFAULT 0,
+ MaxVols INTEGER DEFAULT 0,
+ UseOnce SMALLINT DEFAULT 0,
+ UseCatalog SMALLINT DEFAULT 0,
+ AcceptAnyVolume SMALLINT DEFAULT 0,
+ VolRetention BIGINT DEFAULT 0,
+ VolUseDuration BIGINT DEFAULT 0,
+ MaxVolJobs INTEGER DEFAULT 0,
+ MaxVolFiles INTEGER DEFAULT 0,
+ MaxVolBytes BIGINT DEFAULT 0,
+ AutoPrune SMALLINT DEFAULT 0,
+ Recycle SMALLINT DEFAULT 0,
+ ActionOnPurge SMALLINT DEFAULT 0,
+ PoolType VARBYTE(32)
+ CHECK (pooltype in ('Backup','Copy','Cloned','Archive','Migration','Scratch')),
+ LabelType INTEGER DEFAULT 0,
+ LabelFormat VARBYTE(128) NOT NULL,
+ Enabled SMALLINT DEFAULT 1,
+ ScratchPoolId INTEGER DEFAULT 0,
+ RecyclePoolId INTEGER DEFAULT 0,
+ NextPoolId INTEGER DEFAULT 0,
+ MigrationHighBytes BIGINT DEFAULT 0,
+ MigrationLowBytes BIGINT DEFAULT 0,
+ MigrationTime BIGINT DEFAULT 0,
+ PRIMARY KEY (poolid)