1 CREATE SEQUENCE plugin_globaldashboard_user_forge_account_pk_seq start 1 increment 1 minvalue 1 cache 1 ;
2 CREATE TABLE plugin_globaldashboard_user_forge_account (
3 account_id integer PRIMARY KEY DEFAULT NEXTVAL('plugin_globaldashboard_user_forge_account_pk_seq') ,
4 user_id integer NOT NULL REFERENCES users(user_id) ,
5 forge_account_login_name varchar(32) DEFAULT '' NOT NULL ,
6 forge_account_password varchar(32) DEFAULT '' NOT NULL ,
7 forge_software integer DEFAULT 1 NOT NULL ,
8 forge_account_domain varchar(250) DEFAULT '' NOT NULL ,
9 forge_account_uri varchar(250) DEFAULT '' NOT NULL ,
10 forge_account_is_foaf integer DEFAULT 0 ,
11 forge_oslc_discovery_uri varchar(250) DEFAULT NULL ,
12 forge_account_rss_uri varchar(250) DEFAULT NULL ,
13 forge_account_soap_wsdl_uri varchar(250) DEFAULT NULL
16 CREATE SEQUENCE plugin_globaldashboard_account_discovery_pk_seq start 1 increment 1 minvalue 1 cache 1 ;
17 CREATE TABLE plugin_globaldashboard_account_discovery (
18 account_discovery_id integer PRIMARY KEY DEFAULT NEXTVAL('plugin_globaldashboard_account_discovery_pk_seq') ,
19 account_id integer NOT NULL REFERENCES plugin_globaldashboard_user_forge_account(account_id) ON DELETE CASCADE ,
20 projects_discovery_method integer DEFAULT NULL ,
21 artifacts_discovery_method integer DEFAULT NULL