/* truncate table before insert */
truncate table ffam_programme;
truncate table ffam_figure;
/* end truncate table before insert */
--
-- MariaDB dump 10.19  Distrib 10.5.19-MariaDB, for debian-linux-gnueabihf (armv7l)
--
-- Host: localhost    Database: ffam_concours
-- ------------------------------------------------------
-- Server version	10.5.19-MariaDB-0+deb11u2-log

/*!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'),(101,'F3A (2024-2025) PRELIMINARY SCHEDULE P-25','F3A-P25','ENG',2,4,10,999.99,999.99,4,3,2,'2017'),(102,'F3A (2024-2025) FINAL SCHEDULE F-25','F3A-F25','ENG',2,4,10,999.99,999.99,4,3,2,'2017'),(103,'F3A(2024-2025) NORDIC SCHEDULE N-25','N25','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.00,'To looper','Two loops',1),(1971,95,2,1.00,'Halv reversert Cuban åtte','Half Cuban eight',1),(1972,95,3,3.00,'Full Roll','Full Roll',1),(1973,95,4,2.00,'Firkantet loop','Square loop',1),(1974,95,5,1.00,'Immelmann','Immelman',1),(1975,95,6,2.00,'45 grader nedstigning','45 degrees down',1),(1976,95,7,3.00,'Stall turn m kvarte roller','Stall turn',1),(1977,95,8,1.00,'Humptybump halv roll up','Humpybump half roll up',1),(1978,95,9,2.00,'Trekant loop','Triangle loop',1),(1979,95,10,3.00,'Tre turn spinn','Three turn spinn',1),(1997,97,1,1.00,'Take off','Take off',1),(1998,97,2,3.00,'Two loops','Two loops',1),(1999,97,3,3.00,'Two rolls','Two rolls',1),(2000,97,4,4.00,'Triangle loop','Triangle loop',1),(2001,97,5,2.00,'Inverted flight','Inverted flight',1),(2002,97,6,3.00,'Top hat with half rolls','Topp hat',1),(2003,97,7,3.00,'Cobra roll','Cobra roll',1),(2004,97,8,3.00,'Immelman Combo','Immelman',1),(2005,97,9,4.00,'Cuban eight','Cuban eight',1),(2006,97,10,1.00,'Landing','Landing',1),(2060,101,1,3.00,'Triangle from Top with two quarter rolls, roll, two quarter rolls','Triangle from Top',1),(2061,101,2,2.00,'Half Square Loop with roll','Half Square Loop with roll',1),(2062,101,3,5.00,'Square Loop on corner with half roll, half roll, half roll, half roll','Square Loop on corner',1),(2063,101,4,3.00,'Figure Nine with half roll','Figure Nine with half roll',1),(2064,101,5,4.00,'Roll Combination with three quarter rolls, three quarter rolls in opposite direction','Roll Combination',1),(2065,101,6,3.00,'Stall Turn with half roll','Stall Turn with half roll',1),(2066,101,7,4.00,'Double Immelman with roll, quarter roll, quarter roll, half roll','Double Immelman',1),(2067,101,8,3.00,'Humpty Bump with two consecutive half rolls in opposite direction, half roll','Humpty Bump',1),(2068,101,9,5.00,'Loop with two half rolls integrated','Loop',1),(2069,101,10,2.00,'Half Square Loop on Corner with half roll, half roll','Half Square Loop on Corner',1),(2070,101,11,5.00,'Half Cloverleaf with half roll, half roll, half roll','Half Cloverleaf',1),(2071,101,12,4.00,'Reverse Figure ET with half roll, two quarter rolls','Reverse Figure ET',1),(2072,101,13,3.00,'Inverted Spin two turns, half roll','Inverted Spin two turns',1),(2073,101,14,3.00,'Top hat with two quarter rolls. Option: Top hat with quarter roll, quarter roll','Top hat',1),(2074,101,15,4.00,'Figure Z with snap roll','Figure Z with snap roll',1),(2075,101,16,3.00,'Comet with two quarter rolls, roll','Comet',1),(2076,101,17,5.00,'Figure S with quarter roll, quarter roll','Figure S',1),(2077,102,1,4.00,'Square Loop on Corner with quarter roll integrated, half roll integrated, half roll integrated, half roll integrated, quarter roll integrated','Square Loop on Corner',1),(2078,102,2,3.00,'Figure Nine with roll, half roll in opposite directions','Figure Nine',1),(2079,102,3,4.00,'Roll Combination with consecutive two quarter rolls, four consecutive quarter rolls in opposite direction, two consecutive quarter rolls in opposite direction','Roll Combination',1),(2080,102,4,4.00,'Half Loop with half roll integrated','Half Loop',1),(2081,102,5,5.00,'Pull Pull Push Humpty Bump with one and half snap rolls, half roll integrated, one and a half rolls','Pull Pull Push Humpty Bump',1),(2082,102,6,3.00,'Three Turn Spin with half roll','Three Turn Spin with half roll',1),(2083,102,7,5.00,'Horizontal Circle with three half rolls in opposite direction integrated','Horizontal Circle',1),(2084,102,8,4.00,'Shark Fin with roll, two snap rolls in opposite directions','Shark Fin',1),(2085,102,9,5.00,'Square Vertical Eight with half roll, roll, quarter roll, roll, quarter roll, roll, half roll','Square Vertical Eight',1),(2086,102,10,3.00,'Push Push Pull Humpty Bump with half roll, one and a half roll','Push Push Pull Humpty Bump',1),(2087,102,11,5.00,'Knife-edge Triangle with quarter roll integrated, half roll, half roll integrated, half roll, quarter roll integrated','Knife-edge Triangle',1),(2088,102,12,3.00,'Half Eight Sided Loop with quarter roll, quarter roll','Half Eight Sided Loop',1),(2089,102,13,4.00,'Forty Five Degree Downline with two consecutive one and a quarter rolls in opposite direction','Forty Five Degree Downline',1),(2090,102,14,3.00,'Half Square Loop with roll, half roll in opposite directions','Half Square Loop',1),(2091,102,15,6.00,'Avalanche (from top) with quarter roll integrated, snap roll, quarter roll integrated','Avalanche (from top)',1),(2092,102,16,4.00,'Knife Edge Split S with quarter roll, quarter roll','Knife Edge Split S',1),(2093,102,17,5.00,'Stall Turn with half roll, three quarter rolls, three quarter snap roll, half roll','Stall Turn',1),(2095,103,1,3.00,'Pull-push-pull Humpty Bump with two half rolls','Humpty Bump half rolls',1),(2096,103,2,3.00,'Trombone with roll and half roll','Trombone with rolls',1),(2097,103,3,3.00,'Triangle with two half rolls','Triangle with half rolls',1),(2098,103,4,3.00,'Reverse Shark Fin with half roll','Reverse Shark Fin with roll',1),(2099,103,5,4.00,'Roll Combination with four quarter rolls','Four point roll',1),(2100,103,6,2.00,'Immelmann','Immelmann',1),(2101,103,7,4.00,'Square Loop on corner from top with half roll','Square Loop on corner',1),(2102,103,8,2.00,'Half Cuban 8 from top with half roll','Half Cuban 8',1),(2103,103,9,3.00,'Spin with three turns','Spin with three turns',1),(2104,103,10,3.00,'Top Hat with half roll.','Top Hat with half roll.',1),(2105,103,11,4.00,'Roll Combination with quarter roll, Knife Edge, quarter roll','Knife Edge flight',1),(2106,103,12,3.00,'Pull-pull-pull Humpty Bump with two quarter rolls','Humpty Bump two quarter rolls',1),(2107,103,13,5.00,'Figure M with quarter rolls','Figure M',1),(2108,103,14,3.00,'Half square Loop on Corner with 1/2 rolls','Half square Loop on Corner',1),(2109,103,15,4.00,'Double triangle with half roll','Double triangle',1),(2110,103,16,3.00,'Reverse Figure ET with half roll','Reverse Figure ET',1),(2111,103,17,4.00,'Loop with two half rolls, the second roll integrated','Loop with two half 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 2024-01-30 16:37:55
