CREATE TABLE [dbo].[Tab_utenti](
  [Id] [int] NOT NULL,
  [Utente] [varchar](30) NULL,
  [Conchilavoro] [varchar](30) NULL,
  [Specializzazione] [varchar](30) NULL,
  [Idcategoria] [smallint] NULL,
  [Idregione] [tinyint] NULL,
  [Idprovincia] [tinyint] NULL,
  [Idcomune] [smallint] NULL,
  [Indirizzo] [varchar](50) NULL,
  [Cap] [varchar](5) NULL,
  [Datanascita] [smalldatetime] NULL,
  [Telefono] [varchar](15) NULL,
  [Fax] [varchar](15) NULL,
  [Cellulare] [varchar](15) NULL,
  [Email] [varchar](50) NULL,
  [Website] [varchar](50) NULL,
  [Piva] [varchar](11) NULL,
  [Codfiscale] [varchar](16) NULL,
  [Note] [varchar](500) NULL,
  [Facebook] [varchar](100) NULL,
  [Twitter] [varchar](100) NULL,
  [Skype] [varchar](30) NULL,
  [Google] [varchar](30) NULL,
  [Linkedin] [varchar](50) NULL,
  [Messenger] [varchar](30) NULL,
  [Imageprofile] [varchar](50) NULL,
  [Imagecard] [varchar](50) NULL,
  [Username] [varchar](20) NULL,
  [Password] [varchar](20) NULL,
  [Referente] [varchar](30) NULL,
  [AccettazioneInformativa] [bit] NULL,
  [DescrizioneInformativa] [varchar](max) NULL,
 CONSTRAINT [Chiaveprimaria] PRIMARY KEY CLUSTERED 
(
  [Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[Tab_utenti] ADD  CONSTRAINT [DF_Tab_utenti_Idcategoria]  DEFAULT ((0)) FOR [Idcategoria]
GO

ALTER TABLE [dbo].[Tab_utenti] ADD  CONSTRAINT [DF_Tab_utenti_Idregione]  DEFAULT ((0)) FOR [Idregione]
GO

ALTER TABLE [dbo].[Tab_utenti] ADD  CONSTRAINT [DF_Tab_utenti_Idprovincia]  DEFAULT ((0)) FOR [Idprovincia]
GO

ALTER TABLE [dbo].[Tab_utenti] ADD  CONSTRAINT [DF_Tab_utenti_Idcomune]  DEFAULT ((0)) FOR [Idcomune]
GO

ALTER TABLE [dbo].[Tab_utenti] ADD  CONSTRAINT [DF_Tab_utenti_Datanascita]  DEFAULT ('01-01-1900') FOR [Datanascita]
GO

CREATE TABLE [dbo].[Tab_comuni](
  [Id] [smallint] NOT NULL,
  [Idprovincia] [tinyint] NULL,
  [Idregione] [tinyint] NULL,
  [Descrizione] [nvarchar](30) NULL,
 CONSTRAINT [PK_Tab_comuni] PRIMARY KEY CLUSTERED 
(
  [Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

CREATE TABLE [dbo].[Tab_categorie](
  [id] [smallint] NOT NULL,
  [descrizione] [varchar](20) NULL,
 CONSTRAINT [PK_Tab_categorie] PRIMARY KEY CLUSTERED 
(
  [id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO