API tools faq
paste
Advertisement
_fops

createdb

_fops
Dec 3rd, 2013
72
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 37.60 KB | None | 0 0
raw download clone embed print report
  1. USE [master]
  2. GO
  3. /****** Object:  Database [ProvSys]    Script Date: 12/03/2013 00:22:05 ******/
  4. CREATE DATABASE [ProvSys] ON  PRIMARY
  5. ( NAME = N'ProvSys', FILENAME = N'c:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\ProvSys.mdf' , SIZE = 5120KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
  6.  LOG ON
  7. ( NAME = N'ProvSys_log', FILENAME = N'c:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\ProvSys_log.ldf' , SIZE = 2304KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
  8. GO
  9. ALTER DATABASE [ProvSys] SET COMPATIBILITY_LEVEL = 100
  10. GO
  11. IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
  12. begin
  13. EXEC [ProvSys].[dbo].[sp_fulltext_database] @action = 'enable'
  14. end
  15. GO
  16. ALTER DATABASE [ProvSys] SET ANSI_NULL_DEFAULT OFF
  17. GO
  18. ALTER DATABASE [ProvSys] SET ANSI_NULLS OFF
  19. GO
  20. ALTER DATABASE [ProvSys] SET ANSI_PADDING OFF
  21. GO
  22. ALTER DATABASE [ProvSys] SET ANSI_WARNINGS OFF
  23. GO
  24. ALTER DATABASE [ProvSys] SET ARITHABORT OFF
  25. GO
  26. ALTER DATABASE [ProvSys] SET AUTO_CLOSE OFF
  27. GO
  28. ALTER DATABASE [ProvSys] SET AUTO_CREATE_STATISTICS ON
  29. GO
  30. ALTER DATABASE [ProvSys] SET AUTO_SHRINK OFF
  31. GO
  32. ALTER DATABASE [ProvSys] SET AUTO_UPDATE_STATISTICS ON
  33. GO
  34. ALTER DATABASE [ProvSys] SET CURSOR_CLOSE_ON_COMMIT OFF
  35. GO
  36. ALTER DATABASE [ProvSys] SET CURSOR_DEFAULT  GLOBAL
  37. GO
  38. ALTER DATABASE [ProvSys] SET CONCAT_NULL_YIELDS_NULL OFF
  39. GO
  40. ALTER DATABASE [ProvSys] SET NUMERIC_ROUNDABORT OFF
  41. GO
  42. ALTER DATABASE [ProvSys] SET QUOTED_IDENTIFIER OFF
  43. GO
  44. ALTER DATABASE [ProvSys] SET RECURSIVE_TRIGGERS OFF
  45. GO
  46. ALTER DATABASE [ProvSys] SET  DISABLE_BROKER
  47. GO
  48. ALTER DATABASE [ProvSys] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
  49. GO
  50. ALTER DATABASE [ProvSys] SET DATE_CORRELATION_OPTIMIZATION OFF
  51. GO
  52. ALTER DATABASE [ProvSys] SET TRUSTWORTHY OFF
  53. GO
  54. ALTER DATABASE [ProvSys] SET ALLOW_SNAPSHOT_ISOLATION OFF
  55. GO
  56. ALTER DATABASE [ProvSys] SET PARAMETERIZATION SIMPLE
  57. GO
  58. ALTER DATABASE [ProvSys] SET READ_COMMITTED_SNAPSHOT OFF
  59. GO
  60. ALTER DATABASE [ProvSys] SET HONOR_BROKER_PRIORITY OFF
  61. GO
  62. ALTER DATABASE [ProvSys] SET  READ_WRITE
  63. GO
  64. ALTER DATABASE [ProvSys] SET RECOVERY SIMPLE
  65. GO
  66. ALTER DATABASE [ProvSys] SET  MULTI_USER
  67. GO
  68. ALTER DATABASE [ProvSys] SET PAGE_VERIFY CHECKSUM
  69. GO
  70. ALTER DATABASE [ProvSys] SET DB_CHAINING OFF
  71. GO
  72. USE [ProvSys]
  73. GO
  74. /****** Object:  Table [dbo].[webpages_Roles]    Script Date: 12/03/2013 00:22:06 ******/
  75. SET ANSI_NULLS ON
  76. GO
  77. SET QUOTED_IDENTIFIER ON
  78. GO
  79. CREATE TABLE [dbo].[webpages_Roles](
  80.     [RoleId] [int] IDENTITY(1,1) NOT NULL,
  81.     [RoleName] [nvarchar](256) NOT NULL,
  82. PRIMARY KEY CLUSTERED
  83. (
  84.     [RoleId] ASC
  85. )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],
  86. UNIQUE NONCLUSTERED
  87. (
  88.     [RoleName] ASC
  89. )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  90. ) ON [PRIMARY]
  91. GO
  92. /****** Object:  Table [dbo].[webpages_OAuthMembership]    Script Date: 12/03/2013 00:22:06 ******/
  93. SET ANSI_NULLS ON
  94. GO
  95. SET QUOTED_IDENTIFIER ON
  96. GO
  97. CREATE TABLE [dbo].[webpages_OAuthMembership](
  98.     [Provider] [nvarchar](30) NOT NULL,
  99.     [ProviderUserId] [nvarchar](100) NOT NULL,
  100.     [UserId] [int] NOT NULL,
  101. PRIMARY KEY CLUSTERED
  102. (
  103.     [Provider] ASC,
  104.     [ProviderUserId] ASC
  105. )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  106. ) ON [PRIMARY]
  107. GO
  108. /****** Object:  Table [dbo].[webpages_Membership]    Script Date: 12/03/2013 00:22:06 ******/
  109. SET ANSI_NULLS ON
  110. GO
  111. SET QUOTED_IDENTIFIER ON
  112. GO
  113. CREATE TABLE [dbo].[webpages_Membership](
  114.     [UserId] [int] NOT NULL,
  115.     [CreateDate] [datetime] NULL,
  116.     [ConfirmationToken] [nvarchar](128) NULL,
  117.     [IsConfirmed] [bit] NULL,
  118.     [LastPasswordFailureDate] [datetime] NULL,
  119.     [PasswordFailuresSinceLastSuccess] [int] NOT NULL,
  120.     [Password] [nvarchar](128) NOT NULL,
  121.     [PasswordChangedDate] [datetime] NULL,
  122.     [PasswordSalt] [nvarchar](128) NOT NULL,
  123.     [PasswordVerificationToken] [nvarchar](128) NULL,
  124.     [PasswordVerificationTokenExpirationDate] [datetime] NULL,
  125. PRIMARY KEY CLUSTERED
  126. (
  127.     [UserId] ASC
  128. )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  129. ) ON [PRIMARY]
  130. GO
  131. /****** Object:  Table [dbo].[tblVehicleTypes]    Script Date: 12/03/2013 00:22:06 ******/
  132. SET ANSI_NULLS ON
  133. GO
  134. SET QUOTED_IDENTIFIER ON
  135. GO
  136. CREATE TABLE [dbo].[tblVehicleTypes](
  137.     [IDVehicleType] [int] IDENTITY(1,1) NOT NULL,
  138.     [Type] [nvarchar](50) NOT NULL,
  139.  CONSTRAINT [PK_tblVehiclyTypes] PRIMARY KEY CLUSTERED
  140. (
  141.     [IDVehicleType] ASC
  142. )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  143. ) ON [PRIMARY]
  144. GO
  145. /****** Object:  Table [dbo].[tblVehicleModels]    Script Date: 12/03/2013 00:22:06 ******/
  146. SET ANSI_NULLS ON
  147. GO
  148. SET QUOTED_IDENTIFIER ON
  149. GO
  150. CREATE TABLE [dbo].[tblVehicleModels](
  151.     [IDVehicleModel] [int] IDENTITY(1,1) NOT NULL,
  152.     [Category] [nvarchar](50) NOT NULL,
  153.     [Brand] [nvarchar](50) NOT NULL,
  154.  CONSTRAINT [PK_tblVehicleTypes] PRIMARY KEY CLUSTERED
  155. (
  156.     [IDVehicleModel] ASC
  157. )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  158. ) ON [PRIMARY]
  159. GO
  160. /****** Object:  Table [dbo].[tblCampaignTypes]    Script Date: 12/03/2013 00:22:06 ******/
  161. SET ANSI_NULLS ON
  162. GO
  163. SET QUOTED_IDENTIFIER ON
  164. GO
  165. CREATE TABLE [dbo].[tblCampaignTypes](
  166.     [IDCampaignType] [int] IDENTITY(1,1) NOT NULL,
  167.     [CampaignType] [nvarchar](50) NOT NULL,
  168.  CONSTRAINT [PK_tblCampainTypes] PRIMARY KEY CLUSTERED
  169. (
  170.     [IDCampaignType] ASC
  171. )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  172. ) ON [PRIMARY]
  173. GO
  174. /****** Object:  Table [dbo].[tblSalesChannels]    Script Date: 12/03/2013 00:22:06 ******/
  175. SET ANSI_NULLS ON
  176. GO
  177. SET QUOTED_IDENTIFIER ON
  178. GO
  179. CREATE TABLE [dbo].[tblSalesChannels](
  180.     [IDSalesChannel] [int] IDENTITY(1,1) NOT NULL,
  181.     [SalesChannel] [nvarchar](50) NOT NULL,
  182.  CONSTRAINT [PK_tblSalesChannels] PRIMARY KEY CLUSTERED
  183. (
  184.     [IDSalesChannel] ASC
  185. )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  186. ) ON [PRIMARY]
  187. GO
  188. /****** Object:  Table [dbo].[tblImporterDiscounts]    Script Date: 12/03/2013 00:22:06 ******/
  189. SET ANSI_NULLS ON
  190. GO
  191. SET QUOTED_IDENTIFIER ON
  192. GO
  193. CREATE TABLE [dbo].[tblImporterDiscounts](
  194.     [IDImporterDiscount] [int] IDENTITY(1,1) NOT NULL,
  195.     [IsSpecialDiscount] [bit] NOT NULL,
  196.     [ImporterDiscount] [nvarchar](50) NOT NULL,
  197.  CONSTRAINT [PK_tblImporterDiscounts] PRIMARY KEY CLUSTERED
  198. (
  199.     [IDImporterDiscount] ASC
  200. )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  201. ) ON [PRIMARY]
  202. GO
  203. /****** Object:  Table [dbo].[tblEmployees]    Script Date: 12/03/2013 00:22:06 ******/
  204. SET ANSI_NULLS ON
  205. GO
  206. SET QUOTED_IDENTIFIER ON
  207. GO
  208. CREATE TABLE [dbo].[tblEmployees](
  209.     [IDEmployee] [int] IDENTITY(1,1) NOT NULL,
  210.     [IDEmpNoCompany] [nvarchar](50) NOT NULL,
  211.     [FirstName] [nvarchar](50) NULL,
  212.     [LastName] [nvarchar](50) NULL,
  213.     [ResetPassword] [nvarchar](50) NULL,
  214.     [Role] [nvarchar](50) NOT NULL,
  215.     [CalculationMethod] [nvarchar](2) NOT NULL,
  216.  CONSTRAINT [PK_tblEmployees] PRIMARY KEY CLUSTERED
  217. (
  218.     [IDEmployee] ASC
  219. )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],
  220.  CONSTRAINT [IX_tblEmployees] UNIQUE NONCLUSTERED
  221. (
  222.     [IDEmpNoCompany] ASC
  223. )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  224. ) ON [PRIMARY]
  225. GO
  226. /****** Object:  Table [dbo].[tblDiscountTypes]    Script Date: 12/03/2013 00:22:06 ******/
  227. SET ANSI_NULLS ON
  228. GO
  229. SET QUOTED_IDENTIFIER ON
  230. GO
  231. SET ANSI_PADDING ON
  232. GO
  233. CREATE TABLE [dbo].[tblDiscountTypes](
  234.     [IDDiscountType] [int] IDENTITY(1,1) NOT NULL,
  235.     [DiscountType] [varchar](50) NOT NULL,
  236.  CONSTRAINT [PK_tblDiscountTypes] PRIMARY KEY CLUSTERED
  237. (
  238.     [IDDiscountType] ASC
  239. )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  240. ) ON [PRIMARY]
  241. GO
  242. SET ANSI_PADDING OFF
  243. GO
  244. /****** Object:  Table [dbo].[tblCustomerTypes]    Script Date: 12/03/2013 00:22:06 ******/
  245. SET ANSI_NULLS ON
  246. GO
  247. SET QUOTED_IDENTIFIER ON
  248. GO
  249. SET ANSI_PADDING ON
  250. GO
  251. CREATE TABLE [dbo].[tblCustomerTypes](
  252.     [IDCustomerType] [int] IDENTITY(1,1) NOT NULL,
  253.     [CustomerType] [varchar](50) NOT NULL,
  254.     [FixProvision] [decimal](19, 6) NOT NULL,
  255.  CONSTRAINT [PK_tblCustomerTypes] PRIMARY KEY CLUSTERED
  256. (
  257.     [IDCustomerType] ASC
  258. )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  259. ) ON [PRIMARY]
  260. GO
  261. SET ANSI_PADDING OFF
  262. GO
  263. /****** Object:  Table [dbo].[tblConditions]    Script Date: 12/03/2013 00:22:06 ******/
  264. SET ANSI_NULLS ON
  265. GO
  266. SET QUOTED_IDENTIFIER ON
  267. GO
  268. CREATE TABLE [dbo].[tblConditions](
  269.     [IDCondition] [int] IDENTITY(1,1) NOT NULL,
  270.     [IDEmployee] [int] NOT NULL,
  271.     [Value1] [decimal](19, 6) NULL,
  272.     [Value2] [decimal](19, 6) NULL,
  273.     [Value3] [decimal](19, 6) NULL,
  274.     [Value4] [decimal](19, 6) NULL,
  275.     [Value5] [decimal](19, 6) NULL,
  276.     [Value6] [decimal](19, 6) NULL,
  277.     [FromYear] [int] NOT NULL,
  278.  CONSTRAINT [PK_tblConditions] PRIMARY KEY CLUSTERED
  279. (
  280.     [IDCondition] ASC
  281. )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  282. ) ON [PRIMARY]
  283. GO
  284. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A: Minimum Neuwagen, M:Umsatzmultiplikator BO' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblConditions', @level2type=N'COLUMN',@level2name=N'Value1'
  285. GO
  286. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A: Minimum Occasion, M:Max. ZEG' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblConditions', @level2type=N'COLUMN',@level2name=N'Value2'
  287. GO
  288. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'M:Max. Provision' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblConditions', @level2type=N'COLUMN',@level2name=N'Value3'
  289. GO
  290. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'M:Bonusbasis' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblConditions', @level2type=N'COLUMN',@level2name=N'Value4'
  291. GO
  292. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'M:Exponent' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblConditions', @level2type=N'COLUMN',@level2name=N'Value5'
  293. GO
  294. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'M:NullVersatz' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblConditions', @level2type=N'COLUMN',@level2name=N'Value6'
  295. GO
  296. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblConditions'
  297. GO
  298. /****** Object:  Table [dbo].[tblCompensations]    Script Date: 12/03/2013 00:22:06 ******/
  299. SET ANSI_NULLS ON
  300. GO
  301. SET QUOTED_IDENTIFIER ON
  302. GO
  303. CREATE TABLE [dbo].[tblCompensations](
  304.     [IDCompensation] [int] IDENTITY(1,1) NOT NULL,
  305.     [IDEmployee] [int] NOT NULL,
  306.     [Month] [int] NOT NULL,
  307.     [Year] [int] NOT NULL,
  308.     [NrOfDaysHoliday] [int] NOT NULL,
  309.     [NrOfDaysIlness] [int] NOT NULL,
  310.  CONSTRAINT [PK_tblCompensations] PRIMARY KEY CLUSTERED
  311. (
  312.     [IDCompensation] ASC
  313. )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  314. ) ON [PRIMARY]
  315. GO
  316. /****** Object:  Table [dbo].[webpages_UsersInRoles]    Script Date: 12/03/2013 00:22:06 ******/
  317. SET ANSI_NULLS ON
  318. GO
  319. SET QUOTED_IDENTIFIER ON
  320. GO
  321. CREATE TABLE [dbo].[webpages_UsersInRoles](
  322.     [UserId] [int] NOT NULL,
  323.     [RoleId] [int] NOT NULL,
  324. PRIMARY KEY CLUSTERED
  325. (
  326.     [UserId] ASC,
  327.     [RoleId] ASC
  328. )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  329. ) ON [PRIMARY]
  330. GO
  331. /****** Object:  Table [dbo].[tblTargets]    Script Date: 12/03/2013 00:22:06 ******/
  332. SET ANSI_NULLS ON
  333. GO
  334. SET QUOTED_IDENTIFIER ON
  335. GO
  336. CREATE TABLE [dbo].[tblTargets](
  337.     [IDTarget] [int] IDENTITY(1,1) NOT NULL,
  338.     [IDEmployee] [int] NOT NULL,
  339.     [Month] [int] NOT NULL,
  340.     [Year] [int] NOT NULL,
  341.     [QuantityNewVehicles] [decimal](19, 6) NULL,
  342.     [QuantityUsedVehicles] [decimal](19, 6) NULL,
  343.     [Revenue] [decimal](19, 6) NULL,
  344.  CONSTRAINT [PK_tblTargets] PRIMARY KEY CLUSTERED
  345. (
  346.     [IDTarget] ASC
  347. )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  348. ) ON [PRIMARY]
  349. GO
  350. /****** Object:  Table [dbo].[tblSpecialBonuses]    Script Date: 12/03/2013 00:22:06 ******/
  351. SET ANSI_NULLS ON
  352. GO
  353. SET QUOTED_IDENTIFIER ON
  354. GO
  355. CREATE TABLE [dbo].[tblSpecialBonuses](
  356.     [IDSpecialBonus] [int] IDENTITY(1,1) NOT NULL,
  357.     [IDEmployee] [int] NOT NULL,
  358.     [SpecialBonusValue] [decimal](19, 6) NOT NULL,
  359.     [SpecialBonusDescription] [nvarchar](50) NOT NULL,
  360.     [Month] [int] NOT NULL,
  361.     [Year] [int] NOT NULL,
  362.  CONSTRAINT [PK_tblSpecialBonuses] PRIMARY KEY CLUSTERED
  363. (
  364.     [IDSpecialBonus] ASC
  365. )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  366. ) ON [PRIMARY]
  367. GO
  368. /****** Object:  Table [dbo].[tblSalarySettings]    Script Date: 12/03/2013 00:22:06 ******/
  369. SET ANSI_NULLS ON
  370. GO
  371. SET QUOTED_IDENTIFIER ON
  372. GO
  373. CREATE TABLE [dbo].[tblSalarySettings](
  374.     [IDSalarySetting] [int] IDENTITY(1,1) NOT NULL,
  375.     [FromMonth] [int] NOT NULL,
  376.     [FromYear] [int] NOT NULL,
  377.     [IDEmployee] [int] NOT NULL,
  378.     [BaseSalary] [decimal](19, 6) NOT NULL,
  379.     [MinimumSalary] [decimal](19, 6) NOT NULL,
  380.     [CompensationValue] [decimal](19, 6) NOT NULL,
  381.  CONSTRAINT [PK_tblSalarySettings] PRIMARY KEY CLUSTERED
  382. (
  383.     [IDSalarySetting] ASC
  384. )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  385. ) ON [PRIMARY]
  386. GO
  387. /****** Object:  Table [dbo].[tblBonuses]    Script Date: 12/03/2013 00:22:06 ******/
  388. SET ANSI_NULLS ON
  389. GO
  390. SET QUOTED_IDENTIFIER ON
  391. GO
  392. CREATE TABLE [dbo].[tblBonuses](
  393.     [IDBonus] [int] IDENTITY(1,1) NOT NULL,
  394.     [BonusValue] [decimal](19, 6) NOT NULL,
  395.     [BonusDescription] [nvarchar](50) NOT NULL,
  396.     [IDEmployee] [int] NOT NULL,
  397.     [Month] [int] NOT NULL,
  398.     [Year] [int] NOT NULL,
  399.  CONSTRAINT [PK_tblBonuses] PRIMARY KEY CLUSTERED
  400. (
  401.     [IDBonus] ASC
  402. )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  403. ) ON [PRIMARY]
  404. GO
  405. /****** Object:  Table [dbo].[tblTransactions]    Script Date: 12/03/2013 00:22:06 ******/
  406. SET ANSI_NULLS ON
  407. GO
  408. SET QUOTED_IDENTIFIER ON
  409. GO
  410. CREATE TABLE [dbo].[tblTransactions](
  411.     [IDTransaction] [int] IDENTITY(1,1) NOT NULL,
  412.     [IDEmployee] [int] NOT NULL,
  413.     [CustomerFirstName] [nvarchar](50) NULL,
  414.     [CustomerLastName] [nvarchar](50) NULL,
  415.     [IDCustomerType] [int] NOT NULL,
  416.     [IDVehicleType] [int] NOT NULL,
  417.     [IDVehicleModel] [int] NOT NULL,
  418.     [VehicleFreeText] [nvarchar](50) NULL,
  419.     [IDSalesChannel] [int] NOT NULL,
  420.     [ChassisNumber] [nvarchar](50) NULL,
  421.     [OrderNumber] [nvarchar](50) NULL,
  422.     [ContractDate] [date] NOT NULL,
  423.     [DeliveryDate] [date] NULL,
  424.     [PaymentDate] [date] NULL,
  425.     [ExCustomer] [nvarchar](50) NULL,
  426.     [Comments] [nvarchar](50) NULL,
  427.     [EuroplusNumber] [nvarchar](50) NULL,
  428.     [Financing] [nvarchar](50) NULL,
  429.     [PriceModel] [nvarchar](2) NULL,
  430.     [ListPrice] [decimal](19, 6) NOT NULL,
  431.     [Extras] [decimal](19, 6) NULL,
  432.     [OtherExtras] [decimal](19, 6) NULL,
  433.     [OtherExtrasDescription] [nvarchar](250) NULL,
  434.     [DeliveryFixPrice] [decimal](19, 6) NULL,
  435.     [Discount] [decimal](19, 6) NULL,
  436.     [IDDiscountType] [int] NOT NULL,
  437.     [FreeExtras] [decimal](19, 6) NULL,
  438.     [FreeExtrasDescription] [nvarchar](50) NULL,
  439.     [ExchangedVehicleType] [nvarchar](50) NULL,
  440.     [ExchangedChassisNumber] [nvarchar](50) NULL,
  441.     [ExchangedVehiclePrice] [decimal](19, 6) NULL,
  442.     [ExchangedVehicleSalesPrice] [decimal](19, 6) NULL,
  443.     [IDParticipator] [int] NULL,
  444.     [TypeOfParticipation] [nvarchar](2) NULL,
  445.     [AffectsProvision] [bit] NULL,
  446.     [AffectsQuantity] [bit] NULL,
  447.     [DocumentsReceived] [bit] NULL,
  448.     [C_ImportDiscountTotal] [decimal](19, 6) NULL,
  449.     [ProvisionChecked] [bit] NULL,
  450.     [C_ImportSpecialDiscountTotal] [decimal](19, 6) NULL,
  451.     [C_CompletePrice] [decimal](19, 6) NULL,
  452.     [C_EstimateExceeded] [decimal](19, 6) NULL,
  453.     [C_TotalDiscountValue] [decimal](19, 6) NULL,
  454.     [C_GrossPrice] [decimal](19, 6) NULL,
  455.     [C_TotalDiscountPercent] [decimal](19, 6) NULL,
  456.     [M_TurnoverCorrectionFactor] [decimal](19, 6) NULL,
  457.     [M_ProvisionRelevantTurnoverVehicle] [decimal](19, 6) NULL,
  458.     [M_TotalTurnoverExtras] [decimal](19, 6) NULL,
  459.     [M_TotalDiscountExtrasPercent] [decimal](19, 6) NULL,
  460.     [M_TurnoverMultiplicator] [decimal](19, 6) NULL,
  461.     [M_ProvisionRelevantTurnoverExtras] [decimal](19, 6) NULL,
  462.     [M_ProvisionRelevantTurnoverTotal] [decimal](19, 6) NULL,
  463.     [A_ProvisionParticipation] [decimal](19, 6) NULL,
  464.     [A_ProvisionFactor] [decimal](19, 6) NULL,
  465.     [A_ProvisionTurnover] [decimal](19, 6) NULL,
  466.     [A_ProvisionTotal] [decimal](19, 6) NULL,
  467.  CONSTRAINT [PK_tblTransaction] PRIMARY KEY CLUSTERED
  468. (
  469.     [IDTransaction] ASC
  470. )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  471. ) ON [PRIMARY]
  472. GO
  473. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Listenpreis' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblTransactions', @level2type=N'COLUMN',@level2name=N'ListPrice'
  474. GO
  475. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Sonderausstattung exkl. MwSt' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblTransactions', @level2type=N'COLUMN',@level2name=N'Extras'
  476. GO
  477. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'sonstiges Zubehör(UPE) exkl.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblTransactions', @level2type=N'COLUMN',@level2name=N'OtherExtras'
  478. GO
  479. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Kostenlose Zuganen' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblTransactions', @level2type=N'COLUMN',@level2name=N'FreeExtras'
  480. GO
  481. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblTransactions'
  482. GO
  483. /****** Object:  Table [dbo].[tblTransactionImporterDiscounts]    Script Date: 12/03/2013 00:22:06 ******/
  484. SET ANSI_NULLS ON
  485. GO
  486. SET QUOTED_IDENTIFIER ON
  487. GO
  488. CREATE TABLE [dbo].[tblTransactionImporterDiscounts](
  489.     [IDTransactionImporterDiscount] [int] IDENTITY(1,1) NOT NULL,
  490.     [IDImporterDiscount] [int] NOT NULL,
  491.     [IDCampaignType] [int] NOT NULL,
  492.     [CampaignText] [nvarchar](50) NULL,
  493.     [Discount] [decimal](19, 6) NULL,
  494.     [IDTransaction] [int] NOT NULL,
  495.     [ReceivedOn] [date] NULL,
  496.  CONSTRAINT [PK_tblTransactionImporterDiscounts] PRIMARY KEY CLUSTERED
  497. (
  498.     [IDTransactionImporterDiscount] ASC
  499. )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  500. ) ON [PRIMARY]
  501. GO
  502. /****** Object:  Default [DF__webpages___IsCon__5812160E]    Script Date: 12/03/2013 00:22:06 ******/
  503. ALTER TABLE [dbo].[webpages_Membership] ADD  DEFAULT ((0)) FOR [IsConfirmed]
  504. GO
  505. /****** Object:  Default [DF__webpages___Passw__59063A47]    Script Date: 12/03/2013 00:22:06 ******/
  506. ALTER TABLE [dbo].[webpages_Membership] ADD  DEFAULT ((0)) FOR [PasswordFailuresSinceLastSuccess]
  507. GO
  508. /****** Object:  Default [DF_tblImporterDiscounts_IsSpecialDiscount]    Script Date: 12/03/2013 00:22:06 ******/
  509. ALTER TABLE [dbo].[tblImporterDiscounts] ADD  CONSTRAINT [DF_tblImporterDiscounts_IsSpecialDiscount]  DEFAULT ((0)) FOR [IsSpecialDiscount]
  510. GO
  511. /****** Object:  Default [DF_tblEmployees_FirstName]    Script Date: 12/03/2013 00:22:06 ******/
  512. ALTER TABLE [dbo].[tblEmployees] ADD  CONSTRAINT [DF_tblEmployees_FirstName]  DEFAULT (N'admin:bitte komplettieren') FOR [FirstName]
  513. GO
  514. /****** Object:  Default [DF_tblEmployees_LastName]    Script Date: 12/03/2013 00:22:06 ******/
  515. ALTER TABLE [dbo].[tblEmployees] ADD  CONSTRAINT [DF_tblEmployees_LastName]  DEFAULT (N'admin:bitte komplettieren') FOR [LastName]
  516. GO
  517. /****** Object:  Default [DF_tblEmployees_ResetPassword]    Script Date: 12/03/2013 00:22:06 ******/
  518. ALTER TABLE [dbo].[tblEmployees] ADD  CONSTRAINT [DF_tblEmployees_ResetPassword]  DEFAULT ('') FOR [ResetPassword]
  519. GO
  520. /****** Object:  Default [DF_tblEmployees_Role]    Script Date: 12/03/2013 00:22:06 ******/
  521. ALTER TABLE [dbo].[tblEmployees] ADD  CONSTRAINT [DF_tblEmployees_Role]  DEFAULT (N'sales') FOR [Role]
  522. GO
  523. /****** Object:  Default [DF_tblEmployees_CalculationMethod]    Script Date: 12/03/2013 00:22:06 ******/
  524. ALTER TABLE [dbo].[tblEmployees] ADD  CONSTRAINT [DF_tblEmployees_CalculationMethod]  DEFAULT (N'A') FOR [CalculationMethod]
  525. GO
  526. /****** Object:  Default [DF_tblCustomerTypes_FixProvision]    Script Date: 12/03/2013 00:22:06 ******/
  527. ALTER TABLE [dbo].[tblCustomerTypes] ADD  CONSTRAINT [DF_tblCustomerTypes_FixProvision]  DEFAULT ((0)) FOR [FixProvision]
  528. GO
  529. /****** Object:  Default [DF_tblConditions_Value1]    Script Date: 12/03/2013 00:22:06 ******/
  530. ALTER TABLE [dbo].[tblConditions] ADD  CONSTRAINT [DF_tblConditions_Value1]  DEFAULT ((0)) FOR [Value1]
  531. GO
  532. /****** Object:  Default [DF_tblConditions_Value2]    Script Date: 12/03/2013 00:22:06 ******/
  533. ALTER TABLE [dbo].[tblConditions] ADD  CONSTRAINT [DF_tblConditions_Value2]  DEFAULT ((0)) FOR [Value2]
  534. GO
  535. /****** Object:  Default [DF_tblConditions_Value3]    Script Date: 12/03/2013 00:22:06 ******/
  536. ALTER TABLE [dbo].[tblConditions] ADD  CONSTRAINT [DF_tblConditions_Value3]  DEFAULT ((0)) FOR [Value3]
  537. GO
  538. /****** Object:  Default [DF_tblConditions_Value4]    Script Date: 12/03/2013 00:22:06 ******/
  539. ALTER TABLE [dbo].[tblConditions] ADD  CONSTRAINT [DF_tblConditions_Value4]  DEFAULT ((0)) FOR [Value4]
  540. GO
  541. /****** Object:  Default [DF_tblConditions_Value5]    Script Date: 12/03/2013 00:22:06 ******/
  542. ALTER TABLE [dbo].[tblConditions] ADD  CONSTRAINT [DF_tblConditions_Value5]  DEFAULT ((0)) FOR [Value5]
  543. GO
  544. /****** Object:  Default [DF_tblConditions_Value6]    Script Date: 12/03/2013 00:22:06 ******/
  545. ALTER TABLE [dbo].[tblConditions] ADD  CONSTRAINT [DF_tblConditions_Value6]  DEFAULT ((0)) FOR [Value6]
  546. GO
  547. /****** Object:  Default [DF_Table_1_Quantity]    Script Date: 12/03/2013 00:22:06 ******/
  548. ALTER TABLE [dbo].[tblTargets] ADD  CONSTRAINT [DF_Table_1_Quantity]  DEFAULT ((0)) FOR [QuantityNewVehicles]
  549. GO
  550. /****** Object:  Default [DF_Table_1_QuantityUsedCars]    Script Date: 12/03/2013 00:22:06 ******/
  551. ALTER TABLE [dbo].[tblTargets] ADD  CONSTRAINT [DF_Table_1_QuantityUsedCars]  DEFAULT ((0)) FOR [QuantityUsedVehicles]
  552. GO
  553. /****** Object:  Default [DF_tblTargets_Revenue]    Script Date: 12/03/2013 00:22:06 ******/
  554. ALTER TABLE [dbo].[tblTargets] ADD  CONSTRAINT [DF_tblTargets_Revenue]  DEFAULT ((0)) FOR [Revenue]
  555. GO
  556. /****** Object:  Default [DF_tblTransactions_ListPrice]    Script Date: 12/03/2013 00:22:06 ******/
  557. ALTER TABLE [dbo].[tblTransactions] ADD  CONSTRAINT [DF_tblTransactions_ListPrice]  DEFAULT ((0)) FOR [ListPrice]
  558. GO
  559. /****** Object:  Default [DF_tblTransactions_Extras]    Script Date: 12/03/2013 00:22:06 ******/
  560. ALTER TABLE [dbo].[tblTransactions] ADD  CONSTRAINT [DF_tblTransactions_Extras]  DEFAULT ((0)) FOR [Extras]
  561. GO
  562. /****** Object:  Default [DF_tblTransactions_OtherExtras]    Script Date: 12/03/2013 00:22:06 ******/
  563. ALTER TABLE [dbo].[tblTransactions] ADD  CONSTRAINT [DF_tblTransactions_OtherExtras]  DEFAULT ((0)) FOR [OtherExtras]
  564. GO
  565. /****** Object:  Default [DF_tblTransactions_DeliveryFixPrice]    Script Date: 12/03/2013 00:22:06 ******/
  566. ALTER TABLE [dbo].[tblTransactions] ADD  CONSTRAINT [DF_tblTransactions_DeliveryFixPrice]  DEFAULT ((0)) FOR [DeliveryFixPrice]
  567. GO
  568. /****** Object:  Default [DF_tblTransactions_Discount]    Script Date: 12/03/2013 00:22:06 ******/
  569. ALTER TABLE [dbo].[tblTransactions] ADD  CONSTRAINT [DF_tblTransactions_Discount]  DEFAULT ((0)) FOR [Discount]
  570. GO
  571. /****** Object:  Default [DF_tblTransactions_FreeExtras]    Script Date: 12/03/2013 00:22:06 ******/
  572. ALTER TABLE [dbo].[tblTransactions] ADD  CONSTRAINT [DF_tblTransactions_FreeExtras]  DEFAULT ((0)) FOR [FreeExtras]
  573. GO
  574. /****** Object:  Default [DF_tblTransactions_ExchangedVehiclePrice]    Script Date: 12/03/2013 00:22:06 ******/
  575. ALTER TABLE [dbo].[tblTransactions] ADD  CONSTRAINT [DF_tblTransactions_ExchangedVehiclePrice]  DEFAULT ((0)) FOR [ExchangedVehiclePrice]
  576. GO
  577. /****** Object:  Default [DF_tblTransactions_ExchangedVehicleSalesPrice]    Script Date: 12/03/2013 00:22:06 ******/
  578. ALTER TABLE [dbo].[tblTransactions] ADD  CONSTRAINT [DF_tblTransactions_ExchangedVehicleSalesPrice]  DEFAULT ((0)) FOR [ExchangedVehicleSalesPrice]
  579. GO
  580. /****** Object:  Default [DF_tblTransactions_AffectsProvision]    Script Date: 12/03/2013 00:22:06 ******/
  581. ALTER TABLE [dbo].[tblTransactions] ADD  CONSTRAINT [DF_tblTransactions_AffectsProvision]  DEFAULT ((1)) FOR [AffectsProvision]
  582. GO
  583. /****** Object:  Default [DF_tblTransactions_AffectsQuantity]    Script Date: 12/03/2013 00:22:06 ******/
  584. ALTER TABLE [dbo].[tblTransactions] ADD  CONSTRAINT [DF_tblTransactions_AffectsQuantity]  DEFAULT ((1)) FOR [AffectsQuantity]
  585. GO
  586. /****** Object:  Default [DF_tblTransactions_DocumentsReceived]    Script Date: 12/03/2013 00:22:06 ******/
  587. ALTER TABLE [dbo].[tblTransactions] ADD  CONSTRAINT [DF_tblTransactions_DocumentsReceived]  DEFAULT ((0)) FOR [DocumentsReceived]
  588. GO
  589. /****** Object:  Default [DF_tblTransactions_C_ImportDiscountTotal]    Script Date: 12/03/2013 00:22:06 ******/
  590. ALTER TABLE [dbo].[tblTransactions] ADD  CONSTRAINT [DF_tblTransactions_C_ImportDiscountTotal]  DEFAULT ((0)) FOR [C_ImportDiscountTotal]
  591. GO
  592. /****** Object:  Default [DF_tblTransactions_ProvisionChecked]    Script Date: 12/03/2013 00:22:06 ******/
  593. ALTER TABLE [dbo].[tblTransactions] ADD  CONSTRAINT [DF_tblTransactions_ProvisionChecked]  DEFAULT ((0)) FOR [ProvisionChecked]
  594. GO
  595. /****** Object:  Default [DF_tblTransactions_C_ImportSpecialDiscount]    Script Date: 12/03/2013 00:22:06 ******/
  596. ALTER TABLE [dbo].[tblTransactions] ADD  CONSTRAINT [DF_tblTransactions_C_ImportSpecialDiscount]  DEFAULT ((0)) FOR [C_ImportSpecialDiscountTotal]
  597. GO
  598. /****** Object:  Default [DF_tblTransactions_C_CompletPrice]    Script Date: 12/03/2013 00:22:06 ******/
  599. ALTER TABLE [dbo].[tblTransactions] ADD  CONSTRAINT [DF_tblTransactions_C_CompletPrice]  DEFAULT ((0)) FOR [C_CompletePrice]
  600. GO
  601. /****** Object:  Default [DF_tblTransactions_C_EstimateExceeded]    Script Date: 12/03/2013 00:22:06 ******/
  602. ALTER TABLE [dbo].[tblTransactions] ADD  CONSTRAINT [DF_tblTransactions_C_EstimateExceeded]  DEFAULT ((0)) FOR [C_EstimateExceeded]
  603. GO
  604. /****** Object:  Default [DF_tblTransactions_C_TotalDiscountValue]    Script Date: 12/03/2013 00:22:06 ******/
  605. ALTER TABLE [dbo].[tblTransactions] ADD  CONSTRAINT [DF_tblTransactions_C_TotalDiscountValue]  DEFAULT ((0)) FOR [C_TotalDiscountValue]
  606. GO
  607. /****** Object:  Default [DF_tblTransactions_C_GrossPrice]    Script Date: 12/03/2013 00:22:06 ******/
  608. ALTER TABLE [dbo].[tblTransactions] ADD  CONSTRAINT [DF_tblTransactions_C_GrossPrice]  DEFAULT ((0)) FOR [C_GrossPrice]
  609. GO
  610. /****** Object:  Default [DF_tblTransactions_C_TotalDiscountPercent]    Script Date: 12/03/2013 00:22:06 ******/
  611. ALTER TABLE [dbo].[tblTransactions] ADD  CONSTRAINT [DF_tblTransactions_C_TotalDiscountPercent]  DEFAULT ((0)) FOR [C_TotalDiscountPercent]
  612. GO
  613. /****** Object:  Default [DF_tblTransactions_M_TurnoverCorrectionFactor]    Script Date: 12/03/2013 00:22:06 ******/
  614. ALTER TABLE [dbo].[tblTransactions] ADD  CONSTRAINT [DF_tblTransactions_M_TurnoverCorrectionFactor]  DEFAULT ((0)) FOR [M_TurnoverCorrectionFactor]
  615. GO
  616. /****** Object:  Default [DF_tblTransactions_M_ProvisionRelevantTurnover]    Script Date: 12/03/2013 00:22:06 ******/
  617. ALTER TABLE [dbo].[tblTransactions] ADD  CONSTRAINT [DF_tblTransactions_M_ProvisionRelevantTurnover]  DEFAULT ((0)) FOR [M_ProvisionRelevantTurnoverVehicle]
  618. GO
  619. /****** Object:  Default [DF_tblTransactions_M_TotalExtras]    Script Date: 12/03/2013 00:22:06 ******/
  620. ALTER TABLE [dbo].[tblTransactions] ADD  CONSTRAINT [DF_tblTransactions_M_TotalExtras]  DEFAULT ((0)) FOR [M_TotalTurnoverExtras]
  621. GO
  622. /****** Object:  Default [DF_tblTransactions_M_TotalDiscountExtrasPercent]    Script Date: 12/03/2013 00:22:06 ******/
  623. ALTER TABLE [dbo].[tblTransactions] ADD  CONSTRAINT [DF_tblTransactions_M_TotalDiscountExtrasPercent]  DEFAULT ((0)) FOR [M_TotalDiscountExtrasPercent]
  624. GO
  625. /****** Object:  Default [DF_tblTransactions_M_TurnoverMultiplicator]    Script Date: 12/03/2013 00:22:06 ******/
  626. ALTER TABLE [dbo].[tblTransactions] ADD  CONSTRAINT [DF_tblTransactions_M_TurnoverMultiplicator]  DEFAULT ((0)) FOR [M_TurnoverMultiplicator]
  627. GO
  628. /****** Object:  Default [DF_tblTransactions_M_ProvisionRelevantTurnoverExtras]    Script Date: 12/03/2013 00:22:06 ******/
  629. ALTER TABLE [dbo].[tblTransactions] ADD  CONSTRAINT [DF_tblTransactions_M_ProvisionRelevantTurnoverExtras]  DEFAULT ((0)) FOR [M_ProvisionRelevantTurnoverExtras]
  630. GO
  631. /****** Object:  Default [DF_tblTransactions_M_ProvisionRelevantTurnoverTotal]    Script Date: 12/03/2013 00:22:06 ******/
  632. ALTER TABLE [dbo].[tblTransactions] ADD  CONSTRAINT [DF_tblTransactions_M_ProvisionRelevantTurnoverTotal]  DEFAULT ((0)) FOR [M_ProvisionRelevantTurnoverTotal]
  633. GO
  634. /****** Object:  Default [DF_tblTransactions_A_ParticipationValue]    Script Date: 12/03/2013 00:22:06 ******/
  635. ALTER TABLE [dbo].[tblTransactions] ADD  CONSTRAINT [DF_tblTransactions_A_ParticipationValue]  DEFAULT ((0)) FOR [A_ProvisionParticipation]
  636. GO
  637. /****** Object:  Default [DF_tblTransactions_A_ProvisionFactor]    Script Date: 12/03/2013 00:22:06 ******/
  638. ALTER TABLE [dbo].[tblTransactions] ADD  CONSTRAINT [DF_tblTransactions_A_ProvisionFactor]  DEFAULT ((0)) FOR [A_ProvisionFactor]
  639. GO
  640. /****** Object:  Default [DF_tblTransactions_A_ProvisionValue]    Script Date: 12/03/2013 00:22:06 ******/
  641. ALTER TABLE [dbo].[tblTransactions] ADD  CONSTRAINT [DF_tblTransactions_A_ProvisionValue]  DEFAULT ((0)) FOR [A_ProvisionTurnover]
  642. GO
  643. /****** Object:  Default [DF_tblTransactions_A_ProvisionValueTotal]    Script Date: 12/03/2013 00:22:06 ******/
  644. ALTER TABLE [dbo].[tblTransactions] ADD  CONSTRAINT [DF_tblTransactions_A_ProvisionValueTotal]  DEFAULT ((0)) FOR [A_ProvisionTotal]
  645. GO
  646. /****** Object:  Default [DF_tblTransactionDiscounts_Bonus]    Script Date: 12/03/2013 00:22:06 ******/
  647. ALTER TABLE [dbo].[tblTransactionImporterDiscounts] ADD  CONSTRAINT [DF_tblTransactionDiscounts_Bonus]  DEFAULT ((0)) FOR [Discount]
  648. GO
  649. /****** Object:  ForeignKey [FK_tblConditions_tblEmployees]    Script Date: 12/03/2013 00:22:06 ******/
  650. ALTER TABLE [dbo].[tblConditions]  WITH CHECK ADD  CONSTRAINT [FK_tblConditions_tblEmployees] FOREIGN KEY([IDEmployee])
  651. REFERENCES [dbo].[tblEmployees] ([IDEmployee])
  652. ON DELETE CASCADE
  653. GO
  654. ALTER TABLE [dbo].[tblConditions] CHECK CONSTRAINT [FK_tblConditions_tblEmployees]
  655. GO
  656. /****** Object:  ForeignKey [FK_tblCompensations_tblEmployees]    Script Date: 12/03/2013 00:22:06 ******/
  657. ALTER TABLE [dbo].[tblCompensations]  WITH CHECK ADD  CONSTRAINT [FK_tblCompensations_tblEmployees] FOREIGN KEY([IDEmployee])
  658. REFERENCES [dbo].[tblEmployees] ([IDEmployee])
  659. ON DELETE CASCADE
  660. GO
  661. ALTER TABLE [dbo].[tblCompensations] CHECK CONSTRAINT [FK_tblCompensations_tblEmployees]
  662. GO
  663. /****** Object:  ForeignKey [fk_RoleId]    Script Date: 12/03/2013 00:22:06 ******/
  664. ALTER TABLE [dbo].[webpages_UsersInRoles]  WITH CHECK ADD  CONSTRAINT [fk_RoleId] FOREIGN KEY([RoleId])
  665. REFERENCES [dbo].[webpages_Roles] ([RoleId])
  666. GO
  667. ALTER TABLE [dbo].[webpages_UsersInRoles] CHECK CONSTRAINT [fk_RoleId]
  668. GO
  669. /****** Object:  ForeignKey [fk_UserId]    Script Date: 12/03/2013 00:22:06 ******/
  670. ALTER TABLE [dbo].[webpages_UsersInRoles]  WITH CHECK ADD  CONSTRAINT [fk_UserId] FOREIGN KEY([UserId])
  671. REFERENCES [dbo].[tblEmployees] ([IDEmployee])
  672. GO
  673. ALTER TABLE [dbo].[webpages_UsersInRoles] CHECK CONSTRAINT [fk_UserId]
  674. GO
  675. /****** Object:  ForeignKey [FK_tblTargets_tblEmployees]    Script Date: 12/03/2013 00:22:06 ******/
  676. ALTER TABLE [dbo].[tblTargets]  WITH CHECK ADD  CONSTRAINT [FK_tblTargets_tblEmployees] FOREIGN KEY([IDEmployee])
  677. REFERENCES [dbo].[tblEmployees] ([IDEmployee])
  678. GO
  679. ALTER TABLE [dbo].[tblTargets] CHECK CONSTRAINT [FK_tblTargets_tblEmployees]
  680. GO
  681. /****** Object:  ForeignKey [FK_tblSpecialBonuses_tblEmployees]    Script Date: 12/03/2013 00:22:06 ******/
  682. ALTER TABLE [dbo].[tblSpecialBonuses]  WITH CHECK ADD  CONSTRAINT [FK_tblSpecialBonuses_tblEmployees] FOREIGN KEY([IDEmployee])
  683. REFERENCES [dbo].[tblEmployees] ([IDEmployee])
  684. GO
  685. ALTER TABLE [dbo].[tblSpecialBonuses] CHECK CONSTRAINT [FK_tblSpecialBonuses_tblEmployees]
  686. GO
  687. /****** Object:  ForeignKey [FK_tblSalarySettings_tblEmployees]    Script Date: 12/03/2013 00:22:06 ******/
  688. ALTER TABLE [dbo].[tblSalarySettings]  WITH CHECK ADD  CONSTRAINT [FK_tblSalarySettings_tblEmployees] FOREIGN KEY([IDEmployee])
  689. REFERENCES [dbo].[tblEmployees] ([IDEmployee])
  690. GO
  691. ALTER TABLE [dbo].[tblSalarySettings] CHECK CONSTRAINT [FK_tblSalarySettings_tblEmployees]
  692. GO
  693. /****** Object:  ForeignKey [FK_tblBonuses_tblEmployees]    Script Date: 12/03/2013 00:22:06 ******/
  694. ALTER TABLE [dbo].[tblBonuses]  WITH CHECK ADD  CONSTRAINT [FK_tblBonuses_tblEmployees] FOREIGN KEY([IDEmployee])
  695. REFERENCES [dbo].[tblEmployees] ([IDEmployee])
  696. GO
  697. ALTER TABLE [dbo].[tblBonuses] CHECK CONSTRAINT [FK_tblBonuses_tblEmployees]
  698. GO
  699. /****** Object:  ForeignKey [FK_tblTransactions_tblCustomerTypes]    Script Date: 12/03/2013 00:22:06 ******/
  700. ALTER TABLE [dbo].[tblTransactions]  WITH CHECK ADD  CONSTRAINT [FK_tblTransactions_tblCustomerTypes] FOREIGN KEY([IDCustomerType])
  701. REFERENCES [dbo].[tblCustomerTypes] ([IDCustomerType])
  702. GO
  703. ALTER TABLE [dbo].[tblTransactions] CHECK CONSTRAINT [FK_tblTransactions_tblCustomerTypes]
  704. GO
  705. /****** Object:  ForeignKey [FK_tblTransactions_tblDiscountTypes]    Script Date: 12/03/2013 00:22:06 ******/
  706. ALTER TABLE [dbo].[tblTransactions]  WITH CHECK ADD  CONSTRAINT [FK_tblTransactions_tblDiscountTypes] FOREIGN KEY([IDDiscountType])
  707. REFERENCES [dbo].[tblDiscountTypes] ([IDDiscountType])
  708. GO
  709. ALTER TABLE [dbo].[tblTransactions] CHECK CONSTRAINT [FK_tblTransactions_tblDiscountTypes]
  710. GO
  711. /****** Object:  ForeignKey [FK_tblTransactions_tblEmployees]    Script Date: 12/03/2013 00:22:06 ******/
  712. ALTER TABLE [dbo].[tblTransactions]  WITH NOCHECK ADD  CONSTRAINT [FK_tblTransactions_tblEmployees] FOREIGN KEY([IDEmployee])
  713. REFERENCES [dbo].[tblEmployees] ([IDEmployee])
  714. GO
  715. ALTER TABLE [dbo].[tblTransactions] CHECK CONSTRAINT [FK_tblTransactions_tblEmployees]
  716. GO
  717. /****** Object:  ForeignKey [FK_tblTransactions_tblEmployees1]    Script Date: 12/03/2013 00:22:06 ******/
  718. ALTER TABLE [dbo].[tblTransactions]  WITH NOCHECK ADD  CONSTRAINT [FK_tblTransactions_tblEmployees1] FOREIGN KEY([IDParticipator])
  719. REFERENCES [dbo].[tblEmployees] ([IDEmployee])
  720. GO
  721. ALTER TABLE [dbo].[tblTransactions] NOCHECK CONSTRAINT [FK_tblTransactions_tblEmployees1]
  722. GO
  723. /****** Object:  ForeignKey [FK_tblTransactions_tblSalesChannels]    Script Date: 12/03/2013 00:22:06 ******/
  724. ALTER TABLE [dbo].[tblTransactions]  WITH NOCHECK ADD  CONSTRAINT [FK_tblTransactions_tblSalesChannels] FOREIGN KEY([IDSalesChannel])
  725. REFERENCES [dbo].[tblSalesChannels] ([IDSalesChannel])
  726. GO
  727. ALTER TABLE [dbo].[tblTransactions] NOCHECK CONSTRAINT [FK_tblTransactions_tblSalesChannels]
  728. GO
  729. /****** Object:  ForeignKey [FK_tblTransactions_tblVehicleModels]    Script Date: 12/03/2013 00:22:06 ******/
  730. ALTER TABLE [dbo].[tblTransactions]  WITH CHECK ADD  CONSTRAINT [FK_tblTransactions_tblVehicleModels] FOREIGN KEY([IDVehicleModel])
  731. REFERENCES [dbo].[tblVehicleModels] ([IDVehicleModel])
  732. GO
  733. ALTER TABLE [dbo].[tblTransactions] CHECK CONSTRAINT [FK_tblTransactions_tblVehicleModels]
  734. GO
  735. /****** Object:  ForeignKey [FK_tblTransactions_tblVehicleTypes]    Script Date: 12/03/2013 00:22:06 ******/
  736. ALTER TABLE [dbo].[tblTransactions]  WITH CHECK ADD  CONSTRAINT [FK_tblTransactions_tblVehicleTypes] FOREIGN KEY([IDVehicleType])
  737. REFERENCES [dbo].[tblVehicleTypes] ([IDVehicleType])
  738. GO
  739. ALTER TABLE [dbo].[tblTransactions] CHECK CONSTRAINT [FK_tblTransactions_tblVehicleTypes]
  740. GO
  741. /****** Object:  ForeignKey [FK_tblTransactionDiscounts_tblCampainTypes]    Script Date: 12/03/2013 00:22:06 ******/
  742. ALTER TABLE [dbo].[tblTransactionImporterDiscounts]  WITH CHECK ADD  CONSTRAINT [FK_tblTransactionDiscounts_tblCampainTypes] FOREIGN KEY([IDCampaignType])
  743. REFERENCES [dbo].[tblCampaignTypes] ([IDCampaignType])
  744. GO
  745. ALTER TABLE [dbo].[tblTransactionImporterDiscounts] CHECK CONSTRAINT [FK_tblTransactionDiscounts_tblCampainTypes]
  746. GO
  747. /****** Object:  ForeignKey [FK_tblTransactionDiscounts_tblImporterDiscounts]    Script Date: 12/03/2013 00:22:06 ******/
  748. ALTER TABLE [dbo].[tblTransactionImporterDiscounts]  WITH CHECK ADD  CONSTRAINT [FK_tblTransactionDiscounts_tblImporterDiscounts] FOREIGN KEY([IDImporterDiscount])
  749. REFERENCES [dbo].[tblImporterDiscounts] ([IDImporterDiscount])
  750. GO
  751. ALTER TABLE [dbo].[tblTransactionImporterDiscounts] CHECK CONSTRAINT [FK_tblTransactionDiscounts_tblImporterDiscounts]
  752. GO
  753. /****** Object:  ForeignKey [FK_tblTransactionImporterDiscounts_tblTransactions]    Script Date: 12/03/2013 00:22:06 ******/
  754. ALTER TABLE [dbo].[tblTransactionImporterDiscounts]  WITH NOCHECK ADD  CONSTRAINT [FK_tblTransactionImporterDiscounts_tblTransactions] FOREIGN KEY([IDTransaction])
  755. REFERENCES [dbo].[tblTransactions] ([IDTransaction])
  756. NOT FOR REPLICATION
  757. GO
  758. ALTER TABLE [dbo].[tblTransactionImporterDiscounts] NOCHECK CONSTRAINT [FK_tblTransactionImporterDiscounts_tblTransactions]
  759. GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!