...
You will then need to create 2 tables in your PortalDb database (if you use MySQL, just execute the following):
| No Format |
|---|
CREATE CREATE TABLE IF NOT EXISTS `UPC_FACEBOOK` ( `UID` varchar(128) NOT NULL, `SESSION` varchar(255) DEFAULT NULL, `PREFERENCES` text, PRIMARY KEY (`UID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE IF NOT EXISTS `UPC_FACEBOOK_PREFS` ( `UID` varchar(128) NOT NULL, `PREF_NM` varchar(128) DEFAULT NULL, `PREF_VAL` tinyint(1) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
...
This portlet has not been thoroughly tested under heavy load and should not be placed into a production environment without doing so first. Enjoy!