From d036b432cb49742e26e66d652f67e54e9a9a8cd2 Mon Sep 17 00:00:00 2001
From: hrcerqueira <hrcerqueira@gmail.com>
Date: Sat, 23 Jan 2010 18:20:03 +0000
Subject: Sql file for installing fbconnect table.

---
 sql_scripts/update_2010_01_23.sql | 9 +++++++++
 1 file changed, 9 insertions(+)
 create mode 100755 sql_scripts/update_2010_01_23.sql

(limited to 'sql_scripts/update_2010_01_23.sql')

diff --git a/sql_scripts/update_2010_01_23.sql b/sql_scripts/update_2010_01_23.sql
new file mode 100755
index 00000000..621207be
--- /dev/null
+++ b/sql_scripts/update_2010_01_23.sql
@@ -0,0 +1,9 @@
+CREATE TABLE `fbconnect_fbassociation` (
+    `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
+    `user_id` integer NOT NULL,
+    `fbuid` varchar(12) NOT NULL UNIQUE
+)
+;
+ALTER TABLE `fbconnect_fbassociation` ADD CONSTRAINT `user_id_refs_id_3534873d`
+FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`);
+CREATE INDEX `fbconnect_fbassociation_user_id` ON `fbconnect_fbassociation` (`user_id`);
-- 
cgit v1.2.3-1-g7c22

