Project

General

Profile

« Previous | Next » 

Revision 8837

/README.TXT: Schema changes: Reinstall staging tables: added step to first run this on the local machine to check for any errors, before running it on the live DB, to prevent the live DB from becoming unrestorable in the case of bugs

View differences:

README.TXT
311 311
	Regenerate schema from installed DB: make schemas/remake
312 312
	Reinstall DB from schema: make schemas/public/reinstall schemas/reinstall
313 313
		WARNING: This will delete the current public schema of your VegBIEN DB!
314
	Reinstall staging tables: . bin/reinstall_all
314
	Reinstall staging tables:
315
		On local machine:
316
			. bin/reinstall_all
317
			Fix any bugs and retry until no errors
318
		On vegbiendev: . bin/reinstall_all
319
			WARNING: Do not run this until reinstall_all runs successfully on
320
			the local machine, or the live DB may be unrestorable!
315 321
	Sync ERD with vegbien.sql schema:
316 322
		Run make schemas/vegbien.my.sql
317 323
		Open schemas/vegbien.ERD.mwb in MySQLWorkbench

Also available in: Unified diff