28 lines
4.2 KiB
Plaintext
28 lines
4.2 KiB
Plaintext
CREATE TABLE [dbo].[Projects] (
|
|
[Id] INT IDENTITY (1, 1) NOT NULL,
|
|
[ProjectName] NVARCHAR (50) DEFAULT ('Default') NOT NULL,
|
|
[OutPath] NVARCHAR (MAX) DEFAULT ('') NOT NULL,
|
|
[Created] SMALLDATETIME DEFAULT (getdate()) NOT NULL,
|
|
[LastUpdated] SMALLDATETIME DEFAULT (getdate()) NOT NULL,
|
|
[HologramWidth] FLOAT (53) DEFAULT ((30)) NOT NULL,
|
|
[HologramHeight] FLOAT (53) DEFAULT ((30)) NOT NULL,
|
|
[FrameWidth] FLOAT (53) DEFAULT ((0.2)) NOT NULL,
|
|
[FrameHeight] FLOAT (53) DEFAULT ((0.15)) NOT NULL,
|
|
[FrameResolutionX] INT DEFAULT ((1024)) NOT NULL,
|
|
[FrameResolutionY] INT DEFAULT ((768)) NOT NULL,
|
|
[GrayRangeHigh] INT DEFAULT ((255)) NOT NULL,
|
|
[GrayRangeLow] INT DEFAULT ((50)) NOT NULL,
|
|
PRIMARY KEY CLUSTERED ([Id] ASC)
|
|
);
|
|
|
|
|
|
SET IDENTITY_INSERT [dbo].[Projects] ON
|
|
INSERT INTO [dbo].[Projects] ([Id], [ProjectName], [OutPath], [Created], [LastUpdated], [HologramWidth], [HologramHeight], [FrameWidth], [FrameHeight], [FrameResolutionX], [FrameResolutionY], [GrayRangeHigh], [GrayRangeLow]) VALUES (3007, N'my test project 2', N'C:\Download\Proekty\DotMatrix\ProjectResources\Treko_Kolja\Treko\Koliny fajly po Treko3D\Face\TEST', N'2018-07-10 15:58:00', N'2018-07-28 15:09:00', 30, 30, 0.20000000298023224, 0.15000000596046448, 1024, 768, 55, 255)
|
|
INSERT INTO [dbo].[Projects] ([Id], [ProjectName], [OutPath], [Created], [LastUpdated], [HologramWidth], [HologramHeight], [FrameWidth], [FrameHeight], [FrameResolutionX], [FrameResolutionY], [GrayRangeHigh], [GrayRangeLow]) VALUES (3009, N'Flower - Trubochkina', N'', N'2018-07-11 18:53:00', N'2018-07-11 18:53:00', 30, 30, 0.2, 0.15, 1024, 768, 50, 255)
|
|
INSERT INTO [dbo].[Projects] ([Id], [ProjectName], [OutPath], [Created], [LastUpdated], [HologramWidth], [HologramHeight], [FrameWidth], [FrameHeight], [FrameResolutionX], [FrameResolutionY], [GrayRangeHigh], [GrayRangeLow]) VALUES (3010, N'Project1 -Treko', N'', N'2018-07-13 18:07:00', N'2018-07-13 18:07:00', 30, 30, 2, 15, 1024, 768, 50, 255)
|
|
INSERT INTO [dbo].[Projects] ([Id], [ProjectName], [OutPath], [Created], [LastUpdated], [HologramWidth], [HologramHeight], [FrameWidth], [FrameHeight], [FrameResolutionX], [FrameResolutionY], [GrayRangeHigh], [GrayRangeLow]) VALUES (3011, N'Treko3D Project', N'', N'2018-07-15 22:39:00', N'2018-07-15 22:39:00', 30, 30, 2, 15, 1024, 768, 50, 255)
|
|
INSERT INTO [dbo].[Projects] ([Id], [ProjectName], [OutPath], [Created], [LastUpdated], [HologramWidth], [HologramHeight], [FrameWidth], [FrameHeight], [FrameResolutionX], [FrameResolutionY], [GrayRangeHigh], [GrayRangeLow]) VALUES (3015, N'Face', N'', N'2018-07-16 11:55:00', N'2018-07-16 11:55:00', 30, 30, 0.2, 0.15, 1024, 768, 50, 255)
|
|
INSERT INTO [dbo].[Projects] ([Id], [ProjectName], [OutPath], [Created], [LastUpdated], [HologramWidth], [HologramHeight], [FrameWidth], [FrameHeight], [FrameResolutionX], [FrameResolutionY], [GrayRangeHigh], [GrayRangeLow]) VALUES (3017, N'Test2 - Treko - Treko3D', N'C:\Download\Proekty\DotMatrix\ProjectResources\Treko_Kolja\Treko\Koliny fajly po Treko3D\Face\TEST', N'2018-07-20 22:42:00', N'2018-07-28 15:11:00', 30, 30, 0.40000000596046448, 0.22499999403953552, 1920, 1080, 50, 255)
|
|
INSERT INTO [dbo].[Projects] ([Id], [ProjectName], [OutPath], [Created], [LastUpdated], [HologramWidth], [HologramHeight], [FrameWidth], [FrameHeight], [FrameResolutionX], [FrameResolutionY], [GrayRangeHigh], [GrayRangeLow]) VALUES (3020, N'dddeeefffaaauuulllttt', N'C:\Download\Proekty\DotMatrix\ProjectResources\Treko_Kolja\Treko\Koliny fajly po Treko3D\Face\TEST', N'2018-07-24 12:35:00', N'2018-07-28 14:48:00', 30, 30, 0.20000000298023224, 0.15000000596046448, 1024, 768, 55, 255)
|
|
INSERT INTO [dbo].[Projects] ([Id], [ProjectName], [OutPath], [Created], [LastUpdated], [HologramWidth], [HologramHeight], [FrameWidth], [FrameHeight], [FrameResolutionX], [FrameResolutionY], [GrayRangeHigh], [GrayRangeLow]) VALUES (3027, N'Test Default', N'C:\Download\Proekty\DotMatrix\ProjectResources\Treko_Kolja\Treko\Koliny fajly po Treko3D\Face\TEST', N'2018-07-28 16:26:00', N'2018-07-28 16:27:00', 30, 30, 0.20000000298023224, 0.15000000596046448, 1024, 768, 55, 255)
|
|
SET IDENTITY_INSERT [dbo].[Projects] OFF |