/[AnywhereTS-MSSQL]/trunk/TSAdminTool/UpdateDatabase1.sql
ViewVC logotype

Contents of /trunk/TSAdminTool/UpdateDatabase1.sql

Parent Directory Parent Directory | Revision Log Revision Log


Revision 134 - (show annotations) (download) (as text)
Sun Jul 15 05:13:20 2012 UTC (8 years, 11 months ago) by william
File MIME type: application/octet-stream
File size: 3218 byte(s)
+ fix errors in database
+ logon to 'master' database and refer to our database is sql statments
+ remove empty GO statements from end of .sql files

1 ÿþ-- This is the Anywhere TS main database update script from version 1.0.0.0 to 1.0.0.1
2
3 USE [AnywhereTS]
4
5 GO
6
7 -- The AnywhereTS clients. Used by AnywhereTS and Control panel
8
9 ALTER TABLE [dbo].[Client] ADD
10
11 [DailyReboot] [bit] NULL,
12
13 [KeyboardMap] [nvarchar](12) NULL,
14
15 [TimeZone] [nvarchar](60) NULL,
16
17 [RedirectCom1] [bit] NULL,
18
19 [RedirectCom2] [bit] NULL,
20
21 [UsbDrive] [int] NULL,
22
23 [UsbDriveName] [nvarchar](20) NULL
24
25 GO
26
27 UPDATE [dbo].[Client] set [DailyReboot]=1
28
29 UPDATE [dbo].[Client] set [KeyboardMap]='en_us'
30
31 UPDATE [dbo].[Client] set [TimeZone]='UTC+0'
32
33 UPDATE [dbo].[Client] set [RedirectCom1]=0
34
35 UPDATE [dbo].[Client] set [RedirectCom2]=0
36
37 UPDATE [dbo].[Client] set [UsbDrive]=0
38
39 UPDATE [dbo].[Client] set UsbDriveName='USB_Drive'
40
41 GO
42
43 -- Client images design time options
44
45 CREATE TABLE [dbo].[Image](
46
47 [UseDHCP] [bit] NULL,
48
49 [ClientIPAddress] [nvarchar](39) NULL,
50
51 [ClientIPNetmask] [nvarchar](39) NULL,
52
53 [ClientIPGateway] [nvarchar](39) NULL,
54
55 [ClientIPDNS1] [nvarchar](39) NULL,
56
57 [ClientIPDNS2] [nvarchar](39) NULL,
58
59 [ClientIPDNSSuffix] [nvarchar](200) NULL,
60
61 [ClientBootServer] [nvarchar](200) NULL,
62
63 [ConfigFile] [bit] NULL,
64
65 [OnlyUseRDP] [bit] NULL,
66
67 [BootPicture] [int] NULL,
68
69 [NetworkDriver] [nvarchar](100) NULL,
70
71 [SoundType] [int] NULL,
72
73 [SoundDriver] [nvarchar](100) NULL,
74
75 [Name] [nvarchar](50) NOT NULL,
76
77 [GraphicsDriver] [nvarchar](100) NULL,
78
79 CONSTRAINT [PK_Image] PRIMARY KEY CLUSTERED
80
81 (
82
83 [Name] ASC
84
85 )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
86
87 ) ON [PRIMARY]
88
89 GO
90
91 UPDATE AnywhereTS..AppInfo set Value='1.0.0.1' where
92
93 Property='Version'

Properties

Name Value
svn:mime-type application/octet-stream

  ViewVC Help
Powered by ViewVC 1.1.22