/usr/share/pyzy/db/create_index.sql is in libpyzy-1.0-0 1.0.1-4.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 | /* drop indexes */
DROP INDEX IF EXISTS index_0_0;
DROP INDEX IF EXISTS index_1_0;
DROP INDEX IF EXISTS index_1_1;
DROP INDEX IF EXISTS index_2_0;
DROP INDEX IF EXISTS index_2_1;
DROP INDEX IF EXISTS index_3_0;
DROP INDEX IF EXISTS index_3_1;
DROP INDEX IF EXISTS index_4_0;
DROP INDEX IF EXISTS index_4_1;
DROP INDEX IF EXISTS index_5_0;
DROP INDEX IF EXISTS index_5_1;
DROP INDEX IF EXISTS index_6_0;
DROP INDEX IF EXISTS index_6_1;
DROP INDEX IF EXISTS index_7_0;
DROP INDEX IF EXISTS index_7_1;
DROP INDEX IF EXISTS index_8_0;
DROP INDEX IF EXISTS index_8_1;
DROP INDEX IF EXISTS index_9_0;
DROP INDEX IF EXISTS index_9_1;
DROP INDEX IF EXISTS index_10_0;
DROP INDEX IF EXISTS index_10_1;
DROP INDEX IF EXISTS index_11_0;
DROP INDEX IF EXISTS index_11_1;
DROP INDEX IF EXISTS index_12_0;
DROP INDEX IF EXISTS index_12_1;
DROP INDEX IF EXISTS index_13_0;
DROP INDEX IF EXISTS index_13_1;
DROP INDEX IF EXISTS index_14_0;
DROP INDEX IF EXISTS index_14_1;
DROP INDEX IF EXISTS index_15_0;
DROP INDEX IF EXISTS index_15_1;
/* create indexes */
CREATE INDEX index_0_0 ON py_phrase_0(s0, y0);
CREATE INDEX index_1_0 ON py_phrase_1(s0, y0, s1, y1);
CREATE INDEX index_1_1 ON py_phrase_1(s0, s1, y1);
CREATE INDEX index_2_0 ON py_phrase_2(s0, y0, s1, y1, s2, y2);
CREATE INDEX index_2_1 ON py_phrase_2(s0, s1, s2, y2);
CREATE INDEX index_3_0 ON py_phrase_3(s0, y0, s1, y1, s2, y2);
CREATE INDEX index_3_1 ON py_phrase_3(s0, s1, s2, y2);
CREATE INDEX index_4_0 ON py_phrase_4(s0, y0, s1, y1, s2, y2);
CREATE INDEX index_4_1 ON py_phrase_4(s0, s1, s2, y2);
CREATE INDEX index_5_0 ON py_phrase_5(s0, y0, s1, y1, s2, y2);
CREATE INDEX index_5_1 ON py_phrase_5(s0, s1, s2, y2);
CREATE INDEX index_6_0 ON py_phrase_6(s0, y0, s1, y1, s2, y2);
CREATE INDEX index_6_1 ON py_phrase_6(s0, s1, s2, y2);
CREATE INDEX index_7_0 ON py_phrase_7(s0, y0, s1, y1, s2, y2);
CREATE INDEX index_7_1 ON py_phrase_7(s0, s1, s2, y2);
CREATE INDEX index_8_0 ON py_phrase_8(s0, y0, s1, y1, s2, y2);
CREATE INDEX index_8_1 ON py_phrase_8(s0, s1, s2, y2);
CREATE INDEX index_9_0 ON py_phrase_9(s0, y0, s1, y1, s2, y2);
CREATE INDEX index_9_1 ON py_phrase_9(s0, s1, s2, y2);
CREATE INDEX index_10_0 ON py_phrase_10(s0, y0, s1, y1, s2, y2);
CREATE INDEX index_10_1 ON py_phrase_10(s0, s1, s2, y2);
CREATE INDEX index_11_0 ON py_phrase_11(s0, y0, s1, y1, s2, y2);
CREATE INDEX index_11_1 ON py_phrase_11(s0, s1, s2, y2);
CREATE INDEX index_12_0 ON py_phrase_12(s0, y0, s1, y1, s2, y2);
CREATE INDEX index_12_1 ON py_phrase_12(s0, s1, s2, y2);
CREATE INDEX index_13_0 ON py_phrase_13(s0, y0, s1, y1, s2, y2);
CREATE INDEX index_13_1 ON py_phrase_13(s0, s1, s2, y2);
CREATE INDEX index_14_0 ON py_phrase_14(s0, y0, s1, y1, s2, y2);
CREATE INDEX index_14_1 ON py_phrase_14(s0, s1, s2, y2);
CREATE INDEX index_15_0 ON py_phrase_15(s0, y0, s1, y1, s2, y2);
CREATE INDEX index_15_1 ON py_phrase_15(s0, s1, s2, y2);
/* optimize database */
VACUUM;
|