SQLize | PHPize | SQLtest

USE [master] GO /****** Object: Database [sport_tovar] Script Date: 03.03.2025 17:45:53 ******/ CREATE DATABASE [sport_tovar] CONTAINMENT = NONE ON PRIMARY ( NAME = N'sport_tovar', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS\MSSQL\DATA\sport_tovar.mdf' , SIZE = 8192KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB ) LOG ON ( NAME = N'sport_tovar_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS\MSSQL\DATA\sport_tovar_log.ldf' , SIZE = 8192KB , MAXSIZE = 2048GB , FILEGROWTH = 65536KB ) WITH CATALOG_COLLATION = DATABASE_DEFAULT, LEDGER = OFF GO ALTER DATABASE [sport_tovar] SET COMPATIBILITY_LEVEL = 160 GO IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')) begin EXEC [sport_tovar].[dbo].[sp_fulltext_database] @action = 'enable' end GO ALTER DATABASE [sport_tovar] SET ANSI_NULL_DEFAULT OFF GO ALTER DATABASE [sport_tovar] SET ANSI_NULLS OFF GO ALTER DATABASE [sport_tovar] SET ANSI_PADDING OFF GO ALTER DATABASE [sport_tovar] SET ANSI_WARNINGS OFF GO ALTER DATABASE [sport_tovar] SET ARITHABORT OFF GO ALTER DATABASE [sport_tovar] SET AUTO_CLOSE OFF GO ALTER DATABASE [sport_tovar] SET AUTO_SHRINK OFF GO ALTER DATABASE [sport_tovar] SET AUTO_UPDATE_STATISTICS ON GO ALTER DATABASE [sport_tovar] SET CURSOR_CLOSE_ON_COMMIT OFF GO ALTER DATABASE [sport_tovar] SET CURSOR_DEFAULT GLOBAL GO ALTER DATABASE [sport_tovar] SET CONCAT_NULL_YIELDS_NULL OFF GO ALTER DATABASE [sport_tovar] SET NUMERIC_ROUNDABORT OFF GO ALTER DATABASE [sport_tovar] SET QUOTED_IDENTIFIER OFF GO ALTER DATABASE [sport_tovar] SET RECURSIVE_TRIGGERS OFF GO ALTER DATABASE [sport_tovar] SET DISABLE_BROKER GO ALTER DATABASE [sport_tovar] SET AUTO_UPDATE_STATISTICS_ASYNC OFF GO ALTER DATABASE [sport_tovar] SET DATE_CORRELATION_OPTIMIZATION OFF GO ALTER DATABASE [sport_tovar] SET TRUSTWORTHY OFF GO ALTER DATABASE [sport_tovar] SET ALLOW_SNAPSHOT_ISOLATION OFF GO ALTER DATABASE [sport_tovar] SET PARAMETERIZATION SIMPLE GO ALTER DATABASE [sport_tovar] SET READ_COMMITTED_SNAPSHOT OFF GO ALTER DATABASE [sport_tovar] SET HONOR_BROKER_PRIORITY OFF GO ALTER DATABASE [sport_tovar] SET RECOVERY SIMPLE GO ALTER DATABASE [sport_tovar] SET MULTI_USER GO ALTER DATABASE [sport_tovar] SET PAGE_VERIFY CHECKSUM GO ALTER DATABASE [sport_tovar] SET DB_CHAINING OFF GO ALTER DATABASE [sport_tovar] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF ) GO ALTER DATABASE [sport_tovar] SET TARGET_RECOVERY_TIME = 60 SECONDS GO ALTER DATABASE [sport_tovar] SET DELAYED_DURABILITY = DISABLED GO ALTER DATABASE [sport_tovar] SET ACCELERATED_DATABASE_RECOVERY = OFF GO ALTER DATABASE [sport_tovar] SET QUERY_STORE = ON GO ALTER DATABASE [sport_tovar] SET QUERY_STORE (OPERATION_MODE = READ_WRITE, CLEANUP_POLICY = (STALE_QUERY_THRESHOLD_DAYS = 30), DATA_FLUSH_INTERVAL_SECONDS = 900, INTERVAL_LENGTH_MINUTES = 60, MAX_STORAGE_SIZE_MB = 1000, QUERY_CAPTURE_MODE = AUTO, SIZE_BASED_CLEANUP_MODE = AUTO, MAX_PLANS_PER_QUERY = 200, WAIT_STATS_CAPTURE_MODE = ON) GO USE [sport_tovar] GO /****** Object: Table [dbo].[chek] Script Date: 03.03.2025 17:45:53 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[chek]( [kod_chek] [int] NOT NULL, [kod_korzina] [int] NOT NULL, [kod_user] [int] NOT NULL, [kod_PR] [int] NOT NULL, [Mgaz] [int] NOT NULL, CONSTRAINT [PK__chek__C73BAED7518D3584] PRIMARY KEY CLUSTERED ( [kod_chek] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[korzina] Script Date: 03.03.2025 17:45:54 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[korzina]( [kod_korzina] [int] NOT NULL, [kod_tovar] [int] NOT NULL, [kolv] [int] NULL, PRIMARY KEY CLUSTERED ( [kod_korzina] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[Magaz] Script Date: 03.03.2025 17:45:54 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Magaz]( [kod_Magaz] [int] NOT NULL, [inn] [int] NOT NULL, PRIMARY KEY CLUSTERED ( [kod_Magaz] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[postav] Script Date: 03.03.2025 17:45:54 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[postav]( [kod_post] [int] NOT NULL, [name_psot] [nchar](10) NULL, [tovar] [int] NOT NULL, [prim_cost] [int] NULL, [after_cost] [int] NULL, [adres] [nchar](10) NULL, [telefon] [nchar](10) NULL, PRIMARY KEY CLUSTERED ( [kod_post] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[Postav_sklad] Script Date: 03.03.2025 17:45:54 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Postav_sklad]( [kod_sklad] [int] NOT NULL, [kod_Post] [int] NOT NULL, CONSTRAINT [PK_Postav_sklad] PRIMARY KEY CLUSTERED ( [kod_sklad] ASC, [kod_Post] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[prodavec] Script Date: 03.03.2025 17:45:54 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[prodavec]( [kod_pr] [int] NOT NULL, [name_pr] [nchar](10) NULL, [adres] [nchar](10) NULL, [telefon] [nchar](10) NULL, PRIMARY KEY CLUSTERED ( [kod_pr] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[sklad] Script Date: 03.03.2025 17:45:54 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[sklad]( [kod_sklad] [int] NOT NULL, [tovar] [int] NOT NULL, [kolv_tovar] [int] NULL, PRIMARY KEY CLUSTERED ( [kod_sklad] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[tovar] Script Date: 03.03.2025 17:45:54 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tovar]( [kod_tovar] [int] NOT NULL, [name_tovar] [nchar](10) NULL, [Cost] [int] NULL, PRIMARY KEY CLUSTERED ( [kod_tovar] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[user1] Script Date: 03.03.2025 17:45:54 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[user1]( [kod_user] [int] NOT NULL, [name_user] [nchar](10) NULL, [adres] [nchar](10) NULL, [telefon] [nchar](10) NULL, PRIMARY KEY CLUSTERED ( [kod_user] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO ALTER TABLE [dbo].[chek] WITH CHECK ADD FOREIGN KEY([kod_PR]) REFERENCES [dbo].[prodavec] ([kod_pr]) GO ALTER TABLE [dbo].[chek] WITH CHECK ADD CONSTRAINT [FK__chek__kod_user__619B8048] FOREIGN KEY([kod_user]) REFERENCES [dbo].[user1] ([kod_user]) GO ALTER TABLE [dbo].[chek] CHECK CONSTRAINT [FK__chek__kod_user__619B8048] GO ALTER TABLE [dbo].[chek] WITH CHECK ADD CONSTRAINT [FK__chek__Mgaz__693CA210] FOREIGN KEY([Mgaz]) REFERENCES [dbo].[Magaz] ([kod_Magaz]) GO ALTER TABLE [dbo].[chek] CHECK CONSTRAINT [FK__chek__Mgaz__693CA210] GO ALTER TABLE [dbo].[korzina] WITH CHECK ADD CONSTRAINT [FK__korzina__kod_kor__628FA481] FOREIGN KEY([kod_korzina]) REFERENCES [dbo].[chek] ([kod_chek]) GO ALTER TABLE [dbo].[korzina] CHECK CONSTRAINT [FK__korzina__kod_kor__628FA481] GO ALTER TABLE [dbo].[korzina] WITH CHECK ADD FOREIGN KEY([kod_tovar]) REFERENCES [dbo].[tovar] ([kod_tovar]) GO ALTER TABLE [dbo].[Postav_sklad] WITH CHECK ADD FOREIGN KEY([kod_Post]) REFERENCES [dbo].[postav] ([kod_post]) GO ALTER TABLE [dbo].[Postav_sklad] WITH CHECK ADD FOREIGN KEY([kod_sklad]) REFERENCES [dbo].[sklad] ([kod_sklad]) GO USE [master] GO ALTER DATABASE [sport_tovar] SET READ_WRITE GO