Guest User

DBExemple

a guest
Oct 21st, 2016
104
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE Data
  2.     ([ID] int, [Color] varchar(6), [Type] varchar(5), [Type2] varchar(4), [Name] varchar(7), [Sci_Name] varchar(5), [Version] varchar(20), [Date] datetime, [Foreign_ID] int)
  3. ;
  4.    
  5. INSERT INTO Data
  6.     ([ID], [Color], [Type], [Type2], [Name], [Sci_Name], [Version], [Date], [Foreign_ID])
  7. VALUES
  8.     (1, 'Red', 'Type1', NULL, 'Monica', 'Life', 'software version 7.0', '2017-09-10 02:00:00', 4),
  9.     (2, 'Blue', 'Type2', NULL, 'Erica', 'Side', 'software version 7.0', '2017-09-10 02:00:00', 5),
  10.     (3, 'Yellow', 'Type2', NULL, 'Rita', 'Need', 'software version 7.0', '2017-09-10 02:00:00', 6),
  11.     (4, 'Red', 'Type1', NULL, 'Tina', 'See', 'software version 7.0', '2017-09-10 02:00:00', 7),
  12.     (5, 'Red', 'Type1', NULL, 'Sandra', 'Sun', 'software version 7.0', '2017-09-10 02:00:00', 1),
  13.     (6, 'Blue', 'Type1', NULL, 'Mary', 'Night', 'software version 7.0', '2017-09-10 02:00:00', 2),
  14.     (7, 'Yellow', 'Type2', NULL, 'Jessica', 'Here', 'software version 7.0', '2017-09-10 02:00:00', 5)
  15. ;
  16.  
  17. CREATE TABLE Parameter
  18.     ([Column_Name] varchar(9), [ByteValue] int)
  19. ;    
  20. INSERT INTO Parameter
  21.     ([Column_Name], [ByteValue])
  22. VALUES
  23.     ('Color', 0),
  24.     ('Type', 1),
  25.     ('Type2', 2),
  26.     ('Name', 3),
  27.     ('Sci_Name', 4),
  28.     ('Alias', 5),
  29.     ('Version', 6),
  30.     ('Firmware', 7),
  31.     ('Brand', 8),
  32.     ('Avaidable', 9)
  33. ;
RAW Paste Data