API tools faq
paste
Advertisement
Guest User

MCUTables and data

a guest
May 6th, 2015
296
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.91 KB | None | 0 0
raw download clone embed print report
  1. CREATE TABLE [dbo].[MCU] (
  2. [MCUId] INT NOT NULL,
  3. [Room] NVARCHAR (50) NOT NULL,
  4. [Facility] NVARCHAR (50) NOT NULL,
  5. [UserName] NVARCHAR (256) NOT NULL,
  6. [GroupName] NVARCHAR (50) DEFAULT (NULL) NULL,
  7. [FanStatus] BIT DEFAULT ('0') NOT NULL,
  8. [LightStatus] BIT DEFAULT ('0') NOT NULL,
  9. [PumpStatus] BIT DEFAULT ('0') NOT NULL,
  10. [CropType] NVARCHAR (50) DEFAULT ('Crop1') NOT NULL,
  11. [StartDate] DATE DEFAULT (getdate()) NOT NULL,
  12. [LightOn] TIME (0) DEFAULT ('00:00:00') NOT NULL,
  13. [LightOff] TIME (0) DEFAULT ('00:00:00') NOT NULL,
  14. [TotalLight] INT DEFAULT ((720)) NOT NULL,
  15. PRIMARY KEY CLUSTERED ([MCUId] ASC),
  16. FOREIGN KEY ([UserName]) REFERENCES [dbo].[AspNetUsers] ([UserName])
  17. );
  18.  
  19. INSERT INTO [dbo].[MCU] ([MCUId], [Room], [Facility], [UserName], [GroupName], [FanStatus], [LightStatus], [PumpStatus], [CropType], [StartDate], [LightOn], [LightOff], [TotalLight]) VALUES (1, N'Room 307', N'GroLab', N'frederica58chan@gmail.com', NULL, 1, 1, 0, N'Lettuce', N'2015-04-13', N'12:00:00', N'00:00:00', 720)
  20. INSERT INTO [dbo].[MCU] ([MCUId], [Room], [Facility], [UserName], [GroupName], [FanStatus], [LightStatus], [PumpStatus], [CropType], [StartDate], [LightOn], [LightOff], [TotalLight]) VALUES (2, N'Room 307', N'GroLab', N'frederica58chan@gmail.com', NULL, 1, 0, 0, N'Lettuce', N'2015-04-13', N'12:00:00', N'00:00:00', 720)
  21. INSERT INTO [dbo].[MCU] ([MCUId], [Room], [Facility], [UserName], [GroupName], [FanStatus], [LightStatus], [PumpStatus], [CropType], [StartDate], [LightOn], [LightOff], [TotalLight]) VALUES (3, N'Room 405', N'GroLab', N'frederica58chan@gmail.com', N'Basil2015', 0, 1, 1, N'Basil', N'2015-03-15', N'12:00:00', N'00:00:00', 720)
  22. INSERT INTO [dbo].[MCU] ([MCUId], [Room], [Facility], [UserName], [GroupName], [FanStatus], [LightStatus], [PumpStatus], [CropType], [StartDate], [LightOn], [LightOff], [TotalLight]) VALUES (4, N'Room 405', N'GroLab', N'frederica58chan@gmail.com', N'Basil2015', 0, 1, 0, N'Basil', N'2015-03-15', N'12:00:00', N'00:00:00', 720)
  23. INSERT INTO [dbo].[MCU] ([MCUId], [Room], [Facility], [UserName], [GroupName], [FanStatus], [LightStatus], [PumpStatus], [CropType], [StartDate], [LightOn], [LightOff], [TotalLight]) VALUES (5, N'Room 405', N'GroLab', N'frederica58chan@gmail.com', N'Basil2015', 1, 1, 0, N'Basil', N'2015-03-15', N'12:00:00', N'00:00:00', 720)
  24. INSERT INTO [dbo].[MCU] ([MCUId], [Room], [Facility], [UserName], [GroupName], [FanStatus], [LightStatus], [PumpStatus], [CropType], [StartDate], [LightOn], [LightOff], [TotalLight]) VALUES (301, N'Room 2109', N'AgriCrop', N'critte18@students.rowan.edu', N'Tomato2015', 1, 1, 0, N'Tomato', N'2015-03-01', N'12:00:00', N'00:00:00', 720)
  25. INSERT INTO [dbo].[MCU] ([MCUId], [Room], [Facility], [UserName], [GroupName], [FanStatus], [LightStatus], [PumpStatus], [CropType], [StartDate], [LightOn], [LightOff], [TotalLight]) VALUES (302, N'Room 2109', N'AgriCrop', N'critte18@students.rowan.edu', N'Tomato2015', 0, 1, 1, N'Tomato', N'2015-03-01', N'12:00:00', N'00:00:00', 720)
  26. INSERT INTO [dbo].[MCU] ([MCUId], [Room], [Facility], [UserName], [GroupName], [FanStatus], [LightStatus], [PumpStatus], [CropType], [StartDate], [LightOn], [LightOff], [TotalLight]) VALUES (303, N'Room 1068', N'AgriCrop', N'critte18@students.rowan.edu', NULL, 1, 0, 1, N'Carrot', N'2015-02-14', N'12:00:00', N'00:00:00', 720)
  27. INSERT INTO [dbo].[MCU] ([MCUId], [Room], [Facility], [UserName], [GroupName], [FanStatus], [LightStatus], [PumpStatus], [CropType], [StartDate], [LightOn], [LightOff], [TotalLight]) VALUES (304, N'Room 1068', N'AgriCrop', N'critte18@students.rowan.edu', NULL, 1, 1, 0, N'Carrot', N'2015-02-14', N'12:00:00', N'00:00:00', 720)
  28. INSERT INTO [dbo].[MCU] ([MCUId], [Room], [Facility], [UserName], [GroupName], [FanStatus], [LightStatus], [PumpStatus], [CropType], [StartDate], [LightOn], [LightOff], [TotalLight]) VALUES (305, N'Room 1068', N'AgriCrop', N'critte18@students.rowan.edu', N'Carrot12Light', 0, 1, 1, N'Carrot', N'2015-02-14', N'12:00:00', N'00:00:00', 720)
  29. INSERT INTO [dbo].[MCU] ([MCUId], [Room], [Facility], [UserName], [GroupName], [FanStatus], [LightStatus], [PumpStatus], [CropType], [StartDate], [LightOn], [LightOff], [TotalLight]) VALUES (310, N'Room 1068', N'AgriCrop', N'critte18@students.rowan.edu', N'Carrot12Light', 0, 0, 0, N'Carrot', N'2015-04-25', N'12:00:00', N'00:00:00', 720)
  30. INSERT INTO [dbo].[MCU] ([MCUId], [Room], [Facility], [UserName], [GroupName], [FanStatus], [LightStatus], [PumpStatus], [CropType], [StartDate], [LightOn], [LightOff], [TotalLight]) VALUES (320, N'Room 2109', N'AgriCrop', N'critte18@students.rowan.edu', N'Carrot12Light', 0, 0, 0, N'Carrot', N'2015-04-26', N'12:00:00', N'00:00:00', 720)
  31. INSERT INTO [dbo].[MCU] ([MCUId], [Room], [Facility], [UserName], [GroupName], [FanStatus], [LightStatus], [PumpStatus], [CropType], [StartDate], [LightOn], [LightOff], [TotalLight]) VALUES (450, N'Room 307', N'GroLab', N'frederica58chan@gmail.com', N'', 0, 0, 0, N'Dill', N'2015-05-03', N'08:30:00', N'17:30:00', 721)
  32. INSERT INTO [dbo].[MCU] ([MCUId], [Room], [Facility], [UserName], [GroupName], [FanStatus], [LightStatus], [PumpStatus], [CropType], [StartDate], [LightOn], [LightOff], [TotalLight]) VALUES (934, N'Room 307', N'GroLab', N'frederica58chan@gmail.com', N'', 0, 0, 0, N'Tomato', N'2015-04-25', N'12:00:00', N'00:00:00', 720)
  33. INSERT INTO [dbo].[MCU] ([MCUId], [Room], [Facility], [UserName], [GroupName], [FanStatus], [LightStatus], [PumpStatus], [CropType], [StartDate], [LightOn], [LightOff], [TotalLight]) VALUES (939, N'Room 307', N'GroLab', N'frederica58chan@gmail.com', N'', 0, 0, 0, N'Tomato', N'2015-04-25', N'12:00:00', N'00:00:00', 720)
  34. INSERT INTO [dbo].[MCU] ([MCUId], [Room], [Facility], [UserName], [GroupName], [FanStatus], [LightStatus], [PumpStatus], [CropType], [StartDate], [LightOn], [LightOff], [TotalLight]) VALUES (1020, N'Room 405', N'GroLab', N'frederica58chan@gmail.com', N'', 0, 0, 0, N'Tomato', N'2015-04-26', N'12:00:00', N'00:00:00', 720)
  35.  
  36.  
  37. CREATE TABLE [dbo].[MCUData] (
  38. [MCUId] INT NOT NULL,
  39. [UserName] NVARCHAR(256) NULL FOREIGN KEY ([UserName]) REFERENCES [dbo].[AspNetUsers] ([UserName]),
  40. [Temperature] DECIMAL (5, 2) NOT NULL,
  41. [CO2] DECIMAL (5, 2) NOT NULL,
  42. [Humidity] DECIMAL (5, 2) NOT NULL,
  43. [Photo] IMAGE NULL,
  44. [Time] DATETIME NOT NULL,
  45. FOREIGN KEY ([MCUId]) REFERENCES [dbo].[MCU] ([MCUId])
  46. );
  47.  
  48. INSERT INTO [dbo].[MCUData] ([MCUId], [UserName], [Temperature], [CO2], [Humidity], [Photo], [Time]) VALUES (1, N'frederica58chan@gmail.com', CAST(75.09 AS Decimal(5, 2)), CAST(45.00 AS Decimal(5, 2)), CAST(12.00 AS Decimal(5, 2)), <SQLVARIANT>, N'2015-01-01 12:03:45')
  49. INSERT INTO [dbo].[MCUData] ([MCUId], [UserName], [Temperature], [CO2], [Humidity], [Photo], [Time]) VALUES (1, N'frederica58chan@gmail.com', CAST(75.13 AS Decimal(5, 2)), CAST(44.29 AS Decimal(5, 2)), CAST(12.01 AS Decimal(5, 2)), <SQLVARIANT>, N'2015-01-01 12:13:34')
  50. INSERT INTO [dbo].[MCUData] ([MCUId], [UserName], [Temperature], [CO2], [Humidity], [Photo], [Time]) VALUES (1, N'frederica58chan@gmail.com', CAST(75.06 AS Decimal(5, 2)), CAST(44.31 AS Decimal(5, 2)), CAST(12.00 AS Decimal(5, 2)), <SQLVARIANT>, N'2015-01-01 12:23:56')
  51. INSERT INTO [dbo].[MCUData] ([MCUId], [UserName], [Temperature], [CO2], [Humidity], [Photo], [Time]) VALUES (1, N'frederica58chan@gmail.com', CAST(75.07 AS Decimal(5, 2)), CAST(44.52 AS Decimal(5, 2)), CAST(11.99 AS Decimal(5, 2)), <SQLVARIANT>, N'2015-01-01 12:33:33')
  52. INSERT INTO [dbo].[MCUData] ([MCUId], [UserName], [Temperature], [CO2], [Humidity], [Photo], [Time]) VALUES (1, N'frederica58chan@gmail.com', CAST(75.06 AS Decimal(5, 2)), CAST(44.45 AS Decimal(5, 2)), CAST(12.00 AS Decimal(5, 2)), <SQLVARIANT>, N'2015-01-01 12:43:45')
  53. INSERT INTO [dbo].[MCUData] ([MCUId], [UserName], [Temperature], [CO2], [Humidity], [Photo], [Time]) VALUES (2, N'frederica58chan@gmail.com', CAST(45.31 AS Decimal(5, 2)), CAST(56.00 AS Decimal(5, 2)), CAST(45.00 AS Decimal(5, 2)), <SQLVARIANT>, N'2015-05-01 08:07:31')
  54. INSERT INTO [dbo].[MCUData] ([MCUId], [UserName], [Temperature], [CO2], [Humidity], [Photo], [Time]) VALUES (2, NULL, CAST(45.29 AS Decimal(5, 2)), CAST(56.02 AS Decimal(5, 2)), CAST(45.03 AS Decimal(5, 2)), <SQLVARIANT>, N'2015-05-01 08:17:43')
  55. INSERT INTO [dbo].[MCUData] ([MCUId], [UserName], [Temperature], [CO2], [Humidity], [Photo], [Time]) VALUES (2, NULL, CAST(45.29 AS Decimal(5, 2)), CAST(56.02 AS Decimal(5, 2)), CAST(45.03 AS Decimal(5, 2)), <SQLVARIANT>, N'2015-05-01 08:17:43')
  56. INSERT INTO [dbo].[MCUData] ([MCUId], [UserName], [Temperature], [CO2], [Humidity], [Photo], [Time]) VALUES (2, NULL, CAST(45.29 AS Decimal(5, 2)), CAST(56.02 AS Decimal(5, 2)), CAST(45.03 AS Decimal(5, 2)), <SQLVARIANT>, N'2015-05-01 08:17:43')
  57. INSERT INTO [dbo].[MCUData] ([MCUId], [UserName], [Temperature], [CO2], [Humidity], [Photo], [Time]) VALUES (2, NULL, CAST(45.29 AS Decimal(5, 2)), CAST(56.02 AS Decimal(5, 2)), CAST(45.03 AS Decimal(5, 2)), <SQLVARIANT>, N'2015-05-01 08:17:43')
  58. INSERT INTO [dbo].[MCUData] ([MCUId], [UserName], [Temperature], [CO2], [Humidity], [Photo], [Time]) VALUES (2, NULL, CAST(45.29 AS Decimal(5, 2)), CAST(56.02 AS Decimal(5, 2)), CAST(45.03 AS Decimal(5, 2)), <SQLVARIANT>, N'2015-05-01 08:17:43')
  59. INSERT INTO [dbo].[MCUData] ([MCUId], [UserName], [Temperature], [CO2], [Humidity], [Photo], [Time]) VALUES (2, NULL, CAST(45.29 AS Decimal(5, 2)), CAST(56.02 AS Decimal(5, 2)), CAST(45.03 AS Decimal(5, 2)), <SQLVARIANT>, N'2015-05-01 08:17:43')
  60. INSERT INTO [dbo].[MCUData] ([MCUId], [UserName], [Temperature], [CO2], [Humidity], [Photo], [Time]) VALUES (2, NULL, CAST(45.29 AS Decimal(5, 2)), CAST(56.02 AS Decimal(5, 2)), CAST(45.03 AS Decimal(5, 2)), <SQLVARIANT>, N'2015-05-01 08:17:43')
  61. INSERT INTO [dbo].[MCUData] ([MCUId], [UserName], [Temperature], [CO2], [Humidity], [Photo], [Time]) VALUES (2, N'frederica58chan@gmail.com', CAST(45.31 AS Decimal(5, 2)), CAST(57.02 AS Decimal(5, 2)), CAST(45.23 AS Decimal(5, 2)), <SQLVARIANT>, N'2015-05-01 08:27:34')
  62. INSERT INTO [dbo].[MCUData] ([MCUId], [UserName], [Temperature], [CO2], [Humidity], [Photo], [Time]) VALUES (2, N'frederica58chan@gmail.com', CAST(46.99 AS Decimal(5, 2)), CAST(57.02 AS Decimal(5, 2)), CAST(45.20 AS Decimal(5, 2)), <SQLVARIANT>, N'2015-05-01 08:37:34')
  63. INSERT INTO [dbo].[MCUData] ([MCUId], [UserName], [Temperature], [CO2], [Humidity], [Photo], [Time]) VALUES (2, N'frederica58chan@gmail.com', CAST(46.73 AS Decimal(5, 2)), CAST(56.93 AS Decimal(5, 2)), CAST(45.03 AS Decimal(5, 2)), <SQLVARIANT>, N'2015-05-01 08:47:45')
  64. INSERT INTO [dbo].[MCUData] ([MCUId], [UserName], [Temperature], [CO2], [Humidity], [Photo], [Time]) VALUES (2, N'frederica58chan@gmail.com', CAST(46.34 AS Decimal(5, 2)), CAST(56.34 AS Decimal(5, 2)), CAST(45.03 AS Decimal(5, 2)), <SQLVARIANT>, N'2015-05-01 08:57:54')
  65. INSERT INTO [dbo].[MCUData] ([MCUId], [UserName], [Temperature], [CO2], [Humidity], [Photo], [Time]) VALUES (2, N'frederica58chan@gmail.com', CAST(46.02 AS Decimal(5, 2)), CAST(56.13 AS Decimal(5, 2)), CAST(45.15 AS Decimal(5, 2)), <SQLVARIANT>, N'2015-05-01 09:07:32')
  66. INSERT INTO [dbo].[MCUData] ([MCUId], [UserName], [Temperature], [CO2], [Humidity], [Photo], [Time]) VALUES (450, N'frederica58chan@gmail.com', CAST(32.00 AS Decimal(5, 2)), CAST(100.00 AS Decimal(5, 2)), CAST(35.00 AS Decimal(5, 2)), <SQLVARIANT>, N'2015-05-02 12:05:32')
  67. INSERT INTO [dbo].[MCUData] ([MCUId], [UserName], [Temperature], [CO2], [Humidity], [Photo], [Time]) VALUES (450, N'frederica58chan@gmail.com', CAST(72.00 AS Decimal(5, 2)), CAST(30.00 AS Decimal(5, 2)), CAST(99.99 AS Decimal(5, 2)), <SQLVARIANT>, N'2015-05-02 12:15:32')
  68. INSERT INTO [dbo].[MCUData] ([MCUId], [UserName], [Temperature], [CO2], [Humidity], [Photo], [Time]) VALUES (450, N'frederica58chan@gmail.com', CAST(95.03 AS Decimal(5, 2)), CAST(56.00 AS Decimal(5, 2)), CAST(86.32 AS Decimal(5, 2)), <SQLVARIANT>, N'2015-05-02 12:25:34')
  69. INSERT INTO [dbo].[MCUData] ([MCUId], [UserName], [Temperature], [CO2], [Humidity], [Photo], [Time]) VALUES (450, N'frederica58chan@gmail.com', CAST(34.34 AS Decimal(5, 2)), CAST(57.00 AS Decimal(5, 2)), CAST(12.00 AS Decimal(5, 2)), <SQLVARIANT>, N'2015-05-02 12:35:34')
  70. INSERT INTO [dbo].[MCUData] ([MCUId], [UserName], [Temperature], [CO2], [Humidity], [Photo], [Time]) VALUES (450, N'frederica58chan@gmail.com', CAST(56.12 AS Decimal(5, 2)), CAST(45.03 AS Decimal(5, 2)), CAST(23.05 AS Decimal(5, 2)), <SQLVARIANT>, N'2015-05-02 12:45:34')
  71. INSERT INTO [dbo].[MCUData] ([MCUId], [UserName], [Temperature], [CO2], [Humidity], [Photo], [Time]) VALUES (450, N'frederica58chan@gmail.com', CAST(78.92 AS Decimal(5, 2)), CAST(95.10 AS Decimal(5, 2)), CAST(48.93 AS Decimal(5, 2)), <SQLVARIANT>, N'2015-05-02 12:55:34')
  72. INSERT INTO [dbo].[MCUData] ([MCUId], [UserName], [Temperature], [CO2], [Humidity], [Photo], [Time]) VALUES (450, N'frederica58chan@gmail.com', CAST(45.02 AS Decimal(5, 2)), CAST(83.09 AS Decimal(5, 2)), CAST(49.02 AS Decimal(5, 2)), <SQLVARIANT>, N'2015-05-02 13:05:05')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!