585 |
|
Query.ExecSQL; |
586 |
|
Query.SQL.Text := |
587 |
|
'CREATE TABLE linkmap ( id AUTOINC PRIMARY KEY, src_id INTEGER, ' + |
588 |
< |
'src_link_offset INTEGER, target_id INTEGER, INDEX idsrcid src_id, ' + |
589 |
< |
'INDEX iddestid target_id);'; |
588 |
> |
'src_link_offset INTEGER, target_id INTEGER, INDEX idsrcid x src_id, ' + |
589 |
> |
'INDEX iddestid x target_id);'; |
590 |
|
Query.ExecSQL; |
591 |
|
Query.SQL.Text := |
592 |
|
'CREATE TABLE rawmap ( id AUTOINC PRIMARY KEY, src_id INTEGER, ' + |
593 |
|
'src_link_offset INTEGER, sep BOOLEAN, size INTEGER, ' + |
594 |
|
'data BLOB BlobCompressionMode 9 BlobBlockSize 1024 BlobCompressionAlgorithm ZLib, ' + |
595 |
< |
'INDEX idsrcid src_id);'; |
595 |
> |
'INDEX idsrcid x src_id);'; |
596 |
|
// Query.SQL.Text:='CREATE TABLE rawmap ( id AUTOINC PRIMARY KEY, src_id INTEGER, src_link_offset INTEGER, size INTEGER, data BLOB BlobCompressionAlgorithm None );'; |
597 |
|
Query.ExecSQL; |
598 |
|
Query.SQL.Text := |