[jira] [Created] (TC-126) Seeded data represented as a migration was lost

["Jeremy Mitchell (JIRA)" <ji...@apache.org>]

Jeremy Mitchell created TC-126:
----------------------------------

             Summary: Seeded data represented as a migration was lost 
                 Key: TC-126
                 URL: https://issues.apache.org/jira/browse/TC-126
             Project: Traffic Control
          Issue Type: Bug
          Components: Traffic Ops
    Affects Versions: 2.0.0
            Reporter: Jeremy Mitchell
             Fix For: 2.0.0


The move from 1.8.x (mysql) to 2.0.x (postgres) involved rolling all the changes represented in the migration files into the create_tables.sql file and removing the migration files leaving only migration files that reflect schema changes after 1.8.

However, some of these migration files included "seed data" or inserts which would not be captured in create_tables.sql.

For example, the "ANY_MAP" delivery service type was lost as well as job agent and job status entries required for content invalidation.

Need to go thru each deleted migration file to find seed data and move it to seeds.sql





--
This message was sent by Atlassian JIRA
(v6.3.15#6346)