Skip to content

Instantly share code, notes, and snippets.

@danahern
Created October 23, 2008 23:07
Show Gist options
  • Save danahern/19262 to your computer and use it in GitHub Desktop.
Save danahern/19262 to your computer and use it in GitHub Desktop.
mysql> select * from listing_types;
+----+--------------------+--------+---------------+---------+--------------+----------+------------+----------------+-------------+---------------------+
| id | name | cost | picture_count | amount | listing_time | position | level | promotion_time | pillar_type | discount_percentage |
+----+--------------------+--------+---------------+---------+--------------+----------+------------+----------------+-------------+---------------------+
| 1 | Gold | 0.00 | 8 | 1 | NULL | 1 | Listing | 0 | NULL | 0 |
| 2 | Platinum | 0.00 | 20 | 1 | NULL | 2 | Listing | 0 | NULL | 0 |
| 3 | Home Page Featured | 99.00 | 20 | 1 | NULL | 3 | Listing | 0 | NULL | 0 |
| 4 | Entry Level | 250.00 | 20 | 25 | NULL | 2 | Dealership | 1 | Auto | 10 |
| 5 | Advanced | 500.00 | 20 | 1000000 | NULL | 2 | Dealership | 1 | Auto | 25 |
| 6 | Advanced | 100.00 | 20 | 1000000 | NULL | 2 | Dealership | 1 | Boat | 25 |
| 7 | Advanced | 100.00 | 20 | 1000000 | NULL | 2 | Dealership | 1 | Motorcycle | 25 |
| 8 | Advanced | 100.00 | 20 | 1000000 | NULL | 2 | Dealership | 1 | Motorhome | 25 |
| 9 | Advanced | 100.00 | 20 | 1000000 | NULL | 2 | Dealership | 1 | Aircraft | 25 |
| 10 | Bold | 10.00 | 20 | 1 | NULL | 2 | Listing | 0 | NULL | 0 |
| 11 | Border | 10.00 | 20 | 1 | NULL | 2 | Listing | 0 | NULL | 0 |
| 12 | Color | 10.00 | 20 | 1 | NULL | 2 | Listing | 0 | NULL | 0 |
| 13 | Pay Per | 25.00 | 20 | 1000000 | NULL | 2 | Listing | 0 | NULL | 10 |
+----+--------------------+--------+---------------+---------+--------------+----------+------------+----------------+-------------+---------------------+
13 rows in set (0.00 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment