Mercurial > p > roundup > code
comparison doc/upgrading.txt @ 4332:61f2e659faf7
add SQL detail
| author | Richard Jones <richard@users.sourceforge.net> |
|---|---|
| date | Fri, 29 Jan 2010 05:53:44 +0000 |
| parents | 15f74c03d9f5 |
| children | 261c9f913ff7 |
comparison
equal
deleted
inserted
replaced
| 4331:7327b102920f | 4332:61f2e659faf7 |
|---|---|
| 317 In the latest version we have added some database indexes to the | 317 In the latest version we have added some database indexes to the |
| 318 SQL-backends (mysql, postgresql, sqlite) for speeding up building the | 318 SQL-backends (mysql, postgresql, sqlite) for speeding up building the |
| 319 roundup-index for full-text search. We recommend that you create the | 319 roundup-index for full-text search. We recommend that you create the |
| 320 following database indexes on the database by hand:: | 320 following database indexes on the database by hand:: |
| 321 | 321 |
| 322 CREATE INDEX words_by_id ON __words (_textid) | 322 CREATE INDEX words_by_id ON __words (_textid); |
| 323 CREATE UNIQUE INDEX __textids_by_props ON __textids (_class, _itemid, _prop) | 323 CREATE UNIQUE INDEX __textids_by_props ON __textids (_class, _itemid, _prop); |
| 324 | 324 |
| 325 Migrating from 1.2.x to 1.3.0 | 325 Migrating from 1.2.x to 1.3.0 |
| 326 ============================= | 326 ============================= |
| 327 | 327 |
| 328 1.3.0 Web interface changes | 328 1.3.0 Web interface changes |