]> git.openstreetmap.org Git - osqa.git/blob - sql_scripts/update_2010_01_23.sql
Initial commit
[osqa.git] / sql_scripts / update_2010_01_23.sql
1 CREATE TABLE `fbconnect_fbassociation` (
2     `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
3     `user_id` integer NOT NULL,
4     `fbuid` varchar(12) NOT NULL UNIQUE
5 )
6 ;
7 ALTER TABLE `fbconnect_fbassociation` ADD CONSTRAINT `user_id_refs_id_3534873d`
8 FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`);
9 CREATE INDEX `fbconnect_fbassociation_user_id` ON `fbconnect_fbassociation` (`user_id`);