
Новичок
Профиль
Группа: Участник
Сообщений: 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
|