3 -- http://www.phpmyadmin.net
5 -- Generation Time: Jun 12, 2007 at 03:07 PM
6 -- Server version: 5.0.24
12 -- --------------------------------------------------------
15 -- Table structure for table `library_amazon_images`
17 -- Creation: Apr 02, 2007 at 11:13 AM
18 -- Last update: Apr 02, 2007 at 11:13 AM
19 -- Last check: Jun 10, 2007 at 06:44 PM
22 DROP TABLE IF EXISTS `library_amazon_images`;
23 CREATE TABLE IF NOT EXISTS `library_amazon_images` (
24 `asin` varchar(255) NOT NULL,
25 `category` varchar(255) NOT NULL,
26 `size` varchar(20) NOT NULL,
27 `width` int(11) NOT NULL,
28 `height` int(11) NOT NULL,
32 -- --------------------------------------------------------
35 -- Table structure for table `library_amazon_query_log`
37 -- Creation: Mar 25, 2007 at 06:44 AM
38 -- Last update: Mar 25, 2007 at 06:44 AM
39 -- Last check: Jun 10, 2007 at 06:44 PM
42 DROP TABLE IF EXISTS `library_amazon_query_log`;
43 CREATE TABLE IF NOT EXISTS `library_amazon_query_log` (
44 `query_url` text NOT NULL,
45 `time` timestamp NULL,
49 -- --------------------------------------------------------
52 -- Table structure for table `library_book_authors`
54 -- Creation: Apr 02, 2007 at 11:13 AM
55 -- Last update: Apr 02, 2007 at 11:13 AM
56 -- Last check: Jun 10, 2007 at 06:44 PM
59 DROP TABLE IF EXISTS `library_book_authors`;
60 CREATE TABLE IF NOT EXISTS `library_book_authors` (
61 `id` char(36) NOT NULL,
62 `author` text NOT NULL,
64 FULLTEXT KEY `author` (`author`)
67 -- --------------------------------------------------------
70 -- Table structure for table `library_book_info`
72 -- Creation: Apr 02, 2007 at 11:13 AM
73 -- Last update: Apr 02, 2007 at 11:13 AM
74 -- Last check: Jun 10, 2007 at 06:44 PM
77 DROP TABLE IF EXISTS `library_book_info`;
78 CREATE TABLE IF NOT EXISTS `library_book_info` (
79 `id` char(36) NOT NULL,
80 `isbn` varchar(10) default NULL,
81 `ean` varchar(13) default NULL,
83 `binding` varchar(255) default NULL,
84 `deweydecimal` float default NULL,
86 `published` date default NULL,
87 `released` date default NULL,
89 `pages` int(11) default NULL,
90 `height` int(11) default NULL,
91 `heightunits` varchar(255) default NULL,
92 `length` int(11) default NULL,
93 `lengthunits` varchar(255) default NULL,
94 `width` int(11) default NULL,
95 `widthunits` varchar(255) default NULL,
96 `weight` int(11) default NULL,
97 `weightunits` varchar(255) default NULL,
98 `asin` varchar(255) default NULL,
100 `updated` timestamp NULL,
102 KEY `updated` (`updated`),
103 FULLTEXT KEY `title` (`title`)
106 -- --------------------------------------------------------
109 -- Table structure for table `library_dvd_actors`
111 -- Creation: Mar 25, 2007 at 06:44 AM
112 -- Last update: Mar 25, 2007 at 06:44 AM
113 -- Last check: Jun 10, 2007 at 06:44 PM
116 DROP TABLE IF EXISTS `library_dvd_actors`;
117 CREATE TABLE IF NOT EXISTS `library_dvd_actors` (
118 `id` char(36) NOT NULL,
119 `actor` varchar(255) NOT NULL
122 -- --------------------------------------------------------
125 -- Table structure for table `library_dvd_formats`
127 -- Creation: Mar 25, 2007 at 06:44 AM
128 -- Last update: Mar 25, 2007 at 06:44 AM
129 -- Last check: Jun 10, 2007 at 06:44 PM
132 DROP TABLE IF EXISTS `library_dvd_formats`;
133 CREATE TABLE IF NOT EXISTS `library_dvd_formats` (
134 `id` char(36) NOT NULL,
135 `format` varchar(255) NOT NULL
138 -- --------------------------------------------------------
141 -- Table structure for table `library_dvd_info`
143 -- Creation: Mar 25, 2007 at 06:48 AM
144 -- Last update: Mar 25, 2007 at 06:48 AM
145 -- Last check: Jun 10, 2007 at 06:44 PM
148 DROP TABLE IF EXISTS `library_dvd_info`;
149 CREATE TABLE IF NOT EXISTS `library_dvd_info` (
150 `id` char(36) NOT NULL default 'UUID()',
151 `asin` varchar(255) default NULL,
152 `isbn` varchar(10) default NULL,
153 `ean` varchar(13) default NULL,
154 `upc` varchar(14) default NULL,
155 `title` text NOT NULL,
156 `aspectratio` varchar(10) default NULL,
157 `audiencerating` varchar(50) default NULL,
158 `binding` varchar(255) default NULL,
159 `label` varchar(255) default NULL,
160 `manufacturer` varchar(255) default NULL,
161 `studio` varchar(255) default NULL,
162 `publisher` varchar(255) default NULL,
163 `theatricalreleasedate` date default NULL,
164 `originalreleasedate` date default NULL,
165 `releasedate` date default NULL,
166 `regioncode` tinyint(4) default NULL,
167 `runningtime` int(11) default NULL,
168 `numberofitems` int(11) default NULL,
169 `detailpageurl` text,
170 `packageheight` int(11) default NULL,
171 `packagelength` int(11) default NULL,
172 `packagewidth` int(11) default NULL,
173 `packageweight` int(11) default NULL,
174 `listpriceamount` int(11) default NULL,
175 `currencycode` varchar(3) default NULL,
176 `updated` timestamp NOT NULL,
180 -- --------------------------------------------------------
183 -- Table structure for table `library_dvd_languages`
185 -- Creation: Mar 25, 2007 at 06:58 AM
186 -- Last update: Mar 25, 2007 at 06:58 AM
187 -- Last check: Jun 10, 2007 at 06:44 PM
190 DROP TABLE IF EXISTS `library_dvd_languages`;
191 CREATE TABLE IF NOT EXISTS `library_dvd_languages` (
192 `id` char(36) NOT NULL,
193 `language` varchar(255) NOT NULL,
194 `type` varchar(255) NOT NULL
197 -- --------------------------------------------------------
200 -- Table structure for table `library_friends`
202 -- Creation: Mar 25, 2007 at 06:59 AM
203 -- Last update: Mar 25, 2007 at 06:59 AM
204 -- Last check: Jun 10, 2007 at 06:44 PM
207 DROP TABLE IF EXISTS `library_friends`;
208 CREATE TABLE IF NOT EXISTS `library_friends` (
209 `user` char(36) NOT NULL,
210 `friend` char(36) NOT NULL
213 -- --------------------------------------------------------
216 -- Table structure for table `library_libraries`
218 -- Creation: Mar 25, 2007 at 06:59 AM
219 -- Last update: Mar 25, 2007 at 06:59 AM
220 -- Last check: Jun 10, 2007 at 06:44 PM
223 DROP TABLE IF EXISTS `library_libraries`;
224 CREATE TABLE IF NOT EXISTS `library_libraries` (
225 `who` char(36) NOT NULL,
226 `item` char(36) NOT NULL,
227 `own` tinyint(1) NOT NULL default '0',
228 `copies` int(11) NOT NULL,
229 `want` tinyint(1) NOT NULL default '0',
230 `offer` tinyint(1) NOT NULL default '0'
233 -- --------------------------------------------------------
236 -- Table structure for table `library_loans`
238 -- Creation: Mar 25, 2007 at 07:12 AM
239 -- Last update: Mar 25, 2007 at 07:12 AM
240 -- Last check: Jun 10, 2007 at 06:44 PM
243 DROP TABLE IF EXISTS `library_loans`;
244 CREATE TABLE IF NOT EXISTS `library_loans` (
245 `from` char(36) NOT NULL,
246 `to` char(36) NOT NULL,
247 `item` char(36) NOT NULL,
252 -- --------------------------------------------------------
255 -- Table structure for table `library_queue_amazon`
257 -- Creation: Apr 02, 2007 at 11:13 AM
258 -- Last update: Apr 02, 2007 at 11:13 AM
259 -- Last check: Jun 10, 2007 at 06:44 PM
262 DROP TABLE IF EXISTS `library_queue_amazon`;
263 CREATE TABLE IF NOT EXISTS `library_queue_amazon` (
264 `id` varchar(14) NOT NULL COMMENT 'ISBN/EAN/UPC to be looked up on Amazon.com',
265 `type` varchar(10) NOT NULL,
266 `inserted` timestamp NOT NULL,
269 KEY `inserted` (`inserted`)
270 ) TYPE=MyISAM COMMENT='Queue of ISBNs to be looked up through Amazon.com';
272 -- --------------------------------------------------------
275 -- Table structure for table `library_queue_amazon_failed`
277 -- Creation: Apr 02, 2007 at 11:13 AM
278 -- Last update: Apr 02, 2007 at 11:13 AM
279 -- Last check: Jun 10, 2007 at 06:44 PM
282 DROP TABLE IF EXISTS `library_queue_amazon_failed`;
283 CREATE TABLE IF NOT EXISTS `library_queue_amazon_failed` (
284 `id` varchar(14) NOT NULL,
285 `type` varchar(10) NOT NULL,
286 `tried` timestamp NOT NULL,
290 -- --------------------------------------------------------
293 -- Table structure for table `library_recommendations`
295 -- Creation: Mar 25, 2007 at 07:17 AM
296 -- Last update: Mar 25, 2007 at 07:17 AM
297 -- Last check: Jun 10, 2007 at 06:44 PM
300 DROP TABLE IF EXISTS `library_recommendations`;
301 CREATE TABLE IF NOT EXISTS `library_recommendations` (
302 `to` char(36) NOT NULL,
303 `from` char(36) NOT NULL,
304 `item` text NOT NULL,
305 `itemtype` varchar(255) NOT NULL,
306 `comment` text NOT NULL,
307 `when` timestamp NOT NULL,
308 `read` tinyint(1) NOT NULL default '0'
311 -- --------------------------------------------------------
314 -- Table structure for table `library_users`
316 -- Creation: Mar 25, 2007 at 07:18 AM
317 -- Last update: Mar 25, 2007 at 07:18 AM
318 -- Last check: Jun 10, 2007 at 06:44 PM
321 DROP TABLE IF EXISTS `library_users`;
322 CREATE TABLE IF NOT EXISTS `library_users` (
323 `id` char(36) NOT NULL,
324 `login` varchar(255) NOT NULL,
325 `password` varchar(255) NOT NULL,
326 `private` tinyint(1) NOT NULL default '0',
327 `email` varchar(500) NOT NULL,
328 `joined` timestamp NOT NULL,
329 `displayname` varchar(500) NOT NULL,