Icon Stores Table

Structure
CREATE TABLE "Stores"
(
"Name" VARCHAR(40) COLLATE "ANSI_CI",
"Description" CLOB COLLATE "ANSI",
"Attributes" CLOB COLLATE "ANSI",
"Type" VARCHAR(30) COLLATE "ANSI_CI",
"Path" VARCHAR(255) COLLATE "ANSI_CI",
"Address" VARCHAR(16) COLLATE "ANSI_CI",
"Host" VARCHAR(60) COLLATE "ANSI_CI",
"Port" INTEGER,
"Service" VARCHAR(60) COLLATE "ANSI_CI",
"UserName" VARCHAR(40) COLLATE "ANSI_CI",
"Password" VARCHAR(60) COLLATE "ANSI_CI",
"RemoteStore" VARCHAR(40) COLLATE "ANSI_CI",
"Signature" VARCHAR(60) COLLATE "ANSI_CI",
"Encrypted" BOOLEAN,
"EncryptionPassword" VARCHAR(60) COLLATE "ANSI_CI",
"Compression" INTEGER,
"Timeout" INTEGER,
"Ping" BOOLEAN,
"PingInterval" INTEGER,
"CreateSQL" CLOB COLLATE "ANSI_CI",
"DropSQL" CLOB COLLATE "ANSI_CI"
)

CREATE INDEX "Name" ON "Stores"
("Name")

Description
This table containes the defined stores in an ElevateDB configuration. Each store in ElevateDB is defined with path information that determines the folder where the store will manage its files.

The Type column values are as follows:

TypeDescription
LocalThe store references a local path
RemoteThe store references another store defined on an ElevateDB Server

Related DDL Statements
StatementDescription
CREATE STORECreates a new store
ALTER STOREAlters an existing store
DROP STOREDrops an existing store
RENAME STORERenames an existing store
Image