Revision 1261
k-fish, 2008-09-19 18:25
TYPO3CR: Implemented MySQL testing, vastly improved PostgreSQL testing and wrote install shell script.- the SQL code contains key lengths for MySQL which are removed by all code that uses the SQL automatically if the database type is not mysql, fixes
#1486 - namespace URIs are now stored in TEXT columns, fixes
#1484 - MySQL gets it's ANSI_QUOTES option after connection setup in all places where connections are made
- install.sh allows fully automated setup of both production and test databases: MySQL, PostgreSQL, SQLite; calls fixpermissions.sh
- install.sh automatically calls web based database setup via lynx (could be wget if there are problems with the availability of lynx but lynx -dump gives more meaningful output)
- testdb.sh replaces the various db specific tools and is used by install.sh for testdb setup, also allows dumping and cleanup of test databases
- PHP code uses testdb.conf to read test database settings (all except sqlite currently)
- production and testing now use the same database schema file, multi-line statements are now supported by the storage helper too
Patch (mostly) by Matthias Hörmann.
Related issues
- Bug #1484: Namespace columns are used to store URIs now but are only VARCHAR(255)
- Bug #1486: Keys in current schema too long for MySQL
Files
added
modified
deleted