14 lines
334 B
SQL
14 lines
334 B
SQL
CREATE TABLE users (
|
|
id INT AUTO_INCREMENT PRIMARY KEY,
|
|
username VARCHAR(255),
|
|
password VARCHAR(255)
|
|
);
|
|
|
|
CREATE TABLE posts (
|
|
id INT AUTO_INCREMENT PRIMARY KEY,
|
|
content TEXT NOT NULL
|
|
);
|
|
|
|
INSERT INTO users (username, password) VALUES ('admin', 'admin123');
|
|
INSERT INTO users (username, password) VALUES ('user', 'password');
|