database/create.sql - master - Alyar/Fastify-master

database/create.sql

37 строк649 B

Alyar

Preloader

03 дек 2025, 18:25

03 дек 2025, 18:257b6f7b7

CREATE DATABASE `__DB_NAME__`;

USE `__DB_NAME__`;

CREATE TABLE categories (
    id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(255)
);

CREATE TABLE locations (
    id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(255)
);

CREATE TABLE items (
    id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(255),
    location_id INT
);

CREATE TABLE item_category (
    item_id INT,
    category_id INT
);


CREATE TABLE products (
    id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(255), 
    description VARCHAR(255)
);

CREATE TABLE location (
    id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(255), 
    description VARCHAR(255)
);