From 44c3bc48b5db7b3dc6517d2b073a55af5d4b52db Mon Sep 17 00:00:00 2001 From: Kelly Rauchenberger Date: Wed, 10 Sep 2008 21:06:49 +0000 Subject: Series: Moved around directory structure Refs #55 --- series/trunk/instadisc.sql | 44 ++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 44 insertions(+) create mode 100644 series/trunk/instadisc.sql (limited to 'series/trunk/instadisc.sql') diff --git a/series/trunk/instadisc.sql b/series/trunk/instadisc.sql new file mode 100644 index 0000000..8954446 --- /dev/null +++ b/series/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