Example Data

The examples in this reference are based on the Adaptor for MySQL databases prototype deployed to Google AppEngine.

The prototype is connected to a database with the following tables and data:

Car Table

Column Name	MySql Data Type
_id	varchar(36)
_owner	varchar(36)
date_added	datetime
make	varchar(100)
model	varchar(100)
year	int

Car Table Data

_id	_owner	make	model	year	date_added
86cbf595-d369-48bb-8649-c6c082c003ca	81c9168e-95b8-47fd-8e6a-ad9fdf71b38e	Ford	Mustang	1995	2001-06-07 21:00:00.0
95953ca3-5fe5-4ce7-9cca-9bcc1ba64ba6	81c9168e-95b8-47fd-8e6a-ad9fdf71b38e	Toyota	Corolla	2019	2020-09-30 21:30:00.0
1e68ce9c-a7bc-4440-a9d4-7ce6b42e5be8	81c9168e-95b8-47fd-8e6a-ad9fdf71b38e	Mercedes-Benz	E Coupe	2020	2020-06-16 21:30:00.0
6d04fb52-f317-4d7b-bc23-46dd1c74d5a8	81c9168e-95b8-47fd-8e6a-ad9fdf71b38e	Hyundai	Tuscon	2005	2020-08-31 21:00:00.0
f551864f-4022-430e-b311-0215b9c9ac38	81c9168e-95b8-47fd-8e6a-ad9fdf71b38e	Hyundai	I20	2018	2018-07-31 21:00:00.0
295f6831-ce44-429d-aeb9-e3a91cdfc6e0	81c9168e-95b8-47fd-8e6a-ad9fdf71b38e	Nissan	Maxima	2012	2012-07-31 21:00:00.0
20cd8f8d-1a0f-4530-91df-6d31fe9e83a5	81c9168e-95b8-47fd-8e6a-ad9fdf71b38e	Ferrari	812GTS	2020	2020-03-31 21:00:00.0
4b0841dc-2355-4351-9cbc-2b6c9cf53cec	81c9168e-95b8-47fd-8e6a-ad9fdf71b38e	Mazda	MX5	2003	2002-12-09 22:00:00.0

Manufacturer Table

Column Name	MySql Data Type
name	varchar(100)
country	varchar(100)
established	datetime
share_price	decimal(10,2)
_id	varchar(36)
_owner	varchar(36)

Manufacturer Table Data

name	country	established	share_price	_id	_owner
Ford	USA	1903-01-01 12:00:00.0	6	abc-123
Nissan	Japan	1933-12-06 12:00:00.0	4.12	abc-124
Mercedes-Benz	Germany	1926-01-01 12:00:00.0	1.45	abc-125
Mazda	Japan	1920-01-30 12:00:00.0	6.96	abc-126
Ferrari	Italy	1947-01-01 12:00:00.0	152	abc-127
Citroen	France	1919-01-01 00:00:00.0	2.34	abc-128
Hyundai	Korea	1967-01-01 00:00:00.0	7.41	abc-129