This forum is in READ-ONLY mode.
You can look around, but if you want to ask a new question, please use Stack Overflow.

No models generated from your databases

Discussion relating to version 1.3.x and 1.4.x

No models generated from your databases

by Harsh » Fri Sep 12, 2014 6:38 am

I'm a beginner with symfony, but when i would build the schema with the command

php symfony doctrine:build-schema

It return me this:

>> No models is generated

My database.yml file is below:

etaEmailSignups:
actAs: { Timestampable: ~ }
columns:
email: { type: string(96), unique: true }
has_beta: { type: boolean }
ref: { type: string(255) }
singup_date: { type: datetime }
ref_site: { type: string(255) }

BetaEmailRefs:
actAs: { Timestampable: ~ }
columns:
invitor_id: { type: int }
signup_id: { type: int }

User:
actAs: { Timestampable: ~ }
columns:
user_id: { type: string(255), notnull: true, unique: true }
email: { type: string(255), unique: true }
role: { type: string(20), notnull: true, unique: false }
password_hash: { type: string(255) }
facebook_userid: { type: string(255), unique: true }
fname: { type: string(100) }
lname: { type: string(100) }
dob: { type: date }
gender: { type: string(6) }
age_years: {type: integer }
address1: { type: string(200) }
address2: { type: string(200) }
city: { type: string(100) }
zip: { type: string(10) }
state: { type: string(50) }
country: { type: string(50) }
phone: { type: string(20) }
height: { type: string(10) }
band: { type: string(10) }
cup: { type: string(10) }
shape: { type: string(25) }
standard_size: { type: integer }
likes: { type: string(1000) }
groups: { type: string(1000) }
verified: { type: integer }
vertfication_string: { type: string(10) }
newsletter: { type: integer }
spam: { type: integer }
invalid_email: { type: integer }
balance: { type: decimal, notnull: true, default: 0 }
in_bag_alerts: { type: integer, notnull: true, default: 1 }
saved_design_email: { type: integer, notnull: true, default: 1 }
my_points_visitor_id: { type: string(100) }
welcome_email_sent: { type: boolean, notnull: true, default: 0 }
email_registered_at: { type: datetime }
tweetable_bio: { type: string(200) }
shop_name: { type: string(100) }
shop_url: { type: string(100), unique: true }
shop_image: { type: string(100) }

UserBag:
actAs: { Timestampable: ~ }
columns:
user_id: { type: integer, notnull: true }
product_id: { type: integer, notnull: true }
prerender_key: { type: string (255), notnull: true }
quantity: { type: integer, notnull: true }
size: { type: string(500), notnull: true }
type: { type: string(50), notnull: true, default: Product }
backurl: { type: string (500) }
delete_date: { type: date }
delete_reason: { type: string(50) }
image_id: { type: integer }
shop_product_id: { type: integer }
alerted: { type: integer, notnull: true, default: 0 }
alerted_1_hour: { type: integer, notnull: true, default: 0 }
discount_price: { type: decimal }
discount_reason: { type: string(100) }
disable_quantity: { type: boolean, default: false }
relations:
User: { local: user_id, foreign: id, foreignAlias: Bag, type: many, foreignType: one, onDelete: CASCADE }
Product: { local: product_id, foreign: id, foreignAlias: Bags, type: one, foreignType: one }
PreRender: { local: prerender_key, foreign: prerender_key, foreignAlias: Bags, type: one, foreignType: one}

UserSavedProducts:
actAs: { Timestampable: ~ }
columns:
user_id: { type: integer, notnull: true }
product_id: { type: integer, notnull: true }
prerender_key: { type: string (255), notnull: true }
user_sort_order: { type: integer, default: 1 }
delete_date: { type: date }
is_fave: { type: boolean, default: 0 }
is_un_fave: { type: boolean, default: 0 }
relations:
User: { local: user_id, foreign: id, foreignAlias: SavedProducts, type: many, foreignType: one }
Product: { local: product_id, foreign: id, foreignAlias: SavedProducts, type: one, foreignType: one }
ProductPreRender: { local: prerender_key, foreign: prerender_key, foreignAlias: SavedProducts, type: one, foreignType: one}

UserShopLog:
actAs: { Timestampable: ~ }
columns:
user_id: { type: integer, notnull: true }
user_authenticated: { type: boolean, notnull: true }
visited_id: { type: integer, notnull: true }

UserProductLog:
actAs: { Timestampable: ~ }
columns:
user_id: { type: integer, notnull: true }
product_id: { type: integer, notnull: true }
prerender_key: { type: string(255) }
relations:
User: { local: user_id, foreign: id, foreignAlias: Bag, type: one, foreignType: one }
Product: { local: product_id, foreign: id, foreignAlias: Bags, type: many, foreignType: one }
ProductPreRender: { local: prerender_key, foreign: prerender_key, foreignAlias: Bags, type: many, foreignType: one}

UserEmail:
actAs: { Timestampable: ~ }
columns:
email: { type: string(255), notnull: true }
type: { type: string(255) }
subject: { type: string(255) }
text: { type: string(9999999) }
opened: { type: boolean, default: false }
clicked: { type: boolean, default: false }
relations:
User: { local: email, foreign: email }

ProductType:
actAs: { Timestampable: ~ }
columns:
name: { type: string(255), notnull: true, unique: true }

Image:
actAs: { Timestampable: ~ }
columns:
directory_local: { type: string(255), notnull: true }
file_name: { type: string(255), notnull: true }
height: { type: integer, notnull: true }
width: { type: integer, notnull: true }
position_top: { type: integer, notnull: true, default: 0 }
position_left: { type: integer, notnull: true, default: 0 }
file_s3: { type: boolean, notnull: true, default: 0 }
canvas_file_name: { type: string(255) }
canvas_height: { type: integer, notnull: true, default: 0 }
canvas_width: { type: integer, notnull: true, default: 0 }
canvas_top: { type: integer, notnull: true, default: 0 }
canvas_left: { type: integer, notnull: true, default: 0 }
canvas_s3: { type: boolean, notnull: true, default: 0 }
thumbnail_file_name: { type: string(255) }
thumbnail_height: { type: integer, notnull: true, default: 0 }
thumbnail_width: { type: integer, notnull: true, default: 0 }
thumbnail_top: { type: integer, notnull: true, default: 0 }
thumbnail_left: { type: integer, notnull: true, default: 0 }
thumbnail_s3: { type: boolean, notnull: true, default: 0 }
thumbnail_2_file_name: { type: string(255) }
thumbnail_2_height: { type: integer, notnull: true, default: 0 }
thumbnail_2_width: { type: integer, notnull: true, default: 0 }
thumbnail_2_top: { type: integer, notnull: true, default: 0 }
thumbnail_2_left: { type: integer, notnull: true, default: 0 }
thumbnail_2_s3: { type: boolean, notnull: true, default: 0 }
thumbnail_3_file_name: { type: string(255) }
thumbnail_3_height: { type: integer, notnull: true, default: 0 }
thumbnail_3_width: { type: integer, notnull: true, default: 0 }
thumbnail_3_top: { type: integer, notnull: true, default: 0 }
thumbnail_3_left: { type: integer, notnull: true, default: 0 }
thumbnail_3_s3: { type: boolean, notnull: true, default: 0 }

Trims:
actAs: { Timestampable: ~ }
columns:
name: { type: string(255), notnull: true }
thumbnail_image_id: { type: integer, notnull: true }
SKU: { type: string(3) }
relations:
Image: { onDelete: CASCADE, local: thumbnail_image_id, foreign: id, alias: ThumbnailImage, foreignAlias: Color, foreignType: one }

Color:
actAs: { Timestampable: ~ }
columns:
color_name: { type: string(255), notnull: true }
fabric_name: { type: string(255), notnull: true }
thumbnail_image_id: { type: integer, notnull: true }
SKU: { type: string(10) }
FabricSKU: { type: string(10) }
Color_SEO_Title: { type: string(100) }
Color_SEO_Keywords: { type: string(250) }
Color_SEO_Description: { type: string(5000) }
Color_SEO_Spin_Text1: { type: string(5000) }
Color_SEO_Spin_Text2: { type: string(5000) }
Color_SEO_Spin_Text3: { type: string(5000) }
Color_SEO_Spin_Text4: { type: string(5000) }
Color_SEO_Spin_Text5: { type: string(5000) }
Fabric_SEO_Title: { type: string(100) }
Fabric_SEO_Keywords: { type: string(250) }
Fabric_SEO_Description: { type: string(5000) }
Fabric_SEO_Spin_Text1: { type: string(5000) }
Fabric_SEO_Spin_Text2: { type: string(5000) }
Fabric_SEO_Spin_Text3: { type: string(5000) }
Fabric_SEO_Spin_Text4: { type: string(5000) }
Fabric_SEO_Spin_Text5: { type: string(5000) }
is_active: { type: boolean, default: 1 }
relations:
Image: { onDelete: CASCADE, local: thumbnail_image_id, foreign: id, alias: ThumbnailImage, foreignAlias: Color, foreignType: one }

Product:
actAs: { Timestampable: ~ }
columns:
name: { type: string(255), notnull: true, unique: true }
product_type_id: { type: integer, notnull: true }
base_price: { type: decimal, notnull: true }
thumbnail_image_id: { type: integer}
more_image1_id: { type: integer}
more_image2_id: { type: integer}
is_active: { type: boolean, notnull: true, default: 0 }
tags: { type: string(1000), notnull: false }
description: { type: string(5000), notnull: true }
quick_view_description: { type: string(5000), notnull: true }
homepage_description: { type: string(500), notnull: true }
video: { type: string(255) }
SKU: { type: string(10) }
show_order: { type: integer, notnull: true, default: 1000 }
available_date: { type: date, notnull: true }
activate_date: { type: date, notnull: true }
deactivate_date: { type: date, notnull: true }
why_we_love_it_title: { type: string(20), default: 'WHY WE LOVE IT' }
why_we_love_it: { type: string(500) }
ml_silhouette_title: { type: string(50), default: 'THE SILHOUETTE' }
ml_silhouette_image_id: { type: integer }
ml_silhouette_description: { type: string(5000) }
size_chart_type: { type: string(10) }
sizing_description: { type: string(500) }
discount_amount: { type: decimal }
discount_type: { type: string(10) }
discount_start_date: { type: date }
discount_end_date: { type: date }
weight_lbs: { type: decimal }
weight_oz: { type: decimal }
ship_location_id: { type: integer }
ship_preset_id: { type: integer }
turn_around_days: { type: integer, notnull: true, default: 11 }
show_right_image: { type: boolean, notnull: true, default: false }
test_price: { type: integer }
relations:
ProductType: { onDelete: CASCADE, local: product_type_id, foreign: id, foreignAlias: Products, type: one, foreignType: one }
Image: { onDelete: CASCADE, local: thumbnail_image_id, foreign: id, alias: ThumbnailImage, foreignAlias: Product, type: one, foreignType: one}
Image: { onDelete: CASCADE, local: more_image1_id, foreign: id, alias: MoreImage1, foreignAlias: ProductM1, type: one, foreignType: one}
Image: { onDelete: CASCADE, local: more_image2_id, foreign: id, alias: MoreImage2, foreignAlias: ProductM2, type: one, foreignType: one}
Image: { onDelete: CASCADE, local: ml_silhouette_image_id, foreign: id, alias: SilhoutteImage, foreignAlias: ProductM2, type: one, foreignType: one}
ShippingLocation: { local: ship_location_id, foreign: id }
ShippingPreset: { local: ship_preset_id, foreign: id }

ShippingLocation:
actAs: { Timestampable: ~ }
columns:
name: { type: string(100), notnull: true, unique: true }
addr1: { type: string(200), notnull: true }
addr2: { type: string(200) }
city: { type: string(100), notnull: true }
state: { type: string(100), notnull: true }
country: { type: string(100), notnull: true }
zip: { type: string(15), notnull: true }
phone: { type: string(255) }

what is the wrong with this code?
Thanks
Harsh
Junior Member
 
Posts: 1
Joined: Fri Sep 12, 2014 6:15 am