Ooh. Once you start changing the DB manually ... all bets are off. Regarding the pipeline history page, it'll likely be joining a few tables. Here are some pointers that might help:
1. See [this query](https://github.com/gocd/gocd/blob/fdbdbd4477cd8ae9b90b5dae883199f01fe00dce/server/src/main/resources/com/thoughtworks/go/server/dao/maps/Pipeline.xml#L282) and [this one](https://github.com/gocd/gocd/blob/fdbdbd4477cd8ae9b90b5dae883199f01fe00dce/server/src/main/resources/com/thoughtworks/go/server/dao/maps/Pipeline.xml#L296). These might not be the right ones, but will give you a sense of the kind of things being done. You'll need to follow the "<include>" tags to find the queries which will be merged into this one. 2. [Outdated DB schema diagram](https://github.com/gocd/developer.go.cd/blob/a76dac9fbfd06e550b2558326ef91b40715f0729/source/4/images/database_schema.png): Might give you a sense of the connections. It's outdated though. So, don't rely on it too much. Cheers, Aravind -- You received this message because you are subscribed to the Google Groups "go-cd" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/go-cd/m2zgy1svsa.fsf%40arvindsv.com.
