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' } |