schema

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