From 5ea1322236d3b07f0a6601071d6756cec8eed590 Mon Sep 17 00:00:00 2001
From: Gabriel Dunne <gdunne@quilime.com>
Date: Sat, 19 Nov 2011 20:56:27 -0800
Subject: [PATCH] added mysql schema

---
 clmpr.sql | 28 ++++++++++++++++++++++++++++
 index.php | 10 +++++-----
 2 files changed, 33 insertions(+), 5 deletions(-)
 create mode 100644 clmpr.sql

diff --git a/clmpr.sql b/clmpr.sql
new file mode 100644
index 0000000..cf99eea
--- /dev/null
+++ b/clmpr.sql
@@ -0,0 +1,28 @@
+SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
+
+-- Database: `clmpr`
+
+
+-- Table structure for table `clumps`
+
+CREATE TABLE IF NOT EXISTS `clumps` (
+  `id` int(9) NOT NULL AUTO_INCREMENT,
+  `user_id` int(9) NOT NULL,
+  `title` varchar(255) NOT NULL,
+  `location` varchar(255) NOT NULL,
+  `tags` varchar(255) NOT NULL,
+  `date` datetime NOT NULL,
+  PRIMARY KEY (`id`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=239 ;
+
+
+-- Table structure for table `users`
+
+CREATE TABLE IF NOT EXISTS `users` (
+  `id` int(9) NOT NULL AUTO_INCREMENT,
+  `user` varchar(255) NOT NULL,
+  `pass` varchar(255) NOT NULL,
+  `created` datetime NOT NULL,
+  PRIMARY KEY (`id`),
+  UNIQUE KEY `user` (`user`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;
diff --git a/index.php b/index.php
index 31d0341..aa3977a 100644
--- a/index.php
+++ b/index.php
@@ -14,13 +14,13 @@
     switch($endpoint)
     {
         case 'about' :
-	    echo "clmpr is a place to save hyperlinks";
-	    echo '<br/>&copy; 2011 <a href="http://quilime.com">quilime</a>';
-	exit;
-            break;
+            include 'head.html';
+            echo "clmpr is a place to save hyperlinks";
+            echo '<br /><a href="https://github.com/quilime/clmpr">source on github</a>';
+            echo '<br />&copy; 2011 <a href="http://quilime.com">quilime</a>';
+            exit;
 
         default :
-
             if ($endpoint != '') {
 
                 $dbh = get_db_connection();
-- 
2.34.1