|
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
|
/*C3*/SET SCHEMA PUBLIC
CONNECT USER SA
/*C4*/SET SCHEMA PUBLIC
CONNECT USER SA
SET AUTOCOMMIT FALSE
INSERT INTO JBM_DUAL VALUES(1)
COMMIT
DELETE FROM JBM_COUNTER WHERE NAME='MESSAGE_ID'
INSERT INTO JBM_COUNTER VALUES('MESSAGE_ID',20480)
COMMIT
DELETE FROM JBM_COUNTER WHERE NAME='CHANNEL_ID'
INSERT INTO JBM_COUNTER VALUES('CHANNEL_ID',50)
COMMIT
DELETE FROM JBM_COUNTER WHERE NAME='TRANSACTION_ID'
INSERT INTO JBM_COUNTER VALUES('TRANSACTION_ID',5120)
COMMIT
SET AUTOCOMMIT TRUE
drop table TAG if exists
create table TAG (ID bigint generated by default as identity (start with 1), NAME varchar(20) not null, VERSION integer, primary key (ID))
drop table TAG if exists
create table TAG (ID bigint generated by default as identity (start with 1), NAME varchar(20) not null, VERSION integer, primary key (ID))
SET AUTOCOMMIT FALSE
INSERT INTO TAG VALUES(1,'My new legal act',0)
COMMIT
|