1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
| /*
| Navicat Premium Data Transfer
|
| Source Server : DESKTOP-SCT31AM
| Source Server Type : SQL Server
| Source Server Version : 13001601
| Source Catalog : WIDESEA_DB
| Source Schema : dbo
|
| Target Server Type : SQL Server
| Target Server Version : 13001601
| File Encoding : 65001
|
| Date: 25/01/2024 11:03:06
| */
|
|
| -- ----------------------------
| -- Table structure for dt_geometry_data
| -- ----------------------------
| IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[dt_geometry_data]') AND type IN ('U'))
| DROP TABLE [dbo].[dt_geometry_data]
| GO
|
| CREATE TABLE [dbo].[dt_geometry_data] (
| [TypeId] int IDENTITY(1,1) NOT NULL,
| [Description] nvarchar(100) COLLATE Chinese_PRC_CI_AS NOT NULL,
| [a] float(53) NOT NULL,
| [b] float(53) NOT NULL,
| [c] float(53) NOT NULL,
| [d] float(53) NOT NULL,
| [e] float(53) NOT NULL,
| [f] float(53) NOT NULL,
| [g] float(53) NOT NULL,
| [h] float(53) NOT NULL
| )
| GO
|
| ALTER TABLE [dbo].[dt_geometry_data] SET (LOCK_ESCALATION = TABLE)
| GO
|
|
| -- ----------------------------
| -- Records of dt_geometry_data
| -- ----------------------------
| SET IDENTITY_INSERT [dbo].[dt_geometry_data] ON
| GO
|
| INSERT INTO [dbo].[dt_geometry_data] ([TypeId], [Description], [a], [b], [c], [d], [e], [f], [g], [h]) VALUES (N'1', N'TSW-003D (915KKD)', N'69', N'12', N'126', N'-28', N'972', N'185', N'27', N'70')
| GO
|
| INSERT INTO [dbo].[dt_geometry_data] ([TypeId], [Description], [a], [b], [c], [d], [e], [f], [g], [h]) VALUES (N'2', N'TSW-051 (840HESA)', N'70', N'12', N'128', N'-30', N'900', N'197', N'27', N'70')
| GO
|
| INSERT INTO [dbo].[dt_geometry_data] ([TypeId], [Description], [a], [b], [c], [d], [e], [f], [g], [h]) VALUES (N'3', N'TSW-005 (840HDSA)', N'70', N'12', N'128', N'-30', N'898', N'185', N'27', N'70')
| GO
|
| SET IDENTITY_INSERT [dbo].[dt_geometry_data] OFF
| GO
|
|
| -- ----------------------------
| -- Auto increment value for dt_geometry_data
| -- ----------------------------
| DBCC CHECKIDENT ('[dbo].[dt_geometry_data]', RESEED, 3)
| GO
|
|
| -- ----------------------------
| -- Primary Key structure for table dt_geometry_data
| -- ----------------------------
| ALTER TABLE [dbo].[dt_geometry_data] ADD CONSTRAINT [PK__dt_geome__516F03B53F710A80] PRIMARY KEY CLUSTERED ([TypeId])
| WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
| ON [PRIMARY]
| GO
|
|
