diff options
Diffstat (limited to 'series/trunk/instadisc.sql')
-rw-r--r-- | series/trunk/instadisc.sql | 59 |
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 | |||
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 | `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 | |||
52 | DROP TABLE IF EXISTS `users`; | ||
53 | CREATE 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 | |||