CREATE DATABASE GasPrices;
        USE GasPrices;

        CREATE TABLE users (
            id INT AUTO_INCREMENT PRIMARY KEY,
            username VARCHAR(50) UNIQUE NOT NULL,
            password VARCHAR(255) NOT NULL,
            is_admin BOOLEAN DEFAULT FALSE
        );

        CREATE TABLE stations (
            id INT AUTO_INCREMENT PRIMARY KEY,
            name VARCHAR(100),
            latitude DECIMAL(10, 8),
            longitude DECIMAL(11, 8)
        );

        CREATE TABLE gas_types (
            id INT AUTO_INCREMENT PRIMARY KEY,
            type VARCHAR(50)
        );
        INSERT INTO gas_types (type) VALUES ('SP95'), ('SP98'), ('Diesel');

        CREATE TABLE prices (
            id INT AUTO_INCREMENT PRIMARY KEY,
            station_id INT,
            gas_type_id INT,
            price DECIMAL(5, 2),
            date TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
            FOREIGN KEY (station_id) REFERENCES stations(id),
            FOREIGN KEY (gas_type_id) REFERENCES gas_types(id)
        );