mirror of
https://github.com/BishopFox/cloudfoxable.git
synced 2026-11-10 01:31:24 -10:00
16 lines
700 B
SQL
16 lines
700 B
SQL
CREATE TABLE IF NOT EXISTS credit_cards (
|
|
id INT AUTO_INCREMENT PRIMARY KEY,
|
|
card_holder_name VARCHAR(255) NOT NULL,
|
|
card_number VARCHAR(16) NOT NULL,
|
|
expiry_date DATE NOT NULL,
|
|
cvv INT NOT NULL,
|
|
notes TEXT
|
|
);
|
|
|
|
INSERT INTO credit_cards (card_holder_name, card_number, expiry_date, cvv, notes)
|
|
VALUES ('Jane Smith', '2345678923456789', '2024-06-30', 456, NULL),
|
|
('Alice Johnson', '3456789034567890', '2023-12-31', 789, NULL),
|
|
('Bob Brown', '4567890145678901', '2023-05-31', 321, 'FLAG{DidYouKnowDatabasesHoldSensitiveData}'),
|
|
('Charlie Davis', '5678901256789012', '2022-11-30', 654, NULL),
|
|
('John Doe', '1234567812345678', '2025-01-31', 123, NULL);
|