PHP Classes

File: test/script_mssql/test.sql

Recommend this page to a friend!
  Classes of Hernádi Tamás   Rasher PHP Data Access Layer Helper - Database Repository   test/script_mssql/test.sql   Download  
File: test/script_mssql/test.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: Rasher PHP Data Access Layer Helper - Database Repository
Run queries to access data in any type of database
Author: By
Last change: finding bugfix + restructure datamodel + refact
Date: 6 months ago
Size: 5,852 bytes
 

Contents

Class file image Download
??USE [test] GO /****** Object: Table [dbo].[user] Script Date: 2023.08.18. 23:05:20 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[user]( [Id] [int] IDENTITY(1,1) NOT NULL, [LoginName] [varchar](100) NULL, [Password] [varchar](100) NULL, [LastLoginDateTime] [datetime] NULL, [IsLogged] [tinyint] NOT NULL, [IsDeleted] [tinyint] NOT NULL, CONSTRAINT [PK_user] 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 /****** Object: Table [dbo].[user_userrolescollection] Script Date: 2023.08.18. 23:05:21 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[user_userrolescollection]( [Id] [int] IDENTITY(1,1) NOT NULL, [User] [int] NOT NULL, [UserRole] [int] NOT NULL, [IsDeleted] [tinyint] NOT NULL, CONSTRAINT [PK__user_use__3214EC07139C4111] 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 /****** Object: Table [dbo].[userrole] Script Date: 2023.08.18. 23:05:21 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[userrole]( [Id] [int] IDENTITY(1,1) NOT NULL, [Code] [varchar](50) NOT NULL, [Name] [varchar](100) NOT NULL, [IsDeleted] [tinyint] NOT NULL, CONSTRAINT [PK__userrole__3214EC07DE834AB3] 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 /****** Object: Table [dbo].[userrole_userrolesettingscollection] Script Date: 2023.08.18. 23:05:21 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[userrole_userrolesettingscollection]( [Id] [int] IDENTITY(1,1) NOT NULL, [UserRole] [int] NOT NULL, [UserRoleSetting] [int] NOT NULL, [Value] [varchar](100) NULL, [IsDeleted] [tinyint] NOT NULL, CONSTRAINT [PK__user_use__3214EC0779CD1A8E] 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 /****** Object: Table [dbo].[userrolesetting] Script Date: 2023.08.18. 23:05:21 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[userrolesetting]( [Id] [int] IDENTITY(1,1) NOT NULL, [Name] [varchar](100) NOT NULL, [DefaultValue] [varchar](100) NULL, [IsDeleted] [tinyint] NOT NULL, CONSTRAINT [PK__usersett__3214EC07E74868B6] 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