/
techuser
/
testtask
Обзор
Документация
Войти
/
techuser
/
testtask
Код
Запросы
0
Пакеты
0
Релизы
0
CI/CD
Аналитика
Безопасность
master
Scripts/init_schema.sql
18 строк
869 B
Evgeniy Shimkov
testtask initial commit
25 мар 2024, 17:59
25 мар 2024, 17:59
2a290a1
Код
Авторство
О чём код?
--create schema --connect jdbc:derby://localhost:1527/test' user 'uname' password 'pass'; create schema uname authorization uname; set schema uname; create table ttable ( --id integer default autoincrement: start 1 increment 1 not null generated always as identity (start with 1, increment by 1), id integer not null generated always as identity (start with 1, increment by 1), value varchar(100), description varchar(100), created date, constraint ttable_pk primary key (id) ); insert into ttable (value, description, created) values('second', 'description', '2024-03-25'); insert into ttable (value, description, created) values('third', 'description', '2024-03-25'); insert into ttable (value, description, created) values('fourth', 'description', '2024-03-25'); insert into ttable (value, description, created) values('fifth', 'description', '2024-03-25');