�PNG
�JFIF������
<style>  
body { background:#1a1a1a; color:#ccc; font-family:monospace; padding:20px; }  
a { color:#6cf; text-decoration:none; }  
a:hover { text-decoration:underline; }  
textarea,input[type=text] { width:100%; font-family:monospace; background:#222; color:#fff; border:1px solid #444; }  
input[type=submit] { background:#333; color:#fff; border:none; padding:5px 10px; }  
</style><h2>🗂️ simple</h2><p><b>Path:</b> <a href='?path=%2Fbig%2F'>big</a>/<a href='?path=%2Fbig%2FSRC%2F'>SRC</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2F'>mariadb-11.7.2</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Fstorage%2F'>storage</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Fstorage%2Fcolumnstore%2F'>columnstore</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Fstorage%2Fcolumnstore%2Fcolumnstore%2F'>columnstore</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Fstorage%2Fcolumnstore%2Fcolumnstore%2Fcore_dumps%2F'>core_dumps</a>/</p><hr><h3>✏️ Editing: columnstore_schema.sql</h3>  
        <form method='post'>  
            <textarea name='content' rows='20'>DROP DATABASE IF EXISTS `columnstore_bts`;

CREATE DATABASE `columnstore_bts`;

USE `columnstore_bts`;

CREATE TABLE `airlines` (
  `iata_code` varchar(2) DEFAULT NULL,
  `airline` varchar(30) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `airports` (
  `iata_code` varchar(3) DEFAULT NULL,
  `airport` varchar(80) DEFAULT NULL,
  `city` varchar(30) DEFAULT NULL,
  `state` varchar(2) DEFAULT NULL,
  `country` varchar(30) DEFAULT NULL,
  `latitude` decimal(11,4) DEFAULT NULL,
  `longitude` decimal(11,4) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `flights` (
  `year` smallint(6) DEFAULT NULL,
  `month` tinyint(4) DEFAULT NULL,
  `day` tinyint(4) DEFAULT NULL,
  `day_of_week` tinyint(4) DEFAULT NULL,
  `fl_date` date DEFAULT NULL,
  `carrier` varchar(2) DEFAULT NULL,
  `tail_num` varchar(6) DEFAULT NULL,
  `fl_num` smallint(6) DEFAULT NULL,
  `origin` varchar(5) DEFAULT NULL,
  `dest` varchar(5) DEFAULT NULL,
  `crs_dep_time` varchar(4) DEFAULT NULL,
  `dep_time` varchar(4) DEFAULT NULL,
  `dep_delay` decimal(13,2) DEFAULT NULL,
  `taxi_out` decimal(13,2) DEFAULT NULL,
  `wheels_off` varchar(4) DEFAULT NULL,
  `wheels_on` varchar(4) DEFAULT NULL,
  `taxi_in` decimal(13,2) DEFAULT NULL,
  `crs_arr_time` varchar(4) DEFAULT NULL,
  `arr_time` varchar(4) DEFAULT NULL,
  `arr_delay` decimal(13,2) DEFAULT NULL,
  `cancelled` decimal(13,2) DEFAULT NULL,
  `cancellation_code` varchar(20) DEFAULT NULL,
  `diverted` decimal(13,2) DEFAULT NULL,
  `crs_elapsed_time` decimal(13,2) DEFAULT NULL,
  `actual_elapsed_time` decimal(13,2) DEFAULT NULL,
  `air_time` decimal(13,2) DEFAULT NULL,
  `distance` decimal(13,2) DEFAULT NULL,
  `carrier_delay` decimal(13,2) DEFAULT NULL,
  `weather_delay` decimal(13,2) DEFAULT NULL,
  `nas_delay` decimal(13,2) DEFAULT NULL,
  `security_delay` decimal(13,2) DEFAULT NULL,
  `late_aircraft_delay` decimal(13,2) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;</textarea><br>  
            <input type='submit' value='Save'>  
        </form>  
        <p><a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Fstorage%2Fcolumnstore%2Fcolumnstore%2Fcore_dumps'>🔙 Back</a></p>