diff options
Diffstat (limited to 'series/core')
-rw-r--r-- | series/core/trunk/instadisc.sql | 44 |
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 | |||
19 | DROP TABLE IF EXISTS `config`; | ||
20 | CREATE 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 | |||
32 | DROP TABLE IF EXISTS `subscriptions`; | ||
33 | CREATE 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 | |||