Dublin Core Metadata Elements as MySQL Table


I just took a few minutes and built a simple MySQL table to store the 51 Dublin Core metadata elements that make up the "core" and "other elements". Except for elements that are dates, I used "text" fields for everything so that it can hold anything you can throw at it, while still being indexable and searchable.

I haven't updated the Lightweight Asset Manager to use the full schema yet, but here's the raw SQL to generate your own copy of the table if you want it.

There is a small chance that there are some typos etc (since I haven't tested it yet, and I built it while stretched out on the couch watching the finale of the Race).


See Also