SQL_Scripts

Jump to bottom Edit New page

Matt West edited this page Oct 27, 2012 · 2 revisions

summary All information regarding the sql scripts used for install/update of db scheme

Introduction

Any change to the database design must be done in a couple of places so that everything works all OK for the users

Details

  * ./sys/include/sql_patches.php
    * Add a new patch to the sql patches file - this file gets run when the users is upgrading from a previous version. SI check what patches has been run when it opens and prompts the user to run the required patches if it finds any unrun
   * Below is an example sql patch

  * The below 4 files need to be updated with the new fields/changes
    * sys/databases/json/sample_data.json
    * sys/databases/json/essential_data.json
    * databases/mysql/Full_Simple_Invoices.sql
      * i normally generate this from phpmyadmin once the db is all up to date
    * sys/databases/mysql/structure.sql