NDBBCKUP
|uxV4 BANK ACCOUNT USING HASH (ACCOUNT_ID))
ENGINE = NDB BANK TRANSACTION TRANSACTION_TYPE INT UNSIGNED NOT NULL,
TIME BIGINT UNSIGNED NOT NULL,
AMOUNT INT UNSIGNED NOT NULL,
PRIMARY KEY USING HASH (TRANSACTION_ID,ACCOUNT))
ENGINE = NDB BANK GL LL,
WITHDRAWAL_COUNT INT UNSIGNED NOT NULL,
WITHDRAWAL_SUM INT UNSIGNED NOT NULL,
PURGED INT UNSIGNED NOT NULL,
PRIMARY KEY USING HASH (TIME,ACCOUNT_TYPE))
ENGINE = NDB k S $ z N 0u AO I: з ! +n ! { N N N IREPL$BANK/ACCOUNT_TYPE BANK/def/ACCOUNT_TYPE INDB$BLOBEVENT_REPL$cluster/schema_3 cluster/def/NDB$BLOB_2_3 IREPL$cluster/apply_status cluster/def/apply_status IREPL$BANK/GL BANK/def/GL IREPL$BANK/SYSTEM_VALUES BANK/def/SYSTEM_VALUES IREPL$BANK/ACCOUNT BANK/def/ACCOUNT a
A 3 > I S _ @# o X B p y 8 w r q & l ) % _
l % o J Q f v
d } g < "
y z : ! [
# * G j # G
$ 2 D 3 d & q" q y z k C M n ]# ! a ] | J , @ N -
' B !
N" ; x ^ 0 Z ( % #
]& 1
_ y & f {
$ t 5 ,! d t t 7 6 ? 5 ! < = < M
Z b
d # 6 ] " V } J D " " l & : l 4 D D l# e W! $ 3 C % N E _ J E / &
% m / Z y % % [ 2 ^ U $ i 8 k! F R w > I 7 4 9 # 6 E C x & i l & B f 6 7 : ! ; b n i q = u = g A
' f
W ] X _ n
0 i } / b % K b W W w / p
G ! ' > z z y Y W `
; e U
, { T $ V } =$ W r 9 x : u " A 7 " V % / : .
! U % X u z T ! % P ] [% Z $ k C B @ 2 & A w Z ] ^ ! B @ & =" i! z $ 9 X : + 6 6
) ! # : ] T w" S " f N + l #
1 J X 0 " h z @ P T Q y /" $ 4 # ` 4 Z C e M% r } z I ? #
5 V p P G \ 3 b W 7 " 8 # s = " 5 R $ o C S & H 9 C 1 q % ` < v { % " O a u " # ' = s l % 0
8 % T G _ Q p ?
. * : e" u" b z $ " < c H v % u & ! S L# c 8 x L W - L R 5 | t ( n O H B ' B 5 V $ C # F & N"
" # & $ # o J > / F 9 e 0 E " & ( " x # = ) 3 ; . D g " : I )
. % K
g " O ! M p P G Q f O - U# > D V ! O e [ M B # ' h& Z $ ` = s h ! C $ l$ X x 8 ~ W
}
6 2" z i i M% u " % C ~ " { % # E &% & t 2 i 3 =
@ b 8 % r ? $ C % 6 0
9 : w e & g . w& ) % ` 1 < T 9 ~ U $ g
t m # q > y 4 , " ) 6 ] : f {
q } Q 0
) U H
i
* & k I [% h <
j G 7# 4 ( ! a% a 5 N D < G j ( m ( ? t [ a / u
O :
" Z H L j \ h! R 6
" ; 9 A v )# q D D 0 q ! ] t N 7 J
" " d " 7 M l% t T
Y E } / S A v \& " t 7 n ' v M 6 h I! 1 { % ( k 9 C 4% ) ! ~ t! n ( K Q G / ; / U & /" ] x# o a H ^ ! a h$ j j y$ $ | , R < V D m v j 8 8 b - j X 8& u% O - 2 X x " g A O G% <
` [ W 8 Y u + 4
] : 8 6 2 D ( 3 P 3 N
<
@ P ^ $ ' ` R ` [ = ! \ & A G m a$ _ * E # F 5
M p m $ _ R S L# M "
4 _ \ + L B& ; Y F 5
M [ , @ a > 0 9 m 9 =$ ; # " X x [ ! P j z Y ^ K O - k r { `
1 ) # p d& l < ;& - I a ! = c [" F ! d l b R$ $ k + A$ e
` O 0! . F $ [ T 6 1 * u
P
j c H i C V B F K i h& # &
" ^ Q
[ w l% 9 ~ # f H ] I
B ! ( > P M
D t 3 M * C W C 5 [ 3 = a% Y . O D W
m g # B [ g 2 % z e [ ? A 9 g ! H # z
M% v } u% K E , P # } " } "# ! R 5 ~ $ K < r s
Y | o ` { M Q i
F K J [ ! q
d z | l } < 1 L ! i T & @ 9 $ V j < d z ` m & f u
h
%
p s "# . B u R < w F X Q p B @ " 6 - D " h < 4 i - \ | & _ ' & O ` j w Y 0 " Y . A t i# r ^ f$ g " _ ~ $ ! P > | T \ 6
" / i! t v j 1 w / 7 8 % C C V " E r } O D G P L
I q& X !$ %" ~ P Z : {
> j
F P } E &% u ] R = F o .! # j ~ Z ! ! > 7 _ 9 ] I
g { ^ >% (
o X 3 % ] 8 ~
V t b w < < 9 W ' "
P o
e Q M @ s
B 6 q! I y m & 3 _ o w s x ^ ! 2 { } 2 U
.$ @ r B ) ^ ~ % " o N "
" ' n
$ 3 # Q
: a D#
f A " d 8
& A$
n T x | _ _ 2 & u O [ T& V
W - D + l N p b l
a 5 ,! N z e $ n
I S f$ Y G F _ ^ 4% k )
5 R a @ M t 0 % ] " ! { 3 d " E n i e
{ } "# ; } h < b $ $ " t % 3 b& n
t Y = . B h ! & D B [ s "# K I ; N u $ [ W
a Q [ ! < z e E U t i# r 8 m O : 3 q - 5 d % H # u & j c _" j v e ? h -! 4
U y$ M ] " ; < h
V > ` C J g { e
k I! * : k < ;&
& M% # W
S n ; 3 . *
% ! j - L 9 %
< 7 D P 3 B @ % " A b& o 7 % X % 9 % 0 c / 6 & W
%
) j < 9 = % & w " N & { 0
n ' $ & N V
' T
j { Y _ x 1 w& T ) F R&
KASSA LNEKONTO W T CREATE DATABASE IF NOT EXISTS BANK default charset=latin1 default collate=latin1_bin BANK W CREATE TABLE GL ( TIME BIGINT UNSIGNED NOT NULL,
ACCOUNT_TYPE INT UNSIGNED NOT NULL,
BALANCE INT UNSIGNED NOT NULL,
DEPOSIT_COUNT INT UNSIGNED NOT NULL,
DEPOSIT_SUM INT UNSIGNED NOT NU BANK GL X ) CREATE TABLE ACCOUNT ( ACCOUNT_ID INT UNSIGNED NOT NULL,
OWNER INT UNSIGNED NOT NULL,
BALANCE INT UNSIGNED NOT NULL,
ACCOUNT_TYPE INT UNSIGNED NOT NULL,
PRIMARY KEY BANK ACCOUNT YI ? ^q
M M P P
i i a a 9 9 > > X X b b < < b b - - % % p p A A J J L L 5 5 _ _ 8 8 & & X X U U ? ? W W . . o o @ @ N N t t k k c c m m . . N N % % $ $
| | " " @ @ C C _ _ 6 6 / / v v V V y y N N 6 6 P P N N
k k 4 4 s s t t > > x x h h < < * * Y Y w w l l x x I I C C 0 0 ' ' 4 4 Y Y # # ( ( Q Q $ $ t t & & . . > > w w 7 7 6 6 C C y y H H E E B B u u h h k k I I m m v v ; ; B B } } i i W W # # & & : : z z u u f f ^ ^ Z Z > > K K A A a a \ \ } } j j N N m m ? ? M M A A v v U U 7 7 9 9 " " w w - - , , H H { { q q P P } } = = > > H H \ \ l l m m ^ ^ ` ` \ \ Q Q n n q q f f ^ ^ R R k k 4 4 B B / / e e ~ ~ O O y y F F
, , F F x x { { / / ; ; S S D D r r 4 4 j j / / S S : : } } h h E E ' ' % % \ \ B B ~ ~ ` ` 5 5 @ @ . . e e | | R R Q Q Z Z < < s s V V I I o o { { X X q q m m 6 6 o o L L c c 0 0 - - d d 0 0 r r E E 8 8 J J D D p p _ _ ] ] } } n n ] ] f f A A c c ( ( P P | | - -
A A + + l l Z Z J J Y Y 5 5 e e 4 4 y y f f m m W W E E G G D D O O # # . . # # 2 2 \ \ V V X X g g i i ] ] S S ) ) m m Y Y f f [ [ Z Z ; ; ( ( 6 6 M M z z R R 1 1 c c 0 0 = = q q + + C C c c = = > > D D H H d d 1 1 W W < < F F r r @ @ 0 0 8 8 * * : : ! ! $ $ 3 3 ( ( B B B B [ [ v v & & i i X X e e } } . . 5 5 e e ; ; 5 5 P P a a o o + + < < d d _ _ ! ! ! ! . . e e ~ ~ ( ( & & ' ' 2 2 K K 6 6 / / n n ) ) 9 9 M M { { L L h h 9 9 F F s s T T ] ] E E
M M X X 4 4 Y Y L L
7 7 X X g g ; ; U U x x q q y y } } % %
d d t t ` ` o o w w ? ? F F j j 9 9 ? ? s s x x ! ! [ [ : : i i , , a a u u M M ] ] & & f f = = ; ; & & 4 4 9 9 R R J J | | [ [ O O & & I I S S + + m m " " f f O O r r : : & & ? ? H H u u 1 1 s s \ \ ? ? ^ ^ " " C C @ @ G G H H _ _ L L * * { { p p d d E E - - s s T T V V 5 5 P P k k O O % % n n V V 6 6 k k { { Z Z ) ) 6 6 ^ ^ k k V V 9 9 X X $ $ a a h h } } R R 0 0 , , 7 7 R R H H 1 1 9 9
T T A A X X } } z z x x @ @ C C U U P P g g . . r r @ @ Y Y 7 7 O O r r _ _ H H # # q q 2 2 L L ' ' H H ` ` b b | | O O F F ' ' T T @ @ % % $ $ 7 7
, , Z Z / / u u 3 3 E E c c K K 5 5 N N 3 3 5 5 . . 8 8 A A s s , , P P W W a a M M * * | | r r # # M M ^ ^ , , / / ! ! + + v v 1 1 ( ( y y ] ] z z z z 1 1 5 5 ] ] V V ) ) - - L L _ _ + + % % o o [ [ q q > >
o o P P E E 2 2 f f u u c c i i 4 4 A A & & T T S S e e F F U U o o b b l l h h j j 4 4 K K j j ( ( C C k k 0 0 * * l l S S E E - - A A 8 8 Z Z | | d d ^ ^ 3 3 | | d d u u " " A A _ _ k k @ @ ~ ~ n n p p L L p p
l l i i " " I I R R | | % % B B Y Y ] ] Z Z h h % % u u V V X X r r W W Y Y D D H H 8 8 * * & & ` ` r r , , ] ] a a Z Z [ [ y y s s ~ ~ G G 2 2 * * ~ ~ A A - - ' ' n n N N = = V V ^ ^ 6 6 a a < < R R f f 0 0 ( ( W W W W } } U U
s s N N d d a a F F T T ' ' g g 4 4 s s
_ _ 2 2 y y y y \ \ t t ) ) 1 1 l l h h 8 8 $ $ b b \ \ o o ! ! 5 5 ' ' J J T T - - z z C C < < ? ? 9 9 q q = = F F j j t t S S [ [ w w n n ( ( . . ~ ~ O O . . K K V V M M Q Q D D > > % % ; ; k k Y Y e e z z 6 6 : : u u s s
% % 8 8 % % 0 0 4 4 S S U U G G ? ? w w ] ] 6 6 ~ ~ V V 0 0 t t H H 2 2 3 3 U U 4 4 E E " " F F \ \ i i ; ; $ $ x x P P 1 1 ~ ~ p p K K : : ( ( , , m m O O ? ? 6 6 : : R R ! ! D D [ [ 5 5 v v 4