aboutsummaryrefslogtreecommitdiffstats
path: root/db/migrate
AgeCommit message (Collapse)Author
2017-11-14Remove rule parameter set routeXinhui
Refs #4516 Removel rule parameter set from migration
2017-11-14Drop table rule_parameter_setsXinhui
Refs #4516
2017-11-13compliance_check_resources: Rename `type` column to `resource_type`Teddy Wing
The Java application needs a `resource_type` column to be able to store the class/object that was validated by the resource's check. Since we don't need or want Single Table Inheritance on this table, rename the existing `type` field to `resource_type`. Refs #4953
2017-11-10Change `compliance_check_set_id` to `bigint`Teddy Wing
I had missed this one in 63d85933ac99453c76df7cda102a4f60d94f5f53. Thanks a lot to Robert for scouring the fields and finding it. Since the v2 migration was irreversible, add a new one to change the type of this foreign key. Refs #4947
2017-11-10Migrate all foreign keys to `bigint` from `integer`Teddy Wing
All our primary keys are supposed to be `bigint`s, and our foreign keys should likewise be `bigint`s. But it's easy to forget this when creating migrations, or some committers might not have been up to speed on the convention. In any case, this changes all existing foreign keys to be `bigint`s. Need to get this out now so that Michel Etienne can use it to correctly test the Java application for compliance check validations. That's why I'm not including any future-looking checks or enforcements here. That will be coming next. Refs #4947
2017-11-10Remove RouteSection from SetUpdatedAt migration. Refs #4944Alban Peignier
2017-11-09add object_id_format to migrations, create module for call Referential, Line ↵Guillaume
Referential, StopAreaReferential in models, add Enumerize in models Refs #4941
2017-11-09Migration drop table route_sections & journey_pattern_sectionsXinhui
2017-11-06Refs #4859 Change ImportMessage#criticity type to stringcedricnjanga
2017-10-16Fix uniqueness for code in compliance_control_set Refs #4731Luc Donnet
2017-10-12Refs: #4709@0.75h;Robert
DONE: - Copied all node atts for ComplianceChecks - Migration of CompliancCheck#criticity int -> string TODO: - Check what to do with attribute ComplianceCheck#type
2017-10-03Refs #4661 Remove string column from ComplianceCheckSetcedricnjanga
2017-10-03Add attributes to compliance check set Refs #4661cedricnjanga
2017-10-03Refs #4678 Add migration to convert control attributes to hstorecedricnjanga
2017-10-02Refs #4638 Add reliation between ComplianceCheckSet and CompliancecheckMessagecedricnjanga
2017-09-28Refs #4626 Add compliance_check_set_id to ComplianceCheckResourcecedricnjanga
2017-09-28Refs #4625 Add status to ComplianceCheckMessagecedricnjanga
2017-09-28Revert references compliance_control should belong to compliance_control blockXinhui
2017-09-28Refs #4623 : Add orrigin code to Compliance Checkcedricnjanga
2017-09-27Refs #4615 Refacto compliance control models and add origin_code to ↵cedricnjanga
ComplianceControl model
2017-09-27Remove compliance control block id column from compliance_controls tableXinhui
Refs #4585
2017-09-27Nested compliance control blockXinhui
Refs #4585
2017-09-25Add data migration to give all Workbenches a ReferentialSuiteTeddy Wing
Existing `Workbench`es don't have associated `ReferentialSuite`s in their `output` fields. The new requirement is that all `Workbench`es must have a `ReferentialSuite`. To enforce this for existing `Workbench` records, this data migration creates new (empty) `ReferentialSuite`s for each existing `Workbench`. Not performant at all, and I'm worried I'm missing some edge case, but this is the gist of it. Refs #3520
2017-09-25Add `output_id` column to `workbenches`Teddy Wing
This column will be a reference to a `ReferentialSuite`. Going forward, all `Workbench`es will be required to have an associated `ReferentialSuite`. Refs #3520
2017-09-22Add `has_many` association between `Referential` and `ReferentialSuite`Teddy Wing
`ReferentialSuite` has many `Referential`s. Need to add a foreign key column to the `referentials` table to allow that to work. Refs #3519
2017-09-22Add `ReferentialSuite`Teddy Wing
This model is responsible for collecting referentials in order to merge them into a single referential. * `new` corresponds to a referential in the process of being validated * `current` corresponds to the most recently validated referential Refs #3519
2017-09-18Fix table name compliance_check_result to compliance_check_message Refs #4390 @2Luc Donnet
2017-09-15Initialize first model for compliance_control STI Refs #3550 @4Luc Donnet
2017-09-14Change wayback values in route Refs #3395 @4Luc Donnet
2017-09-13Restore /20131029115820_create_compliance_check_results. Refs #4469Alban Peignier
2017-09-12Merge branch 'master' into compliance_controlXinhui Xu
2017-09-07Add data_source_ref for model Route, JourneyPattern, RoutingConstraintZone, ↵Xinhui
VehicleJourney, Timetable, Footnote Refs #4368
2017-09-06Model ComplianceCheckResultXinhui
Refs #4390
2017-09-06Model ComplianceCheckResourceXinhui
Refs #4391
2017-09-06Resolve merge conflictcedricnjanga
2017-09-06Model ComplianceCheckXinhui
Refs #4388
2017-09-05Model ComplianceCheckBlockXinhui
Refs #4387
2017-09-05Model ComplianceCheckSetXinhui
Refs #4386
2017-09-05Model ComplianceControlXinhui
Refs #4385
2017-09-05Model ComplianceControlBlockXinhui
Refs #4384
2017-09-05Model ComplianceControlSetXinhui
Refs #4383
2017-09-04Update workbench_import, netex_import and import_resources views Refs #4256 ↵Luc Donnet
#4257 #4258
2017-08-31Merge branch 'master' into stif_netex_objectidXinhui
2017-08-31Remove model WorkbenchObjectIdentifierXinhui
2017-08-17Model ApiKey add belongs_to organisationXinhui
2017-08-16Add creator column to importsXinhui
Refs #4270
2017-08-09Merge branch 'master' of github.com:af83/stif-boivRobert
2017-08-08Model WorkbenchObjectIdentifierXinhui
2017-08-08Change checksum_source column to textXinhui
2017-08-08Merge branch 'checksum'Xinhui