sql-statements

--Creating a new MySQL database with a user
--CREATE DATABASE db_name;
--CREATE USER `username`@`localhost` IDENTIFIED BY "password";
--GRANT ALL PRIVILEGES ON db_name.* TO `username`@`localhost`;
------------------------------------------------------------


CREATE DATABASE cmsdb;

CREATE TABLE Users
(
  id INT AUTO_INCREMENT NOT NULL,
  name VARCHAR(255) NOT NULL,
  email VARCHAR(255) NOT NULL,
  password VARCHAR(255) NOT NULL,
  PRIMARY KEY (id),
  UNIQUE (email)
);

CREATE TABLE Articles
(
  id INT AUTO_INCREMENT NOT NULL,
  title VARCHAR(255) NOT NULL,
  content TEXT,
  published_date DATE NOT NULL,
  users_id INT NOT NULL,
  PRIMARY KEY (id),
  FOREIGN KEY (users_id) REFERENCES Users(id)
);

CREATE TABLE Images
(
  id INT AUTO_INCREMENT NOT NULL,
  name VARCHAR(255) NOT NULL,
  url VARCHAR(255) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE ArticleImages
(
  images_id INT AUTO_INCREMENT NOT NULL,
  articles_id INT NOT NULL,
  PRIMARY KEY (images_id, articles_id),
  FOREIGN KEY (images_id) REFERENCES Images(id),
  FOREIGN KEY (articles_id) REFERENCES Articles(id)
);

INSERT INTO Users (name, email, password)
VALUES('Admin', 'admin@admin.com', '$2a$12$9F4icyaDD8yoifH2qcfGu.MN48cMgdI0S58/kUIAnlSwXHyTGjUh6') --Admin@12345