-
Notifications
You must be signed in to change notification settings - Fork 19
Change start value for accession numbers
Björn Albers edited this page Mar 8, 2022
·
1 revision
If you have existing studies in your PACS then you'll likely create new orders with an accession number offset.
This is what I did inside the web container to create accession numbers starting at 500.000:
$ bin/rails db -e production
SQLite version 3.7.13 2012-07-17 17:46:21
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> UPDATE SQLITE_SEQUENCE SET seq = 500000 where name = 'orders';
sqlite> SELECT name, seq FROM SQLITE_SEQUENCE;
stations|10
orders|500000
sqlite> .quit