Untitled

USE Trybefy;

CREATE TABLE plans (
  id INT PRIMARY KEY AUTO_INCREMENT,
  name VARCHAR(50) NOT NULL,
  price FLOAT(5, 2) NOT NULL
);

CREATE TABLE users (
  id INT AUTO_INCREMENT PRIMARY KEY,
  full_name VARCHAR(50) NOT NULL,
  email VARCHAR(50) NOT NULL,
  birthday DATE NOT NULL,
  active BOOLEAN DEFAULT TRUE NOT NULL,
  plan_id INT NOT NULL,
  FOREIGN KEY (plan_id) REFERENCES plans(id)
);

INSERT INTO plans (name, price) VALUES 
('Anual', 39.9), 
('Mensal', 5.9), 
('Trimestral', 19.9);

INSERT INTO users (full_name, email, birthday, active, plan_id) VALUES 
('Pedro', '[email protected]', '1990-01-01', true, 1), 
('Camila', '[email protected]', '1988-12-01', true, 1), 
('Guilherme', '[email protected]', '1988-12-01', true, 2), 
('Andressa', '[email protected]', '1984-07-20', false, 3), 
('Luís', '[email protected]', '2000-01-01', true, 2), 
('Cássia', '[email protected]', '1995-12-01', true, 1), 
('Simone', '[email protected]', '1988-12-01', true, 1), 
('Rogério', '[email protected]', '1979-12-01', true, 3), 
('Júlio', '[email protected]', '1994-06-20', false, 2), 
('Melissa', '[email protected]', '1997-04-11', true, 2);