Untitled
unknown
plain_text
20 days ago
1.2 kB
2
Indexable
Never
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', 'pedro@trybefy.com', '1990-01-01', true, 1), ('Camila', 'camila@trybefy.com', '1988-12-01', true, 1), ('Guilherme', 'guilherme@trybefy.com', '1988-12-01', true, 2), ('Andressa', 'andressa@trybefy.com', '1984-07-20', false, 3), ('Luís', 'luis@trybefy.com', '2000-01-01', true, 2), ('Cássia', 'cassia@trybefy.com', '1995-12-01', true, 1), ('Simone', 'simone@trybefy.com', '1988-12-01', true, 1), ('Rogério', 'rogerio@trybefy.com', '1979-12-01', true, 3), ('Júlio', 'julio@trybefy.com', '1994-06-20', false, 2), ('Melissa', 'melissa@trybefy.com', '1997-04-11', true, 2);
Leave a Comment