Changeset 750 for trunk/app/config

Timestamp:

09/02/08 21:40:55 (3 months ago)

Author:

aarkerio

Message:

backups scripts

Location:

trunk/app/config/sql/postgresql

Files:

• entries.sql (modified) (1 diff)
• lessons.sql (modified) (1 diff)
• news.sql (modified) (1 diff)

trunk/app/config/sql/postgresql/entries.sql

@@ -11 +11 @@
 "karanet" smallint NOT NULL DEFAULT 0
 );
+-- search engine index
+CREATE INDEX entries_idx ON entries USING gin(to_tsvector('spanish', body));
 
-

trunk/app/config/sql/postgresql/lessons.sql

@@ -14 +14 @@
 );
 
-
+CREATE INDEX lessons_idx ON lessons USING gin(to_tsvector('spanish', body));

trunk/app/config/sql/postgresql/news.sql

@@ -18 +18 @@
 3, 1, 1);
 
+CREATE INDEX news_idx ON news USING gin(to_tsvector('spanish', body));