about summary refs log tree commit diff stats
path: root/series/core/trunk/instadisc.sql
diff options
context:
space:
mode:
Diffstat (limited to 'series/core/trunk/instadisc.sql')
-rw-r--r--series/core/trunk/instadisc.sql44
1 files changed, 44 insertions, 0 deletions
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 @@
1-- phpMyAdmin SQL Dump
2-- version 2.9.1.1
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Sep 06, 2008 at 05:38 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 `personal` varchar(5) NOT NULL,
41 PRIMARY KEY (`id`),
42 UNIQUE KEY `identity` (`identity`,`url`)
43) ENGINE=MyISAM DEFAULT CHARSET=latin1;
44