localprojects / Change-By-Us

A new way to share ideas, do projects, and make our cities better
changeby.us
Other
55 stars 27 forks source link

Removed all occurrences of 'latin1' #24

Closed cvee closed 12 years ago

cvee commented 12 years ago

This pull request should resolve Issue #23.

In addition, I added a new script in sql/mysql/schema.sql that automates the creating the database schema and user then import models.sql, data_badwords.sql, data_tasks.sql, data_user_groups.sql.

The installation instructions on the Wiki should be updated with the following:

Open sql/mysql/schema-mysql.sql in a text editor. Replace the placeholder values db_name, db_user_name and db_user_password with your desired database name and authentication credentials.

Save sql/mysql/schema-mysql.sql then run the script to create the database schema:

mysql -u root -p < sql/mysql/schema.sql