...
| No Format |
|---|
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; |
PostgreSQL
| No Format |
|---|
-- Table: "UPC_FACEBOOK"
DROP TABLE "upc_facebook";
CREATE TABLE "upc_facebook"
(
"uid" varchar NOT NULL,
"session" varchar,
"preferences" text,
CONSTRAINT pk_uid PRIMARY KEY ("uid")
)
WITHOUT OIDS;
ALTER TABLE "upc_facebook" OWNER TO portal;
-- Table: "UPC_FACEBOOK_PREFS"
DROP TABLE "upc_facebook_prefs";
CREATE TABLE "upc_facebook_prefs"
(
"uid" varchar NOT NULL,
"pref_nm" varchar,
"pref_val" bool
)
WITHOUT OIDS;
ALTER TABLE "upc_facebook_prefs" OWNER TO portal;
|
You will also need to create a Facebook API and "secret" key. If you don't have a Facebook account, create one and then go to the developers sectionto sign up for an API key (it's free). When signing up, make sure you enter the full URL of your portal as the Callback URL and set the Application Type to website.
...