From 8f9d87008461388052bf2738627157343030c4a7 Mon Sep 17 00:00:00 2001 From: Don Armstrong Date: Fri, 14 Apr 2017 09:34:50 -0700 Subject: [PATCH] update DBI documentation --- sql/README.mdwn | 10 ++++------ 1 file changed, 4 insertions(+), 6 deletions(-) diff --git a/sql/README.mdwn b/sql/README.mdwn index 334fabc..a5dc05e 100644 --- a/sql/README.mdwn +++ b/sql/README.mdwn @@ -7,13 +7,11 @@ To make changes to the database schema: debbugs_schema.sql file, and make corresponding changes to the database (or dump the entire database and otherwise make the changes). -2. Run `./sql/dbicdump_command.sh` to update the DBIx::Class classes - which are under Debbugs::DB + + If you add non-unique indexes, you will need to add an sqlt_deploy_hook + (or edit an exist one) to add the index +2. Run `./sql/dbicdump_command.sh` to update the DBIx::Class classes which are + under Debbugs::DB if you made changes to the database directly 3. Increment the version of Debbugs::DB; -4. Run `./bin/debbugs-installsql --install --deployment-dir sql --developer-prepare` - and `./bin/debbugs-installsql --upgrade --deployment-dir sql --developer-prepare` - which will generate the files necessary to do upgrades in the field. - Steps 1 and 2 can alternatively be performed by changing the DBIx::Class classes directly if that is desired. -- 2.39.2