--~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
--  Customer Service Kiosk ini_schemas
--
--  Project:    Customer Service Kiosk
--  Design:     Un-Managed Devices
--  Date:       20-July-2007
--  Where:      Pharos Systems Ltd
--  Who:        Frank Caico
--  Version:    1.0
--
--  Description:
--    Add and update Customer Service Kiosk schema Row in ini_schemas
--
--  Columns:
--    ini_schema_id           PK to ini_schemas table
--    ini_schema_name         Unique schema name, identifies the type of EDI terminal
--    ini_schema              XML schema for ini configuration data
--
--  Warning:
--    This software is property of Pharos Systems Inc.
--    Unauthorized use or duplication of this software is strictly prohibited.  
--    Authorized users are subject to the following restrictions:
--    * Neither the author, their corporation, nor Pharos Systems Inc.
--      is responsible for any consequences of the use of this software.
--    * The origin of this software must not be misrepresented either by 
--      explicit claim or by omission.
--    * Altered versions of this software must be plainly marked as such.
--    * This notice may not be removed or altered.
--~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

if not exists (select ini_schema_id from ini_schemas where ini_schema_id = 203)
begin
    insert ini_schemas values (203, 'Customer Service Kiosk', '') 
end

update ini_schemas set ini_schema =
'<?xml version="1.0" encoding="utf-8" ?> 
<!-- version 2.1.0 -->
<PharosIniFileSchema>
	<Header>
		<Device>Customer Service Kiosk US Default</Device>
		<SchemaVersion>1</SchemaVersion>
	</Header>
	<Properties>
		<Property Clonable="true" Advanced="false" Hidden="false" Type="string">
			<IniSection>visualCustomizations</IniSection>
			<IniLabel>Organization</IniLabel>
			<Name>Organization Name</Name>
			<Tab>Customizations</Tab>
			<HelpId>120001</HelpId>
			<Default>Pharos Systems</Default> 
			<TypeAttributes MaxLength="50" AllowBlank="False" /> 
		</Property>
	
		<Property Clonable="true" Advanced="false" Hidden="false" Type="string">
			<IniSection>visualCustomizations</IniSection>
			<IniLabel>RecieptFooter</IniLabel>
			<Name>Cash receipt footer</Name>
			<Tab>Customizations</Tab>
			<HelpId>120001</HelpId>
			<Default>Keep this receipt. It is your only proof of transaction.       - Non-Refundable -</Default> 
			<TypeAttributes MaxLength="100" AllowBlank="False" /> 
		</Property>

		<Property Clonable="true" Advanced="false" Hidden="false" Type="string">
			<IniSection>kioskIdSettings</IniSection>
			<IniLabel>BranchName</IniLabel>
			<Name>Branch Name</Name>
			<Tab>Kiosk Identification</Tab>
			<HelpId>120001</HelpId>
			<Default>Main Branch</Default> 
			<TypeAttributes MaxLength="100" AllowBlank="False" /> 
		</Property>

		<Property Clonable="true" Advanced="false" Hidden="false" Type="string">
			<IniSection>kioskIdSettings</IniSection>
			<IniLabel>TID</IniLabel>
			<Name>TID</Name>
			<Tab>Kiosk Identification</Tab>
			<HelpId>120001</HelpId>
			<Default>CSK01</Default> 
			<TypeAttributes MaxLength="100" AllowBlank="False" /> 
		</Property>
		
		<Property Clonable="true" Advanced="true" Hidden="false" Type="integer">
			<IniSection>kioskIdSettings</IniSection>
			<IniLabel>BranchNumber</IniLabel>
			<Name>Branch Number</Name>
			<Tab>Kiosk Identification</Tab>
			<HelpId>120001</HelpId>
			<Default>1</Default>
			<TypeAttributes Min="0" Max="32353"/>
		</Property>
		
		<Property Clonable="true" Advanced="true" Hidden="false" Type="integer">
			<IniSection>kioskIdSettings</IniSection>
			<IniLabel>KioskNumber</IniLabel>
			<Name>Kiosk Number</Name>
			<Tab>Kiosk Identification</Tab>
			<HelpId>120001</HelpId>
			<Default>1</Default>
			<TypeAttributes Min="0" Max="32353"/>
		</Property>
		
		<Property Clonable="true" Advanced="false" Hidden="false" Type="combobox">
			<IniSection>localAdministrator</IniSection>
			<IniLabel>UseLocalAdmin</IniLabel>
			<Name>Use Local Administrator account</Name>
			<Tab>Admin</Tab>
			<HelpId>120001</HelpId>
			<Default>Yes</Default>
			<TypeAttributes>
				<ListEntry Display="No" IniValue="0" /> 
				<ListEntry Display="Yes" IniValue="1" /> 
  			</TypeAttributes>
		</Property>
		
		<Property Clonable="true" Advanced="false" Hidden="false" Type="string">
			<IniSection>localAdministrator</IniSection>
			<IniLabel>AdminUsername</IniLabel>
			<Name>Administrator Username</Name>
			<Tab>Admin</Tab>
			<HelpId>120001</HelpId>
			<Default>admin</Default> 
			<TypeAttributes MaxLength="25" AllowBlank="False" /> 
		</Property>
		
		<Property Clonable="true" Advanced="false" Hidden="false" Type="string">
			<IniSection>localAdministrator</IniSection>
			<IniLabel>AdminPassword</IniLabel>
			<Name>Administrator Password</Name>
			<Tab>Admin</Tab>
			<HelpId>120001</HelpId>
			<Default>xyzzy</Default> 
			<TypeAttributes MaxLength="25" AllowBlank="False" /> 
		</Property>

		<Property Clonable="true" Advanced="false" Hidden="false" Type="string">
		  <IniSection>emailSettings</IniSection>
		  <IniLabel>SMTPServer</IniLabel>
		  <Name>SMTP Server</Name>
		  <Tab>Email</Tab>
		  <HelpId>120001</HelpId>
		  <Default>pusapiano</Default>
		  <TypeAttributes MaxLength="25" AllowBlank="False" />
		</Property>

		<Property Clonable="true" Advanced="false" Hidden="false" Type="integer">
		  <IniSection>emailSettings</IniSection>
		  <IniLabel>SMTPServerPort</IniLabel>
		  <Name>Port</Name>
		  <Tab>Email</Tab>
		  <HelpId>120001</HelpId>
		  <Default>25</Default>
		  <TypeAttributes Min="0" Max="32353"/>
		</Property>

		<Property Clonable="true" Advanced="false" Hidden="false" Type="integer">
		  <IniSection>emailSettings</IniSection>
		  <IniLabel>AuthenticationMode</IniLabel>
		  <Name>Authentication Mode</Name>
		  <Tab>Email</Tab>
		  <HelpId>120001</HelpId>
		  <Default>1</Default>
		  <TypeAttributes Min="0" Max="3"/>
		</Property>

		<Property Clonable="true" Advanced="false" Hidden="false" Type="string">
		  <IniSection>emailSettings</IniSection>
		  <IniLabel>AuthUsername</IniLabel>
		  <Name>Authorized Username</Name>
		  <Tab>Email</Tab>
		  <HelpId>120001</HelpId>
		  <Default></Default>
		  <TypeAttributes MaxLength="25" AllowBlank="False" />
		</Property>

		<Property Clonable="true" Advanced="false" Hidden="false" Type="string">
		  <IniSection>emailSettings</IniSection>
		  <IniLabel>AuthPassword</IniLabel>
		  <Name>Authorized Password</Name>
		  <Tab>Email</Tab>
		  <HelpId>120001</HelpId>
		  <Default></Default>
		  <TypeAttributes MaxLength="25" AllowBlank="False" />
		</Property>

		<Property Clonable="true" Advanced="false" Hidden="false" Type="string">
		  <IniSection>cashboxSettings</IniSection>
		  <IniLabel>CashboxAdminEmailTO</IniLabel>
		  <Name>Email address to send Cashbox notifications TO</Name>
		  <Tab>Cashbox</Tab>
		  <HelpId>120001</HelpId>
		  <Default>someone@somewhere.com</Default>
		  <TypeAttributes MaxLength="255" AllowBlank="False" />
		</Property>

		<Property Clonable="true" Advanced="false" Hidden="false" Type="string">
		  <IniSection>cashboxSettings</IniSection>
		  <IniLabel>CashboxAdminEmailFROM</IniLabel>
		  <Name>Email address Cashbox notifications should appear FROM</Name>
		  <Tab>Cashbox</Tab>
		  <HelpId>120001</HelpId>
		  <Default>someone@somewhere.com</Default>
		  <TypeAttributes MaxLength="255" AllowBlank="False" />
		</Property>

		<Property Clonable="true" Advanced="false" Hidden="false" Type="double">
		  <IniSection>cashboxSettings</IniSection>
		  <IniLabel>CashboxAdminTimeoutInMinutes</IniLabel>
		  <Name>Cashbox empty procedure timeout (minutes)</Name>
		  <Tab>Cashbox</Tab>
		  <HelpId>120001</HelpId>
		  <Default>5.0</Default>
		  <TypeAttributes Max="60.0" Min="0.0" />
		</Property>

		<Property Clonable="true" Advanced="false" Hidden="false" Type="combobox">
			<IniSection>guestcardSettings</IniSection>
			<IniLabel>EnableGuests</IniLabel>
			<Name>Enable Guest Passes</Name>
			<Tab>Guests</Tab>
			<HelpId>120001</HelpId>
			<Default>Yes</Default>
			<TypeAttributes>
				<ListEntry Display="No" IniValue="0" /> 
				<ListEntry Display="Yes" IniValue="1" /> 
  			</TypeAttributes>
		</Property>

		<Property Clonable="true" Advanced="false" Hidden="false" Type="string">
		  <IniSection>guestcardSettings</IniSection>
		  <IniLabel>UniquePrefix</IniLabel>
		  <Name>Prefix for Guest Card IDs</Name>
		  <Tab>Guests</Tab>
		  <HelpId>120001</HelpId>
		  <Default>CSK1</Default>
		  <TypeAttributes MaxLength="25" AllowBlank="True" />
		</Property>

		<Property Clonable="true" Advanced="false" Hidden="false" Type="string">
		  <IniSection>guestcardSettings</IniSection>
		  <IniLabel>Group</IniLabel>
		  <Name>Group to add guests to</Name>
		  <Tab>Guests</Tab>
		  <HelpId>120001</HelpId>
		  <Default>Guests</Default>
		  <TypeAttributes MaxLength="25" AllowBlank="False" />
		</Property>

		<Property Clonable="true" Advanced="false" Hidden="false" Type="combobox">
		  <IniSection>guestcardSettings</IniSection>
		  <IniLabel>ShowPIN</IniLabel>
		  <Name>Show PIN numbers on Guest Pass?</Name>
		  <Tab>Guests</Tab>
		  <HelpId>120001</HelpId>
		  <Default>Yes</Default>
		  <TypeAttributes>
			<ListEntry Display="No" IniValue="0" />
			<ListEntry Display="Yes" IniValue="1" />
		  </TypeAttributes>
		</Property>

		<Property Clonable="true" Advanced="false" Hidden="false" Type="double">
		  <IniSection>guestcardSettings</IniSection>
		  <IniLabel>MinAmount</IniLabel>
		  <Name>Minimum dollar amount for Guest Pass creation</Name>
		  <Tab>Guests</Tab>
		  <HelpId>120001</HelpId>
		  <Default>0.0</Default>
		  <TypeAttributes Max="9999.9" Min="0.0" />
		</Property>

		<Property Clonable="true" Advanced="false" Hidden="false" Type="double">
		  <IniSection>guestcardSettings</IniSection>
		  <IniLabel>MaxAmount</IniLabel>
		  <Name>Maximum dollar amount allowed on Guest Passes (0 for none)</Name>
		  <Tab>Guests</Tab>
		  <HelpId>120001</HelpId>
		  <Default>0.0</Default>
		  <TypeAttributes Max="20.0" Min="0.0" />
		</Property>

		<Property Clonable="true" Advanced="false" Hidden="false" Type="double">
		  <IniSection>guestcardSettings</IniSection>
		  <IniLabel>GuestCardFee</IniLabel>
		  <Name>Guest Pass Fee</Name>
		  <Tab>Guests</Tab>
		  <HelpId>120001</HelpId>
		  <Default>0.0</Default>
		  <TypeAttributes Max="9999.9" Min="0.0" />
		</Property>
	    
		<Property Clonable="true" Advanced="false" Hidden="false" Type="double">
		  <IniSection>guestcardSettings</IniSection>
		  <IniLabel>GuestCardStartAmount</IniLabel>
		  <Name>Guest Pass creation bonus</Name>
		  <Tab>Guests</Tab>
		  <HelpId>120001</HelpId>
		  <Default>0.0</Default>
		  <TypeAttributes Max="9999.9" Min="0.0" />
		</Property>

		<Property Clonable="true" Advanced="false" Hidden="false" Type="string">
		  <IniSection>guestcardSettings</IniSection>
		  <IniLabel>GuestCardFooter</IniLabel>
		  <Name>Footer to use on Guest Passes</Name>
		  <Tab>Guests</Tab>
		  <HelpId>120001</HelpId>
		  <Default>Keep this pass. It is your only proof of transaction. Valid for one year from last use. - Non-Refundable -</Default>
		  <TypeAttributes MaxLength="1024" AllowBlank="True" />
		</Property>

		<Property Clonable="true" Advanced="false" Hidden="false" Type="string">
		  <IniSection>appSettings</IniSection>
		  <IniLabel>KioskAdministratorEmail</IniLabel>
		  <Name>Email address to send kiosk alerts to</Name>
		  <Tab>Misc</Tab>
		  <HelpId>120001</HelpId>
		  <Default>administrator@yourcompany.com</Default>
		  <TypeAttributes MaxLength="255" AllowBlank="True" />
		</Property>

		<Property Clonable="true" Advanced="false" Hidden="false" Type="double">
		  <IniSection>appSettings</IniSection>
		  <IniLabel>TimeoutInMinutes</IniLabel>
		  <Name>Kiosk inactivity Timeout (in minutes)</Name>
		  <Tab>Misc</Tab>
		  <HelpId>120001</HelpId>
		  <Default>1.0</Default>
		  <TypeAttributes Max="10.0" Min="0.0" />
		</Property>

	</Properties>
</PharosIniFileSchema>' 
where ini_schema_id = 203
go

-- update ini_schemas set ini_schema = '' where ini_schema_id = 901
-- delete from ini_schemas where ini_schema_id = 901
-- select * from ini_schemas