From ff9420cbde416fa022b6726b643bbad3c2d38659 Mon Sep 17 00:00:00 2001
From: Kelly Rauchenberger <fefferburbia@gmail.com>
Date: Sat, 6 Sep 2008 21:42:52 +0000
Subject: Series: Created database schema

Refs #28
---
 series/core/trunk/instadisc.sql | 44 +++++++++++++++++++++++++++++++++++++++++
 1 file changed, 44 insertions(+)
 create mode 100644 series/core/trunk/instadisc.sql

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

diff --git a/series/core/trunk/instadisc.sql b/series/core/trunk/instadisc.sql
new file mode 100644
index 0000000..8954446
--- /dev/null
+++ b/series/core/trunk/instadisc.sql
@@ -0,0 +1,44 @@
+-- phpMyAdmin SQL Dump
+-- version 2.9.1.1
+-- http://www.phpmyadmin.net
+-- 
+-- Host: localhost
+-- Generation Time: Sep 06, 2008 at 05:38 PM
+-- Server version: 5.0.51
+-- PHP Version: 5.2.4-2ubuntu5.3
+-- 
+-- Database: `instadisc_series`
+-- 
+
+-- --------------------------------------------------------
+
+-- 
+-- Table structure for table `config`
+-- 
+
+DROP TABLE IF EXISTS `config`;
+CREATE TABLE `config` (
+  `name` varchar(255) NOT NULL,
+  `value` varchar(255) NOT NULL,
+  PRIMARY KEY  (`name`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
+-- --------------------------------------------------------
+
+-- 
+-- Table structure for table `subscriptions`
+-- 
+
+DROP TABLE IF EXISTS `subscriptions`;
+CREATE TABLE `subscriptions` (
+  `id` int(11) NOT NULL auto_increment,
+  `identity` varchar(255) NOT NULL,
+  `title` varchar(255) NOT NULL,
+  `url` varchar(255) NOT NULL,
+  `category` varchar(255) NOT NULL,
+  `password` varchar(255) NOT NULL,
+  `personal` varchar(5) NOT NULL,
+  PRIMARY KEY  (`id`),
+  UNIQUE KEY `identity` (`identity`,`url`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
-- 
cgit 1.4.1

