Vyššie na [Platon] / web-apps / finance-manager / sql

Added schema and problem description + solving method.

You must enable InnoDB support in your MySQL server, because
finance-manager uses transaction safe tables InnoDB.

Please, read documentation for your MySQL server.

1.    QUICK  HOWTO:
=-=-=-=-=-=-==--=-=

- remove line "skip-innodb" from /etc/mysql/my.cnf
- add these options into /etc/mysql/my.cnf:

  innodb_data_home_dir = /var/lib/mysql/
  innodb_data_file_path = ibdata1:10M:autoextend
  innodb_log_group_home_dir = /var/lib/mysql/
  innodb_log_arch_dir = /var/lib/mysql/
  innodb_buffer_pool_size = 16M
  innodb_additional_mem_pool_size = 2M
  innodb_log_file_size = 5M
  innodb_log_buffer_size = 8M
  innodb_flush_log_at_trx_commit = 1
  innodb_lock_wait_timeout = 50


2.    ERROR when creating database:
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

Error message:

ERROR 1217 at line 12: Cannot delete or update a parent row: a foreign key constraint fails

Solution:

Drop tables (or create tables) in the right order. Take a look at
create-sql-dump.sh script. Transation safe tables (InnoDB table type)
contains dependencies, which are checked by database server engine:


+------------+  eventid
| Transation |-----------------+
+------------+                 |
       |                       V
       |      from_source  +-------+
       |  +----------------| Event |
       |  |    to_source   +-------+
       V  V                    |
   +--------+                  |
   | Source |                  | event_type
   +--------+                  |
                               V
                        +------------+
                        | event_type |
                        +------------+



--
Lubomir Host 'rajo' <rajo AT platon. NOSPAM .sk>
2004-04-07