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

Contents of /trunk/TSAdminTool/UpdateDatabase3.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, 2 months ago) by william
File MIME type: application/octet-stream
File size: 1386 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.2 to 1.0.0.3 (ATS 3.2)
2
3 USE [AnywhereTS]
4
5 GO
6
7 -- The AnywhereTS client images.
8
9 ALTER TABLE [dbo].[Image] ADD
10
11 [Debug] [int] NULL,
12
13 [BootPackage] [int] NULL,
14
15 [BootPictureWidth] [int] NULL,
16
17 [BootPictureHeight] [int] NULL,
18
19 [BootPictureProgressBar] [int] NULL,
20
21 [BootPicturePng] [image] NULL
22
23 GO
24
25 UPDATE [dbo].[Image] set [Debug] = 0
26
27 UPDATE [dbo].[Image] set [BootPackage] = 1
28
29 UPDATE [dbo].[Image] set [BootPictureWidth] = 1024
30
31 UPDATE [dbo].[Image] set [BootPictureHeight] = 768
32
33 UPDATE [dbo].[Image] set [BootPictureProgressBar] = 0
34
35 GO
36
37 UPDATE [dbo].[AppInfo] set Value='1.0.0.3' where
38
39 Property='Version'

Properties

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

  ViewVC Help
Powered by ViewVC 1.1.22