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 | |||
