CREATE TABLE register (
  id            INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT,
  name          VARCHAR(50) NOT NULL,
  type          VARCHAR(50) NOT NULL,
  description   TEXT DEFAULT NULL,
  serialnumber  VARCHAR(50) DEFAULT NULL,
  createdate    TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

INSERT INTO register (name, type, description, serialnumber, createdate) 
VALUES
('Nikon', 'Camera', 'Special model of camera width wide object', '45E1234AE1', '2024-02-15 08:35:37'),
('IBM', 'Notebook', 'AMD/4GB/500GB', '151234IBM', '2024-02-15 08:35:37'),
('Canon', 'Scanner', 'Portable scanner, USB', 'CA341512341', '2024-02-15 08:35:37'),
('Canon', 'Camera', 'Compact camera model 500', 'CA123451234', '2024-02-15 08:35:37'),
('Canon EOS', 'Camera', 'Digital system camera', '4A12E1234', '2024-02-15 09:57:10');