DESKSTORAGES

"localhost:/firebird/data/ILICHEVSK2.FDB". ��

DESKSTORAGES

��

(�� DESKSTORAGES)

��

��	��	��
STORAGEID	INTEGER
STORAGEPARENTID	INTEGER
STORAGESHORTNAME	VARCHAR(15)
STORAGENAME	VARCHAR(100)
STORAGECONTROLNAME	VARCHAR(31)
STORAGETYPEID	INTEGER
STORAGEPLATFORMTYPEID	INTEGER
STORAGEUSERID	INTEGER
COMMENT	VARCHAR(254)

��

(�� DESKSTORAGES)

��

CREATE VIEW DESKSTORAGES(
    STORAGEID,
    STORAGEPARENTID,
    STORAGESHORTNAME,
    STORAGENAME,
    STORAGECONTROLNAME,
    STORAGETYPEID,
    STORAGEPLATFORMTYPEID,
    STORAGEUSERID,
    COMMENT)
AS
select STORAGELIST.STORAGEID, STORAGELIST.STORAGEPARENTID, STORAGELIST.STORAGESHORTNAME,
    STORAGELIST.STORAGENAME, STORAGELIST.STORAGECONTROLNAME, STORAGELIST.STORAGETYPEID,
--  STORAGELIST.STORAGEstoringtypeid,
    STORAGELIST.STORAGEPLATFORMTYPEID, STORAGELIST.STORAGEUSERID, STORAGELIST.COMMENT
  from STORAGE STORAGELIST
  where (STORAGELIST.STORAGETYPEID in (1,9))
    or ((STORAGELIST.STORAGEPARENTID is not null)
        and (exists(select * from STORAGE PARENTSTORAGE
               where (PARENTSTORAGE.STORAGETYPEID in (1,9))
                 and (PARENTSTORAGE.STORAGEID = STORAGELIST.STORAGEPARENTID))))
;