Example MySQL Schemas from open-source projects
You can contribute any schema with the following syntax:
$ mysqldump -u[user] -p --skip-lock-tables --no-data --databases [schema] > [schema].sql
Existing schemas include:
- wordpress.sql
- drupal.sql
- mediawiki.sql
- joomla.sql
- oscommerce.sql - https://raw.github.com/osCommerce/oscommerce2/master/catalog/install/oscommerce.sql
- ezpublish.sh - https://raw.github.com/ezsystems/ezpublish/master/kernel/sql/mysql/kernel_schema.sql & https://raw.github.com/ezsystems/ezpublish/master/kernel/sql/mysql/cluster_db_schema.sql
- sakila.sql - http://downloads.mysql.com/docs/sakila-db.tar.gz
- employees.sql - http://bazaar.launchpad.net/~sandbox-developers/test-db/employees_db_1/download/head:/employees.sql-20080729220128-yub0xyoby9skmnf3-4/employees.sql
- classicmodels.sql - http://www.mysqltutorial.org/mysql-sample-database.aspx
- magento.sql -- http://www.magentocommerce.com/wiki/2_-_magento_concepts_and_architecture/magento_database_diagram