propel:
  rss_channels:
    _attributes:        { phpName: RssChannel }
    id:                 { type: integer, required: true, primaryKey: true, autoIncrement: true }
    url:                { type: longvarchar, required: true }
    title:              { type: longvarchar, required: true, default: 'N/A' }
    description:        { type: longvarchar, required: true, default: 'N/A' }
    is_active:          { type: boolean, required: true, default: false, index: true }
    created_at:         { type: timestamp, required: true }
    updated_at:         { type: timestamp, required: true }
    checked_at:         { type: timestamp, required: false }
  rss_items:
    _attributes:        { phpName: RssItem }
    id:                 { type: integer, required: true, primaryKey: true, autoIncrement: true }
    rss_channel_id:     { type: integer, required: true, foreignTable: rss_channels, foreignReference: id, onDelete: cascade; index: true }
    url:                { type: longvarchar, required: true }
    title:              { type: longvarchar, required: true }
    description:        { type: longvarchar, required: true }
    guid:               { type: varchar(255), required: true, index: unique }
    created_at:         { type: timestamp, required: true }
    updated_at:         { type: timestamp, required: true }
    published_at:       { type: timestamp, required: true, index: true }
  email_templates:
    _attributes:        { phpName: EmailTemplate }
    id:                 { type: integer, required: true, primaryKey: true, autoIncrement: true }
    subject:            { type: longvarchar, required: false }
    body:               { type: longvarchar, required: false }
    template_vars:      { type: longvarchar, required: false }
    description:        { type: longvarchar, required: true, default: '--' }
    created_at:         { type: timestamp, required: true }
    updated_at:         { type: timestamp, required: true }
    sender_name:        { type: varchar(255), required: true, default: 'Złoty Program Partnerski' }
    sender_email:       { type: varchar(255), required: true, default: 'zpp@zlotemysli.pl' }
    template_name:      { type: varchar(40), required: true, index: unique }
  orders:
    _attributes:        { phpName: Order }
    id:                 { type: integer, required: true, primaryKey: true, autoIncrement: true }
    date:               { type: timestamp, required: true }
    users_id:           { type: integer, required: true, default: -1 }
    state:              { type: integer, required: true, default: 0 }
    price:              { type: double, required: true, default: 0 }
    kod:                { type: varchar(255), required: false }
    miasto:             { type: varchar(255), required: false }
    adres:              { type: varchar(255), required: false }
    fnazwa:             { type: varchar(255), required: false }
    fkod:               { type: varchar(255), required: false }
    fmiasto:            { type: varchar(255), required: false }
    fadres:             { type: varchar(255), required: false }
    session_id:         { type: varchar(255), required: false }
    faktura:            { type: boolean, required: true, default: false }
    partner_id:         { type: integer, required: true, default: 0 }
    used_gp:            { type: integer, required: false }
    gp:                 { type: integer, required: true, default: 0 }
    discount:           { type: integer, required: true, default: 0 }
    wysylka_imie:       { type: varchar(255), required: false }
    wysylka_nazwisko:   { type: varchar(255), required: false }
    campaign:           { type: varchar(255), required: false }
    realized:           { type: timestamp, required: false }
    codes_id:           { type: integer, required: true, default: 0 }
  ordered_versions:
    _attributes:        { phpName: OrderItem }
    version_id:         { type: integer, required: true, primaryKey: true, foreignTable: versions, foreignReference: id, onDelete: restrict }
    orders_id:          { type: integer, required: true, primaryKey: true, foreignTable: orders, foreignReference: id, onDelete: restrict }
    token:              { type: varchar(255), required: true }
    price:              { type: double, required: true }
    quantity:           { type: integer, required: true, default: 1 }
    flags:              { type: integer, required: true, default: 0 }
    lastmodified:       { type: date, required: true }
  publications:
    _attributes:        { phpName: Publication }
    id:                 { type: integer, required: true, primaryKey: true, autoIncrement: true }
    user_id:            { type: integer, required: false, foreignTable: users, foreignReference: id }
    title:              { type: longvarchar, required: false }
    original:           { type: longvarchar, required: false }
    category_id:        { type: integer, required: false }  #FIXME
    added:              { type: timestamp, required: true }
    image:              { type: integer, required: false }
    description:        { type: longvarchar, required: false }
    author_id:          { type: integer, required: false, foreignTable: users, foreignReference: id }
    image3d:            { type: integer, required: false }
    metatitle:          { type: longvarchar, required: false }
    metadescription:    { type: longvarchar, required: false }
    metakeywords:       { type: longvarchar, required: false }
    subdomain:          { type: longvarchar, required: false }
    visible:            { type: integer, required: true, default: 2 }
    short:              { type: longvarchar, required: false }
    prepared:           { type: integer, required: true, default: 0 }
    last_modified:      { type: timestamp, required: true }
    index:              { type: longvarchar, required: false }
    id_ebook:           { type: integer, required: false }
    bonus:              { type: longvarchar, required: false }
    is_training:        { type: boolean, required: true, default: false }
  versions:
    _attributes:          { phpName: PublicationVersion }
    id:                   { type: integer, required: true, primaryKey: true, autoIncrement: true }
    publications_id:      { type: integer, required: true, foreignTable: publications, foreignReference: id, index: true }
    version:              { type: integer, required: true, default: 0 }
    files_id:             { type: integer, required: true }
    pages:                { type: integer, required: false }
    pub_date:             { type: date, required: false }
    isbn:                 { type: varchar(255), required: false }
    added:                { type: timestamp, required: true }
    price:                { type: double, required: true, default: 0 }
    nr:                   { type: varchar(255), required: false }
    isbn2:                { type: varchar(255), required: false }
    id_ebook:             { type: integer, required: false }
    date_start:           { type: timestamp, required: true }
    date_end:             { type: timestamp, required: false }
    minimalna_kwota:      { type: double, required: false }
    uciekajaca_cena_pocz: { type: double, required: false }
    uciekajaca_skok:      { type: double, required: false }
    cena_promocyjna:      { type: double, required: false }
    zp:                   { type: boolean, required: true, default: true }
    vat:                  { type: integer, required: true, default: 0 }
    lektor:               { type: varchar(255), required: false }
    preorder:             { type: boolean, required: true, default: false }
    inbonus:              { type: boolean, required: false }
    bonusamount:          { type: double, required: false }
  users:
    _attributes:          { phpName: User }
    id:                   { type: integer, required: true, primaryKey: true, autoIncrement: true }
    imie:                 { type: longvarchar, required: false }
    nazwisko:             { type: longvarchar, required: false }
    email:                { type: longvarchar, required: false }
    role:                 { type: integer, required: false }
    login:                { type: longvarchar, required: false }
    password:             { type: longvarchar, required: false }
    lastlogin:            { type: timestamp, required: false }
    created:              { type: timestamp, required: true }
    telefon:              { type: longvarchar, required: false }
    parent_id:            { type: integer, required: true, default: 0 }
    confirmed:            { type: boolean, required: true, default: true }
    id_author:            { type: integer, required: false }
    ebook_pass:           { type: longvarchar, required: false }
    gp:                   { type: integer, required: true, default: 0 }
    discount:             { type: integer, required: true, default: 0 }
    id_partner:           { type: integer, required: true, default: 0 }
    description:          { type: longvarchar, required: false }
    approved_by_author:   { type: timestamp, required: false }
    credentials:          { type: integer, required: true, default: 0 }
  generated_pp_ebooks:
    _attributes:          { phpName: GeneratedPpEbook }
    id:                   { type: integer, required: true, primaryKey: true, autoIncrement: true }
    partner_id:           { type: integer, required: true, index: true }
    status:               { type: smallint, required: true, default: 0 }
    token:                { type: varchar(32), required: false, index: unique }
    generated_at:         { type: timestamp, required: false }
    downloaded_at:        { type: timestamp, required: false }
    created_at:           { type: timestamp, required: true }
    updated_at:           { type: timestamp, required: true }
    file_id:              { type: integer, required: true, index: true }
    publication_id:       { type: integer, required: true, index: true, foreignTable: publications, foreignReference: id }
  static_pages:
    _attributes:        { phpName: StaticPage }
    id:                 { type: integer, required: true, primaryKey: true, autoIncrement: true }
    name:               { type: varchar(255), required: true }
    permalink:          { type: varchar(255), required: true; index: unique }
    body:               { type: longvarchar, required: false }
    body_vars:          { type: longvarchar, required: false }
    created_at:         { type: timestamp, required: true }
    updated_at:         { type: timestamp, required: true }
    description:        { type: longvarchar, required: false }
    is_private:         { type: boolean, required: true, default: false }
    is_internal:        { type: boolean, required: true, default: false }
  stats_records_temporary:
    _attributes:        { phpName: StatsRecordTemporary }
    owner_id:           { type: integer, required: false }
    target_id:          { type: integer, required: false }
    object:             { type: integer, required: false }
    action:             { type: integer, required: false }
    created_at:         { type: timestamp, required: false }
    campaign:           { type: varchar(100), required: false }
    subdomain:          { type: varchar(100), required: false }
    user_hash:          { type: varchar(32), required: false }
  stats_records_users:
    _attributes:        { phpName: StatsRecordUser }
    id:                 { type: integer, required: true, primaryKey: true, autoIncrement: true }
    owner_id:           { type: integer, required: true }
    created_at:         { type: timestamp, required: true }
    user_hash:          { type: varchar(32), required: true }
  stats_records_campaigns:
    _attributes:        { phpName: StatsRecordCampaign }
    id:                 { type: integer, required: true, primaryKey: true, autoIncrement: true }
    owner_id:           { type: integer, required: false }
    created_at:         { type: timestamp, required: true }
    campaign:           { type: varchar(50), required: true }
  stats_records_subdomains:
    _attributes:        { phpName: StatsRecordSubdomain }
    id:                 { type: integer, required: true, primaryKey: true, autoIncrement: true }
    created_at:         { type: timestamp, required: true }
    subdomain:          { type: varchar(50), required: true }
  stats_records:
    _attributes:          { phpName: StatsRecord }
    id:                   { type: integer, required: true, primaryKey: true, autoIncrement: true }
    owner_id:             { type: integer, required: true }
    created_at:           { type: timestamp, required: true }
    target_id:            { type: integer, required: true }
    object:               { type: integer, required: true }
    action:               { type: integer, required: true }
    stats_user_id:        { type: integer, required: true, index: true, foreignTable: stats_records_users, foreignReference: id }
    stats_campaign_id:    { type: integer, required: false, index: true, foreignTable: stats_records_campaigns, foreignReference: id }
    stats_subdomain_id:   { type: integer, required: true, index: true, foreignTable: stats_records_subdomains, foreignReference: id }
    stats_campaign_name:  { type: varchar(50), required: true }
    stats_subdomain_name: { type: varchar(50), required: true }
    stats_target_details: { type: varchar(255), required: true }
  stats_records_process:
    _attributes:          { phpName: StatsRecordProcess }
    id:                   { type: integer, required: true, primaryKey: true, autoIncrement: true }
    created_at:           { type: timestamp, required: true }
    updated_at:           { type: timestamp, required: true }
    records_processed:    { type: integer, required: true, default: 0 }
    status:               { type: integer, required: true, default: 1 }