/* truncate table before insert */
truncate table ffam_programme;
truncate table ffam_figure;
/* end truncate table before insert */
--
-- MySQL dump 10.18  Distrib 10.3.27-MariaDB, for debian-linux-gnueabihf (armv8l)
--
-- Host: localhost    Database: ffam_concours
-- ------------------------------------------------------
-- Server version	10.3.27-MariaDB-0+deb10u1

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Dumping data for table `ffam_programme`
--

LOCK TABLES `ffam_programme` WRITE;
/*!40000 ALTER TABLE `ffam_programme` DISABLE KEYS */;
INSERT INTO `ffam_programme` (`prgid`, `prglibelle`, `prgshortname`, `prglang`, `typeid`, `catid`, `duration`, `promothreshold1`, `promothreshold2`, `promoflightsmax`, `promoflights`, `promoflightsmin`, `promoversion`) VALUES (95,'F3A SPORT S-11','F3A-S11','ENG',2,4,10,999.99,999.99,4,3,2,'2017'),(97,'F3A Curare Cup Normal','F3A-Cura','ENG',2,4,10,999.99,999.99,4,3,2,'2017'),(98,'F3A (2022-2023) PRELIMINARY SCHEDULE P-23','F3A-P23','ENG',2,4,10,999.99,999.99,4,3,2,'2017'),(99,'F3A (2022-2023) FINAL SCHEDULE F-23','F3A-F23','ENG',2,4,10,999.99,999.99,4,3,2,'2017'),(100,'F3A(2022-2023) NORDIC SCHEDULE N-23','F3A-N23','ENG',2,4,10,999.99,999.99,4,3,2,'2017');
/*!40000 ALTER TABLE `ffam_programme` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `ffam_figure`
--

LOCK TABLES `ffam_figure` WRITE;
/*!40000 ALTER TABLE `ffam_figure` DISABLE KEYS */;
INSERT INTO `ffam_figure` (`figid`, `prgid`, `figposition`, `figcomplexite`, `figdescription`, `figshortdesc`, `figoption`) VALUES (1970,95,1,2,'2 looper','Two loops',1),(1971,95,2,1,'Halv reversert Cuban 8','Half Cuban eight',1),(1972,95,3,3,'Full Roll','Full Roll',1),(1973,95,4,2,'Firkantet loop','Square loop',1),(1974,95,5,1,'Immelmann','Immelman',1),(1975,95,6,2,'45 grader nedstigning','45 degrees down',1),(1976,95,7,3,'Stall turn m 1/4 roller','Stall turn',1),(1977,95,8,1,'Humptybump 1/2 roll up','Humpybump half roll up',1),(1978,95,9,2,'Trekant loop','triangle loop',1),(1979,95,10,3,'3 turn spinn','Three turn spinn',1),(1997,97,1,1,'Take off','Take off',1),(1998,97,2,3,'Two loops','Two loops',1),(1999,97,3,3,'Two rolls','Two rolls',1),(2000,97,4,4,'Triangle loop','Triangle loop',1),(2001,97,5,2,'Inverted flight','Inverted flight',1),(2002,97,6,3,'Top hat with half rolls','Topp hat',1),(2003,97,7,3,'Cobra roll','Cobra roll',1),(2004,97,8,3,'Immelman Combo','Immelman',1),(2005,97,9,4,'Cuban eight','Cuban 8',1),(2006,97,10,1,'Landing','Landing',1),(2007,98,1,4,'Top Hat with two quarter rolls up, half roll, two quarter rolls down','Top Hat',1),(2008,98,2,2,'Half Square Loop with half roll','Half square Loop',1),(2009,98,3,4,'Pull-Pull-Push Humpty-Bump with roll, half roll','Pull Pull Push HumptyBump',1),(2010,98,4,3,'Half Square Loop on Corner with half roll, half roll','Half Square Loop on Corner',1),(2011,98,5,5,'Forty Five Degree Upline, with one and a half snap roll','45 ° upline',1),(2012,98,6,3,'Half Eight Sided Loop','Half Eight Sided Loop',1),(2013,98,7,4,'Roll Combination with two consecutive half rolls, two consecutive half rolls in opposite direction','Roll Combination',1),(2014,98,8,2,'Pushed Immelmann turn with half roll','Pushed Immelmann',1),(2015,98,9,4,'Inverted Spin two and a half turns','Inverted Spin',1),(2016,98,10,3,'Pull-Pull-Push Humpty-Bump, with half rolls (Option : three quarter roll, quarter roll)','Pull Pull Push HumptyBump',1),(2017,98,11,4,'Reverse Figure ET with two consecutive half rolls in opposite direction, two consecutive quarter rolls','Reverse Figure ET',1),(2018,98,12,2,'Half Square Loop with half roll','Half Square Loop',1),(2019,98,13,5,'Crossbox Figure M, with three quarter rolls','Crossbox Figure M',1),(2020,98,14,4,'Fighter Turn with quarter rolls','Fighter Turn',1),(2021,98,15,3,'Triangle with half roll, two consecutive quarter rolls, two consecutive quarter rolls, half roll','Triangle',1),(2022,98,16,3,'Shark Fin with half roll, two consecutive quarter rolls','Shark Fin',1),(2023,98,17,5,'Loop with half roll integrated','Loop with half roll integrated',1),(2025,99,1,5,'Knife Edge Rolling Loop','Knife Edge Rolling Loop',1),(2026,99,2,4,'Stall Turn with snap roll, roll','Stall Turn',1),(2027,99,3,4,'Eight consecutive 1/8 rolls','Eight point roll',1),(2028,99,4,3,'Shark Tooth with three consecutive quarter rolls, three quarter rolls','Shark Tooth',1),(2029,99,5,5,'Square Loop on corner with quarter roll, half roll, half roll, quarter roll','Square Loop on corner',1),(2030,99,6,4,'Push-Pull-Pull Humpty-Bump with consecutive half rolls, integrated roll, snap roll','Push-Pull-Pull Humpty-Bump',1),(2031,99,7,6,'Horizontal Eight with rolls integrated','Horizontal Eight',1),(2032,99,8,3,'Reverse Figure ET with roll, consecutive quarter rolls','Reverse Figure ET',1),(2033,99,9,6,'Knife Edge Forty Five Degree Upline with two consecutive snap rolls in opposite direction','Knife Edge 45 ° Upline',1),(2034,99,10,3,'Reverse Vertical Shark Tooth with two consecutive half rolls in opposite direction, two consecutive quarter rolls, roll','Reverse Shark Tooth',1),(2035,99,11,6,'Reverse Double Fighter Turn with three consecutive quarter rolls, half roll, half roll, three consecutive quarter rolls','Double Fighter Turn',1),(2036,99,12,2,'Top Hat with half roll, half roll. Option : Top Hat with quarter roll, quarter roll','Top Hat',1),(2037,99,13,5,'Spin with two and a quarter turns, two and a quarter turns in opposite direction','Spin two and a quarter turns',1),(2038,99,14,4,'Half Cuban Eight, with two half rolls in opposite direction, one and half snap roll','Half Cuban Eight',1),(2039,99,15,5,'Rolling Circle with half rolls in opposite direction integrated ','Rolling Circle',1),(2040,99,16,2,'Half Square Loop with half rolls in opposite direction','Half Square Loop',1),(2041,99,17,5,'Avalanche (from top) with half rolls integrated, snap, half roll integrated','Avalanche',1),(2043,100,1,3,'Triangleloop with 1/2 rolls','Triangleloop with half rolll',1),(2044,100,2,3,'2 ½ turn spin','Two and a half spin',1),(2045,100,3,4,'Squareloop on corner with 1/1 rolls','Squareloop on corner rolls',1),(2046,100,4,3,'Figure 9 with two ¼ rolls','Figure 9 two quarter rolls',1),(2047,100,5,4,'Rollcombination with two and two 1⁄4 rolls in opposite direction','Rollcombination two quarters',1),(2048,100,6,4,'Stallturn with ½ rolls','Stallturn with half rolls',1),(2049,100,7,4,'Inverted flight, immelmann/split S combo','Immelmann split S combo',1),(2050,100,8,3,'Humptybump with ½ rolls. Option: ¼ rolls','Humptybump with half rolls',1),(2051,100,9,4,'Loop with integrated roll','Loop with integrated roll',1),(2052,100,10,2,'Squareloop on corner with 1⁄2 roll','Squareloop on corner half roll',1),(2053,100,11,5,'Half reverse Clover Leaf with ½ rolls','Half reverse Clover Leaf',1),(2054,100,12,2,'Half Squareloop with two ¼ rolls','Half Squareloop quarter rolls',1),(2055,100,13,4,'Figure U with ¼ rolls','Figure U with quarter rolls',1),(2056,100,14,2,'Reverse Humptybump with ½ roll','Reverse Humptybump half roll',1),(2057,100,15,4,'Figure Z with 1/1 roll','Figure Z with full roll',1),(2058,100,16,3,'Comet with ½ roll','Comet with half roll',1),(2059,100,17,5,'Snowman with ½ rolls','Snowman with halv rolls',1);
/*!40000 ALTER TABLE `ffam_figure` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2021-10-01 19:48:37
