16 lines
349 B
MySQL
16 lines
349 B
MySQL
|
create database db;
|
||
|
|
use db;
|
||
|
|
|
||
|
|
CREATE TABLE templates (
|
||
|
|
id INT AUTO_INCREMENT PRIMARY KEY,
|
||
|
|
title VARCHAR(255) NOT NULL,
|
||
|
|
author VARCHAR(255) NOT NULL
|
||
|
|
)
|
||
|
|
|
||
|
|
CREATE TABLE elements (
|
||
|
|
id INT PRIMARY KEY,
|
||
|
|
template_id INT NOT NULL,
|
||
|
|
name VARCHAR(255) NOT NULL,
|
||
|
|
FOREIGN KEY (template_id) REFERENCES templates(id) ON DELETE CASCADE
|
||
|
|
);;
|