All pastes #758972 Raw Edit

Mine

public text v1 · immutable
·published 2007-11-02 18:49 UTC
rendered paste body
mysql> select * from  tblAdvertisementTypes;
+---------------------+---------------------------+------------------+-------------------------+
| AdvertisementTypeID | Name                      | Description      | AdvertisementCategoryID |
+---------------------+---------------------------+------------------+-------------------------+
|                   1 | Audio Insertion           | OrderSpotblocks  |                       3 |
|                   2 | Audio Insertion /w Banner | OrderSpotblocks  |                       3 |
|                   3 | Audio Gateway             | OrderImpressions |                       2 |
|                   4 | Video Gateway             | OrderImpressions |                       2 |
|                   5 | Banner                    | OrderClickthrus  |                       1 |
|                   6 | Audio Gateway /w Banner   | NULL             |                       2 |
|                   7 | Third-Party Banner        | OrderClickthrus  |                       1 |
|                   8 | Third-Party Gateway       | OrderImpressions |                       2 |
|                   9 | Video Gateway w/ Banner   | NULL             |                       2 |
+---------------------+---------------------------+------------------+-------------------------+


mysql> select * from tblAdvertisementCategories;
+-------------------------+-----------+
| AdvertisementCategoryID | Name      |
+-------------------------+-----------+
|                       1 | Banner    |
|                       2 | Gateway   |
|                       3 | Insertion |
+-------------------------+-----------+