From 6f531aa3ac1dfefe9c61033b2f4ba13162c23186 Mon Sep 17 00:00:00 2001
From: raylu <raylu@mixpanel.com>
Date: Mon, 25 Jul 2011 01:19:07 -0700
Subject: add animelist sql file

---
 setup/animelist.sql | 9 +++++++++
 1 file changed, 9 insertions(+)
 create mode 100644 setup/animelist.sql

(limited to 'setup/animelist.sql')

diff --git a/setup/animelist.sql b/setup/animelist.sql
new file mode 100644
index 0000000..27513e8
--- /dev/null
+++ b/setup/animelist.sql
@@ -0,0 +1,9 @@
+DROP TABLE IF EXISTS `anime_list`;
+
+CREATE TABLE `anime_list` (
+  `uid` int(11) unsigned NOT NULL,
+  `aid` int(11) unsigned NOT NULL,
+  `status` tinyint(4) NOT NULL,
+  `episodes` int(11) NOT NULL,
+  KEY `aiduid` (`aid`, `uid`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- 
cgit v1.2.3

