summaryrefslogtreecommitdiff
path: root/bucky2/schema/search-log.sql
diff options
context:
space:
mode:
authorJules Laplace <carbon@melanarchy.org>2013-08-02 17:23:25 -0500
committerJules Laplace <carbon@melanarchy.org>2013-08-02 17:23:25 -0500
commite76b691e78e273226cba9284cb8cd22a423319ed (patch)
treea58d22f69869fe2bf3885f81bdda4952f87ff6d7 /bucky2/schema/search-log.sql
parent753f60c7d4769fa72d3b910e491f37db6f130898 (diff)
bucky2
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;
+