SQL
CREATE TABLE "git_connection" (
"id" varchar(36) PRIMARY KEY NOT NULL,
"name" varchar(128) NOT NULL,
"repositoryUrl" text NOT NULL,
"branchName" varchar(255),
"connectionType" varchar(16) NOT NULL,
"publicKey" text,
"encryptedPrivateKey" text,
"encryptedUsername" text,
"encryptedPassword" text,
"keyGeneratorType" varchar(16),
"baseCommit" varchar(64),
"createdAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')),
"updatedAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')),
CONSTRAINT "CHK_git_connection_ssh_auth" CHECK ("connectionType" <> 'ssh' OR ("encryptedUsername" IS NULL AND "encryptedPassword" IS NULL)),
CONSTRAINT "CHK_git_connection_https_auth" CHECK ("connectionType" <> 'https' OR ("publicKey" IS NULL AND "encryptedPrivateKey" IS NULL AND "keyGeneratorType" IS NULL)),
CONSTRAINT "CHK_git_connection_connectionType" CHECK ("connectionType" IN ('ssh', 'https')),
CONSTRAINT "CHK_git_connection_keyGeneratorType" CHECK ("keyGeneratorType" IN ('ed25519', 'rsa'))
)
Columns
| Column | Data type | Allow null | Primary key | Actions |
|---|---|---|---|---|
id |
varchar(36) |
✓ | Rename | Drop | |
name |
varchar(128) |
Rename | Drop | ||
repositoryUrl |
TEXT |
Rename | Drop | ||
branchName |
varchar(255) |
✓ | Rename | Drop | |
connectionType |
varchar(16) |
Rename | Drop | ||
publicKey |
TEXT |
✓ | Rename | Drop | |
encryptedPrivateKey |
TEXT |
✓ | Rename | Drop | |
encryptedUsername |
TEXT |
✓ | Rename | Drop | |
encryptedPassword |
TEXT |
✓ | Rename | Drop | |
keyGeneratorType |
varchar(16) |
✓ | Rename | Drop | |
baseCommit |
varchar(64) |
✓ | Rename | Drop | |
createdAt |
datetime(3) |
Rename | Drop | ||
updatedAt |
datetime(3) |
Rename | Drop |
Indexes
| Name | Columns | Unique | SQL | Drop? |
|---|---|---|---|---|
| sqlite_autoindex_git_connection_1 |
id
|
✓ | SQL | Drop |