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_worldcup_Notice: Use characters a-z0-9 only. Only lowercase, no spaces.
This becomes the table name in the database. Title of the table: [English] [German] Fields Overview
Name
Title
Type
Exclude?
Details
name Name String input shortcut Shortcut String input
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 shortcut: Shortcut Descending "Type-field", if any: [none] name: Name shortcut: Shortcut (What is this?) Label-field: [none] name: Name shortcut: Shortcut (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: shortcut NEW FIELD: Load preset fields: __Fields picked up in this session__: worldcup-tables-1: Name (name, type: input) worldcup-tables-1: Shortcut (shortcut, type: input) worldcup-tables-2: Playtime (playtime, type: datetime) worldcup-tables-2: Team 1 (team1, type: rel) worldcup-tables-2: Place (place, type: input) worldcup-tables-2: Result (result, type: input) worldcup-tables-2: Result on regular playtime (result_regular_playplaytime, type: input) worldcup-tables-2: Winner (winner, type: radio) worldcup-tables-2: Group, Round (group_round, type: select) worldcup-tables-3: Game (game, type: rel) worldcup-tables-3: Goals Team 1 (goals_team1, type: input+) worldcup-tables-3: Goals Team 2 (goals_team2, type: input+) worldcup-tables-3: User (fe_user_id, type: rel) worldcup-tables-4: Playtime (playtime, type: datetime) worldcup-tables-4: Team 1 (team1, type: rel) worldcup-tables-4: Team 2 (team2, type: rel) worldcup-tables-4: Goals Team 1 (goals_team1, type: input+) worldcup-tables-4: Goals Team 2 (goals_team2, type: input+) worldcup-tables-4: Place (place, type: input) worldcup-tables-4: Group / Round (finals, type: radio)
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_worldcup_Notice: Use characters a-z0-9 only. Only lowercase, no spaces.
This becomes the table name in the database. Title of the table: [English] [German] Fields Overview
Name
Title
Type
Exclude?
Details
game Game Database relation tx_worldcup_games goals_team1 Goals Team 1 String input, advanced varchar goals_team2 Goals Team 2 String input, advanced varchar fe_user_id User 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] game: Game goals_team1: Goals Team 1 goals_team2: Goals Team 2 fe_user_id: User Descending "Type-field", if any: [none] game: Game goals_team1: Goals Team 1 goals_team2: Goals Team 2 fe_user_id: User (What is this?) Label-field: [none] game: Game goals_team1: Goals Team 1 goals_team2: Goals Team 2 fe_user_id: User (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: game
Field name: (Remove: )
Field title: [English] [German]
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) Extension table: Teams (tx_worldcup_teams) Extension table: Bets (tx_worldcup_bets) Extension table: Games (tx_worldcup_games) Type:Field with Element Browser Selectorbox, select global Selectorbox, select from current page Selectorbox, select from root page Selectorbox, select from storage page Add a blank item to the selector Max number of relations Size of selector box True M-M relations (otherwise commalist of values) Add "Add record" link Add "List records" link Add "Edit record" link
FIELD: goals_team1
Field name: (Remove: )
Field title: [English] [German]
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?) Field width (5-48 relative, 30 default) Max characters Required Create VARCHAR, not TINYTEXT field (if not forced INT) Apply checkbox Evaluate value to:Date (day-month-year) Time (hours, minutes) Time + seconds Date + Time Year Integer Integer 0-1000 Floating point, x.xx Alphanumeric only Upper case Lower case Strip space Is password field Unique in whole database Unique inside parent page Not unique (default) Add colorpicker wizard Add link wizard
FIELD: goals_team2
Field name: (Remove: )
Field title: [English] [German]
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?) Field width (5-48 relative, 30 default) Max characters Required Create VARCHAR, not TINYTEXT field (if not forced INT) Apply checkbox Evaluate value to:Date (day-month-year) Time (hours, minutes) Time + seconds Date + Time Year Integer Integer 0-1000 Floating point, x.xx Alphanumeric only Upper case Lower case Strip space Is password field Unique in whole database Unique inside parent page Not unique (default) Add colorpicker wizard Add link wizard
FIELD: fe_user_id
Field name: (Remove: )
Field title: [English] [German]
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) Extension table: Teams (tx_worldcup_teams) Extension table: Bets (tx_worldcup_bets) Extension table: Games (tx_worldcup_games) Type:Field with Element Browser Selectorbox, select global Selectorbox, select from current page Selectorbox, select from root page Selectorbox, select from storage page Add a blank item to the selector Max number of relations Size of selector box True M-M relations (otherwise commalist of values) Add "Add record" link Add "List records" link Add "Edit record" link
NEW FIELD: Load preset fields: __Fields picked up in this session__: worldcup-tables-1: Name (name, type: input) worldcup-tables-1: Shortcut (shortcut, type: input) worldcup-tables-2: Playtime (playtime, type: datetime) worldcup-tables-2: Team 1 (team1, type: rel) worldcup-tables-2: Place (place, type: input) worldcup-tables-2: Result (result, type: input) worldcup-tables-2: Result on regular playtime (result_regular_playplaytime, type: input) worldcup-tables-2: Winner (winner, type: radio) worldcup-tables-2: Group, Round (group_round, type: select) worldcup-tables-3: Game (game, type: rel) worldcup-tables-3: Goals Team 1 (goals_team1, type: input+) worldcup-tables-3: Goals Team 2 (goals_team2, type: input+) worldcup-tables-3: User (fe_user_id, type: rel) worldcup-tables-4: Playtime (playtime, type: datetime) worldcup-tables-4: Team 1 (team1, type: rel) worldcup-tables-4: Team 2 (team2, type: rel) worldcup-tables-4: Goals Team 1 (goals_team1, type: input+) worldcup-tables-4: Goals Team 2 (goals_team2, type: input+) worldcup-tables-4: Place (place, type: input) worldcup-tables-4: Group / Round (finals, type: radio)
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_worldcup_Notice: Use characters a-z0-9 only. Only lowercase, no spaces.
This becomes the table name in the database. Title of the table: [English] [German] Fields Overview
Name
Title
Type
Exclude?
Details
playtime Playtime Date and time team1 Team 1 Database relation tx_worldcup_teams team2 Team 2 Database relation tx_worldcup_teams goals_team1 Goals Team 1 String input, advanced varchar goals_team2 Goals Team 2 String input, advanced varchar place Place String input finals Group / Round Radio buttons 12 options
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] playtime: Playtime team1: Team 1 team2: Team 2 goals_team1: Goals Team 1 goals_team2: Goals Team 2 place: Place finals: Group / Round Descending "Type-field", if any: [none] playtime: Playtime team1: Team 1 team2: Team 2 goals_team1: Goals Team 1 goals_team2: Goals Team 2 place: Place finals: Group / Round (What is this?) Label-field: [none] playtime: Playtime team1: Team 1 team2: Team 2 goals_team1: Goals Team 1 goals_team2: Goals Team 2 place: Place finals: Group / Round (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: playtime FIELD: team1
Field name: (Remove: )
Field title: [English] [German]
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) Extension table: Teams (tx_worldcup_teams) Extension table: Bets (tx_worldcup_bets) Extension table: Games (tx_worldcup_games) Type:Field with Element Browser Selectorbox, select global Selectorbox, select from current page Selectorbox, select from root page Selectorbox, select from storage page Add a blank item to the selector Max number of relations Size of selector box True M-M relations (otherwise commalist of values) Add "Add record" link Add "List records" link Add "Edit record" link
FIELD: team2
Field name: (Remove: )
Field title: [English] [German]
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) Extension table: Teams (tx_worldcup_teams) Extension table: Bets (tx_worldcup_bets) Extension table: Games (tx_worldcup_games) Type:Field with Element Browser Selectorbox, select global Selectorbox, select from current page Selectorbox, select from root page Selectorbox, select from storage page Add a blank item to the selector Max number of relations Size of selector box True M-M relations (otherwise commalist of values) Add "Add record" link Add "List records" link Add "Edit record" link
FIELD: goals_team1
Field name: (Remove: )
Field title: [English] [German]
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?) Field width (5-48 relative, 30 default) Max characters Required Create VARCHAR, not TINYTEXT field (if not forced INT) Apply checkbox Evaluate value to:Date (day-month-year) Time (hours, minutes) Time + seconds Date + Time Year Integer Integer 0-1000 Floating point, x.xx Alphanumeric only Upper case Lower case Strip space Is password field Unique in whole database Unique inside parent page Not unique (default) Add colorpicker wizard Add link wizard
FIELD: goals_team2
Field name: (Remove: )
Field title: [English] [German]
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?) Field width (5-48 relative, 30 default) Max characters Required Create VARCHAR, not TINYTEXT field (if not forced INT) Apply checkbox Evaluate value to:Date (day-month-year) Time (hours, minutes) Time + seconds Date + Time Year Integer Integer 0-1000 Floating point, x.xx Alphanumeric only Upper case Lower case Strip space Is password field Unique in whole database Unique inside parent page Not unique (default) Add colorpicker wizard Add link wizard
FIELD: place FIELD: finals NEW FIELD: Load preset fields: __Fields picked up in this session__: worldcup-tables-1: Name (name, type: input) worldcup-tables-1: Shortcut (shortcut, type: input) worldcup-tables-2: Playtime (playtime, type: datetime) worldcup-tables-2: Team 1 (team1, type: rel) worldcup-tables-2: Place (place, type: input) worldcup-tables-2: Result (result, type: input) worldcup-tables-2: Result on regular playtime (result_regular_playplaytime, type: input) worldcup-tables-2: Winner (winner, type: radio) worldcup-tables-2: Group, Round (group_round, type: select) worldcup-tables-3: Game (game, type: rel) worldcup-tables-3: Goals Team 1 (goals_team1, type: input+) worldcup-tables-3: Goals Team 2 (goals_team2, type: input+) worldcup-tables-3: User (fe_user_id, type: rel) worldcup-tables-4: Playtime (playtime, type: datetime) worldcup-tables-4: Team 1 (team1, type: rel) worldcup-tables-4: Team 2 (team2, type: rel) worldcup-tables-4: Goals Team 1 (goals_team1, type: input+) worldcup-tables-4: Goals Team 2 (goals_team2, type: input+) worldcup-tables-4: Place (place, type: input) worldcup-tables-4: Group / Round (finals, type: radio)