FriendsOfSymfony/FOSUserBundle — pull request #574 by c33s (2012-03-24 05:31:46+00:00)
Title: prefixed fos table names in propel schema with "fos_" because "user" and...

... "group" are reserved sql words

the used tables names in the propel schema are reserved sql keywords. this renders the fos user bundle unuseable with postgres (yes, developers which use postgres exist :) ). i have not tested it in depth but as i tried to get fos user bundle up and running with postgres i also tried sqlite which doesn't worked either.

by simple prefixing the table names with "fos_" it works out of the box.

currently we had to use the propel external schema feature to override the default names.

it's not a good practice using reserved keywords as table names.

http://www.postgresql.org/docs/8.2/static/sql-keywords-appendix.html
```
Key Word	PostgreSQL	SQL:2003	SQL:1999	SQL-92
USER	reserved	reserved	reserved	reserved
GROUP	reserved	reserved	reserved	reserved
```

https://dev.mysql.com/doc/refman/5.0/en/reserved-words.html
````
Table 8.2. Reserved Words in MySQL 5.0.96
GROUP
````

escaping with quotes is also a solution but this relies on the ORM/DAL and also can have sideeffects like making the case of the table relevant. see 4.1.1. Identifiers and Key Words http://www.postgresql.org/docs/8.2/static/sql-syntax-lexical.html

currently i have a broken test environment, if someone can run the tests for me?