Development

Changeset 4874

You must first sign up to be able to contribute.

Changeset 4874

Show
Ignore:
Timestamp:
08/14/07 11:53:54 (6 years ago)
Author:
francois
Message:

sfSimpleCMSPlugin: Fixed wrong handling of primary/foreign keys in schema

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • plugins/sfSimpleCMSPlugin/README

    r4872 r4874  
    274274=== Trunk === 
    275275 
     276 * francois: Fixed wrong handling of primary/foreign keys in schema 
    276277 * francois: Fixed wrong slot type label formatting 
    277278 * francois: Reduced the query count with smart (and complex) joins 

  • plugins/sfSimpleCMSPlugin/config/schema.yml

    r4859 r4874  
    66    tree_left:    { type: integer, required: true } 
    77    tree_right:   { type: integer, required: true } 
    8     tree_parent:  { type: integer, foreignTable: sf_simple_cms_page, foreignReference: id, required: false, onDelete: cascade, isPrimaryKey: true } 
     8    tree_parent:  { type: integer, foreignTable: sf_simple_cms_page, foreignReference: id, required: false, onDelete: cascade } 
    99    topic_id:     { type: integer } 
    1010    template:     varchar(100) 
    …… 
    1515  sf_simple_cms_slot: 
    1616    _attributes:  { phpName: sfSimpleCMSSlot, package: plugins.sfSimpleCMSPlugin.lib.model } 
    17     page_id:      { type: integer, foreignTable: sf_simple_cms_page, foreignReference: id, required: true, onDelete: cascade, isPrimaryKey: true } 
    18     culture:      { isCulture: true, type: varchar(7), required: true, isPrimaryKey: true } 
    19     name:         { type: varchar(100), required: true, isPrimaryKey: true } 
     17    page_id:      { type: integer, foreignTable: sf_simple_cms_page, foreignReference: id, required: true, onDelete: cascade, primaryKey: true } 
     18    culture:      { isCulture: true, type: varchar(7), required: true, primaryKey: true } 
     19    name:         { type: varchar(100), required: true, primaryKey: true } 
    2020    type:         { type: varchar(100), required: true, default: Text }         
    2121    value:        { type: longvarchar }