summaryrefslogtreecommitdiff
path: root/
  • CREATE SEQUENCE session_session_id_seq;
  • CREATE TABLE session(
  • session_id INTEGER PRIMARY KEY DEFAULT <
    1. /basewiki_l10n
    2. /basewiki_nonedit
    3. /basewiki_nonedit_l10n
    4. /content
    5. /content_dummy
    6. /directives_l10n
    7. /smiley_l10n
    8. /templates_l10n
    9. /templates_nonedit
    10. /templates_nonedit_l10n
  • n_10" class="hl">-- LOCK TABLE acc_trans;
  • ALTER TABLE acc_trans ALTER COLUMN chart_id SET NOT NULL;
  • -- For older versions pre 8.0.3
  • ALTER TABLE acc_trans ADD COLUMN amount2 NUMERIC;
  • UPDATE acc_trans set amount2 = amount;
  • ALTER TABLE acc_trans DROP COLUMN amount;
  • ALTER TABLE acc_trans RENAME column amount2 TO amount;
  • UPDATE defaults SET version = '2.6.17';