Confirmed users
1,158
edits
User:Clouserw/AMODBrefresh: Difference between revisions
no edit summary
No edit summary |
No edit summary |
||
| Line 48: | Line 48: | ||
<pre> | <pre> | ||
DATABASE='solitudedb'; echo mysql -Nse 'show tables' $DATABASE | grep -v schema_version | while read table; do mysql -e "set foreign_key_checks = 0; truncate table $table; set foreign_key_checks = 1;" $DATABASE ; done' | DATABASE='solitudedb'; echo mysql -Nse 'show tables' $DATABASE | grep -v schema_version | while read table; do mysql -e "set foreign_key_checks = 0; truncate table $table; set foreign_key_checks = 1;" $DATABASE ; done' | ||
</pre> | |||
<p>We then need to make some price tiers for the reference provider (zippy). A simple way to do this is to move all Bango price tiers over to the reference provider: | |||
<pre> | |||
UPDATE price_currency SET provider = 2; | |||
</pre> | </pre> | ||
<p> | <p> | ||