DATABASE PERSONAL NATO
by As7nuvixx3xpl0it - Friday September 26, 2025 at 10:38 AM
#1
[Image: e4k8ij.jpg]
DATABASE NATO
get full data? pv t.me/ayaVlock
CREATE TABLE personnel (
    id INT PRIMARY KEY,
    name VARCHAR(100),
    rank VARCHAR(50),
    country VARCHAR(50),
    deployment_status VARCHAR(50)
);

CREATE TABLE missions (
    mission_id INT PRIMARY KEY,
    mission_name VARCHAR(100),
    location VARCHAR(100),
    start_date DATE,
    status VARCHAR(50)
);

CREATE TABLE equipment (
    equipment_id INT PRIMARY KEY,
    type VARCHAR(50),
    name VARCHAR(100),
    quantity INT,
    assigned_mission_id INT,
    FOREIGN KEY (assigned_mission_id) REFERENCES missions(mission_id)
);

INSERT INTO personnel (id, name, rank, country, deployment_status) VALUES
(1, 'John Smith', 'Colonel', 'United States', 'Active'),
(2, 'Marie Dubois', 'Captain', 'France', 'Reserve'),
(3, 'Hans Müller', 'Major', 'Germany', 'Active'),
(4, 'Anna Kowalski', 'Lieutenant', 'Poland', 'On Leave'),
(5, 'James Brown', 'Sergeant', 'United Kingdom', 'Active');

INSERT INTO missions (mission_id, mission_name, location, start_date, status) VALUES
(1, 'Operation Peacekeeper', 'Eastern Europe', '2024-01-15', 'Ongoing'),
(2, 'Operation Northern Shield', 'Baltic Region', '2023-06-20', 'Completed'),
(3, 'Operation Atlantic Resolve', 'Western Europe', '2025-03-01', 'Planned');

INSERT INTO equipment (equipment_id, type, name, quantity, assigned_mission_id) VALUES
(1, 'Vehicle', 'Armored Transport', 10, 1),
(2, 'Weapon', 'Standard Rifle', 500, 1),
(3, 'Communication', 'Satellite Radio', 50, 3),
(4, 'Vehicle', 'Utility Helicopter', 5, 2),
(5, 'Weapon', 'Anti-Tank Missile', 20, 1);
Reply
#2
legit?
Reply
#3
(26-09-25, 10:38 AM)As7nuvixx3xpl0it Wrote: [Image: e4k8ij.jpg]
DATABASE NATO
get full data? pv t.me/ayaVlock
CREATE TABLE personnel (
    id INT PRIMARY KEY,
    name VARCHAR(100),
    rank VARCHAR(50),
    country VARCHAR(50),
    deployment_status VARCHAR(50)
);

CREATE TABLE missions (
    mission_id INT PRIMARY KEY,
    mission_name VARCHAR(100),
    location VARCHAR(100),
    start_date DATE,
    status VARCHAR(50)
);

CREATE TABLE equipment (
    equipment_id INT PRIMARY KEY,
    type VARCHAR(50),
    name VARCHAR(100),
    quantity INT,
    assigned_mission_id INT,
    FOREIGN KEY (assigned_mission_id) REFERENCES missions(mission_id)
);

INSERT INTO personnel (id, name, rank, country, deployment_status) VALUES
(1, 'John Smith', 'Colonel', 'United States', 'Active'),
(2, 'Marie Dubois', 'Captain', 'France', 'Reserve'),
(3, 'Hans Müller', 'Major', 'Germany', 'Active'),
(4, 'Anna Kowalski', 'Lieutenant', 'Poland', 'On Leave'),
(5, 'James Brown', 'Sergeant', 'United Kingdom', 'Active');

INSERT INTO missions (mission_id, mission_name, location, start_date, status) VALUES
(1, 'Operation Peacekeeper', 'Eastern Europe', '2024-01-15', 'Ongoing'),
(2, 'Operation Northern Shield', 'Baltic Region', '2023-06-20', 'Completed'),
(3, 'Operation Atlantic Resolve', 'Western Europe', '2025-03-01', 'Planned');

INSERT INTO equipment (equipment_id, type, name, quantity, assigned_mission_id) VALUES
(1, 'Vehicle', 'Armored Transport', 10, 1),
(2, 'Weapon', 'Standard Rifle', 500, 1),
(3, 'Communication', 'Satellite Radio', 50, 3),
(4, 'Vehicle', 'Utility Helicopter', 5, 2),
(5, 'Weapon', 'Anti-Tank Missile', 20, 1);
Reply
#4
were the link
Reply


Forum Jump:


 Users browsing this thread: 1 Guest(s)