summaryrefslogtreecommitdiff
path: root/sql/modules/README
blob: a305f1e27ebb1e439569240e747a66e506251474 (plain)
  1. This set of files is just for initial testing and proof of concept purposes.
  2. They will be moved out of here into appropriate upgrade scripts as necessary
  3. and are intended only for collaborative development purposes.
  4. For people trying to get 1.3 up and running manually, the following load order
  5. should work. Note that many of these scripts declare types, so if you want to
  6. redefine functions, you will need to drop the types and reload the scripts.
  7. Drafts.sql
  8. chart.sql
  9. Account.sql
  10. Session.sql
  11. Business_type.sql
  12. Location.sql
  13. Company.sql
  14. Customer.sql
  15. Date.sql
  16. Defaults.sql
  17. Settings.sql
  18. Employee.sql
  19. Entity.sql
  20. Payment.sql
  21. Person.sql
  22. Report.sql
  23. Voucher.sql
  24. Note that the Roles.sql is special and must be preprocessed to get it to work.
  25. A command like:
  26. sed -e 's/<?lsmb dbname ?>/[dbname]/g' Roles.sql > [dbname]_roles.sql
  27. would work where [dbname] represents the name of the database you are
  28. installing into.
  29. Also Roles.sql MUST be run last because portions of it depend on function
  30. declarations in the other scripts.
  31. The following files are not ready to be loaded:
  32. admin.sql
  33. security.sql
  34. Reconciliaton.sql