merceruniversity / hubbabubba-chewbacca-migration

Moving applications from Hubbabubba to Chewbacca before Hubbabubba dies.

0 stars 0 forks source link

Update Adjuncts Database on Chewbacca #36

Closed Sporkyy closed 6 years ago

Sporkyy commented 6 years ago

Tables and the fields to be altered

AccessLevel

None

AdminMessage

AdminMessageID

[x] Make Identity
[x] Set Seed = 15
[x] Make PK

CourseApprovals

ApprovalID

[x] Make Identity
[x] Set Seed = 11320
[x] Make PK

CourseCategories

CategoryID

[x] Make Identity
[x] Set Seed = 42
[x] Make PK

Courses

CourseID

[x] Make Identity
[x] Set Seed = 644
[x] Make PK

DegreeMajor

MajorID

[x] Make Identity
[x] Set Seed = 437
[x] Make PK

Degrees

DegreeID

[x] Make Identity
[x] Set Seed = 2452
[x] Make PK

DegreeSubject

SubjectID

[x] Make Identity
[x] Set Seed = 42
[x] Make PK

DegreeType

TypeID

[x] Make Identity
[x] Set Seed = 128
[x] Make PK

Departments

DeptID

[x] Make Identity
[x] Set Seed = 25
[x] Make PK

LocationPrefs

None

LocationPrefs Query

None

Locations

LocationID

[x] Make Identity
[x] Set Seed = 9
[x] Make PK

LoginMessage

None

Schools

SchoolID

[x] Make Identity
[x] Set Seed = 3
[x] Make PK

TeachingHistory

TeachingHistoryID

[x] Make Identity
[x] Set Seed = 4869
[x] Make PK

Term

TermID

[x] Make Identity
[x] Set Seed = 86
[x] Make PK

UserDepts

None

UserRights

None

Users

UserID

[x] Make Identity
[x] Set Seed = 870
[x] Make PK