ich beschäftige mich seit ein paar Tagen mit dem Datenmodell von Contenido. Dabei habe ich gerade diese Übersicht angefertigt, die zeigt wie sich die Datenmodelle von version 4.5.3 und 4.4.4 unterscheiden.
Gilt auch für 4.6.
Es sind nur die Unterschiede in Tabellen und Spalten angezeigt, keine Unterschiede in "Beziehungen" (die in mysql eh nicht mit referentieller Integrität implementiert sind), Keys, Indizes...
Ich dachte das ist von Interesse für viele User. Die ja irgendwann auch upgraden swollen, und dann beim Setup/Upgrade genauer wissen möchten was mit der Datenbank passiert.
Knut
Code: Alles auswählen
*****************************************
** Comparison Legend
**
** [+-] object present only in model 4.5.3
** [-+] object present only in model 4.4.4
** [#] differences detected on attribute values
** [!] changes detected on columns
** [<-] object moved, position in model in the right pane
** [->] object moved, position in model in the left pane
**
*****************************************
Neue Tabellen
[+-]<Table Symbol> con_art_spec
[+-]<Table Symbol> con_chartable
[+-]<Table Symbol> con_communications
[+-]<Table Symbol> con_dbfs
[+-]<Table Symbol> con_frontendgroupmembers
[+-]<Table Symbol> con_frontendgroups
[+-]<Table Symbol> con_frontendpermissions
[+-]<Table Symbol> con_frontendusers
[+-]<Table Symbol> con_mod_history
[+-]<Table Symbol> con_mod_translations
[+-]<Table Symbol> con_news_groupmembers
[+-]<Table Symbol> con_news_groups
[+-]<Table Symbol> con_properties
[+-]<Table Symbol> con_system_prop
Unterschiede in den Spalten (Unterschiede in Indizes und Keys nicht berücksichtigt)
Bitte beachten: die Vergleiche sind NACHHER (4.5.3) : (VORHER) 4.4.4
Tables:
[!]<Table> con_area
Columns:
[+-]<Column> menuless
[!]<Table> con_art_lang
Columns:
[+-]<Column> artspec
[+-]<Column> published
[+-]<Column> publishedby
[+-]<Table> con_art_spec
Columns:
[+-]<Column> idartspec
[+-]<Column> client
[+-]<Column> lang
[+-]<Column> artspec
[+-]<Column> online
[+-]<Column> artspecdefault
[!]<Table> con_cat_lang
Columns:
[+-]<Column> startidartlang
[+-]<Column> urlname
[+-]<Table> con_chartable
Columns:
[+-]<Column> encoding
[+-]<Column> charid
[+-]<Column> normalized_char
[+-]<Table> con_communications
Columns:
[+-]<Column> idcommunication
[+-]<Column> idclient
[+-]<Column> comtype
[+-]<Column> subject
[+-]<Column> message
[+-]<Column> recipient
[+-]<Column> author
[+-]<Column> created
[+-]<Column> modifiedby
[+-]<Column> modified
[+-]<Table> con_dbfs
Columns:
[+-]<Column> iddbfs
[+-]<Column> idclient
[+-]<Column> dirname
[+-]<Column> filename
[+-]<Column> mimetype
[+-]<Column> size
[+-]<Column> content
[+-]<Column> created
[+-]<Column> author
[+-]<Column> modified
[+-]<Column> modifiedby
[+-]<Table> con_frontendgroupmembers
Columns:
[+-]<Column> idfrontendgroupmember
[+-]<Column> idfrontendgroup
[+-]<Column> idfrontenduser
[+-]<Table> con_frontendgroups
Columns:
[+-]<Column> idfrontendgroup
[+-]<Column> idclient
[+-]<Column> groupname
[+-]<Column> defaultgroup
[+-]<Table> con_frontendpermissions
Columns:
[+-]<Column> idfrontendpermission
[+-]<Column> idfrontendgroup
[+-]<Column> idlang
[+-]<Column> plugin
[+-]<Column> action
[+-]<Column> item
[+-]<Table> con_frontendusers
Columns:
[+-]<Column> idfrontenduser
[+-]<Column> idclient
[+-]<Column> username
[+-]<Column> password
[+-]<Column> active
[+-]<Column> author
[+-]<Column> created
[+-]<Column> modified
[+-]<Column> modifiedby
[!]<Table> con_lang
Columns:
[+-]<Column> direction
[!]<Table> con_meta_type
Columns:
[+-]<Column> fieldname
[!]<Table> con_mod
Columns:
[+-]<Column> type
[+-]<Table> con_mod_history
Columns:
[+-]<Column> idmodhistory
[+-]<Column> idmod
[+-]<Column> idclient
[+-]<Column> name
[+-]<Column> type
[+-]<Column> description
[+-]<Column> input
[+-]<Column> output
[+-]<Column> template
[+-]<Column> changedby
[+-]<Column> changed
[+-]<Table> con_mod_translations
Columns:
[+-]<Column> idmodtranslation
[+-]<Column> idmod
[+-]<Column> idlang
[+-]<Column> original
[+-]<Column> translation
[!]<Table> con_news
Columns:
[+-]<Column> welcome
[+-]<Column> modified
[+-]<Column> modifiedby
[+-]<Table> con_news_groupmembers
Columns:
[+-]<Column> idnewsgroupmember
[+-]<Column> idnewsgroup
[+-]<Column> idnewsrcp
[+-]<Table> con_news_groups
Columns:
[+-]<Column> idnewsgroup
[+-]<Column> idclient
[+-]<Column> idlang
[+-]<Column> groupname
[+-]<Column> defaultgroup
[!]<Table> con_news_rcp
Columns:
[+-]<Column> confirmeddate
[+-]<Column> modified
[+-]<Column> modifiedby
[!]<Table> con_phplib_auth_user_md5
Columns:
[#]<Column> perms
<Data Type> text : varchar(255)
[!]<Table> con_plugins
Columns:
[->]<Column> name
[+-]<Column> version
[+-]<Column> author
[+-]<Column> idinternal
[+-]<Column> url
[+-]<Column> status
[->]<Column> description
[+-]<Column> install
[+-]<Column> uninstall
[+-]<Column> date
[<-]<Column> name
[<-]<Column> description
[+-]<Table> con_properties
Columns:
[+-]<Column> idproperty
[+-]<Column> idclient
[+-]<Column> itemtype
[+-]<Column> itemid
[+-]<Column> type
[+-]<Column> name
[+-]<Column> value
[+-]<Column> author
[+-]<Column> created
[+-]<Column> modified
[+-]<Column> modifiedby
[!]<Table> con_stat
Columns:
[#]<Column> visitdate
<Data Type> varchar(14) : timestamp(19)
<Mandatory> FALSE : TRUE
[!]<Table> con_stat_archive
Columns:
[#]<Column> visitdate
<Data Type> varchar(14) : timestamp(19)
<Mandatory> FALSE : TRUE
[+-]<Table> con_system_prop
Columns:
[+-]<Column> idsystemprop
[+-]<Column> type
[+-]<Column> name
[+-]<Column> value
[!]<Table> con_template
Columns:
[#]<Column> created
<Data Type> varchar(14) : timestamp(19)
<Mandatory> FALSE : TRUE
[#]<Column> lastmodified
<Mandatory> FALSE : TRUE
[+-]<Column> defaulttemplate
[!]<Table> con_template_conf
Columns:
[#]<Column> created
<Data Type> varchar(14) : timestamp(19)
<Mandatory> FALSE : TRUE
[#]<Column> lastmodified
<Mandatory> FALSE : TRUE
[!]<Table> con_upl
Columns:
[+-]<Column> modifiedby