/
NikolayIvkin
/
tutorials1
Обзор
Документация
Войти
/
NikolayIvkin
/
tutorials1
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
libraries-testing/src/test/resources/dbunit/schema.sql
25 строк
776 B
panos-kakos
[JAVA-13966] Upgraded h2 database to 2.1.214 + clean up (#12711)
19 окт 2022, 21:47
19 окт 2022, 21:47
eb17d0e
Код
Авторство
О чём код?
CREATE TABLE IF NOT EXISTS CLIENTS ( `id` int PRIMARY KEY AUTO_INCREMENT NOT NULL, `first_name` varchar(100) NOT NULL, `last_name` varchar(100) NOT NULL ); CREATE TABLE IF NOT EXISTS ITEMS ( `id` int PRIMARY KEY AUTO_INCREMENT NOT NULL, `title` varchar(100) NOT NULL, `produced` date, `price` float ); CREATE TABLE IF NOT EXISTS PURCHASES ( `id` int PRIMARY KEY AUTO_INCREMENT NOT NULL, `id_user` int NOT NULL, `id_item` int NOT NULL, `total_price` float NOT NULL, `quantity` int NOT NULL, FOREIGN KEY (`id_user`) REFERENCES CLIENTS (`id`) ON DELETE CASCADE, FOREIGN KEY (`id_item`) REFERENCES ITEMS (`id`) ON DELETE CASCADE ON UPDATE CASCADE );