by domminic59 » Mon Jun 07, 2010 1:24 pm
Table Name Table Description
phpbb_garage All the main vehicle information is stored in this table. There is one entry per vehicle
phpbb_garage_business All business's are listed in this table
phpbb_garage_categories Categories are the means of dividing different types of modifications into logical groups.
phpbb_garage_config Garage configuration values. The values are in a name / value pair. For example, a name of "version" has a value of "1.0.3". The values in this table may be provided by a default phpBB Garage install, or there may be additional values added by various mods. These values are maintained via the Configuration option on the ACP.
phpbb_garage_gallery This table holds the imformation about which images are in a gallery for any vehicle.
phpbb_garage_guestbooks Stores all the posts of comments entered into a vehicles guestbook
phpbb_garage_images Every image record wether it be connected to a vehicle, modification, quartermile or dynorun are located in this table
phpbb_garage_insurance Contains all the insurance premiums entered for vehicles.
phpbb_garage_makes A list of vehicle makes.
phpbb_garage_models A list of vehicle models.
phpbb_garage_mods Stores all modifications added to a vehicle.
phpbb_garage_quartermile Contains all the quartermile data related to any vehicle
phpbb_garage_rating Records every vote for a vehicle.
phpbb_garage_rollingroad Contains all the dynorun records for all vehicles.
phpbb_garage
Contains vehicle data
Column Name Datatype Default Column Description
id int(10) unsigned
auto_increment System assigned primary key, no user interaction required.
member_id int(10) 0 Foreign key to the phpbb_users table, showing which user made this post..
made_year varchar(4) 2003 Year of vehicle manafacturer.
color varchar(128) Colour of vehicle.
mileage int(10) unsigned 0
mileage_units varchar(32) Miles
price int(10) unsigned
currency varchar(32) USD
comments varchar(255)
image_id int(10) unsigned
views int(10) unsigned 0
date_created int(10) unsigned
date_updated int(10)
make_id int(10) unsigned 0
model_id int(10) unsigned 0
guestbook_pm_notify tinyint(1) 0
main_vehicle tinyint(1) 0
Table relationships
Forum containing the Post phpbb_forums.forum_id = phpbb_posts.forum_id
Legend Notes: [Primary Key] [Foreign Key or other Indexed Field(s)]
phpbb_garage_business
Contains vehicle data
Column Name Datatype Default Column Description
id int(10) unsigned
auto_increment System assigned primary key, no user interaction required.
title varchar(255) System assigned primary key, no user interaction required.
address varchar(255) System assigned primary key, no user interaction required.
telephone varchar(32) System assigned primary key, no user interaction required.
fax varchar(32) System assigned primary key, no user interaction required.
website varchar(255) System assigned primary key, no user interaction required.
email varchar(32) System assigned primary key, no user interaction required.
opening_hours varchar(255) System assigned primary key, no user interaction required.
insurance tinyint(1) 0 System assigned primary key, no user interaction required.
retail_shop tinyint(1) 0 System assigned primary key, no user interaction required.
web_shop tinyint(1) 0 System assigned primary key, no user interaction required.
garage tinyint(1) 0 System assigned primary key, no user interaction required.
pending tinyint(1) 0 System assigned primary key, no user interaction required.
comments text System assigned primary key, no user interaction required.
Table relationships
Forum containing the Post phpbb_forums.forum_id = phpbb_posts.forum_id
Legend Notes: [Primary Key] [Foreign Key or other Indexed Field(s)]
phpbb_garage_categories
Contains vehicle data
Column Name Datatype Default Column Description
id int(10) unsigned
auto_increment System assigned primary key, no user interaction required.
title varchar(255) System assigned primary key, no user interaction required.
image_id int(10) unsigned System assigned primary key, no user interaction required.
field_order tinyint(4) unsigned 0 System assigned primary key, no user interaction required.
Table relationships
Forum containing the Post phpbb_forums.forum_id = phpbb_posts.forum_id
Legend Notes: [Primary Key] [Foreign Key or other Indexed Field(s)]
phpbb_garage_config
Contains vehicle data
Column Name Datatype Default Column Description
config_name varchar(255) System assigned primary key, no user interaction required.
config_value varchar(255 System assigned primary key, no user interaction required.
Table relationships
No joins for this table N/A
Legend Notes: [Primary Key] [Foreign Key or other Indexed Field(s)]
phpbb_garage_gallery
Contains vehicle data
Column Name Datatype Default Column Description
id int(10) unsigned
auto_increment System assigned primary key, no user interaction required.
garage_id int(10) unsigned 0 System assigned primary key, no user interaction required.
image_id int(10) unsigned 0 System assigned primary key, no user interaction required.
Table relationships
Forum containing the Post phpbb_forums.forum_id = phpbb_posts.forum_id
Legend Notes: [Primary Key] [Foreign Key or other Indexed Field(s)]
phpbb_garage_guestbook
Contains vehicle data
Column Name Datatype Default Column Description
id int(10) unsigned
auto_increment System assigned primary key, no user interaction required.
garage_id int(10) unsigned System assigned primary key, no user interaction required.
author_id mediumint(8) System assigned primary key, no user interaction required.
post_date int(10) System assigned primary key, no user interaction required.
ip_address varchar(16) System assigned primary key, no user interaction required.
post text System assigned primary key, no user interaction required.
Table relationships
Forum containing the Post phpbb_forums.forum_id = phpbb_posts.forum_id
Legend Notes: [Primary Key] [Foreign Key or other Indexed Field(s)]
phpbb_garage_images
Contains vehicle data
Column Name Datatype Default Column Description
attach_id int(10) unsigned
auto_increment System assigned primary key, no user interaction required.
attach_location varchar(255) System assigned primary key, no user interaction required.
attach_hits int(10) unsigned 0 System assigned primary key, no user interaction required.
attach_ext varchar(10) System assigned primary key, no user interaction required.
attach_file varchar(255) System assigned primary key, no user interaction required.
attach_thumb_location varchar(128) System assigned primary key, no user interaction required.
attach_thumb_width smallint(5) 0 System assigned primary key, no user interaction required.
attach_thumb_height smallint(5) 0 System assigned primary key, no user interaction required.
attach_is_image tinyint(1) 0 System assigned primary key, no user interaction required.
attach_date int(10) 0 System assigned primary key, no user interaction required.
attach_filesize int(10) System assigned primary key, no user interaction required.
Table relationships
Forum containing the Post phpbb_forums.forum_id = phpbb_posts.forum_id
Legend Notes: [Primary Key] [Foreign Key or other Indexed Field(s)]
phpbb_garage_insurance
Contains vehicle data
Column Name Datatype Default Column Description
id int(10) auto_increment System assigned primary key, no user interaction required.
garage_id int(10) unsigned System assigned primary key, no user interaction required.
business_id int(10) unsigned System assigned primary key, no user interaction required.
premium int(10) unsigned System assigned primary key, no user interaction required.
cover_type varchar(255) System assigned primary key, no user interaction required.
comments text System assigned primary key, no user interaction required.
Table relationships
Forum containing the Post phpbb_forums.forum_id = phpbb_posts.forum_id
Legend Notes: [Primary Key] [Foreign Key or other Indexed Field(s)]
phpbb_garage_makes
Contains vehicle data
Column Name Datatype Default Column Description
id int(10) unsigned
auto_increment System assigned primary key, no user interaction required.
make varchar(255) System assigned primary key, no user interaction required.
pending tinyint(1) 1 System assigned primary key, no user interaction required.
Table relationships
Forum containing the Post phpbb_forums.forum_id = phpbb_posts.forum_id
Legend Notes: [Primary Key] [Foreign Key or other Indexed Field(s)]
phpbb_garage_models
Contains vehicle data
Column Name Datatype Default Column Description
id int(10) unsigned
auto_increment System assigned primary key, no user interaction required.
make_id int(10) unsigned 0 System assigned primary key, no user interaction required.
model varchar(255) System assigned primary key, no user interaction required.
pending tinyint(1) 1 System assigned primary key, no user interaction required.
Table relationships
Forum containing the Post phpbb_forums.forum_id = phpbb_posts.forum_id
Legend Notes: [Primary Key] [Foreign Key or other Indexed Field(s)]
phpbb_garage_mods
Contains vehicle data
Column Name Datatype Default Column Description
id int(10) unsigned
auto_increment System assigned primary key, no user interaction required.
garage_id int(10) unsigned 0 System assigned primary key, no user interaction required.
member_id int(10) 0 System assigned primary key, no user interaction required.
category_id int(10) unsigned 0 System assigned primary key, no user interaction required.
title varchar(255) System assigned primary key, no user interaction required.
price int(10) unsigned
auto_increment System assigned primary key, no user interaction required.
install_price int(10) unsigned System assigned primary key, no user interaction required.
product_rating tinyint(2) System assigned primary key, no user interaction required.
install_rating tinyint(2) System assigned primary key, no user interaction required.
business_id int(10) System assigned primary key, no user interaction required.
install_business_id int(10) System assigned primary key, no user interaction required.
comments text System assigned primary key, no user interaction required.
install_comments text System assigned primary key, no user interaction required.
image_id int(10) unsigned System assigned primary key, no user interaction required.
date_created int(10) System assigned primary key, no user interaction required.
date_updated int(10) System assigned primary key, no user interaction required.
Table relationships
Forum containing the Post phpbb_forums.forum_id = phpbb_posts.forum_id
Legend Notes: [Primary Key] [Foreign Key or other Indexed Field(s)]
phpbb_quartermile_mods
Contains vehicle data
Column Name Datatype Default Column Description
id int(10) unsigned
auto_increment System assigned primary key, no user interaction required.
garage_id int(10) unsigned System assigned primary key, no user interaction required.
rt decimal(6,3) System assigned primary key, no user interaction required.
sixty decimal(6,3) System assigned primary key, no user interaction required.
three decimal(6,3) System assigned primary key, no user interaction required.
eight decimal(6,3) System assigned primary key, no user interaction required.
eightmph decimal(6,3) System assigned primary key, no user interaction required.
thou decimal(6,3) System assigned primary key, no user interaction required.
quart decimal(6,3) System assigned primary key, no user interaction required.
quartmph decimal(6,3) System assigned primary key, no user interaction required.
pending tinyint(1) 1 System assigned primary key, no user interaction required.
image_id int(10) unsigned System assigned primary key, no user interaction required.
rr_id int(10) unsigned System assigned primary key, no user interaction required.
date_created int(10) System assigned primary key, no user interaction required.
date_updated int(10) System assigned primary key, no user interaction required.
Table relationships
Forum containing the Post phpbb_forums.forum_id = phpbb_posts.forum_id
Legend Notes: [Primary Key] [Foreign Key or other Indexed Field(s)]
phpbb_garage_rating
Contains vehicle data
Column Name Datatype Default Column Description
id int(10) auto_increment System assigned primary key, no user interaction required.
garage_id int(10) 0 System assigned primary key, no user interaction required.
rating int(10) 0 System assigned primary key, no user interaction required.
user_id int(10) 0 System assigned primary key, no user interaction required.
rate_date int(10) System assigned primary key, no user interaction required.
Table relationships
Forum containing the Post phpbb_forums.forum_id = phpbb_posts.forum_id
Legend Notes: [Primary Key] [Foreign Key or other Indexed Field(s)]
phpbb_garage_rollingroad
Contains vehicle data
Column Name Datatype Default Column Description
id int(10) unsigned
auto_increment System assigned primary key, no user interaction required.
garage_id int(10) unsigned System assigned primary key, no user interaction required.
bhp decimal(6,2) System assigned primary key, no user interaction required.
bhp_unit varchar(32) System assigned primary key, no user interaction required.
torque decimal(6,2) System assigned primary key, no user interaction required.
torque_unit varchar(32) System assigned primary key, no user interaction required.
boost decimal(6,2) System assigned primary key, no user interaction required.
boost_unit varchar(32) System assigned primary key, no user interaction required.
nitrous int(10) System assigned primary key, no user interaction required.
datacenter varchar(32) System assigned primary key, no user interaction required.
peakpoint decimal(7,3) System assigned primary key, no user interaction required.
image_id int(10) unsigned System assigned primary key, no user interaction required.
date_created int(10) System assigned primary key, no user interaction required.
date_updated int(10) System assigned primary key, no user interaction required.
pending tinyint(1) 1 System assigned primary key, no user interaction required.
Table relationships
Forum containing the Post phpbb_forums.forum_id = phpbb_posts.forum_id
Legend Notes: [Primary Key] [Foreign Key or other Indexed Field(s)]
^^
is the table..!!
--------------------------------------
[url=http://www.styleunion.co.uk/kerastase-nutritive-hair-care-m12.html]Kerastase Nutritive[/url]
[url=http://www.styleunion.co.uk/kerastase-resistance-m14.html]Kerastase Resistance[/url]