-
Technical task
-
Resolution: Won't Fix
-
Major
-
None
-
None
-
None
-
20141009-201410015
The table that stores shared list metadata is called “CUSTOM_SERIES_LIST”. This table stores the data about the shared list, except the SeriesInstanceUIDs, which are stored in custom_series_list_attribute.
The table CUSTOM_SERIES_LIST contains the Name, Comment, URL, Username, Date and CUSTOM_SERIES_LIST_PK_ID (<— Primary Key)
The create shared list API expects a CSV that contains “Name”, “Comment”, “URL”, and “Username”.
The issue is that the PK column does not auto-increment.
Could we set it to auto increment?
i.e.
alter table NCIA.CUSTOM_SERIES_LIST modify column CUSTOM_SERIES_LIST_PK_ID bigint(20) auto_increment