New Database Tables Add database tables which can be edited inside the backend. These tables will be added to the global TCA array in TYPO3. Tablename: tx_hoicommunity_Notice: Use characters a-z0-9 only. Only lowercase, no spaces.
This becomes the table name in the database. Title of the table: [English] Fields Overview
Name
Title
Type
Exclude?
Details
fe_user_uid Reciever uid Database relation fe_users folder_uid Folder uid Database relation tx_hoicommunity_folders subject Subject String input body Body Text area read Read Checkbox, single
Edit Fields Add "Deleted" field (What is this?) Add "Hidden" flag (What is this?) Add "Starttime" (What is this?) Add "Endtime" (What is this?) Add "Access group" (What is this?) Enabled localization features (What is this?) Enable versioning (What is this?) Manual ordering of records (What is this?) If "Manual ordering" is not set, order the table by this field:[crdate] [cruser_id] [tstamp] fe_user_uid: Reciever uid folder_uid: Folder uid subject: Subject body: Body read: Read Descending "Type-field", if any: [none] fe_user_uid: Reciever uid folder_uid: Folder uid subject: Subject body: Body read: Read (What is this?) Label-field: [none] fe_user_uid: Reciever uid folder_uid: Folder uid subject: Subject body: Body read: Read (What is this?) Default (white) Black Gray Blue Green Red Yellow Purple Default icon (What is this?) Allowed on pages: Allow records from this table to be created on regular pages.Allowed in "Insert Records" field in content elements: Allow records from this table to be linked to by content elements.Add "Save and new" button in forms: Will add an additional save-button to forms by which you can save the item and instantly create the next.Notice on fieldnames: Don't use fieldnames from this list of reserved names/words:
uid, pid, endtime, starttime, sorting, fe_group, hidden, deleted, cruser_id, crdate, tstamp, data, table, field, key, desc FIELD: fe_user_uid
Field name: (Remove: )
Field title: [English]
Field type: String input String input, advanced Text area Text area with RTE Text area, No wrapping Checkbox, single Checkbox, 4 boxes in a row Checkbox, 10 boxes in two rows (max) Link Date Date and time Integer, 10-1000 Selectorbox Radio buttons Database relation Files Not editable, only displayed [Passthrough] Is Exclude-field (What is this?) Create relation to table:Pages table, (pages) Frontend Users, (fe_users) Frontend Usergroups, (fe_groups) Content elements, (tt_content) Custom table (enter name below) All tables allowed! Extension table: Messages (tx_hoicommunity_messages) Extension table: Folders (tx_hoicommunity_folders) Extension table: Buddylist (tx_hoicommunity_buddylist) Extension table: Emoticons (tx_hoicommunity_emoticons) Type:Field with Element Browser Selectorbox, select global Selectorbox, select from current page Selectorbox, select from root page Selectorbox, select from storage page Max number of relations Size of selector box True M-M relations (otherwise commalist of values)
FIELD: folder_uid
Field name: (Remove: )
Field title: [English]
Field type: String input String input, advanced Text area Text area with RTE Text area, No wrapping Checkbox, single Checkbox, 4 boxes in a row Checkbox, 10 boxes in two rows (max) Link Date Date and time Integer, 10-1000 Selectorbox Radio buttons Database relation Files Not editable, only displayed [Passthrough] Is Exclude-field (What is this?) Create relation to table:Pages table, (pages) Frontend Users, (fe_users) Frontend Usergroups, (fe_groups) Content elements, (tt_content) Custom table (enter name below) All tables allowed! Extension table: Messages (tx_hoicommunity_messages) Extension table: Folders (tx_hoicommunity_folders) Extension table: Buddylist (tx_hoicommunity_buddylist) Extension table: Emoticons (tx_hoicommunity_emoticons) Type:Field with Element Browser Selectorbox, select global Selectorbox, select from current page Selectorbox, select from root page Selectorbox, select from storage page Max number of relations Size of selector box True M-M relations (otherwise commalist of values)
FIELD: subject FIELD: body FIELD: read NEW FIELD: Load preset fields: __Fields picked up in this session__: cwt_community-tables-6: String to parse (string, type: input) cwt_community-tables-6: Icon (icon, type: files) cwt_community-tables-1: FE User UID (fe_users_uid, type: rel) cwt_community-tables-1: Subject (subject, type: input) cwt_community-tables-1: Body (body, type: textarea) cwt_community-tables-1: Message Status (status, type: select) hoicommunity-tables-1: Reciever uid (fe_user_uid, type: rel) hoicommunity-tables-1: Folder uid (folder_uid, type: rel) hoicommunity-tables-1: Subject (subject, type: input) hoicommunity-tables-1: Body (body, type: textarea) hoicommunity-tables-1: Read (read, type: check) hoicommunity-tables-2: Name (name, type: input) hoicommunity-tables-2: Is inbox? (is_inbox, type: check) hoicommunity-tables-3: Buddy uid (fe_user_uid, type: rel) hoicommunity-tables-4: String (string, type: input) hoicommunity-tables-4: File (file, type: files) hoicommunity-fields-1: Birthday (hoicommunity_birthday, type: date) hoicommunity-fields-1: Information (hoicommunity_information, type: textarea)
New Database Tables Add database tables which can be edited inside the backend. These tables will be added to the global TCA array in TYPO3. Tablename: tx_hoicommunity_Notice: Use characters a-z0-9 only. Only lowercase, no spaces.
This becomes the table name in the database. Title of the table: [English] Fields Overview
Name
Title
Type
Exclude?
Details
name Name String input is_inbox Is inbox? Checkbox, single
Edit Fields Add "Deleted" field (What is this?) Add "Hidden" flag (What is this?) Add "Starttime" (What is this?) Add "Endtime" (What is this?) Add "Access group" (What is this?) Enabled localization features (What is this?) Enable versioning (What is this?) Manual ordering of records (What is this?) If "Manual ordering" is not set, order the table by this field:[crdate] [cruser_id] [tstamp] name: Name is_inbox: Is inbox? Descending "Type-field", if any: [none] name: Name is_inbox: Is inbox? (What is this?) Label-field: [none] name: Name is_inbox: Is inbox? (What is this?) Default (white) Black Gray Blue Green Red Yellow Purple Default icon (What is this?) Allowed on pages: Allow records from this table to be created on regular pages.Allowed in "Insert Records" field in content elements: Allow records from this table to be linked to by content elements.Add "Save and new" button in forms: Will add an additional save-button to forms by which you can save the item and instantly create the next.Notice on fieldnames: Don't use fieldnames from this list of reserved names/words:
uid, pid, endtime, starttime, sorting, fe_group, hidden, deleted, cruser_id, crdate, tstamp, data, table, field, key, desc FIELD: name FIELD: is_inbox NEW FIELD: Load preset fields: __Fields picked up in this session__: cwt_community-tables-6: String to parse (string, type: input) cwt_community-tables-6: Icon (icon, type: files) cwt_community-tables-1: FE User UID (fe_users_uid, type: rel) cwt_community-tables-1: Subject (subject, type: input) cwt_community-tables-1: Body (body, type: textarea) cwt_community-tables-1: Message Status (status, type: select) hoicommunity-tables-1: Reciever uid (fe_user_uid, type: rel) hoicommunity-tables-1: Folder uid (folder_uid, type: rel) hoicommunity-tables-1: Subject (subject, type: input) hoicommunity-tables-1: Body (body, type: textarea) hoicommunity-tables-1: Read (read, type: check) hoicommunity-tables-2: Name (name, type: input) hoicommunity-tables-2: Is inbox? (is_inbox, type: check) hoicommunity-tables-3: Buddy uid (fe_user_uid, type: rel) hoicommunity-tables-4: String (string, type: input) hoicommunity-tables-4: File (file, type: files) hoicommunity-fields-1: Birthday (hoicommunity_birthday, type: date) hoicommunity-fields-1: Information (hoicommunity_information, type: textarea)
New Database Tables Add database tables which can be edited inside the backend. These tables will be added to the global TCA array in TYPO3. Tablename: tx_hoicommunity_Notice: Use characters a-z0-9 only. Only lowercase, no spaces.
This becomes the table name in the database. Title of the table: [English] Fields Overview
Name
Title
Type
Exclude?
Details
fe_user_uid Buddy uid Database relation fe_users
Edit Fields Add "Deleted" field (What is this?) Add "Hidden" flag (What is this?) Add "Starttime" (What is this?) Add "Endtime" (What is this?) Add "Access group" (What is this?) Enabled localization features (What is this?) Enable versioning (What is this?) Manual ordering of records (What is this?) If "Manual ordering" is not set, order the table by this field:[crdate] [cruser_id] [tstamp] fe_user_uid: Buddy uid Descending "Type-field", if any: [none] fe_user_uid: Buddy uid (What is this?) Label-field: [none] fe_user_uid: Buddy uid (What is this?) Default (white) Black Gray Blue Green Red Yellow Purple Default icon (What is this?) Allowed on pages: Allow records from this table to be created on regular pages.Allowed in "Insert Records" field in content elements: Allow records from this table to be linked to by content elements.Add "Save and new" button in forms: Will add an additional save-button to forms by which you can save the item and instantly create the next.Notice on fieldnames: Don't use fieldnames from this list of reserved names/words:
uid, pid, endtime, starttime, sorting, fe_group, hidden, deleted, cruser_id, crdate, tstamp, data, table, field, key, desc FIELD: fe_user_uid
Field name: (Remove: )
Field title: [English]
Field type: String input String input, advanced Text area Text area with RTE Text area, No wrapping Checkbox, single Checkbox, 4 boxes in a row Checkbox, 10 boxes in two rows (max) Link Date Date and time Integer, 10-1000 Selectorbox Radio buttons Database relation Files Not editable, only displayed [Passthrough] Is Exclude-field (What is this?) Create relation to table:Pages table, (pages) Frontend Users, (fe_users) Frontend Usergroups, (fe_groups) Content elements, (tt_content) Custom table (enter name below) All tables allowed! Extension table: Messages (tx_hoicommunity_messages) Extension table: Folders (tx_hoicommunity_folders) Extension table: Buddylist (tx_hoicommunity_buddylist) Extension table: Emoticons (tx_hoicommunity_emoticons) Type:Field with Element Browser Selectorbox, select global Selectorbox, select from current page Selectorbox, select from root page Selectorbox, select from storage page Max number of relations Size of selector box True M-M relations (otherwise commalist of values)
NEW FIELD: Load preset fields: __Fields picked up in this session__: cwt_community-tables-6: String to parse (string, type: input) cwt_community-tables-6: Icon (icon, type: files) cwt_community-tables-1: FE User UID (fe_users_uid, type: rel) cwt_community-tables-1: Subject (subject, type: input) cwt_community-tables-1: Body (body, type: textarea) cwt_community-tables-1: Message Status (status, type: select) hoicommunity-tables-1: Reciever uid (fe_user_uid, type: rel) hoicommunity-tables-1: Folder uid (folder_uid, type: rel) hoicommunity-tables-1: Subject (subject, type: input) hoicommunity-tables-1: Body (body, type: textarea) hoicommunity-tables-1: Read (read, type: check) hoicommunity-tables-2: Name (name, type: input) hoicommunity-tables-2: Is inbox? (is_inbox, type: check) hoicommunity-tables-3: Buddy uid (fe_user_uid, type: rel) hoicommunity-tables-4: String (string, type: input) hoicommunity-tables-4: File (file, type: files) hoicommunity-fields-1: Birthday (hoicommunity_birthday, type: date) hoicommunity-fields-1: Information (hoicommunity_information, type: textarea)
New Database Tables Add database tables which can be edited inside the backend. These tables will be added to the global TCA array in TYPO3. Tablename: tx_hoicommunity_Notice: Use characters a-z0-9 only. Only lowercase, no spaces.
This becomes the table name in the database. Title of the table: [English] Fields Overview
Name
Title
Type
Exclude?
Details
string String String input file File Files webimages, 1 files, 25 kB
Edit Fields Add "Deleted" field (What is this?) Add "Hidden" flag (What is this?) Add "Starttime" (What is this?) Add "Endtime" (What is this?) Add "Access group" (What is this?) Enabled localization features (What is this?) Enable versioning (What is this?) Manual ordering of records (What is this?) If "Manual ordering" is not set, order the table by this field:[crdate] [cruser_id] [tstamp] string: String file: File Descending "Type-field", if any: [none] string: String file: File (What is this?) Label-field: [none] string: String file: File (What is this?) Default (white) Black Gray Blue Green Red Yellow Purple Default icon (What is this?) Allowed on pages: Allow records from this table to be created on regular pages.Allowed in "Insert Records" field in content elements: Allow records from this table to be linked to by content elements.Add "Save and new" button in forms: Will add an additional save-button to forms by which you can save the item and instantly create the next.Notice on fieldnames: Don't use fieldnames from this list of reserved names/words:
uid, pid, endtime, starttime, sorting, fe_group, hidden, deleted, cruser_id, crdate, tstamp, data, table, field, key, desc FIELD: string FIELD: file
Field name: (Remove: )
Field title: [English]
Field type: String input String input, advanced Text area Text area with RTE Text area, No wrapping Checkbox, single Checkbox, 4 boxes in a row Checkbox, 10 boxes in two rows (max) Link Date Date and time Integer, 10-1000 Selectorbox Radio buttons Database relation Files Not editable, only displayed [Passthrough] Is Exclude-field (What is this?) Extensions:Imagefiles Web-imagefiles (gif,jpg,png) All files, except php/php3 extensions Max number of files Max filesize allowed (kb) Size of selector box Show thumbnails
NEW FIELD: Load preset fields: __Fields picked up in this session__: cwt_community-tables-6: String to parse (string, type: input) cwt_community-tables-6: Icon (icon, type: files) cwt_community-tables-1: FE User UID (fe_users_uid, type: rel) cwt_community-tables-1: Subject (subject, type: input) cwt_community-tables-1: Body (body, type: textarea) cwt_community-tables-1: Message Status (status, type: select) hoicommunity-tables-1: Reciever uid (fe_user_uid, type: rel) hoicommunity-tables-1: Folder uid (folder_uid, type: rel) hoicommunity-tables-1: Subject (subject, type: input) hoicommunity-tables-1: Body (body, type: textarea) hoicommunity-tables-1: Read (read, type: check) hoicommunity-tables-2: Name (name, type: input) hoicommunity-tables-2: Is inbox? (is_inbox, type: check) hoicommunity-tables-3: Buddy uid (fe_user_uid, type: rel) hoicommunity-tables-4: String (string, type: input) hoicommunity-tables-4: File (file, type: files) hoicommunity-fields-1: Birthday (hoicommunity_birthday, type: date) hoicommunity-fields-1: Information (hoicommunity_information, type: textarea)
Extend existing Tables Add custom fields to existing tables, such as the "pages", "tt_content", "fe_users" or "be_users" table. Which table: Content (tt_content) Frontend Users (fe_users) Frontend Groups (fe_groups) Backend Users (be_users) Backend Groups (be_groups) News (tt_news) Address (tt_address) Pages (pages) Filemount (sys_filemounts) Workspace (sys_workspace) Website Language (sys_language) Domain (sys_domain) Alternative Page Language (pages_language_overlay) Template (sys_template) Static templates (static_template) Internal note (sys_note) Modern Linklist Category (tx_ablinklist_category) Modern Linklist Link (tx_ablinklist_link) Territories (static_territories) Countries (static_countries) Country subdivisions (static_country_zones) Languages (static_languages) Currencies (static_currencies) News category (tt_news_cat) News comments (tx_ednewscomments_items) Rating (tt_rating) Poll (tx_quickpoll_poll) Static taxes (static_taxes) Chat Entry (tx_vjchat_entry) Chat Room (tx_vjchat_room) Chat Session (tx_vjchat_session) Acronym (tx_rtehtmlarea_acronym) User Group Alternative Language (fe_groups_language_overlay) Download (tx_nfdownloads_download) Message (tx_cwtcommunity_message) Buddylist (tx_cwtcommunity_buddylist) Buddylist Approval (tx_cwtcommunity_buddylist_approval) Guestbook (tx_cwtcommunity_guestbook) Guestbook Data (tx_cwtcommunity_guestbook_data) Icons (tx_cwtcommunity_icons) Messages (tx_hoicommunity_messages) Folders (tx_hoicommunity_folders) Buddylist (tx_hoicommunity_buddylist) Emoticons (tx_hoicommunity_emoticons) (What is this?) FIELD: hoicommunity_birthday FIELD: hoicommunity_information NEW FIELD: Load preset fields: __Fields picked up in this session__: cwt_community-tables-6: String to parse (string, type: input) cwt_community-tables-6: Icon (icon, type: files) cwt_community-tables-1: FE User UID (fe_users_uid, type: rel) cwt_community-tables-1: Subject (subject, type: input) cwt_community-tables-1: Body (body, type: textarea) cwt_community-tables-1: Message Status (status, type: select) hoicommunity-tables-1: Reciever uid (fe_user_uid, type: rel) hoicommunity-tables-1: Folder uid (folder_uid, type: rel) hoicommunity-tables-1: Subject (subject, type: input) hoicommunity-tables-1: Body (body, type: textarea) hoicommunity-tables-1: Read (read, type: check) hoicommunity-tables-2: Name (name, type: input) hoicommunity-tables-2: Is inbox? (is_inbox, type: check) hoicommunity-tables-3: Buddy uid (fe_user_uid, type: rel) hoicommunity-tables-4: String (string, type: input) hoicommunity-tables-4: File (file, type: files) hoicommunity-fields-1: Birthday (hoicommunity_birthday, type: date) hoicommunity-fields-1: Information (hoicommunity_information, type: textarea)