Nick/BigLitho
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
master
BigLitho/Large.Lito.Database/Make3_Treko3D/Docs/SQL Scripts/Layers.txt

39 lines
7.2 KiB
Plaintext
Raw Permalink Blame History

CREATE TABLE [dbo].[Layers] (
[Id] INT IDENTITY (1, 1) NOT NULL,
[Order] INT DEFAULT ((0)) NOT NULL,
[LayerName] NVARCHAR (50) DEFAULT ('Default') NOT NULL,
[TechnologyName] NVARCHAR (50) DEFAULT ('Treko') NOT NULL,
[OpticalSchema] NVARCHAR (50) DEFAULT ('SP0') NOT NULL,
[ProjectId] INT DEFAULT ((1)) NOT NULL,
[TechnologyId] INT DEFAULT ((0)) NOT NULL,
[ArcWidth] INT DEFAULT ((15)) NOT NULL,
[RadiusMax] FLOAT (53) DEFAULT ((4.8)) NOT NULL,
[Step] FLOAT (53) DEFAULT ((15)) NOT NULL,
[SourceFilePath] NVARCHAR (MAX) DEFAULT ('') NOT NULL,
[AnglesFilePath] NVARCHAR (MAX) DEFAULT ('') NOT NULL,
[FullMask] INT NULL,
[TileMask] INT NULL,
PRIMARY KEY CLUSTERED ([Id] ASC),
FOREIGN KEY ([ProjectId]) REFERENCES [dbo].[Projects] ([Id])
);
SET IDENTITY_INSERT [dbo].[Layers] ON
INSERT INTO [dbo].[Layers] ([Id], [Order], [LayerName], [TechnologyName], [OpticalSchema], [ProjectId], [TechnologyId], [ArcWidth], [RadiusMax], [Step], [SourceFilePath], [AnglesFilePath], [FullMask], [TileMask]) VALUES (22, 2, N'Layer1 - Treko', N'Treko', N'SC0', 3007, 0, 15, 4.8000001907348633, 0.15000000596046448, N'C:\Download\Proekty\DotMatrix\ProjectResources\Treko_Kolja\Treko\Koliny fajly po Treko3D\Face', N'', NULL, NULL)
INSERT INTO [dbo].[Layers] ([Id], [Order], [LayerName], [TechnologyName], [OpticalSchema], [ProjectId], [TechnologyId], [ArcWidth], [RadiusMax], [Step], [SourceFilePath], [AnglesFilePath], [FullMask], [TileMask]) VALUES (32, 3, N'Layer4-Treko', N'Treko', N'SC0', 3007, 0, 15, 4.8000001907348633, 0.15000000596046448, N'C:\Download\Proekty\DotMatrix\ProjectResources\Treko_Kolja\Treko\Koliny fajly po Treko3D\Face', N'', NULL, NULL)
INSERT INTO [dbo].[Layers] ([Id], [Order], [LayerName], [TechnologyName], [OpticalSchema], [ProjectId], [TechnologyId], [ArcWidth], [RadiusMax], [Step], [SourceFilePath], [AnglesFilePath], [FullMask], [TileMask]) VALUES (33, 1, N'Layer5 - Treko3D', N'Treko3D', N'SC0', 3007, 0, 15, 4.8000001907348633, 0.15000000596046448, N'C:\Download\Proekty\DotMatrix\ProjectResources\Treko_Kolja\Treko\Koliny fajly po Treko3D\Face', N'', NULL, NULL)
INSERT INTO [dbo].[Layers] ([Id], [Order], [LayerName], [TechnologyName], [OpticalSchema], [ProjectId], [TechnologyId], [ArcWidth], [RadiusMax], [Step], [SourceFilePath], [AnglesFilePath], [FullMask], [TileMask]) VALUES (35, 0, N'Layer6 - Treko3D', N'Treko3D', N'SC0', 3007, 0, 15, 4.8000001907348633, 0.15000000596046448, N'C:\Download\Proekty\DotMatrix\ProjectResources\Treko_Kolja\Treko\Koliny fajly po Treko3D\Face', N'', NULL, NULL)
INSERT INTO [dbo].[Layers] ([Id], [Order], [LayerName], [TechnologyName], [OpticalSchema], [ProjectId], [TechnologyId], [ArcWidth], [RadiusMax], [Step], [SourceFilePath], [AnglesFilePath], [FullMask], [TileMask]) VALUES (36, 1, N'Layer0 Treko', N'Treko', N'SC0', 3010, 0, 15, 4.8, 0.15, N'', N'', NULL, NULL)
INSERT INTO [dbo].[Layers] ([Id], [Order], [LayerName], [TechnologyName], [OpticalSchema], [ProjectId], [TechnologyId], [ArcWidth], [RadiusMax], [Step], [SourceFilePath], [AnglesFilePath], [FullMask], [TileMask]) VALUES (37, 2, N'Layer1 - Treko3D', N'Treko3D', N'SC0', 3010, 0, 15, 4.8, 0.15, N'', N'', NULL, NULL)
INSERT INTO [dbo].[Layers] ([Id], [Order], [LayerName], [TechnologyName], [OpticalSchema], [ProjectId], [TechnologyId], [ArcWidth], [RadiusMax], [Step], [SourceFilePath], [AnglesFilePath], [FullMask], [TileMask]) VALUES (41, 3, N'Layer2 - Treko', N'Treko', N'SP0', 3010, 0, 15, 4.8, 0.15, N'', N'', NULL, NULL)
INSERT INTO [dbo].[Layers] ([Id], [Order], [LayerName], [TechnologyName], [OpticalSchema], [ProjectId], [TechnologyId], [ArcWidth], [RadiusMax], [Step], [SourceFilePath], [AnglesFilePath], [FullMask], [TileMask]) VALUES (42, 0, N'Layer3 - Treko', N'Treko', N'SP1', 3010, 0, 15, 4.8, 0.15, N'', N'', NULL, NULL)
INSERT INTO [dbo].[Layers] ([Id], [Order], [LayerName], [TechnologyName], [OpticalSchema], [ProjectId], [TechnologyId], [ArcWidth], [RadiusMax], [Step], [SourceFilePath], [AnglesFilePath], [FullMask], [TileMask]) VALUES (43, 4, N'Layer1 - Treko3D', N'Treko3D', N'SP0', 3010, 0, 15, 4.8, 0.15, N'', N'', NULL, NULL)
INSERT INTO [dbo].[Layers] ([Id], [Order], [LayerName], [TechnologyName], [OpticalSchema], [ProjectId], [TechnologyId], [ArcWidth], [RadiusMax], [Step], [SourceFilePath], [AnglesFilePath], [FullMask], [TileMask]) VALUES (44, 5, N'Layer1 - Treko3D', N'Treko3D', N'SP0', 3010, 0, 15, 4.8, 0.15, N'', N'', NULL, NULL)
INSERT INTO [dbo].[Layers] ([Id], [Order], [LayerName], [TechnologyName], [OpticalSchema], [ProjectId], [TechnologyId], [ArcWidth], [RadiusMax], [Step], [SourceFilePath], [AnglesFilePath], [FullMask], [TileMask]) VALUES (54, 0, N'Treko3D', N'Treko3D', N'SC0', 3015, 0, 15, 4.8, 0.15, N'', N'', NULL, NULL)
INSERT INTO [dbo].[Layers] ([Id], [Order], [LayerName], [TechnologyName], [OpticalSchema], [ProjectId], [TechnologyId], [ArcWidth], [RadiusMax], [Step], [SourceFilePath], [AnglesFilePath], [FullMask], [TileMask]) VALUES (57, 0, N'Treko3D-2', N'Treko3D', N'SP0', 3017, 0, 15, 4.9, 0.16, N'C:\Download\Proekty\DotMatrix\ProjectResources\Treko_Kolja\Treko\Koliny fajly po Treko3D\Face', N'', NULL, NULL)
INSERT INTO [dbo].[Layers] ([Id], [Order], [LayerName], [TechnologyName], [OpticalSchema], [ProjectId], [TechnologyId], [ArcWidth], [RadiusMax], [Step], [SourceFilePath], [AnglesFilePath], [FullMask], [TileMask]) VALUES (59, 0, N'dddeeefffaaauuulllttt', N'Treko3D', N'SP0', 3020, 0, 15, 4.8, 0.15, N'C:\Download\Proekty\DotMatrix\ProjectResources\Treko_Kolja\Treko\Koliny fajly po Treko3D\Face', N'', NULL, NULL)
INSERT INTO [dbo].[Layers] ([Id], [Order], [LayerName], [TechnologyName], [OpticalSchema], [ProjectId], [TechnologyId], [ArcWidth], [RadiusMax], [Step], [SourceFilePath], [AnglesFilePath], [FullMask], [TileMask]) VALUES (60, 0, N'dddeeefffaaauuulllttt', N'Treko', N'SP0', 3020, 0, 20, 5, 0.3, N'C:\Download\Proekty\DotMatrix\ProjectResources\Treko_Kolja\Treko\test1.bmp', N'C:\Download\Proekty\DotMatrix\ProjectResources\Treko_Kolja\Treko\ang.ini', NULL, NULL)
INSERT INTO [dbo].[Layers] ([Id], [Order], [LayerName], [TechnologyName], [OpticalSchema], [ProjectId], [TechnologyId], [ArcWidth], [RadiusMax], [Step], [SourceFilePath], [AnglesFilePath], [FullMask], [TileMask]) VALUES (73, 1, N'Layer1 - Treko', N'Treko', N'SP0', 3017, 0, 20, 5, 0.300000011920929, N'C:\Download\Proekty\DotMatrix\ProjectResources\Treko_Kolja\Treko\test1.bmp', N'', NULL, NULL)
INSERT INTO [dbo].[Layers] ([Id], [Order], [LayerName], [TechnologyName], [OpticalSchema], [ProjectId], [TechnologyId], [ArcWidth], [RadiusMax], [Step], [SourceFilePath], [AnglesFilePath], [FullMask], [TileMask]) VALUES (74, 0, N'Layer0 - Treko', N'Treko', N'SP0', 3027, 0, 15, 4.8, 0.15, N'C:\Download\Proekty\DotMatrix\ProjectResources\Treko_Kolja\Treko\test1.bmp', N'', NULL, NULL)
INSERT INTO [dbo].[Layers] ([Id], [Order], [LayerName], [TechnologyName], [OpticalSchema], [ProjectId], [TechnologyId], [ArcWidth], [RadiusMax], [Step], [SourceFilePath], [AnglesFilePath], [FullMask], [TileMask]) VALUES (75, 1, N'Layer1 - Treko3D', N'Treko3D', N'SP0', 3027, 0, 15, 4.8, 0.15, N'C:\Download\Proekty\DotMatrix\ProjectResources\Treko_Kolja\Treko\3d', N'', NULL, NULL)
SET IDENTITY_INSERT [dbo].[Layers] OFF
Reference in New Issue View Git Blame Copy Permalink