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_en
   • 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