summaryrefslogtreecommitdiffstats
path: root/sql_scripts
diff options
context:
space:
mode:
Diffstat (limited to 'sql_scripts')
-rwxr-xr-xsql_scripts/update_2010_01_23.sql9
1 files changed, 9 insertions, 0 deletions
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`);