From 82cc031c6537d55c84722ad420e431dc71eefecd Mon Sep 17 00:00:00 2001 From: Peng Wu Date: Wed, 6 Jun 2012 11:02:54 +0800 Subject: clean android db --- data/db/Makefile.am | 50 ---------------------------------- data/db/android/id.py | 1 - data/db/android/pydict.py | 1 - data/db/create_index.sql | 68 ----------------------------------------------- 4 files changed, 120 deletions(-) delete mode 100644 data/db/Makefile.am delete mode 120000 data/db/android/id.py delete mode 120000 data/db/android/pydict.py delete mode 100644 data/db/create_index.sql (limited to 'data') diff --git a/data/db/Makefile.am b/data/db/Makefile.am deleted file mode 100644 index 398bcad..0000000 --- a/data/db/Makefile.am +++ /dev/null @@ -1,50 +0,0 @@ -# vim:set noet ts=4: -# -# ibus-pinyin - The Chinese PinYin engine for IBus -# -# Copyright (c) 2008-2010 Peng Huang -# -# This program is free software; you can redistribute it and/or modify -# it under the terms of the GNU General Public License as published by -# the Free Software Foundation; either version 2, or (at your option) -# any later version. -# -# This program is distributed in the hope that it will be useful, -# but WITHOUT ANY WARRANTY; without even the implied warranty of -# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the -# GNU General Public License for more details. -# -# You should have received a copy of the GNU General Public License -# along with this program; if not, write to the Free Software -# Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA. - -main_db_DATA = \ - create_index.sql \ - $(NULL) -main_dbdir = $(pkgdatadir)/db - -EXTRA_DIST = \ - create_index.sql \ - $(NULL) - -SUBDIRS = \ - android \ - open-phrase \ - $(NULL) - - -install-data-hook: - @( \ -if test "$(NO_INDEX)" = ""; then \ - cd $(DESTDIR)$(main_dbdir); \ - if test -f android.db; then \ - echo "Creating index for android.db"; \ - sqlite3 android.db ".read create_index.sql"; \ - fi; \ - if test -f open-phrase.db; then \ - echo "Creating index for open-phrase.db"; \ - sqlite3 open-phrase.db ".read create_index.sql"; \ - fi; \ -fi) - - diff --git a/data/db/android/id.py b/data/db/android/id.py deleted file mode 120000 index feea3e1..0000000 --- a/data/db/android/id.py +++ /dev/null @@ -1 +0,0 @@ -../../../scripts/id.py \ No newline at end of file diff --git a/data/db/android/pydict.py b/data/db/android/pydict.py deleted file mode 120000 index 762c55e..0000000 --- a/data/db/android/pydict.py +++ /dev/null @@ -1 +0,0 @@ -../../../scripts/pydict.py \ No newline at end of file diff --git a/data/db/create_index.sql b/data/db/create_index.sql deleted file mode 100644 index d40ed02..0000000 --- a/data/db/create_index.sql +++ /dev/null @@ -1,68 +0,0 @@ -/* 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; -- cgit