Ni­PDB Database

CREATE TABLE [dbo].[acquis]
(
[acquis_id] [int] NOT NULL IDENTITY(1, 1),
[orgs_id] [int] NULL,
[acquis_ref] [int] NOT NULL,
[acquis_type] [int] NOT NULL,
[acquis_valid_from] [datetime] NOT NULL,
[acquis_valid_to] [datetime] NOT NULL,
[acquis_text] [nvarchar] (max) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL,
[acquis_adnl_info] [nvarchar] (max) COLLATE Finnish_­Swedish_­CI_­AS NULL
) ON [PRIMARY] TEXTIMAGE_­ON [PRIMARY]
GO
ALTER TABLE [dbo].[acquis] ADD CONSTRAINT [PK_acquis_id] PRIMARY KEY CLUSTERED ([acquis_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[acquis] ADD CONSTRAINT [FK_acquis_orgs_id] FOREIGN KEY ([orgs_id]) REFERENCES [dbo].[orgs] ([orgs_id])
GO

CREATE TABLE [dbo].[acquis_usr_relns]
(
[acquis_id] [int] NULL,
[usrs_id] [int] NULL,
[acquis_usr_reln_acquis_text] [nvarchar] (max) COLLATE Finnish_­Swedish_­CI_­AS NULL
) ON [PRIMARY] TEXTIMAGE_­ON [PRIMARY]
GO
ALTER TABLE [dbo].[acquis_usr_relns] ADD CONSTRAINT [FK_acquis_usr_relns_acquis_id] FOREIGN KEY ([acquis_id]) REFERENCES [dbo].[acquis] ([acquis_id])
GO
ALTER TABLE [dbo].[acquis_usr_relns] ADD CONSTRAINT [FK_acquis_usr_relns_usrs_id] FOREIGN KEY ([usrs_id]) REFERENCES [dbo].[usrs] ([usrs_id])
GO

CREATE TABLE [dbo].[act_usrs]
(
[act_usr_disp_name] [nvarchar] (300) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[act_usr_log_datetime] [datetime] NULL,
[act_usr_idle_datetime] [datetime] NULL,
[act_usr_type] [int] NOT NULL CONSTRAINT [DF_act_usrs_act_usr_type] DEFAULT ((0)),
[orgs_id] [int] NULL,
[act_usr_session_id] [nvarchar] (200) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[act_usr_ticket_bin] [varbinary] (max) NULL,
[usrs_id] [int] NULL,
[act_usr_login_mode] [int] NULL
) ON [PRIMARY] TEXTIMAGE_­ON [PRIMARY]
GO
ALTER TABLE [dbo].[act_usrs] ADD CONSTRAINT [FK_act_usrs_orgs_id] FOREIGN KEY ([orgs_id]) REFERENCES [dbo].[orgs] ([orgs_id])
GO
ALTER TABLE [dbo].[act_usrs] ADD CONSTRAINT [FK_act_usrs_usrs_id] FOREIGN KEY ([usrs_id]) REFERENCES [dbo].[usrs] ([usrs_id])
GO

CREATE TABLE [dbo].[adm_cfgs]
(
[adm_cfg_adnl_task_info] [nvarchar] (max) COLLATE Finnish_­Swedish_­CI_­AS NULL
) ON [PRIMARY] TEXTIMAGE_­ON [PRIMARY]
GO

CREATE TABLE [dbo].[adnl_ids]
(
[adnl_ids_id] [int] NOT NULL IDENTITY(1, 1),
[orgs_id] [int] NULL,
[adnl_id_value] [nvarchar] (max) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL,
[adnl_id_type] [int] NOT NULL,
[adnl_id_service_type] [int] NOT NULL,
[adnl_id_category_id] [int] NOT NULL,
[adnl_id_ref] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL,
[adnl_id_searchable] [bit] NOT NULL,
[adnl_id_adnl_info] [nvarchar] (max) COLLATE Finnish_­Swedish_­CI_­AS NULL
) ON [PRIMARY] TEXTIMAGE_­ON [PRIMARY]
GO
ALTER TABLE [dbo].[adnl_ids] ADD CONSTRAINT [PK_adnl_ids_id] PRIMARY KEY CLUSTERED ([adnl_ids_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[adnl_ids] ADD CONSTRAINT [FK_adnl_ids_orgs_id] FOREIGN KEY ([orgs_id]) REFERENCES [dbo].[orgs] ([orgs_id])
GO

CREATE TABLE [dbo].[cache_objs]
(
[cache_objs_id] [int] NOT NULL IDENTITY(1, 1),
[orgs_id] [int] NULL,
[cache_obj_type] [int] NOT NULL,
[cache_obj_type_adnl] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[cache_obj_binary] [varbinary] (max) NOT NULL,
[cache_obj_property] [nvarchar] (500) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL
) ON [PRIMARY] TEXTIMAGE_­ON [PRIMARY]
GO
ALTER TABLE [dbo].[cache_objs] ADD CONSTRAINT [PK_cache_objs_id] PRIMARY KEY CLUSTERED ([cache_objs_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[cache_objs] ADD CONSTRAINT [FK_cache_objs_orgs_id] FOREIGN KEY ([orgs_id]) REFERENCES [dbo].[orgs] ([orgs_id])
GO

CREATE TABLE [dbo].[cm_soc_sec_nrs]
(
[cm_soc_sec_nrs_id] [int] NOT NULL IDENTITY(1, 1),
[cm_soc_sec_nr_date] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[cm_soc_sec_nr_seqnr] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[cm_soc_sec_nr_gen] [nvarchar] (20) COLLATE Finnish_­Swedish_­CI_­AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[cm_soc_sec_nrs] ADD CONSTRAINT [PK_cm_soc_sec_nrs_id] PRIMARY KEY CLUSTERED ([cm_soc_sec_nrs_id]) ON [PRIMARY]
GO

CREATE TABLE [dbo].[creds]
(
[creds_id] [int] NOT NULL IDENTITY(1, 1),
[cred_obj_name] [varbinary] (max) NULL,
[cred_obj_value] [varbinary] (max) NULL,
[cred_prot] [bit] NOT NULL,
[cred_ref_id] [int] NULL,
[cred_type] [int] NOT NULL CONSTRAINT [DF_creds_cred_type] DEFAULT ((0)),
[orgs_id] [int] NULL
) ON [PRIMARY] TEXTIMAGE_­ON [PRIMARY]
GO
ALTER TABLE [dbo].[creds] ADD CONSTRAINT [PK_creds_id] PRIMARY KEY CLUSTERED ([creds_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[creds] ADD CONSTRAINT [FK_creds_orgs_id] FOREIGN KEY ([orgs_id]) REFERENCES [dbo].[orgs] ([orgs_id])
GO

CREATE TABLE [dbo].[crt_auths]
(
[crt_auths_id] [int] NOT NULL IDENTITY(1, 1),
[crt_auth_name] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[crt_auth_srv] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[crt_auth_crt_hash] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[crt_auth_mfr_type] [int] NOT NULL CONSTRAINT [DF_crt_auths_crt_auth_mfr_type] DEFAULT ((2)),
[crt_auth_enrl_type] [int] NOT NULL CONSTRAINT [DF_crt_auths_crt_auth_enrl_type] DEFAULT ((2)),
[orgs_id] [int] NULL,
[crt_auth_crl_list] [nvarchar] (500) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[crt_auth_ocsp_list] [nvarchar] (500) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[crt_auth_key_id] [nvarchar] (50) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[crt_auth_crt] [nvarchar] (max) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[crt_auth_adnl_info] [nvarchar] (max) COLLATE Finnish_­Swedish_­CI_­AS NULL
) ON [PRIMARY] TEXTIMAGE_­ON [PRIMARY]
GO
ALTER TABLE [dbo].[crt_auths] ADD CONSTRAINT [PK_crt_auths_id] PRIMARY KEY CLUSTERED ([crt_auths_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[crt_auths] ADD CONSTRAINT [FK_crt_auths_orgs_id] FOREIGN KEY ([orgs_id]) REFERENCES [dbo].[orgs] ([orgs_id])
GO

CREATE TABLE [dbo].[crt_keys]
(
[crt_keys_id] [int] NOT NULL IDENTITY(1, 1),
[orgs_id] [int] NULL,
[crt_key_type] [int] NOT NULL,
[crt_key_ref] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL,
[crt_key_value] [varbinary] (max) NOT NULL,
[crt_key_passw] [varbinary] (max) NULL,
[crt_key_adnl_info] [nvarchar] (max) COLLATE Finnish_­Swedish_­CI_­AS NULL
) ON [PRIMARY] TEXTIMAGE_­ON [PRIMARY]
GO
ALTER TABLE [dbo].[crt_keys] ADD CONSTRAINT [PK_crt_keys_id] PRIMARY KEY CLUSTERED ([crt_keys_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[crt_keys] ADD CONSTRAINT [FK_crt_keys_orgs_id] FOREIGN KEY ([orgs_id]) REFERENCES [dbo].[orgs] ([orgs_id])
GO

CREATE TABLE [dbo].[crt_tmls]
(
[crt_tmls_id] [int] NOT NULL IDENTITY(1, 1),
[crt_auths_id] [int] NULL,
[crt_tml_name] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[crt_tml_mfr_name] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[crt_tml_validity_key] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[crt_tml_validity_value] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[crt_tml_mfr_prof] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[crt_tml_mfr_end_entity] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[crt_tml_ldap_paths] [nvarchar] (max) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[crt_tml_tkn_label] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[orgs_id] [int] NULL,
[crt_tml_descr] [nvarchar] (300) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL CONSTRAINT [DF_crt_tmls_crt_tml_descr] DEFAULT (''),
[crt_tml_type] [int] NOT NULL CONSTRAINT [DF_crt_tmls_crt_tml_type] DEFAULT ((1)),
[crt_tml_rec] [bit] NOT NULL CONSTRAINT [DF_crt_tmls_crt_tml_rec] DEFAULT ((0)),
[crt_tml_rec_renew] [bit] NOT NULL CONSTRAINT [DF_crt_tmls_crt_tml_rec_renew] DEFAULT ((0)),
[crt_tml_asym_alg] [int] NOT NULL CONSTRAINT [DF_crt_tmls_crt_tml_asym_alg] DEFAULT ((2)),
[crt_tml_ecc_param] [int] NOT NULL CONSTRAINT [DF_crt_tmls_crt_tml_ecc_param] DEFAULT ((4)),
[crt_tml_hash_alg] [int] NOT NULL CONSTRAINT [DF_crt_tmls_crt_tml_hash_alg] DEFAULT ((1)),
[crt_tml_key_id] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL CONSTRAINT [DF_crt_tmls_crt_tml_key_id] DEFAULT (''),
[crt_tml_key_param] [nvarchar] (10) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL CONSTRAINT [DF_crt_tmls_crt_tml_key_param] DEFAULT ('0x800'),
[crt_tml_key_usage] [nvarchar] (10) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL CONSTRAINT [DF_crt_tmls_crt_tml_key_usage] DEFAULT ('0x­A0'),
[crt_tml_enhncd_key_usage] [nvarchar] (500) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[crt_tml_subj_cn_attr] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL CONSTRAINT [DF_crt_tmls_crt_tml_subj_cn_attr] DEFAULT ('\{directory.cn}'),
[crt_tml_subj_g_attr] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL CONSTRAINT [DF_crt_tmls_crt_tml_subj_g_attr] DEFAULT (''),
[crt_tml_subj_sn_attr] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL CONSTRAINT [DF_crt_tmls_crt_tml_subj_sn_attr] DEFAULT (''),
[crt_tml_subj_ou_attr] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL CONSTRAINT [DF_crt_tmls_crt_tml_subj_ou_attr] DEFAULT (''),
[crt_tml_subj_o_attr] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL CONSTRAINT [DF_crt_tmls_crt_tml_subj_o_attr] DEFAULT (''),
[crt_tml_subj_snr_attr] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL CONSTRAINT [DF_crt_tmls_crt_tml_subj_snr_attr] DEFAULT (''),
[crt_tml_subj_e_attr] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL CONSTRAINT [DF_crt_tmls_crt_tml_subj_e_attr] DEFAULT (''),
[crt_tml_subj_t_attr] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL CONSTRAINT [DF_crt_tmls_crt_tml_subj_t_attr] DEFAULT (''),
[crt_tml_subj_l_attr] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL CONSTRAINT [DF_crt_tmls_crt_tml_subj_l_attr] DEFAULT (''),
[crt_tml_subj_s_attr] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL CONSTRAINT [DF_crt_tmls_crt_tml_subj_s_attr] DEFAULT (''),
[crt_tml_subj_i_attr] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL CONSTRAINT [DF_crt_tmls_crt_tml_subj_i_attr] DEFAULT (''),
[crt_tml_subj_st_attr] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL CONSTRAINT [DF_crt_tmls_crt_tml_subj_st_attr] DEFAULT (''),
[crt_tml_subj_c_attr] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL CONSTRAINT [DF_crt_tmls_crt_tml_subj_c_attr] DEFAULT (''),
[crt_tml_subj_unstr_name_attr] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL CONSTRAINT [DF_crt_tmls_crt_tml_subj_unstr_name_attr] DEFAULT (''),
[crt_tml_subj_unstr_addr_attr] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL CONSTRAINT [DF_crt_tmls_crt_tml_subj_unstr_addr_attr] DEFAULT (''),
[crt_tml_extsn_san_upn_attr] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL CONSTRAINT [DF_crt_tmls_crt_tml_extsn_san_upn_attr] DEFAULT ('\{directory.user­Principal­Name}'),
[crt_tml_extsn_san_rfc822_attr] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL CONSTRAINT [DF_crt_tmls_crt_tml_extsn_san_rfc822_attr] DEFAULT (''),
[crt_tml_extsn_san_dns_attr] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL CONSTRAINT [DF_crt_tmls_crt_tml_extsn_san_dns_attr] DEFAULT (''),
[crt_tml_extsn_san_dn_attr] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL CONSTRAINT [DF_crt_tmls_crt_tml_extsn_san_dn_attr] DEFAULT (''),
[crt_tml_extsn_san_url_attr] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL CONSTRAINT [DF_crt_tmls_crt_tml_extsn_san_url_attr] DEFAULT (''),
[crt_tml_extsn_san_ip_attr] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL CONSTRAINT [DF_crt_tmls_crt_tml_extsn_san_ip_attr] DEFAULT (''),
[crt_tml_extsn_san_guid_attr] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL CONSTRAINT [DF_crt_tmls_crt_tml_extsn_san_guid_attr] DEFAULT (''),
[crt_tml_extsn_san_oid_attr] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL CONSTRAINT [DF_crt_tmls_crt_tml_extsn_san_oid_attr] DEFAULT (''),
[crt_tml_extn_seis_attr] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL CONSTRAINT [DF_crt_tmls_crt_tml_extn_seis_attr] DEFAULT (''),
[crt_tml_extsn_qc_eu_comp_attr] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL CONSTRAINT [DF_crt_tmls_crt_tml_extsn_qc_eu_comp_attr] DEFAULT (''),
[crt_tml_extsn_qc_eu_limit_value_attr] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL CONSTRAINT [DF_crt_tmls_crt_tml_extsn_qc_eu_limit_value_attr] DEFAULT (''),
[crt_tml_extsn_qc_eu_limit_cur_attr] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL CONSTRAINT [DF_crt_tmls_crt_tml_extsn_qc_eu_limit_cur_attr] DEFAULT (''),
[crt_tml_extsn_qc_eu_sscd_attr] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL CONSTRAINT [DF_crt_tmls_crt_tml_extsn_qc_eu_sscd_attr] DEFAULT (''),
[crt_tml_adnl_task_info] [nvarchar] (max) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[crt_tml_visible] [bit] NULL,
[crt_tml_adnl_info] [nvarchar] (max) COLLATE Finnish_­Swedish_­CI_­AS NULL
) ON [PRIMARY] TEXTIMAGE_­ON [PRIMARY]
GO
ALTER TABLE [dbo].[crt_tmls] ADD CONSTRAINT [PK_crt_tmls_id] PRIMARY KEY CLUSTERED ([crt_tmls_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[crt_tmls] ADD CONSTRAINT [FK_crt_tmls_crt_auths_id] FOREIGN KEY ([crt_auths_id]) REFERENCES [dbo].[crt_auths] ([crt_auths_id])
GO
ALTER TABLE [dbo].[crt_tmls] ADD CONSTRAINT [FK_crt_tmls_orgs_id] FOREIGN KEY ([orgs_id]) REFERENCES [dbo].[orgs] ([orgs_id])
GO

CREATE TABLE [dbo].[crt_whitelist_appvls]
(
[crt_whitelist_appvls_id] [int] NOT NULL IDENTITY(1, 1),
[orgs_id] [int] NULL,
[crt_whitelists_id] [int] NULL,
[crt_whitelist_appvl_created_datetime] [datetime] NOT NULL,
[crt_whitelist_appvl_evidence] [nvarchar] (max) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL,
[crt_whitelist_appvl_comment] [nvarchar] (max) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL,
[crt_whitelist_appvl_adnl_info] [nvarchar] (max) COLLATE Finnish_­Swedish_­CI_­AS NULL
) ON [PRIMARY] TEXTIMAGE_­ON [PRIMARY]
GO
ALTER TABLE [dbo].[crt_whitelist_appvls] ADD CONSTRAINT [PK_crt_whitelist_appvls_id] PRIMARY KEY CLUSTERED ([crt_whitelist_appvls_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[crt_whitelist_appvls] ADD CONSTRAINT [FK_crt_whitelist_appvls_crt_whitelists_id] FOREIGN KEY ([crt_whitelists_id]) REFERENCES [dbo].[crt_whitelists] ([crt_whitelists_id])
GO
ALTER TABLE [dbo].[crt_whitelist_appvls] ADD CONSTRAINT [FK_crt_whitelist_appvls_orgs_id] FOREIGN KEY ([orgs_id]) REFERENCES [dbo].[orgs] ([orgs_id])
GO

CREATE TABLE [dbo].[crt_whitelists]
(
[crt_whitelists_id] [int] NOT NULL IDENTITY(1, 1),
[orgs_id] [int] NULL,
[crt_whitelist_org_name] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL,
[crt_whitelist_org_nr] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL,
[crt_whitelist_org_l] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL,
[crt_whitelist_org_c] [nvarchar] (10) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL,
[crt_whitelist_name] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL,
[crt_whitelist_ref] [int] NOT NULL,
[crt_whitelist_type] [int] NOT NULL,
[crt_whitelist_status] [int] NOT NULL,
[crt_whitelist_valid_from] [datetime] NOT NULL,
[crt_whitelist_valid_to] [datetime] NOT NULL,
[crt_whitelist_changed_datetime] [datetime] NULL,
[crt_whitelist_evidence] [nvarchar] (max) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[crt_whitelist_comment] [nvarchar] (max) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[crt_whitelist_adnl_info] [nvarchar] (max) COLLATE Finnish_­Swedish_­CI_­AS NULL
) ON [PRIMARY] TEXTIMAGE_­ON [PRIMARY]
GO
ALTER TABLE [dbo].[crt_whitelists] ADD CONSTRAINT [PK_crt_whitelists_id] PRIMARY KEY CLUSTERED ([crt_whitelists_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[crt_whitelists] ADD CONSTRAINT [FK_crt_whitelists_orgs_id] FOREIGN KEY ([orgs_id]) REFERENCES [dbo].[orgs] ([orgs_id])
GO

CREATE TABLE [dbo].[crts]
(
[tkns_id] [int] NULL,
[crt_auths_id] [int] NULL,
[orgs_id] [int] NULL,
[crt_binary] [varbinary] (max) NULL,
[crt_subj] [nvarchar] (500) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[crt_snr] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[crt_valid_from] [datetime] NULL,
[crt_valid_to] [datetime] NULL,
[crt_issuer] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[crt_requester_name] [nvarchar] (200) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[crt_rev_datetime] [datetime] NULL,
[crt_rev_by] [nvarchar] (200) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[crt_hidden] [bit] NOT NULL,
[crt_type] [int] NOT NULL CONSTRAINT [DF_crts_crt_type] DEFAULT ((1)),
[crt_key_binary] [varbinary] (max) NULL,
[crt_status] [int] NOT NULL CONSTRAINT [DF_crts_crt_status] DEFAULT ((1)),
[crt_status_rsn] [int] NOT NULL CONSTRAINT [DF_crts_crt_status_rsn] DEFAULT ((-1)),
[crt_thumbprint] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[crt_tmls_id] [int] NULL,
[crt_adnl_info] [nvarchar] (max) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[crts_id] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[crt_ku] [nvarchar] (10) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[crt_nfcn_type] [int] NULL,
[usrs_id] [int] NULL,
[srvs_id] [int] NULL,
[crt_subj_alt_name] [nvarchar] (500) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[crt_mfr_tml_name] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[crt_nfcn_value] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[end_entities_id] [int] NULL
) ON [PRIMARY] TEXTIMAGE_­ON [PRIMARY]
GO
ALTER TABLE [dbo].[crts] ADD CONSTRAINT [FK_crts_crt_auths_id] FOREIGN KEY ([crt_auths_id]) REFERENCES [dbo].[crt_auths] ([crt_auths_id])
GO
ALTER TABLE [dbo].[crts] ADD CONSTRAINT [FK_crts_crt_tmls_id] FOREIGN KEY ([crt_tmls_id]) REFERENCES [dbo].[crt_tmls] ([crt_tmls_id])
GO
ALTER TABLE [dbo].[crts] ADD CONSTRAINT [FK_crts_end_entities_id] FOREIGN KEY ([end_entities_id]) REFERENCES [dbo].[end_entities] ([end_entities_id])
GO
ALTER TABLE [dbo].[crts] ADD CONSTRAINT [FK_crts_orgs_id] FOREIGN KEY ([orgs_id]) REFERENCES [dbo].[orgs] ([orgs_id])
GO
ALTER TABLE [dbo].[crts] ADD CONSTRAINT [FK_crts_srvs_id] FOREIGN KEY ([srvs_id]) REFERENCES [dbo].[srvs] ([srvs_id])
GO
ALTER TABLE [dbo].[crts] ADD CONSTRAINT [FK_crts_tkns_id] FOREIGN KEY ([tkns_id]) REFERENCES [dbo].[tkns] ([tkns_id])
GO
ALTER TABLE [dbo].[crts] ADD CONSTRAINT [FK_crts_usrs_id] FOREIGN KEY ([usrs_id]) REFERENCES [dbo].[usrs] ([usrs_id])
GO

CREATE TABLE [dbo].[dir_svcs]
(
[dir_svcs_id] [int] NOT NULL IDENTITY(1, 1),
[orgs_id] [int] NULL,
[dir_svc_type] [int] NOT NULL CONSTRAINT [DF_dir_svcs_dir_svc_type] DEFAULT ((2)),
[dir_svc_auth_type] [int] NOT NULL CONSTRAINT [DF_dir_svcs_dir_svc_auth_type] DEFAULT ((2)),
[dir_svc_prm] [bit] NOT NULL CONSTRAINT [DF_dir_svcs_dir_svc_prm] DEFAULT ((1)),
[dir_svc_srv] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL CONSTRAINT [DF_dir_svcs_dir_svc_srv] DEFAULT ('Root­DSE'),
[dir_svc_sa_grp_unique_id] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL CONSTRAINT [DF_dir_svcs_dir_svc_sa_grp_unique_id] DEFAULT (''),
[dir_svc_ldap_scoop_lvl] [int] NOT NULL CONSTRAINT [DF_dir_svcs_dir_svc_ldap_scoop_lvl] DEFAULT ((0)),
[dir_svc_end_entity_filter_attr] [nvarchar] (500) COLLATE Finnish_­Swedish_­CI_­AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[dir_svcs] ADD CONSTRAINT [PK_dir_svcs_id] PRIMARY KEY CLUSTERED ([dir_svcs_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[dir_svcs] ADD CONSTRAINT [FK_dir_svcs_orgs_id] FOREIGN KEY ([orgs_id]) REFERENCES [dbo].[orgs] ([orgs_id])
GO

CREATE TABLE [dbo].[end_entities]
(
[end_entities_id] [int] NOT NULL IDENTITY(1, 1),
[orgs_id] [int] NULL,
[end_entity_dir_type] [int] NOT NULL,
[end_entity_dir_id] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL,
[end_entity_status] [int] NOT NULL,
[end_entity_name] [nvarchar] (500) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL,
[end_entity_org_name] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL,
[end_entity_org_nr] [nvarchar] (50) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL,
[end_entity_org_locality] [nvarchar] (50) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL,
[end_entity_org_country] [nvarchar] (10) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL,
[end_entity_snr] [nvarchar] (200) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[end_entity_mail_addr] [nvarchar] (200) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[end_entity_resp_name] [nvarchar] (200) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[end_entity_resp_mail] [nvarchar] (200) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[end_entity_resp_mobile] [nvarchar] (50) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[end_entity_san] [nvarchar] (max) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[end_entity_adnl_info] [nvarchar] (max) COLLATE Finnish_­Swedish_­CI_­AS NULL
) ON [PRIMARY] TEXTIMAGE_­ON [PRIMARY]
GO
ALTER TABLE [dbo].[end_entities] ADD CONSTRAINT [PK_end_entities_id] PRIMARY KEY CLUSTERED ([end_entities_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[end_entities] ADD CONSTRAINT [FK_end_entities_orgs_id] FOREIGN KEY ([orgs_id]) REFERENCES [dbo].[orgs] ([orgs_id])
GO

CREATE TABLE [dbo].[gen_sets]
(
[gen_sets_id] [int] NOT NULL IDENTITY(1, 1),
[property] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL CONSTRAINT [DF_gen_sets_property] DEFAULT (''),
[value] [nvarchar] (max) COLLATE Finnish_­Swedish_­CI_­AS NULL
) ON [PRIMARY] TEXTIMAGE_­ON [PRIMARY]
GO
ALTER TABLE [dbo].[gen_sets] ADD CONSTRAINT [PK_gen_sets_id] PRIMARY KEY CLUSTERED ([gen_sets_id]) ON [PRIMARY]
GO

CREATE TABLE [dbo].[gen_txts]
(
[gen_txts_id] [int] NOT NULL IDENTITY(1, 1),
[orgs_id] [int] NULL,
[gen_txt_type] [int] NOT NULL,
[gen_txt_svc_type] [int] NOT NULL,
[gen_txt_task_type_id] [int] NOT NULL,
[gen_txt_value] [nvarchar] (max) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL,
[gen_txt_adnl_info] [nvarchar] (max) COLLATE Finnish_­Swedish_­CI_­AS NULL
) ON [PRIMARY] TEXTIMAGE_­ON [PRIMARY]
GO
ALTER TABLE [dbo].[gen_txts] ADD CONSTRAINT [PK_gen_txts_id] PRIMARY KEY CLUSTERED ([gen_txts_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[gen_txts] ADD CONSTRAINT [FK_gen_txts_orgs_id] FOREIGN KEY ([orgs_id]) REFERENCES [dbo].[orgs] ([orgs_id])
GO

CREATE TABLE [dbo].[hist_tkns]
(
[usrs_id] [int] NULL,
[hist_tkn_type] [int] NOT NULL,
[hist_tkn_snr] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL,
[hist_tkn_datetime] [datetime] NOT NULL,
[hist_tkn_status] [int] NOT NULL,
[hist_tkn_status_rsn] [int] NOT NULL,
[hist_tkns_id] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[tkns_id] [int] NULL,
[hist_tkn_rec_binary] [varbinary] (max) NULL,
[hist_tkn_rec_type] [int] NULL
) ON [PRIMARY] TEXTIMAGE_­ON [PRIMARY]
GO
ALTER TABLE [dbo].[hist_tkns] ADD CONSTRAINT [FK_hist_tkns_usrs_id] FOREIGN KEY ([usrs_id]) REFERENCES [dbo].[usrs] ([usrs_id])
GO

CREATE TABLE [dbo].[key_objs]
(
[key_objs_id] [int] NOT NULL IDENTITY(1, 1),
[key_blob_type] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[key_blob] [varbinary] (max) NULL,
[key_obj_param] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[key_obj_usr_dist_name] [nvarchar] (500) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[key_obj_tkn_snr] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[key_obj_key_binary] [varbinary] (max) NULL,
[key_obj_purpose] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[key_obj_protn] [bit] NOT NULL CONSTRAINT [DF_key_objs_key_obj_protn] DEFAULT ((0)),
[key_obj_type] [int] NOT NULL CONSTRAINT [DF_key_objs_key_obj_type] DEFAULT ((0)),
[orgs_id] [int] NULL,
[tkns_id] [int] NULL
) ON [PRIMARY] TEXTIMAGE_­ON [PRIMARY]
GO
ALTER TABLE [dbo].[key_objs] ADD CONSTRAINT [PK_key_objs_id] PRIMARY KEY CLUSTERED ([key_objs_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[key_objs] ADD CONSTRAINT [FK_key_objs_orgs_id] FOREIGN KEY ([orgs_id]) REFERENCES [dbo].[orgs] ([orgs_id])
GO
ALTER TABLE [dbo].[key_objs] ADD CONSTRAINT [FK_key_objs_tkns_id] FOREIGN KEY ([tkns_id]) REFERENCES [dbo].[tkns] ([tkns_id])
GO

CREATE TABLE [dbo].[lic_svc_custs]
(
[lic_svc_custs_id] [int] NOT NULL IDENTITY(1, 1),
[lic_svc_cust_name] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL,
[lic_svc_cust_mail_addr] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[lic_svc_cust_mobile_nr] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[lic_svc_cust_created_datetime] [datetime] NOT NULL,
[lic_svc_cust_bin] [varbinary] (max) NULL,
[lic_svc_cust_ref_type] [nvarchar] (50) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[lic_svc_cust_ref_id] [int] NULL
) ON [PRIMARY] TEXTIMAGE_­ON [PRIMARY]
GO
ALTER TABLE [dbo].[lic_svc_custs] ADD CONSTRAINT [PK_lic_svc_custs_id] PRIMARY KEY CLUSTERED ([lic_svc_custs_id]) ON [PRIMARY]
GO

CREATE TABLE [dbo].[lic_svc_machines]
(
[lic_svc_machines_id] [int] NOT NULL IDENTITY(1, 1),
[lic_svc_masters_id] [int] NULL,
[lic_svc_machine_name] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[lic_svc_machine_company] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL,
[lic_svc_machine_value] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL,
[lic_svc_machine_amount] [int] NOT NULL,
[lic_svc_machine_system] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL,
[lic_svc_machine_status] [int] NOT NULL,
[lic_svc_machine_published] [bit] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[lic_svc_machines] ADD CONSTRAINT [PK_lic_svc_machines_id] PRIMARY KEY CLUSTERED ([lic_svc_machines_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[lic_svc_machines] ADD CONSTRAINT [FK_lic_svc_machines_lic_svc_masters_id] FOREIGN KEY ([lic_svc_masters_id]) REFERENCES [dbo].[lic_svc_masters] ([lic_svc_masters_id])
GO

CREATE TABLE [dbo].[lic_svc_masters]
(
[lic_svc_masters_id] [int] NOT NULL IDENTITY(1, 1),
[lic_svc_custs_id] [int] NULL,
[lic_svc_master_ref_id] [int] NOT NULL,
[lic_svc_master_name] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL,
[lic_svc_master_company] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL,
[lic_svc_master_value] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL,
[lic_svc_master_mode] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL,
[lic_svc_master_amount] [int] NOT NULL,
[lic_svc_master_amount_max] [int] NOT NULL,
[lic_svc_master_validity] [nvarchar] (50) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL,
[lic_svc_master_next_update] [nvarchar] (50) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL,
[lic_svc_master_signature] [varbinary] (max) NOT NULL
) ON [PRIMARY] TEXTIMAGE_­ON [PRIMARY]
GO
ALTER TABLE [dbo].[lic_svc_masters] ADD CONSTRAINT [PK_lic_svc_masters_id] PRIMARY KEY CLUSTERED ([lic_svc_masters_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[lic_svc_masters] ADD CONSTRAINT [FK_lic_svc_masters_lic_svc_custs_id] FOREIGN KEY ([lic_svc_custs_id]) REFERENCES [dbo].[lic_svc_custs] ([lic_svc_custs_id])
GO

CREATE TABLE [dbo].[natl_regs]
(
[natl_regs_id] [int] NOT NULL IDENTITY(1, 1),
[orgs_id] [int] NULL,
[natl_reg_name] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL,
[natl_reg_name_enum] [int] NOT NULL,
[natl_reg_service] [nvarchar] (500) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL,
[natl_reg_search_type] [int] NOT NULL,
[natl_reg_auth_type] [int] NOT NULL,
[natl_reg_auth_crt_hash] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[natl_reg_cust_id] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL,
[natl_reg_ord_id] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL,
[natl_reg_priority] [bit] NULL,
[natl_reg_hsa_id] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[natl_reg_hsa_base] [nvarchar] (500) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[natl_reg_hsa_base_end_entity] [nvarchar] (500) COLLATE Finnish_­Swedish_­CI_­AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[natl_regs] ADD CONSTRAINT [PK_natl_regs_id] PRIMARY KEY CLUSTERED ([natl_regs_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[natl_regs] ADD CONSTRAINT [FK_natl_regs_orgs_id] FOREIGN KEY ([orgs_id]) REFERENCES [dbo].[orgs] ([orgs_id])
GO

CREATE TABLE [dbo].[ofcs]
(
[ofcs_id] [int] NOT NULL IDENTITY(1, 1),
[orgs_id] [int] NULL,
[ofc_name] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL,
[ofc_org_name] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL,
[ofc_street_addr] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL,
[ofc_postl_addr] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[ofc_postl_code] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[ofc_postl_city] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[ofc_postl_c] [nvarchar] (10) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[ofc_mail_addr] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[ofc_phone_nr] [nvarchar] (50) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[ofc_contct_pers] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[ofc_inv_addr] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[ofc_inv_postl_code] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[ofc_inv_city] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[ofc_inv_c] [nvarchar] (10) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[ofc_cost_cntr] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[ofc_tkn_mfr_ref] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[ofc_obj_hash] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[ofc_adnl_info] [nvarchar] (max) COLLATE Finnish_­Swedish_­CI_­AS NULL
) ON [PRIMARY] TEXTIMAGE_­ON [PRIMARY]
GO
ALTER TABLE [dbo].[ofcs] ADD CONSTRAINT [PK_ofcs_id] PRIMARY KEY CLUSTERED ([ofcs_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ofcs] ADD CONSTRAINT [FK_ofcs_orgs_id] FOREIGN KEY ([orgs_id]) REFERENCES [dbo].[orgs] ([orgs_id])
GO

CREATE TABLE [dbo].[org_crts]
(
[org_crts_id] [int] NOT NULL IDENTITY(1, 1),
[orgs_id] [int] NULL,
[org_crt_type] [int] NOT NULL,
[org_crt_hash] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL,
[org_crt_value] [nvarchar] (max) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL,
[org_crt_adnl_info] [nvarchar] (max) COLLATE Finnish_­Swedish_­CI_­AS NULL
) ON [PRIMARY] TEXTIMAGE_­ON [PRIMARY]
GO
ALTER TABLE [dbo].[org_crts] ADD CONSTRAINT [PK_org_crts_id] PRIMARY KEY CLUSTERED ([org_crts_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[org_crts] ADD CONSTRAINT [FK_org_crts_orgs_id] FOREIGN KEY ([orgs_id]) REFERENCES [dbo].[orgs] ([orgs_id])
GO

CREATE TABLE [dbo].[org_ofc_addrs]
(
[org_ofc_addrs_id] [int] NOT NULL IDENTITY(1, 1),
[org_ofcs_id] [int] NULL,
[org_ofc_addr] [nvarchar] (300) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[org_ofc_zip] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[org_ofc_city] [nvarchar] (300) COLLATE Finnish_­Swedish_­CI_­AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[org_ofc_addrs] ADD CONSTRAINT [PK_org_ofc_addrs_id] PRIMARY KEY CLUSTERED ([org_ofc_addrs_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[org_ofc_addrs] ADD CONSTRAINT [FK_org_ofc_addrs_org_ofcs_id] FOREIGN KEY ([org_ofcs_id]) REFERENCES [dbo].[org_ofcs] ([org_ofcs_id])
GO

CREATE TABLE [dbo].[org_ofcs]
(
[org_ofcs_id] [int] NOT NULL IDENTITY(1, 1),
[orgs_id] [int] NULL,
[org_ofc_name] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[org_ofc_adnl_info] [nvarchar] (max) COLLATE Finnish_­Swedish_­CI_­AS NULL
) ON [PRIMARY] TEXTIMAGE_­ON [PRIMARY]
GO
ALTER TABLE [dbo].[org_ofcs] ADD CONSTRAINT [PK_org_ofcs_id] PRIMARY KEY CLUSTERED ([org_ofcs_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[org_ofcs] ADD CONSTRAINT [FK_org_ofcs_orgs_id] FOREIGN KEY ([orgs_id]) REFERENCES [dbo].[orgs] ([orgs_id])
GO

CREATE TABLE [dbo].[orgs]
(
[orgs_id] [int] NOT NULL IDENTITY(1, 1),
[org_name] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[org_domain_suffix] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[org_nr] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[org_domain_suffix_whitelist] [nvarchar] (500) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[org_permissions] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[org_mediation_task_addr] [nvarchar] (300) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[org_mediation_task_zip] [nvarchar] (50) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[org_mediation_task_city] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[org_owner] [bit] NOT NULL CONSTRAINT [DF_orgs_org_owner] DEFAULT ((0)),
[org_sa_mail] [nvarchar] (500) COLLATE Finnish_­Swedish_­CI_­AS NULL CONSTRAINT [DF_orgs_org_sa_mail] DEFAULT (''),
[org_sign_crt_ku] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL CONSTRAINT [DF_orgs_org_sign_crt_ku] DEFAULT (''),
[org_crt_type] [int] NULL,
[org_crt_hash] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[org_crt_bin] [varbinary] (max) NULL,
[org_uniq_crt_src] [int] NOT NULL CONSTRAINT [DF_orgs_org_uniq_crt_src] DEFAULT ((1)),
[org_adnl_info] [nvarchar] (max) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[org_adnl_data] [nvarchar] (max) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[org_adnl_task_info] [nvarchar] (max) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[org_l] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[org_c] [nvarchar] (10) COLLATE Finnish_­Swedish_­CI_­AS NULL
) ON [PRIMARY] TEXTIMAGE_­ON [PRIMARY]
GO
ALTER TABLE [dbo].[orgs] ADD CONSTRAINT [PK_orgs_id] PRIMARY KEY CLUSTERED ([orgs_id]) ON [PRIMARY]
GO

CREATE TABLE [dbo].[otps]
(
[orgs_id] [int] NULL,
[otp_obj_type] [int] NOT NULL,
[otp_obj_ref] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL,
[otp_valid_to] [datetime] NOT NULL,
[otp_value] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL,
[otp_attempts] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[otps] ADD CONSTRAINT [FK_otps_orgs_id] FOREIGN KEY ([orgs_id]) REFERENCES [dbo].[orgs] ([orgs_id])
GO

CREATE TABLE [dbo].[privileges]
(
[privilege_id] [int] NOT NULL,
[privilege_name] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NOT NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[role_privilege_relns]
(
[roles_id] [int] NULL,
[privilege] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[role_privilege_relns] ADD CONSTRAINT [FK_role_privilege_relns_roles_id] FOREIGN KEY ([roles_id]) REFERENCES [dbo].[roles] ([roles_id])
GO

CREATE TABLE [dbo].[role_usr_grp_relns]
(
[roles_id] [int] NULL,
[usr_grps_id] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[role_usr_grp_relns] ADD CONSTRAINT [FK_role_usr_grp_relns_roles_id] FOREIGN KEY ([roles_id]) REFERENCES [dbo].[roles] ([roles_id])
GO
ALTER TABLE [dbo].[role_usr_grp_relns] ADD CONSTRAINT [FK_role_usr_grp_relns_usr_grps_id] FOREIGN KEY ([usr_grps_id]) REFERENCES [dbo].[usr_grps] ([usr_grps_id])
GO