--
-- Host: localhost    Database: stellan
-- ------------------------------------------------------


--
-- Current Database: `stellan`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `stellan` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */;

USE `stellan`;

--
-- Table structure for table `link`
--

CREATE TABLE `link` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `adress` longtext NOT NULL,
  `rubrik` varchar(255) NOT NULL,
  `bild` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `link`
--

INSERT INTO `link` VALUES
(1,'https://chat.openai.com/auth/login','ChatGpt','../bilder/chatgpt.png'),
(2,'https://online.swedbank.se/app/ib/logga-in','Swedbank','../bilder/swedbank.jpg'),
(3,'https://budget.stellan.tv/index.php','Budget','../bilder/budget.jpg'),
(13,'https://app.plex.tv/desktop/#!','Plex','../bilder/plex.jpg'),
(14,'https://mail.eposten.tv/owa/auth/logon.aspx?replaceCurrent=1&url=https%3a%2f%2fmail.eposten.tv%2fecp%2f','Eposten','../bilder/exchange.png');

--
-- Table structure for table `todo`
--

CREATE TABLE `todo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rubrik` text NOT NULL,
  `text` longtext NOT NULL,
  `datum` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `todo`
--

INSERT INTO `todo` VALUES
(2,'Hans Engfeldt','äta pizza o läsk','2023-08-20'),
(3,'Kalle','kattförsäkring','2023-08-20'),
(5,'en ny rad till','testar att lägga till en ny rad och att janne spelar trumpet och fiol samt piano','2023-08-19');


