CREATE TABLE [dbo].[usr_users_options]
(
[usro_user_code] [dbo].[ais_code_medium] NOT NULL,
[usro_rowver] [timestamp] NOT NULL,
[usro_opt_mnu_dbl_click] [bit] NOT NULL CONSTRAINT [DF__usr_users_options__usro_opt_mnu_dbl_click] DEFAULT ((0)),
[usro_opt_find_show_det] [bit] NOT NULL CONSTRAINT [DF__usr_users_options__usro_opt_find_show_det] DEFAULT ((0)),
[usro_do_not_show_combo_code] [bit] NOT NULL CONSTRAINT [DF__usr_users_options__usro_do_not_show_combo_code] DEFAULT ((0))
) ON [PRIMARY]
ALTER TABLE [dbo].[usr_users_options] ADD
CONSTRAINT [FK_usr_users_options_usr_users] FOREIGN KEY ([usro_user_code]) REFERENCES [dbo].[usr_users] ([usr_user_code]) ON DELETE CASCADE ON UPDATE CASCADE

GO
ALTER TABLE [dbo].[usr_users_options] ADD CONSTRAINT [PK_usr_users_options] PRIMARY KEY CLUSTERED  ([usro_user_code]) ON [PRIMARY]
GO
