diff options
| author | Peng Huang <shawn.p.huang@gmail.com> | 2009-10-05 15:52:57 +0800 |
|---|---|---|
| committer | Peng Huang <shawn.p.huang@gmail.com> | 2009-10-05 15:52:57 +0800 |
| commit | efa62ef0960cbebeb38110d9fc95f895da1d2a59 (patch) | |
| tree | d834c6fd76dd4effac43a9414972978d2781e658 /data | |
| parent | 7a755bd0134e600586dbd53186553bdfb5ebc0dc (diff) | |
| download | ibus-libpinyin-efa62ef0960cbebeb38110d9fc95f895da1d2a59.tar.gz ibus-libpinyin-efa62ef0960cbebeb38110d9fc95f895da1d2a59.tar.xz ibus-libpinyin-efa62ef0960cbebeb38110d9fc95f895da1d2a59.zip | |
Add create_index.sql in data/db
Diffstat (limited to 'data')
| -rw-r--r-- | data/db/create_index.sql | 31 |
1 files changed, 31 insertions, 0 deletions
diff --git a/data/db/create_index.sql b/data/db/create_index.sql new file mode 100644 index 0000000..021baa6 --- /dev/null +++ b/data/db/create_index.sql @@ -0,0 +1,31 @@ +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); |