page

Table

VERSIONlatest How to create a table

Table

NAME

Table - How to create a table

STEPS

  1. In the Extenso menu, go to Extenso - Databases - Tables list
  2. ADD a new table - insert at least these fieds:
    • Table name
    • Table label
    • Menu (where your table will be in the menu)
    • Engine - Choose : InnoDB Percona-XtraDB, Supports transactions, row-level locking, and foreign keys
  3. SAVE your table
  4. Clic on the Fields list
  5. ADD fields - fill your needs 
  6. SAVE your fields
  7. PUBLISH PARENT

Type of fields

Here is the minimum you need for each type of field:

  1. Text  
    • Field name
    • Field label
    • Display format: HTML edit
    • Database format: Text
    • You can choose a "ck toolbar"
  2. Text
    • Field name
    • Field label
    • Display format: Text
    • Database format: Variable character field
  3. Checkbox 
    • Field name
    • Field label
    • Display format: Checkbox
    • Database format: Enumeration
    • List of values for enum type - example : yes,no
  4. List of checkboxes from a table
    1. Field name
    2. Field label
    3. Display format: List of checkboxes from a table
    4. Database format: Variable character field
    5. Table name - example: sn_languages
    6. Name of field with value - example: lg
    7. Field name - example: lgname
    8. Option: sort by - example: lgname
    9. Option: select by - example: active = 'yes'
  5. Image
    • Field name
    • Field label
    • Display format : Image
    • Database format : Variable character field
  6. Pulldown menu from a list
    • Field name
    • Field label
    • Display format: Pulldown menu from a list
    • Database format: Variable character field
    • Add values - example: internal,external
    • Add options - example: Internal,External
  7. Pulldown menu from a table
    • Field name
    • Field label
    • Display format: Pulldown menu from a table
    • Database format: Integer
    • Table name - example: pages
    • Name of field with value - example: uid
    • Field name - example: title
    • Option: sort by - example: title_
    • Option: select by - example: active = 'yes'
  8. Radio from a list
    • Field name
    • Field label
    • Display format: Radio from a list
    • Database format: Variable character field
    • List of values for enum type - example: internal,external
    • Add values - example: internal,external
    • Add options - example: Internal,External
  9. Parent
    1. Field name
    2. Field label
    3. Display format : Parent
    4. Database format : Integerz
    5. Parent table - example : sn_widget_list
    6. Name of field to display in parent table - example : uid
    7. Name of field for value in parent table - example : uid
  10. Date
    • Field name
    • Field label
    • Display format : Date selection
    • Database format : Date
  11. Textarea
    • Field name
    • Field label
    • Display format : Textarea
    • Database format : Text

 

AUTHOR

Written by Pascale Dewingaerde, <pascale@sednove.com>

VERSION

1.0 2016-05-17 pascale@sednove.com