summaryrefslogtreecommitdiffstats
path: root/sql_scripts/update_2010_01_23.sql
blob: 621207be52f1292fedba97b184742f80d02b1fd1 (plain)
1
2
3
4
5
6
7
8
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`);