• FAI Family number (text): (1..23, A..M). Categories of maneuvers.
• Sub-ID (integer): 1..44. Variations of a particular category of maneuver. Family number, dot, Sub-ID = “1.1” .. “M.10” = unique identifier for one maneuver.
• Family Name: base figure (Loop .. Humpty bump from top).
• FAI text: Script for calling card. Natural language from the FAI/F3A rulebook.
• SVG for the maneuver drawing?
• Entrance height: high, middle, low? Exit height of one maneuver must match entrance height of the next. Need help from experienced people!
• Exit height: high, middle, low?
• Enter inverted (boolean): yes or no.
• Exit inverted (boolean): yes or no.
• K-Factor: an integer that indicates degree of difficulty.
• enterY, exitY: where the S-curve between maneuvers enters this drawing and where the next S-curve exits from this drawing.

Plain text, tab-delimited.

• Create the table.

$sql = "CREATE TABLE `joomla`.`jos_beppo_maneuvers` (`fai_family_num` VARCHAR(4) NOT NULL, `sub_id` TINYINT NOT NULL, `family_name` VARCHAR(64) NOT NULL, `fai_text` TEXT NOT NULL, `parsed` TEXT NOT NULL, `entrance_height` TEXT NOT NULL, `exit_height` TEXT NOT NULL, `entrance_attitude` TEXT NOT NULL, `exit_attitude` TEXT NOT NULL, `Kfactor` TINYINT NOT NULL, `enterY` TINYINT NOT NULL, `exitY` TINYINT NOT NULL) ENGINE = InnoDB;";

• Load all the maneuvers into it.

$sql = "INSERT INTO `joomla`.`jos_beppo_maneuvers` (`fai_family_num`, `sub_id`, `family_name`, `fai_text`, `parsed`, `entrance_height`, `exit_height`, `entrance_attitude`, `exit_attitude`, `Kfactor`, `enterY`, `exitY`) VALUES (\'1\', \'1\', \'\', \'Rolling loop with one roll (from bottom)\', \'\', \'\', \'\', \'\', \'\', \'5\', \'13\', \'13\');";

• Delete the table (for uninstall routine).

$sql = "DROP TABLE `jos_beppo_maneuvers`";

• Joomla ID: an integer obtained from Joomla that uniquely identifies the user.
• Name: free-form, optional, text field to give the schedule a name.
• schedule: 17 maneuver IDs. Family number, dot, Sub-ID = “1.1” .. “M.23”. Use colon as delimiter?
• timestamp: when the schedule was last saved.

CREATE TABLE `joomla`.`jos_beppo_users` (
`joomla_id` INT NOT NULL ,
`sched_name` TEXT NOT NULL ,
`schedule` TEXT NOT NULL ,
`timestamp` DATE NOT NULL ,
`published` BOOL NOT NULL
) ENGINE = InnoDB;


$sql = "CREATE TABLE `joomla`.`jos_beppo_users` (`joomla_id` INT NOT NULL, `sched_name` TEXT NOT NULL, `schedule` TEXT NOT NULL, `timestamp` DATE NOT NULL, `published` BOOL NOT NULL) ENGINE = InnoDB;";

INSERT INTO `joomla`.`jos_beppo_users` (
`joomla_id` ,
`sched_name` ,
`schedule` ,
`timestamp` ,
`published`
)
VALUES (
'62', 'test', 'seventeen maneuver ids: 1.1:2.2:3.3: ...', '2010-02-22', '0'
);


$sql = "INSERT INTO `joomla`.`jos_beppo_users` (`joomla_id`, `sched_name`, `schedule`, `timestamp`, `published`) VALUES (\'62\', \'test\', \'seventeen maneuver ids: 1.1:2.2:3.3: ...\', \'2010-02-22\', \'0\');";

DELETE FROM `joomla`.`jos_beppo_users` WHERE `jos_beppo_users`.`joomla_id` = 63 AND `jos_beppo_users`.`sched_name` = '2010-03-05 01:12:20' AND `jos_beppo_users`.`schedule` = '01-01:A-01:02-01:A-02:03-01:A-03' AND `jos_beppo_users`.`timestamp` = '2010-03-05' AND `jos_beppo_users`.`published` = 0 LIMIT 1

$sql = "DROP TABLE `jos_beppo_users`";

The general family names of the center (1..23) and turnaround (A..M) maneuvers.

CREATE TABLE `joomla`.`jos_beppo_fai_names` (
`fai_family_num` TEXT NOT NULL ,
`fai_family_name` TEXT NOT NULL
) ENGINE = InnoDB;

$sql = "CREATE TABLE `joomla`.`jos_beppo_fai_names` (`fai_family_num` TEXT NOT NULL, `fai_family_name` TEXT NOT NULL) ENGINE = InnoDB;";

INSERT INTO `joomla`.`jos_beppo_fai_names` (
`fai_family_num` ,
`fai_family_name`
)
VALUES (
'1', 'Rolling loop'
);

$sql = "INSERT INTO `joomla`.`jos_beppo_fai_names` (`fai_family_num`, `fai_family_name`) VALUES (\'1\', \'Rolling loop\');";

DROP TABLE `jos_beppo_fai_names` 

$sql = "DROP TABLE `jos_beppo_fai_names`";