about summary refs log tree commit diff stats
path: root/series/trunk/instadisc.sql
diff options
context:
space:
mode:
authorKelly Rauchenberger <fefferburbia@gmail.com>2008-09-18 21:59:23 +0000
committerKelly Rauchenberger <fefferburbia@gmail.com>2008-09-18 21:59:23 +0000
commitfd3f2cbdaa1e3c160727c3cf09ef03d06174c114 (patch)
tree12ea30a00c68891f2fbc01f5b2730bc6edc153aa /series/trunk/instadisc.sql
parentd2a7b26e98569624347d717d7fdfe6c3074658a9 (diff)
downloadinstadisc-fd3f2cbdaa1e3c160727c3cf09ef03d06174c114.tar.gz
instadisc-fd3f2cbdaa1e3c160727c3cf09ef03d06174c114.tar.bz2
instadisc-fd3f2cbdaa1e3c160727c3cf09ef03d06174c114.zip
Series: Removed Series component
Refs #57
Diffstat (limited to 'series/trunk/instadisc.sql')
-rw-r--r--series/trunk/instadisc.sql59
1 files changed, 0 insertions, 59 deletions
diff --git a/series/trunk/instadisc.sql b/series/trunk/instadisc.sql deleted file mode 100644 index 3e5071d..0000000 --- a/series/trunk/instadisc.sql +++ /dev/null
@@ -1,59 +0,0 @@
1-- phpMyAdmin SQL Dump
2-- version 2.9.1.1
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Sep 14, 2008 at 12:41 PM
7-- Server version: 5.0.51
8-- PHP Version: 5.2.4-2ubuntu5.3
9--
10-- Database: `instadisc_series`
11--
12
13-- --------------------------------------------------------
14
15--
16-- Table structure for table `config`
17--
18
19DROP TABLE IF EXISTS `config`;
20CREATE TABLE `config` (
21 `name` varchar(255) NOT NULL,
22 `value` varchar(255) NOT NULL,
23 PRIMARY KEY (`name`)
24) ENGINE=MyISAM DEFAULT CHARSET=latin1;
25
26-- --------------------------------------------------------
27
28--
29-- Table structure for table `subscriptions`
30--
31
32DROP TABLE IF EXISTS `subscriptions`;
33CREATE TABLE `subscriptions` (
34 `id` int(11) NOT NULL auto_increment,
35 `identity` varchar(255) NOT NULL,
36 `title` varchar(255) NOT NULL,
37 `url` varchar(255) NOT NULL,
38 `category` varchar(255) NOT NULL,
39 `password` varchar(255) NOT NULL,
40 `username` varchar(255) NOT NULL,
41 `lastUpdated` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
42 PRIMARY KEY (`id`),
43 UNIQUE KEY `identity` (`identity`,`url`)
44) ENGINE=MyISAM DEFAULT CHARSET=latin1;
45
46-- --------------------------------------------------------
47
48--
49-- Table structure for table `users`
50--
51
52DROP TABLE IF EXISTS `users`;
53CREATE TABLE `users` (
54 `id` int(11) NOT NULL auto_increment,
55 `username` varchar(255) NOT NULL,
56 `password` varchar(255) NOT NULL,
57 PRIMARY KEY (`id`)
58) ENGINE=MyISAM DEFAULT CHARSET=latin1;
59