11 lines
358 B
SQL
11 lines
358 B
SQL
CREATE TABLE users(
|
|
id INT(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
|
|
username VARCHAR(30) NOT NULL,
|
|
password VARCHAR(32) NOT NULL,
|
|
is_admin TINYINT(1) DEFAULT 0,
|
|
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
|
|
);
|
|
|
|
INSERT INTO users(username, password, is_admin) VALUES
|
|
('admin', 'password', 1),
|
|
('joakim', 'ErEnIdiot', 0); |