Skip to content

Instantly share code, notes, and snippets.

@kieran

kieran/gist:426259

Created June 5, 2010 03:15
Show Gist options
  • Save kieran/426259 to your computer and use it in GitHub Desktop.
Save kieran/426259 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
mysql> describe stores;
+-----------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+------------------+------+-----+---------+----------------+
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| latitude | float | YES | | NULL | |
| longitude | float | YES | | NULL | |
| name | varchar(50) | YES | | NULL | |
| address_line_1 | varchar(40) | YES | | NULL | |
| address_line_2 | varchar(40) | YES | | NULL | |
| postal_code | varchar(6) | YES | | NULL | |
| city | varchar(25) | YES | | NULL | |
| telephone | varchar(14) | YES | | NULL | |
| fax | varchar(14) | YES | | NULL | |
| inventory_count | int(11) | YES | | NULL | |
| products_count | int(11) | YES | | NULL | |
| sunday_open | int(11) | YES | | NULL | |
| sunday_close | int(11) | YES | | NULL | |
| monday_open | int(11) | YES | | NULL | |
| monday_close | int(11) | YES | | NULL | |
| tuesday_open | int(11) | YES | | NULL | |
| tuesday_close | int(11) | YES | | NULL | |
| wednesday_open | int(11) | YES | | NULL | |
| wednesday_close | int(11) | YES | | NULL | |
| thursday_open | int(11) | YES | | NULL | |
| thursday_close | int(11) | YES | | NULL | |
| friday_open | int(11) | YES | | NULL | |
| friday_close | int(11) | YES | | NULL | |
| saturday_open | int(11) | YES | | NULL | |
| saturday_close | int(11) | YES | | NULL | |
+-----------------+------------------+------+-----+---------+----------------+
mysql> describe products;
+--------------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------------+------------------+------+-----+---------+----------------+
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| price_in_cents | int(11) | YES | | NULL | |
| name | varchar(100) | YES | | NULL | |
| stock_type | varchar(10) | YES | | NULL | |
| primary_category | varchar(32) | YES | | NULL | |
| secondary_category | varchar(32) | YES | | NULL | |
| origin | varchar(60) | YES | | NULL | |
| package | varchar(32) | YES | | NULL | |
| alcohol_content | int(11) | YES | | NULL | |
| sugar_content | varchar(5) | YES | | NULL | |
| producer_name | varchar(80) | YES | | NULL | |
| inventory_count | int(11) | YES | | NULL | |
+--------------------+------------------+------+-----+---------+----------------+
mysql> describe inventories;
+------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+------------------+------+-----+---------+----------------+
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| store_id | int(11) | YES | MUL | NULL | |
| product_id | int(11) | YES | MUL | NULL | |
| quantity | int(11) | YES | | NULL | |
| date | date | YES | MUL | NULL | |
+------------+------------------+------+-----+---------+----------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment