Misc notes for menu dev
For changing sizes for a particular item to only have certain sizes, you need to create another group then assign sizes to that group this limits the entire group of items to a certain size
Make sure to login as the revadmin / L0muQ@352 user first
To enable the browser go to regedit.exe
HKEY_LOCAL_MACHINE
User that auto logs in is Revention
Windows Auto Logon
There are 3 disks
C: Main 19.5 GB
R: Data 20.4 GB
D: 113MB
Microsoft SQL Server Management Studio
10.0.1600.22 ((SQL_PreRelease).080709-1414 )
Microsoft Data Access Components (MDAC)
6.1.7601.17514 (win7sp1_rtm.101119-1850)
Microsoft MSXML 3.0 6.0
Microsoft Internet Explorer 9.0.8112.16443
Microsoft .NET Framework 2.0.50727.5485
Operating System 6.1.7601
USE [Revention] GO /****** Object: Table [dbo].[CustomerAddr] Script Date: 08/20/2018 09:37:59 ******/ CREATE TABLE [dbo].[CustomerAddr]( [AddrKey] [int] IDENTITY(1,1) NOT NULL, [StNumber] [nvarchar](15) NULL, [Street] [nvarchar](50) NULL, [Apt] [nvarchar](25) NULL, [City] [nvarchar](25) NULL, [State] [nvarchar](20) NULL, [Zip] [nvarchar](20) NULL, [AddrType] [nvarchar](10) NOT NULL, [CompanyName] [nvarchar](50) NULL, [EntryCode] [nvarchar](20) NULL, [AddrZone] [nvarchar](25) NULL, [CrossStreet] [nvarchar](40) NULL, [AddrGrid] [nvarchar](10) NULL, [BadChecksAddr] [bit] NOT NULL, [DoNotDeliver] [bit] NOT NULL, [EntSync] [datetime] NULL, [SyncStatus] [int] NOT NULL, [EntID] [int] NOT NULL, CONSTRAINT [PK_CustomerAddr] PRIMARY KEY CLUSTERED ( [AddrKey] 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 ALTER TABLE [dbo].[CustomerAddr] ADD CONSTRAINT [DF__CustomerA__BadCh__3CFEF876] DEFAULT (0) FOR [BadChecksAddr] GO ALTER TABLE [dbo].[CustomerAddr] ADD CONSTRAINT [DF__CustomerA__DoNot__23FE4082] DEFAULT (0) FOR [DoNotDeliver] GO ALTER TABLE [dbo].[CustomerAddr] ADD DEFAULT ((0)) FOR [SyncStatus] GO ALTER TABLE [dbo].[CustomerAddr] ADD DEFAULT ((0)) FOR [EntID] GO
USE [Revention] GO /****** Object: Table [dbo].[Customer] Script Date: 08/20/2018 09:36:32 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Customer]( [CustomerKey] [int] IDENTITY(1,1) NOT NULL, [AddrKey] [int] NULL, [LastName] [nvarchar](25) NULL, [FirstName] [nvarchar](25) NULL, [CustID] [nvarchar](25) NULL, [SpNote] [nvarchar](100) NOT NULL, [DelNote] [nvarchar](100) NOT NULL, [FirstOrdDate] [datetime] NULL, [LastOrdDate] [datetime] NULL, [LastOrdNum] [int] NOT NULL, [OrdCnt] [int] NOT NULL, [OrdAmt] [money] NOT NULL, [TaxExempt] [bit] NOT NULL, [TaxNum] [nvarchar](25) NULL, [AcceptChecks] [bit] NOT NULL, [LastChanged] [smalldatetime] NULL, [Created] [smalldatetime] NULL, [BadChecksCust] [bit] NOT NULL, [PctDiscount] [decimal](18, 3) NOT NULL, [Points] [int] NOT NULL, [Email] [nvarchar](80) NOT NULL, [PctDiscAppr] [int] NOT NULL, [FirstOLDate] [datetime] NULL, [LastOLDate] [datetime] NULL, [OLCnt] [int] NOT NULL, [OLAmt] [money] NOT NULL, [OptOut] [bit] NOT NULL, [LoyaltyPoints] [int] NOT NULL, [LoyaltyCredit] [money] NOT NULL, [AVSZip] [nvarchar](10) NOT NULL, [AVSStNum] [nvarchar](8) NOT NULL, [AVSManual] [bit] NOT NULL, [CpnUsage] [nvarchar](120) NOT NULL, [RewardsMember] [bit] NOT NULL, [LoyaltyNum] [nvarchar](30) NOT NULL, [EntSync] [datetime] NULL, [SyncStatus] [int] NOT NULL, [EntID] [int] NOT NULL, CONSTRAINT [PK_Customer] PRIMARY KEY CLUSTERED ( [CustomerKey] 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 ALTER TABLE [dbo].[Customer] ADD CONSTRAINT [DF_Customer_SpNote] DEFAULT (N' ') FOR [SpNote] GO ALTER TABLE [dbo].[Customer] ADD CONSTRAINT [DF_Customer_DelNote] DEFAULT (N' ') FOR [DelNote] GO ALTER TABLE [dbo].[Customer] ADD CONSTRAINT [DF_Customer_LastOrdNum] DEFAULT (0) FOR [LastOrdNum] GO ALTER TABLE [dbo].[Customer] ADD CONSTRAINT [DF_Customer_OrdCnt] DEFAULT (0) FOR [OrdCnt] GO ALTER TABLE [dbo].[Customer] ADD CONSTRAINT [DF_Customer_OrdAmt] DEFAULT (0) FOR [OrdAmt] GO ALTER TABLE [dbo].[Customer] ADD CONSTRAINT [DF_Customer_TaxExempt] DEFAULT (0) FOR [TaxExempt] GO ALTER TABLE [dbo].[Customer] ADD CONSTRAINT [DF_Customer_AcceptChecks] DEFAULT (0) FOR [AcceptChecks] GO ALTER TABLE [dbo].[Customer] ADD DEFAULT (0) FOR [BadChecksCust] GO ALTER TABLE [dbo].[Customer] ADD DEFAULT (0) FOR [PctDiscount] GO ALTER TABLE [dbo].[Customer] ADD DEFAULT ((0)) FOR [Points] GO ALTER TABLE [dbo].[Customer] ADD DEFAULT ('') FOR [Email] GO ALTER TABLE [dbo].[Customer] ADD DEFAULT ((0)) FOR [PctDiscAppr] GO ALTER TABLE [dbo].[Customer] ADD DEFAULT ((0)) FOR [OLCnt] GO ALTER TABLE [dbo].[Customer] ADD DEFAULT ((0)) FOR [OLAmt] GO ALTER TABLE [dbo].[Customer] ADD DEFAULT ((0)) FOR [OptOut] GO ALTER TABLE [dbo].[Customer] ADD DEFAULT ((0)) FOR [LoyaltyPoints] GO ALTER TABLE [dbo].[Customer] ADD DEFAULT ((0)) FOR [LoyaltyCredit] GO ALTER TABLE [dbo].[Customer] ADD DEFAULT ('') FOR [AVSZip] GO ALTER TABLE [dbo].[Customer] ADD DEFAULT ('') FOR [AVSStNum] GO ALTER TABLE [dbo].[Customer] ADD DEFAULT ((0)) FOR [AVSManual] GO ALTER TABLE [dbo].[Customer] ADD DEFAULT ('') FOR [CpnUsage] GO ALTER TABLE [dbo].[Customer] ADD DEFAULT ((0)) FOR [RewardsMember] GO ALTER TABLE [dbo].[Customer] ADD DEFAULT ('') FOR [LoyaltyNum] GO ALTER TABLE [dbo].[Customer] ADD DEFAULT ((0)) FOR [SyncStatus] GO ALTER TABLE [dbo].[Customer] ADD DEFAULT ((0)) FOR [EntID] GO
USE [Revention] GO /****** Object: Table [dbo].[CustAcct] Script Date: 08/20/2018 09:34:33 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[CustAcct]( [CustAcctKey] [int] IDENTITY(1,1) NOT NULL, [AcctNum] [int] NOT NULL, [CustKey] [int] NOT NULL, [AcctBalance] [money] NOT NULL, [AcctStatus] [nvarchar](10) NULL, [CreditLimit] [money] NOT NULL, [AvailableCredit] [money] NOT NULL, [DateOpened] [datetime] NULL, [OpenedByEmplKey] [int] NOT NULL, PRIMARY KEY CLUSTERED ( [CustAcctKey] 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 ALTER TABLE [dbo].[CustAcct] ADD DEFAULT ((0)) FOR [AcctNum] GO ALTER TABLE [dbo].[CustAcct] ADD DEFAULT ((0)) FOR [CustKey] GO ALTER TABLE [dbo].[CustAcct] ADD DEFAULT ((0)) FOR [AcctBalance] GO ALTER TABLE [dbo].[CustAcct] ADD DEFAULT ((0)) FOR [CreditLimit] GO ALTER TABLE [dbo].[CustAcct] ADD DEFAULT ((0)) FOR [AvailableCredit] GO ALTER TABLE [dbo].[CustAcct] ADD DEFAULT ((0)) FOR [OpenedByEmplKey] GO
/****** Object: Table [dbo].[InventVendor] Script Date: 08/08/2018 12:42:56 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[InventVendor]( [InventVendorKey] [int] IDENTITY(1,1) NOT NULL, [Name] [nvarchar](25) NULL, [Addr1] [nvarchar](25) NULL, [Addr2] [nvarchar](25) NULL, [City] [nvarchar](25) NULL, [State] [nvarchar](15) NULL, [Zip] [nvarchar](15) NULL, [Phone] [nvarchar](25) NULL, [Fax] [nvarchar](25) NULL, [VendorID] [nvarchar](25) NULL, [SalesRep] [nvarchar](50) NULL, [Terms] [nvarchar](50) NULL, [Note] [nvarchar](255) NULL, [EntSync] [datetime] NULL, [SyncStatus] [int] NOT NULL, [EntID] [int] NOT NULL, PRIMARY KEY CLUSTERED ( [InventVendorKey] 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 ALTER TABLE [dbo].[InventVendor] ADD DEFAULT ((0)) FOR [SyncStatus] GO ALTER TABLE [dbo].[InventVendor] ADD DEFAULT ((0)) FOR [EntID] GO