summaryrefslogtreecommitdiff
path: root/bucky2/schema/search-log.sql
diff options
context:
space:
mode:
Diffstat (limited to 'bucky2/schema/search-log.sql')
-rw-r--r--bucky2/schema/search-log.sql11
1 files changed, 11 insertions, 0 deletions
diff --git a/bucky2/schema/search-log.sql b/bucky2/schema/search-log.sql
new file mode 100644
index 0000000..ae61893
--- /dev/null
+++ b/bucky2/schema/search-log.sql
@@ -0,0 +1,11 @@
+USE `bucky`;
+
+DROP TABLE IF EXISTS `search_log`;
+CREATE TABLE `search_log` (
+ `id` int(11) NOT NULL auto_increment,
+ `query` varchar(255),
+ `date` int(11),
+ `matches` int(11),
+ PRIMARY KEY(`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+