1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66
|
USE [sugarcrm_db]
GO
/****** Object: Table [dbo].[contacts] Script Date: 04/20/2011 09:11:25 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING OFF
GO
CREATE TABLE [dbo].[contacts](
[id] [varchar](36) NOT NULL,
[date_entered] [datetime] NULL,
[date_modified] [datetime] NULL,
[modified_user_id] [varchar](36) NULL,
[created_by] [varchar](36) NULL,
[description] [text] NULL,
[deleted] [bit] NULL,
[assigned_user_id] [varchar](36) NULL,
[salutation] [varchar](255) NULL,
[first_name] [varchar](100) NULL,
[last_name] [varchar](100) NULL,
[title] [varchar](100) NULL,
[department] [varchar](255) NULL,
[do_not_call] [bit] NULL,
[phone_home] [varchar](100) NULL,
[phone_mobile] [varchar](100) NULL,
[phone_work] [varchar](100) NULL,
[phone_other] [varchar](100) NULL,
[phone_fax] [varchar](100) NULL,
[primary_address_street] [varchar](150) NULL,
[primary_address_city] [varchar](100) NULL,
[primary_address_state] [varchar](100) NULL,
[primary_address_postalcode] [varchar](20) NULL,
[primary_address_country] [varchar](255) NULL,
[alt_address_street] [varchar](150) NULL,
[alt_address_city] [varchar](100) NULL,
[alt_address_state] [varchar](100) NULL,
[alt_address_postalcode] [varchar](20) NULL,
[alt_address_country] [varchar](255) NULL,
[assistant] [varchar](75) NULL,
[assistant_phone] [varchar](100) NULL,
[lead_source] [varchar](255) NULL,
[reports_to_id] [varchar](36) NULL,
[birthdate] [datetime] NULL,
[campaign_id] [varchar](36) NULL,
CONSTRAINT [pk_contacts] 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] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[contacts] ADD DEFAULT ('0') FOR [deleted]
GO
ALTER TABLE [dbo].[contacts] ADD DEFAULT ('0') FOR [do_not_call]
GO |
Partager