FilesExpand file tree

 main

/

delete.sql

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

17 lines (16 loc) · 456 Bytes

 main

/

delete.sql

Copy path

Top

File metadata and controls

• Code
• Blame

17 lines (16 loc) · 456 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

-- Delete table entries

DELETE FROM ISSUE_LABEL;

DELETE FROM LABEL;

DELETE FROM COMMENT;

DELETE FROM ISSUE;

DELETE FROM STATETRANSITION;

DELETE FROM STATE;

DELETE FROM PROJECT;

DELETE FROM USERS;

-- Restart identity columns

ALTER SEQUENCE STATE_sid_seq restart;

ALTER SEQUENCE ISSUE_iid_seq restart;

ALTER SEQUENCE LABEL_lid_seq restart;

ALTER SEQUENCE COMMENT_cid_seq restart;

ALTER SEQUENCE PROJECT_pid_seq restart;

ALTER SEQUENCE USERS_uid_seq restart;