Introduces an id field as primary key for UtubUrls, and removes previous composite primary key that consisted of utubID, urlID, and userID.
Enforces the usage of the UtubUrls.id field as the foreign key for URL reference in the UtubUrlTags table. Replaced the urlID foreign key that points to an entry in the Urls table, with a utubUrlID field that points towards the primary key of UtubUrls field.
Updates all JSON responses to use utubUrlID instead of urlID in responses where the urlID was provided.
Changes table name from
UrlTags
toUtubUrlTags
Introduces an
id
field as primary key forUtubUrls
, and removes previous composite primary key that consisted ofutubID
,urlID
, anduserID
.Enforces the usage of the
UtubUrls.id
field as the foreign key for URL reference in theUtubUrlTags
table. Replaced theurlID
foreign key that points to an entry in theUrls
table, with autubUrlID
field that points towards the primary key ofUtubUrls
field.Updates all JSON responses to use
utubUrlID
instead ofurlID
in responses where theurlID
was provided.