propel:
  _attributes:
    package: lib.model
    defaultIdMethod: native

### Do całego Portalu

  jezyk_tbl:
    _attributes: { phpName: JezykTbl }
    jezyk_kolejnosc: { type: INTEGER, size: '5', required: true, defaultValue: '0' }
    jezyk_id: { type: INTEGER, size: '11', primaryKey: true, autoIncrement: true, required: true }
    jezyk_skrot: { type: VARCHAR, size: '5', required: true, defaultValue: '' }
    jezyk_nazwa: { type: VARCHAR, size: '100', required: true, defaultValue: '' }
    jezyk_nazwa_en: { type: VARCHAR, size: '255', required: true, defaultValue: '' }
    _uniques: { jezyk_skrot: [jezyk_skrot], jezyk_nazwa_en: [jezyk_nazwa_en], jezyk_nazwa: [jezyk_nazwa], jezyk_kolejnosc: [jezyk_kolejnosc] }

  portal_tbl:
    _attributes: { phpName: PortalTbl }
    portal_id: { type: INTEGER, size: '11', primaryKey: true, required: true, defaultValue: '0' }
    portal_nazwa: { type: VARCHAR, size: '50', required: true, defaultValue: '' }
    grupa_id: { type: INTEGER, size: '11', required: true, defaultValue: '0' }

  tlumaczenie_system_tbl:
    _attributes: { phpName: TlumaczenieSystem }
    id: ~
    tresc: { type: INTEGER, size: '100', required: true, defaultValue: '0' }
    identyfikator: { type: INTEGER, size: '11', required: true, defaultValue: '0' }
    pole: { type: VARCHAR, size: '50', required: true, defaultValue: '' }
    jezyk_id: { type: INTEGER, size: '11', primaryKey: true, required: true, defaultValue: '0', foreignTable: jezyk_tbl, foreignReference: jezyk_id, onDelete: CASCADE, onUpdate: RESTRICT }
    _indexes: { jezyk_id: [jezyk_id] }

  tryb_modul:
    _attributes: { phpName: TrybModul }
    id: ~
    modul_id: { type: INTEGER, size: '11', required: true, defaultValue: '0', foreignTable: modul, foreignReference: id, onDelete: CASCADE, onUpdate: RESTRICT }
    tryb_id: { type: INTEGER, size: '11', required: true, defaultValue: '0', foreignTable: tryb_tbl, foreignReference: id, onDelete: CASCADE, onUpdate: RESTRICT }
    _indexes: { tryb_id: [tryb_id], modul_id: [modul_id] }

  tryb_tbl:
    _attributes: { phpName: Tryb }
    id: ~
    nazwa: { type: VARCHAR, size: '50', required: true, defaultValue: '' }

  ustawienie_tbl:
    _attributes: { phpName: Ustawienie }
    id: ~
    pole_id: { type: INTEGER, size: '11', required: true, defaultValue: '0', foreignTable: pole_tbl, foreignReference: id, onDelete: CASCADE, onUpdate: RESTRICT }
    uzytkownik_id: { type: INTEGER, size: '11', required: true, defaultValue: '0', foreignTable: sf_guard_user, foreignReference: id, onDelete: CASCADE, onUpdate: RESTRICT }
    _indexes: { pole_id: [pole_id], uzytkownik_id: [uzytkownik_id] }

  pole_tbl:
    _attributes: { phpName: Pole }
    id: ~
    tresc: { type: VARCHAR, size: '100', required: true, defaultValue: '' }
    jezyk_id: { type: INTEGER, size: '11', required: true, defaultValue: '0', foreignTable: jezyk_tbl, foreignReference: jezyk_id, onDelete: CASCADE, onUpdate: RESTRICT }
    _indexes: { jezyk_id: [jezyk_id] }

  komunikat_tbl:
    _attributes: { phpName: Komunikat }
    id: ~
    tresc: { type: VARCHAR, size: '200', required: true, defaultValue: '' }
    jezyk_id: { type: INTEGER, size: '11', required: true, defaultValue: '0', foreignTable: jezyk_tbl, foreignReference: jezyk_id, onDelete: CASCADE, onUpdate: RESTRICT }
    _indexes: { jezyk_id: [jezyk_id] }

  modul:
    _attributes: { phpName: Modul }
    id: ~
    short: { type: VARCHAR, size: '4', required: true,  defaultValue: '', index: unique }
    permissions: { type: TINYINT, size: '1', required: true, defaultValue: '1' }
    active: { type: TINYINT, size: '1', required: true, defaultValue: '1' }
    nazwa: { type: VARCHAR, size: '50', required: true, defaultValue: '' }

  pomoc_slownik_tbl:
    _attributes: { phpName: PomocSlownikTbl }
    pomoc_slownik_id: { type: BIGINT, size: '20', primaryKey: true, autoIncrement: true, required: true }
    pomoc_slownik_nazwa: { type: VARCHAR, size: '255', required: true, defaultValue: '' }
    pomoc_slownik_opis: { type: LONGVARCHAR, required: true }
    pomoc_slownik_tresc_pl: { type: LONGVARCHAR, required: true }
    pomoc_slownik_tresc_en: { type: LONGVARCHAR, required: true }
    _uniques: { pomoc_slownik_nazwa: [pomoc_slownik_nazwa] }

### Gelerie

  galeria_kategoria_tbl:
    _attributes: { phpName: GKategoria }
    id: ~
    nazwa: { type: VARCHAR, size: '100', required: true, defaultValue: '' }
    jezyk_id: { type: INTEGER, size: '11', required: true, defaultValue: '0', foreignTable: jezyk_tbl, foreignReference: jezyk_id, onDelete: CASCADE, onUpdate: RESTRICT }
    _indexes: { jezyk_id: [jezyk_id] }

  galeria_tbl:
    _attributes: { phpName: Galeria }
    id: ~
    zajawka: { type: VARCHAR, size: '250', required: true, defaultValue: '' }
    tytul: { type: VARCHAR, size: '200', required: true, defaultValue: '' }
    zdjecie: { type: VARCHAR, size: '100', required: true, defaultValue: '' }
    data_utworzenia: { type: DATE, required: true, defaultValue: '0000-00-00' }
    widoczna: { type: TINYINT, size: '1', required: true, defaultValue: '0' }
    dostepna: { type: TINYINT, size: '1', required: true, defaultValue: '0' }
    autor: { type: VARCHAR, size: '150', required: false, defaultValue: '' }
    uzytkownik_id: { type: INTEGER, size: '11', required: true, defaultValue: '0', foreignTable: sf_guard_user, foreignReference: id, onDelete: CASCADE, onUpdate: RESTRICT }
    kategoria_id: { type: INTEGER, size: '11', required: true, defaultValue: '0', foreignTable: galeria_kategoria_tbl, foreignReference: id, onDelete: CASCADE, onUpdate: RESTRICT }
    _indexes: { uzytkownik_id: [uzytkownik_id], kategoria_id: [kategoria_id] }

  obraz_opis_tbl:
    _attributes: { phpName: ObrazOpisTbl }
    id: ~
    tytul: { type: VARCHAR, size: '200', required: true, defaultValue: '' }
    opis: { type: VARCHAR, size: '250', required: true, defaultValue: '' }
    nadrzedny: { type: INTEGER, size: '11', required: true, defaultValue: '0' }
    autor: { type: INTEGER, size: '11', required: true, defaultValue: '0' }
    obraz_id: { type: INTEGER, size: '11', required: true, defaultValue: '0', foreignTable: obraz_tbl, foreignReference: id, onDelete: CASCADE, onUpdate: CASCADE }
    _indexes: { obraz_id: [obraz_id] }

  obraz_tbl:
    _attributes: { phpName: Obraz }
    id: ~
    nazwa_pliku: { type: VARCHAR, size: '100', required: true, defaultValue: '' }
    opis_pliku: { type: VARCHAR, size: '250', required: true, defaultValue: '' }
    nadrzedny: { type: INTEGER, size: '11', required: true, defaultValue: '0' }
    modyfikacja: { type: TIMESTAMP, required: true, defaultValue: CURRENT_TIMESTAMP }
    galeria_id: { type: INTEGER, size: '11', required: true, defaultValue: '0', foreignTable: galeria_tbl, foreignReference: id, onDelete: CASCADE, onUpdate: RESTRICT }
    _indexes: { galeria_id: [galeria_id] }

### Użytkownicy

  sf_guard_user_profile:
    _attributes: { phpName: sfGuardUserProfile }
    id: ~
    imie: { type: VARCHAR, size: '50', required: true, defaultValue: '' }
    nazwisko: { type: VARCHAR, size: '50', required: true, defaultValue: '' }
    email: { type: VARCHAR, size: '100', required: true, defaultValue: brak.brak@brak }
    miasto: { type: VARCHAR, size: '100', required: true, defaultValue: '' }
    ulica: { type: VARCHAR, size: '100', required: true, defaultValue: '' }
    kod_pocztowy: { type: VARCHAR, size: '6', required: true, defaultValue: 00-000 }
    nr_telefonu: { type: VARCHAR, size: '10', required: true, defaultValue: '' }
    user_id: { type: INTEGER, size: '11', required: true, defaultValue: '0', foreignTable: sf_guard_user, foreignReference: id, onDelete: RESTRICT, onUpdate: CASCADE }
    organizacja_id: { type: INTEGER, size: '11', required: false, defaultValue: '0', foreignTable: organizacja_tbl, foreignReference: id, onDelete: CASCADE, onUpdate: RESTRICT }
    funkcja_id: { type: INTEGER, size: '11', required: false, defaultValue: '0', foreignTable: funkcja_tbl, foreignReference: id, onDelete: CASCADE, onUpdate: RESTRICT }
    _indexes: { funkcja_id: [funkcja_id], organizacja_id: [organizacja_id] }

# Do rozbudowy

  organizacja_tbl:
    _attributes: { phpName: Organizacja }
    id: ~
    nazwa: { type: VARCHAR, size: '50', required: true, defaultValue: '' }

  dostep_tbl:
    _attributes: { phpName: Dostep }
    id: ~
    ip: { type: VARCHAR, size: '15', required: true, defaultValue: 000.000.000.000 }
    dopusc: { type: SMALLINT, size: '1', required: true, defaultValue: '1' }

  funkcja_tbl:
    _attributes: { phpName: Funkcja }
    id: ~
    nazwa: { type: VARCHAR, size: '50', required: true, defaultValue: '' }

# Strona CMS

  strona_kategoria_tbl:
    _attributes: { phpName: StronaKategoriaTbl }
    strona_kategoria_id: { type: INTEGER, size: '11', primaryKey: true, autoIncrement: true, required: true }
    strona_kategoria_nazwa: { type: VARCHAR, size: '255', required: true, defaultValue: '' }
    strona_kategoria_nadrzedna: { type: INTEGER, size: '10', required: false }
    strona_kategoria_ukryta: { type: TINYINT, size: '1', required: true, defaultValue: '0' }
    strona_kategoria_menu: { type: TINYINT, size: '1', required: true, defaultValue: '0' }
    strona_kategoria_tresc: { type: LONGVARCHAR, required: false }
    strona_kategoria_pokazuj_tresc: { type: TINYINT, size: '1', required: true, defaultValue: '1' }
    strona_kategoria_pokazuj_strony: { type: TINYINT, size: '1', required: true, defaultValue: '1' }
    strona_kategoria_strona_id: { type: INTEGER, size: '10', required: false }
    strona_kategoria_uzytkownik_id: { type: INTEGER, size: '11', required: true, defaultValue: '0' }
    strona_kategoria_data_dodania: { type: TIMESTAMP, required: true, defaultValue: '0000-00-00 00:00:00' }
    strona_kategoria_data_modyfikacji: { type: TIMESTAMP, required: true, defaultValue: '0000-00-00 00:00:00' }
    strona_kategoria_zatwierdzona: { type: TINYINT, size: '1', required: true, defaultValue: '0' }

  strona_kategoria_tbl_arch:
    _attributes: { phpName: StronaKategoriaTblArch }
    strona_kategoria_id: { type: INTEGER, size: '11', primaryKey: true, autoIncrement: true, required: true }
    strona_kategoria_usunieta_id: { type: INTEGER, size: '11', required: false }
    strona_kategoria_nazwa: { type: VARCHAR, size: '255', required: true, defaultValue: '' }
    strona_kategoria_nadrzedna: { type: INTEGER, size: '10', required: true, defaultValue: '0' }
    strona_kategoria_ukryta: { type: TINYINT, size: '1', required: true, defaultValue: '0' }
    strona_kategoria_menu: { type: TINYINT, size: '1', required: true, defaultValue: '0' }
    strona_kategoria_tresc: { type: LONGVARCHAR, required: false }
    strona_kategoria_pokazuj_tresc: { type: TINYINT, size: '1', required: true, defaultValue: '1' }
    strona_kategoria_pokazuj_strony: { type: TINYINT, size: '1', required: true, defaultValue: '1' }
    strona_kategoria_strona_id: { type: INTEGER, size: '10', required: false }
    strona_kategoria_uzytkownik_id: { type: INTEGER, size: '11', required: true, defaultValue: '0' }
    strona_kategoria_data_dodania: { type: TIMESTAMP, required: true, defaultValue: CURRENT_TIMESTAMP }
    strona_kategoria_data_modyfikacji: { type: TIMESTAMP, required: true, defaultValue: '0000-00-00 00:00:00' }
    strona_kategoria_zatwierdzona: { type: TINYINT, size: '1', required: true, defaultValue: '0' }

  strona_stopka_tbl:
    _attributes: { phpName: StronaStopkaTbl }
    strona_stopka_id: { type: INTEGER, size: '11', primaryKey: true, autoIncrement: true, required: true }
    strona_stopka_tresc: { type: LONGVARCHAR, required: false }
    strona_stopka_strona_id: { type: INTEGER, size: '11', required: false }
    strona_stopka_strona_kategoria_id: { type: INTEGER, size: '11', required: false }

  strona_tbl:
    _attributes: { phpName: StronaTbl }
    strona_id: { type: INTEGER, size: '11', primaryKey: true, autoIncrement: true, required: true }
    strona_data_utworzenia: { type: TIMESTAMP, required: true, defaultValue: '0000-00-00 00:00:00' }
    strona_nadrzedna: { type: INTEGER, size: '11', required: true, defaultValue: '0' }
    strona_nazwa_nadrzednej: { type: VARCHAR, size: '255', required: true }
    strona_kolejnosc: { type: INTEGER, size: '11', required: true, defaultValue: '0' }
    strona_ostatnia_modyfikacja: { type: TIMESTAMP, required: true, defaultValue: CURRENT_TIMESTAMP }
    strona_ukryta: { type: TINYINT, size: '1', required: true, defaultValue: '0' }
    strona_menu: { type: TINYINT, size: '1', required: true, defaultValue: '1' }
    strona_promowana: { type: TINYINT, size: '1', required: true, defaultValue: '0' }
    strona_portal_id: { type: INTEGER, size: '11', required: true, defaultValue: '0' }
    _indexes: { strona_portal_id: [strona_portal_id] }

  strona_tbl_arch:
    _attributes: { phpName: StronaTblArch }
    strona_id: { type: INTEGER, size: '11', primaryKey: true, required: true }
    strona_usunieta_id: { type: INTEGER, size: '11', required: true }
    strona_data_utworzenia: { type: TIMESTAMP, required: true, defaultValue: '0000-00-00 00:00:00' }
    strona_nadrzedna: { type: INTEGER, size: '11', required: true, defaultValue: '0' }
    strona_kolejnosc: { type: INTEGER, size: '11', required: true, defaultValue: '0' }
    strona_ostatnia_modyfikacja: { type: TIMESTAMP, required: true, defaultValue: CURRENT_TIMESTAMP }
    strona_ukryta: { type: TINYINT, size: '1', required: true, defaultValue: '0' }
    strona_menu: { type: TINYINT, size: '1', required: true, defaultValue: '1' }
    strona_promowana: { type: TINYINT, size: '1', required: true, defaultValue: '0' }
    strona_portal_id: { type: INTEGER, size: '11', required: true, defaultValue: '0' }
    strona_kto_usunal: { type: VARCHAR, size: '255', required: true }
    strona_data_usuniecia: { type: TIMESTAMP, required: true, defaultValue: '0000-00-00 00:00:00' }
    _indexes: { strona_portal_id: [strona_portal_id] }

  strona_tresc_tbl:
    _attributes: { phpName: StronaTrescTbl }
    tresc_id: { type: INTEGER, size: '11', primaryKey: true, autoIncrement: true, required: true }
    tresc_publikowana: { type: TINYINT, size: '1', required: true, defaultValue: '1' }
    tresc_data_utworzenia: { type: TIMESTAMP, required: true, defaultValue: '0000-00-00 00:00:00' }
    tresc_wytworzyl: { type: VARCHAR, size: '255', required: false }
    tresc_zatwierdzil: { type: INTEGER, size: '11', required: false }
    tresc_ukryta: { type: TINYINT, size: '1', required: true, defaultValue: '0' }
    tresc_tytul: { type: VARCHAR, size: '255', required: true, defaultValue: '' }
    tresc_tekst: { type: CLOB, required: true }
    tresc_zajawka: { type: LONGVARCHAR, required: true }
    tresc_ukryj_zajawki_podstron: { type: TINYINT, size: '1', required: true, defaultValue: '0' }
    tresc_grafika_zajawki: { type: VARCHAR, size: '255', required: false }
    tresc_nazwa_pliku_zajawki: { type: VARCHAR, size: '255', required: false }
    tresc_opis_grafiki_zajawki: { type: LONGVARCHAR, required: false }
    tresc_meta_kluczowe: { type: VARCHAR, size: '255', required: true, defaultValue: '' }
    tresc_meta_tytul: { type: VARCHAR, size: '255', required: true, defaultValue: '' }
    tresc_meta_description: { type: VARCHAR, size: '255', required: true, defaultValue: '' }
    tresc_jezyk_id: { type: INTEGER, size: '11', required: true, defaultValue: '0', foreignTable: jezyk_tbl, foreignReference: jezyk_id, onDelete: RESTRICT, onUpdate: RESTRICT }
    tresc_strona_id: { type: INTEGER, size: '11', required: false, foreignTable: strona_tbl, foreignReference: strona_id }
    tresc_strona_kategoria_id: { type: INTEGER, size: '11', required: false }
    tresc_pokazuj_tresc: { type: TINYINT, size: '1', required: true, defaultValue: '1' }
    tresc_ostatnia_modyfikacja: { type: TIMESTAMP, required: true, defaultValue: CURRENT_TIMESTAMP }
    tresc_data_publikacji: { type: TIMESTAMP, required: true, defaultValue: '0000-00-00 00:00:00' }
    tresc_publikacja_od: { type: TIMESTAMP, required: false }
    tresc_publikacja_do: { type: TIMESTAMP, required: false }
    tresc_uzytkownik_id: { type: INTEGER, size: '11', required: true, defaultValue: '0' }
    tresc_zatwierdzona: { type: TINYINT, size: '1', required: true, defaultValue: '0' }
    tresc_menu: { type: TINYINT, size: '1', required: true, defaultValue: '1' }
    tresc_promowana: { type: TINYINT, size: '4', required: true, defaultValue: '0' }
    tresc_przekierowanie: { type: VARCHAR, size: '255', required: false }
    tresc_uwagi: { type: LONGVARCHAR, required: false }
    tresc_opis_zmian: { type: LONGVARCHAR, required: false }
    tresc_link_bezposredni: { type: VARCHAR, size: '255', required: false }
    tresc_dodatkowa_stopka: { type: LONGVARCHAR, required: false }
    _indexes: { tresc_jezyk_id: [tresc_jezyk_id], tresc_strona_id: [tresc_strona_id], tresc_strona_kategoria_id: [tresc_strona_kategoria_id] }

  strona_tresc_tbl_arch:
    _attributes: { phpName: StronaTrescTblArch }
    tresc_id: { type: INTEGER, size: '11', primaryKey: true, autoIncrement: true, required: true }
    tresc_publikowana: { type: TINYINT, size: '1', required: true, defaultValue: '1' }
    tresc_data_utworzenia: { type: TIMESTAMP, required: true, defaultValue: '0000-00-00 00:00:00' }
    tresc_wytworzyl: { type: VARCHAR, size: '255', required: false }
    tresc_zatwierdzil: { type: INTEGER, size: '11', required: false }
    tresc_ukryta: { type: TINYINT, size: '1', required: true, defaultValue: '0' }
    tresc_tytul: { type: VARCHAR, size: '255', required: true, defaultValue: '' }
    tresc_tekst: { type: CLOB, required: true }
    tresc_zajawka: { type: LONGVARCHAR, required: true }
    tresc_ukryj_zajawki_podstron: { type: TINYINT, size: '1', required: true, defaultValue: '0' }
    tresc_grafika_zajawki: { type: VARCHAR, size: '255', required: false }
    tresc_nazwa_pliku_zajawki: { type: VARCHAR, size: '255', required: false }
    tresc_opis_grafiki_zajawki: { type: LONGVARCHAR, required: false }
    tresc_meta_kluczowe: { type: VARCHAR, size: '255', required: true, defaultValue: '' }
    tresc_meta_tytul: { type: VARCHAR, size: '255', required: true, defaultValue: '' }
    tresc_meta_description: { type: VARCHAR, size: '255', required: true, defaultValue: '' }
    tresc_jezyk_id: { type: INTEGER, size: '11', required: true, defaultValue: '0' }
    tresc_strona_id: { type: INTEGER, size: '11', required: false, foreignTable: strona_tbl_arch, foreignReference: strona_id, onDelete: RESTRICT, onUpdate: RESTRICT }
    tresc_strona_usunieta_id: { type: INTEGER, size: '11', required: true }
    tresc_strona_kategoria_id: { type: INTEGER, size: '11', required: false }
    tresc_pokazuj_tresc: { type: TINYINT, size: '1', required: true, defaultValue: '1' }
    tresc_ostatnia_modyfikacja: { type: TIMESTAMP, required: true, defaultValue: CURRENT_TIMESTAMP }
    tresc_data_publikacji: { type: TIMESTAMP, required: true, defaultValue: '0000-00-00 00:00:00' }
    tresc_publikacja_od: { type: TIMESTAMP, required: false }
    tresc_publikacja_do: { type: TIMESTAMP, required: false }
    tresc_uzytkownik_id: { type: INTEGER, size: '11', required: true, defaultValue: '0' }
    tresc_zatwierdzona: { type: TINYINT, size: '1', required: true, defaultValue: '0' }
    tresc_menu: { type: TINYINT, size: '1', required: true, defaultValue: '1' }
    tresc_promowana: { type: TINYINT, size: '4', required: true, defaultValue: '0' }
    tresc_przekierowanie: { type: VARCHAR, size: '255', required: false }
    tresc_uwagi: { type: LONGVARCHAR, required: false }
    tresc_opis_zmian: { type: LONGVARCHAR, required: false }
    tresc_link_bezposredni: { type: VARCHAR, size: '255', required: false }
    tresc_dodatkowa_stopka: { type: LONGVARCHAR, required: false }
    _indexes: { tresc_jezyk_id: [tresc_jezyk_id], tresc_strona_id: [tresc_strona_id], tresc_strona_kategoria_id: [tresc_strona_kategoria_id] }

  strona_tresc_temp_tbl:
    _attributes: { phpName: StronaTrescTempTbl }
    tresc_id: { type: INTEGER, size: '11', primaryKey: true, autoIncrement: true, required: true }
    tresc_data_utworzenia: { type: TIMESTAMP, required: true, defaultValue: '0000-00-00 00:00:00' }
    tresc_wytworzyl: { type: VARCHAR, size: '255', required: false }
    tresc_zatwierdzil: { type: INTEGER, size: '11', required: false }
    tresc_ukryta: { type: TINYINT, size: '1', required: true, defaultValue: '0' }
    tresc_tytul: { type: VARCHAR, size: '255', required: true, defaultValue: '' }
    tresc_tekst: { type: CLOB, required: true }
    tresc_zajawka: { type: LONGVARCHAR, required: true }
    tresc_ukryj_zajawki_podstron: { type: TINYINT, size: '1', required: true, defaultValue: '0' }
    tresc_grafika_zajawki: { type: VARCHAR, size: '255', required: false }
    tresc_nazwa_pliku_zajawki: { type: VARCHAR, size: '255', required: false }
    tresc_opis_grafiki_zajawki: { type: LONGVARCHAR, required: false }
    tresc_meta_kluczowe: { type: VARCHAR, size: '255', required: true, defaultValue: '' }
    tresc_meta_tytul: { type: VARCHAR, size: '255', required: true, defaultValue: '' }
    tresc_meta_description: { type: VARCHAR, size: '255', required: true, defaultValue: '' }
    tresc_jezyk_id: { type: INTEGER, size: '11', required: true, defaultValue: '0', foreignTable: jezyk_tbl, foreignReference: jezyk_id, onDelete: RESTRICT, onUpdate: RESTRICT }
    tresc_strona_id: { type: INTEGER, size: '11', required: false, foreignTable: strona_tbl, foreignReference: strona_id, onDelete: CASCADE, onUpdate: RESTRICT }
    tresc_strona_kategoria_id: { type: INTEGER, size: '11', required: false }
    tresc_pokazuj_tresc: { type: TINYINT, size: '1', required: true, defaultValue: '1' }
    tresc_ostatnia_modyfikacja: { type: TIMESTAMP, required: true, defaultValue: CURRENT_TIMESTAMP }
    tresc_data_publikacji: { type: TIMESTAMP, required: true, defaultValue: '0000-00-00 00:00:00' }
    tresc_publikacja_od: { type: TIMESTAMP, required: false }
    tresc_publikacja_do: { type: TIMESTAMP, required: false }
    tresc_uzytkownik_id: { type: INTEGER, size: '11', required: true, defaultValue: '0' }
    tresc_zatwierdzona: { type: TINYINT, size: '1', required: true, defaultValue: '0' }
    tresc_w_publikacji: { type: TINYINT, size: '1', required: true, defaultValue: '0' }
    tresc_menu: { type: TINYINT, size: '1', required: true, defaultValue: '1' }
    tresc_promowana: { type: TINYINT, size: '4', required: true, defaultValue: '0' }
    tresc_przekierowanie: { type: VARCHAR, size: '255', required: false }
    tresc_uwagi: { type: LONGVARCHAR, required: false }
    tresc_opis_zmian: { type: LONGVARCHAR, required: false }
    tresc_link_bezposredni: { type: VARCHAR, size: '255', required: false }
    tresc_dodatkowa_stopka: { type: LONGVARCHAR, required: false }
    _indexes: { tresc_jezyk_id: [tresc_jezyk_id], tresc_strona_id: [tresc_strona_id], tresc_strona_kategoria_id: [tresc_strona_kategoria_id] }

  log_strona:
    _attributes: { phpName: LogStrona }
    id: ~
    id_strony: { type: INTEGER, size: '11', required: true, defaultValue: '0', foreignTable: strona_tbl, foreignReference: strona_id, onDelete: RESTRICT, onUpdate: CASCADE }
    id_tresc_temp: { type: INTEGER, size: '11', required: true, defaultValue: '0', foreignTable: strona_tresc_temp_id, foreignReference: id, onDelete: RESTRICT, onUpdate: CASCADE }
    id_tresc_arch: { type: INTEGER, size: '11', required: true, defaultValue: '0', foreignTable: strona_tresc_arch, foreignReference: id, onDelete: RESTRICT, onUpdate: CASCADE }
    operacja: { type: LONGVARCHAR, required: false }
    created_at: ~
    user_id: { type: INTEGER, size: '11', required: true, defaultValue: '0', foreignTable: sf_guard_user, foreignReference: id, onDelete: RESTRICT, onUpdate: CASCADE } 
    
    
### Logowanie

  log_messages:
    _attributes: { phpName: LogMessages }
    id: ~
    
### Statystyki

  stat_strona_tresc:
    _attributes: { phpName: StatStrona }
    id: ~
    id_strona:   { type: INTEGER, size: '11', required: true, foreignTable: strona_tbl, foreignReference: strona_id }
    id_jezyk:    { type: INTEGER, size: '11', required: true, foreignTable: jezyk_tbl, foreignReference: jezyk_id }
    rok:         { type: INTEGER, size: '4', required: true }
    miesiac:     { type: INTEGER, size: '2', required: true }
    wejsc:       { type: INTEGER, size: '255', required: false }

### Zalaczniki

  strona_tresc_zalacznik:
    _attributes: { phpName: STrescZalacznik }
    tresc_id: { type: integer, primaryKey: true, required: false, foreignTable: strona_tresc_tbl, foreignReference: tresc_id, onDelete: cascade }
    zalacznik_id: { type: integer, primaryKey: true, required: true, foreignTable: zalacznik, foreignReference: id, onDelete: cascade }
    
  strona_tresc_zalacznik_temp:
    _attributes: { phpName: STrescZalacznikTemp }
    tresc_temp_id: { type: integer, primaryKey: true, required: false, foreignTable: strona_tresc_temp_tbl, foreignReference: tresc_id, onDelete: cascade }
    zalacznik_id: { type: integer, primaryKey: true, required: true, foreignTable: zalacznik, foreignReference: id, onDelete: cascade }

  strona_tresc_zalacznik_arch:
    _attributes: { phpName: STrescZalacznikArch }
    tresc_arch_id: { type: integer, primaryKey: true, required: false, foreignTable: strona_tresc_tbl_arch, foreignReference: tresc_id, onDelete: cascade }
    zalacznik_id: { type: integer, primaryKey: true, required: true, foreignTable: zalacznik, foreignReference: id, onDelete: cascade }

  zalacznik_kategoria:
    _attributes: { phpName: ZKategoria }
    id: ~
    nazwa: { type: VARCHAR, size: '100', required: true, defaultValue: '' }
    opis: { type: VARCHAR, size: '250', required: true, defaultValue: '' }

  zalacznik:
    _attributes: { phpName: Zalacznik }
    id: ~
    sciezka: { type: VARCHAR, size: '255', required: true, defaultValue: '' }
    nazwa_pliku: { type: VARCHAR, size: '255', required: true, defaultValue: '' }
    rozmiar_pliku: { type: INTEGER, size: '255', required: true, defaultValue: '' }
    nazwa: { type: VARCHAR, size: '255', required: true, defaultValue: '' }
    opis: { type: LONGVARCHAR, required: false, defaultValue: '' }
    created_at: ~
    kategoria_id: { type: INTEGER, size: '11', required: false, defaultValue: '', foreignTable: zalacznik_kategoria, foreignReference: id }

# Aktualności

  aktualnosc_kategoria_tbl:
    _attributes: { phpName: AKategoria }
    id: ~
    nazwa: { type: VARCHAR, size: '100', required: true, defaultValue: '' }
    nazwa_pliku: { type: VARCHAR, size: '100', required: true, defaultValue: '' }
    nadrzedna: { type: INTEGER, size: '11', required: true, defaultValue: '0' }
    jezyk_id: { type: INTEGER, size: '11', required: true, defaultValue: '0', foreignTable: jezyk_tbl, foreignReference: jezyk_id, onDelete: CASCADE, onUpdate: RESTRICT }
    _indexes: { jezyk_id: [jezyk_id] }

  aktualnosc_tbl:
    _attributes: { phpName: Aktualnosc }
    id: ~
    newsletter: { type: TINYINT, size: '1', required: true, defaultValue: '0' }
    komentarz: { type: TINYINT, size: '1', required: true, defaultValue: '0' }
    kategoria_id: { type: INTEGER, size: '11', required: true, defaultValue: '0', foreignTable: aktualnosc_kategoria_tbl, foreignReference: id, onDelete: CASCADE, onUpdate: RESTRICT }
    uzytkownik_id: { type: INTEGER, size: '11', required: true, defaultValue: '0', foreignTable: sf_guard_user, foreignReference: id, onDelete: CASCADE, onUpdate: RESTRICT }
    jezyk_id: { type: INTEGER, size: '11', required: true, defaultValue: '0', foreignTable: jezyk_tbl, foreignReference: jezyk_id, onDelete: CASCADE, onUpdate: RESTRICT }
    _indexes: { kategoria_id: [kategoria_id], uzytkownik_id: [uzytkownik_id], jezyk_id: [jezyk_id] }