X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;f=sql%2FREADME.mdwn;fp=sql%2FREADME.mdwn;h=a5dc05e9e0a2cf607a5495e29c788e067e611d77;hb=53c435119200ab9b1c2538a96b8374c51a078855;hp=0000000000000000000000000000000000000000;hpb=0e8f07fda6e40b5967d9c6b28b3200db22766343;p=debbugs.git

diff --git a/sql/README.mdwn b/sql/README.mdwn
new file mode 100644
index 0000000..a5dc05e
--- /dev/null
+++ b/sql/README.mdwn
@@ -0,0 +1,17 @@
+# Developer specific instructions #
+## Upgrading Schema ##
+
+To make changes to the database schema:
+
+1. Make whatever changes are appropriate to the SQL directly in the
+   debbugs_schema.sql file, and make corresponding changes to the
+   database (or dump the entire database and otherwise make the
+   changes).
+    + 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;
+
+Steps 1 and 2 can alternatively be performed by changing the
+DBIx::Class classes directly if that is desired.