1 CREATE SEQUENCE plugin_oauthconsumer_provider_id_seq start 1 increment 1 minvalue 1 cache 1;
2 CREATE TABLE plugin_oauthconsumer_provider (id INTEGER PRIMARY KEY DEFAULT NEXTVAL('plugin_oauthconsumer_provider_id_seq'),
3 name VARCHAR(128) NOT NULL,
4 description VARCHAR(500) NOT NULL,
5 consumer_key VARCHAR(250) NOT NULL,
6 consumer_secret VARCHAR(250) NOT NULL,
7 request_token_url VARCHAR(250) NOT NULL,
8 authorize_url VARCHAR(250) NOT NULL,
9 access_token_url VARCHAR(250) NOT NULL
11 CREATE UNIQUE INDEX idx_oauthconsumer_provider_name on plugin_oauthconsumer_provider(name);
12 CREATE UNIQUE INDEX idx_oauthconsumer_provider_consumer_key on plugin_oauthconsumer_provider(consumer_key);
14 CREATE SEQUENCE plugin_oauthconsumer_access_token_id_seq start 1 increment 1 minvalue 1 cache 1;
15 CREATE TABLE plugin_oauthconsumer_access_token (id INTEGER PRIMARY KEY DEFAULT NEXTVAL('plugin_oauthconsumer_access_token_id_seq'),
16 provider_id INTEGER REFERENCES plugin_oauthconsumer_provider(id),
17 token_key VARCHAR(250) NOT NULL,
18 token_secret VARCHAR(250) NOT NULL,
19 user_id INTEGER NOT NULL,
20 time_stamp INTEGER NOT NULL,
22 CHECK (consumer_id>=0),
25 CREATE UNIQUE INDEX idx_oauthconsumer_access_token_key on plugin_oauthconsumer_access_token(token_key);
27 CREATE SEQUENCE plugin_oauthconsumer_resource_id_seq start 1 increment 1 minvalue 1 cache 1;
28 CREATE TABLE plugin_oauthconsumer_resource (id INTEGER PRIMARY KEY DEFAULT NEXTVAL('plugin_oauthconsumer_resource_id_seq'),
29 provider_id INTEGER REFERENCES plugin_oauthconsumer_provider(id),
30 url VARCHAR(250) NOT NULL,
31 http_method VARCHAR(10) NOT NULL