Notes about MySQL

From OpenPetra Wiki
Jump to navigation Jump to search

backup solutions

Differences to PostgreSQL

  • we need to use InnoDB tables in order to have foreign key constraints
  • there are no default values for CURRENT_DATE, because it is a function; see also MySQL Documentation and MySQL Forum Discussion
  • there seem to be no SEQUENCES in MySQL; see for a proposed workaround: LAST_INSERT_ID

current implementation

  • PetraTools GenerateSQL.exe already creates the CREATE TABLE sql file
  • still todo:
    • load data from db/basedata CSV files (nant resetDatabase)
    • Ict.Common.DB needs an implementation of TMysql for IDataBaseRDBMS