1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
| drop table gmms2_task;
| drop table gmms2_user;
|
| create table gmms2_task (
| id number(19,0),
| title varchar2(128) not null,
| description varchar2(255),
| user_id number(19,0) not null,
| primary key (id)
| );
|
| create table gmms2_user (
| id number(19,0),
| login_name varchar2(64) not null unique,
| name varchar2(64) not null,
| password varchar2(255) not null,
| salt varchar2(64) not null,
| roles varchar2(255) not null,
| register_date date not null,
| primary key (id)
| );
|
|
| create sequence gmms2_seq_task start with 100 increment by 20;
| create sequence gmms2_seq_user start with 100 increment by 20;
|
|
