diff options
| author | Kelly Rauchenberger <fefferburbia@gmail.com> | 2008-09-26 22:27:54 +0000 |
|---|---|---|
| committer | Kelly Rauchenberger <fefferburbia@gmail.com> | 2008-09-26 22:27:54 +0000 |
| commit | 50c1fa87dc9a9d081298f9873168d14af1be0921 (patch) | |
| tree | c5cc7db2d54999d92d64f7133fe9fab6750dbd7c /central | |
| parent | e6c31d14ae34334e70ae239dd3706efca047cb0f (diff) | |
| download | instadisc-50c1fa87dc9a9d081298f9873168d14af1be0921.tar.gz instadisc-50c1fa87dc9a9d081298f9873168d14af1be0921.tar.bz2 instadisc-50c1fa87dc9a9d081298f9873168d14af1be0921.zip | |
Central: Completed Step 1
Refs #69
Diffstat (limited to 'central')
| -rw-r--r-- | central/trunk/instadisc.sql | 16 |
1 files changed, 9 insertions, 7 deletions
| diff --git a/central/trunk/instadisc.sql b/central/trunk/instadisc.sql index f64eafc..6d28e2a 100644 --- a/central/trunk/instadisc.sql +++ b/central/trunk/instadisc.sql | |||
| @@ -3,11 +3,11 @@ | |||
| 3 | -- http://www.phpmyadmin.net | 3 | -- http://www.phpmyadmin.net |
| 4 | -- | 4 | -- |
| 5 | -- Host: localhost | 5 | -- Host: localhost |
| 6 | -- Generation Time: Sep 06, 2008 at 10:16 PM | 6 | -- Generation Time: Sep 26, 2008 at 06:23 PM |
| 7 | -- Server version: 5.0.51 | 7 | -- Server version: 5.0.51 |
| 8 | -- PHP Version: 5.2.4-2ubuntu5.3 | 8 | -- PHP Version: 5.2.4-2ubuntu5.3 |
| 9 | -- | 9 | -- |
| 10 | -- Database: `instadisc_central` | 10 | -- Database: `instadisc_test` |
| 11 | -- | 11 | -- |
| 12 | 12 | ||
| 13 | -- -------------------------------------------------------- | 13 | -- -------------------------------------------------------- |
| @@ -22,7 +22,7 @@ CREATE TABLE `config` ( | |||
| 22 | `name` varchar(255) NOT NULL, | 22 | `name` varchar(255) NOT NULL, |
| 23 | `value` varchar(255) NOT NULL, | 23 | `value` varchar(255) NOT NULL, |
| 24 | PRIMARY KEY (`id`) | 24 | PRIMARY KEY (`id`) |
| 25 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | 25 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
| 26 | 26 | ||
| 27 | -- -------------------------------------------------------- | 27 | -- -------------------------------------------------------- |
| 28 | 28 | ||
| @@ -42,7 +42,7 @@ CREATE TABLE `inbox` ( | |||
| 42 | `semantics` text NOT NULL, | 42 | `semantics` text NOT NULL, |
| 43 | `encryptionID` int(11) NOT NULL, | 43 | `encryptionID` int(11) NOT NULL, |
| 44 | PRIMARY KEY (`id`) | 44 | PRIMARY KEY (`id`) |
| 45 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | 45 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
| 46 | 46 | ||
| 47 | -- -------------------------------------------------------- | 47 | -- -------------------------------------------------------- |
| 48 | 48 | ||
| @@ -56,7 +56,7 @@ CREATE TABLE `oldVerID` ( | |||
| 56 | `username` varchar(255) NOT NULL, | 56 | `username` varchar(255) NOT NULL, |
| 57 | `verID` int(11) NOT NULL, | 57 | `verID` int(11) NOT NULL, |
| 58 | PRIMARY KEY (`id`) | 58 | PRIMARY KEY (`id`) |
| 59 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | 59 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
| 60 | 60 | ||
| 61 | -- -------------------------------------------------------- | 61 | -- -------------------------------------------------------- |
| 62 | 62 | ||
| @@ -87,7 +87,7 @@ CREATE TABLE `subscriptions` ( | |||
| 87 | `url` varchar(255) NOT NULL, | 87 | `url` varchar(255) NOT NULL, |
| 88 | `category` varchar(255) NOT NULL, | 88 | `category` varchar(255) NOT NULL, |
| 89 | PRIMARY KEY (`id`) | 89 | PRIMARY KEY (`id`) |
| 90 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | 90 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
| 91 | 91 | ||
| 92 | -- -------------------------------------------------------- | 92 | -- -------------------------------------------------------- |
| 93 | 93 | ||
| @@ -102,7 +102,9 @@ CREATE TABLE `users` ( | |||
| 102 | `password` varchar(255) NOT NULL, | 102 | `password` varchar(255) NOT NULL, |
| 103 | `email` varchar(255) NOT NULL, | 103 | `email` varchar(255) NOT NULL, |
| 104 | `ip` varchar(255) NOT NULL, | 104 | `ip` varchar(255) NOT NULL, |
| 105 | `port` int(11) NOT NULL, | ||
| 105 | `nextItemID` int(11) NOT NULL, | 106 | `nextItemID` int(11) NOT NULL, |
| 107 | `downloadItemMode` varchar(255) NOT NULL, | ||
| 106 | PRIMARY KEY (`id`) | 108 | PRIMARY KEY (`id`) |
| 107 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | 109 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
| 108 | 110 | ||