INSERT INTO users (name, last_name, mail, password, registration_date, status, balance)
VALUES ('John', 'Doe', 'john.doe@example.com', STANDARD_HASH('password123', 'MD5'), SYSDATE, '1', 100.00);
INSERT INTO users (name, last_name, mail, password, registration_date, status, balance)
VALUES ('Jane', 'Smith', 'jane.smith@example.com', STANDARD_HASH('password123', 'MD5'), SYSDATE, '1', 150.00);
INSERT INTO users (name, last_name, mail, password, registration_date, status, balance)
VALUES ('Alice', 'Johnson', 'alice.johnson@example.com', STANDARD_HASH('password123', 'MD5'), SYSDATE, '1', 200.00);
INSERT INTO users (name, last_name, mail, password, registration_date, status, balance)
VALUES ('Bob', 'Brown', 'bob.brown@example.com', STANDARD_HASH('password123', 'MD5'), SYSDATE, '1', 50.00);
INSERT INTO users (name, last_name, mail, password, registration_date, status, balance)
VALUES ('Charlie', 'Davis', 'charlie.davis@example.com', STANDARD_HASH('password123', 'MD5'), SYSDATE, '1', 75.00);
INSERT INTO admins (name, last_name, password, mail, registration_date, role, status, phone_number)
VALUES ('Admin1', 'Admin', STANDARD_HASH('adminpass1', 'MD5'), 'admin1@example.com', SYSDATE, '0', '1', '1234567890');
INSERT INTO admins (name, last_name, password, mail, registration_date, role, status, phone_number)
VALUES ('Admin2', 'Admin', STANDARD_HASH('adminpass2', 'MD5'), 'admin2@example.com', SYSDATE, '0', '1', '0987654321');
INSERT INTO packages (name, description, price, ram_limit, disc_space_limit, cpu_limit, max_player_count, status)
VALUES ('Basic Package', 'Basic server package', 10.00, 512, 1024, 1.00, 10, '1');
INSERT INTO packages (name, description, price, ram_limit, disc_space_limit, cpu_limit, max_player_count, status)
VALUES ('Advanced Package', 'Advanced server package', 20.00, 1024, 2048, 2.00, 20, '1');
INSERT INTO modules (name, type, description, version, minecraft_version, status)
VALUES ('Module1', '0', 'First module description', 1.0, '1.16', '1');
INSERT INTO modules (name, type, description, version, minecraft_version, status)
VALUES ('Module2', '1', 'Second module description', 1.1, '1.17', '1');
INSERT INTO domains (server_id, domain_name, status, assign_date, expiration_date)
VALUES (1, 'example.com', '1', SYSDATE, SYSDATE + 365);
INSERT INTO domains (server_id, domain_name, status, assign_date, expiration_date)
VALUES (1, 'test.com', '1', SYSDATE, SYSDATE + 365);
INSERT INTO servers (user_id, package_id, name, status, ipv4_address, port, assigned_domain, creation_date, minecraft_version)
VALUES (1, 1, 'Server1', '0', '192.168.1.1', 25565, 'example.com', SYSDATE, '1.16');
INSERT INTO servers (user_id, package_id, name, status, ipv4_address, port, assigned_domain, creation_date, minecraft_version)
VALUES (2, 2, 'Server2', '0', '192.168.1.2', 25566, 'test.com', SYSDATE, '1.17');
INSERT INTO moduleinstallations (server_id, module_id, installation_date, status)
VALUES (1, 1, SYSDATE, '1');
INSERT INTO moduleinstallations (server_id, module_id, installation_date, status)
VALUES (2, 2, SYSDATE, '1');
INSERT INTO payments (user_id, package_id, amount, payment_date, status, payment_method, payment_deadline)
VALUES (1, 1, 10.00, SYSDATE, '1', '0', SYSDATE + 7);
INSERT INTO payments (user_id, package_id, amount, payment_date, status, payment_method, payment_deadline)
VALUES (2, 2, 20.00, SYSDATE, '1', '1', SYSDATE + 7);
INSERT INTO serverlogs (server_id, timestamp, type, description, importance_level, additional_data)
VALUES (1, CURRENT_TIMESTAMP, '0', 'Server started', '0', NULL);
INSERT INTO serverlogs (server_id, timestamp, type, description, importance_level, additional_data)
VALUES (2, CURRENT_TIMESTAMP, '1', 'Server stopped', '1', 'Maintenance');
INSERT INTO tickets (user_id, server_id, title, description, creation_date, status, priority, admin_id)
VALUES (1, 1, 'Issue with Server1', 'Server is not responding', SYSDATE, '0', '1', 1);
INSERT INTO tickets (user_id, server_id, title, description, creation_date, status, priority, admin_id)
VALUES (2, 2, 'Server2 Lagging', 'Experiencing lag issues', SYSDATE, '0', '2', 2);