Новичок
Профиль
Группа: Участник
Сообщений: 25
Регистрация: 22.3.2007
Где: Moscow
Репутация: нет
Всего: нет
|
файл schema.yml | Код |
propel:
_attributes:
package: lib.model
defaultIdMethod: native
articles:
_attributes: { phpName: Articles }
articleid: { type: INTEGER, size: '6', primaryKey: true, autoIncrement: true, required: true }
title: { type: VARCHAR, size: '150', required: true, defaultValue: '' }
head: { type: VARCHAR, size: '60', required: true, defaultValue: '' }
latin_head: { type: VARCHAR, size: '60', required: false }
description: { type: VARCHAR, size: '255', required: true, defaultValue: '' }
keywords: { type: VARCHAR, size: '255', required: false }
folderid: { type: INTEGER, size: '6', required: true, defaultValue: '0' }
date: { type: DATE, required: true, defaultValue: '0000-00-00' }
rating: { type: DOUBLE, required: true, defaultValue: '0' }
tags: { type: LONGVARCHAR, required: false }
_indexes: { folderid: [folderid] }
comments_banned:
_attributes: { phpName: CommentsBanned }
ID: { type: INTEGER, size: '1', primaryKey: true, autoIncrement: true, required: true }
ip: { type: VARCHAR, size: '15', required: true, defaultValue: '' }
_uniques: { ip: [ip] }
comments_data:
_attributes: { phpName: CommentsData }
ID: { type: BIGINT, size: '3', primaryKey: true, autoIncrement: true, required: true }
time: { type: TIMESTAMP, required: true, defaultValue: '0000-00-00 00:00:00' }
href: { type: VARCHAR, size: '255', required: true, defaultValue: '' }
text: { type: LONGVARCHAR, required: true }
author: { type: VARCHAR, size: '150', required: true, defaultValue: '' }
email: { type: VARCHAR, size: '255', required: false }
dont_show_email: { type: CHAR, size: '1', required: false, defaultValue: '0' }
ip: { type: VARCHAR, size: '15', required: false }
_indexes: { time: [time, href], href: [href] }
comments_junk:
_attributes: { phpName: CommentsJunk }
ID: { type: BIGINT, size: '3', primaryKey: true, autoIncrement: true, required: true }
time: { type: TIMESTAMP, required: true, defaultValue: '0000-00-00 00:00:00' }
href: { type: VARCHAR, size: '255', required: true, defaultValue: '' }
text: { type: LONGVARCHAR, required: true }
author: { type: VARCHAR, size: '255', required: true, defaultValue: '' }
email: { type: VARCHAR, size: '255', required: false }
dont_show_email: { type: INTEGER, size: '11', required: false, defaultValue: '0' }
ip: { type: VARCHAR, size: '15', required: false }
_indexes: { time: [time, href], href: [href] }
comments_subscribes:
_attributes: { phpName: CommentsSubscribes }
ID: { type: BIGINT, size: '20', primaryKey: true, autoIncrement: true, required: true }
email: { type: VARCHAR, size: '255', required: true, defaultValue: '' }
href: { type: VARCHAR, size: '255', required: true, defaultValue: '' }
hash: { type: VARCHAR, size: '255', required: true, defaultValue: '' }
_indexes: { href: [href] }
config:
_attributes: { phpName: Config }
site: { type: VARCHAR, size: '255', required: false }
phone: { type: VARCHAR, size: '255', required: false }
phone2: { type: VARCHAR, size: '255', required: false }
phone3: { type: VARCHAR, size: '255', required: false }
from_mail: { type: VARCHAR, size: '255', required: false }
from_name: { type: VARCHAR, size: '255', required: false }
smtp_mode: { type: TINYINT, size: '1', required: false, defaultValue: '0' }
smtp_host: { type: VARCHAR, size: '255', required: false }
smtp_port: { type: INTEGER, size: '4', required: false }
smtp_username: { type: VARCHAR, size: '255', required: false }
exchange: { type: FLOAT, required: false, defaultValue: '0' }
id: { type: INTEGER, size: '11', primaryKey: true, autoIncrement: true, required: true }
config_tree:
_attributes: { phpName: ConfigTree }
folderid: { type: INTEGER, size: '6', primaryKey: true, autoIncrement: true, required: true }
name: { type: VARCHAR, size: '255', required: false }
url: { type: VARCHAR, size: '255', required: false }
hide: { type: CHAR, size: '1', required: true, defaultValue: '1' }
parent: { type: INTEGER, size: '6', required: false, defaultValue: '0' }
priority: { type: INTEGER, size: '6', required: false }
keywords:
_attributes: { phpName: Keywords }
wordid: { type: INTEGER, size: '10', primaryKey: true, autoIncrement: true, required: true }
word: { type: VARCHAR, size: '255', required: false }
main_page:
_attributes: { phpName: MainPage }
pageid: { type: INTEGER, size: '1', primaryKey: true, autoIncrement: true, required: true }
title: { type: VARCHAR, size: '150', required: true, defaultValue: '' }
head: { type: VARCHAR, size: '150', required: true, defaultValue: '' }
keywords: { type: VARCHAR, size: '255', required: false }
description: { type: VARCHAR, size: '255', required: false }
tags: { type: LONGVARCHAR, required: false }
news:
_attributes: { phpName: News }
newsid: { type: INTEGER, size: '6', primaryKey: true, autoIncrement: true, required: true }
folderid: { type: INTEGER, size: '6', required: true, defaultValue: '0' }
title: { type: VARCHAR, size: '150', required: true, defaultValue: '' }
ltitle: { type: VARCHAR, size: '150', required: true, defaultValue: '' }
head: { type: VARCHAR, size: '60', required: true, defaultValue: '' }
description: { type: VARCHAR, size: '255', required: true, defaultValue: '' }
keywords: { type: VARCHAR, size: '255', required: false }
date: { type: DATE, required: true, defaultValue: '0000-00-00' }
hide: { type: CHAR, size: '1', required: true, defaultValue: '0' }
rating: { type: DOUBLE, required: false, defaultValue: '0' }
tags: { type: LONGVARCHAR, required: false }
priority: { type: INTEGER, size: '6', required: false }
_indexes: { folderid: [folderid] }
pages:
_attributes: { phpName: Pages }
folderid: { type: INTEGER, size: '6', primaryKey: true, autoIncrement: true, required: true }
title: { type: VARCHAR, size: '150', required: false }
head: { type: VARCHAR, size: '150', required: false }
keywords: { type: VARCHAR, size: '255', required: false }
description: { type: VARCHAR, size: '255', required: false }
tags: { type: LONGVARCHAR, required: false }
pages_folders:
_attributes: { phpName: PagesFolders }
folderid: { type: INTEGER, size: '6', primaryKey: true, autoIncrement: true, required: true }
parent: { type: INTEGER, size: '6', required: false, defaultValue: '0' }
name: { type: CHAR, size: '60', required: false }
lname: { type: CHAR, size: '60', required: false }
sys: { type: CHAR, size: '60', required: false }
priority: { type: INTEGER, size: '6', required: false }
_indexes: { FK_pages_folders: [parent] }
pages_folders_description:
_attributes: { phpName: PagesFoldersDescription }
folderid: { type: INTEGER, size: '6', primaryKey: true, autoIncrement: true, required: true }
description: { type: VARCHAR, size: '255', required: false }
pages_folders_links:
_attributes: { phpName: PagesFoldersLinks }
folderid: { type: INTEGER, size: '6', primaryKey: true, autoIncrement: true, required: true }
link: { type: VARCHAR, size: '255', required: false }
phg_articles:
_attributes: { phpName: PhgArticles }
imageid: { type: INTEGER, size: '10', primaryKey: true, autoIncrement: true, required: true }
phgid: { type: INTEGER, size: '10', required: false }
priority: { type: INTEGER, size: '10', required: false }
title: { type: VARCHAR, size: '255', required: false }
description: { type: VARCHAR, size: '255', required: false }
_indexes: { phgid: [phgid] }
phg_news:
_attributes: { phpName: PhgNews }
imageid: { type: INTEGER, size: '10', primaryKey: true, autoIncrement: true, required: true }
phgid: { type: INTEGER, size: '10', required: false }
priority: { type: INTEGER, size: '10', required: false }
title: { type: VARCHAR, size: '255', required: false }
description: { type: VARCHAR, size: '255', required: false }
_indexes: { phgid: [phgid] }
phg_news2:
_attributes: { phpName: PhgNews2 }
imageid: { type: INTEGER, size: '10', primaryKey: true, autoIncrement: true, required: true }
phgid: { type: INTEGER, size: '10', required: false }
priority: { type: INTEGER, size: '10', required: false }
title: { type: VARCHAR, size: '255', required: false }
description: { type: VARCHAR, size: '255', required: false }
_indexes: { phgid: [phgid] }
phg_pages:
_attributes: { phpName: PhgPages }
imageid: { type: INTEGER, size: '10', primaryKey: true, autoIncrement: true, required: true }
phgid: { type: INTEGER, size: '10', required: false }
priority: { type: INTEGER, size: '10', required: false }
title: { type: VARCHAR, size: '255', required: false }
description: { type: VARCHAR, size: '255', required: false }
_indexes: { phgid: [phgid] }
phg_shop:
_attributes: { phpName: PhgShop }
imageid: { type: INTEGER, size: '10', primaryKey: true, autoIncrement: true, required: true }
phgid: { type: INTEGER, size: '10', required: false }
priority: { type: INTEGER, size: '10', required: false }
title: { type: VARCHAR, size: '255', required: false }
description: { type: VARCHAR, size: '255', required: false }
_indexes: { phgid: [phgid, imageid] }
shop_prdocut_options:
_attributes: { phpName: ShopPrdocutOptions }
optionsid: { type: INTEGER, size: '11', primaryKey: true, autoIncrement: true, required: true }
productid: { type: INTEGER, size: '11', required: true }
sizeid: { type: INTEGER, size: '11', required: true, defaultValue: '0' }
setid: { type: INTEGER, size: '11', required: true, defaultValue: '0' }
stock: { type: INTEGER, size: '11', required: true, defaultValue: '-1' }
_indexes: { FK_shop_prdocut_options: [productid], FK_shop_prdocut_options_sizes: [sizeid], FK_shop_prdocut_options_sets: [setid] }
shop_product_brands:
_attributes: { phpName: ShopProductBrands }
brandid: { type: INTEGER, size: '11', primaryKey: true, autoIncrement: true, required: true }
original_url: { type: VARCHAR, size: '255', required: false }
name: { type: VARCHAR, size: '150', required: false }
last_check: { type: TIMESTAMP, required: false }
shop_product_pages:
_attributes: { phpName: ShopProductPages }
productid: { type: INTEGER, size: '6', primaryKey: true, autoIncrement: true, required: true }
lname: { type: VARCHAR, size: '150', required: false }
title: { type: VARCHAR, size: '150', required: false }
head: { type: VARCHAR, size: '150', required: false }
keywords: { type: VARCHAR, size: '255', required: false }
description: { type: VARCHAR, size: '255', required: false }
shop_product_sets:
_attributes: { phpName: ShopProductSets }
setid: { type: INTEGER, size: '11', primaryKey: true, autoIncrement: true, required: true }
name: { type: VARCHAR, size: '150', required: true }
shop_product_sizes:
_attributes: { phpName: ShopProductSizes }
sizeid: { type: INTEGER, size: '11', primaryKey: true, autoIncrement: true, required: true }
size: { type: VARCHAR, size: '10', required: true }
shop_products:
_attributes: { phpName: ShopProducts }
productid: { type: INTEGER, size: '11', primaryKey: true, autoIncrement: true, required: true }
folderid: { type: INTEGER, size: '11', required: true, defaultValue: '0' }
brandid: { type: INTEGER, size: '11', required: true, defaultValue: '0' }
name: { type: VARCHAR, size: '255', required: true }
price: { type: DOUBLE, required: true, defaultValue: '0' }
new_price: { type: DOUBLE, required: false }
original_url: { type: VARCHAR, size: '255', required: false }
description: { type: VARCHAR, size: '255', required: false }
instok: { type: CHAR, size: '1', required: true, defaultValue: '0' }
article: { type: VARCHAR, size: '150', required: true }
weight: { type: FLOAT, required: true, defaultValue: '0' }
size: { type: INTEGER, size: '11', required: true, defaultValue: '0' }
sizetype: { type: INTEGER, size: '11', required: false, defaultValue: '0' }
priority: { type: INTEGER, size: '11', required: true, defaultValue: '0' }
stocklink: { type: VARCHAR, size: '255', required: false }
last_check: { type: TIMESTAMP, required: false }
_indexes: { brandid: [brandid], folderid: [folderid] }
_uniques: { original_url: [original_url] }
tags:
_attributes: { phpName: Tags }
tagid: { type: INTEGER, size: '10', primaryKey: true, autoIncrement: true, required: true }
tagname: { type: VARCHAR, size: '255', required: false }
templates:
_attributes: { phpName: Templates }
templateid: { type: INTEGER, size: '100', primaryKey: true, autoIncrement: true, required: true }
title: { type: VARCHAR, size: '150', required: false }
description: { type: VARCHAR, size: '255', required: false }
users:
_attributes: { phpName: Users }
userid: { type: INTEGER, size: '3', primaryKey: true, autoIncrement: true, required: true }
user: { type: VARCHAR, size: '50', required: true, defaultValue: '' }
pass: { type: VARCHAR, size: '32', required: true, defaultValue: '' }
level: { type: INTEGER, size: '3', required: true, defaultValue: '0' }
|
файл data/fixtures/005_pages_folders.yml | Код |
PageFolders:
root_folder:
name: root_folder
|
при попытке загрузить данные в базу $ php symfony propel:data-load выдаёт ошибку Call to undefined method BasePagesFolders::setByPosition |
php symfony propel:data-load, не могу загрузить начальные данные 
Загрузка ...
