Database sql ise
-- ----------------------------
-- Table structure for Categories
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Categories]') AND type IN ('U'))
DROP TABLE [dbo].[Categories]
GO
CREATE TABLE [dbo].[Categories] (
[CategoryID] int NOT NULL,
[CategoryName] varchar(255) COLLATE Turkish_CI_AS NULL,
[Description] varchar(255) COLLATE Turkish_CI_AS NULL,
[Picture] varchar(255) COLLATE Turkish_CI_AS NULL,
[Active] varchar(255) COLLATE Turkish_CI_AS NULL
)
GO
ALTER TABLE [dbo].[Categories] SET (LOCK_ESCALATION = TABLE)
GO
-- ----------------------------
-- Table structure for Colors
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Colors]') AND type IN ('U'))
DROP TABLE [dbo].[Colors]
GO
CREATE TABLE [dbo].[Colors] (
[ColorID] int NOT NULL,
[Color] varchar(255) COLLATE Turkish_CI_AS NULL,
[ColorValue] varchar(255) COLLATE Turkish_CI_AS NULL
)
GO
ALTER TABLE [dbo].[Colors] SET (LOCK_ESCALATION = TABLE)
GO
-- ----------------------------
-- Records of Colors
-- ----------------------------
INSERT INTO [dbo].[Colors] VALUES (N'1', N'Sarı', NULL)
GO
-- ----------------------------
-- Table structure for Complaints
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Complaints]') AND type IN ('U'))
DROP TABLE [dbo].[Complaints]
GO
CREATE TABLE [dbo].[Complaints] (
[ComplaintID] int NOT NULL,
[Title] varchar(255) COLLATE Turkish_CI_AS NULL,
[CustomerID] int NULL,
[Description] varchar(255) COLLATE Turkish_CI_AS NULL,
[CreatedDate] datetime NULL
)
GO
ALTER TABLE [dbo].[Complaints] SET (LOCK_ESCALATION = TABLE)
GO
-- ----------------------------
-- Table structure for Customers
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Customers]') AND type IN ('U'))
DROP TABLE [dbo].[Customers]
GO
CREATE TABLE [dbo].[Customers] (
[CustomerID] int NOT NULL,
[FirstName] varchar(255) COLLATE Turkish_CI_AS NULL,
[LastName] varchar(255) COLLATE Turkish_CI_AS NULL,
[Address1] varchar(255) COLLATE Turkish_CI_AS NULL,
[Address2] varchar(255) COLLATE Turkish_CI_AS NULL,
[City] varchar(255) COLLATE Turkish_CI_AS NULL,
[PostalCode] varchar(255) COLLATE Turkish_CI_AS NULL,
[Country] varchar(255) COLLATE Turkish_CI_AS NULL,
[Phone] varchar(255) COLLATE Turkish_CI_AS NULL,
[Email] varchar(255) COLLATE Turkish_CI_AS NULL,
[Password] varchar(255) COLLATE Turkish_CI_AS NULL,
[CreditCard] varchar(255) COLLATE Turkish_CI_AS NULL,
[CardExpMo] int NULL,
[CardExpYr] int NULL,
[CreditCardTypeID] varchar(255) COLLATE Turkish_CI_AS NULL,
[BillingAddress] varchar(255) COLLATE Turkish_CI_AS NULL,
[BillingCity] varchar(255) COLLATE Turkish_CI_AS NULL,
[BillingCountry] varchar(255) COLLATE Turkish_CI_AS NULL,
[BillingPostalCode] varchar(255) COLLATE Turkish_CI_AS NULL,
[ShipAddress] varchar(255) COLLATE Turkish_CI_AS NULL,
[ShipCity] varchar(255) COLLATE Turkish_CI_AS NULL,
[ShipPostalCode] varchar(255) COLLATE Turkish_CI_AS NULL,
[ShipCountry] varchar(255) COLLATE Turkish_CI_AS NULL,
[RegistrationDate] datetime NULL,
[RoleId] int NULL
)
GO
ALTER TABLE [dbo].[Customers] SET (LOCK_ESCALATION = TABLE)
GO
-- ----------------------------
-- Table structure for OrderDetails
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[OrderDetails]') AND type IN ('U'))
DROP TABLE [dbo].[OrderDetails]
GO
CREATE TABLE [dbo].[OrderDetails] (
[OrderDetailID] int NOT NULL,
[ProductID] int NULL,
[OrderID] int NULL,
[OrderNumber] bigint NULL,
[Price] int NULL,
[Quantity] int NULL,
[Discount] int NULL,
[Total] int NULL,
[Size] nvarchar(1) COLLATE Turkish_CI_AS NULL,
[Color] varchar(255) COLLATE Turkish_CI_AS NULL,
[FulFilled] varchar(255) COLLATE Turkish_CI_AS NULL,
[ShipDate] datetime2(7) NULL,
[BillDate] datetime2(7) NULL
)
GO
ALTER TABLE [dbo].[OrderDetails] SET (LOCK_ESCALATION = TABLE)
GO
-- ----------------------------
-- Table structure for Orders
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Orders]') AND type IN ('U'))
DROP TABLE [dbo].[Orders]
GO
CREATE TABLE [dbo].[Orders] (
[OrderID] int NOT NULL,
[CustomerID] int NULL,
[PaymentID] int NULL,
[OrderNumber] bigint NULL,
[OrderDate] datetime NULL,
[ShipDate] datetime NULL,
[ShipperID] int NULL,
[Freight] money NULL,
[SalesTax] money NULL,
[FulFilled] bit NULL,
[Deleted] bit NULL,
[PaymentDate] datetime NULL,
[Paid] money NULL,
[TransactStatus] varchar(255) COLLATE Turkish_CI_AS NULL,
[ErrLoc] varchar(255) COLLATE Turkish_CI_AS NULL,
[ErrMsg] varchar(255) COLLATE Turkish_CI_AS NULL
)
GO
ALTER TABLE [dbo].[Orders] SET (LOCK_ESCALATION = TABLE)
GO
-- ----------------------------
-- Table structure for Payments
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Payments]') AND type IN ('U'))
DROP TABLE [dbo].[Payments]
GO
CREATE TABLE [dbo].[Payments] (
[PaymentID] int NOT NULL,
[PaymentType] varchar(255) COLLATE Turkish_CI_AS NULL,
[Allowed] bit NULL
)
GO
ALTER TABLE [dbo].[Payments] SET (LOCK_ESCALATION = TABLE)
GO
-- ----------------------------
-- Table structure for Products
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Products]') AND type IN ('U'))
DROP TABLE [dbo].[Products]
GO
CREATE TABLE [dbo].[Products] (
[ProductID] int NOT NULL,
[ProductName] varchar(255) COLLATE Turkish_CI_AS NULL,
[ProductDescription] varchar(255) COLLATE Turkish_CI_AS NULL,
[SupplierID] int NULL,
[CategoryID] int NULL,
[QuantityPerUnit] int NULL,
[UnitPrice] int NULL,
[SizeID] int NOT NULL,
[ColorID] int NOT NULL,
[Discount] varchar(255) COLLATE Turkish_CI_AS NULL,
[Picture] varchar(255) COLLATE Turkish_CI_AS NULL,
[DiscountAvailable] bit NULL,
[CurrentOrder] bit NULL
)
GO
ALTER TABLE [dbo].[Products] SET (LOCK_ESCALATION = TABLE)
GO
-- ----------------------------
-- Table structure for Roles
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Roles]') AND type IN ('U'))
DROP TABLE [dbo].[Roles]
GO
CREATE TABLE [dbo].[Roles] (
[Id] int NOT NULL,
[RoleName] varchar(255) COLLATE Turkish_CI_AS NULL
)
GO
ALTER TABLE [dbo].[Roles] SET (LOCK_ESCALATION = TABLE)
GO
-- ----------------------------
-- Table structure for Shippers
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Shippers]') AND type IN ('U'))
DROP TABLE [dbo].[Shippers]
GO
CREATE TABLE [dbo].[Shippers] (
[ShipperID] int NOT NULL,
[CompanyName] varchar(255) COLLATE Turkish_CI_AS NULL,
[Phone] varchar(255) COLLATE Turkish_CI_AS NULL
)
GO
ALTER TABLE [dbo].[Shippers] SET (LOCK_ESCALATION = TABLE)
GO
-- ----------------------------
-- Table structure for Sizes
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Sizes]') AND type IN ('U'))
DROP TABLE [dbo].[Sizes]
GO
CREATE TABLE [dbo].[Sizes] (
[SizeID] int NOT NULL,
[Size] nvarchar(1) COLLATE Turkish_CI_AS NULL,
[SizeValue] float(53) NULL
)
GO
ALTER TABLE [dbo].[Sizes] SET (LOCK_ESCALATION = TABLE)
GO
-- ----------------------------
-- Records of Sizes
-- ----------------------------
INSERT INTO [dbo].[Sizes] VALUES (N'1', N'M', NULL)
GO
-- ----------------------------
-- Table structure for Suppliers
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Suppliers]') AND type IN ('U'))
DROP TABLE [dbo].[Suppliers]
GO
CREATE TABLE [dbo].[Suppliers] (
[SupplierID] int NOT NULL,
[CompanyName] varchar(255) COLLATE Turkish_CI_AS NULL,
[ContactFName] varchar(255) COLLATE Turkish_CI_AS NULL,
[ContactLName] varchar(255) COLLATE Turkish_CI_AS NULL,
[Address1] varchar(255) COLLATE Turkish_CI_AS NULL,
[Address2] varchar(255) COLLATE Turkish_CI_AS NULL,
[City] varchar(255) COLLATE Turkish_CI_AS NULL,
[PostalCode] varchar(255) COLLATE Turkish_CI_AS NULL,
[Country] varchar(255) COLLATE Turkish_CI_AS NULL,
[Phone] varchar(255) COLLATE Turkish_CI_AS NULL,
[Fax] varchar(255) COLLATE Turkish_CI_AS NULL,
[Email] varchar(255) COLLATE Turkish_CI_AS NULL,
[Website] varchar(255) COLLATE Turkish_CI_AS NULL,
[DiscountType] varchar(255) COLLATE Turkish_CI_AS NULL,
[DiscountRate] varchar(255) COLLATE Turkish_CI_AS NULL,
[DiscountAvailable] varchar(255) COLLATE Turkish_CI_AS NULL,
[CustomerID] int NULL,
[Logo] varchar(255) COLLATE Turkish_CI_AS NULL,
[Note] varchar(255) COLLATE Turkish_CI_AS NULL
)
GO
ALTER TABLE [dbo].[Suppliers] SET (LOCK_ESCALATION = TABLE)
GO
-- ----------------------------
-- Primary Key structure for table Categories
-- ----------------------------
ALTER TABLE [dbo].[Categories] ADD CONSTRAINT [PK__Categori__19093A2BDC670CE3] PRIMARY KEY CLUSTERED ([CategoryID])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
GO
-- ----------------------------
-- Primary Key structure for table Colors
-- ----------------------------
ALTER TABLE [dbo].[Colors] ADD CONSTRAINT [PK__Colors__8DA7676D51CA1D4C] PRIMARY KEY CLUSTERED ([ColorID])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
GO
-- ----------------------------
-- Primary Key structure for table Complaints
-- ----------------------------
ALTER TABLE [dbo].[Complaints] ADD CONSTRAINT [PK__Complain__740D89AF2732EF1E] PRIMARY KEY CLUSTERED ([ComplaintID])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
GO
-- ----------------------------
-- Primary Key structure for table Customers
-- ----------------------------
ALTER TABLE [dbo].[Customers] ADD CONSTRAINT [PK__Customer__A4AE64B8ECDF0326] PRIMARY KEY CLUSTERED ([CustomerID])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
GO
-- ----------------------------
-- Primary Key structure for table OrderDetails
-- ----------------------------
ALTER TABLE [dbo].[OrderDetails] ADD CONSTRAINT [PK__OrderDet__D3B9D30C23587F26] PRIMARY KEY CLUSTERED ([OrderDetailID])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
GO
-- ----------------------------
-- Primary Key structure for table Orders
-- ----------------------------
ALTER TABLE [dbo].[Orders] ADD CONSTRAINT [PK__Orders__C3905BAFD05C1018] PRIMARY KEY CLUSTERED ([OrderID])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
GO
-- ----------------------------
-- Primary Key structure for table Payments
-- ----------------------------
ALTER TABLE [dbo].[Payments] ADD CONSTRAINT [PK__Payments__9B556A58BD67DE30] PRIMARY KEY CLUSTERED ([PaymentID])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
GO
-- ----------------------------
-- Primary Key structure for table Products
-- ----------------------------
ALTER TABLE [dbo].[Products] ADD CONSTRAINT [PK__Products__B40CC6EDD66B4F64] PRIMARY KEY CLUSTERED ([ProductID])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
GO
-- ----------------------------
-- Primary Key structure for table Roles
-- ----------------------------
ALTER TABLE [dbo].[Roles] ADD CONSTRAINT [PK__Roles__3214EC0792FBB6BE] PRIMARY KEY CLUSTERED ([Id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
GO
-- ----------------------------
-- Primary Key structure for table Shippers
-- ----------------------------
ALTER TABLE [dbo].[Shippers] ADD CONSTRAINT [PK__Shippers__1F8AFFB93B884D8C] PRIMARY KEY CLUSTERED ([ShipperID])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
GO
-- ----------------------------
-- Primary Key structure for table Sizes
-- ----------------------------
ALTER TABLE [dbo].[Sizes] ADD CONSTRAINT [PK__Sizes__83BD095A492BC076] PRIMARY KEY CLUSTERED ([SizeID])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
GO
-- ----------------------------
-- Primary Key structure for table Suppliers
-- ----------------------------
ALTER TABLE [dbo].[Suppliers] ADD CONSTRAINT [PK__Supplier__4BE66694FD53D5D6] PRIMARY KEY CLUSTERED ([SupplierID])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
GO
-- ----------------------------
-- Foreign Keys structure for table Complaints
-- ----------------------------
ALTER TABLE [dbo].[Complaints] ADD CONSTRAINT [fk_Complaints_Customers_1] FOREIGN KEY ([CustomerID]) REFERENCES [dbo].[Customers] ([CustomerID]) ON DELETE NO ACTION ON UPDATE NO ACTION
GO
-- ----------------------------
-- Foreign Keys structure for table OrderDetails
-- ----------------------------
ALTER TABLE [dbo].[OrderDetails] ADD CONSTRAINT [fk_OrderDetails_Products_1] FOREIGN KEY ([ProductID]) REFERENCES [dbo].[Products] ([ProductID]) ON DELETE NO ACTION ON UPDATE NO ACTION
GO
ALTER TABLE [dbo].[OrderDetails] ADD CONSTRAINT [fk_OrderDetails_Orders_1] FOREIGN KEY ([OrderID]) REFERENCES [dbo].[Orders] ([OrderID]) ON DELETE NO ACTION ON UPDATE NO ACTION
GO
-- ----------------------------
-- Foreign Keys structure for table Orders
-- ----------------------------
ALTER TABLE [dbo].[Orders] ADD CONSTRAINT [fk_Orders_Customers_1] FOREIGN KEY ([CustomerID]) REFERENCES [dbo].[Customers] ([CustomerID]) ON DELETE NO ACTION ON UPDATE NO ACTION
GO
ALTER TABLE [dbo].[Orders] ADD CONSTRAINT [fk_Orders_Payments_1] FOREIGN KEY ([PaymentID]) REFERENCES [dbo].[Payments] ([PaymentID]) ON DELETE NO ACTION ON UPDATE NO ACTION
GO
-- ----------------------------
-- Foreign Keys structure for table Products
-- ----------------------------
ALTER TABLE [dbo].[Products] ADD CONSTRAINT [fk_Products_Categories_1] FOREIGN KEY ([CategoryID]) REFERENCES [dbo].[Categories] ([CategoryID]) ON DELETE NO ACTION ON UPDATE NO ACTION
GO
ALTER TABLE [dbo].[Products] ADD CONSTRAINT [fk_Products_Suppliers_1] FOREIGN KEY ([SupplierID]) REFERENCES [dbo].[Suppliers] ([SupplierID]) ON DELETE NO ACTION ON UPDATE NO ACTION
GO
ALTER TABLE [dbo].[Products] ADD CONSTRAINT [fk_Products_Sizes_1] FOREIGN KEY ([SizeID]) REFERENCES [dbo].[Sizes] ([SizeID]) ON DELETE NO ACTION ON UPDATE NO ACTION
GO
ALTER TABLE [dbo].[Products] ADD CONSTRAINT [fk_Products_Colors_1] FOREIGN KEY ([ColorID]) REFERENCES [dbo].[Colors] ([ColorID]) ON DELETE NO ACTION ON UPDATE NO ACTION
GO
ALTER TABLE [dbo].[Products] ADD CONSTRAINT [fk_Products_Suppliers_2] FOREIGN KEY ([SupplierID]) REFERENCES [dbo].[Suppliers] ([SupplierID]) ON DELETE NO ACTION ON UPDATE NO ACTION
GOSadece yapman gereken otomatik id artımını açmayı unuttum onuda sen yaparsın artık...