/
pavelsamodurov
/
financejavaee216
Обзор
Документация
Войти
/
pavelsamodurov
/
financejavaee216
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
financejavaee-ejb/src/main/resources/db/insert-data.sql
18 строк
607 B
Pavel Samodurov
add Primefaces dependency
25 фев 2020, 21:20
25 фев 2020, 21:20
098e283
Код
Авторство
О чём код?
DELETE FROM fin_transaction; DELETE FROM account; DELETE FROM customer; ALTER SEQUENCE global_seq_finance RESTART WITH 100000; INSERT INTO customer (name, address) VALUES ('Customer1', 'address1'), ('Customer2', 'address2'); INSERT INTO account (acc_number, description, customer_id) VALUES (1, 'one', 100000), (2, 'two', 100001), (3, 'three', 100001); INSERT INTO fin_transaction (date_time, amount, description, account_id) VALUES ('2020-02-20 10:00:00', 100, 'one hundred', 100002), ('2020-02-20 11:00:00', 200, 'two hundred', 100002), ('2020-02-20 15:00:00', 300, 'three hundred', 100003);