Mercurial > p > roundup > code
comparison doc/mysql.txt @ 3929:a472391156ae
mysql table creation syntax change
The MySQL people gratuitously changed the syntax for specifying the storage
engine a while back and the current alpha drops support for the old syntax.
This patch changes TYPE to ENGINE in the mysql backend and updates the
documentation to show that we require MySQL 4.0.18 because of that. I also
removed a note in the mysql docs about a bug in InnoDB that has been fixed as
of the required version.
This fixes [SF#1727529]
| author | Justus Pendleton <jpend@users.sourceforge.net> |
|---|---|
| date | Fri, 28 Sep 2007 15:26:10 +0000 |
| parents | ad4fb8a14a97 |
| children | 6a32a2fb95b4 |
comparison
equal
deleted
inserted
replaced
| 3928:24440a420f53 | 3929:a472391156ae |
|---|---|
| 1 ============= | 1 ============= |
| 2 MySQL Backend | 2 MySQL Backend |
| 3 ============= | 3 ============= |
| 4 | 4 |
| 5 :version: $Revision: 1.12 $ | 5 :version: $Revision: 1.13 $ |
| 6 | 6 |
| 7 This notes detail the MySQL backend for the Roundup issue tracker. | 7 This notes detail the MySQL backend for the Roundup issue tracker. |
| 8 | 8 |
| 9 | 9 |
| 10 Prerequisites | 10 Prerequisites |
| 11 ============= | 11 ============= |
| 12 | 12 |
| 13 To use MySQL as the backend for storing roundup data, you also need | 13 To use MySQL as the backend for storing roundup data, you also need |
| 14 to install: | 14 to install: |
| 15 | 15 |
| 16 1. MySQL RDBMS 4.0.16 or higher - http://www.mysql.com. Your MySQL | 16 1. MySQL RDBMS 4.0.18 or higher - http://www.mysql.com. Your MySQL |
| 17 installation MUST support InnoDB tables (or Berkeley DB (BDB) tables | 17 installation MUST support InnoDB tables (or Berkeley DB (BDB) tables |
| 18 if you have no other choice). If you're running < 4.0.16 (but not <4.0) | 18 if you have no other choice). If you're running < 4.0.18 (but not <4.0) |
| 19 then you'll need to use BDB to pass all unit tests. Edit the | 19 then you'll need to use BDB to pass all unit tests. Edit the |
| 20 ``roundup/backends/back_mysql.py`` file to enable DBD instead of InnoDB. | 20 ``roundup/backends/back_mysql.py`` file to enable DBD instead of InnoDB. |
| 21 2. Python MySQL interface - http://sourceforge.net/projects/mysql-python | 21 2. Python MySQL interface - http://sourceforge.net/projects/mysql-python |
| 22 | |
| 23 .. note:: | |
| 24 The InnoDB implementation has a bug__ that Roundup tickles. See | |
| 25 | |
| 26 __ http://bugs.mysql.com/bug.php?id=1810 | |
| 27 | |
| 28 | 22 |
| 29 Running the MySQL tests | 23 Running the MySQL tests |
| 30 ======================= | 24 ======================= |
| 31 | 25 |
| 32 Roundup tests expect an empty MySQL database. Two alternate ways to provide | 26 Roundup tests expect an empty MySQL database. Two alternate ways to provide |