From 970ec85cad2cc833f0ba4c9e9488952b9aa33575 Mon Sep 17 00:00:00 2001
From: Kelly Rauchenberger <fefferburbia@gmail.com>
Date: Sat, 13 Sep 2008 13:33:19 +0000
Subject: Series: Integrated Update

Refs #55
---
 series/trunk/instadisc.sql | 20 ++++++++++++++++++--
 1 file changed, 18 insertions(+), 2 deletions(-)

(limited to 'series/trunk/instadisc.sql')

diff --git a/series/trunk/instadisc.sql b/series/trunk/instadisc.sql
index 8954446..4c9a816 100644
--- a/series/trunk/instadisc.sql
+++ b/series/trunk/instadisc.sql
@@ -3,7 +3,7 @@
 -- http://www.phpmyadmin.net
 -- 
 -- Host: localhost
--- Generation Time: Sep 06, 2008 at 05:38 PM
+-- Generation Time: Sep 13, 2008 at 09:16 AM
 -- Server version: 5.0.51
 -- PHP Version: 5.2.4-2ubuntu5.3
 -- 
@@ -38,7 +38,23 @@ CREATE TABLE `subscriptions` (
   `category` varchar(255) NOT NULL,
   `password` varchar(255) NOT NULL,
   `personal` varchar(5) NOT NULL,
+  `username` varchar(255) NOT NULL,
+  `lastUpdated` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
   PRIMARY KEY  (`id`),
   UNIQUE KEY `identity` (`identity`,`url`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM  DEFAULT CHARSET=latin1;
+
+-- --------------------------------------------------------
+
+-- 
+-- Table structure for table `users`
+-- 
+
+DROP TABLE IF EXISTS `users`;
+CREATE TABLE `users` (
+  `id` int(11) NOT NULL auto_increment,
+  `username` varchar(255) NOT NULL,
+  `password` varchar(255) NOT NULL,
+  PRIMARY KEY  (`id`)
+) ENGINE=MyISAM  DEFAULT CHARSET=latin1;
 
-- 
cgit 1.4.1

