Make campaign ID (primary key) start at least from 10000

Avatar

Avatar

salvdangelo

Avatar

salvdangelo

salvdangelo

19-09-2017

Hi,

I would like to make sure that all campaign (operation) IDs are over 10.000 (since we import historical campaigns from a different source having IDs from 1 to about 9600).
Could you tell me step by step, I should I do this ?

I extended the "operation" schema with a custom one, if may help.
Someone suggested me to use a sequence for the primary key, but I never used it.

Thanks for your help,

Salvatore

florentlb

Amit_Kumar

Adhiyan

Vipul Raghav

Adobe Campaign

Replies

Avatar

Avatar

Adhiyan

Employee

Avatar

Adhiyan

Employee

Adhiyan
Employee

21-06-2018

Hi Ishani,

Technically this should be possible but I am not sure if sequence creation is possible with type as UUID.

Generally it's a number and it's assigned values automatically.

Also , have not seen such a configuration yet. Might as well you want to make that column as unique or not Null and populate them with values sequentially instead of making that as PK.

Regards,

Adhiyan