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

Contents of /trunk/TSAdminTool/UpdateDatabase2.sql

Parent Directory Parent Directory | Revision Log Revision Log


Revision 134 - (show annotations) (download) (as text)
Sun Jul 15 05:13:20 2012 UTC (9 years ago) by william
File MIME type: application/octet-stream
File size: 2450 byte(s)
Unable to calculate annotation data on binary file contents.
+ 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.1 to 1.0.0.2 (ATS 3.0)
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 [ServerPort] [int] NULL,
12
13 [NumLock] [bit] NULL,
14
15 [Created] [datetime] NULL CONSTRAINT [DF_Client_Created] DEFAULT (getdate()),
16
17 [Modified] [datetime] NULL CONSTRAINT [DF_Client_Modified] DEFAULT (getdate()),
18
19 [IcaApplicationSet] [nvarchar](200) NULL,
20
21 [IcaServer] [nvarchar](200) NULL,
22
23 [TempString] [nvarchar](200) NULL,
24
25 [TempBit] [bit] NULL,
26
27 [TempInt] [int] NULL
28
29 GO
30
31 UPDATE [dbo].[Client] set [ServerPort] = -1
32
33 UPDATE [dbo].[Client] set [Numlock] = 1
34
35 UPDATE [dbo].[Client] set [Created] = GETDATE()
36
37 UPDATE [dbo].[Client] set [Modified] = GETDATE()
38
39 GO
40
41 CREATE NONCLUSTERED INDEX [IX_Client_Created] ON [dbo].[Client]
42
43 (
44
45 [Created] ASC
46
47 )WITH (PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]
48
49 ALTER TABLE [dbo].[AppInfo]
50
51 ADD CONSTRAINT [PK_AppInfo] PRIMARY KEY CLUSTERED
52
53 ([Property] ASC)
54
55 WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
56
57 GO
58
59 UPDATE [dbo].[AppInfo] set Value='1.0.0.2' where
60
61 Property='Version'

Properties

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

  ViewVC Help
Powered by ViewVC 1.1.22