Ghost
New
pippinmole
/
ghost
public
forked from
ghost/ghost
Source code of Ghost - On Ghost
Star
0
Fork
0
Code
Issues
0
Pull requests
0
main
76
branches
Go to file
t
Code
ghost
packages
db
drizzle
0041_pull_ref_write_pending.sql
pull-requests: recover pull ref storage accounting after commit failures without double counting
f47590e
11 days ago
7 lines · 529 B
1
CREATE
TABLE
"
pull_request_ref_write_pending
" (
2
"
id
"
text
PRIMARY KEY
3
"
pull_request_id
"
text
NOT NULL
4
);
5
--
> statement-breakpoint
6
ALTER
TABLE
"
pull_request_ref_write_pending
"
ADD
7
CREATE
INDEX
"
pull_request_ref_write_pending_pull_idx
"
ON
NOT NULL
,
CONSTRAINT
"
pull_request_ref_write_pending_pull_request_id_pull_request_id_fk
"
FOREIGN KEY
(
"
pull_request_id
"
)
REFERENCES
"
public
"
.
"
pull_request
"
(
"
id
"
)
ON DELETE cascade
ON UPDATE
no
action
;
--
> statement-breakpoint
"
pull_request_ref_write_pending
"
USING
btree (
"
pull_request_id
"
);