Google Apility MySQL Structure

I was looking around the Internet today (10th October 2005) trying to find a MySQL schema for the Google Adwords PHP Apility Library, but unfortunately I wasn't able to find one. So I have decided to create one myself and publish it as open source for anyone else to use. This is my first attempt at any open source project, so I apologise if you find it a little unpolished!

Note: Using InterCaps field names goes against how I would normally name a MySQL database field (I tend to use lowercase only), however because the Apility object attributes are referred to with InterCaps, I decided to keep the field names identical to these. If anyone feels I should do this differently then let me know.

Version	Date	Notes	Download
0.3	2006-07-07	This version has been changed to support version 1.4.4a of google-apility PHP library.	Download 0.3 MySQL Schema
0.2	2005-10-12	Slightly updated version, added reference tables for ISO codes and Language codes used by Google.	Download 0.2 MySQL Schema
0.1	2005-10-10	The first (and very experimental) version is released.	Download 0.1 MySQL Schema

• Will need to be updated to support the extended Geo Targets when the next apility version is released. The object structure will contain one new attribute: $geoTargetType and $countries will be changed to $geoTargets.

If you have any comments, criticisms or suggestions, or you would like to submit an improved version of the MySQL schema then please write to me at .

• Google Adwords Developer Reference
• Google Adwords PHP Apility Library
• MySQL languages table from Adwords API Languages List
• MySQL country table from ISO Countries List and SQL from here.
• Adwords API Geotargetting Info