about summary refs log tree commit diff stats
path: root/central
diff options
context:
space:
mode:
Diffstat (limited to 'central')
-rw-r--r--central/trunk/instadisc.sql16
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