These three tables should be created by //install.php// and removed by //uninstall.php//

====== #__beppo_maneuvers ======
|FAI Family number|Sub-ID|Family Name|FAI text|Parsed variations|entrance height|exit height|enter inverted|exit inverted|K-Factor|enterY|exitY|
\\ 
  * 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.
=== The basic data ===
[[all-maneuvers|Plain text, tab-delimited.]]  
== Installation ==
  * Create the table.
<code>
$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;";</code>
  * Load all the maneuvers into it.
<code>
$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\');";
</code>
  * Delete the table (for uninstall routine).
<code>
$sql = "DROP TABLE `jos_beppo_maneuvers`";
</code>
====== #__beppo_users ======
|Joomla ID|name|schedule|timestamp|published|
\\ 
  * 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 =====
<code>
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;";

</code>
===== insert record =====
<code>

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\');";
</code>

===== delete record =====
<code>
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
</code>

===== delete =====
<code>
$sql = "DROP TABLE `jos_beppo_users`";
</code>


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

|fai_family_num|fai_family_name|
\\ 
^  Center Maneuvers  ^^
|fai_family_num|fai_family_name|
|  1|Loop|
|  2|Two loops|
|  3|Avalanche|
|  4|Triangular loop|
|  5|Square loop|
|  6|Square loop on corner|
|  7|Six-sided loop|
|  8|Cobra roll|
|  9|Golf ball|
|  10|Cuban eight|
|  11|45 degree down|
|  12|Figure Z|
|  13|Hourglass|
|  14|Vertical eight|
|  15|Square horizontal eight|
|  16|Figure M|
|  17|Top hat|
|  18|Humpty bump|
|  19|Spin|
|  20|Stall turn|
|  21|Double Immelmann|
|  22|Rolling circle|
|  23|Roll|
^  Turnaround manoeuvres  ^^
|fai_family_num|fai_family_name|
|  A|Half square loop|
|  B|Half loop|
|  C|Split S|
|  D|Immelman turn|
|  E|Figure 9|
|  F|Half cuban eight|
|  G|Spin|
|  H|Stall turn|
|  J|Top hat|
|  K|45 degree up|
|  L|Humpty bump|
|  M|Humpty bump from top|
===== create =====

<code>
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;";

</code>

===== insert =====

<code>
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\');";
</code>

===== delete =====

<code>
DROP TABLE `jos_beppo_fai_names` 

$sql = "DROP TABLE `jos_beppo_fai_names`";
</code>