New DB for JW
Posted by mholmes on 03 Feb 2011 in Activity log
JW has requested a new, smaller-scale db for another project, and sent details of the field structure. It will also use custom fields, so it's a useful testbed alongside the larger AdaptiveDB. Today I:
- built the schema in MySQL Workbench
- sent the schema diagram to JW for checking
- generated the db-creation sql
- added the custom-field-related sql (to create the fieldTypes, customFields, and customFieldData tables). I made a generic template for this, which I've added to the AdaptiveDB codebase.
- Created a db ("manifest") and an admin user for it ("manifest_admin") on mysql_dev.
- Tested and tweaked the table-creation sql until it worked.
If JW OKs the structure, I can build the local_classes.php file and we'll be ready to roll.