fwdfAXi9

1"C:\Program Files\Android\Android Studio\jre\bin\java.exe" -ea -Didea.test.cyclic.buffer.size=1048576 "-javaagent:C:\Program Files\Android\Android Studio\lib\idea_rt.jar=64493:C:\Program Files\Android\Android Studio\bin" -Dfile.encoding=UTF-8 -classpath "C:\Program Files\Android\Android Studio\lib\idea_rt.jar;C:\Program Files\Android\Android Studio\plugins\junit\lib\junit-rt.jar;C:\Program Files\Android\Android Studio\plugins\junit\lib\junit5-rt.jar;C:\Program Files\Android\Android Studio\jre\jre\lib\charsets.jar;C:\Program Files\Android\Android Studio\jre\jre\lib\ext\access-bridge-64.jar;C:\Program Files\Android\Android Studio\jre\jre\lib\ext\cldrdata.jar;C:\Program Files\Android\Android Studio\jre\jre\lib\ext\dnsns.jar;C:\Program Files\Android\Android Studio\jre\jre\lib\ext\jaccess.jar;C:\Program Files\Android\Android Studio\jre\jre\lib\ext\localedata.jar;C:\Program Files\Android\Android Studio\jre\jre\lib\ext\nashorn.jar;C:\Program Files\Android\Android Studio\jre\jre\lib\ext\sunec.jar;C:\Program Files\Android\Android Studio\jre\jre\lib\ext\sunjce_provider.jar;C:\Program Files\Android\Android Studio\jre\jre\lib\ext\sunmscapi.jar;C:\Program Files\Android\Android Studio\jre\jre\lib\ext\sunpkcs11.jar;C:\Program Files\Android\Android Studio\jre\jre\lib\ext\zipfs.jar;C:\Program Files\Android\Android Studio\jre\jre\lib\jce.jar;C:\Program Files\Android\Android Studio\jre\jre\lib\jsse.jar;C:\Program Files\Android\Android Studio\jre\jre\lib\management-agent.jar;C:\Program Files\Android\Android Studio\jre\jre\lib\resources.jar;C:\Program Files\Android\Android Studio\jre\jre\lib\rt.jar;D:\github\ardor\addons\test\classes;D:\github\ardor\addons\classes;D:\github\ardor\ardor.jar;D:\github\ardor\lib\core-3.3.0.jar;D:\github\ardor\lib\h2-1.4.196.jar;D:\github\ardor\lib\javase-3.3.0.jar;D:\github\ardor\lib\weupnp-0.1.4.jar;D:\github\ardor\lib\tika-core-1.13.jar;D:\github\ardor\lib\javapoet-1.11.0.jar;D:\github\ardor\lib\slf4j-api-1.7.22.jar;D:\github\ardor\lib\commons-cli-1.3.1.jar;D:\github\ardor\lib\json-simple-1.1.1.jar;D:\github\ardor\lib\lucene-core-7.1.0.jar;D:\github\ardor\lib\tika-parsers-1.13.jar;D:\github\ardor\lib\bcprov-jdk15on-160.jar;D:\github\ardor\lib\slf4j-jdk14-1.7.22.jar;D:\github\ardor\lib\lucene-queries-7.1.0.jar;D:\github\ardor\lib\javax.servlet-api-3.1.0.jar;D:\github\ardor\lib\lucene-queryparser-7.1.0.jar;D:\github\ardor\lib\jetty-io-9.3.24.v20180605.jar;D:\github\ardor\lib\jetty-http-9.3.24.v20180605.jar;D:\github\ardor\lib\jetty-util-9.3.24.v20180605.jar;D:\github\ardor\lib\jetty-proxy-9.3.24.v20180605.jar;D:\github\ardor\lib\jetty-client-9.3.24.v20180605.jar;D:\github\ardor\lib\jetty-server-9.3.24.v20180605.jar;D:\github\ardor\lib\lucene-analyzers-common-7.1.0.jar;D:\github\ardor\lib\jetty-servlet-9.3.24.v20180605.jar;D:\github\ardor\lib\jetty-security-9.3.24.v20180605.jar;D:\github\ardor\lib\jetty-servlets-9.3.24.v20180605.jar;D:\github\ardor\lib\jetty-continuation-9.3.24.v20180605.jar;D:\github\ardor\ardor-tests.jar;D:\github\ardor\testlib\junit-4.11.jar;D:\github\ardor\testlib\hamcrest-core-1.3.jar;D:\github\ardor\testlib\websocket-api-9.3.22.v20171030.jar;D:\github\ardor\testlib\websocket-client-9.3.22.v20171030.jar;D:\github\ardor\testlib\websocket-common-9.3.22.v20171030.jar;D:\github\ardor\testlib\websocket-server-9.3.22.v20171030.jar;D:\github\ardor\testlib\websocket-servlet-9.3.22.v20171030.jar;D:\github\ardor\testlib\javafx_webview_debugger--bce7c7c2ae-1.jar;D:\github\ardor\conf" com.intellij.rt.execution.junit.JUnitStarter -ideVersion5 -junit4 com.jelurida.ardor.contracts.ContractRunnerSuite
2Initializing Nxt server version 2.2.0e
3Command line arguments
4-ea
5-Didea.test.cyclic.buffer.size=1048576
6-javaagent:C:\Program Files\Android\Android Studio\lib\idea_rt.jar=64493:C:\Program Files\Android\Android Studio\bin
7-Dfile.encoding=UTF-8
8Loading nxt-installer.properties from classpath
9javafx not supported
10isHeadless=false
11Runtime mode nxt.env.CommandLineMode
12User home folder D:\github\ardor
13Loading nxt-default.properties from classpath
14Loading nxt-installer.properties from classpath
15Loading logging-default.properties from classpath
162018-11-09 08:41:38 INFO: nxt.enableStackTraces = "true"
172018-11-09 08:41:38 INFO: nxt.enableLogTraceback = "false"
182018-11-09 08:41:38 INFO: nxt.enableLogThreadName = "true"
192018-11-09 08:41:38 INFO: main logging enabled
202018-11-09 08:41:38 INFO: main nxt.useStrongSecureRandom = "false"
212018-11-09 08:41:38 FINE: main java.version = 1.8.0_152-release
222018-11-09 08:41:38 FINE: main java.vm.version = 25.152-b06
232018-11-09 08:41:38 FINE: main java.vm.name = OpenJDK 64-Bit Server VM
242018-11-09 08:41:38 FINE: main java.vendor = JetBrains s.r.o
252018-11-09 08:41:38 FINE: main java.vm.vendor = JetBrains s.r.o
262018-11-09 08:41:38 FINE: main java.home = C:\Program Files\Android\Android Studio\jre\jre
272018-11-09 08:41:38 FINE: main java.library.path = C:\Program Files\Android\Android Studio\jre\bin;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\Program Files\NVIDIA GPU Computing Toolkit\CUDA\v10.0\bin;C:\Program Files\NVIDIA GPU Computing Toolkit\CUDA\v10.0\libnvvp;C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\Program Files (x86)\iis express\PHP\v7.1;C:\Program Files (x86)\Intel\iCLS Client\;C:\Program Files\Intel\iCLS Client\;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\NVIDIA Corporation\PhysX\Common;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files (x86)\GtkSharp\2.12\bin;C:\Program Files\PuTTY\;C:\Program Files\Git\cmd;C:\Program Files\Microsoft SQL Server\130\Tools\Binn\;C:\Program Files\Redis\;C:\Program Files\dotnet\;C:\Program Files (x86)\MySQL\MySQL Utilities 1.6\;C:\Users\ohad\AppData\Local\Microsoft\WindowsApps;C:\Program Files\Heroku\;C:\Program Files\Geth;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\WINDOWS\System32\OpenSSH\;C:\Program Files\Microsoft VS Code\bin;C:\Program Files\TortoiseGit\bin;C:\Program Files\nodejs\;C:\Users\ohad\AppData\Local\Microsoft\WindowsApps;C:\Program Files\Heroku\bin;C:\program files (x86)\microsoft visual studio\shared\python36_64;C:\program files (x86)\microsoft visual studio\shared\python36_64\Scripts;C:\Program Files\Microsoft VS Code\bin;C:\Users\ohad\AppData\Local\Microsoft\WindowsApps;D:\AppData\Roaming\npm;C:\Program Files\Docker Toolbox;C:\Program Files\Docker Toolbox;.
282018-11-09 08:41:38 FINE: main java.class.path = C:\Program Files\Android\Android Studio\lib\idea_rt.jar;C:\Program Files\Android\Android Studio\plugins\junit\lib\junit-rt.jar;C:\Program Files\Android\Android Studio\plugins\junit\lib\junit5-rt.jar;C:\Program Files\Android\Android Studio\jre\jre\lib\charsets.jar;C:\Program Files\Android\Android Studio\jre\jre\lib\ext\access-bridge-64.jar;C:\Program Files\Android\Android Studio\jre\jre\lib\ext\cldrdata.jar;C:\Program Files\Android\Android Studio\jre\jre\lib\ext\dnsns.jar;C:\Program Files\Android\Android Studio\jre\jre\lib\ext\jaccess.jar;C:\Program Files\Android\Android Studio\jre\jre\lib\ext\localedata.jar;C:\Program Files\Android\Android Studio\jre\jre\lib\ext\nashorn.jar;C:\Program Files\Android\Android Studio\jre\jre\lib\ext\sunec.jar;C:\Program Files\Android\Android Studio\jre\jre\lib\ext\sunjce_provider.jar;C:\Program Files\Android\Android Studio\jre\jre\lib\ext\sunmscapi.jar;C:\Program Files\Android\Android Studio\jre\jre\lib\ext\sunpkcs11.jar;C:\Program Files\Android\Android Studio\jre\jre\lib\ext\zipfs.jar;C:\Program Files\Android\Android Studio\jre\jre\lib\jce.jar;C:\Program Files\Android\Android Studio\jre\jre\lib\jsse.jar;C:\Program Files\Android\Android Studio\jre\jre\lib\management-agent.jar;C:\Program Files\Android\Android Studio\jre\jre\lib\resources.jar;C:\Program Files\Android\Android Studio\jre\jre\lib\rt.jar;D:\github\ardor\addons\test\classes;D:\github\ardor\addons\classes;D:\github\ardor\ardor.jar;D:\github\ardor\lib\core-3.3.0.jar;D:\github\ardor\lib\h2-1.4.196.jar;D:\github\ardor\lib\javase-3.3.0.jar;D:\github\ardor\lib\weupnp-0.1.4.jar;D:\github\ardor\lib\tika-core-1.13.jar;D:\github\ardor\lib\javapoet-1.11.0.jar;D:\github\ardor\lib\slf4j-api-1.7.22.jar;D:\github\ardor\lib\commons-cli-1.3.1.jar;D:\github\ardor\lib\json-simple-1.1.1.jar;D:\github\ardor\lib\lucene-core-7.1.0.jar;D:\github\ardor\lib\tika-parsers-1.13.jar;D:\github\ardor\lib\bcprov-jdk15on-160.jar;D:\github\ardor\lib\slf4j-jdk14-1.7.22.jar;D:\github\ardor\lib\lucene-queries-7.1.0.jar;D:\github\ardor\lib\javax.servlet-api-3.1.0.jar;D:\github\ardor\lib\lucene-queryparser-7.1.0.jar;D:\github\ardor\lib\jetty-io-9.3.24.v20180605.jar;D:\github\ardor\lib\jetty-http-9.3.24.v20180605.jar;D:\github\ardor\lib\jetty-util-9.3.24.v20180605.jar;D:\github\ardor\lib\jetty-proxy-9.3.24.v20180605.jar;D:\github\ardor\lib\jetty-client-9.3.24.v20180605.jar;D:\github\ardor\lib\jetty-server-9.3.24.v20180605.jar;D:\github\ardor\lib\lucene-analyzers-common-7.1.0.jar;D:\github\ardor\lib\jetty-servlet-9.3.24.v20180605.jar;D:\github\ardor\lib\jetty-security-9.3.24.v20180605.jar;D:\github\ardor\lib\jetty-servlets-9.3.24.v20180605.jar;D:\github\ardor\lib\jetty-continuation-9.3.24.v20180605.jar;D:\github\ardor\ardor-tests.jar;D:\github\ardor\testlib\junit-4.11.jar;D:\github\ardor\testlib\hamcrest-core-1.3.jar;D:\github\ardor\testlib\websocket-api-9.3.22.v20171030.jar;D:\github\ardor\testlib\websocket-client-9.3.22.v20171030.jar;D:\github\ardor\testlib\websocket-common-9.3.22.v20171030.jar;D:\github\ardor\testlib\websocket-server-9.3.22.v20171030.jar;D:\github\ardor\testlib\websocket-servlet-9.3.22.v20171030.jar;D:\github\ardor\testlib\javafx_webview_debugger--bce7c7c2ae-1.jar;D:\github\ardor\conf;C:\Program Files\Android\Android Studio\lib\idea_rt.jar
292018-11-09 08:41:38 FINE: main os.arch = amd64
302018-11-09 08:41:38 FINE: main sun.arch.data.model = 64
312018-11-09 08:41:38 FINE: main os.name = Windows 10
322018-11-09 08:41:38 FINE: main file.encoding = UTF-8
332018-11-09 08:41:38 FINE: main java.security.policy = null
342018-11-09 08:41:38 FINE: main java.security.manager = null
352018-11-09 08:41:38 FINE: main nxt.runtime.mode = null
362018-11-09 08:41:38 FINE: main nxt.runtime.dirProvider = null
372018-11-09 08:41:38 FINE: main availableProcessors = 8
382018-11-09 08:41:38 FINE: main maxMemory = 1883242496
392018-11-09 08:41:38 FINE: main processId = 11736
402018-11-09 08:41:38 INFO: main nxt.isTestnet = "true"
412018-11-09 08:41:38 INFO: main nxt.isOffline = "true"
422018-11-09 08:41:38 INFO: main nxt.isLightClient = "true"
432018-11-09 08:41:38 INFO: main nxt.isPermissioned = "false"
442018-11-09 08:41:38 INFO: main nxt.isAutomatedTest = "true"
452018-11-09 08:41:38 INFO: main nxt.customLoginWarning not defined
462018-11-09 08:41:38 INFO: main nxt.maxRollback = "800"
472018-11-09 08:41:38 INFO: main nxt.testnetGuaranteedBalanceConfirmations = "1"
482018-11-09 08:41:38 INFO: main nxt.testnetLeasingDelay = "2"
492018-11-09 08:41:38 INFO: main nxt.forgingDelay = "10"
502018-11-09 08:41:38 INFO: main nxt.forgingSpeedup = "3"
512018-11-09 08:41:38 INFO: main nxt.batchCommitSize = "100"
522018-11-09 08:41:38 INFO: main nxt.maxPrunableLifetime = "7776000"
532018-11-09 08:41:38 INFO: main nxt.includeExpiredPrunable = "true"
542018-11-09 08:41:38 INFO: main nxt.correctInvalidFees = "false"
552018-11-09 08:41:38 INFO: main nxt.statementLogThreshold = "10000"
562018-11-09 08:41:38 INFO: main nxt.transactionLogThreshold = "15000"
572018-11-09 08:41:38 INFO: main nxt.transactionLogInterval = "15"
582018-11-09 08:41:38 INFO: main nxt.dbCacheKB = "0"
592018-11-09 08:41:38 INFO: main nxt.testDbUrl not defined
602018-11-09 08:41:38 INFO: main nxt.testDbType = "h2"
612018-11-09 08:41:38 INFO: main nxt.testDbDir = "./nxt_unit_test_db/nxt"
622018-11-09 08:41:38 INFO: main nxt.testDbParams = "DB_CLOSE_ON_EXIT=FALSE;MVCC=TRUE;MV_STORE=FALSE"
632018-11-09 08:41:38 INFO: main nxt.testDbUsername = "sa"
642018-11-09 08:41:38 INFO: main nxt.testDbPassword = "{not logged}"
652018-11-09 08:41:38 INFO: main nxt.maxDbConnections = "30"
662018-11-09 08:41:38 INFO: main nxt.dbLoginTimeout = "70"
672018-11-09 08:41:38 INFO: main nxt.dbDefaultLockTimeout = "60"
682018-11-09 08:41:38 INFO: main nxt.dbMaxMemoryRows = "1000000"
692018-11-09 08:41:38 INFO: main nxt.adminPassword not defined
702018-11-09 08:41:38 INFO: main nxt.maxAPIRecords = "100"
712018-11-09 08:41:38 INFO: main nxt.enableAPIUPnP = "false"
722018-11-09 08:41:38 INFO: main nxt.apiServerIdleTimeout = "30000"
732018-11-09 08:41:38 INFO: main nxt.apiServerCORS = "true"
742018-11-09 08:41:38 INFO: main nxt.forwardedForHeader not defined
752018-11-09 08:41:38 INFO: main nxt.disabledAPIs not defined
762018-11-09 08:41:38 INFO: main nxt.disabledAPITags not defined
772018-11-09 08:41:38 INFO: main nxt.allowedBotHosts = "127.0.0.1; localhost; [0:0:0:0:0:0:0:1];"
782018-11-09 08:41:38 INFO: main nxt.enableAPIServer = "true"
792018-11-09 08:41:38 INFO: main nxt.apiServerHost = "127.0.0.1"
802018-11-09 08:41:38 INFO: main nxt.disableAdminPassword = "true"
812018-11-09 08:41:38 INFO: main nxt.apiSSL = "false"
822018-11-09 08:41:38 INFO: main API server using HTTP port 26875
832018-11-09 08:41:38 INFO: main nxt.apiResourceBase = "./html/www"
842018-11-09 08:41:38 INFO: main nxt.apiWelcomeFile = "index.html"
852018-11-09 08:41:38 INFO: main nxt.javadocResourceBase = "./html/doc"
862018-11-09 08:41:38 INFO: main nxt.maxUploadFileSize not defined or not numeric, using default value 0
872018-11-09 08:41:38 INFO: main nxt.maxUploadFileSize not defined or not numeric, using default value 0
882018-11-09 08:41:38 INFO: main nxt.enableAPIServerGZIPFilter not defined, using default false
892018-11-09 08:41:38 INFO: main nxt.apiFrameOptionsSameOrigin = "true"
902018-11-09 08:41:38 INFO: main nxt.trimDerivedTables = "true"
912018-11-09 08:41:38 INFO: main nxt.testnetNumberOfForkConfirmations = "2"
922018-11-09 08:41:38 INFO: main nxt.simulateEndlessDownload not defined, using default false
932018-11-09 08:41:38 INFO: main nxt.trimFrequency = "1000"
942018-11-09 08:41:38 INFO: main nxt.processPolls = "true"
952018-11-09 08:41:38 INFO: main nxt.deleteFinishedShufflings = "false"
962018-11-09 08:41:38 FINE: main Database jdbc url set to jdbc:h2:./nxt_unit_test_db/nxt;DB_CLOSE_ON_EXIT=FALSE;MVCC=TRUE;MV_STORE=FALSE;CACHE_SIZE=262144 username sa
972018-11-09 08:41:39 FINE: main Database connection pool current size: 1
982018-11-09 08:41:39 INFO: main Initializing an empty database
992018-11-09 08:41:39 FINE: main Database connection pool current size: 2
1002018-11-09 08:41:39 FINE: main Will apply sql:
101CREATE TABLE IF NOT EXISTS block (db_id IDENTITY, id BIGINT NOT NULL, version INT NOT NULL, timestamp INT NOT NULL, previous_block_id BIGINT, total_fee BIGINT NOT NULL, previous_block_hash BINARY(32), cumulative_difficulty VARBINARY NOT NULL, base_target BIGINT NOT NULL, next_block_id BIGINT, height INT NOT NULL, generation_signature BINARY(64) NOT NULL, block_signature BINARY(64) NOT NULL, payload_hash BINARY(32) NOT NULL, generator_id BIGINT NOT NULL)
1022018-11-09 08:41:39 FINE: main Will apply sql:
103CREATE UNIQUE INDEX IF NOT EXISTS block_id_idx ON block (id)
1042018-11-09 08:41:39 FINE: main Will apply sql:
105CREATE TABLE IF NOT EXISTS transaction_fxt (db_id IDENTITY, id BIGINT NOT NULL, deadline SMALLINT NOT NULL, recipient_id BIGINT, transaction_index SMALLINT NOT NULL, amount BIGINT NOT NULL, fee BIGINT NOT NULL, full_hash BINARY(32) NOT NULL, height INT NOT NULL, block_id BIGINT NOT NULL, FOREIGN KEY (block_id) REFERENCES block (id) ON DELETE CASCADE, signature BINARY(64) NOT NULL, timestamp INT NOT NULL, type TINYINT NOT NULL, subtype TINYINT NOT NULL, sender_id BIGINT NOT NULL, block_timestamp INT NOT NULL, has_prunable_attachment BOOLEAN NOT NULL DEFAULT FALSE, has_prunable_message BOOLEAN NOT NULL DEFAULT FALSE, has_prunable_encrypted_message BOOLEAN NOT NULL DEFAULT FALSE, ec_block_height INT DEFAULT NULL, ec_block_id BIGINT DEFAULT NULL, attachment_bytes VARBINARY, version TINYINT NOT NULL)
1062018-11-09 08:41:39 FINE: main Will apply sql:
107CREATE UNIQUE INDEX IF NOT EXISTS transaction_fxt_id_idx ON transaction_fxt (id)
1082018-11-09 08:41:39 FINE: main Will apply sql:
109CREATE UNIQUE INDEX IF NOT EXISTS block_height_idx ON block (height)
1102018-11-09 08:41:39 FINE: main Will apply sql:
111CREATE INDEX IF NOT EXISTS block_generator_id_idx ON block (generator_id)
1122018-11-09 08:41:39 FINE: main Will apply sql:
113CREATE INDEX IF NOT EXISTS transaction_fxt_sender_id_idx ON transaction_fxt (sender_id)
1142018-11-09 08:41:39 FINE: main Will apply sql:
115CREATE INDEX IF NOT EXISTS transaction_fxt_recipient_id_idx ON transaction_fxt (recipient_id)
1162018-11-09 08:41:39 FINE: main Will apply sql:
117CREATE TABLE IF NOT EXISTS peer (address VARCHAR PRIMARY KEY, last_updated INT, services BIGINT)
1182018-11-09 08:41:39 FINE: main Will apply sql:
119CREATE INDEX IF NOT EXISTS transaction_fxt_block_timestamp_idx ON transaction_fxt (block_timestamp DESC)
1202018-11-09 08:41:39 FINE: main Will apply sql:
121CREATE TABLE IF NOT EXISTS account (db_id IDENTITY, id BIGINT NOT NULL, has_control_phasing BOOLEAN NOT NULL DEFAULT FALSE, forged_balance BIGINT NOT NULL, active_lessee_id BIGINT, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
1222018-11-09 08:41:39 FINE: main Will apply sql:
123CREATE UNIQUE INDEX IF NOT EXISTS account_id_height_idx ON account (id, height DESC)
1242018-11-09 08:41:39 FINE: main Will apply sql:
125CREATE TABLE IF NOT EXISTS account_asset (db_id IDENTITY, account_id BIGINT NOT NULL, asset_id BIGINT NOT NULL, quantity BIGINT NOT NULL, unconfirmed_quantity BIGINT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
1262018-11-09 08:41:39 FINE: main Will apply sql:
127CREATE UNIQUE INDEX IF NOT EXISTS account_asset_id_height_idx ON account_asset (account_id, asset_id, height DESC)
1282018-11-09 08:41:39 FINE: main Will apply sql:
129CREATE TABLE IF NOT EXISTS account_guaranteed_balance (db_id IDENTITY, account_id BIGINT NOT NULL, additions BIGINT NOT NULL, height INT NOT NULL)
1302018-11-09 08:41:39 FINE: main Will apply sql:
131CREATE UNIQUE INDEX IF NOT EXISTS account_guaranteed_balance_id_height_idx ON account_guaranteed_balance (account_id, height DESC)
1322018-11-09 08:41:39 FINE: main Will apply sql:
133CREATE TABLE IF NOT EXISTS unconfirmed_transaction (db_id IDENTITY, id BIGINT NOT NULL, expiration INT NOT NULL, transaction_height INT NOT NULL, fee BIGINT NOT NULL, fee_per_byte BIGINT NOT NULL, arrival_timestamp BIGINT NOT NULL, is_bundled BOOLEAN NOT NULL DEFAULT FALSE, transaction_bytes VARBINARY NOT NULL, chain_id INT NOT NULL, height INT NOT NULL)
1342018-11-09 08:41:39 FINE: main Will apply sql:
135CREATE UNIQUE INDEX IF NOT EXISTS unconfirmed_transaction_id_idx ON unconfirmed_transaction (id)
1362018-11-09 08:41:39 FINE: main Will apply sql:
137CREATE INDEX IF NOT EXISTS account_asset_quantity_idx ON account_asset (quantity DESC)
1382018-11-09 08:41:39 FINE: main Will apply sql:
139CREATE UNIQUE INDEX IF NOT EXISTS block_timestamp_idx ON block (timestamp DESC)
1402018-11-09 08:41:39 FINE: main Will apply sql:
141CREATE TABLE IF NOT EXISTS account_currency (db_id IDENTITY, account_id BIGINT NOT NULL, currency_id BIGINT NOT NULL, units BIGINT NOT NULL, unconfirmed_units BIGINT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
1422018-11-09 08:41:39 FINE: main Will apply sql:
143CREATE UNIQUE INDEX IF NOT EXISTS account_currency_id_height_idx ON account_currency (account_id, currency_id, height DESC)
1442018-11-09 08:41:39 FINE: main Will apply sql:
145CREATE INDEX IF NOT EXISTS account_currency_units_idx ON account_currency (units DESC)
1462018-11-09 08:41:39 FINE: main Will apply sql:
147CREATE INDEX IF NOT EXISTS unconfirmed_transaction_chain_id_idx ON unconfirmed_transaction (chain_id)
1482018-11-09 08:41:39 FINE: main Will apply sql:
149CREATE TABLE IF NOT EXISTS scan (rescan BOOLEAN NOT NULL DEFAULT FALSE, height INT NOT NULL DEFAULT 0, validate BOOLEAN NOT NULL DEFAULT FALSE)
1502018-11-09 08:41:39 FINE: main Will apply sql:
151INSERT INTO scan (rescan, height, validate) VALUES (false, 0, false)
1522018-11-09 08:41:39 FINE: main Will apply sql:
153CREATE TABLE IF NOT EXISTS public_key (db_id IDENTITY, account_id BIGINT NOT NULL, public_key BINARY(32), height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
1542018-11-09 08:41:39 FINE: main Will apply sql:
155CREATE INDEX IF NOT EXISTS account_guaranteed_balance_height_idx ON account_guaranteed_balance(height)
1562018-11-09 08:41:39 FINE: main Will apply sql:
157CREATE TABLE IF NOT EXISTS account_info (db_id IDENTITY, account_id BIGINT NOT NULL, name VARCHAR, description VARCHAR, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
1582018-11-09 08:41:39 FINE: main Will apply sql:
159CREATE UNIQUE INDEX IF NOT EXISTS account_info_id_height_idx ON account_info (account_id, height DESC)
1602018-11-09 08:41:39 FINE: main Will apply sql:
161CREATE INDEX IF NOT EXISTS account_active_lessee_id_idx ON account (active_lessee_id)
1622018-11-09 08:41:39 FINE: main Will apply sql:
163CREATE TABLE IF NOT EXISTS account_lease (db_id IDENTITY, lessor_id BIGINT NOT NULL, current_leasing_height_from INT, current_leasing_height_to INT, current_lessee_id BIGINT, next_leasing_height_from INT, next_leasing_height_to INT, next_lessee_id BIGINT, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
1642018-11-09 08:41:39 FINE: main Will apply sql:
165CREATE UNIQUE INDEX IF NOT EXISTS account_lease_lessor_id_height_idx ON account_lease (lessor_id, height DESC)
1662018-11-09 08:41:39 FINE: main Will apply sql:
167CREATE INDEX IF NOT EXISTS account_lease_current_leasing_height_from_idx ON account_lease (current_leasing_height_from)
1682018-11-09 08:41:39 FINE: main Will apply sql:
169CREATE INDEX IF NOT EXISTS account_lease_current_leasing_height_to_idx ON account_lease (current_leasing_height_to)
1702018-11-09 08:41:39 FINE: main Will apply sql:
171CREATE INDEX IF NOT EXISTS account_lease_height_id_idx ON account_lease (height, lessor_id)
1722018-11-09 08:41:39 FINE: main Will apply sql:
173CREATE INDEX IF NOT EXISTS account_asset_asset_id_idx ON account_asset (asset_id)
1742018-11-09 08:41:39 FINE: main Will apply sql:
175CREATE INDEX IF NOT EXISTS account_currency_currency_id_idx ON account_currency (currency_id)
1762018-11-09 08:41:39 FINE: main Will apply sql:
177CREATE INDEX IF NOT EXISTS unconfirmed_transaction_expiration_idx ON unconfirmed_transaction (expiration DESC)
1782018-11-09 08:41:39 FINE: main Will apply sql:
179CREATE INDEX IF NOT EXISTS account_height_id_idx ON account (height, id)
1802018-11-09 08:41:39 FINE: main Will apply sql:
181CREATE INDEX IF NOT EXISTS account_asset_height_id_idx ON account_asset (height, account_id, asset_id)
1822018-11-09 08:41:39 FINE: main Will apply sql:
183CREATE INDEX IF NOT EXISTS account_currency_height_id_idx ON account_currency (height, account_id, currency_id)
1842018-11-09 08:41:39 FINE: main Will apply sql:
185CREATE INDEX IF NOT EXISTS account_info_height_id_idx ON account_info (height, account_id)
1862018-11-09 08:41:39 FINE: main Will apply sql:
187CREATE TABLE IF NOT EXISTS account_ledger (db_id IDENTITY, account_id BIGINT NOT NULL, event_type TINYINT NOT NULL, event_id BIGINT NOT NULL, event_hash BINARY(32), chain_id INT NOT NULL, holding_type TINYINT NOT NULL, holding_id BIGINT, change BIGINT NOT NULL, balance BIGINT NOT NULL, block_id BIGINT NOT NULL, height INT NOT NULL, timestamp INT NOT NULL)
1882018-11-09 08:41:39 FINE: main Will apply sql:
189CREATE INDEX IF NOT EXISTS account_ledger_id_idx ON account_ledger(account_id, db_id)
1902018-11-09 08:41:39 FINE: main Will apply sql:
191CREATE INDEX IF NOT EXISTS account_ledger_height_idx ON account_ledger(height)
1922018-11-09 08:41:39 INFO: main Lucene search index deleted
1932018-11-09 08:41:39 INFO: main H2 fulltext function aliases dropped
1942018-11-09 08:41:39 INFO: main NRS fulltext schema created
1952018-11-09 08:41:39 INFO: main Rebuilding the Lucene search index
1962018-11-09 08:41:39 INFO: main Lucene search index deleted
1972018-11-09 08:41:39 INFO: main Lucene search index successfully rebuilt
1982018-11-09 08:41:39 INFO: main NRS fulltext aliases created
1992018-11-09 08:41:39 FINE: main Will apply sql:
200CREATE TABLE IF NOT EXISTS account_control_phasing (db_id IDENTITY, account_id BIGINT NOT NULL, whitelist ARRAY, voting_model TINYINT NOT NULL, quorum BIGINT, expression VARCHAR, min_balance BIGINT, holding_id BIGINT, min_balance_model TINYINT, max_fees_chains ARRAY, max_fees ARRAY, min_duration SMALLINT, max_duration SMALLINT, sender_property_setter_id BIGINT, sender_property_name VARCHAR, sender_property_value VARCHAR, recipient_property_setter_id BIGINT, recipient_property_name VARCHAR, recipient_property_value VARCHAR, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
2012018-11-09 08:41:39 FINE: main Will apply sql:
202CREATE UNIQUE INDEX IF NOT EXISTS account_control_phasing_id_height_idx ON account_control_phasing (account_id, height DESC)
2032018-11-09 08:41:39 FINE: main Will apply sql:
204CREATE INDEX IF NOT EXISTS account_control_phasing_height_id_idx ON account_control_phasing (height, account_id)
2052018-11-09 08:41:39 FINE: main Will apply sql:
206CREATE TABLE IF NOT EXISTS account_property (db_id IDENTITY, id BIGINT NOT NULL, recipient_id BIGINT NOT NULL, setter_id BIGINT, property VARCHAR NOT NULL, value VARCHAR, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
2072018-11-09 08:41:39 FINE: main Will apply sql:
208CREATE UNIQUE INDEX IF NOT EXISTS account_property_id_height_idx ON account_property (id, height DESC)
2092018-11-09 08:41:39 FINE: main Will apply sql:
210CREATE INDEX IF NOT EXISTS account_property_height_id_idx ON account_property (height, id)
2112018-11-09 08:41:39 FINE: main Will apply sql:
212CREATE INDEX IF NOT EXISTS account_property_recipient_height_idx ON account_property (recipient_id, height DESC)
2132018-11-09 08:41:39 FINE: main Will apply sql:
214CREATE INDEX IF NOT EXISTS account_property_setter_recipient_idx ON account_property (setter_id, recipient_id)
2152018-11-09 08:41:39 FINE: main Will apply sql:
216CREATE TABLE IF NOT EXISTS asset (db_id IDENTITY, id BIGINT NOT NULL, account_id BIGINT NOT NULL, name VARCHAR NOT NULL, description VARCHAR, quantity BIGINT NOT NULL, decimals TINYINT NOT NULL, has_control_phasing BOOLEAN NOT NULL DEFAULT FALSE, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
2172018-11-09 08:41:39 FINE: main Will apply sql:
218CREATE INDEX IF NOT EXISTS asset_account_id_idx ON asset (account_id)
2192018-11-09 08:41:39 FINE: main Will apply sql:
220CREATE UNIQUE INDEX IF NOT EXISTS asset_id_height_idx ON asset (id, height DESC)
2212018-11-09 08:41:39 FINE: main Will apply sql:
222CREATE INDEX IF NOT EXISTS asset_height_id_idx ON asset (height, id)
2232018-11-09 08:41:39 FINE: main Will apply sql:
224CREATE TABLE IF NOT EXISTS asset_history (db_id IDENTITY, id BIGINT NOT NULL, full_hash BINARY(32) NOT NULL, asset_id BIGINT NOT NULL, account_id BIGINT NOT NULL, quantity BIGINT NOT NULL, timestamp INT NOT NULL, chain_id INT NOT NULL, height INT NOT NULL)
2252018-11-09 08:41:39 FINE: main Will apply sql:
226CREATE INDEX IF NOT EXISTS asset_history_id_idx ON asset_history (id)
2272018-11-09 08:41:39 FINE: main Will apply sql:
228CREATE INDEX IF NOT EXISTS asset_history_asset_id_idx ON asset_history (asset_id, height DESC)
2292018-11-09 08:41:39 FINE: main Will apply sql:
230CREATE INDEX IF NOT EXISTS asset_history_account_id_idx ON asset_history (account_id, height DESC)
2312018-11-09 08:41:39 FINE: main Will apply sql:
232CREATE INDEX IF NOT EXISTS asset_history_height_idx ON asset_history (height)
2332018-11-09 08:41:39 FINE: main Will apply sql:
234CREATE TABLE IF NOT EXISTS asset_transfer (db_id IDENTITY, id BIGINT NOT NULL, full_hash BINARY(32) NOT NULL, asset_id BIGINT NOT NULL, sender_id BIGINT NOT NULL, recipient_id BIGINT NOT NULL, quantity BIGINT NOT NULL, timestamp INT NOT NULL, chain_id INT NOT NULL, height INT NOT NULL)
2352018-11-09 08:41:39 FINE: main Will apply sql:
236CREATE INDEX IF NOT EXISTS asset_transfer_id_idx ON asset_transfer (id)
2372018-11-09 08:41:39 FINE: main Will apply sql:
238CREATE INDEX IF NOT EXISTS asset_transfer_asset_id_idx ON asset_transfer (asset_id, height DESC)
2392018-11-09 08:41:39 FINE: main Will apply sql:
240CREATE INDEX IF NOT EXISTS asset_transfer_sender_id_idx ON asset_transfer (sender_id, height DESC)
2412018-11-09 08:41:39 FINE: main Will apply sql:
242CREATE INDEX IF NOT EXISTS asset_transfer_recipient_id_idx ON asset_transfer (recipient_id, height DESC)
2432018-11-09 08:41:39 FINE: main Will apply sql:
244CREATE INDEX IF NOT EXISTS asset_transfer_height_idx ON asset_transfer (height)
2452018-11-09 08:41:39 FINE: main Will apply sql:
246CREATE TABLE IF NOT EXISTS currency (db_id IDENTITY, id BIGINT NOT NULL, account_id BIGINT NOT NULL, name VARCHAR NOT NULL, name_lower VARCHAR NOT NULL, code VARCHAR NOT NULL, description VARCHAR, type INT NOT NULL, chain INT NOT NULL, initial_supply BIGINT NOT NULL DEFAULT 0, reserve_supply BIGINT NOT NULL, max_supply BIGINT NOT NULL, creation_height INT NOT NULL, issuance_height INT NOT NULL, min_reserve_per_unit_nqt BIGINT NOT NULL, min_difficulty TINYINT NOT NULL, max_difficulty TINYINT NOT NULL, ruleset TINYINT NOT NULL, algorithm TINYINT NOT NULL, decimals TINYINT NOT NULL DEFAULT 0, is_deleted BOOLEAN NOT NULL DEFAULT FALSE, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
2472018-11-09 08:41:39 FINE: main Will apply sql:
248CREATE UNIQUE INDEX IF NOT EXISTS currency_id_height_idx ON currency (id, height DESC)
2492018-11-09 08:41:39 FINE: main Will apply sql:
250CREATE INDEX IF NOT EXISTS currency_account_id_idx ON currency (account_id)
2512018-11-09 08:41:39 FINE: main Will apply sql:
252CREATE INDEX IF NOT EXISTS currency_name_idx ON currency (name_lower, chain, height DESC)
2532018-11-09 08:41:39 FINE: main Will apply sql:
254CREATE INDEX IF NOT EXISTS currency_code_idx ON currency (code, chain, height DESC)
2552018-11-09 08:41:39 FINE: main Will apply sql:
256CREATE INDEX IF NOT EXISTS currency_creation_height_idx ON currency (creation_height DESC)
2572018-11-09 08:41:39 FINE: main Will apply sql:
258CREATE INDEX IF NOT EXISTS currency_issuance_height_idx ON currency (issuance_height)
2592018-11-09 08:41:39 FINE: main Will apply sql:
260CREATE INDEX IF NOT EXISTS currency_height_id_idx ON currency (height, id)
2612018-11-09 08:41:39 FINE: main Will apply sql:
262CREATE TABLE IF NOT EXISTS currency_supply (db_id IDENTITY, id BIGINT NOT NULL, current_supply BIGINT NOT NULL, current_reserve_per_unit_nqt BIGINT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
2632018-11-09 08:41:39 FINE: main Will apply sql:
264CREATE UNIQUE INDEX IF NOT EXISTS currency_supply_id_height_idx ON currency_supply (id, height DESC)
2652018-11-09 08:41:39 FINE: main Will apply sql:
266CREATE INDEX IF NOT EXISTS currency_supply_height_id_idx ON currency_supply (height, id)
2672018-11-09 08:41:39 FINE: main Will apply sql:
268CREATE TABLE IF NOT EXISTS phasing_poll_finish (db_id IDENTITY, transaction_id BIGINT NOT NULL, full_hash BINARY(32) NOT NULL, chain_id INT NOT NULL, finish_height INT NOT NULL, height INT NOT NULL)
2692018-11-09 08:41:39 FINE: main Will apply sql:
270CREATE INDEX IF NOT EXISTS phasing_poll_finish_finish_height_idx ON phasing_poll_finish (finish_height)
2712018-11-09 08:41:39 FINE: main Will apply sql:
272CREATE INDEX IF NOT EXISTS phasing_poll_finish_height_idx ON phasing_poll_finish (height)
2732018-11-09 08:41:39 FINE: main Will apply sql:
274CREATE TABLE IF NOT EXISTS currency_mint (db_id IDENTITY, currency_id BIGINT NOT NULL, account_id BIGINT NOT NULL, counter BIGINT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
2752018-11-09 08:41:39 FINE: main Will apply sql:
276CREATE UNIQUE INDEX IF NOT EXISTS currency_mint_currency_id_account_id_idx ON currency_mint (currency_id, account_id, height DESC)
2772018-11-09 08:41:39 FINE: main Will apply sql:
278CREATE INDEX IF NOT EXISTS currency_mint_height_id_idx ON currency_mint (height, currency_id, account_id)
2792018-11-09 08:41:39 FINE: main Will apply sql:
280CREATE TABLE IF NOT EXISTS currency_transfer (db_id IDENTITY, id BIGINT NOT NULL, full_hash BINARY(32) NOT NULL, currency_id BIGINT NOT NULL, sender_id BIGINT NOT NULL, recipient_id BIGINT NOT NULL, units BIGINT NOT NULL, timestamp INT NOT NULL, chain_id INT NOT NULL, height INT NOT NULL)
2812018-11-09 08:41:39 FINE: main Will apply sql:
282CREATE INDEX IF NOT EXISTS currency_transfer_id_idx ON currency_transfer (id)
2832018-11-09 08:41:39 FINE: main Will apply sql:
284CREATE INDEX IF NOT EXISTS currency_transfer_currency_id_idx ON currency_transfer (currency_id, height DESC)
2852018-11-09 08:41:39 FINE: main Will apply sql:
286CREATE INDEX IF NOT EXISTS currency_transfer_sender_id_idx ON currency_transfer (sender_id, height DESC)
2872018-11-09 08:41:39 FINE: main Will apply sql:
288CREATE INDEX IF NOT EXISTS currency_transfer_recipient_id_idx ON currency_transfer (recipient_id, height DESC)
2892018-11-09 08:41:39 FINE: main Will apply sql:
290CREATE INDEX IF NOT EXISTS currency_transfer_height_idx ON currency_transfer(height)
2912018-11-09 08:41:39 FINE: main Will apply sql:
292CREATE INDEX IF NOT EXISTS phasing_poll_finish_id_idx ON phasing_poll_finish (transaction_id)
2932018-11-09 08:41:39 FINE: main Will apply sql:
294CREATE TABLE IF NOT EXISTS phasing_poll_linked_transaction (db_id IDENTITY, chain_id INT NOT NULL, transaction_id BIGINT NOT NULL, transaction_full_hash BINARY(32) NOT NULL, linked_chain_id INT NOT NULL, linked_full_hash BINARY(32) NOT NULL, linked_transaction_id BIGINT NOT NULL, sub_poll_name VARCHAR, height INT NOT NULL)
2952018-11-09 08:41:39 FINE: main Will apply sql:
296CREATE INDEX IF NOT EXISTS phasing_poll_linked_transaction_id_link_idx ON phasing_poll_linked_transaction (transaction_id, linked_transaction_id)
2972018-11-09 08:41:39 FINE: main Will apply sql:
298CREATE INDEX IF NOT EXISTS phasing_poll_linked_transaction_height_idx ON phasing_poll_linked_transaction (height)
2992018-11-09 08:41:39 FINE: main Will apply sql:
300CREATE INDEX IF NOT EXISTS phasing_poll_linked_transaction_link_id_idx ON phasing_poll_linked_transaction (linked_transaction_id, transaction_id)
3012018-11-09 08:41:39 FINE: main Will apply sql:
302CREATE TABLE IF NOT EXISTS balance_fxt (db_id IDENTITY, account_id BIGINT NOT NULL, balance BIGINT NOT NULL, unconfirmed_balance BIGINT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
3032018-11-09 08:41:39 FINE: main Will apply sql:
304CREATE UNIQUE INDEX IF NOT EXISTS balance_fxt_id_height_idx ON balance_fxt (account_id, height DESC)
3052018-11-09 08:41:39 FINE: main Will apply sql:
306CREATE INDEX IF NOT EXISTS balance_fxt_height_id_idx ON balance_fxt (height, account_id)
3072018-11-09 08:41:39 FINE: main Will apply sql:
308CREATE TABLE IF NOT EXISTS coin_order_fxt (db_id IDENTITY, id BIGINT NOT NULL,account_id BIGINT NOT NULL, chain_id INT NOT NULL, exchange_id INT NOT NULL, full_hash BINARY(32) NOT NULL, amount BIGINT NOT NULL, quantity BIGINT NOT NULL, bid_price BIGINT NOT NULL, ask_price BIGINT NOT NULL, creation_height INT NOT NULL, height INT NOT NULL, transaction_height INT NOT NULL, transaction_index SMALLINT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
3092018-11-09 08:41:39 FINE: main Will apply sql:
310CREATE INDEX IF NOT EXISTS coin_order_fxt_id_idx ON coin_order_fxt (id, height DESC)
3112018-11-09 08:41:39 FINE: main Will apply sql:
312CREATE INDEX IF NOT EXISTS coin_order_fxt_chain_idx ON coin_order_fxt (chain_id, exchange_id)
3132018-11-09 08:41:39 FINE: main Will apply sql:
314CREATE INDEX IF NOT EXISTS coin_order_fxt_exchange_idx ON coin_order_fxt (exchange_id)
3152018-11-09 08:41:39 FINE: main Will apply sql:
316CREATE INDEX IF NOT EXISTS coin_order_fxt_account_idx ON coin_order_fxt (account_id)
3172018-11-09 08:41:39 FINE: main Will apply sql:
318CREATE TABLE IF NOT EXISTS coin_trade_fxt (db_id IDENTITY, chain_id INT NOT NULL, exchange_id INT NOT NULL, account_id BIGINT NOT NULL, block_id BIGINT NOT NULL, height INT NOT NULL, timestamp INT NOT NULL, exchange_quantity BIGINT NOT NULL, exchange_price BINARY(16) NOT NULL, order_id BIGINT NOT NULL, order_full_hash BINARY(32) NOT NULL, match_id BIGINT NOT NULL, match_full_hash BINARY(32) NOT NULL)
3192018-11-09 08:41:39 FINE: main Will apply sql:
320CREATE INDEX IF NOT EXISTS coin_trade_fxt_chain_idx ON coin_trade_fxt (chain_id)
3212018-11-09 08:41:39 FINE: main Will apply sql:
322CREATE INDEX IF NOT EXISTS coin_trade_fxt_exchange_idx ON coin_trade_fxt (exchange_id)
3232018-11-09 08:41:39 FINE: main Will apply sql:
324CREATE INDEX IF NOT EXISTS coin_trade_fxt_account_idx ON coin_trade_fxt (account_id)
3252018-11-09 08:41:39 FINE: main Will apply sql:
326CREATE INDEX IF NOT EXISTS coin_trade_fxt_order_idx ON coin_trade_fxt (order_id)
3272018-11-09 08:41:39 FINE: main Will apply sql:
328CREATE UNIQUE INDEX IF NOT EXISTS public_key_account_id_height_idx ON public_key (account_id, height DESC)
3292018-11-09 08:41:39 FINE: main Will apply sql:
330CREATE TABLE IF NOT EXISTS phasing_poll_result (db_id IDENTITY, id BIGINT NOT NULL, full_hash BINARY(32) NOT NULL, chain_id INT NOT NULL, result BIGINT NOT NULL, approved BOOLEAN NOT NULL, height INT NOT NULL)
3312018-11-09 08:41:39 FINE: main Will apply sql:
332CREATE INDEX IF NOT EXISTS phasing_poll_result_id_idx ON phasing_poll_result(id)
3332018-11-09 08:41:39 FINE: main Will apply sql:
334CREATE INDEX IF NOT EXISTS phasing_poll_result_height_idx ON phasing_poll_result(height)
3352018-11-09 08:41:39 FINE: main Will apply sql:
336CREATE TABLE IF NOT EXISTS prunable_message (db_id IDENTITY, id BIGINT NOT NULL, full_hash BINARY(32) NOT NULL, sender_id BIGINT NOT NULL, recipient_id BIGINT, message VARBINARY, message_is_text BOOLEAN NOT NULL, is_compressed BOOLEAN NOT NULL, encrypted_message VARBINARY, encrypted_is_text BOOLEAN DEFAULT FALSE, block_timestamp INT NOT NULL, transaction_timestamp INT NOT NULL, height INT NOT NULL)
3372018-11-09 08:41:39 FINE: main Will apply sql:
338CREATE INDEX IF NOT EXISTS prunable_message_id_idx ON prunable_message (id)
3392018-11-09 08:41:39 FINE: main Will apply sql:
340CREATE INDEX IF NOT EXISTS prunable_message_transaction_timestamp_idx ON prunable_message (transaction_timestamp DESC)
3412018-11-09 08:41:39 FINE: main Will apply sql:
342CREATE INDEX IF NOT EXISTS prunable_message_sender_idx ON prunable_message (sender_id)
3432018-11-09 08:41:39 FINE: main Will apply sql:
344CREATE INDEX IF NOT EXISTS prunable_message_recipient_idx ON prunable_message (recipient_id)
3452018-11-09 08:41:39 FINE: main Will apply sql:
346CREATE INDEX IF NOT EXISTS prunable_message_block_timestamp_dbid_idx ON prunable_message (block_timestamp DESC, db_id DESC)
3472018-11-09 08:41:39 FINE: main Will apply sql:
348CREATE TABLE IF NOT EXISTS account_control_phasing_sub_poll (db_id IDENTITY, account_id BIGINT NOT NULL, name VARCHAR, whitelist ARRAY, voting_model TINYINT NOT NULL, quorum BIGINT, min_balance BIGINT, sender_property_setter_id BIGINT, sender_property_name VARCHAR, sender_property_value VARCHAR, recipient_property_setter_id BIGINT, recipient_property_name VARCHAR, recipient_property_value VARCHAR, holding_id BIGINT, min_balance_model TINYINT, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
3492018-11-09 08:41:39 FINE: main Will apply sql:
350CREATE INDEX IF NOT EXISTS account_control_phasing_sub_poll_id_height_idx ON account_control_phasing_sub_poll (account_id, height DESC)
3512018-11-09 08:41:39 FINE: main Will apply sql:
352CREATE INDEX IF NOT EXISTS account_control_phasing_sub_poll_height_id_idx ON account_control_phasing_sub_poll (height, account_id)
3532018-11-09 08:41:39 FINE: main Will apply sql:
354CREATE TABLE IF NOT EXISTS asset_control_phasing (db_id IDENTITY, asset_id BIGINT NOT NULL, voting_model TINYINT NOT NULL, quorum BIGINT, min_balance BIGINT, holding_id BIGINT, min_balance_model TINYINT, whitelist ARRAY, expression VARCHAR, sender_property_setter_id BIGINT, sender_property_name VARCHAR, sender_property_value VARCHAR, recipient_property_setter_id BIGINT, recipient_property_name VARCHAR, recipient_property_value VARCHAR, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
3552018-11-09 08:41:39 FINE: main Will apply sql:
356CREATE TABLE IF NOT EXISTS asset_control_phasing_sub_poll (db_id IDENTITY, asset_id BIGINT NOT NULL, name VARCHAR, voting_model TINYINT NOT NULL, quorum BIGINT, min_balance BIGINT, holding_id BIGINT, min_balance_model TINYINT, whitelist ARRAY, sender_property_setter_id BIGINT, sender_property_name VARCHAR, sender_property_value VARCHAR, recipient_property_setter_id BIGINT, recipient_property_name VARCHAR, recipient_property_value VARCHAR, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
3572018-11-09 08:41:39 FINE: main Will apply sql:
358CREATE INDEX IF NOT EXISTS asset_control_phasing_id_height_idx ON asset_control_phasing (asset_id, height DESC)
3592018-11-09 08:41:39 FINE: main Will apply sql:
360CREATE INDEX IF NOT EXISTS asset_control_phasing_height_id_idx ON asset_control_phasing (height, asset_id)
3612018-11-09 08:41:39 FINE: main Will apply sql:
362CREATE INDEX IF NOT EXISTS asset_control_phasing_sub_poll_id_height_idx ON asset_control_phasing_sub_poll (asset_id, height DESC)
3632018-11-09 08:41:39 FINE: main Will apply sql:
364CREATE INDEX IF NOT EXISTS asset_control_phasing_sub_poll_height_id_idx ON asset_control_phasing_sub_poll (height, asset_id)
3652018-11-09 08:41:39 INFO: main Lucene search index deleted
3662018-11-09 08:41:40 INFO: main Rebuilding the Lucene search index
3672018-11-09 08:41:40 INFO: main Lucene search index deleted
3682018-11-09 08:41:40 INFO: main Lucene search index successfully rebuilt
3692018-11-09 08:41:40 FINE: main Will apply sql:
370TRUNCATE TABLE coin_trade_fxt
3712018-11-09 08:41:40 FINE: main Will apply sql:
372ALTER TABLE coin_trade_fxt ALTER COLUMN exchange_price BIGINT NOT NULL
3732018-11-09 08:41:40 FINE: main Database connection pool current size: 3
3742018-11-09 08:41:40 FINE: main Will apply sql:
375CREATE INDEX IF NOT EXISTS public_key_height_idx ON public_key (height)
3762018-11-09 08:41:40 FINE: main Will apply sql:
377CREATE INDEX IF NOT EXISTS prunable_message_height_idx ON prunable_message (height)
3782018-11-09 08:41:40 FINE: main Will apply sql:
379CREATE TABLE IF NOT EXISTS contract_reference (db_id IDENTITY, id BIGINT NOT NULL, account_id BIGINT NOT NULL, contract_name VARCHAR NOT NULL, contract_params VARCHAR, contract_transaction_chain_id INT NOT NULL, contract_transaction_full_hash BINARY(32), height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
3802018-11-09 08:41:40 FINE: main Will apply sql:
381CREATE UNIQUE INDEX IF NOT EXISTS contract_reference_id_height_idx ON contract_reference (id, height DESC)
3822018-11-09 08:41:40 FINE: main Will apply sql:
383CREATE INDEX IF NOT EXISTS contract_reference_height_id_idx ON contract_reference (height, id)
3842018-11-09 08:41:40 FINE: main Will apply sql:
385CREATE INDEX IF NOT EXISTS contract_reference_account_height_idx ON contract_reference (account_id, height DESC)
3862018-11-09 08:41:40 FINE: main Will apply sql:
387DELETE FROM unconfirmed_transaction
3882018-11-09 08:41:40 FINE: main Will apply sql:
389CREATE TABLE IF NOT EXISTS asset_property (   db_id IDENTITY,    id BIGINT NOT NULL,    asset_id BIGINT NOT NULL,    setter_id BIGINT NOT NULL,    property VARCHAR NOT NULL,    value VARCHAR,    height INT NOT NULL,    latest BOOLEAN NOT NULL DEFAULT TRUE)
3902018-11-09 08:41:40 FINE: main Will apply sql:
391CREATE UNIQUE INDEX IF NOT EXISTS asset_property_id_height_idx ON asset_property (id, height DESC)
3922018-11-09 08:41:40 FINE: main Will apply sql:
393CREATE INDEX IF NOT EXISTS asset_property_height_id_idx ON asset_property (height, id)
3942018-11-09 08:41:40 FINE: main Will apply sql:
395CREATE INDEX IF NOT EXISTS asset_property_asset_height_idx ON asset_property (asset_id, height DESC)
3962018-11-09 08:41:40 FINE: main Will apply sql:
397CREATE INDEX IF NOT EXISTS asset_property_setter_property_idx ON asset_property (setter_id, property)
3982018-11-09 08:41:40 FINE: main Will apply sql:
399CREATE TABLE IF NOT EXISTS holding_freeze (   db_id IDENTITY,    holding_id BIGINT NOT NULL,    holding_type VARCHAR NOT NULL CHECK (holding_type IN ('ASSET', 'CURRENCY')),    min_height INT NOT NULL,    actual_height INT NOT NULL,    height INT NOT NULL,    latest BOOLEAN NOT NULL DEFAULT TRUE)
4002018-11-09 08:41:40 FINE: main Will apply sql:
401CREATE UNIQUE INDEX IF NOT EXISTS holding_freeze_holding_id_holding_type_idx ON holding_freeze (holding_id, holding_type, height DESC)
4022018-11-09 08:41:40 FINE: main Will apply sql:
403CREATE INDEX IF NOT EXISTS holding_freeze_actual_height_idx ON holding_freeze (actual_height)
4042018-11-09 08:41:40 FINE: main Will apply sql:
405CREATE INDEX IF NOT EXISTS holding_freeze_height_idx ON holding_freeze (height)
4062018-11-09 08:41:40 FINE: main Will apply sql:
407CREATE TABLE IF NOT EXISTS holding_migrate (   db_id IDENTITY,    holding_id BIGINT,    holding_type VARCHAR NOT NULL CHECK (holding_type IN ('ASSET', 'CURRENCY', 'COIN')),    child_chain_id INT NOT NULL,    min_height INT NOT NULL,    actual_height INT NOT NULL,    height INT NOT NULL,    latest BOOLEAN NOT NULL DEFAULT TRUE)
4082018-11-09 08:41:40 FINE: main Will apply sql:
409CREATE UNIQUE INDEX IF NOT EXISTS holding_migrate_child_chain_id_idx ON holding_migrate (child_chain_id, height DESC)
4102018-11-09 08:41:40 FINE: main Will apply sql:
411CREATE INDEX IF NOT EXISTS holding_migrate_holding_id_holding_type_idx ON holding_migrate (holding_id, holding_type)
4122018-11-09 08:41:40 FINE: main Will apply sql:
413CREATE INDEX IF NOT EXISTS holding_migrate_actual_height_idx ON holding_migrate (actual_height)
4142018-11-09 08:41:40 FINE: main Will apply sql:
415CREATE INDEX IF NOT EXISTS holding_migrate_height_idx ON holding_migrate (height)
4162018-11-09 08:41:40 FINE: main Average database transaction time is 0.009 seconds
4172018-11-09 08:41:40 INFO: main Initializing an empty database
4182018-11-09 08:41:40 FINE: main Will apply sql:
419CREATE TABLE IF NOT EXISTS transaction (db_id IDENTITY, id BIGINT NOT NULL, deadline SMALLINT NOT NULL, recipient_id BIGINT, transaction_index SMALLINT NOT NULL, amount BIGINT NOT NULL, fee BIGINT NOT NULL, full_hash BINARY(32) NOT NULL, height INT NOT NULL, block_id BIGINT NOT NULL, FOREIGN KEY (block_id) REFERENCES PUBLIC.block (id) ON DELETE CASCADE, signature BINARY(64) NOT NULL, timestamp INT NOT NULL, type TINYINT NOT NULL, subtype TINYINT NOT NULL, sender_id BIGINT NOT NULL, block_timestamp INT NOT NULL, referenced_transaction_chain_id INT, referenced_transaction_full_hash BINARY(32), referenced_transaction_id BIGINT, phased BOOLEAN NOT NULL DEFAULT FALSE, fxt_transaction_id BIGINT NOT NULL, attachment_bytes VARBINARY, version TINYINT NOT NULL, has_message BOOLEAN NOT NULL DEFAULT FALSE, has_encrypted_message BOOLEAN NOT NULL DEFAULT FALSE, has_public_key_announcement BOOLEAN NOT NULL DEFAULT FALSE, ec_block_height INT DEFAULT NULL, ec_block_id BIGINT DEFAULT NULL, has_encrypttoself_message BOOLEAN NOT NULL DEFAULT FALSE, has_prunable_message BOOLEAN NOT NULL DEFAULT FALSE, has_prunable_encrypted_message BOOLEAN NOT NULL DEFAULT FALSE, has_prunable_attachment BOOLEAN NOT NULL DEFAULT FALSE)
4202018-11-09 08:41:40 FINE: main Will apply sql:
421CREATE INDEX IF NOT EXISTS transaction_id_idx ON transaction (id)
4222018-11-09 08:41:40 FINE: main Will apply sql:
423CREATE INDEX IF NOT EXISTS transaction_sender_id_idx ON transaction (sender_id)
4242018-11-09 08:41:40 FINE: main Will apply sql:
425CREATE INDEX IF NOT EXISTS transaction_recipient_id_idx ON transaction (recipient_id)
4262018-11-09 08:41:40 FINE: main Will apply sql:
427CREATE INDEX IF NOT EXISTS transaction_block_timestamp_idx ON transaction (block_timestamp DESC)
4282018-11-09 08:41:40 FINE: main Will apply sql:
429CREATE TABLE IF NOT EXISTS alias (db_id IDENTITY, id BIGINT NOT NULL, account_id BIGINT NOT NULL, alias_name VARCHAR NOT NULL, alias_name_lower VARCHAR NOT NULL, alias_uri VARCHAR NOT NULL, timestamp INT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
4302018-11-09 08:41:40 FINE: main Will apply sql:
431CREATE UNIQUE INDEX IF NOT EXISTS alias_id_height_idx ON alias (id, height DESC)
4322018-11-09 08:41:40 FINE: main Will apply sql:
433CREATE INDEX IF NOT EXISTS alias_account_id_idx ON alias (account_id, height DESC)
4342018-11-09 08:41:40 FINE: main Will apply sql:
435CREATE INDEX IF NOT EXISTS alias_name_lower_idx ON alias (alias_name_lower)
4362018-11-09 08:41:40 FINE: main Will apply sql:
437CREATE TABLE IF NOT EXISTS alias_offer (db_id IDENTITY, id BIGINT NOT NULL, price BIGINT NOT NULL, buyer_id BIGINT, height INT NOT NULL, latest BOOLEAN DEFAULT TRUE NOT NULL)
4382018-11-09 08:41:40 FINE: main Will apply sql:
439CREATE UNIQUE INDEX IF NOT EXISTS alias_offer_id_height_idx ON alias_offer (id, height DESC)
4402018-11-09 08:41:40 FINE: main Will apply sql:
441CREATE TABLE IF NOT EXISTS trade (db_id IDENTITY, asset_id BIGINT NOT NULL, block_id BIGINT NOT NULL, ask_order_id BIGINT NOT NULL, ask_order_full_hash BINARY(32) NOT NULL, bid_order_id BIGINT NOT NULL, bid_order_full_hash BINARY(32) NOT NULL, ask_order_height INT NOT NULL, bid_order_height INT NOT NULL, seller_id BIGINT NOT NULL, buyer_id BIGINT NOT NULL, is_buy BOOLEAN NOT NULL, quantity BIGINT NOT NULL, price BIGINT NOT NULL, timestamp INT NOT NULL, height INT NOT NULL)
4422018-11-09 08:41:40 FINE: main Will apply sql:
443CREATE INDEX IF NOT EXISTS trade_asset_id_idx ON trade (asset_id, height DESC)
4442018-11-09 08:41:40 FINE: main Will apply sql:
445CREATE INDEX IF NOT EXISTS trade_seller_id_idx ON trade (seller_id, height DESC)
4462018-11-09 08:41:40 FINE: main Will apply sql:
447CREATE INDEX IF NOT EXISTS trade_buyer_id_idx ON trade (buyer_id, height DESC)
4482018-11-09 08:41:40 FINE: main Will apply sql:
449CREATE TABLE IF NOT EXISTS ask_order (db_id IDENTITY, id BIGINT NOT NULL, full_hash BINARY(32) NOT NULL, account_id BIGINT NOT NULL, asset_id BIGINT NOT NULL, price BIGINT NOT NULL, transaction_index SMALLINT NOT NULL, transaction_height INT NOT NULL, quantity BIGINT NOT NULL, creation_height INT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
4502018-11-09 08:41:40 FINE: main Will apply sql:
451CREATE UNIQUE INDEX IF NOT EXISTS ask_order_id_height_idx ON ask_order (id, height DESC)
4522018-11-09 08:41:40 FINE: main Will apply sql:
453CREATE INDEX IF NOT EXISTS ask_order_account_id_idx ON ask_order (account_id, height DESC)
4542018-11-09 08:41:40 FINE: main Will apply sql:
455CREATE INDEX IF NOT EXISTS ask_order_asset_id_price_idx ON ask_order (asset_id, price)
4562018-11-09 08:41:40 FINE: main Will apply sql:
457CREATE TABLE IF NOT EXISTS bid_order (db_id IDENTITY, id BIGINT NOT NULL, full_hash BINARY(32) NOT NULL, account_id BIGINT NOT NULL, asset_id BIGINT NOT NULL, price BIGINT NOT NULL, transaction_index SMALLINT NOT NULL, transaction_height INT NOT NULL, amount BIGINT NOT NULL, quantity BIGINT NOT NULL, creation_height INT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
4582018-11-09 08:41:40 FINE: main Will apply sql:
459CREATE UNIQUE INDEX IF NOT EXISTS bid_order_id_height_idx ON bid_order (id, height DESC)
4602018-11-09 08:41:40 FINE: main Will apply sql:
461CREATE INDEX IF NOT EXISTS bid_order_account_id_idx ON bid_order (account_id, height DESC)
4622018-11-09 08:41:40 FINE: main Will apply sql:
463CREATE INDEX IF NOT EXISTS bid_order_asset_id_price_idx ON bid_order (asset_id, price DESC)
4642018-11-09 08:41:40 FINE: main Will apply sql:
465CREATE TABLE IF NOT EXISTS goods (db_id IDENTITY, id BIGINT NOT NULL, full_hash BINARY(32), seller_id BIGINT NOT NULL, name VARCHAR NOT NULL, description VARCHAR, parsed_tags ARRAY, has_image BOOLEAN NOT NULL, tags VARCHAR, timestamp INT NOT NULL, quantity INT NOT NULL, price BIGINT NOT NULL, delisted BOOLEAN NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
4662018-11-09 08:41:40 FINE: main Will apply sql:
467CREATE UNIQUE INDEX IF NOT EXISTS goods_id_height_idx ON goods (id, height DESC)
4682018-11-09 08:41:40 FINE: main Will apply sql:
469CREATE INDEX IF NOT EXISTS goods_seller_id_name_idx ON goods (seller_id, name)
4702018-11-09 08:41:40 FINE: main Will apply sql:
471CREATE INDEX IF NOT EXISTS goods_timestamp_idx ON goods (timestamp DESC, height DESC)
4722018-11-09 08:41:40 FINE: main Will apply sql:
473CREATE TABLE IF NOT EXISTS purchase (db_id IDENTITY, id BIGINT NOT NULL, buyer_id BIGINT NOT NULL, goods_id BIGINT NOT NULL, seller_id BIGINT NOT NULL, quantity INT NOT NULL, price BIGINT NOT NULL, deadline INT NOT NULL, note VARBINARY, nonce BINARY(32), timestamp INT NOT NULL, pending BOOLEAN NOT NULL, goods VARBINARY, goods_nonce BINARY(32), goods_is_text BOOLEAN NOT NULL DEFAULT TRUE, refund_note VARBINARY, refund_nonce BINARY(32), has_feedback_notes BOOLEAN NOT NULL DEFAULT FALSE, has_public_feedbacks BOOLEAN NOT NULL DEFAULT FALSE, discount BIGINT NOT NULL, refund BIGINT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
4742018-11-09 08:41:40 FINE: main Will apply sql:
475CREATE UNIQUE INDEX IF NOT EXISTS purchase_id_height_idx ON purchase (id, height DESC)
4762018-11-09 08:41:40 FINE: main Will apply sql:
477CREATE INDEX IF NOT EXISTS purchase_buyer_id_height_idx ON purchase (buyer_id, height DESC)
4782018-11-09 08:41:40 FINE: main Will apply sql:
479CREATE INDEX IF NOT EXISTS purchase_seller_id_height_idx ON purchase (seller_id, height DESC)
4802018-11-09 08:41:40 FINE: main Will apply sql:
481CREATE INDEX IF NOT EXISTS purchase_deadline_idx ON purchase (deadline DESC, height DESC)
4822018-11-09 08:41:40 FINE: main Will apply sql:
483CREATE TABLE IF NOT EXISTS balance (db_id IDENTITY, account_id BIGINT NOT NULL, balance BIGINT NOT NULL, unconfirmed_balance BIGINT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
4842018-11-09 08:41:40 FINE: main Will apply sql:
485CREATE UNIQUE INDEX IF NOT EXISTS balance_id_height_idx ON balance (account_id, height DESC)
4862018-11-09 08:41:40 FINE: main Will apply sql:
487CREATE TABLE IF NOT EXISTS purchase_feedback (db_id IDENTITY, id BIGINT NOT NULL, feedback_data VARBINARY NOT NULL, feedback_nonce BINARY(32) NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
4882018-11-09 08:41:40 FINE: main Will apply sql:
489CREATE INDEX IF NOT EXISTS purchase_feedback_id_height_idx ON purchase_feedback (id, height DESC)
4902018-11-09 08:41:40 FINE: main Will apply sql:
491CREATE TABLE IF NOT EXISTS purchase_public_feedback (db_id IDENTITY, id BIGINT NOT NULL, public_feedback VARCHAR NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
4922018-11-09 08:41:40 FINE: main Will apply sql:
493CREATE INDEX IF NOT EXISTS purchase_public_feedback_id_height_idx ON purchase_public_feedback (id, height DESC)
4942018-11-09 08:41:40 FINE: main Will apply sql:
495CREATE INDEX IF NOT EXISTS purchase_timestamp_idx ON purchase (timestamp DESC, id)
4962018-11-09 08:41:40 FINE: main Will apply sql:
497CREATE INDEX IF NOT EXISTS ask_order_creation_idx ON ask_order (creation_height DESC)
4982018-11-09 08:41:40 FINE: main Will apply sql:
499CREATE INDEX IF NOT EXISTS bid_order_creation_idx ON bid_order (creation_height DESC)
5002018-11-09 08:41:40 FINE: main Will apply sql:
501CREATE TABLE IF NOT EXISTS tag (db_id IDENTITY, tag VARCHAR NOT NULL, in_stock_count INT NOT NULL, total_count INT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
5022018-11-09 08:41:40 FINE: main Will apply sql:
503CREATE UNIQUE INDEX IF NOT EXISTS tag_tag_idx ON tag (tag, height DESC)
5042018-11-09 08:41:40 FINE: main Will apply sql:
505CREATE INDEX IF NOT EXISTS tag_in_stock_count_idx ON tag (in_stock_count DESC, height DESC)
5062018-11-09 08:41:40 FINE: main Will apply sql:
507CREATE TABLE IF NOT EXISTS currency_founder (db_id IDENTITY, currency_id BIGINT NOT NULL, account_id BIGINT NOT NULL, amount_per_unit BIGINT NOT NULL, amount BIGINT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
5082018-11-09 08:41:40 FINE: main Will apply sql:
509CREATE UNIQUE INDEX IF NOT EXISTS currency_founder_currency_id_idx ON currency_founder (currency_id, account_id, height DESC)
5102018-11-09 08:41:40 FINE: main Will apply sql:
511CREATE TABLE IF NOT EXISTS buy_offer (db_id IDENTITY, id BIGINT NOT NULL, full_hash BINARY(32) NOT NULL, currency_id BIGINT NOT NULL, account_id BIGINT NOT NULL,rate BIGINT NOT NULL, unit_limit BIGINT NOT NULL, supply BIGINT NOT NULL, expiration_height INT NOT NULL, amount BIGINT NOT NULL, creation_height INT NOT NULL, transaction_index SMALLINT NOT NULL, transaction_height INT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
5122018-11-09 08:41:40 FINE: main Will apply sql:
513CREATE UNIQUE INDEX IF NOT EXISTS buy_offer_id_idx ON buy_offer (id, height DESC)
5142018-11-09 08:41:40 FINE: main Will apply sql:
515CREATE INDEX IF NOT EXISTS buy_offer_currency_id_account_id_idx ON buy_offer (currency_id, account_id, height DESC)
5162018-11-09 08:41:40 FINE: main Will apply sql:
517CREATE TABLE IF NOT EXISTS sell_offer (db_id IDENTITY, id BIGINT NOT NULL, full_hash BINARY(32) NOT NULL, currency_id BIGINT NOT NULL, account_id BIGINT NOT NULL, rate BIGINT NOT NULL, unit_limit BIGINT NOT NULL, supply BIGINT NOT NULL, expiration_height INT NOT NULL, creation_height INT NOT NULL, transaction_index SMALLINT NOT NULL, transaction_height INT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
5182018-11-09 08:41:40 FINE: main Will apply sql:
519CREATE UNIQUE INDEX IF NOT EXISTS sell_offer_id_idx ON sell_offer (id, height DESC)
5202018-11-09 08:41:40 FINE: main Will apply sql:
521CREATE INDEX IF NOT EXISTS sell_offer_currency_id_account_id_idx ON sell_offer (currency_id, account_id, height DESC)
5222018-11-09 08:41:40 FINE: main Will apply sql:
523CREATE TABLE IF NOT EXISTS exchange (db_id IDENTITY, transaction_id BIGINT NOT NULL, transaction_full_hash BINARY(32) NOT NULL, currency_id BIGINT NOT NULL, block_id BIGINT NOT NULL, offer_id BIGINT NOT NULL, offer_full_hash BINARY(32) NOT NULL, seller_id BIGINT NOT NULL, buyer_id BIGINT NOT NULL, units BIGINT NOT NULL, rate BIGINT NOT NULL, timestamp INT NOT NULL, height INT NOT NULL)
5242018-11-09 08:41:40 FINE: main Will apply sql:
525CREATE INDEX IF NOT EXISTS exchange_offer_idx ON exchange (transaction_id, offer_id)
5262018-11-09 08:41:40 FINE: main Will apply sql:
527CREATE INDEX IF NOT EXISTS exchange_currency_id_idx ON exchange (currency_id, height DESC)
5282018-11-09 08:41:40 FINE: main Will apply sql:
529CREATE INDEX IF NOT EXISTS exchange_seller_id_idx ON exchange (seller_id, height DESC)
5302018-11-09 08:41:40 FINE: main Will apply sql:
531CREATE INDEX IF NOT EXISTS exchange_buyer_id_idx ON exchange (buyer_id, height DESC)
5322018-11-09 08:41:40 FINE: main Will apply sql:
533CREATE INDEX IF NOT EXISTS buy_offer_rate_height_idx ON buy_offer (rate DESC, creation_height ASC)
5342018-11-09 08:41:40 FINE: main Will apply sql:
535CREATE INDEX IF NOT EXISTS sell_offer_rate_height_idx ON sell_offer (rate ASC, creation_height ASC)
5362018-11-09 08:41:40 FINE: main Will apply sql:
537CREATE INDEX IF NOT EXISTS exchange_height_idx ON exchange(height)
5382018-11-09 08:41:40 FINE: main Will apply sql:
539CREATE INDEX IF NOT EXISTS trade_height_idx ON trade(height)
5402018-11-09 08:41:40 FINE: main Will apply sql:
541CREATE TABLE IF NOT EXISTS vote (db_id IDENTITY, id BIGINT NOT NULL, full_hash BINARY(32) NOT NULL, poll_id BIGINT NOT NULL, voter_id BIGINT NOT NULL, vote_bytes VARBINARY NOT NULL, height INT NOT NULL)
5422018-11-09 08:41:40 FINE: main Will apply sql:
543CREATE INDEX IF NOT EXISTS vote_id_idx ON vote (id)
5442018-11-09 08:41:40 FINE: main Will apply sql:
545CREATE UNIQUE INDEX IF NOT EXISTS vote_poll_id_idx ON vote (poll_id, voter_id)
5462018-11-09 08:41:40 FINE: main Will apply sql:
547CREATE TABLE IF NOT EXISTS poll (db_id IDENTITY, id BIGINT NOT NULL, account_id BIGINT NOT NULL, name VARCHAR NOT NULL, description VARCHAR, options ARRAY NOT NULL, min_num_options TINYINT, max_num_options TINYINT, min_range_value TINYINT, max_range_value TINYINT, timestamp INT NOT NULL, finish_height INT NOT NULL, voting_model TINYINT NOT NULL, min_balance BIGINT, min_balance_model TINYINT, holding_id BIGINT, height INT NOT NULL)
5482018-11-09 08:41:40 FINE: main Will apply sql:
549CREATE TABLE IF NOT EXISTS poll_result (db_id IDENTITY, poll_id BIGINT NOT NULL, result BIGINT, weight BIGINT NOT NULL, height INT NOT NULL)
5502018-11-09 08:41:40 FINE: main Will apply sql:
551CREATE TABLE IF NOT EXISTS phasing_poll (db_id IDENTITY, id BIGINT NOT NULL, full_hash BINARY(32) NOT NULL, account_id BIGINT NOT NULL, whitelist_size TINYINT NOT NULL DEFAULT 0, finish_height INT NOT NULL, voting_model TINYINT NOT NULL, quorum BIGINT, min_balance BIGINT, holding_id BIGINT, min_balance_model TINYINT, expression VARCHAR, recipient_account_id BIGINT, sender_property_setter_id BIGINT, sender_property_name VARCHAR, sender_property_value VARCHAR, recipient_property_setter_id BIGINT, recipient_property_name VARCHAR, recipient_property_value VARCHAR, hashed_secret VARBINARY, algorithm TINYINT, height INT NOT NULL)
5522018-11-09 08:41:40 FINE: main Will apply sql:
553CREATE TABLE IF NOT EXISTS phasing_vote (db_id IDENTITY, vote_id BIGINT NOT NULL, vote_full_hash BINARY(32) NOT NULL, transaction_id BIGINT NOT NULL, transaction_full_hash BINARY(32) NOT NULL, voter_id BIGINT NOT NULL, height INT NOT NULL)
5542018-11-09 08:41:40 FINE: main Will apply sql:
555CREATE TABLE IF NOT EXISTS phasing_poll_voter (db_id IDENTITY, transaction_id BIGINT NOT NULL, transaction_full_hash BINARY(32) NOT NULL, voter_id BIGINT NOT NULL, sub_poll_name VARCHAR, height INT NOT NULL)
5562018-11-09 08:41:40 FINE: main Will apply sql:
557CREATE INDEX IF NOT EXISTS vote_height_idx ON vote(height)
5582018-11-09 08:41:40 FINE: main Will apply sql:
559CREATE UNIQUE INDEX IF NOT EXISTS poll_id_idx ON poll(id)
5602018-11-09 08:41:40 FINE: main Will apply sql:
561CREATE INDEX IF NOT EXISTS poll_height_idx ON poll(height)
5622018-11-09 08:41:40 FINE: main Will apply sql:
563CREATE INDEX IF NOT EXISTS poll_account_idx ON poll(account_id)
5642018-11-09 08:41:40 FINE: main Will apply sql:
565CREATE INDEX IF NOT EXISTS poll_finish_height_idx ON poll(finish_height DESC)
5662018-11-09 08:41:40 FINE: main Will apply sql:
567CREATE INDEX IF NOT EXISTS poll_result_poll_id_idx ON poll_result(poll_id)
5682018-11-09 08:41:40 FINE: main Will apply sql:
569CREATE INDEX IF NOT EXISTS poll_result_height_idx ON poll_result(height)
5702018-11-09 08:41:40 FINE: main Will apply sql:
571CREATE INDEX IF NOT EXISTS phasing_poll_id_idx ON phasing_poll(id)
5722018-11-09 08:41:40 FINE: main Will apply sql:
573CREATE INDEX IF NOT EXISTS phasing_poll_height_idx ON phasing_poll(height)
5742018-11-09 08:41:40 FINE: main Will apply sql:
575CREATE INDEX IF NOT EXISTS phasing_poll_account_id_idx ON phasing_poll(account_id, height DESC)
5762018-11-09 08:41:40 FINE: main Will apply sql:
577CREATE INDEX IF NOT EXISTS phasing_poll_holding_id_idx ON phasing_poll(holding_id, height DESC)
5782018-11-09 08:41:40 FINE: main Will apply sql:
579CREATE INDEX IF NOT EXISTS phasing_vote_transaction_voter_idx ON phasing_vote(transaction_id, voter_id)
5802018-11-09 08:41:40 FINE: main Will apply sql:
581CREATE INDEX IF NOT EXISTS phasing_poll_voter_transaction_voter_idx ON phasing_poll_voter(transaction_id, voter_id)
5822018-11-09 08:41:40 FINE: main Will apply sql:
583CREATE INDEX IF NOT EXISTS currency_founder_account_id_idx ON currency_founder (account_id, height DESC)
5842018-11-09 08:41:40 FINE: main Will apply sql:
585CREATE INDEX IF NOT EXISTS phasing_poll_voter_height_idx ON phasing_poll_voter(height)
5862018-11-09 08:41:40 FINE: main Will apply sql:
587CREATE INDEX IF NOT EXISTS phasing_vote_height_idx ON phasing_vote(height)
5882018-11-09 08:41:40 FINE: main Will apply sql:
589CREATE INDEX IF NOT EXISTS trade_ask_idx ON trade (ask_order_id, height DESC)
5902018-11-09 08:41:40 FINE: main Will apply sql:
591CREATE INDEX IF NOT EXISTS trade_bid_idx ON trade (bid_order_id, height DESC)
5922018-11-09 08:41:40 FINE: main Will apply sql:
593CREATE TABLE IF NOT EXISTS prunable_message (db_id IDENTITY, id BIGINT NOT NULL, full_hash BINARY(32) NOT NULL, sender_id BIGINT NOT NULL, recipient_id BIGINT, message VARBINARY, message_is_text BOOLEAN NOT NULL, is_compressed BOOLEAN NOT NULL, encrypted_message VARBINARY, encrypted_is_text BOOLEAN DEFAULT FALSE, block_timestamp INT NOT NULL, transaction_timestamp INT NOT NULL, height INT NOT NULL)
5942018-11-09 08:41:40 FINE: main Will apply sql:
595CREATE INDEX IF NOT EXISTS prunable_message_id_idx ON prunable_message (id)
5962018-11-09 08:41:40 FINE: main Will apply sql:
597CREATE INDEX IF NOT EXISTS prunable_message_transaction_timestamp_idx ON prunable_message (transaction_timestamp DESC)
5982018-11-09 08:41:40 FINE: main Will apply sql:
599CREATE INDEX IF NOT EXISTS prunable_message_sender_idx ON prunable_message (sender_id)
6002018-11-09 08:41:40 FINE: main Will apply sql:
601CREATE INDEX IF NOT EXISTS prunable_message_recipient_idx ON prunable_message (recipient_id)
6022018-11-09 08:41:40 FINE: main Will apply sql:
603CREATE INDEX IF NOT EXISTS prunable_message_block_timestamp_dbid_idx ON prunable_message (block_timestamp DESC, db_id DESC)
6042018-11-09 08:41:40 FINE: main Will apply sql:
605CREATE TABLE IF NOT EXISTS tagged_data (db_id IDENTITY, id BIGINT NOT NULL, full_hash BINARY(32) NOT NULL, account_id BIGINT NOT NULL, name VARCHAR NOT NULL, description VARCHAR, tags VARCHAR, parsed_tags ARRAY, type VARCHAR, data VARBINARY NOT NULL, is_text BOOLEAN NOT NULL, channel VARCHAR, filename VARCHAR, block_timestamp INT NOT NULL, transaction_timestamp INT NOT NULL, height INT NOT NULL)
6062018-11-09 08:41:40 FINE: main Will apply sql:
607CREATE INDEX IF NOT EXISTS tagged_data_id_idx ON tagged_data (id)
6082018-11-09 08:41:40 FINE: main Will apply sql:
609CREATE INDEX IF NOT EXISTS tagged_data_expiration_idx ON tagged_data (transaction_timestamp DESC)
6102018-11-09 08:41:40 FINE: main Will apply sql:
611CREATE INDEX IF NOT EXISTS tagged_data_account_id_height_idx ON tagged_data (account_id, height DESC)
6122018-11-09 08:41:40 FINE: main Will apply sql:
613CREATE INDEX IF NOT EXISTS tagged_data_block_timestamp_db_id_idx ON tagged_data (block_timestamp DESC, db_id DESC)
6142018-11-09 08:41:40 FINE: main Will apply sql:
615CREATE TABLE IF NOT EXISTS data_tag (db_id IDENTITY, tag VARCHAR NOT NULL, tag_count INT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
6162018-11-09 08:41:40 FINE: main Will apply sql:
617CREATE UNIQUE INDEX IF NOT EXISTS data_tag_tag_height_idx ON data_tag (tag, height DESC)
6182018-11-09 08:41:40 FINE: main Will apply sql:
619CREATE INDEX IF NOT EXISTS data_tag_count_height_idx ON data_tag (tag_count DESC, height DESC)
6202018-11-09 08:41:40 FINE: main Will apply sql:
621CREATE INDEX IF NOT EXISTS tagged_data_channel_idx ON tagged_data (channel, height DESC)
6222018-11-09 08:41:40 FINE: main Will apply sql:
623CREATE INDEX IF NOT EXISTS balance_height_id_idx ON balance (height, account_id)
6242018-11-09 08:41:40 FINE: main Will apply sql:
625CREATE INDEX IF NOT EXISTS alias_height_id_idx ON alias (height, id)
6262018-11-09 08:41:40 FINE: main Will apply sql:
627CREATE INDEX IF NOT EXISTS alias_offer_height_id_idx ON alias_offer (height, id)
6282018-11-09 08:41:40 FINE: main Will apply sql:
629CREATE INDEX IF NOT EXISTS ask_order_height_id_idx ON ask_order (height, id)
6302018-11-09 08:41:40 FINE: main Will apply sql:
631CREATE INDEX IF NOT EXISTS bid_order_height_id_idx ON bid_order (height, id)
6322018-11-09 08:41:40 FINE: main Will apply sql:
633CREATE INDEX IF NOT EXISTS buy_offer_height_id_idx ON buy_offer (height, id)
6342018-11-09 08:41:40 FINE: main Will apply sql:
635CREATE INDEX IF NOT EXISTS currency_founder_height_id_idx ON currency_founder (height, currency_id, account_id)
6362018-11-09 08:41:40 FINE: main Will apply sql:
637CREATE INDEX IF NOT EXISTS goods_height_id_idx ON goods (height, id)
6382018-11-09 08:41:40 FINE: main Will apply sql:
639CREATE INDEX IF NOT EXISTS purchase_height_id_idx ON purchase (height, id)
6402018-11-09 08:41:40 FINE: main Will apply sql:
641CREATE INDEX IF NOT EXISTS purchase_feedback_height_id_idx ON purchase_feedback (height, id)
6422018-11-09 08:41:40 FINE: main Will apply sql:
643CREATE INDEX IF NOT EXISTS purchase_public_feedback_height_id_idx ON purchase_public_feedback (height, id)
6442018-11-09 08:41:40 FINE: main Will apply sql:
645CREATE INDEX IF NOT EXISTS sell_offer_height_id_idx ON sell_offer (height, id)
6462018-11-09 08:41:40 FINE: main Will apply sql:
647CREATE INDEX IF NOT EXISTS tag_height_tag_idx ON tag (height, tag)
6482018-11-09 08:41:40 FINE: main Will apply sql:
649CREATE INDEX IF NOT EXISTS trade_height_db_id_idx ON trade (height DESC, db_id DESC)
6502018-11-09 08:41:40 FINE: main Will apply sql:
651CREATE INDEX IF NOT EXISTS exchange_height_db_id_idx ON exchange (height DESC, db_id DESC)
6522018-11-09 08:41:40 FINE: main Will apply sql:
653CREATE TABLE IF NOT EXISTS exchange_request (db_id IDENTITY, id BIGINT NOT NULL, full_hash BINARY(32) NOT NULL, account_id BIGINT NOT NULL, currency_id BIGINT NOT NULL, units BIGINT NOT NULL, rate BIGINT NOT NULL, is_buy BOOLEAN NOT NULL, timestamp INT NOT NULL, height INT NOT NULL)
6542018-11-09 08:41:40 FINE: main Will apply sql:
655CREATE INDEX IF NOT EXISTS exchange_request_id_idx ON exchange_request (id)
6562018-11-09 08:41:40 FINE: main Will apply sql:
657CREATE INDEX IF NOT EXISTS exchange_request_account_currency_idx ON exchange_request (account_id, currency_id, height DESC)
6582018-11-09 08:41:40 FINE: main Will apply sql:
659CREATE INDEX IF NOT EXISTS exchange_request_currency_idx ON exchange_request (currency_id, height DESC)
6602018-11-09 08:41:40 FINE: main Will apply sql:
661CREATE INDEX IF NOT EXISTS exchange_request_height_db_id_idx ON exchange_request (height DESC, db_id DESC)
6622018-11-09 08:41:40 FINE: main Will apply sql:
663CREATE INDEX IF NOT EXISTS exchange_request_height_idx ON exchange_request (height)
6642018-11-09 08:41:40 INFO: main Lucene search index deleted
6652018-11-09 08:41:40 INFO: main H2 fulltext function aliases dropped
6662018-11-09 08:41:40 INFO: main NRS fulltext schema created
6672018-11-09 08:41:40 INFO: main Rebuilding the Lucene search index
6682018-11-09 08:41:40 INFO: main Lucene search index deleted
6692018-11-09 08:41:41 INFO: main Lucene search index successfully rebuilt
6702018-11-09 08:41:41 INFO: main NRS fulltext aliases created
6712018-11-09 08:41:41 FINE: main Will apply sql:
672CREATE TABLE IF NOT EXISTS shuffling (db_id IDENTITY, id BIGINT NOT NULL, full_hash BINARY(32) NOT NULL, holding_id BIGINT NULL, holding_type TINYINT NOT NULL, issuer_id BIGINT NOT NULL, amount BIGINT NOT NULL, participant_count TINYINT NOT NULL, blocks_remaining SMALLINT NULL, stage TINYINT NOT NULL, assignee_account_id BIGINT NULL, registrant_count TINYINT NOT NULL, recipient_public_keys ARRAY, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
6732018-11-09 08:41:41 FINE: main Will apply sql:
674CREATE INDEX IF NOT EXISTS shuffling_id_height_idx ON shuffling (id, height DESC)
6752018-11-09 08:41:41 FINE: main Will apply sql:
676CREATE INDEX IF NOT EXISTS shuffling_holding_id_height_idx ON shuffling (holding_id, height DESC)
6772018-11-09 08:41:41 FINE: main Will apply sql:
678CREATE INDEX IF NOT EXISTS shuffling_assignee_account_id_height_idx ON shuffling (assignee_account_id, height DESC)
6792018-11-09 08:41:41 FINE: main Will apply sql:
680CREATE INDEX IF NOT EXISTS shuffling_height_id_idx ON shuffling (height, id)
6812018-11-09 08:41:41 FINE: main Will apply sql:
682CREATE TABLE IF NOT EXISTS shuffling_participant (db_id IDENTITY, shuffling_id BIGINT NOT NULL, shuffling_full_hash BINARY(32) NOT NULL, account_id BIGINT NOT NULL, next_account_id BIGINT NULL, participant_index TINYINT NOT NULL, state TINYINT NOT NULL, blame_data ARRAY, key_seeds ARRAY, data_transaction_full_hash BINARY(32), height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
6832018-11-09 08:41:41 FINE: main Will apply sql:
684CREATE INDEX IF NOT EXISTS shuffling_participant_shuffling_id_account_id_idx ON shuffling_participant (shuffling_id, account_id, height DESC)
6852018-11-09 08:41:41 FINE: main Will apply sql:
686CREATE INDEX IF NOT EXISTS shuffling_participant_height_idx ON shuffling_participant (height, shuffling_id, account_id)
6872018-11-09 08:41:41 FINE: main Will apply sql:
688CREATE TABLE IF NOT EXISTS shuffling_data (db_id IDENTITY, shuffling_id BIGINT NOT NULL, shuffling_full_hash BINARY(32) NOT NULL, account_id BIGINT NOT NULL, data ARRAY, transaction_timestamp INT NOT NULL, height INT NOT NULL)
6892018-11-09 08:41:41 FINE: main Will apply sql:
690CREATE INDEX IF NOT EXISTS shuffling_data_id_height_idx ON shuffling_data (shuffling_id, height DESC)
6912018-11-09 08:41:41 FINE: main Will apply sql:
692CREATE INDEX shuffling_data_transaction_timestamp_idx ON shuffling_data (transaction_timestamp DESC)
6932018-11-09 08:41:41 FINE: main Will apply sql:
694CREATE INDEX IF NOT EXISTS transaction_referenced_transaction_id_idx ON transaction (referenced_transaction_id)
6952018-11-09 08:41:41 FINE: main Will apply sql:
696CREATE INDEX IF NOT EXISTS shuffling_blocks_remaining_height_idx ON shuffling (blocks_remaining, height DESC)
6972018-11-09 08:41:41 FINE: main Will apply sql:
698CREATE TABLE IF NOT EXISTS asset_dividend (db_id IDENTITY, id BIGINT NOT NULL, full_hash BINARY(32) NOT NULL, asset_id BIGINT NOT NULL, holding_id BIGINT NOT NULL, holding_type TINYINT NOT NULL, amount BIGINT NOT NULL, dividend_height INT NOT NULL, total_dividend BIGINT NOT NULL, num_accounts BIGINT NOT NULL, timestamp INT NOT NULL, height INT NOT NULL)
6992018-11-09 08:41:41 FINE: main Will apply sql:
700CREATE INDEX IF NOT EXISTS asset_dividend_id_idx ON asset_dividend (id)
7012018-11-09 08:41:41 FINE: main Will apply sql:
702CREATE INDEX IF NOT EXISTS asset_dividend_asset_id_idx ON asset_dividend (asset_id, height DESC)
7032018-11-09 08:41:41 FINE: main Will apply sql:
704CREATE INDEX IF NOT EXISTS asset_dividend_height_idx ON asset_dividend (height)
7052018-11-09 08:41:41 FINE: main Will apply sql:
706CREATE INDEX IF NOT EXISTS fxt_transaction_id_idx ON transaction (fxt_transaction_id, transaction_index)
7072018-11-09 08:41:41 FINE: main Will apply sql:
708CREATE TABLE IF NOT EXISTS phasing_sub_poll (db_id IDENTITY, transaction_id BIGINT NOT NULL, transaction_full_hash BINARY(32) NOT NULL, name VARCHAR, whitelist_size TINYINT NOT NULL DEFAULT 0, voting_model TINYINT NOT NULL, quorum BIGINT, min_balance BIGINT, holding_id BIGINT, min_balance_model TINYINT, sender_property_setter_id BIGINT, sender_property_name VARCHAR, sender_property_value VARCHAR, recipient_property_setter_id BIGINT, recipient_property_name VARCHAR, recipient_property_value VARCHAR, hashed_secret VARBINARY, algorithm TINYINT, height INT NOT NULL)
7092018-11-09 08:41:41 FINE: main Will apply sql:
710CREATE TABLE IF NOT EXISTS phasing_vote_sub_poll (db_id IDENTITY, transaction_id BIGINT NOT NULL, transaction_full_hash BINARY(32) NOT NULL, voter_id BIGINT NOT NULL, sub_poll_name VARCHAR NOT NULL, height INT NOT NULL)
7112018-11-09 08:41:41 FINE: main Will apply sql:
712CREATE INDEX IF NOT EXISTS phasing_vote_sub_poll_transaction_id_idx ON phasing_vote_sub_poll(transaction_id, voter_id)
7132018-11-09 08:41:41 FINE: main Will apply sql:
714CREATE INDEX IF NOT EXISTS phasing_vote_sub_poll_height_idx ON phasing_vote_sub_poll(height)
7152018-11-09 08:41:41 FINE: main Will apply sql:
716CREATE INDEX IF NOT EXISTS phasing_sub_poll_id_idx ON phasing_sub_poll(transaction_id)
7172018-11-09 08:41:41 FINE: main Will apply sql:
718CREATE INDEX IF NOT EXISTS phasing_sub_poll_height_idx ON phasing_sub_poll(height)
7192018-11-09 08:41:41 FINE: main Will apply sql:
720CREATE INDEX IF NOT EXISTS prunable_message_height_idx ON prunable_message (height)
7212018-11-09 08:41:41 FINE: main Will apply sql:
722CREATE INDEX IF NOT EXISTS tagged_data_height_idx ON tagged_data (height)
7232018-11-09 08:41:41 FINE: main Will apply sql:
724CREATE INDEX IF NOT EXISTS data_tag_height_idx ON data_tag (height)
7252018-11-09 08:41:41 FINE: main Will apply sql:
726CREATE INDEX IF NOT EXISTS shuffling_data_height_idx ON shuffling_data (height)
7272018-11-09 08:41:41 INFO: main Initializing an empty database
7282018-11-09 08:41:41 FINE: main Will apply sql:
729CREATE TABLE IF NOT EXISTS transaction (db_id IDENTITY, id BIGINT NOT NULL, deadline SMALLINT NOT NULL, recipient_id BIGINT, transaction_index SMALLINT NOT NULL, amount BIGINT NOT NULL, fee BIGINT NOT NULL, full_hash BINARY(32) NOT NULL, height INT NOT NULL, block_id BIGINT NOT NULL, FOREIGN KEY (block_id) REFERENCES PUBLIC.block (id) ON DELETE CASCADE, signature BINARY(64) NOT NULL, timestamp INT NOT NULL, type TINYINT NOT NULL, subtype TINYINT NOT NULL, sender_id BIGINT NOT NULL, block_timestamp INT NOT NULL, referenced_transaction_chain_id INT, referenced_transaction_full_hash BINARY(32), referenced_transaction_id BIGINT, phased BOOLEAN NOT NULL DEFAULT FALSE, fxt_transaction_id BIGINT NOT NULL, attachment_bytes VARBINARY, version TINYINT NOT NULL, has_message BOOLEAN NOT NULL DEFAULT FALSE, has_encrypted_message BOOLEAN NOT NULL DEFAULT FALSE, has_public_key_announcement BOOLEAN NOT NULL DEFAULT FALSE, ec_block_height INT DEFAULT NULL, ec_block_id BIGINT DEFAULT NULL, has_encrypttoself_message BOOLEAN NOT NULL DEFAULT FALSE, has_prunable_message BOOLEAN NOT NULL DEFAULT FALSE, has_prunable_encrypted_message BOOLEAN NOT NULL DEFAULT FALSE, has_prunable_attachment BOOLEAN NOT NULL DEFAULT FALSE)
7302018-11-09 08:41:41 FINE: main Will apply sql:
731CREATE INDEX IF NOT EXISTS transaction_id_idx ON transaction (id)
7322018-11-09 08:41:41 FINE: main Will apply sql:
733CREATE INDEX IF NOT EXISTS transaction_sender_id_idx ON transaction (sender_id)
7342018-11-09 08:41:41 FINE: main Will apply sql:
735CREATE INDEX IF NOT EXISTS transaction_recipient_id_idx ON transaction (recipient_id)
7362018-11-09 08:41:41 FINE: main Will apply sql:
737CREATE INDEX IF NOT EXISTS transaction_block_timestamp_idx ON transaction (block_timestamp DESC)
7382018-11-09 08:41:41 FINE: main Will apply sql:
739CREATE TABLE IF NOT EXISTS alias (db_id IDENTITY, id BIGINT NOT NULL, account_id BIGINT NOT NULL, alias_name VARCHAR NOT NULL, alias_name_lower VARCHAR NOT NULL, alias_uri VARCHAR NOT NULL, timestamp INT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
7402018-11-09 08:41:41 FINE: main Will apply sql:
741CREATE UNIQUE INDEX IF NOT EXISTS alias_id_height_idx ON alias (id, height DESC)
7422018-11-09 08:41:41 FINE: main Will apply sql:
743CREATE INDEX IF NOT EXISTS alias_account_id_idx ON alias (account_id, height DESC)
7442018-11-09 08:41:41 FINE: main Will apply sql:
745CREATE INDEX IF NOT EXISTS alias_name_lower_idx ON alias (alias_name_lower)
7462018-11-09 08:41:41 FINE: main Will apply sql:
747CREATE TABLE IF NOT EXISTS alias_offer (db_id IDENTITY, id BIGINT NOT NULL, price BIGINT NOT NULL, buyer_id BIGINT, height INT NOT NULL, latest BOOLEAN DEFAULT TRUE NOT NULL)
7482018-11-09 08:41:41 FINE: main Will apply sql:
749CREATE UNIQUE INDEX IF NOT EXISTS alias_offer_id_height_idx ON alias_offer (id, height DESC)
7502018-11-09 08:41:41 FINE: main Will apply sql:
751CREATE TABLE IF NOT EXISTS trade (db_id IDENTITY, asset_id BIGINT NOT NULL, block_id BIGINT NOT NULL, ask_order_id BIGINT NOT NULL, ask_order_full_hash BINARY(32) NOT NULL, bid_order_id BIGINT NOT NULL, bid_order_full_hash BINARY(32) NOT NULL, ask_order_height INT NOT NULL, bid_order_height INT NOT NULL, seller_id BIGINT NOT NULL, buyer_id BIGINT NOT NULL, is_buy BOOLEAN NOT NULL, quantity BIGINT NOT NULL, price BIGINT NOT NULL, timestamp INT NOT NULL, height INT NOT NULL)
7522018-11-09 08:41:41 FINE: main Will apply sql:
753CREATE INDEX IF NOT EXISTS trade_asset_id_idx ON trade (asset_id, height DESC)
7542018-11-09 08:41:41 FINE: main Will apply sql:
755CREATE INDEX IF NOT EXISTS trade_seller_id_idx ON trade (seller_id, height DESC)
7562018-11-09 08:41:41 FINE: main Will apply sql:
757CREATE INDEX IF NOT EXISTS trade_buyer_id_idx ON trade (buyer_id, height DESC)
7582018-11-09 08:41:41 FINE: main Will apply sql:
759CREATE TABLE IF NOT EXISTS ask_order (db_id IDENTITY, id BIGINT NOT NULL, full_hash BINARY(32) NOT NULL, account_id BIGINT NOT NULL, asset_id BIGINT NOT NULL, price BIGINT NOT NULL, transaction_index SMALLINT NOT NULL, transaction_height INT NOT NULL, quantity BIGINT NOT NULL, creation_height INT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
7602018-11-09 08:41:41 FINE: main Will apply sql:
761CREATE UNIQUE INDEX IF NOT EXISTS ask_order_id_height_idx ON ask_order (id, height DESC)
7622018-11-09 08:41:41 FINE: main Will apply sql:
763CREATE INDEX IF NOT EXISTS ask_order_account_id_idx ON ask_order (account_id, height DESC)
7642018-11-09 08:41:41 FINE: main Will apply sql:
765CREATE INDEX IF NOT EXISTS ask_order_asset_id_price_idx ON ask_order (asset_id, price)
7662018-11-09 08:41:41 FINE: main Will apply sql:
767CREATE TABLE IF NOT EXISTS bid_order (db_id IDENTITY, id BIGINT NOT NULL, full_hash BINARY(32) NOT NULL, account_id BIGINT NOT NULL, asset_id BIGINT NOT NULL, price BIGINT NOT NULL, transaction_index SMALLINT NOT NULL, transaction_height INT NOT NULL, amount BIGINT NOT NULL, quantity BIGINT NOT NULL, creation_height INT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
7682018-11-09 08:41:41 FINE: main Will apply sql:
769CREATE UNIQUE INDEX IF NOT EXISTS bid_order_id_height_idx ON bid_order (id, height DESC)
7702018-11-09 08:41:41 FINE: main Will apply sql:
771CREATE INDEX IF NOT EXISTS bid_order_account_id_idx ON bid_order (account_id, height DESC)
7722018-11-09 08:41:41 FINE: main Will apply sql:
773CREATE INDEX IF NOT EXISTS bid_order_asset_id_price_idx ON bid_order (asset_id, price DESC)
7742018-11-09 08:41:41 FINE: main Will apply sql:
775CREATE TABLE IF NOT EXISTS goods (db_id IDENTITY, id BIGINT NOT NULL, full_hash BINARY(32), seller_id BIGINT NOT NULL, name VARCHAR NOT NULL, description VARCHAR, parsed_tags ARRAY, has_image BOOLEAN NOT NULL, tags VARCHAR, timestamp INT NOT NULL, quantity INT NOT NULL, price BIGINT NOT NULL, delisted BOOLEAN NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
7762018-11-09 08:41:41 FINE: main Will apply sql:
777CREATE UNIQUE INDEX IF NOT EXISTS goods_id_height_idx ON goods (id, height DESC)
7782018-11-09 08:41:41 FINE: main Will apply sql:
779CREATE INDEX IF NOT EXISTS goods_seller_id_name_idx ON goods (seller_id, name)
7802018-11-09 08:41:41 FINE: main Will apply sql:
781CREATE INDEX IF NOT EXISTS goods_timestamp_idx ON goods (timestamp DESC, height DESC)
7822018-11-09 08:41:41 FINE: main Will apply sql:
783CREATE TABLE IF NOT EXISTS purchase (db_id IDENTITY, id BIGINT NOT NULL, buyer_id BIGINT NOT NULL, goods_id BIGINT NOT NULL, seller_id BIGINT NOT NULL, quantity INT NOT NULL, price BIGINT NOT NULL, deadline INT NOT NULL, note VARBINARY, nonce BINARY(32), timestamp INT NOT NULL, pending BOOLEAN NOT NULL, goods VARBINARY, goods_nonce BINARY(32), goods_is_text BOOLEAN NOT NULL DEFAULT TRUE, refund_note VARBINARY, refund_nonce BINARY(32), has_feedback_notes BOOLEAN NOT NULL DEFAULT FALSE, has_public_feedbacks BOOLEAN NOT NULL DEFAULT FALSE, discount BIGINT NOT NULL, refund BIGINT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
7842018-11-09 08:41:41 FINE: main Will apply sql:
785CREATE UNIQUE INDEX IF NOT EXISTS purchase_id_height_idx ON purchase (id, height DESC)
7862018-11-09 08:41:41 FINE: main Will apply sql:
787CREATE INDEX IF NOT EXISTS purchase_buyer_id_height_idx ON purchase (buyer_id, height DESC)
7882018-11-09 08:41:41 FINE: main Will apply sql:
789CREATE INDEX IF NOT EXISTS purchase_seller_id_height_idx ON purchase (seller_id, height DESC)
7902018-11-09 08:41:41 FINE: main Will apply sql:
791CREATE INDEX IF NOT EXISTS purchase_deadline_idx ON purchase (deadline DESC, height DESC)
7922018-11-09 08:41:41 FINE: main Will apply sql:
793CREATE TABLE IF NOT EXISTS balance (db_id IDENTITY, account_id BIGINT NOT NULL, balance BIGINT NOT NULL, unconfirmed_balance BIGINT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
7942018-11-09 08:41:41 FINE: main Will apply sql:
795CREATE UNIQUE INDEX IF NOT EXISTS balance_id_height_idx ON balance (account_id, height DESC)
7962018-11-09 08:41:41 FINE: main Will apply sql:
797CREATE TABLE IF NOT EXISTS purchase_feedback (db_id IDENTITY, id BIGINT NOT NULL, feedback_data VARBINARY NOT NULL, feedback_nonce BINARY(32) NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
7982018-11-09 08:41:41 FINE: main Will apply sql:
799CREATE INDEX IF NOT EXISTS purchase_feedback_id_height_idx ON purchase_feedback (id, height DESC)
8002018-11-09 08:41:41 FINE: main Will apply sql:
801CREATE TABLE IF NOT EXISTS purchase_public_feedback (db_id IDENTITY, id BIGINT NOT NULL, public_feedback VARCHAR NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
8022018-11-09 08:41:41 FINE: main Will apply sql:
803CREATE INDEX IF NOT EXISTS purchase_public_feedback_id_height_idx ON purchase_public_feedback (id, height DESC)
8042018-11-09 08:41:41 FINE: main Will apply sql:
805CREATE INDEX IF NOT EXISTS purchase_timestamp_idx ON purchase (timestamp DESC, id)
8062018-11-09 08:41:41 FINE: main Will apply sql:
807CREATE INDEX IF NOT EXISTS ask_order_creation_idx ON ask_order (creation_height DESC)
8082018-11-09 08:41:41 FINE: main Will apply sql:
809CREATE INDEX IF NOT EXISTS bid_order_creation_idx ON bid_order (creation_height DESC)
8102018-11-09 08:41:41 FINE: main Will apply sql:
811CREATE TABLE IF NOT EXISTS tag (db_id IDENTITY, tag VARCHAR NOT NULL, in_stock_count INT NOT NULL, total_count INT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
8122018-11-09 08:41:41 FINE: main Will apply sql:
813CREATE UNIQUE INDEX IF NOT EXISTS tag_tag_idx ON tag (tag, height DESC)
8142018-11-09 08:41:41 FINE: main Will apply sql:
815CREATE INDEX IF NOT EXISTS tag_in_stock_count_idx ON tag (in_stock_count DESC, height DESC)
8162018-11-09 08:41:41 FINE: main Will apply sql:
817CREATE TABLE IF NOT EXISTS currency_founder (db_id IDENTITY, currency_id BIGINT NOT NULL, account_id BIGINT NOT NULL, amount_per_unit BIGINT NOT NULL, amount BIGINT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
8182018-11-09 08:41:41 FINE: main Will apply sql:
819CREATE UNIQUE INDEX IF NOT EXISTS currency_founder_currency_id_idx ON currency_founder (currency_id, account_id, height DESC)
8202018-11-09 08:41:41 FINE: main Will apply sql:
821CREATE TABLE IF NOT EXISTS buy_offer (db_id IDENTITY, id BIGINT NOT NULL, full_hash BINARY(32) NOT NULL, currency_id BIGINT NOT NULL, account_id BIGINT NOT NULL,rate BIGINT NOT NULL, unit_limit BIGINT NOT NULL, supply BIGINT NOT NULL, expiration_height INT NOT NULL, amount BIGINT NOT NULL, creation_height INT NOT NULL, transaction_index SMALLINT NOT NULL, transaction_height INT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
8222018-11-09 08:41:41 FINE: main Will apply sql:
823CREATE UNIQUE INDEX IF NOT EXISTS buy_offer_id_idx ON buy_offer (id, height DESC)
8242018-11-09 08:41:41 FINE: main Will apply sql:
825CREATE INDEX IF NOT EXISTS buy_offer_currency_id_account_id_idx ON buy_offer (currency_id, account_id, height DESC)
8262018-11-09 08:41:41 FINE: main Will apply sql:
827CREATE TABLE IF NOT EXISTS sell_offer (db_id IDENTITY, id BIGINT NOT NULL, full_hash BINARY(32) NOT NULL, currency_id BIGINT NOT NULL, account_id BIGINT NOT NULL, rate BIGINT NOT NULL, unit_limit BIGINT NOT NULL, supply BIGINT NOT NULL, expiration_height INT NOT NULL, creation_height INT NOT NULL, transaction_index SMALLINT NOT NULL, transaction_height INT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
8282018-11-09 08:41:41 FINE: main Will apply sql:
829CREATE UNIQUE INDEX IF NOT EXISTS sell_offer_id_idx ON sell_offer (id, height DESC)
8302018-11-09 08:41:41 FINE: main Will apply sql:
831CREATE INDEX IF NOT EXISTS sell_offer_currency_id_account_id_idx ON sell_offer (currency_id, account_id, height DESC)
8322018-11-09 08:41:41 FINE: main Will apply sql:
833CREATE TABLE IF NOT EXISTS exchange (db_id IDENTITY, transaction_id BIGINT NOT NULL, transaction_full_hash BINARY(32) NOT NULL, currency_id BIGINT NOT NULL, block_id BIGINT NOT NULL, offer_id BIGINT NOT NULL, offer_full_hash BINARY(32) NOT NULL, seller_id BIGINT NOT NULL, buyer_id BIGINT NOT NULL, units BIGINT NOT NULL, rate BIGINT NOT NULL, timestamp INT NOT NULL, height INT NOT NULL)
8342018-11-09 08:41:41 FINE: main Will apply sql:
835CREATE INDEX IF NOT EXISTS exchange_offer_idx ON exchange (transaction_id, offer_id)
8362018-11-09 08:41:41 FINE: main Will apply sql:
837CREATE INDEX IF NOT EXISTS exchange_currency_id_idx ON exchange (currency_id, height DESC)
8382018-11-09 08:41:41 FINE: main Will apply sql:
839CREATE INDEX IF NOT EXISTS exchange_seller_id_idx ON exchange (seller_id, height DESC)
8402018-11-09 08:41:41 FINE: main Will apply sql:
841CREATE INDEX IF NOT EXISTS exchange_buyer_id_idx ON exchange (buyer_id, height DESC)
8422018-11-09 08:41:41 FINE: main Will apply sql:
843CREATE INDEX IF NOT EXISTS buy_offer_rate_height_idx ON buy_offer (rate DESC, creation_height ASC)
8442018-11-09 08:41:41 FINE: main Will apply sql:
845CREATE INDEX IF NOT EXISTS sell_offer_rate_height_idx ON sell_offer (rate ASC, creation_height ASC)
8462018-11-09 08:41:41 FINE: main Will apply sql:
847CREATE INDEX IF NOT EXISTS exchange_height_idx ON exchange(height)
8482018-11-09 08:41:41 FINE: main Will apply sql:
849CREATE INDEX IF NOT EXISTS trade_height_idx ON trade(height)
8502018-11-09 08:41:41 FINE: main Will apply sql:
851CREATE TABLE IF NOT EXISTS vote (db_id IDENTITY, id BIGINT NOT NULL, full_hash BINARY(32) NOT NULL, poll_id BIGINT NOT NULL, voter_id BIGINT NOT NULL, vote_bytes VARBINARY NOT NULL, height INT NOT NULL)
8522018-11-09 08:41:41 FINE: main Will apply sql:
853CREATE INDEX IF NOT EXISTS vote_id_idx ON vote (id)
8542018-11-09 08:41:41 FINE: main Will apply sql:
855CREATE UNIQUE INDEX IF NOT EXISTS vote_poll_id_idx ON vote (poll_id, voter_id)
8562018-11-09 08:41:41 FINE: main Will apply sql:
857CREATE TABLE IF NOT EXISTS poll (db_id IDENTITY, id BIGINT NOT NULL, account_id BIGINT NOT NULL, name VARCHAR NOT NULL, description VARCHAR, options ARRAY NOT NULL, min_num_options TINYINT, max_num_options TINYINT, min_range_value TINYINT, max_range_value TINYINT, timestamp INT NOT NULL, finish_height INT NOT NULL, voting_model TINYINT NOT NULL, min_balance BIGINT, min_balance_model TINYINT, holding_id BIGINT, height INT NOT NULL)
8582018-11-09 08:41:41 FINE: main Will apply sql:
859CREATE TABLE IF NOT EXISTS poll_result (db_id IDENTITY, poll_id BIGINT NOT NULL, result BIGINT, weight BIGINT NOT NULL, height INT NOT NULL)
8602018-11-09 08:41:41 FINE: main Will apply sql:
861CREATE TABLE IF NOT EXISTS phasing_poll (db_id IDENTITY, id BIGINT NOT NULL, full_hash BINARY(32) NOT NULL, account_id BIGINT NOT NULL, whitelist_size TINYINT NOT NULL DEFAULT 0, finish_height INT NOT NULL, voting_model TINYINT NOT NULL, quorum BIGINT, min_balance BIGINT, holding_id BIGINT, min_balance_model TINYINT, expression VARCHAR, recipient_account_id BIGINT, sender_property_setter_id BIGINT, sender_property_name VARCHAR, sender_property_value VARCHAR, recipient_property_setter_id BIGINT, recipient_property_name VARCHAR, recipient_property_value VARCHAR, hashed_secret VARBINARY, algorithm TINYINT, height INT NOT NULL)
8622018-11-09 08:41:41 FINE: main Will apply sql:
863CREATE TABLE IF NOT EXISTS phasing_vote (db_id IDENTITY, vote_id BIGINT NOT NULL, vote_full_hash BINARY(32) NOT NULL, transaction_id BIGINT NOT NULL, transaction_full_hash BINARY(32) NOT NULL, voter_id BIGINT NOT NULL, height INT NOT NULL)
8642018-11-09 08:41:41 FINE: main Will apply sql:
865CREATE TABLE IF NOT EXISTS phasing_poll_voter (db_id IDENTITY, transaction_id BIGINT NOT NULL, transaction_full_hash BINARY(32) NOT NULL, voter_id BIGINT NOT NULL, sub_poll_name VARCHAR, height INT NOT NULL)
8662018-11-09 08:41:41 FINE: main Will apply sql:
867CREATE INDEX IF NOT EXISTS vote_height_idx ON vote(height)
8682018-11-09 08:41:41 FINE: main Will apply sql:
869CREATE UNIQUE INDEX IF NOT EXISTS poll_id_idx ON poll(id)
8702018-11-09 08:41:41 FINE: main Will apply sql:
871CREATE INDEX IF NOT EXISTS poll_height_idx ON poll(height)
8722018-11-09 08:41:41 FINE: main Will apply sql:
873CREATE INDEX IF NOT EXISTS poll_account_idx ON poll(account_id)
8742018-11-09 08:41:41 FINE: main Will apply sql:
875CREATE INDEX IF NOT EXISTS poll_finish_height_idx ON poll(finish_height DESC)
8762018-11-09 08:41:41 FINE: main Will apply sql:
877CREATE INDEX IF NOT EXISTS poll_result_poll_id_idx ON poll_result(poll_id)
8782018-11-09 08:41:41 FINE: main Will apply sql:
879CREATE INDEX IF NOT EXISTS poll_result_height_idx ON poll_result(height)
8802018-11-09 08:41:41 FINE: main Will apply sql:
881CREATE INDEX IF NOT EXISTS phasing_poll_id_idx ON phasing_poll(id)
8822018-11-09 08:41:41 FINE: main Will apply sql:
883CREATE INDEX IF NOT EXISTS phasing_poll_height_idx ON phasing_poll(height)
8842018-11-09 08:41:41 FINE: main Will apply sql:
885CREATE INDEX IF NOT EXISTS phasing_poll_account_id_idx ON phasing_poll(account_id, height DESC)
8862018-11-09 08:41:41 FINE: main Will apply sql:
887CREATE INDEX IF NOT EXISTS phasing_poll_holding_id_idx ON phasing_poll(holding_id, height DESC)
8882018-11-09 08:41:41 FINE: main Will apply sql:
889CREATE INDEX IF NOT EXISTS phasing_vote_transaction_voter_idx ON phasing_vote(transaction_id, voter_id)
8902018-11-09 08:41:41 FINE: main Will apply sql:
891CREATE INDEX IF NOT EXISTS phasing_poll_voter_transaction_voter_idx ON phasing_poll_voter(transaction_id, voter_id)
8922018-11-09 08:41:41 FINE: main Will apply sql:
893CREATE INDEX IF NOT EXISTS currency_founder_account_id_idx ON currency_founder (account_id, height DESC)
8942018-11-09 08:41:41 FINE: main Will apply sql:
895CREATE INDEX IF NOT EXISTS phasing_poll_voter_height_idx ON phasing_poll_voter(height)
8962018-11-09 08:41:41 FINE: main Will apply sql:
897CREATE INDEX IF NOT EXISTS phasing_vote_height_idx ON phasing_vote(height)
8982018-11-09 08:41:41 FINE: main Will apply sql:
899CREATE INDEX IF NOT EXISTS trade_ask_idx ON trade (ask_order_id, height DESC)
9002018-11-09 08:41:41 FINE: main Will apply sql:
901CREATE INDEX IF NOT EXISTS trade_bid_idx ON trade (bid_order_id, height DESC)
9022018-11-09 08:41:41 FINE: main Will apply sql:
903CREATE TABLE IF NOT EXISTS prunable_message (db_id IDENTITY, id BIGINT NOT NULL, full_hash BINARY(32) NOT NULL, sender_id BIGINT NOT NULL, recipient_id BIGINT, message VARBINARY, message_is_text BOOLEAN NOT NULL, is_compressed BOOLEAN NOT NULL, encrypted_message VARBINARY, encrypted_is_text BOOLEAN DEFAULT FALSE, block_timestamp INT NOT NULL, transaction_timestamp INT NOT NULL, height INT NOT NULL)
9042018-11-09 08:41:41 FINE: main Will apply sql:
905CREATE INDEX IF NOT EXISTS prunable_message_id_idx ON prunable_message (id)
9062018-11-09 08:41:41 FINE: main Will apply sql:
907CREATE INDEX IF NOT EXISTS prunable_message_transaction_timestamp_idx ON prunable_message (transaction_timestamp DESC)
9082018-11-09 08:41:41 FINE: main Will apply sql:
909CREATE INDEX IF NOT EXISTS prunable_message_sender_idx ON prunable_message (sender_id)
9102018-11-09 08:41:41 FINE: main Will apply sql:
911CREATE INDEX IF NOT EXISTS prunable_message_recipient_idx ON prunable_message (recipient_id)
9122018-11-09 08:41:41 FINE: main Will apply sql:
913CREATE INDEX IF NOT EXISTS prunable_message_block_timestamp_dbid_idx ON prunable_message (block_timestamp DESC, db_id DESC)
9142018-11-09 08:41:41 FINE: main Will apply sql:
915CREATE TABLE IF NOT EXISTS tagged_data (db_id IDENTITY, id BIGINT NOT NULL, full_hash BINARY(32) NOT NULL, account_id BIGINT NOT NULL, name VARCHAR NOT NULL, description VARCHAR, tags VARCHAR, parsed_tags ARRAY, type VARCHAR, data VARBINARY NOT NULL, is_text BOOLEAN NOT NULL, channel VARCHAR, filename VARCHAR, block_timestamp INT NOT NULL, transaction_timestamp INT NOT NULL, height INT NOT NULL)
9162018-11-09 08:41:41 FINE: main Will apply sql:
917CREATE INDEX IF NOT EXISTS tagged_data_id_idx ON tagged_data (id)
9182018-11-09 08:41:41 FINE: main Will apply sql:
919CREATE INDEX IF NOT EXISTS tagged_data_expiration_idx ON tagged_data (transaction_timestamp DESC)
9202018-11-09 08:41:41 FINE: main Will apply sql:
921CREATE INDEX IF NOT EXISTS tagged_data_account_id_height_idx ON tagged_data (account_id, height DESC)
9222018-11-09 08:41:41 FINE: main Will apply sql:
923CREATE INDEX IF NOT EXISTS tagged_data_block_timestamp_db_id_idx ON tagged_data (block_timestamp DESC, db_id DESC)
9242018-11-09 08:41:41 FINE: main Will apply sql:
925CREATE TABLE IF NOT EXISTS data_tag (db_id IDENTITY, tag VARCHAR NOT NULL, tag_count INT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
9262018-11-09 08:41:41 FINE: main Will apply sql:
927CREATE UNIQUE INDEX IF NOT EXISTS data_tag_tag_height_idx ON data_tag (tag, height DESC)
9282018-11-09 08:41:41 FINE: main Will apply sql:
929CREATE INDEX IF NOT EXISTS data_tag_count_height_idx ON data_tag (tag_count DESC, height DESC)
9302018-11-09 08:41:41 FINE: main Will apply sql:
931CREATE INDEX IF NOT EXISTS tagged_data_channel_idx ON tagged_data (channel, height DESC)
9322018-11-09 08:41:41 FINE: main Will apply sql:
933CREATE INDEX IF NOT EXISTS balance_height_id_idx ON balance (height, account_id)
9342018-11-09 08:41:41 FINE: main Will apply sql:
935CREATE INDEX IF NOT EXISTS alias_height_id_idx ON alias (height, id)
9362018-11-09 08:41:41 FINE: main Will apply sql:
937CREATE INDEX IF NOT EXISTS alias_offer_height_id_idx ON alias_offer (height, id)
9382018-11-09 08:41:41 FINE: main Will apply sql:
939CREATE INDEX IF NOT EXISTS ask_order_height_id_idx ON ask_order (height, id)
9402018-11-09 08:41:41 FINE: main Will apply sql:
941CREATE INDEX IF NOT EXISTS bid_order_height_id_idx ON bid_order (height, id)
9422018-11-09 08:41:41 FINE: main Will apply sql:
943CREATE INDEX IF NOT EXISTS buy_offer_height_id_idx ON buy_offer (height, id)
9442018-11-09 08:41:41 FINE: main Will apply sql:
945CREATE INDEX IF NOT EXISTS currency_founder_height_id_idx ON currency_founder (height, currency_id, account_id)
9462018-11-09 08:41:41 FINE: main Will apply sql:
947CREATE INDEX IF NOT EXISTS goods_height_id_idx ON goods (height, id)
9482018-11-09 08:41:41 FINE: main Will apply sql:
949CREATE INDEX IF NOT EXISTS purchase_height_id_idx ON purchase (height, id)
9502018-11-09 08:41:41 FINE: main Will apply sql:
951CREATE INDEX IF NOT EXISTS purchase_feedback_height_id_idx ON purchase_feedback (height, id)
9522018-11-09 08:41:41 FINE: main Will apply sql:
953CREATE INDEX IF NOT EXISTS purchase_public_feedback_height_id_idx ON purchase_public_feedback (height, id)
9542018-11-09 08:41:41 FINE: main Will apply sql:
955CREATE INDEX IF NOT EXISTS sell_offer_height_id_idx ON sell_offer (height, id)
9562018-11-09 08:41:41 FINE: main Will apply sql:
957CREATE INDEX IF NOT EXISTS tag_height_tag_idx ON tag (height, tag)
9582018-11-09 08:41:41 FINE: main Will apply sql:
959CREATE INDEX IF NOT EXISTS trade_height_db_id_idx ON trade (height DESC, db_id DESC)
9602018-11-09 08:41:41 FINE: main Will apply sql:
961CREATE INDEX IF NOT EXISTS exchange_height_db_id_idx ON exchange (height DESC, db_id DESC)
9622018-11-09 08:41:41 FINE: main Will apply sql:
963CREATE TABLE IF NOT EXISTS exchange_request (db_id IDENTITY, id BIGINT NOT NULL, full_hash BINARY(32) NOT NULL, account_id BIGINT NOT NULL, currency_id BIGINT NOT NULL, units BIGINT NOT NULL, rate BIGINT NOT NULL, is_buy BOOLEAN NOT NULL, timestamp INT NOT NULL, height INT NOT NULL)
9642018-11-09 08:41:41 FINE: main Will apply sql:
965CREATE INDEX IF NOT EXISTS exchange_request_id_idx ON exchange_request (id)
9662018-11-09 08:41:41 FINE: main Will apply sql:
967CREATE INDEX IF NOT EXISTS exchange_request_account_currency_idx ON exchange_request (account_id, currency_id, height DESC)
9682018-11-09 08:41:41 FINE: main Will apply sql:
969CREATE INDEX IF NOT EXISTS exchange_request_currency_idx ON exchange_request (currency_id, height DESC)
9702018-11-09 08:41:41 FINE: main Will apply sql:
971CREATE INDEX IF NOT EXISTS exchange_request_height_db_id_idx ON exchange_request (height DESC, db_id DESC)
9722018-11-09 08:41:41 FINE: main Will apply sql:
973CREATE INDEX IF NOT EXISTS exchange_request_height_idx ON exchange_request (height)
9742018-11-09 08:41:41 INFO: main Lucene search index deleted
9752018-11-09 08:41:41 INFO: main H2 fulltext function aliases dropped
9762018-11-09 08:41:41 INFO: main NRS fulltext schema created
9772018-11-09 08:41:41 INFO: main Rebuilding the Lucene search index
9782018-11-09 08:41:41 INFO: main Lucene search index deleted
9792018-11-09 08:41:41 INFO: main Lucene search index successfully rebuilt
9802018-11-09 08:41:41 INFO: main NRS fulltext aliases created
9812018-11-09 08:41:41 FINE: main Will apply sql:
982CREATE TABLE IF NOT EXISTS shuffling (db_id IDENTITY, id BIGINT NOT NULL, full_hash BINARY(32) NOT NULL, holding_id BIGINT NULL, holding_type TINYINT NOT NULL, issuer_id BIGINT NOT NULL, amount BIGINT NOT NULL, participant_count TINYINT NOT NULL, blocks_remaining SMALLINT NULL, stage TINYINT NOT NULL, assignee_account_id BIGINT NULL, registrant_count TINYINT NOT NULL, recipient_public_keys ARRAY, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
9832018-11-09 08:41:41 FINE: main Will apply sql:
984CREATE INDEX IF NOT EXISTS shuffling_id_height_idx ON shuffling (id, height DESC)
9852018-11-09 08:41:41 FINE: main Will apply sql:
986CREATE INDEX IF NOT EXISTS shuffling_holding_id_height_idx ON shuffling (holding_id, height DESC)
9872018-11-09 08:41:41 FINE: main Will apply sql:
988CREATE INDEX IF NOT EXISTS shuffling_assignee_account_id_height_idx ON shuffling (assignee_account_id, height DESC)
9892018-11-09 08:41:41 FINE: main Will apply sql:
990CREATE INDEX IF NOT EXISTS shuffling_height_id_idx ON shuffling (height, id)
9912018-11-09 08:41:41 FINE: main Will apply sql:
992CREATE TABLE IF NOT EXISTS shuffling_participant (db_id IDENTITY, shuffling_id BIGINT NOT NULL, shuffling_full_hash BINARY(32) NOT NULL, account_id BIGINT NOT NULL, next_account_id BIGINT NULL, participant_index TINYINT NOT NULL, state TINYINT NOT NULL, blame_data ARRAY, key_seeds ARRAY, data_transaction_full_hash BINARY(32), height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
9932018-11-09 08:41:41 FINE: main Will apply sql:
994CREATE INDEX IF NOT EXISTS shuffling_participant_shuffling_id_account_id_idx ON shuffling_participant (shuffling_id, account_id, height DESC)
9952018-11-09 08:41:41 FINE: main Will apply sql:
996CREATE INDEX IF NOT EXISTS shuffling_participant_height_idx ON shuffling_participant (height, shuffling_id, account_id)
9972018-11-09 08:41:41 FINE: main Will apply sql:
998CREATE TABLE IF NOT EXISTS shuffling_data (db_id IDENTITY, shuffling_id BIGINT NOT NULL, shuffling_full_hash BINARY(32) NOT NULL, account_id BIGINT NOT NULL, data ARRAY, transaction_timestamp INT NOT NULL, height INT NOT NULL)
9992018-11-09 08:41:41 FINE: main Will apply sql:
1000CREATE INDEX IF NOT EXISTS shuffling_data_id_height_idx ON shuffling_data (shuffling_id, height DESC)
10012018-11-09 08:41:41 FINE: main Will apply sql:
1002CREATE INDEX shuffling_data_transaction_timestamp_idx ON shuffling_data (transaction_timestamp DESC)
10032018-11-09 08:41:41 FINE: main Will apply sql:
1004CREATE INDEX IF NOT EXISTS transaction_referenced_transaction_id_idx ON transaction (referenced_transaction_id)
10052018-11-09 08:41:41 FINE: main Will apply sql:
1006CREATE INDEX IF NOT EXISTS shuffling_blocks_remaining_height_idx ON shuffling (blocks_remaining, height DESC)
10072018-11-09 08:41:41 FINE: main Will apply sql:
1008CREATE TABLE IF NOT EXISTS asset_dividend (db_id IDENTITY, id BIGINT NOT NULL, full_hash BINARY(32) NOT NULL, asset_id BIGINT NOT NULL, holding_id BIGINT NOT NULL, holding_type TINYINT NOT NULL, amount BIGINT NOT NULL, dividend_height INT NOT NULL, total_dividend BIGINT NOT NULL, num_accounts BIGINT NOT NULL, timestamp INT NOT NULL, height INT NOT NULL)
10092018-11-09 08:41:41 FINE: main Will apply sql:
1010CREATE INDEX IF NOT EXISTS asset_dividend_id_idx ON asset_dividend (id)
10112018-11-09 08:41:41 FINE: main Will apply sql:
1012CREATE INDEX IF NOT EXISTS asset_dividend_asset_id_idx ON asset_dividend (asset_id, height DESC)
10132018-11-09 08:41:41 FINE: main Will apply sql:
1014CREATE INDEX IF NOT EXISTS asset_dividend_height_idx ON asset_dividend (height)
10152018-11-09 08:41:41 FINE: main Will apply sql:
1016CREATE INDEX IF NOT EXISTS fxt_transaction_id_idx ON transaction (fxt_transaction_id, transaction_index)
10172018-11-09 08:41:41 FINE: main Will apply sql:
1018CREATE TABLE IF NOT EXISTS phasing_sub_poll (db_id IDENTITY, transaction_id BIGINT NOT NULL, transaction_full_hash BINARY(32) NOT NULL, name VARCHAR, whitelist_size TINYINT NOT NULL DEFAULT 0, voting_model TINYINT NOT NULL, quorum BIGINT, min_balance BIGINT, holding_id BIGINT, min_balance_model TINYINT, sender_property_setter_id BIGINT, sender_property_name VARCHAR, sender_property_value VARCHAR, recipient_property_setter_id BIGINT, recipient_property_name VARCHAR, recipient_property_value VARCHAR, hashed_secret VARBINARY, algorithm TINYINT, height INT NOT NULL)
10192018-11-09 08:41:41 FINE: main Will apply sql:
1020CREATE TABLE IF NOT EXISTS phasing_vote_sub_poll (db_id IDENTITY, transaction_id BIGINT NOT NULL, transaction_full_hash BINARY(32) NOT NULL, voter_id BIGINT NOT NULL, sub_poll_name VARCHAR NOT NULL, height INT NOT NULL)
10212018-11-09 08:41:41 FINE: main Will apply sql:
1022CREATE INDEX IF NOT EXISTS phasing_vote_sub_poll_transaction_id_idx ON phasing_vote_sub_poll(transaction_id, voter_id)
10232018-11-09 08:41:41 FINE: main Will apply sql:
1024CREATE INDEX IF NOT EXISTS phasing_vote_sub_poll_height_idx ON phasing_vote_sub_poll(height)
10252018-11-09 08:41:41 FINE: main Will apply sql:
1026CREATE INDEX IF NOT EXISTS phasing_sub_poll_id_idx ON phasing_sub_poll(transaction_id)
10272018-11-09 08:41:41 FINE: main Will apply sql:
1028CREATE INDEX IF NOT EXISTS phasing_sub_poll_height_idx ON phasing_sub_poll(height)
10292018-11-09 08:41:41 FINE: main Will apply sql:
1030CREATE INDEX IF NOT EXISTS prunable_message_height_idx ON prunable_message (height)
10312018-11-09 08:41:41 FINE: main Will apply sql:
1032CREATE INDEX IF NOT EXISTS tagged_data_height_idx ON tagged_data (height)
10332018-11-09 08:41:41 FINE: main Will apply sql:
1034CREATE INDEX IF NOT EXISTS data_tag_height_idx ON data_tag (height)
10352018-11-09 08:41:41 FINE: main Will apply sql:
1036CREATE INDEX IF NOT EXISTS shuffling_data_height_idx ON shuffling_data (height)
10372018-11-09 08:41:41 INFO: main Initializing an empty database
10382018-11-09 08:41:41 FINE: main Will apply sql:
1039CREATE TABLE IF NOT EXISTS transaction (db_id IDENTITY, id BIGINT NOT NULL, deadline SMALLINT NOT NULL, recipient_id BIGINT, transaction_index SMALLINT NOT NULL, amount BIGINT NOT NULL, fee BIGINT NOT NULL, full_hash BINARY(32) NOT NULL, height INT NOT NULL, block_id BIGINT NOT NULL, FOREIGN KEY (block_id) REFERENCES PUBLIC.block (id) ON DELETE CASCADE, signature BINARY(64) NOT NULL, timestamp INT NOT NULL, type TINYINT NOT NULL, subtype TINYINT NOT NULL, sender_id BIGINT NOT NULL, block_timestamp INT NOT NULL, referenced_transaction_chain_id INT, referenced_transaction_full_hash BINARY(32), referenced_transaction_id BIGINT, phased BOOLEAN NOT NULL DEFAULT FALSE, fxt_transaction_id BIGINT NOT NULL, attachment_bytes VARBINARY, version TINYINT NOT NULL, has_message BOOLEAN NOT NULL DEFAULT FALSE, has_encrypted_message BOOLEAN NOT NULL DEFAULT FALSE, has_public_key_announcement BOOLEAN NOT NULL DEFAULT FALSE, ec_block_height INT DEFAULT NULL, ec_block_id BIGINT DEFAULT NULL, has_encrypttoself_message BOOLEAN NOT NULL DEFAULT FALSE, has_prunable_message BOOLEAN NOT NULL DEFAULT FALSE, has_prunable_encrypted_message BOOLEAN NOT NULL DEFAULT FALSE, has_prunable_attachment BOOLEAN NOT NULL DEFAULT FALSE)
10402018-11-09 08:41:41 FINE: main Will apply sql:
1041CREATE INDEX IF NOT EXISTS transaction_id_idx ON transaction (id)
10422018-11-09 08:41:41 FINE: main Will apply sql:
1043CREATE INDEX IF NOT EXISTS transaction_sender_id_idx ON transaction (sender_id)
10442018-11-09 08:41:41 FINE: main Will apply sql:
1045CREATE INDEX IF NOT EXISTS transaction_recipient_id_idx ON transaction (recipient_id)
10462018-11-09 08:41:41 FINE: main Will apply sql:
1047CREATE INDEX IF NOT EXISTS transaction_block_timestamp_idx ON transaction (block_timestamp DESC)
10482018-11-09 08:41:41 FINE: main Will apply sql:
1049CREATE TABLE IF NOT EXISTS alias (db_id IDENTITY, id BIGINT NOT NULL, account_id BIGINT NOT NULL, alias_name VARCHAR NOT NULL, alias_name_lower VARCHAR NOT NULL, alias_uri VARCHAR NOT NULL, timestamp INT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
10502018-11-09 08:41:41 FINE: main Will apply sql:
1051CREATE UNIQUE INDEX IF NOT EXISTS alias_id_height_idx ON alias (id, height DESC)
10522018-11-09 08:41:41 FINE: main Will apply sql:
1053CREATE INDEX IF NOT EXISTS alias_account_id_idx ON alias (account_id, height DESC)
10542018-11-09 08:41:41 FINE: main Will apply sql:
1055CREATE INDEX IF NOT EXISTS alias_name_lower_idx ON alias (alias_name_lower)
10562018-11-09 08:41:41 FINE: main Will apply sql:
1057CREATE TABLE IF NOT EXISTS alias_offer (db_id IDENTITY, id BIGINT NOT NULL, price BIGINT NOT NULL, buyer_id BIGINT, height INT NOT NULL, latest BOOLEAN DEFAULT TRUE NOT NULL)
10582018-11-09 08:41:41 FINE: main Will apply sql:
1059CREATE UNIQUE INDEX IF NOT EXISTS alias_offer_id_height_idx ON alias_offer (id, height DESC)
10602018-11-09 08:41:41 FINE: main Will apply sql:
1061CREATE TABLE IF NOT EXISTS trade (db_id IDENTITY, asset_id BIGINT NOT NULL, block_id BIGINT NOT NULL, ask_order_id BIGINT NOT NULL, ask_order_full_hash BINARY(32) NOT NULL, bid_order_id BIGINT NOT NULL, bid_order_full_hash BINARY(32) NOT NULL, ask_order_height INT NOT NULL, bid_order_height INT NOT NULL, seller_id BIGINT NOT NULL, buyer_id BIGINT NOT NULL, is_buy BOOLEAN NOT NULL, quantity BIGINT NOT NULL, price BIGINT NOT NULL, timestamp INT NOT NULL, height INT NOT NULL)
10622018-11-09 08:41:41 FINE: main Will apply sql:
1063CREATE INDEX IF NOT EXISTS trade_asset_id_idx ON trade (asset_id, height DESC)
10642018-11-09 08:41:41 FINE: main Will apply sql:
1065CREATE INDEX IF NOT EXISTS trade_seller_id_idx ON trade (seller_id, height DESC)
10662018-11-09 08:41:41 FINE: main Will apply sql:
1067CREATE INDEX IF NOT EXISTS trade_buyer_id_idx ON trade (buyer_id, height DESC)
10682018-11-09 08:41:41 FINE: main Will apply sql:
1069CREATE TABLE IF NOT EXISTS ask_order (db_id IDENTITY, id BIGINT NOT NULL, full_hash BINARY(32) NOT NULL, account_id BIGINT NOT NULL, asset_id BIGINT NOT NULL, price BIGINT NOT NULL, transaction_index SMALLINT NOT NULL, transaction_height INT NOT NULL, quantity BIGINT NOT NULL, creation_height INT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
10702018-11-09 08:41:41 FINE: main Will apply sql:
1071CREATE UNIQUE INDEX IF NOT EXISTS ask_order_id_height_idx ON ask_order (id, height DESC)
10722018-11-09 08:41:41 FINE: main Will apply sql:
1073CREATE INDEX IF NOT EXISTS ask_order_account_id_idx ON ask_order (account_id, height DESC)
10742018-11-09 08:41:41 FINE: main Will apply sql:
1075CREATE INDEX IF NOT EXISTS ask_order_asset_id_price_idx ON ask_order (asset_id, price)
10762018-11-09 08:41:41 FINE: main Will apply sql:
1077CREATE TABLE IF NOT EXISTS bid_order (db_id IDENTITY, id BIGINT NOT NULL, full_hash BINARY(32) NOT NULL, account_id BIGINT NOT NULL, asset_id BIGINT NOT NULL, price BIGINT NOT NULL, transaction_index SMALLINT NOT NULL, transaction_height INT NOT NULL, amount BIGINT NOT NULL, quantity BIGINT NOT NULL, creation_height INT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
10782018-11-09 08:41:41 FINE: main Will apply sql:
1079CREATE UNIQUE INDEX IF NOT EXISTS bid_order_id_height_idx ON bid_order (id, height DESC)
10802018-11-09 08:41:41 FINE: main Will apply sql:
1081CREATE INDEX IF NOT EXISTS bid_order_account_id_idx ON bid_order (account_id, height DESC)
10822018-11-09 08:41:41 FINE: main Will apply sql:
1083CREATE INDEX IF NOT EXISTS bid_order_asset_id_price_idx ON bid_order (asset_id, price DESC)
10842018-11-09 08:41:41 FINE: main Will apply sql:
1085CREATE TABLE IF NOT EXISTS goods (db_id IDENTITY, id BIGINT NOT NULL, full_hash BINARY(32), seller_id BIGINT NOT NULL, name VARCHAR NOT NULL, description VARCHAR, parsed_tags ARRAY, has_image BOOLEAN NOT NULL, tags VARCHAR, timestamp INT NOT NULL, quantity INT NOT NULL, price BIGINT NOT NULL, delisted BOOLEAN NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
10862018-11-09 08:41:41 FINE: main Will apply sql:
1087CREATE UNIQUE INDEX IF NOT EXISTS goods_id_height_idx ON goods (id, height DESC)
10882018-11-09 08:41:41 FINE: main Will apply sql:
1089CREATE INDEX IF NOT EXISTS goods_seller_id_name_idx ON goods (seller_id, name)
10902018-11-09 08:41:41 FINE: main Will apply sql:
1091CREATE INDEX IF NOT EXISTS goods_timestamp_idx ON goods (timestamp DESC, height DESC)
10922018-11-09 08:41:41 FINE: main Will apply sql:
1093CREATE TABLE IF NOT EXISTS purchase (db_id IDENTITY, id BIGINT NOT NULL, buyer_id BIGINT NOT NULL, goods_id BIGINT NOT NULL, seller_id BIGINT NOT NULL, quantity INT NOT NULL, price BIGINT NOT NULL, deadline INT NOT NULL, note VARBINARY, nonce BINARY(32), timestamp INT NOT NULL, pending BOOLEAN NOT NULL, goods VARBINARY, goods_nonce BINARY(32), goods_is_text BOOLEAN NOT NULL DEFAULT TRUE, refund_note VARBINARY, refund_nonce BINARY(32), has_feedback_notes BOOLEAN NOT NULL DEFAULT FALSE, has_public_feedbacks BOOLEAN NOT NULL DEFAULT FALSE, discount BIGINT NOT NULL, refund BIGINT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
10942018-11-09 08:41:41 FINE: main Will apply sql:
1095CREATE UNIQUE INDEX IF NOT EXISTS purchase_id_height_idx ON purchase (id, height DESC)
10962018-11-09 08:41:41 FINE: main Will apply sql:
1097CREATE INDEX IF NOT EXISTS purchase_buyer_id_height_idx ON purchase (buyer_id, height DESC)
10982018-11-09 08:41:41 FINE: main Will apply sql:
1099CREATE INDEX IF NOT EXISTS purchase_seller_id_height_idx ON purchase (seller_id, height DESC)
11002018-11-09 08:41:41 FINE: main Will apply sql:
1101CREATE INDEX IF NOT EXISTS purchase_deadline_idx ON purchase (deadline DESC, height DESC)
11022018-11-09 08:41:41 FINE: main Will apply sql:
1103CREATE TABLE IF NOT EXISTS balance (db_id IDENTITY, account_id BIGINT NOT NULL, balance BIGINT NOT NULL, unconfirmed_balance BIGINT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
11042018-11-09 08:41:41 FINE: main Will apply sql:
1105CREATE UNIQUE INDEX IF NOT EXISTS balance_id_height_idx ON balance (account_id, height DESC)
11062018-11-09 08:41:41 FINE: main Will apply sql:
1107CREATE TABLE IF NOT EXISTS purchase_feedback (db_id IDENTITY, id BIGINT NOT NULL, feedback_data VARBINARY NOT NULL, feedback_nonce BINARY(32) NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
11082018-11-09 08:41:41 FINE: main Will apply sql:
1109CREATE INDEX IF NOT EXISTS purchase_feedback_id_height_idx ON purchase_feedback (id, height DESC)
11102018-11-09 08:41:41 FINE: main Will apply sql:
1111CREATE TABLE IF NOT EXISTS purchase_public_feedback (db_id IDENTITY, id BIGINT NOT NULL, public_feedback VARCHAR NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
11122018-11-09 08:41:41 FINE: main Will apply sql:
1113CREATE INDEX IF NOT EXISTS purchase_public_feedback_id_height_idx ON purchase_public_feedback (id, height DESC)
11142018-11-09 08:41:41 FINE: main Will apply sql:
1115CREATE INDEX IF NOT EXISTS purchase_timestamp_idx ON purchase (timestamp DESC, id)
11162018-11-09 08:41:41 FINE: main Will apply sql:
1117CREATE INDEX IF NOT EXISTS ask_order_creation_idx ON ask_order (creation_height DESC)
11182018-11-09 08:41:41 FINE: main Will apply sql:
1119CREATE INDEX IF NOT EXISTS bid_order_creation_idx ON bid_order (creation_height DESC)
11202018-11-09 08:41:41 FINE: main Will apply sql:
1121CREATE TABLE IF NOT EXISTS tag (db_id IDENTITY, tag VARCHAR NOT NULL, in_stock_count INT NOT NULL, total_count INT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
11222018-11-09 08:41:41 FINE: main Will apply sql:
1123CREATE UNIQUE INDEX IF NOT EXISTS tag_tag_idx ON tag (tag, height DESC)
11242018-11-09 08:41:41 FINE: main Will apply sql:
1125CREATE INDEX IF NOT EXISTS tag_in_stock_count_idx ON tag (in_stock_count DESC, height DESC)
11262018-11-09 08:41:41 FINE: main Will apply sql:
1127CREATE TABLE IF NOT EXISTS currency_founder (db_id IDENTITY, currency_id BIGINT NOT NULL, account_id BIGINT NOT NULL, amount_per_unit BIGINT NOT NULL, amount BIGINT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
11282018-11-09 08:41:41 FINE: main Will apply sql:
1129CREATE UNIQUE INDEX IF NOT EXISTS currency_founder_currency_id_idx ON currency_founder (currency_id, account_id, height DESC)
11302018-11-09 08:41:41 FINE: main Will apply sql:
1131CREATE TABLE IF NOT EXISTS buy_offer (db_id IDENTITY, id BIGINT NOT NULL, full_hash BINARY(32) NOT NULL, currency_id BIGINT NOT NULL, account_id BIGINT NOT NULL,rate BIGINT NOT NULL, unit_limit BIGINT NOT NULL, supply BIGINT NOT NULL, expiration_height INT NOT NULL, amount BIGINT NOT NULL, creation_height INT NOT NULL, transaction_index SMALLINT NOT NULL, transaction_height INT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
11322018-11-09 08:41:41 FINE: main Will apply sql:
1133CREATE UNIQUE INDEX IF NOT EXISTS buy_offer_id_idx ON buy_offer (id, height DESC)
11342018-11-09 08:41:41 FINE: main Will apply sql:
1135CREATE INDEX IF NOT EXISTS buy_offer_currency_id_account_id_idx ON buy_offer (currency_id, account_id, height DESC)
11362018-11-09 08:41:41 FINE: main Will apply sql:
1137CREATE TABLE IF NOT EXISTS sell_offer (db_id IDENTITY, id BIGINT NOT NULL, full_hash BINARY(32) NOT NULL, currency_id BIGINT NOT NULL, account_id BIGINT NOT NULL, rate BIGINT NOT NULL, unit_limit BIGINT NOT NULL, supply BIGINT NOT NULL, expiration_height INT NOT NULL, creation_height INT NOT NULL, transaction_index SMALLINT NOT NULL, transaction_height INT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
11382018-11-09 08:41:41 FINE: main Will apply sql:
1139CREATE UNIQUE INDEX IF NOT EXISTS sell_offer_id_idx ON sell_offer (id, height DESC)
11402018-11-09 08:41:41 FINE: main Will apply sql:
1141CREATE INDEX IF NOT EXISTS sell_offer_currency_id_account_id_idx ON sell_offer (currency_id, account_id, height DESC)
11422018-11-09 08:41:41 FINE: main Will apply sql:
1143CREATE TABLE IF NOT EXISTS exchange (db_id IDENTITY, transaction_id BIGINT NOT NULL, transaction_full_hash BINARY(32) NOT NULL, currency_id BIGINT NOT NULL, block_id BIGINT NOT NULL, offer_id BIGINT NOT NULL, offer_full_hash BINARY(32) NOT NULL, seller_id BIGINT NOT NULL, buyer_id BIGINT NOT NULL, units BIGINT NOT NULL, rate BIGINT NOT NULL, timestamp INT NOT NULL, height INT NOT NULL)
11442018-11-09 08:41:41 FINE: main Will apply sql:
1145CREATE INDEX IF NOT EXISTS exchange_offer_idx ON exchange (transaction_id, offer_id)
11462018-11-09 08:41:41 FINE: main Will apply sql:
1147CREATE INDEX IF NOT EXISTS exchange_currency_id_idx ON exchange (currency_id, height DESC)
11482018-11-09 08:41:41 FINE: main Will apply sql:
1149CREATE INDEX IF NOT EXISTS exchange_seller_id_idx ON exchange (seller_id, height DESC)
11502018-11-09 08:41:41 FINE: main Will apply sql:
1151CREATE INDEX IF NOT EXISTS exchange_buyer_id_idx ON exchange (buyer_id, height DESC)
11522018-11-09 08:41:41 FINE: main Will apply sql:
1153CREATE INDEX IF NOT EXISTS buy_offer_rate_height_idx ON buy_offer (rate DESC, creation_height ASC)
11542018-11-09 08:41:41 FINE: main Will apply sql:
1155CREATE INDEX IF NOT EXISTS sell_offer_rate_height_idx ON sell_offer (rate ASC, creation_height ASC)
11562018-11-09 08:41:41 FINE: main Will apply sql:
1157CREATE INDEX IF NOT EXISTS exchange_height_idx ON exchange(height)
11582018-11-09 08:41:41 FINE: main Will apply sql:
1159CREATE INDEX IF NOT EXISTS trade_height_idx ON trade(height)
11602018-11-09 08:41:41 FINE: main Will apply sql:
1161CREATE TABLE IF NOT EXISTS vote (db_id IDENTITY, id BIGINT NOT NULL, full_hash BINARY(32) NOT NULL, poll_id BIGINT NOT NULL, voter_id BIGINT NOT NULL, vote_bytes VARBINARY NOT NULL, height INT NOT NULL)
11622018-11-09 08:41:41 FINE: main Will apply sql:
1163CREATE INDEX IF NOT EXISTS vote_id_idx ON vote (id)
11642018-11-09 08:41:41 FINE: main Will apply sql:
1165CREATE UNIQUE INDEX IF NOT EXISTS vote_poll_id_idx ON vote (poll_id, voter_id)
11662018-11-09 08:41:41 FINE: main Will apply sql:
1167CREATE TABLE IF NOT EXISTS poll (db_id IDENTITY, id BIGINT NOT NULL, account_id BIGINT NOT NULL, name VARCHAR NOT NULL, description VARCHAR, options ARRAY NOT NULL, min_num_options TINYINT, max_num_options TINYINT, min_range_value TINYINT, max_range_value TINYINT, timestamp INT NOT NULL, finish_height INT NOT NULL, voting_model TINYINT NOT NULL, min_balance BIGINT, min_balance_model TINYINT, holding_id BIGINT, height INT NOT NULL)
11682018-11-09 08:41:41 FINE: main Will apply sql:
1169CREATE TABLE IF NOT EXISTS poll_result (db_id IDENTITY, poll_id BIGINT NOT NULL, result BIGINT, weight BIGINT NOT NULL, height INT NOT NULL)
11702018-11-09 08:41:41 FINE: main Will apply sql:
1171CREATE TABLE IF NOT EXISTS phasing_poll (db_id IDENTITY, id BIGINT NOT NULL, full_hash BINARY(32) NOT NULL, account_id BIGINT NOT NULL, whitelist_size TINYINT NOT NULL DEFAULT 0, finish_height INT NOT NULL, voting_model TINYINT NOT NULL, quorum BIGINT, min_balance BIGINT, holding_id BIGINT, min_balance_model TINYINT, expression VARCHAR, recipient_account_id BIGINT, sender_property_setter_id BIGINT, sender_property_name VARCHAR, sender_property_value VARCHAR, recipient_property_setter_id BIGINT, recipient_property_name VARCHAR, recipient_property_value VARCHAR, hashed_secret VARBINARY, algorithm TINYINT, height INT NOT NULL)
11722018-11-09 08:41:41 FINE: main Will apply sql:
1173CREATE TABLE IF NOT EXISTS phasing_vote (db_id IDENTITY, vote_id BIGINT NOT NULL, vote_full_hash BINARY(32) NOT NULL, transaction_id BIGINT NOT NULL, transaction_full_hash BINARY(32) NOT NULL, voter_id BIGINT NOT NULL, height INT NOT NULL)
11742018-11-09 08:41:41 FINE: main Will apply sql:
1175CREATE TABLE IF NOT EXISTS phasing_poll_voter (db_id IDENTITY, transaction_id BIGINT NOT NULL, transaction_full_hash BINARY(32) NOT NULL, voter_id BIGINT NOT NULL, sub_poll_name VARCHAR, height INT NOT NULL)
11762018-11-09 08:41:41 FINE: main Will apply sql:
1177CREATE INDEX IF NOT EXISTS vote_height_idx ON vote(height)
11782018-11-09 08:41:41 FINE: main Will apply sql:
1179CREATE UNIQUE INDEX IF NOT EXISTS poll_id_idx ON poll(id)
11802018-11-09 08:41:41 FINE: main Will apply sql:
1181CREATE INDEX IF NOT EXISTS poll_height_idx ON poll(height)
11822018-11-09 08:41:41 FINE: main Will apply sql:
1183CREATE INDEX IF NOT EXISTS poll_account_idx ON poll(account_id)
11842018-11-09 08:41:41 FINE: main Will apply sql:
1185CREATE INDEX IF NOT EXISTS poll_finish_height_idx ON poll(finish_height DESC)
11862018-11-09 08:41:41 FINE: main Will apply sql:
1187CREATE INDEX IF NOT EXISTS poll_result_poll_id_idx ON poll_result(poll_id)
11882018-11-09 08:41:41 FINE: main Will apply sql:
1189CREATE INDEX IF NOT EXISTS poll_result_height_idx ON poll_result(height)
11902018-11-09 08:41:41 FINE: main Will apply sql:
1191CREATE INDEX IF NOT EXISTS phasing_poll_id_idx ON phasing_poll(id)
11922018-11-09 08:41:41 FINE: main Will apply sql:
1193CREATE INDEX IF NOT EXISTS phasing_poll_height_idx ON phasing_poll(height)
11942018-11-09 08:41:41 FINE: main Will apply sql:
1195CREATE INDEX IF NOT EXISTS phasing_poll_account_id_idx ON phasing_poll(account_id, height DESC)
11962018-11-09 08:41:41 FINE: main Will apply sql:
1197CREATE INDEX IF NOT EXISTS phasing_poll_holding_id_idx ON phasing_poll(holding_id, height DESC)
11982018-11-09 08:41:41 FINE: main Will apply sql:
1199CREATE INDEX IF NOT EXISTS phasing_vote_transaction_voter_idx ON phasing_vote(transaction_id, voter_id)
12002018-11-09 08:41:41 FINE: main Will apply sql:
1201CREATE INDEX IF NOT EXISTS phasing_poll_voter_transaction_voter_idx ON phasing_poll_voter(transaction_id, voter_id)
12022018-11-09 08:41:41 FINE: main Will apply sql:
1203CREATE INDEX IF NOT EXISTS currency_founder_account_id_idx ON currency_founder (account_id, height DESC)
12042018-11-09 08:41:41 FINE: main Will apply sql:
1205CREATE INDEX IF NOT EXISTS phasing_poll_voter_height_idx ON phasing_poll_voter(height)
12062018-11-09 08:41:41 FINE: main Will apply sql:
1207CREATE INDEX IF NOT EXISTS phasing_vote_height_idx ON phasing_vote(height)
12082018-11-09 08:41:41 FINE: main Will apply sql:
1209CREATE INDEX IF NOT EXISTS trade_ask_idx ON trade (ask_order_id, height DESC)
12102018-11-09 08:41:41 FINE: main Will apply sql:
1211CREATE INDEX IF NOT EXISTS trade_bid_idx ON trade (bid_order_id, height DESC)
12122018-11-09 08:41:41 FINE: main Will apply sql:
1213CREATE TABLE IF NOT EXISTS prunable_message (db_id IDENTITY, id BIGINT NOT NULL, full_hash BINARY(32) NOT NULL, sender_id BIGINT NOT NULL, recipient_id BIGINT, message VARBINARY, message_is_text BOOLEAN NOT NULL, is_compressed BOOLEAN NOT NULL, encrypted_message VARBINARY, encrypted_is_text BOOLEAN DEFAULT FALSE, block_timestamp INT NOT NULL, transaction_timestamp INT NOT NULL, height INT NOT NULL)
12142018-11-09 08:41:41 FINE: main Will apply sql:
1215CREATE INDEX IF NOT EXISTS prunable_message_id_idx ON prunable_message (id)
12162018-11-09 08:41:41 FINE: main Will apply sql:
1217CREATE INDEX IF NOT EXISTS prunable_message_transaction_timestamp_idx ON prunable_message (transaction_timestamp DESC)
12182018-11-09 08:41:41 FINE: main Will apply sql:
1219CREATE INDEX IF NOT EXISTS prunable_message_sender_idx ON prunable_message (sender_id)
12202018-11-09 08:41:41 FINE: main Will apply sql:
1221CREATE INDEX IF NOT EXISTS prunable_message_recipient_idx ON prunable_message (recipient_id)
12222018-11-09 08:41:41 FINE: main Will apply sql:
1223CREATE INDEX IF NOT EXISTS prunable_message_block_timestamp_dbid_idx ON prunable_message (block_timestamp DESC, db_id DESC)
12242018-11-09 08:41:41 FINE: main Will apply sql:
1225CREATE TABLE IF NOT EXISTS tagged_data (db_id IDENTITY, id BIGINT NOT NULL, full_hash BINARY(32) NOT NULL, account_id BIGINT NOT NULL, name VARCHAR NOT NULL, description VARCHAR, tags VARCHAR, parsed_tags ARRAY, type VARCHAR, data VARBINARY NOT NULL, is_text BOOLEAN NOT NULL, channel VARCHAR, filename VARCHAR, block_timestamp INT NOT NULL, transaction_timestamp INT NOT NULL, height INT NOT NULL)
12262018-11-09 08:41:41 FINE: main Will apply sql:
1227CREATE INDEX IF NOT EXISTS tagged_data_id_idx ON tagged_data (id)
12282018-11-09 08:41:41 FINE: main Will apply sql:
1229CREATE INDEX IF NOT EXISTS tagged_data_expiration_idx ON tagged_data (transaction_timestamp DESC)
12302018-11-09 08:41:41 FINE: main Will apply sql:
1231CREATE INDEX IF NOT EXISTS tagged_data_account_id_height_idx ON tagged_data (account_id, height DESC)
12322018-11-09 08:41:41 FINE: main Will apply sql:
1233CREATE INDEX IF NOT EXISTS tagged_data_block_timestamp_db_id_idx ON tagged_data (block_timestamp DESC, db_id DESC)
12342018-11-09 08:41:41 FINE: main Will apply sql:
1235CREATE TABLE IF NOT EXISTS data_tag (db_id IDENTITY, tag VARCHAR NOT NULL, tag_count INT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
12362018-11-09 08:41:41 FINE: main Will apply sql:
1237CREATE UNIQUE INDEX IF NOT EXISTS data_tag_tag_height_idx ON data_tag (tag, height DESC)
12382018-11-09 08:41:41 FINE: main Will apply sql:
1239CREATE INDEX IF NOT EXISTS data_tag_count_height_idx ON data_tag (tag_count DESC, height DESC)
12402018-11-09 08:41:41 FINE: main Will apply sql:
1241CREATE INDEX IF NOT EXISTS tagged_data_channel_idx ON tagged_data (channel, height DESC)
12422018-11-09 08:41:41 FINE: main Will apply sql:
1243CREATE INDEX IF NOT EXISTS balance_height_id_idx ON balance (height, account_id)
12442018-11-09 08:41:41 FINE: main Will apply sql:
1245CREATE INDEX IF NOT EXISTS alias_height_id_idx ON alias (height, id)
12462018-11-09 08:41:41 FINE: main Will apply sql:
1247CREATE INDEX IF NOT EXISTS alias_offer_height_id_idx ON alias_offer (height, id)
12482018-11-09 08:41:41 FINE: main Will apply sql:
1249CREATE INDEX IF NOT EXISTS ask_order_height_id_idx ON ask_order (height, id)
12502018-11-09 08:41:41 FINE: main Will apply sql:
1251CREATE INDEX IF NOT EXISTS bid_order_height_id_idx ON bid_order (height, id)
12522018-11-09 08:41:41 FINE: main Will apply sql:
1253CREATE INDEX IF NOT EXISTS buy_offer_height_id_idx ON buy_offer (height, id)
12542018-11-09 08:41:41 FINE: main Will apply sql:
1255CREATE INDEX IF NOT EXISTS currency_founder_height_id_idx ON currency_founder (height, currency_id, account_id)
12562018-11-09 08:41:41 FINE: main Will apply sql:
1257CREATE INDEX IF NOT EXISTS goods_height_id_idx ON goods (height, id)
12582018-11-09 08:41:41 FINE: main Will apply sql:
1259CREATE INDEX IF NOT EXISTS purchase_height_id_idx ON purchase (height, id)
12602018-11-09 08:41:41 FINE: main Will apply sql:
1261CREATE INDEX IF NOT EXISTS purchase_feedback_height_id_idx ON purchase_feedback (height, id)
12622018-11-09 08:41:41 FINE: main Will apply sql:
1263CREATE INDEX IF NOT EXISTS purchase_public_feedback_height_id_idx ON purchase_public_feedback (height, id)
12642018-11-09 08:41:41 FINE: main Will apply sql:
1265CREATE INDEX IF NOT EXISTS sell_offer_height_id_idx ON sell_offer (height, id)
12662018-11-09 08:41:41 FINE: main Will apply sql:
1267CREATE INDEX IF NOT EXISTS tag_height_tag_idx ON tag (height, tag)
12682018-11-09 08:41:41 FINE: main Will apply sql:
1269CREATE INDEX IF NOT EXISTS trade_height_db_id_idx ON trade (height DESC, db_id DESC)
12702018-11-09 08:41:41 FINE: main Will apply sql:
1271CREATE INDEX IF NOT EXISTS exchange_height_db_id_idx ON exchange (height DESC, db_id DESC)
12722018-11-09 08:41:41 FINE: main Will apply sql:
1273CREATE TABLE IF NOT EXISTS exchange_request (db_id IDENTITY, id BIGINT NOT NULL, full_hash BINARY(32) NOT NULL, account_id BIGINT NOT NULL, currency_id BIGINT NOT NULL, units BIGINT NOT NULL, rate BIGINT NOT NULL, is_buy BOOLEAN NOT NULL, timestamp INT NOT NULL, height INT NOT NULL)
12742018-11-09 08:41:41 FINE: main Will apply sql:
1275CREATE INDEX IF NOT EXISTS exchange_request_id_idx ON exchange_request (id)
12762018-11-09 08:41:41 FINE: main Will apply sql:
1277CREATE INDEX IF NOT EXISTS exchange_request_account_currency_idx ON exchange_request (account_id, currency_id, height DESC)
12782018-11-09 08:41:41 FINE: main Will apply sql:
1279CREATE INDEX IF NOT EXISTS exchange_request_currency_idx ON exchange_request (currency_id, height DESC)
12802018-11-09 08:41:41 FINE: main Will apply sql:
1281CREATE INDEX IF NOT EXISTS exchange_request_height_db_id_idx ON exchange_request (height DESC, db_id DESC)
12822018-11-09 08:41:41 FINE: main Will apply sql:
1283CREATE INDEX IF NOT EXISTS exchange_request_height_idx ON exchange_request (height)
12842018-11-09 08:41:41 INFO: main Lucene search index deleted
12852018-11-09 08:41:42 INFO: main H2 fulltext function aliases dropped
12862018-11-09 08:41:42 INFO: main NRS fulltext schema created
12872018-11-09 08:41:42 INFO: main Rebuilding the Lucene search index
12882018-11-09 08:41:42 INFO: main Lucene search index deleted
12892018-11-09 08:41:42 INFO: main Lucene search index successfully rebuilt
12902018-11-09 08:41:42 INFO: main NRS fulltext aliases created
12912018-11-09 08:41:42 FINE: main Will apply sql:
1292CREATE TABLE IF NOT EXISTS shuffling (db_id IDENTITY, id BIGINT NOT NULL, full_hash BINARY(32) NOT NULL, holding_id BIGINT NULL, holding_type TINYINT NOT NULL, issuer_id BIGINT NOT NULL, amount BIGINT NOT NULL, participant_count TINYINT NOT NULL, blocks_remaining SMALLINT NULL, stage TINYINT NOT NULL, assignee_account_id BIGINT NULL, registrant_count TINYINT NOT NULL, recipient_public_keys ARRAY, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
12932018-11-09 08:41:42 FINE: main Will apply sql:
1294CREATE INDEX IF NOT EXISTS shuffling_id_height_idx ON shuffling (id, height DESC)
12952018-11-09 08:41:42 FINE: main Will apply sql:
1296CREATE INDEX IF NOT EXISTS shuffling_holding_id_height_idx ON shuffling (holding_id, height DESC)
12972018-11-09 08:41:42 FINE: main Will apply sql:
1298CREATE INDEX IF NOT EXISTS shuffling_assignee_account_id_height_idx ON shuffling (assignee_account_id, height DESC)
12992018-11-09 08:41:42 FINE: main Will apply sql:
1300CREATE INDEX IF NOT EXISTS shuffling_height_id_idx ON shuffling (height, id)
13012018-11-09 08:41:42 FINE: main Will apply sql:
1302CREATE TABLE IF NOT EXISTS shuffling_participant (db_id IDENTITY, shuffling_id BIGINT NOT NULL, shuffling_full_hash BINARY(32) NOT NULL, account_id BIGINT NOT NULL, next_account_id BIGINT NULL, participant_index TINYINT NOT NULL, state TINYINT NOT NULL, blame_data ARRAY, key_seeds ARRAY, data_transaction_full_hash BINARY(32), height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
13032018-11-09 08:41:42 FINE: main Will apply sql:
1304CREATE INDEX IF NOT EXISTS shuffling_participant_shuffling_id_account_id_idx ON shuffling_participant (shuffling_id, account_id, height DESC)
13052018-11-09 08:41:42 FINE: main Will apply sql:
1306CREATE INDEX IF NOT EXISTS shuffling_participant_height_idx ON shuffling_participant (height, shuffling_id, account_id)
13072018-11-09 08:41:42 FINE: main Will apply sql:
1308CREATE TABLE IF NOT EXISTS shuffling_data (db_id IDENTITY, shuffling_id BIGINT NOT NULL, shuffling_full_hash BINARY(32) NOT NULL, account_id BIGINT NOT NULL, data ARRAY, transaction_timestamp INT NOT NULL, height INT NOT NULL)
13092018-11-09 08:41:42 FINE: main Will apply sql:
1310CREATE INDEX IF NOT EXISTS shuffling_data_id_height_idx ON shuffling_data (shuffling_id, height DESC)
13112018-11-09 08:41:42 FINE: main Will apply sql:
1312CREATE INDEX shuffling_data_transaction_timestamp_idx ON shuffling_data (transaction_timestamp DESC)
13132018-11-09 08:41:42 FINE: main Will apply sql:
1314CREATE INDEX IF NOT EXISTS transaction_referenced_transaction_id_idx ON transaction (referenced_transaction_id)
13152018-11-09 08:41:42 FINE: main Will apply sql:
1316CREATE INDEX IF NOT EXISTS shuffling_blocks_remaining_height_idx ON shuffling (blocks_remaining, height DESC)
13172018-11-09 08:41:42 FINE: main Will apply sql:
1318CREATE TABLE IF NOT EXISTS asset_dividend (db_id IDENTITY, id BIGINT NOT NULL, full_hash BINARY(32) NOT NULL, asset_id BIGINT NOT NULL, holding_id BIGINT NOT NULL, holding_type TINYINT NOT NULL, amount BIGINT NOT NULL, dividend_height INT NOT NULL, total_dividend BIGINT NOT NULL, num_accounts BIGINT NOT NULL, timestamp INT NOT NULL, height INT NOT NULL)
13192018-11-09 08:41:42 FINE: main Will apply sql:
1320CREATE INDEX IF NOT EXISTS asset_dividend_id_idx ON asset_dividend (id)
13212018-11-09 08:41:42 FINE: main Will apply sql:
1322CREATE INDEX IF NOT EXISTS asset_dividend_asset_id_idx ON asset_dividend (asset_id, height DESC)
13232018-11-09 08:41:42 FINE: main Will apply sql:
1324CREATE INDEX IF NOT EXISTS asset_dividend_height_idx ON asset_dividend (height)
13252018-11-09 08:41:42 FINE: main Will apply sql:
1326CREATE INDEX IF NOT EXISTS fxt_transaction_id_idx ON transaction (fxt_transaction_id, transaction_index)
13272018-11-09 08:41:42 FINE: main Will apply sql:
1328CREATE TABLE IF NOT EXISTS phasing_sub_poll (db_id IDENTITY, transaction_id BIGINT NOT NULL, transaction_full_hash BINARY(32) NOT NULL, name VARCHAR, whitelist_size TINYINT NOT NULL DEFAULT 0, voting_model TINYINT NOT NULL, quorum BIGINT, min_balance BIGINT, holding_id BIGINT, min_balance_model TINYINT, sender_property_setter_id BIGINT, sender_property_name VARCHAR, sender_property_value VARCHAR, recipient_property_setter_id BIGINT, recipient_property_name VARCHAR, recipient_property_value VARCHAR, hashed_secret VARBINARY, algorithm TINYINT, height INT NOT NULL)
13292018-11-09 08:41:42 FINE: main Will apply sql:
1330CREATE TABLE IF NOT EXISTS phasing_vote_sub_poll (db_id IDENTITY, transaction_id BIGINT NOT NULL, transaction_full_hash BINARY(32) NOT NULL, voter_id BIGINT NOT NULL, sub_poll_name VARCHAR NOT NULL, height INT NOT NULL)
13312018-11-09 08:41:42 FINE: main Will apply sql:
1332CREATE INDEX IF NOT EXISTS phasing_vote_sub_poll_transaction_id_idx ON phasing_vote_sub_poll(transaction_id, voter_id)
13332018-11-09 08:41:42 FINE: main Will apply sql:
1334CREATE INDEX IF NOT EXISTS phasing_vote_sub_poll_height_idx ON phasing_vote_sub_poll(height)
13352018-11-09 08:41:42 FINE: main Will apply sql:
1336CREATE INDEX IF NOT EXISTS phasing_sub_poll_id_idx ON phasing_sub_poll(transaction_id)
13372018-11-09 08:41:42 FINE: main Will apply sql:
1338CREATE INDEX IF NOT EXISTS phasing_sub_poll_height_idx ON phasing_sub_poll(height)
13392018-11-09 08:41:42 FINE: main Will apply sql:
1340CREATE INDEX IF NOT EXISTS prunable_message_height_idx ON prunable_message (height)
13412018-11-09 08:41:42 FINE: main Will apply sql:
1342CREATE INDEX IF NOT EXISTS tagged_data_height_idx ON tagged_data (height)
13432018-11-09 08:41:42 FINE: main Will apply sql:
1344CREATE INDEX IF NOT EXISTS data_tag_height_idx ON data_tag (height)
13452018-11-09 08:41:42 FINE: main Will apply sql:
1346CREATE INDEX IF NOT EXISTS shuffling_data_height_idx ON shuffling_data (height)
13472018-11-09 08:41:42 INFO: main Initializing an empty database
13482018-11-09 08:41:42 FINE: main Will apply sql:
1349CREATE TABLE IF NOT EXISTS transaction (db_id IDENTITY, id BIGINT NOT NULL, deadline SMALLINT NOT NULL, recipient_id BIGINT, transaction_index SMALLINT NOT NULL, amount BIGINT NOT NULL, fee BIGINT NOT NULL, full_hash BINARY(32) NOT NULL, height INT NOT NULL, block_id BIGINT NOT NULL, FOREIGN KEY (block_id) REFERENCES PUBLIC.block (id) ON DELETE CASCADE, signature BINARY(64) NOT NULL, timestamp INT NOT NULL, type TINYINT NOT NULL, subtype TINYINT NOT NULL, sender_id BIGINT NOT NULL, block_timestamp INT NOT NULL, referenced_transaction_chain_id INT, referenced_transaction_full_hash BINARY(32), referenced_transaction_id BIGINT, phased BOOLEAN NOT NULL DEFAULT FALSE, fxt_transaction_id BIGINT NOT NULL, attachment_bytes VARBINARY, version TINYINT NOT NULL, has_message BOOLEAN NOT NULL DEFAULT FALSE, has_encrypted_message BOOLEAN NOT NULL DEFAULT FALSE, has_public_key_announcement BOOLEAN NOT NULL DEFAULT FALSE, ec_block_height INT DEFAULT NULL, ec_block_id BIGINT DEFAULT NULL, has_encrypttoself_message BOOLEAN NOT NULL DEFAULT FALSE, has_prunable_message BOOLEAN NOT NULL DEFAULT FALSE, has_prunable_encrypted_message BOOLEAN NOT NULL DEFAULT FALSE, has_prunable_attachment BOOLEAN NOT NULL DEFAULT FALSE)
13502018-11-09 08:41:42 FINE: main Will apply sql:
1351CREATE INDEX IF NOT EXISTS transaction_id_idx ON transaction (id)
13522018-11-09 08:41:42 FINE: main Will apply sql:
1353CREATE INDEX IF NOT EXISTS transaction_sender_id_idx ON transaction (sender_id)
13542018-11-09 08:41:42 FINE: main Will apply sql:
1355CREATE INDEX IF NOT EXISTS transaction_recipient_id_idx ON transaction (recipient_id)
13562018-11-09 08:41:42 FINE: main Will apply sql:
1357CREATE INDEX IF NOT EXISTS transaction_block_timestamp_idx ON transaction (block_timestamp DESC)
13582018-11-09 08:41:42 FINE: main Will apply sql:
1359CREATE TABLE IF NOT EXISTS alias (db_id IDENTITY, id BIGINT NOT NULL, account_id BIGINT NOT NULL, alias_name VARCHAR NOT NULL, alias_name_lower VARCHAR NOT NULL, alias_uri VARCHAR NOT NULL, timestamp INT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
13602018-11-09 08:41:42 FINE: main Will apply sql:
1361CREATE UNIQUE INDEX IF NOT EXISTS alias_id_height_idx ON alias (id, height DESC)
13622018-11-09 08:41:42 FINE: main Will apply sql:
1363CREATE INDEX IF NOT EXISTS alias_account_id_idx ON alias (account_id, height DESC)
13642018-11-09 08:41:42 FINE: main Will apply sql:
1365CREATE INDEX IF NOT EXISTS alias_name_lower_idx ON alias (alias_name_lower)
13662018-11-09 08:41:42 FINE: main Will apply sql:
1367CREATE TABLE IF NOT EXISTS alias_offer (db_id IDENTITY, id BIGINT NOT NULL, price BIGINT NOT NULL, buyer_id BIGINT, height INT NOT NULL, latest BOOLEAN DEFAULT TRUE NOT NULL)
13682018-11-09 08:41:42 FINE: main Will apply sql:
1369CREATE UNIQUE INDEX IF NOT EXISTS alias_offer_id_height_idx ON alias_offer (id, height DESC)
13702018-11-09 08:41:42 FINE: main Will apply sql:
1371CREATE TABLE IF NOT EXISTS trade (db_id IDENTITY, asset_id BIGINT NOT NULL, block_id BIGINT NOT NULL, ask_order_id BIGINT NOT NULL, ask_order_full_hash BINARY(32) NOT NULL, bid_order_id BIGINT NOT NULL, bid_order_full_hash BINARY(32) NOT NULL, ask_order_height INT NOT NULL, bid_order_height INT NOT NULL, seller_id BIGINT NOT NULL, buyer_id BIGINT NOT NULL, is_buy BOOLEAN NOT NULL, quantity BIGINT NOT NULL, price BIGINT NOT NULL, timestamp INT NOT NULL, height INT NOT NULL)
13722018-11-09 08:41:42 FINE: main Will apply sql:
1373CREATE INDEX IF NOT EXISTS trade_asset_id_idx ON trade (asset_id, height DESC)
13742018-11-09 08:41:42 FINE: main Will apply sql:
1375CREATE INDEX IF NOT EXISTS trade_seller_id_idx ON trade (seller_id, height DESC)
13762018-11-09 08:41:42 FINE: main Will apply sql:
1377CREATE INDEX IF NOT EXISTS trade_buyer_id_idx ON trade (buyer_id, height DESC)
13782018-11-09 08:41:42 FINE: main Will apply sql:
1379CREATE TABLE IF NOT EXISTS ask_order (db_id IDENTITY, id BIGINT NOT NULL, full_hash BINARY(32) NOT NULL, account_id BIGINT NOT NULL, asset_id BIGINT NOT NULL, price BIGINT NOT NULL, transaction_index SMALLINT NOT NULL, transaction_height INT NOT NULL, quantity BIGINT NOT NULL, creation_height INT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
13802018-11-09 08:41:42 FINE: main Will apply sql:
1381CREATE UNIQUE INDEX IF NOT EXISTS ask_order_id_height_idx ON ask_order (id, height DESC)
13822018-11-09 08:41:42 FINE: main Will apply sql:
1383CREATE INDEX IF NOT EXISTS ask_order_account_id_idx ON ask_order (account_id, height DESC)
13842018-11-09 08:41:42 FINE: main Will apply sql:
1385CREATE INDEX IF NOT EXISTS ask_order_asset_id_price_idx ON ask_order (asset_id, price)
13862018-11-09 08:41:42 FINE: main Will apply sql:
1387CREATE TABLE IF NOT EXISTS bid_order (db_id IDENTITY, id BIGINT NOT NULL, full_hash BINARY(32) NOT NULL, account_id BIGINT NOT NULL, asset_id BIGINT NOT NULL, price BIGINT NOT NULL, transaction_index SMALLINT NOT NULL, transaction_height INT NOT NULL, amount BIGINT NOT NULL, quantity BIGINT NOT NULL, creation_height INT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
13882018-11-09 08:41:42 FINE: main Will apply sql:
1389CREATE UNIQUE INDEX IF NOT EXISTS bid_order_id_height_idx ON bid_order (id, height DESC)
13902018-11-09 08:41:42 FINE: main Will apply sql:
1391CREATE INDEX IF NOT EXISTS bid_order_account_id_idx ON bid_order (account_id, height DESC)
13922018-11-09 08:41:42 FINE: main Will apply sql:
1393CREATE INDEX IF NOT EXISTS bid_order_asset_id_price_idx ON bid_order (asset_id, price DESC)
13942018-11-09 08:41:42 FINE: main Will apply sql:
1395CREATE TABLE IF NOT EXISTS goods (db_id IDENTITY, id BIGINT NOT NULL, full_hash BINARY(32), seller_id BIGINT NOT NULL, name VARCHAR NOT NULL, description VARCHAR, parsed_tags ARRAY, has_image BOOLEAN NOT NULL, tags VARCHAR, timestamp INT NOT NULL, quantity INT NOT NULL, price BIGINT NOT NULL, delisted BOOLEAN NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
13962018-11-09 08:41:42 FINE: main Will apply sql:
1397CREATE UNIQUE INDEX IF NOT EXISTS goods_id_height_idx ON goods (id, height DESC)
13982018-11-09 08:41:42 FINE: main Will apply sql:
1399CREATE INDEX IF NOT EXISTS goods_seller_id_name_idx ON goods (seller_id, name)
14002018-11-09 08:41:42 FINE: main Will apply sql:
1401CREATE INDEX IF NOT EXISTS goods_timestamp_idx ON goods (timestamp DESC, height DESC)
14022018-11-09 08:41:42 FINE: main Will apply sql:
1403CREATE TABLE IF NOT EXISTS purchase (db_id IDENTITY, id BIGINT NOT NULL, buyer_id BIGINT NOT NULL, goods_id BIGINT NOT NULL, seller_id BIGINT NOT NULL, quantity INT NOT NULL, price BIGINT NOT NULL, deadline INT NOT NULL, note VARBINARY, nonce BINARY(32), timestamp INT NOT NULL, pending BOOLEAN NOT NULL, goods VARBINARY, goods_nonce BINARY(32), goods_is_text BOOLEAN NOT NULL DEFAULT TRUE, refund_note VARBINARY, refund_nonce BINARY(32), has_feedback_notes BOOLEAN NOT NULL DEFAULT FALSE, has_public_feedbacks BOOLEAN NOT NULL DEFAULT FALSE, discount BIGINT NOT NULL, refund BIGINT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
14042018-11-09 08:41:42 FINE: main Will apply sql:
1405CREATE UNIQUE INDEX IF NOT EXISTS purchase_id_height_idx ON purchase (id, height DESC)
14062018-11-09 08:41:42 FINE: main Will apply sql:
1407CREATE INDEX IF NOT EXISTS purchase_buyer_id_height_idx ON purchase (buyer_id, height DESC)
14082018-11-09 08:41:42 FINE: main Will apply sql:
1409CREATE INDEX IF NOT EXISTS purchase_seller_id_height_idx ON purchase (seller_id, height DESC)
14102018-11-09 08:41:42 FINE: main Will apply sql:
1411CREATE INDEX IF NOT EXISTS purchase_deadline_idx ON purchase (deadline DESC, height DESC)
14122018-11-09 08:41:42 FINE: main Will apply sql:
1413CREATE TABLE IF NOT EXISTS balance (db_id IDENTITY, account_id BIGINT NOT NULL, balance BIGINT NOT NULL, unconfirmed_balance BIGINT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
14142018-11-09 08:41:42 FINE: main Will apply sql:
1415CREATE UNIQUE INDEX IF NOT EXISTS balance_id_height_idx ON balance (account_id, height DESC)
14162018-11-09 08:41:42 FINE: main Will apply sql:
1417CREATE TABLE IF NOT EXISTS purchase_feedback (db_id IDENTITY, id BIGINT NOT NULL, feedback_data VARBINARY NOT NULL, feedback_nonce BINARY(32) NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
14182018-11-09 08:41:42 FINE: main Will apply sql:
1419CREATE INDEX IF NOT EXISTS purchase_feedback_id_height_idx ON purchase_feedback (id, height DESC)
14202018-11-09 08:41:42 FINE: main Will apply sql:
1421CREATE TABLE IF NOT EXISTS purchase_public_feedback (db_id IDENTITY, id BIGINT NOT NULL, public_feedback VARCHAR NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
14222018-11-09 08:41:42 FINE: main Will apply sql:
1423CREATE INDEX IF NOT EXISTS purchase_public_feedback_id_height_idx ON purchase_public_feedback (id, height DESC)
14242018-11-09 08:41:42 FINE: main Will apply sql:
1425CREATE INDEX IF NOT EXISTS purchase_timestamp_idx ON purchase (timestamp DESC, id)
14262018-11-09 08:41:42 FINE: main Will apply sql:
1427CREATE INDEX IF NOT EXISTS ask_order_creation_idx ON ask_order (creation_height DESC)
14282018-11-09 08:41:42 FINE: main Will apply sql:
1429CREATE INDEX IF NOT EXISTS bid_order_creation_idx ON bid_order (creation_height DESC)
14302018-11-09 08:41:42 FINE: main Will apply sql:
1431CREATE TABLE IF NOT EXISTS tag (db_id IDENTITY, tag VARCHAR NOT NULL, in_stock_count INT NOT NULL, total_count INT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
14322018-11-09 08:41:42 FINE: main Will apply sql:
1433CREATE UNIQUE INDEX IF NOT EXISTS tag_tag_idx ON tag (tag, height DESC)
14342018-11-09 08:41:42 FINE: main Will apply sql:
1435CREATE INDEX IF NOT EXISTS tag_in_stock_count_idx ON tag (in_stock_count DESC, height DESC)
14362018-11-09 08:41:42 FINE: main Will apply sql:
1437CREATE TABLE IF NOT EXISTS currency_founder (db_id IDENTITY, currency_id BIGINT NOT NULL, account_id BIGINT NOT NULL, amount_per_unit BIGINT NOT NULL, amount BIGINT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
14382018-11-09 08:41:42 FINE: main Will apply sql:
1439CREATE UNIQUE INDEX IF NOT EXISTS currency_founder_currency_id_idx ON currency_founder (currency_id, account_id, height DESC)
14402018-11-09 08:41:42 FINE: main Will apply sql:
1441CREATE TABLE IF NOT EXISTS buy_offer (db_id IDENTITY, id BIGINT NOT NULL, full_hash BINARY(32) NOT NULL, currency_id BIGINT NOT NULL, account_id BIGINT NOT NULL,rate BIGINT NOT NULL, unit_limit BIGINT NOT NULL, supply BIGINT NOT NULL, expiration_height INT NOT NULL, amount BIGINT NOT NULL, creation_height INT NOT NULL, transaction_index SMALLINT NOT NULL, transaction_height INT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
14422018-11-09 08:41:42 FINE: main Will apply sql:
1443CREATE UNIQUE INDEX IF NOT EXISTS buy_offer_id_idx ON buy_offer (id, height DESC)
14442018-11-09 08:41:42 FINE: main Will apply sql:
1445CREATE INDEX IF NOT EXISTS buy_offer_currency_id_account_id_idx ON buy_offer (currency_id, account_id, height DESC)
14462018-11-09 08:41:42 FINE: main Will apply sql:
1447CREATE TABLE IF NOT EXISTS sell_offer (db_id IDENTITY, id BIGINT NOT NULL, full_hash BINARY(32) NOT NULL, currency_id BIGINT NOT NULL, account_id BIGINT NOT NULL, rate BIGINT NOT NULL, unit_limit BIGINT NOT NULL, supply BIGINT NOT NULL, expiration_height INT NOT NULL, creation_height INT NOT NULL, transaction_index SMALLINT NOT NULL, transaction_height INT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
14482018-11-09 08:41:42 FINE: main Will apply sql:
1449CREATE UNIQUE INDEX IF NOT EXISTS sell_offer_id_idx ON sell_offer (id, height DESC)
14502018-11-09 08:41:42 FINE: main Will apply sql:
1451CREATE INDEX IF NOT EXISTS sell_offer_currency_id_account_id_idx ON sell_offer (currency_id, account_id, height DESC)
14522018-11-09 08:41:42 FINE: main Will apply sql:
1453CREATE TABLE IF NOT EXISTS exchange (db_id IDENTITY, transaction_id BIGINT NOT NULL, transaction_full_hash BINARY(32) NOT NULL, currency_id BIGINT NOT NULL, block_id BIGINT NOT NULL, offer_id BIGINT NOT NULL, offer_full_hash BINARY(32) NOT NULL, seller_id BIGINT NOT NULL, buyer_id BIGINT NOT NULL, units BIGINT NOT NULL, rate BIGINT NOT NULL, timestamp INT NOT NULL, height INT NOT NULL)
14542018-11-09 08:41:42 FINE: main Will apply sql:
1455CREATE INDEX IF NOT EXISTS exchange_offer_idx ON exchange (transaction_id, offer_id)
14562018-11-09 08:41:42 FINE: main Will apply sql:
1457CREATE INDEX IF NOT EXISTS exchange_currency_id_idx ON exchange (currency_id, height DESC)
14582018-11-09 08:41:42 FINE: main Will apply sql:
1459CREATE INDEX IF NOT EXISTS exchange_seller_id_idx ON exchange (seller_id, height DESC)
14602018-11-09 08:41:42 FINE: main Will apply sql:
1461CREATE INDEX IF NOT EXISTS exchange_buyer_id_idx ON exchange (buyer_id, height DESC)
14622018-11-09 08:41:42 FINE: main Will apply sql:
1463CREATE INDEX IF NOT EXISTS buy_offer_rate_height_idx ON buy_offer (rate DESC, creation_height ASC)
14642018-11-09 08:41:42 FINE: main Will apply sql:
1465CREATE INDEX IF NOT EXISTS sell_offer_rate_height_idx ON sell_offer (rate ASC, creation_height ASC)
14662018-11-09 08:41:42 FINE: main Will apply sql:
1467CREATE INDEX IF NOT EXISTS exchange_height_idx ON exchange(height)
14682018-11-09 08:41:42 FINE: main Will apply sql:
1469CREATE INDEX IF NOT EXISTS trade_height_idx ON trade(height)
14702018-11-09 08:41:42 FINE: main Will apply sql:
1471CREATE TABLE IF NOT EXISTS vote (db_id IDENTITY, id BIGINT NOT NULL, full_hash BINARY(32) NOT NULL, poll_id BIGINT NOT NULL, voter_id BIGINT NOT NULL, vote_bytes VARBINARY NOT NULL, height INT NOT NULL)
14722018-11-09 08:41:42 FINE: main Will apply sql:
1473CREATE INDEX IF NOT EXISTS vote_id_idx ON vote (id)
14742018-11-09 08:41:42 FINE: main Will apply sql:
1475CREATE UNIQUE INDEX IF NOT EXISTS vote_poll_id_idx ON vote (poll_id, voter_id)
14762018-11-09 08:41:42 FINE: main Will apply sql:
1477CREATE TABLE IF NOT EXISTS poll (db_id IDENTITY, id BIGINT NOT NULL, account_id BIGINT NOT NULL, name VARCHAR NOT NULL, description VARCHAR, options ARRAY NOT NULL, min_num_options TINYINT, max_num_options TINYINT, min_range_value TINYINT, max_range_value TINYINT, timestamp INT NOT NULL, finish_height INT NOT NULL, voting_model TINYINT NOT NULL, min_balance BIGINT, min_balance_model TINYINT, holding_id BIGINT, height INT NOT NULL)
14782018-11-09 08:41:42 FINE: main Will apply sql:
1479CREATE TABLE IF NOT EXISTS poll_result (db_id IDENTITY, poll_id BIGINT NOT NULL, result BIGINT, weight BIGINT NOT NULL, height INT NOT NULL)
14802018-11-09 08:41:42 FINE: main Will apply sql:
1481CREATE TABLE IF NOT EXISTS phasing_poll (db_id IDENTITY, id BIGINT NOT NULL, full_hash BINARY(32) NOT NULL, account_id BIGINT NOT NULL, whitelist_size TINYINT NOT NULL DEFAULT 0, finish_height INT NOT NULL, voting_model TINYINT NOT NULL, quorum BIGINT, min_balance BIGINT, holding_id BIGINT, min_balance_model TINYINT, expression VARCHAR, recipient_account_id BIGINT, sender_property_setter_id BIGINT, sender_property_name VARCHAR, sender_property_value VARCHAR, recipient_property_setter_id BIGINT, recipient_property_name VARCHAR, recipient_property_value VARCHAR, hashed_secret VARBINARY, algorithm TINYINT, height INT NOT NULL)
14822018-11-09 08:41:42 FINE: main Will apply sql:
1483CREATE TABLE IF NOT EXISTS phasing_vote (db_id IDENTITY, vote_id BIGINT NOT NULL, vote_full_hash BINARY(32) NOT NULL, transaction_id BIGINT NOT NULL, transaction_full_hash BINARY(32) NOT NULL, voter_id BIGINT NOT NULL, height INT NOT NULL)
14842018-11-09 08:41:42 FINE: main Will apply sql:
1485CREATE TABLE IF NOT EXISTS phasing_poll_voter (db_id IDENTITY, transaction_id BIGINT NOT NULL, transaction_full_hash BINARY(32) NOT NULL, voter_id BIGINT NOT NULL, sub_poll_name VARCHAR, height INT NOT NULL)
14862018-11-09 08:41:42 FINE: main Will apply sql:
1487CREATE INDEX IF NOT EXISTS vote_height_idx ON vote(height)
14882018-11-09 08:41:42 FINE: main Will apply sql:
1489CREATE UNIQUE INDEX IF NOT EXISTS poll_id_idx ON poll(id)
14902018-11-09 08:41:42 FINE: main Will apply sql:
1491CREATE INDEX IF NOT EXISTS poll_height_idx ON poll(height)
14922018-11-09 08:41:42 FINE: main Will apply sql:
1493CREATE INDEX IF NOT EXISTS poll_account_idx ON poll(account_id)
14942018-11-09 08:41:42 FINE: main Will apply sql:
1495CREATE INDEX IF NOT EXISTS poll_finish_height_idx ON poll(finish_height DESC)
14962018-11-09 08:41:42 FINE: main Will apply sql:
1497CREATE INDEX IF NOT EXISTS poll_result_poll_id_idx ON poll_result(poll_id)
14982018-11-09 08:41:42 FINE: main Will apply sql:
1499CREATE INDEX IF NOT EXISTS poll_result_height_idx ON poll_result(height)
15002018-11-09 08:41:42 FINE: main Will apply sql:
1501CREATE INDEX IF NOT EXISTS phasing_poll_id_idx ON phasing_poll(id)
15022018-11-09 08:41:42 FINE: main Will apply sql:
1503CREATE INDEX IF NOT EXISTS phasing_poll_height_idx ON phasing_poll(height)
15042018-11-09 08:41:42 FINE: main Will apply sql:
1505CREATE INDEX IF NOT EXISTS phasing_poll_account_id_idx ON phasing_poll(account_id, height DESC)
15062018-11-09 08:41:42 FINE: main Will apply sql:
1507CREATE INDEX IF NOT EXISTS phasing_poll_holding_id_idx ON phasing_poll(holding_id, height DESC)
15082018-11-09 08:41:42 FINE: main Will apply sql:
1509CREATE INDEX IF NOT EXISTS phasing_vote_transaction_voter_idx ON phasing_vote(transaction_id, voter_id)
15102018-11-09 08:41:42 FINE: main Will apply sql:
1511CREATE INDEX IF NOT EXISTS phasing_poll_voter_transaction_voter_idx ON phasing_poll_voter(transaction_id, voter_id)
15122018-11-09 08:41:42 FINE: main Will apply sql:
1513CREATE INDEX IF NOT EXISTS currency_founder_account_id_idx ON currency_founder (account_id, height DESC)
15142018-11-09 08:41:42 FINE: main Will apply sql:
1515CREATE INDEX IF NOT EXISTS phasing_poll_voter_height_idx ON phasing_poll_voter(height)
15162018-11-09 08:41:42 FINE: main Will apply sql:
1517CREATE INDEX IF NOT EXISTS phasing_vote_height_idx ON phasing_vote(height)
15182018-11-09 08:41:42 FINE: main Will apply sql:
1519CREATE INDEX IF NOT EXISTS trade_ask_idx ON trade (ask_order_id, height DESC)
15202018-11-09 08:41:42 FINE: main Will apply sql:
1521CREATE INDEX IF NOT EXISTS trade_bid_idx ON trade (bid_order_id, height DESC)
15222018-11-09 08:41:42 FINE: main Will apply sql:
1523CREATE TABLE IF NOT EXISTS prunable_message (db_id IDENTITY, id BIGINT NOT NULL, full_hash BINARY(32) NOT NULL, sender_id BIGINT NOT NULL, recipient_id BIGINT, message VARBINARY, message_is_text BOOLEAN NOT NULL, is_compressed BOOLEAN NOT NULL, encrypted_message VARBINARY, encrypted_is_text BOOLEAN DEFAULT FALSE, block_timestamp INT NOT NULL, transaction_timestamp INT NOT NULL, height INT NOT NULL)
15242018-11-09 08:41:42 FINE: main Will apply sql:
1525CREATE INDEX IF NOT EXISTS prunable_message_id_idx ON prunable_message (id)
15262018-11-09 08:41:42 FINE: main Will apply sql:
1527CREATE INDEX IF NOT EXISTS prunable_message_transaction_timestamp_idx ON prunable_message (transaction_timestamp DESC)
15282018-11-09 08:41:42 FINE: main Will apply sql:
1529CREATE INDEX IF NOT EXISTS prunable_message_sender_idx ON prunable_message (sender_id)
15302018-11-09 08:41:42 FINE: main Will apply sql:
1531CREATE INDEX IF NOT EXISTS prunable_message_recipient_idx ON prunable_message (recipient_id)
15322018-11-09 08:41:42 FINE: main Will apply sql:
1533CREATE INDEX IF NOT EXISTS prunable_message_block_timestamp_dbid_idx ON prunable_message (block_timestamp DESC, db_id DESC)
15342018-11-09 08:41:42 FINE: main Will apply sql:
1535CREATE TABLE IF NOT EXISTS tagged_data (db_id IDENTITY, id BIGINT NOT NULL, full_hash BINARY(32) NOT NULL, account_id BIGINT NOT NULL, name VARCHAR NOT NULL, description VARCHAR, tags VARCHAR, parsed_tags ARRAY, type VARCHAR, data VARBINARY NOT NULL, is_text BOOLEAN NOT NULL, channel VARCHAR, filename VARCHAR, block_timestamp INT NOT NULL, transaction_timestamp INT NOT NULL, height INT NOT NULL)
15362018-11-09 08:41:42 FINE: main Will apply sql:
1537CREATE INDEX IF NOT EXISTS tagged_data_id_idx ON tagged_data (id)
15382018-11-09 08:41:42 FINE: main Will apply sql:
1539CREATE INDEX IF NOT EXISTS tagged_data_expiration_idx ON tagged_data (transaction_timestamp DESC)
15402018-11-09 08:41:42 FINE: main Will apply sql:
1541CREATE INDEX IF NOT EXISTS tagged_data_account_id_height_idx ON tagged_data (account_id, height DESC)
15422018-11-09 08:41:42 FINE: main Will apply sql:
1543CREATE INDEX IF NOT EXISTS tagged_data_block_timestamp_db_id_idx ON tagged_data (block_timestamp DESC, db_id DESC)
15442018-11-09 08:41:42 FINE: main Will apply sql:
1545CREATE TABLE IF NOT EXISTS data_tag (db_id IDENTITY, tag VARCHAR NOT NULL, tag_count INT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
15462018-11-09 08:41:42 FINE: main Will apply sql:
1547CREATE UNIQUE INDEX IF NOT EXISTS data_tag_tag_height_idx ON data_tag (tag, height DESC)
15482018-11-09 08:41:42 FINE: main Will apply sql:
1549CREATE INDEX IF NOT EXISTS data_tag_count_height_idx ON data_tag (tag_count DESC, height DESC)
15502018-11-09 08:41:42 FINE: main Will apply sql:
1551CREATE INDEX IF NOT EXISTS tagged_data_channel_idx ON tagged_data (channel, height DESC)
15522018-11-09 08:41:42 FINE: main Will apply sql:
1553CREATE INDEX IF NOT EXISTS balance_height_id_idx ON balance (height, account_id)
15542018-11-09 08:41:42 FINE: main Will apply sql:
1555CREATE INDEX IF NOT EXISTS alias_height_id_idx ON alias (height, id)
15562018-11-09 08:41:42 FINE: main Will apply sql:
1557CREATE INDEX IF NOT EXISTS alias_offer_height_id_idx ON alias_offer (height, id)
15582018-11-09 08:41:42 FINE: main Will apply sql:
1559CREATE INDEX IF NOT EXISTS ask_order_height_id_idx ON ask_order (height, id)
15602018-11-09 08:41:42 FINE: main Will apply sql:
1561CREATE INDEX IF NOT EXISTS bid_order_height_id_idx ON bid_order (height, id)
15622018-11-09 08:41:42 FINE: main Will apply sql:
1563CREATE INDEX IF NOT EXISTS buy_offer_height_id_idx ON buy_offer (height, id)
15642018-11-09 08:41:42 FINE: main Will apply sql:
1565CREATE INDEX IF NOT EXISTS currency_founder_height_id_idx ON currency_founder (height, currency_id, account_id)
15662018-11-09 08:41:42 FINE: main Will apply sql:
1567CREATE INDEX IF NOT EXISTS goods_height_id_idx ON goods (height, id)
15682018-11-09 08:41:42 FINE: main Will apply sql:
1569CREATE INDEX IF NOT EXISTS purchase_height_id_idx ON purchase (height, id)
15702018-11-09 08:41:42 FINE: main Will apply sql:
1571CREATE INDEX IF NOT EXISTS purchase_feedback_height_id_idx ON purchase_feedback (height, id)
15722018-11-09 08:41:42 FINE: main Will apply sql:
1573CREATE INDEX IF NOT EXISTS purchase_public_feedback_height_id_idx ON purchase_public_feedback (height, id)
15742018-11-09 08:41:42 FINE: main Will apply sql:
1575CREATE INDEX IF NOT EXISTS sell_offer_height_id_idx ON sell_offer (height, id)
15762018-11-09 08:41:42 FINE: main Will apply sql:
1577CREATE INDEX IF NOT EXISTS tag_height_tag_idx ON tag (height, tag)
15782018-11-09 08:41:42 FINE: main Will apply sql:
1579CREATE INDEX IF NOT EXISTS trade_height_db_id_idx ON trade (height DESC, db_id DESC)
15802018-11-09 08:41:42 FINE: main Will apply sql:
1581CREATE INDEX IF NOT EXISTS exchange_height_db_id_idx ON exchange (height DESC, db_id DESC)
15822018-11-09 08:41:42 FINE: main Will apply sql:
1583CREATE TABLE IF NOT EXISTS exchange_request (db_id IDENTITY, id BIGINT NOT NULL, full_hash BINARY(32) NOT NULL, account_id BIGINT NOT NULL, currency_id BIGINT NOT NULL, units BIGINT NOT NULL, rate BIGINT NOT NULL, is_buy BOOLEAN NOT NULL, timestamp INT NOT NULL, height INT NOT NULL)
15842018-11-09 08:41:42 FINE: main Will apply sql:
1585CREATE INDEX IF NOT EXISTS exchange_request_id_idx ON exchange_request (id)
15862018-11-09 08:41:42 FINE: main Will apply sql:
1587CREATE INDEX IF NOT EXISTS exchange_request_account_currency_idx ON exchange_request (account_id, currency_id, height DESC)
15882018-11-09 08:41:42 FINE: main Will apply sql:
1589CREATE INDEX IF NOT EXISTS exchange_request_currency_idx ON exchange_request (currency_id, height DESC)
15902018-11-09 08:41:42 FINE: main Will apply sql:
1591CREATE INDEX IF NOT EXISTS exchange_request_height_db_id_idx ON exchange_request (height DESC, db_id DESC)
15922018-11-09 08:41:42 FINE: main Will apply sql:
1593CREATE INDEX IF NOT EXISTS exchange_request_height_idx ON exchange_request (height)
15942018-11-09 08:41:42 INFO: main Lucene search index deleted
15952018-11-09 08:41:42 INFO: main H2 fulltext function aliases dropped
15962018-11-09 08:41:42 INFO: main NRS fulltext schema created
15972018-11-09 08:41:42 INFO: main Rebuilding the Lucene search index
15982018-11-09 08:41:42 INFO: main Lucene search index deleted
15992018-11-09 08:41:42 INFO: main Lucene search index successfully rebuilt
16002018-11-09 08:41:42 INFO: main NRS fulltext aliases created
16012018-11-09 08:41:42 FINE: main Will apply sql:
1602CREATE TABLE IF NOT EXISTS shuffling (db_id IDENTITY, id BIGINT NOT NULL, full_hash BINARY(32) NOT NULL, holding_id BIGINT NULL, holding_type TINYINT NOT NULL, issuer_id BIGINT NOT NULL, amount BIGINT NOT NULL, participant_count TINYINT NOT NULL, blocks_remaining SMALLINT NULL, stage TINYINT NOT NULL, assignee_account_id BIGINT NULL, registrant_count TINYINT NOT NULL, recipient_public_keys ARRAY, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
16032018-11-09 08:41:42 FINE: main Will apply sql:
1604CREATE INDEX IF NOT EXISTS shuffling_id_height_idx ON shuffling (id, height DESC)
16052018-11-09 08:41:42 FINE: main Will apply sql:
1606CREATE INDEX IF NOT EXISTS shuffling_holding_id_height_idx ON shuffling (holding_id, height DESC)
16072018-11-09 08:41:42 FINE: main Will apply sql:
1608CREATE INDEX IF NOT EXISTS shuffling_assignee_account_id_height_idx ON shuffling (assignee_account_id, height DESC)
16092018-11-09 08:41:42 FINE: main Will apply sql:
1610CREATE INDEX IF NOT EXISTS shuffling_height_id_idx ON shuffling (height, id)
16112018-11-09 08:41:42 FINE: main Will apply sql:
1612CREATE TABLE IF NOT EXISTS shuffling_participant (db_id IDENTITY, shuffling_id BIGINT NOT NULL, shuffling_full_hash BINARY(32) NOT NULL, account_id BIGINT NOT NULL, next_account_id BIGINT NULL, participant_index TINYINT NOT NULL, state TINYINT NOT NULL, blame_data ARRAY, key_seeds ARRAY, data_transaction_full_hash BINARY(32), height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
16132018-11-09 08:41:42 FINE: main Will apply sql:
1614CREATE INDEX IF NOT EXISTS shuffling_participant_shuffling_id_account_id_idx ON shuffling_participant (shuffling_id, account_id, height DESC)
16152018-11-09 08:41:42 FINE: main Will apply sql:
1616CREATE INDEX IF NOT EXISTS shuffling_participant_height_idx ON shuffling_participant (height, shuffling_id, account_id)
16172018-11-09 08:41:42 FINE: main Will apply sql:
1618CREATE TABLE IF NOT EXISTS shuffling_data (db_id IDENTITY, shuffling_id BIGINT NOT NULL, shuffling_full_hash BINARY(32) NOT NULL, account_id BIGINT NOT NULL, data ARRAY, transaction_timestamp INT NOT NULL, height INT NOT NULL)
16192018-11-09 08:41:42 FINE: main Will apply sql:
1620CREATE INDEX IF NOT EXISTS shuffling_data_id_height_idx ON shuffling_data (shuffling_id, height DESC)
16212018-11-09 08:41:42 FINE: main Will apply sql:
1622CREATE INDEX shuffling_data_transaction_timestamp_idx ON shuffling_data (transaction_timestamp DESC)
16232018-11-09 08:41:42 FINE: main Will apply sql:
1624CREATE INDEX IF NOT EXISTS transaction_referenced_transaction_id_idx ON transaction (referenced_transaction_id)
16252018-11-09 08:41:42 FINE: main Will apply sql:
1626CREATE INDEX IF NOT EXISTS shuffling_blocks_remaining_height_idx ON shuffling (blocks_remaining, height DESC)
16272018-11-09 08:41:42 FINE: main Will apply sql:
1628CREATE TABLE IF NOT EXISTS asset_dividend (db_id IDENTITY, id BIGINT NOT NULL, full_hash BINARY(32) NOT NULL, asset_id BIGINT NOT NULL, holding_id BIGINT NOT NULL, holding_type TINYINT NOT NULL, amount BIGINT NOT NULL, dividend_height INT NOT NULL, total_dividend BIGINT NOT NULL, num_accounts BIGINT NOT NULL, timestamp INT NOT NULL, height INT NOT NULL)
16292018-11-09 08:41:42 FINE: main Will apply sql:
1630CREATE INDEX IF NOT EXISTS asset_dividend_id_idx ON asset_dividend (id)
16312018-11-09 08:41:42 FINE: main Will apply sql:
1632CREATE INDEX IF NOT EXISTS asset_dividend_asset_id_idx ON asset_dividend (asset_id, height DESC)
16332018-11-09 08:41:42 FINE: main Will apply sql:
1634CREATE INDEX IF NOT EXISTS asset_dividend_height_idx ON asset_dividend (height)
16352018-11-09 08:41:42 FINE: main Will apply sql:
1636CREATE INDEX IF NOT EXISTS fxt_transaction_id_idx ON transaction (fxt_transaction_id, transaction_index)
16372018-11-09 08:41:42 FINE: main Will apply sql:
1638CREATE TABLE IF NOT EXISTS phasing_sub_poll (db_id IDENTITY, transaction_id BIGINT NOT NULL, transaction_full_hash BINARY(32) NOT NULL, name VARCHAR, whitelist_size TINYINT NOT NULL DEFAULT 0, voting_model TINYINT NOT NULL, quorum BIGINT, min_balance BIGINT, holding_id BIGINT, min_balance_model TINYINT, sender_property_setter_id BIGINT, sender_property_name VARCHAR, sender_property_value VARCHAR, recipient_property_setter_id BIGINT, recipient_property_name VARCHAR, recipient_property_value VARCHAR, hashed_secret VARBINARY, algorithm TINYINT, height INT NOT NULL)
16392018-11-09 08:41:42 FINE: main Will apply sql:
1640CREATE TABLE IF NOT EXISTS phasing_vote_sub_poll (db_id IDENTITY, transaction_id BIGINT NOT NULL, transaction_full_hash BINARY(32) NOT NULL, voter_id BIGINT NOT NULL, sub_poll_name VARCHAR NOT NULL, height INT NOT NULL)
16412018-11-09 08:41:42 FINE: main Will apply sql:
1642CREATE INDEX IF NOT EXISTS phasing_vote_sub_poll_transaction_id_idx ON phasing_vote_sub_poll(transaction_id, voter_id)
16432018-11-09 08:41:42 FINE: main Will apply sql:
1644CREATE INDEX IF NOT EXISTS phasing_vote_sub_poll_height_idx ON phasing_vote_sub_poll(height)
16452018-11-09 08:41:42 FINE: main Will apply sql:
1646CREATE INDEX IF NOT EXISTS phasing_sub_poll_id_idx ON phasing_sub_poll(transaction_id)
16472018-11-09 08:41:42 FINE: main Will apply sql:
1648CREATE INDEX IF NOT EXISTS phasing_sub_poll_height_idx ON phasing_sub_poll(height)
16492018-11-09 08:41:42 FINE: main Will apply sql:
1650CREATE INDEX IF NOT EXISTS prunable_message_height_idx ON prunable_message (height)
16512018-11-09 08:41:42 FINE: main Will apply sql:
1652CREATE INDEX IF NOT EXISTS tagged_data_height_idx ON tagged_data (height)
16532018-11-09 08:41:42 FINE: main Will apply sql:
1654CREATE INDEX IF NOT EXISTS data_tag_height_idx ON data_tag (height)
16552018-11-09 08:41:42 FINE: main Will apply sql:
1656CREATE INDEX IF NOT EXISTS shuffling_data_height_idx ON shuffling_data (height)
16572018-11-09 08:41:42 INFO: main nxt.enableTransactionRebroadcasting = "true"
16582018-11-09 08:41:42 INFO: main nxt.testUnconfirmedTransactions = "true"
16592018-11-09 08:41:42 INFO: main nxt.maxUnconfirmedTransactions = "2000"
16602018-11-09 08:41:42 INFO: main nxt.enablePublicKeyCache = "true"
16612018-11-09 08:41:42 INFO: main nxt.ledgerTrimKeep = "30000"
16622018-11-09 08:41:42 INFO: main nxt.ledgerAccounts = "*"
16632018-11-09 08:41:42 INFO: main Account ledger is tracking all accounts
16642018-11-09 08:41:42 INFO: main nxt.ledgerLogUnconfirmed = "2"
16652018-11-09 08:41:42 INFO: main nxt.maxNumberOfForgers = "100"
16662018-11-09 08:41:42 INFO: main nxt.enableFakeForging = "true"
16672018-11-09 08:41:42 INFO: main nxt.fakeForgingPublicKeys = "c695121842440c4646a128920af54c0f9d451a3c195f37e946cdb8c655753b77;584486d2ba4dbd7eaeadd071f9f8c3593cee620e1e374033551147d68899b529"
16682018-11-09 08:41:42 INFO: main nxt.defaultChildBlockDeadline = "10"
16692018-11-09 08:41:42 INFO: main nxt.bundlingFilter not defined
16702018-11-09 08:41:42 INFO: main nxt.availableBundlingFilters = "nxt.addons.PersonalBundler;nxt.addons.AccountPropertyBundler; nxt.addons.AssetBundler;nxt.addons.CurrencyBundler;nxt.addons.PurchaseBundler; nxt.addons.QuotaBundler"
16712018-11-09 08:41:42 INFO: main nxt.customBundlingFeeCalculators not defined
16722018-11-09 08:41:42 INFO: main nxt.enablePeerUPnP = "true"
16732018-11-09 08:41:42 INFO: main nxt.shareMyAddress = "false"
16742018-11-09 08:41:42 INFO: main nxt.maxNumberOfOutboundConnections = "8"
16752018-11-09 08:41:42 INFO: main nxt.maxNumberOfInboundConnections = "2000"
16762018-11-09 08:41:42 INFO: main nxt.peerConnectTimeout = "10"
16772018-11-09 08:41:42 INFO: main nxt.peerReadTimeout = "20"
16782018-11-09 08:41:42 INFO: main nxt.peerServerHost = "0.0.0.0"
16792018-11-09 08:41:42 INFO: main nxt.myAddress not defined
16802018-11-09 08:41:42 INFO: main Network handler is offline
16812018-11-09 08:41:42 INFO: main nxt.blacklistingPeriod = "600"
16822018-11-09 08:41:42 INFO: main nxt.communicationLogging = "0"
16832018-11-09 08:41:42 INFO: main nxt.getMorePeers = "true"
16842018-11-09 08:41:42 INFO: main nxt.maxNumberOfKnownPeers = "2000"
16852018-11-09 08:41:42 INFO: main nxt.minNumberOfKnownPeers = "1000"
16862018-11-09 08:41:42 INFO: main nxt.usePeersDb = "true"
16872018-11-09 08:41:42 INFO: main nxt.savePeers = "false"
16882018-11-09 08:41:42 INFO: main nxt.hideErrorDetails = "false"
16892018-11-09 08:41:42 INFO: main nxt.ignorePeerAnnouncedAddress = "false"
16902018-11-09 08:41:42 INFO: main nxt.minBundlerBalanceFXT = "1000"
16912018-11-09 08:41:42 INFO: main nxt.minBundlerFeeLimitFXT = "10"
16922018-11-09 08:41:42 INFO: main nxt.blacklistedBundlerAccounts not defined
16932018-11-09 08:41:42 INFO: main nxt.bestBundlerRateWhitelist not defined
16942018-11-09 08:41:42 INFO: main nxt.credentials.secretPhrase not defined
16952018-11-09 08:41:42 INFO: main nxt.testnetPeers not defined
16962018-11-09 08:41:42 INFO: main nxt.knownBlacklistedPeers not defined
16972018-11-09 08:41:42 INFO: main Peer services are offline
16982018-11-09 08:41:42 INFO: main nxt.apiProxyBlacklistingPeriod = "1800000"
16992018-11-09 08:41:42 INFO: main nxt.forceAPIProxyServerURL not defined
17002018-11-09 08:41:42 INFO: main nxt.timeMultiplier = "1"
17012018-11-09 08:41:42 FINE: main Running 1 tasks...
17022018-11-09 08:41:42 INFO: Thread-1 Genesis block not in database, starting from scratch
17032018-11-09 08:41:42 INFO: Thread-1 nxt.forceScan = "false"
17042018-11-09 08:41:42 FINE: main Running 1 final tasks...
17052018-11-09 08:41:42 INFO: Thread-2 nxt.apiServerEnforcePOST = "true"
17062018-11-09 08:41:42 INFO: Thread-2 nxt.apiFixResponseContentType = "false"
17072018-11-09 08:41:42 INFO: Thread-2 nxt.addOns = "nxt.addons.ContractRunner"
17082018-11-09 08:41:42 INFO: Thread-2 nxt.disableSecurityPolicy = "false"
17092018-11-09 08:41:42 INFO: Thread-2 Creating Jelurida security provider
17102018-11-09 08:41:42 INFO: Thread-2 nxt.runtime.mode not defined
17112018-11-09 08:41:42 INFO: Thread-2 Setting security manager with policy ardor.policy
17122018-11-09 08:41:42 INFO: Thread-2 Initializing nxt.addons.ContractRunner
17132018-11-09 08:41:42 INFO: Thread-2 addon.contractRunner.configFile = "./addons/resources/contracts.json"
17142018-11-09 08:41:42 INFO: Thread-2 Loading file from path D:\github\ardor\.\addons\resources\contracts.json
17152018-11-09 08:41:42 INFO: Thread-2 addon.contractRunner.secretPhrase = "{not logged}"
17162018-11-09 08:41:42 INFO: Thread-2 addon.contractRunner.feeRateNQTPerFXT.BITSWIFT not defined
17172018-11-09 08:41:42 INFO: Thread-2 addon.contractRunner.feeRateNQTPerFXT.DOM not defined
17182018-11-09 08:41:42 INFO: Thread-2 addon.contractRunner.feeRateNQTPerFXT.IGNIS = "200000000"
17192018-11-09 08:41:42 INFO: Thread-2 addon.contractRunner.feeRateNQTPerFXT.AEUR not defined
17202018-11-09 08:41:42 INFO: Thread-2 addon.contractRunner.validator not defined
17212018-11-09 08:41:42 INFO: Thread-2 addon.contractRunner.seed not defined
17222018-11-09 08:41:42 WARNING: Thread-2 Contract runner random seed not specified, random values generated by this contract runner will be predictable
17232018-11-09 08:41:42 SEVERE: Thread-2 contract runner account ARDOR-XK4R-7VJU-6EQG-7R335 must have enough ARDR to pay the unconfirmed pool deposit
17242018-11-09 08:41:42 INFO: Thread-2 Add-on nxt.addons.ContractRunner registered new API: triggerContractByVoucher
17252018-11-09 08:41:42 INFO: Thread-2 Add-on nxt.addons.ContractRunner registered new API: reloadContractRunnerConfiguration
17262018-11-09 08:41:42 INFO: Thread-2 Add-on nxt.addons.ContractRunner registered new API: getSupportedContracts
17272018-11-09 08:41:42 INFO: Thread-2 Add-on nxt.addons.ContractRunner registered new API: triggerContractByRequest
17282018-11-09 08:41:42 INFO: Thread-2 Add-on nxt.addons.ContractRunner registered new API: triggerContractByTransaction
17292018-11-09 08:41:42 INFO: Thread-2 Add-on nxt.addons.ContractRunner registered new API: triggerContractByHeight
17302018-11-09 08:41:43 INFO: Thread-2 Started API server at 127.0.0.1:26875
17312018-11-09 08:41:43 FINE: main Starting 0 background jobs
17322018-11-09 08:41:43 FINE: main Starting 0 delayed tasks
17332018-11-09 08:41:43 INFO: main nxt.debugTraceQuote = """
17342018-11-09 08:41:43 INFO: main nxt.debugTraceSeparator = "	"
17352018-11-09 08:41:43 INFO: main nxt.debugLogUnconfirmed = "false"
17362018-11-09 08:41:43 INFO: main nxt.debugTraceAccounts not defined
17372018-11-09 08:41:43 INFO: main nxt.debugTraceLog = "nxt-trace.csv"
17382018-11-09 08:41:43 INFO: main Initialization took 4 seconds
17392018-11-09 08:41:43 INFO: main Ardor server 2.2.0e started successfully.
17402018-11-09 08:41:43 INFO: main Copyright © 2013-2016 The Nxt Core Developers.
17412018-11-09 08:41:43 INFO: main Copyright © 2016-2018 Jelurida IP B.V.
17422018-11-09 08:41:43 INFO: main Distributed under the Jelurida Public License version 1.1 for the Ardor Public Blockchain Platform, with ABSOLUTELY NO WARRANTY.
17432018-11-09 08:41:43 INFO: main Client UI is at http://localhost:26875/index.html
17442018-11-09 08:41:43 INFO: main RUNNING ON TESTNET - DO NOT USE REAL ACCOUNTS!
17452018-11-09 08:41:43 FINE: main [sendMoney]: request {chain=[1], requestType=[sendMoney], amountNQT=[10000000000000], feeNQT=[1100000000], recipient=[5873880488492319831], secretPhrase=[5hiig9BPdYoBzWni0QPaCDno6Wz0Vg8oX9yMcXRjEhmkuQKhvB]}
17462018-11-09 08:41:43 FINE: main [sendMoney]: response {"errorDescription":"Unknown account","errorCode":5}
1747
17482018-11-09 08:41:43 FINE: main [sendMoney]: request {chain=[1], requestType=[sendMoney], amountNQT=[10000000000000], feeNQT=[1100000000], recipient=[5873880488492319831], secretPhrase=[5hiig9BPdYoBzWni0QPaCDno6Wz0Vg8oX9yMcXRjEhmkuQKhvB]}
1749
1750Test ignored.
1751
1752java.lang.AssertionError: No key 'fullHash' in object '{"errorDescription":"Unknown account","errorCode":5}'
1753
1754	at org.junit.Assert.fail(Assert.java:88)
1755	at org.junit.Assert.assertTrue(Assert.java:41)
1756	at org.junit.Assert.assertNotNull(Assert.java:621)
1757	at nxt.util.JSONAssert.str(JSONAssert.java:44)
1758	at nxt.BlockchainTest.fundTestAccounts(BlockchainTest.java:165)
1759	at nxt.BlockchainTest.lambda$initBlockchainTest$2(BlockchainTest.java:124)
1760	at java.security.AccessController.doPrivileged(Native Method)
1761	at nxt.BlockchainTest.initBlockchainTest(BlockchainTest.java:122)
1762	at com.jelurida.ardor.contracts.AbstractContractTest.lambda$init$0(AbstractContractTest.java:38)
1763	at java.security.AccessController.doPrivileged(Native Method)
1764	at com.jelurida.ardor.contracts.AbstractContractTest.init(AbstractContractTest.java:26)
1765	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
1766	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
1767	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
1768	at java.lang.reflect.Method.invoke(Method.java:498)
1769	at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:47)
1770	at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
1771	at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:44)
1772	at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:24)
1773	at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
1774	at org.junit.runners.ParentRunner.run(ParentRunner.java:309)
1775	at org.junit.runners.Suite.runChild(Suite.java:127)
1776	at org.junit.runners.Suite.runChild(Suite.java:26)
1777	at org.junit.runners.ParentRunner$3.run(ParentRunner.java:238)
1778	at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:63)
1779	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:236)
1780	at org.junit.runners.ParentRunner.access$000(ParentRunner.java:53)
1781	at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:229)
1782	at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
1783	at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
1784	at org.junit.runners.ParentRunner.run(ParentRunner.java:309)
1785	at org.junit.runner.JUnitCore.run(JUnitCore.java:160)
1786	at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:68)
1787	at com.intellij.rt.execution.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:47)
1788	at com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:242)
1789	at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:70)
1790
1791
17922018-11-09 08:41:43 INFO: main Ardor server 2.2.0e stopped.
1793
1794Process finished with exit code -1