Commit Diff

Commit:
73c195712944b60fd577e279aee8d91176e77412
From:
mischa <mischa@rx.high5.nl>
Date:
Message:
README added PRIMARY KEY
Actions:
Patch | Tree
commit - a7e8264c4943b38205bfb9640340bc2b4b5cafbf
commit + 73c195712944b60fd577e279aee8d91176e77412
blob - 86974558e0cb8929c12837a079f2ed7b8b404117
blob + d6f240dff9c6b07ec6f9a02c3c59cefee44e03cf
--- README.md
+++ README.md
@@ -6,13 +6,13 @@ Database and table needed, build on MariaDB / MySQL:
 
 	CREATE DATABASE IF NOT EXISTS `shortr` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
 	USE `shortr`;
-
 	CREATE TABLE `urls` (
 	  `id` varchar(255) NOT NULL,
 	  `url` text DEFAULT NULL,
 	  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
 	  `ip` varchar(255) DEFAULT NULL,
-	  `count` int(11) NOT NULL
+	  `count` int(11) NOT NULL,
+          PRIMARY KEY (`id`)
 	) ENGINE=InnoDB DEFAULT CHARSET=latin1;