FilesExpand file tree

 develop

/

sequence_script.sql

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

9 lines (9 loc) · 664 Bytes

 develop

/

sequence_script.sql

Copy path

Top

File metadata and controls

• Code
• Blame

9 lines (9 loc) · 664 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

SELECT setval('datafile_id_seq', (SELECT MAX(id) FROM datafile));

SELECT setval('datafilecategory_id_seq', (SELECT MAX(id) FROM datafilecategory));

SELECT setval('datatable_id_seq', (SELECT MAX(id) FROM datatable));

SELECT setval('datavariable_id_seq', (SELECT MAX(id) FROM datavariable));

SELECT setval('dvobject_id_seq', (SELECT MAX(id) FROM dvobject));

SELECT setval('filemetadata_id_seq', (SELECT MAX(id) FROM filemetadata));

SELECT setval('variablecategory_id_seq', (SELECT MAX(id) FROM variablecategory));

SELECT setval('guestbook_id_seq', (SELECT MAX(id) FROM guestbook));

SELECT setval('guestbookresponse_id_seq', (SELECT MAX(id) FROM guestbookresponse));