Code:
CREATE TABLE directory (
entry_id INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY,
entry_type CHAR(4) NOT NULL,
entry_name VARCHAR(128) NOT NULL,
zimbra_id CHAR(36),
modified SMALLINT NOT NULL,
CONSTRAINT pk_directory PRIMARY KEY (entry_id),
CONSTRAINT ui_directory_entry_type_name UNIQUE(entry_type, entry_name)
);
IJ ERROR: Unable to establish connection
ij> CREATE UNIQUE INDEX ui_directory_zimbra_id ON directory(zimbra_id);
IJ ERROR: Unable to establish connection
ij> CREATE TABLE directory_attrs (
entry_id INTEGER NOT NULL,
name VARCHAR(255) NOT NULL,
value VARCHAR(10240) NOT NULL,
CONSTRAINT fk_dattr_entry_id FOREIGN KEY (entry_id) REFERENCES directory(entry_id)
ON DELETE CASCADE
);
IJ ERROR: Unable to establish connection
ij> CREATE INDEX i_dattr_entry_id_name ON directory_attrs(entry_id, name);
IJ ERROR: Unable to establish connection
ij> CREATE INDEX i_dattr_name ON directory_attrs(name);
IJ ERROR: Unable to establish connection
ij> CREATE TABLE directory_leaf (
entry_id INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY,
parent_id INTEGER NOT NULL,
entry_type CHAR(4) NOT NULL,
entry_name VARCHAR(128) NOT NULL,
zimbra_id CHAR(36) NOT NULL,
CONSTRAINT pk_dleaf PRIMARY KEY (entry_id),
CONSTRAINT ui_dleaf_zimbra_id UNIQUE (zimbra_id),
CONSTRAINT ui_dleaf_parent_entry_type_name UNIQUE (parent_id, entry_type, entry_name),
CONSTRAINT fk_dleaf_entry_id FOREIGN KEY (parent_id) REFERENCES directory(entry_id)
ON DELETE CASCADE
);
IJ ERROR: Unable to establish connection
ij> CREATE TABLE directory_leaf_attrs (
entry_id INTEGER NOT NULL,
name VARCHAR(255) NOT NULL,
value VARCHAR(10240) NOT NULL,
CONSTRAINT fk_dleafattr_entry_id FOREIGN KEY (entry_id) REFERENCES directory_leaf(entry_id)
ON DELETE CASCADE
);
IJ ERROR: Unable to establish connection
ij> CREATE INDEX i_dleafattr_entry_id_name ON directory_leaf_attrs(entry_id, name);
IJ ERROR: Unable to establish connection
ij> CREATE INDEX i_dleafattr_name ON directory_leaf_attrs(name);
IJ ERROR: Unable to establish connection
ij> RUN '/home/mgracy/zimbra/zdesktop/db/versions-init.sql';
ij> -- AUTO-GENERATED .SQL FILE - Generated by the Derby versions tool
INSERT INTO zimbra.config(name, value, description) VALUES
('db.version', '53', 'db schema version'),
('index.version', '2', 'index version'),
('redolog.version', '1.23', 'redolog version');
IJ ERROR: Unable to establish connection
ij> INSERT INTO volume (id, type, name, path, file_bits, file_group_bits,
mailbox_bits, mailbox_group_bits, compress_blobs, compression_threshold)
VALUES (1, 1, 'message1', '/home/mgracy/zimbra/zdesktop/store', 12, 8, 12, 8, 0, 4096);
IJ ERROR: Unable to establish connection
ij> INSERT INTO volume (id, type, name, path, file_bits, file_group_bits,
mailbox_bits, mailbox_group_bits, compress_blobs, compression_threshold)
VALUES (2, 10, 'index1', '/home/mgracy/zimbra/zdesktop/index', 12, 8, 12, 8, 0, 4096);
IJ ERROR: Unable to establish connection
ij> INSERT INTO current_volumes (message_volume_id, index_volume_id, next_mailbox_id) VALUES (1, 2, 1);
IJ ERROR: Unable to establish connection
ij> EXIT;