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:


Related DDL Statements

---