]>
Commit | Line | Data |
---|---|---|
2eb15639 SZ |
1 | # MySQL dump 8.10 |
2 | # | |
3 | # Host: localhost Database: sourceforge | |
4 | #-------------------------------------------------------- | |
5 | # Server version 3.23.25-beta | |
6 | ||
7 | # | |
8 | # Table structure for table 'activity_log' | |
9 | # | |
10 | ||
11 | CREATE TABLE activity_log ( | |
12 | day int(11) DEFAULT '0' NOT NULL, | |
13 | hour int(11) DEFAULT '0' NOT NULL, | |
14 | group_id int(11) DEFAULT '0' NOT NULL, | |
15 | browser varchar(8) DEFAULT 'OTHER' NOT NULL, | |
16 | ver float(10,2) DEFAULT '0.00' NOT NULL, | |
17 | platform varchar(8) DEFAULT 'OTHER' NOT NULL, | |
18 | time int(11) DEFAULT '0' NOT NULL, | |
19 | page text, | |
20 | type int(11) DEFAULT '0' NOT NULL | |
21 | ); | |
22 | ||
23 | # | |
24 | # Dumping data for table 'activity_log' | |
25 | # | |
26 | ||
27 | ||
28 | # | |
29 | # Table structure for table 'activity_log_old' | |
30 | # | |
31 | ||
32 | CREATE TABLE activity_log_old ( | |
33 | day int(11) DEFAULT '0' NOT NULL, | |
34 | hour int(11) DEFAULT '0' NOT NULL, | |
35 | group_id int(11) DEFAULT '0' NOT NULL, | |
36 | browser varchar(8) DEFAULT 'OTHER' NOT NULL, | |
37 | ver float(10,2) DEFAULT '0.00' NOT NULL, | |
38 | platform varchar(8) DEFAULT 'OTHER' NOT NULL, | |
39 | time int(11) DEFAULT '0' NOT NULL, | |
40 | page text, | |
41 | type int(11) DEFAULT '0' NOT NULL | |
42 | ); | |
43 | ||
44 | # | |
45 | # Dumping data for table 'activity_log_old' | |
46 | # | |
47 | ||
48 | ||
49 | # | |
50 | # Table structure for table 'activity_log_old_old' | |
51 | # | |
52 | ||
53 | CREATE TABLE activity_log_old_old ( | |
54 | day int(11) DEFAULT '0' NOT NULL, | |
55 | hour int(11) DEFAULT '0' NOT NULL, | |
56 | group_id int(11) DEFAULT '0' NOT NULL, | |
57 | browser varchar(8) DEFAULT 'OTHER' NOT NULL, | |
58 | ver float(10,2) DEFAULT '0.00' NOT NULL, | |
59 | platform varchar(8) DEFAULT 'OTHER' NOT NULL, | |
60 | time int(11) DEFAULT '0' NOT NULL, | |
61 | page text, | |
62 | type int(11) DEFAULT '0' NOT NULL | |
63 | ); | |
64 | ||
65 | # | |
66 | # Dumping data for table 'activity_log_old_old' | |
67 | # | |
68 | ||
69 | ||
70 | # | |
71 | # Table structure for table 'bug' | |
72 | # | |
73 | ||
74 | CREATE TABLE bug ( | |
75 | bug_id int(11) NOT NULL auto_increment, | |
76 | group_id int(11) DEFAULT '0' NOT NULL, | |
77 | status_id int(11) DEFAULT '0' NOT NULL, | |
78 | priority int(11) DEFAULT '0' NOT NULL, | |
79 | category_id int(11) DEFAULT '0' NOT NULL, | |
80 | submitted_by int(11) DEFAULT '0' NOT NULL, | |
81 | assigned_to int(11) DEFAULT '0' NOT NULL, | |
82 | date int(11) DEFAULT '0' NOT NULL, | |
83 | summary text, | |
84 | details text, | |
85 | close_date int(11), | |
86 | bug_group_id int(11) DEFAULT '0' NOT NULL, | |
87 | resolution_id int(11) DEFAULT '0' NOT NULL, | |
88 | PRIMARY KEY (bug_id), | |
89 | KEY idx_bug_group_id (group_id) | |
90 | ); | |
91 | ||
92 | # | |
93 | # Dumping data for table 'bug' | |
94 | # | |
95 | ||
96 | INSERT INTO bug VALUES (100,1,100,0,100,100,100,0,NULL,NULL,NULL,100,100); | |
97 | ||
98 | # | |
99 | # Table structure for table 'bug_bug_dependencies' | |
100 | # | |
101 | ||
102 | CREATE TABLE bug_bug_dependencies ( | |
103 | bug_depend_id int(11) NOT NULL auto_increment, | |
104 | bug_id int(11) DEFAULT '0' NOT NULL, | |
105 | is_dependent_on_bug_id int(11) DEFAULT '0' NOT NULL, | |
106 | PRIMARY KEY (bug_depend_id), | |
107 | KEY idx_bug_bug_dependencies_bug_id (bug_id), | |
108 | KEY idx_bug_bug_is_dependent_on_task_id (is_dependent_on_bug_id) | |
109 | ); | |
110 | ||
111 | # | |
112 | # Dumping data for table 'bug_bug_dependencies' | |
113 | # | |
114 | ||
115 | ||
116 | # | |
117 | # Table structure for table 'bug_canned_responses' | |
118 | # | |
119 | ||
120 | CREATE TABLE bug_canned_responses ( | |
121 | bug_canned_id int(11) NOT NULL auto_increment, | |
122 | group_id int(11) DEFAULT '0' NOT NULL, | |
123 | title text, | |
124 | body text, | |
125 | PRIMARY KEY (bug_canned_id), | |
126 | KEY idx_bug_canned_response_group_id (group_id) | |
127 | ); | |
128 | ||
129 | # | |
130 | # Dumping data for table 'bug_canned_responses' | |
131 | # | |
132 | ||
133 | ||
134 | # | |
135 | # Table structure for table 'bug_category' | |
136 | # | |
137 | ||
138 | CREATE TABLE bug_category ( | |
139 | bug_category_id int(11) NOT NULL auto_increment, | |
140 | group_id int(11) DEFAULT '0' NOT NULL, | |
141 | category_name text, | |
142 | PRIMARY KEY (bug_category_id), | |
143 | KEY idx_bug_category_group_id (group_id) | |
144 | ); | |
145 | ||
146 | # | |
147 | # Dumping data for table 'bug_category' | |
148 | # | |
149 | ||
150 | INSERT INTO bug_category VALUES (100,1,'None'); | |
151 | ||
152 | # | |
153 | # Table structure for table 'bug_filter' | |
154 | # | |
155 | ||
156 | CREATE TABLE bug_filter ( | |
157 | filter_id int(11) NOT NULL auto_increment, | |
158 | user_id int(11) DEFAULT '0' NOT NULL, | |
159 | group_id int(11) DEFAULT '0' NOT NULL, | |
160 | sql_clause text DEFAULT '' NOT NULL, | |
161 | is_active int(11) DEFAULT '0' NOT NULL, | |
162 | PRIMARY KEY (filter_id) | |
163 | ); | |
164 | ||
165 | # | |
166 | # Dumping data for table 'bug_filter' | |
167 | # | |
168 | ||
169 | ||
170 | # | |
171 | # Table structure for table 'bug_group' | |
172 | # | |
173 | ||
174 | CREATE TABLE bug_group ( | |
175 | bug_group_id int(11) NOT NULL auto_increment, | |
176 | group_id int(11) DEFAULT '0' NOT NULL, | |
177 | group_name text DEFAULT '' NOT NULL, | |
178 | PRIMARY KEY (bug_group_id), | |
179 | KEY idx_bug_group_group_id (group_id) | |
180 | ); | |
181 | ||
182 | # | |
183 | # Dumping data for table 'bug_group' | |
184 | # | |
185 | ||
186 | INSERT INTO bug_group VALUES (100,1,'None'); | |
187 | ||
188 | # | |
189 | # Table structure for table 'bug_history' | |
190 | # | |
191 | ||
192 | CREATE TABLE bug_history ( | |
193 | bug_history_id int(11) NOT NULL auto_increment, | |
194 | bug_id int(11) DEFAULT '0' NOT NULL, | |
195 | field_name text DEFAULT '' NOT NULL, | |
196 | old_value text DEFAULT '' NOT NULL, | |
197 | mod_by int(11) DEFAULT '0' NOT NULL, | |
198 | date int(11), | |
199 | PRIMARY KEY (bug_history_id), | |
200 | KEY idx_bug_history_bug_id (bug_id) | |
201 | ); | |
202 | ||
203 | # | |
204 | # Dumping data for table 'bug_history' | |
205 | # | |
206 | ||
207 | ||
208 | # | |
209 | # Table structure for table 'bug_resolution' | |
210 | # | |
211 | ||
212 | CREATE TABLE bug_resolution ( | |
213 | resolution_id int(11) NOT NULL auto_increment, | |
214 | resolution_name text DEFAULT '' NOT NULL, | |
215 | PRIMARY KEY (resolution_id) | |
216 | ); | |
217 | ||
218 | # | |
219 | # Dumping data for table 'bug_resolution' | |
220 | # | |
221 | ||
222 | INSERT INTO bug_resolution VALUES (1,'Fixed'); | |
223 | INSERT INTO bug_resolution VALUES (2,'Invalid'); | |
224 | INSERT INTO bug_resolution VALUES (3,'Wont Fix'); | |
225 | INSERT INTO bug_resolution VALUES (4,'Later'); | |
226 | INSERT INTO bug_resolution VALUES (5,'Remind'); | |
227 | INSERT INTO bug_resolution VALUES (6,'Works For Me'); | |
228 | INSERT INTO bug_resolution VALUES (100,'None'); | |
229 | INSERT INTO bug_resolution VALUES (101,'Duplicate'); | |
230 | ||
231 | # | |
232 | # Table structure for table 'bug_status' | |
233 | # | |
234 | ||
235 | CREATE TABLE bug_status ( | |
236 | status_id int(11) NOT NULL auto_increment, | |
237 | status_name text, | |
238 | PRIMARY KEY (status_id) | |
239 | ); | |
240 | ||
241 | # | |
242 | # Dumping data for table 'bug_status' | |
243 | # | |
244 | ||
245 | INSERT INTO bug_status VALUES (1,'Open'); | |
246 | INSERT INTO bug_status VALUES (3,'Closed'); | |
247 | INSERT INTO bug_status VALUES (100,'None'); | |
248 | ||
249 | # | |
250 | # Table structure for table 'bug_task_dependencies' | |
251 | # | |
252 | ||
253 | CREATE TABLE bug_task_dependencies ( | |
254 | bug_depend_id int(11) NOT NULL auto_increment, | |
255 | bug_id int(11) DEFAULT '0' NOT NULL, | |
256 | is_dependent_on_task_id int(11) DEFAULT '0' NOT NULL, | |
257 | PRIMARY KEY (bug_depend_id), | |
258 | KEY idx_bug_task_dependencies_bug_id (bug_id), | |
259 | KEY idx_bug_task_is_dependent_on_task_id (is_dependent_on_task_id) | |
260 | ); | |
261 | ||
262 | # | |
263 | # Dumping data for table 'bug_task_dependencies' | |
264 | # | |
265 | ||
266 | ||
267 | # | |
268 | # Table structure for table 'canned_responses' | |
269 | # | |
270 | ||
271 | CREATE TABLE canned_responses ( | |
272 | response_id int(11) NOT NULL auto_increment, | |
273 | response_title varchar(25), | |
274 | response_text text, | |
275 | PRIMARY KEY (response_id) | |
276 | ); | |
277 | ||
278 | # | |
279 | # Dumping data for table 'canned_responses' | |
280 | # | |
281 | ||
282 | ||
283 | # | |
284 | # Table structure for table 'db_images' | |
285 | # | |
286 | ||
287 | CREATE TABLE db_images ( | |
288 | id int(11) NOT NULL auto_increment, | |
289 | group_id int(11) DEFAULT '0' NOT NULL, | |
290 | description text DEFAULT '' NOT NULL, | |
291 | bin_data longblob DEFAULT '' NOT NULL, | |
292 | filename text DEFAULT '' NOT NULL, | |
293 | filesize int(11) DEFAULT '0' NOT NULL, | |
294 | filetype text DEFAULT '' NOT NULL, | |
295 | width int(11) DEFAULT '0' NOT NULL, | |
296 | height int(11) DEFAULT '0' NOT NULL, | |
297 | PRIMARY KEY (id), | |
298 | KEY idx_db_images_group (group_id) | |
299 | ); | |
300 | ||
301 | # | |
302 | # Dumping data for table 'db_images' | |
303 | # | |
304 | ||
305 | ||
306 | # | |
307 | # Table structure for table 'doc_data' | |
308 | # | |
309 | ||
310 | CREATE TABLE doc_data ( | |
311 | docid int(11) NOT NULL auto_increment, | |
312 | stateid int(11) DEFAULT '0' NOT NULL, | |
313 | title varchar(255) DEFAULT '' NOT NULL, | |
314 | data text DEFAULT '' NOT NULL, | |
315 | updatedate int(11) DEFAULT '0' NOT NULL, | |
316 | createdate int(11) DEFAULT '0' NOT NULL, | |
317 | created_by int(11) DEFAULT '0' NOT NULL, | |
318 | doc_group int(11) DEFAULT '0' NOT NULL, | |
319 | description text, | |
320 | language_id int(11) DEFAULT '1' NOT NULL, | |
321 | PRIMARY KEY (docid), | |
322 | KEY idx_doc_group_doc_group (doc_group) | |
323 | ); | |
324 | ||
325 | # | |
326 | # Dumping data for table 'doc_data' | |
327 | # | |
328 | ||
329 | ||
330 | # | |
331 | # Table structure for table 'doc_groups' | |
332 | # | |
333 | ||
334 | CREATE TABLE doc_groups ( | |
335 | doc_group int(12) NOT NULL auto_increment, | |
336 | groupname varchar(255) DEFAULT '' NOT NULL, | |
337 | group_id int(11) DEFAULT '0' NOT NULL, | |
338 | PRIMARY KEY (doc_group), | |
339 | KEY idx_doc_groups_group (group_id) | |
340 | ); | |
341 | ||
342 | # | |
343 | # Dumping data for table 'doc_groups' | |
344 | # | |
345 | ||
346 | INSERT INTO doc_groups VALUES (793,'About SourceForge',1); | |
347 | INSERT INTO doc_groups VALUES (794,'SourceForge Development',1); | |
348 | INSERT INTO doc_groups VALUES (801,'Account Information',1); | |
349 | INSERT INTO doc_groups VALUES (802,'CVS - General Information',1); | |
350 | INSERT INTO doc_groups VALUES (803,'CVS - OS Specific Information',1); | |
351 | INSERT INTO doc_groups VALUES (804,'Database Information',1); | |
352 | INSERT INTO doc_groups VALUES (805,'General Documentation',1); | |
353 | INSERT INTO doc_groups VALUES (806,'Project Administration',1); | |
354 | INSERT INTO doc_groups VALUES (807,'Translated Documentation',1); | |
355 | INSERT INTO doc_groups VALUES (808,'Website Hosting Information',1); | |
356 | ||
357 | # | |
358 | # Table structure for table 'doc_states' | |
359 | # | |
360 | ||
361 | CREATE TABLE doc_states ( | |
362 | stateid int(11) NOT NULL auto_increment, | |
363 | name varchar(255) DEFAULT '' NOT NULL, | |
364 | PRIMARY KEY (stateid) | |
365 | ); | |
366 | ||
367 | # | |
368 | # Dumping data for table 'doc_states' | |
369 | # | |
370 | ||
371 | INSERT INTO doc_states VALUES (1,'active'); | |
372 | INSERT INTO doc_states VALUES (2,'deleted'); | |
373 | INSERT INTO doc_states VALUES (3,'pending'); | |
374 | INSERT INTO doc_states VALUES (4,'hidden'); | |
375 | INSERT INTO doc_states VALUES (5,'private'); | |
376 | ||
377 | # | |
378 | # Table structure for table 'filemodule_monitor' | |
379 | # | |
380 | ||
381 | CREATE TABLE filemodule_monitor ( | |
382 | filemodule_id int(11) DEFAULT '0' NOT NULL, | |
383 | user_id int(11) DEFAULT '0' NOT NULL, | |
384 | KEY idx_filemodule_monitor_id (filemodule_id) | |
385 | ); | |
386 | ||
387 | # | |
388 | # Dumping data for table 'filemodule_monitor' | |
389 | # | |
390 | ||
391 | ||
392 | # | |
393 | # Table structure for table 'forum' | |
394 | # | |
395 | ||
396 | CREATE TABLE forum ( | |
397 | msg_id int(11) NOT NULL auto_increment, | |
398 | group_forum_id int(11) DEFAULT '0' NOT NULL, | |
399 | posted_by int(11) DEFAULT '0' NOT NULL, | |
400 | subject text DEFAULT '' NOT NULL, | |
401 | body text DEFAULT '' NOT NULL, | |
402 | date int(11) DEFAULT '0' NOT NULL, | |
403 | is_followup_to int(11) DEFAULT '0' NOT NULL, | |
404 | thread_id int(11) DEFAULT '0' NOT NULL, | |
405 | has_followups int(11) DEFAULT '0', | |
406 | most_recent_date int(11) DEFAULT '0' NOT NULL, | |
407 | PRIMARY KEY (msg_id), | |
408 | KEY idx_forum_group_forum_id (group_forum_id), | |
409 | KEY idx_forum_thread_id (thread_id), | |
410 | KEY forum_forumid_isfollowupto (group_forum_id,is_followup_to), | |
411 | KEY forum_forumid_isfollto_mostrecentdate (group_forum_id,is_followup_to,most_recent_date), | |
412 | KEY forum_forumid_msgid (group_forum_id,msg_id), | |
413 | KEY forum_threadid_isfollowupto (thread_id,is_followup_to) | |
414 | ); | |
415 | ||
416 | # | |
417 | # Dumping data for table 'forum' | |
418 | # | |
419 | ||
420 | INSERT INTO forum VALUES (1,1,100,'Welcome to Open Discussion','Welcome to Open Discussion',974405311,0,1,0,0); | |
421 | INSERT INTO forum VALUES (2,2,100,'Welcome to Help','Welcome to Help',974405311,0,2,0,0); | |
422 | INSERT INTO forum VALUES (3,3,100,'Welcome to Developers','Welcome to Developers',974405311,0,3,0,0); | |
423 | ||
424 | # | |
425 | # Table structure for table 'forum_agg_msg_count' | |
426 | # | |
427 | ||
428 | CREATE TABLE forum_agg_msg_count ( | |
429 | group_forum_id int(11) DEFAULT '0' NOT NULL, | |
430 | count int(11) DEFAULT '0' NOT NULL, | |
431 | PRIMARY KEY (group_forum_id) | |
432 | ); | |
433 | ||
434 | # | |
435 | # Dumping data for table 'forum_agg_msg_count' | |
436 | # | |
437 | ||
438 | ||
439 | # | |
440 | # Table structure for table 'forum_group_list' | |
441 | # | |
442 | ||
443 | CREATE TABLE forum_group_list ( | |
444 | group_forum_id int(11) NOT NULL auto_increment, | |
445 | group_id int(11) DEFAULT '0' NOT NULL, | |
446 | forum_name text DEFAULT '' NOT NULL, | |
447 | is_public int(11) DEFAULT '0' NOT NULL, | |
448 | description text, | |
449 | allow_anonymous int(11) DEFAULT '0' NOT NULL, | |
450 | send_all_posts_to text, | |
451 | PRIMARY KEY (group_forum_id), | |
452 | KEY idx_forum_group_list_group_id (group_id) | |
453 | ); | |
454 | ||
455 | # | |
456 | # Dumping data for table 'forum_group_list' | |
457 | # | |
458 | ||
459 | INSERT INTO forum_group_list VALUES (1,2,'Open Discussion',1,'',0,NULL); | |
460 | INSERT INTO forum_group_list VALUES (2,2,'Help',1,'',0,NULL); | |
461 | INSERT INTO forum_group_list VALUES (3,2,'Developers',0,'',0,NULL); | |
462 | ||
463 | # | |
464 | # Table structure for table 'forum_monitored_forums' | |
465 | # | |
466 | ||
467 | CREATE TABLE forum_monitored_forums ( | |
468 | monitor_id int(11) NOT NULL auto_increment, | |
469 | forum_id int(11) DEFAULT '0' NOT NULL, | |
470 | user_id int(11) DEFAULT '0' NOT NULL, | |
471 | PRIMARY KEY (monitor_id), | |
472 | KEY idx_forum_monitor_thread_id (forum_id), | |
473 | KEY idx_forum_monitor_combo_id (forum_id,user_id) | |
474 | ); | |
475 | ||
476 | # | |
477 | # Dumping data for table 'forum_monitored_forums' | |
478 | # | |
479 | ||
480 | ||
481 | # | |
482 | # Table structure for table 'forum_saved_place' | |
483 | # | |
484 | ||
485 | CREATE TABLE forum_saved_place ( | |
486 | saved_place_id int(11) NOT NULL auto_increment, | |
487 | user_id int(11) DEFAULT '0' NOT NULL, | |
488 | forum_id int(11) DEFAULT '0' NOT NULL, | |
489 | save_date int(11) DEFAULT '0' NOT NULL, | |
490 | PRIMARY KEY (saved_place_id) | |
491 | ); | |
492 | ||
493 | # | |
494 | # Dumping data for table 'forum_saved_place' | |
495 | # | |
496 | ||
497 | ||
498 | # | |
499 | # Table structure for table 'forum_thread_id' | |
500 | # | |
501 | ||
502 | CREATE TABLE forum_thread_id ( | |
503 | thread_id int(11) NOT NULL auto_increment, | |
504 | PRIMARY KEY (thread_id) | |
505 | ); | |
506 | ||
507 | # | |
508 | # Dumping data for table 'forum_thread_id' | |
509 | # | |
510 | ||
511 | INSERT INTO forum_thread_id VALUES (1); | |
512 | INSERT INTO forum_thread_id VALUES (2); | |
513 | INSERT INTO forum_thread_id VALUES (3); | |
514 | ||
515 | # | |
516 | # Table structure for table 'foundry_data' | |
517 | # | |
518 | ||
519 | CREATE TABLE foundry_data ( | |
520 | foundry_id int(11) NOT NULL auto_increment, | |
521 | freeform1_html text, | |
522 | freeform2_html text, | |
523 | sponsor1_html text, | |
524 | sponsor2_html text, | |
525 | guide_image_id int(11) DEFAULT '0' NOT NULL, | |
526 | logo_image_id int(11) DEFAULT '0' NOT NULL, | |
527 | trove_categories text, | |
528 | PRIMARY KEY (foundry_id) | |
529 | ); | |
530 | ||
531 | # | |
532 | # Dumping data for table 'foundry_data' | |
533 | # | |
534 | ||
535 | ||
536 | # | |
537 | # Table structure for table 'foundry_news' | |
538 | # | |
539 | ||
540 | CREATE TABLE foundry_news ( | |
541 | foundry_news_id int(11) NOT NULL auto_increment, | |
542 | foundry_id int(11) DEFAULT '0' NOT NULL, | |
543 | news_id int(11) DEFAULT '0' NOT NULL, | |
544 | approve_date int(11) DEFAULT '0' NOT NULL, | |
545 | is_approved int(11) DEFAULT '0' NOT NULL, | |
546 | PRIMARY KEY (foundry_news_id), | |
547 | KEY idx_foundry_news_foundry (foundry_id), | |
548 | KEY idx_foundry_news_foundry_approved_date (foundry_id,is_approved,approve_date), | |
549 | KEY idx_foundry_news_foundry_approved (foundry_id,is_approved) | |
550 | ); | |
551 | ||
552 | # | |
553 | # Dumping data for table 'foundry_news' | |
554 | # | |
555 | ||
556 | ||
557 | # | |
558 | # Table structure for table 'foundry_preferred_projects' | |
559 | # | |
560 | ||
561 | CREATE TABLE foundry_preferred_projects ( | |
562 | foundry_project_id int(11) NOT NULL auto_increment, | |
563 | foundry_id int(11) DEFAULT '0' NOT NULL, | |
564 | group_id int(11) DEFAULT '0' NOT NULL, | |
565 | rank int(11) DEFAULT '0' NOT NULL, | |
566 | PRIMARY KEY (foundry_project_id), | |
567 | KEY idx_foundry_project_group (group_id), | |
568 | KEY idx_foundry_project_group_rank (group_id,rank) | |
569 | ); | |
570 | ||
571 | # | |
572 | # Dumping data for table 'foundry_preferred_projects' | |
573 | # | |
574 | ||
575 | ||
576 | # | |
577 | # Table structure for table 'foundry_projects' | |
578 | # | |
579 | ||
580 | CREATE TABLE foundry_projects ( | |
581 | id int(11) NOT NULL auto_increment, | |
582 | foundry_id int(11) DEFAULT '0' NOT NULL, | |
583 | project_id int(11) DEFAULT '0' NOT NULL, | |
584 | PRIMARY KEY (id), | |
585 | KEY idx_foundry_projects_foundry (foundry_id) | |
586 | ); | |
587 | ||
588 | # | |
589 | # Dumping data for table 'foundry_projects' | |
590 | # | |
591 | ||
592 | ||
593 | # | |
594 | # Table structure for table 'frs_dlstats_agg' | |
595 | # | |
596 | ||
597 | CREATE TABLE frs_dlstats_agg ( | |
598 | file_id int(11) DEFAULT '0' NOT NULL, | |
599 | day int(11) DEFAULT '0' NOT NULL, | |
600 | downloads_http int(11) DEFAULT '0' NOT NULL, | |
601 | downloads_ftp int(11) DEFAULT '0' NOT NULL, | |
602 | KEY file_id_idx (file_id), | |
603 | KEY day_idx (day), | |
604 | KEY downloads_http_idx (downloads_http), | |
605 | KEY downloads_ftp_idx (downloads_ftp) | |
606 | ); | |
607 | ||
608 | # | |
609 | # Dumping data for table 'frs_dlstats_agg' | |
610 | # | |
611 | ||
612 | ||
613 | # | |
614 | # Table structure for table 'frs_dlstats_file_agg' | |
615 | # | |
616 | ||
617 | CREATE TABLE frs_dlstats_file_agg ( | |
618 | file_id int(11) DEFAULT '0' NOT NULL, | |
619 | day int(11) DEFAULT '0' NOT NULL, | |
620 | downloads int(11) DEFAULT '0' NOT NULL, | |
621 | KEY idx_dlstats_file_file_id (file_id), | |
622 | KEY idx_dlstats_file_day (day), | |
623 | KEY idx_dlstats_file_down (downloads) | |
624 | ); | |
625 | ||
626 | # | |
627 | # Dumping data for table 'frs_dlstats_file_agg' | |
628 | # | |
629 | ||
630 | ||
631 | # | |
632 | # Table structure for table 'frs_dlstats_filetotal_agg' | |
633 | # | |
634 | ||
635 | CREATE TABLE frs_dlstats_filetotal_agg ( | |
636 | file_id int(11) DEFAULT '0' NOT NULL, | |
637 | downloads int(11) DEFAULT '0' NOT NULL, | |
638 | KEY idx_stats_agr_tmp_fid (file_id) | |
639 | ); | |
640 | ||
641 | # | |
642 | # Dumping data for table 'frs_dlstats_filetotal_agg' | |
643 | # | |
644 | ||
645 | ||
646 | # | |
647 | # Table structure for table 'frs_dlstats_filetotal_agg_old' | |
648 | # | |
649 | ||
650 | CREATE TABLE frs_dlstats_filetotal_agg_old ( | |
651 | file_id int(11) DEFAULT '0' NOT NULL, | |
652 | downloads int(11) DEFAULT '0' NOT NULL, | |
653 | KEY idx_stats_agr_tmp_fid (file_id) | |
654 | ); | |
655 | ||
656 | # | |
657 | # Dumping data for table 'frs_dlstats_filetotal_agg_old' | |
658 | # | |
659 | ||
660 | ||
661 | # | |
662 | # Table structure for table 'frs_dlstats_group_agg' | |
663 | # | |
664 | ||
665 | CREATE TABLE frs_dlstats_group_agg ( | |
666 | group_id int(11) DEFAULT '0' NOT NULL, | |
667 | day int(11) DEFAULT '0' NOT NULL, | |
668 | downloads int(11) DEFAULT '0' NOT NULL, | |
669 | KEY group_id_idx (group_id), | |
670 | KEY day_idx (day), | |
671 | KEY downloads_idx (downloads) | |
672 | ); | |
673 | ||
674 | # | |
675 | # Dumping data for table 'frs_dlstats_group_agg' | |
676 | # | |
677 | ||
678 | ||
679 | # | |
680 | # Table structure for table 'frs_dlstats_grouptotal_agg' | |
681 | # | |
682 | ||
683 | CREATE TABLE frs_dlstats_grouptotal_agg ( | |
684 | group_id int(11) DEFAULT '0' NOT NULL, | |
685 | downloads int(11) DEFAULT '0' NOT NULL, | |
686 | KEY idx_stats_agr_tmp_gid (group_id) | |
687 | ); | |
688 | ||
689 | # | |
690 | # Dumping data for table 'frs_dlstats_grouptotal_agg' | |
691 | # | |
692 | ||
693 | ||
694 | # | |
695 | # Table structure for table 'frs_file' | |
696 | # | |
697 | ||
698 | CREATE TABLE frs_file ( | |
699 | file_id int(11) NOT NULL auto_increment, | |
700 | filename text, | |
701 | release_id int(11) DEFAULT '0' NOT NULL, | |
702 | type_id int(11) DEFAULT '0' NOT NULL, | |
703 | processor_id int(11) DEFAULT '0' NOT NULL, | |
704 | release_time int(11) DEFAULT '0' NOT NULL, | |
705 | file_size int(11) DEFAULT '0' NOT NULL, | |
706 | post_date int(11) DEFAULT '0' NOT NULL, | |
707 | PRIMARY KEY (file_id), | |
708 | KEY idx_frs_file_release_id (release_id), | |
709 | KEY idx_frs_file_type (type_id), | |
710 | KEY idx_frs_file_date (post_date), | |
711 | KEY idx_frs_file_processor (processor_id), | |
712 | KEY idx_frs_file_name (filename(45)) | |
713 | ); | |
714 | ||
715 | # | |
716 | # Dumping data for table 'frs_file' | |
717 | # | |
718 | ||
719 | ||
720 | # | |
721 | # Table structure for table 'frs_filetype' | |
722 | # | |
723 | ||
724 | CREATE TABLE frs_filetype ( | |
725 | type_id int(11) NOT NULL auto_increment, | |
726 | name text, | |
727 | PRIMARY KEY (type_id) | |
728 | ); | |
729 | ||
730 | # | |
731 | # Dumping data for table 'frs_filetype' | |
732 | # | |
733 | ||
734 | INSERT INTO frs_filetype VALUES (1000,'.deb'); | |
735 | INSERT INTO frs_filetype VALUES (2000,'.rpm'); | |
736 | INSERT INTO frs_filetype VALUES (3000,'.zip'); | |
737 | INSERT INTO frs_filetype VALUES (3001,'.bz2'); | |
738 | INSERT INTO frs_filetype VALUES (3002,'.gz'); | |
739 | INSERT INTO frs_filetype VALUES (5000,'Source .zip'); | |
740 | INSERT INTO frs_filetype VALUES (5001,'Source .bz2'); | |
741 | INSERT INTO frs_filetype VALUES (5002,'Source .gz'); | |
742 | INSERT INTO frs_filetype VALUES (5100,'Source .rpm'); | |
743 | INSERT INTO frs_filetype VALUES (5900,'Other Source File'); | |
744 | INSERT INTO frs_filetype VALUES (8000,'.jpg'); | |
745 | INSERT INTO frs_filetype VALUES (8001,'text'); | |
746 | INSERT INTO frs_filetype VALUES (8002,'html'); | |
747 | INSERT INTO frs_filetype VALUES (8003,'pdf'); | |
748 | INSERT INTO frs_filetype VALUES (9999,'Other'); | |
749 | ||
750 | # | |
751 | # Table structure for table 'frs_package' | |
752 | # | |
753 | ||
754 | CREATE TABLE frs_package ( | |
755 | package_id int(11) NOT NULL auto_increment, | |
756 | group_id int(11) DEFAULT '0' NOT NULL, | |
757 | name text, | |
758 | status_id int(11) DEFAULT '0' NOT NULL, | |
759 | PRIMARY KEY (package_id), | |
760 | KEY idx_package_group_id (group_id) | |
761 | ); | |
762 | ||
763 | # | |
764 | # Dumping data for table 'frs_package' | |
765 | # | |
766 | ||
767 | ||
768 | # | |
769 | # Table structure for table 'frs_processor' | |
770 | # | |
771 | ||
772 | CREATE TABLE frs_processor ( | |
773 | processor_id int(11) NOT NULL auto_increment, | |
774 | name text, | |
775 | PRIMARY KEY (processor_id) | |
776 | ); | |
777 | ||
778 | # | |
779 | # Dumping data for table 'frs_processor' | |
780 | # | |
781 | ||
782 | INSERT INTO frs_processor VALUES (1000,'i386'); | |
783 | INSERT INTO frs_processor VALUES (6000,'IA64'); | |
784 | INSERT INTO frs_processor VALUES (7000,'Alpha'); | |
785 | INSERT INTO frs_processor VALUES (8000,'Any'); | |
786 | INSERT INTO frs_processor VALUES (2000,'PPC'); | |
787 | INSERT INTO frs_processor VALUES (3000,'MIPS'); | |
788 | INSERT INTO frs_processor VALUES (4000,'Sparc'); | |
789 | INSERT INTO frs_processor VALUES (5000,'UltraSparc'); | |
790 | INSERT INTO frs_processor VALUES (9999,'Other'); | |
791 | ||
792 | # | |
793 | # Table structure for table 'frs_release' | |
794 | # | |
795 | ||
796 | CREATE TABLE frs_release ( | |
797 | release_id int(11) NOT NULL auto_increment, | |
798 | package_id int(11) DEFAULT '0' NOT NULL, | |
799 | name text, | |
800 | notes text, | |
801 | changes text, | |
802 | status_id int(11) DEFAULT '0' NOT NULL, | |
803 | preformatted int(11) DEFAULT '0' NOT NULL, | |
804 | release_date int(11) DEFAULT '0' NOT NULL, | |
805 | released_by int(11) DEFAULT '0' NOT NULL, | |
806 | PRIMARY KEY (release_id), | |
807 | KEY idx_frs_release_by (released_by), | |
808 | KEY idx_frs_release_date (release_date), | |
809 | KEY idx_frs_release_package (package_id) | |
810 | ); | |
811 | ||
812 | # | |
813 | # Dumping data for table 'frs_release' | |
814 | # | |
815 | ||
816 | ||
817 | # | |
818 | # Table structure for table 'frs_status' | |
819 | # | |
820 | ||
821 | CREATE TABLE frs_status ( | |
822 | status_id int(11) NOT NULL auto_increment, | |
823 | name text, | |
824 | PRIMARY KEY (status_id) | |
825 | ); | |
826 | ||
827 | # | |
828 | # Dumping data for table 'frs_status' | |
829 | # | |
830 | ||
831 | INSERT INTO frs_status VALUES (1,'Active'); | |
832 | INSERT INTO frs_status VALUES (3,'Hidden'); | |
833 | ||
834 | # | |
835 | # Table structure for table 'group_cvs_history' | |
836 | # | |
837 | ||
838 | CREATE TABLE group_cvs_history ( | |
839 | group_id int(11) DEFAULT '0' NOT NULL, | |
840 | user_name varchar(80) DEFAULT '' NOT NULL, | |
841 | cvs_commits int(11) DEFAULT '0' NOT NULL, | |
842 | cvs_commits_wk int(11) DEFAULT '0' NOT NULL, | |
843 | cvs_adds int(11) DEFAULT '0' NOT NULL, | |
844 | cvs_adds_wk int(11) DEFAULT '0' NOT NULL, | |
845 | KEY group_id_idx (group_id), | |
846 | KEY user_name_idx (user_name) | |
847 | ); | |
848 | ||
849 | # | |
850 | # Dumping data for table 'group_cvs_history' | |
851 | # | |
852 | ||
853 | ||
854 | # | |
855 | # Table structure for table 'group_history' | |
856 | # | |
857 | ||
858 | CREATE TABLE group_history ( | |
859 | group_history_id int(11) NOT NULL auto_increment, | |
860 | group_id int(11) DEFAULT '0' NOT NULL, | |
861 | field_name text DEFAULT '' NOT NULL, | |
862 | old_value text DEFAULT '' NOT NULL, | |
863 | mod_by int(11) DEFAULT '0' NOT NULL, | |
864 | date int(11), | |
865 | PRIMARY KEY (group_history_id), | |
866 | KEY idx_group_history_group_id (group_id) | |
867 | ); | |
868 | ||
869 | # | |
870 | # Dumping data for table 'group_history' | |
871 | # | |
872 | ||
873 | ||
874 | # | |
875 | # Table structure for table 'group_type' | |
876 | # | |
877 | ||
878 | CREATE TABLE group_type ( | |
879 | type_id int(11) NOT NULL auto_increment, | |
880 | name text, | |
881 | PRIMARY KEY (type_id) | |
882 | ); | |
883 | ||
884 | # | |
885 | # Dumping data for table 'group_type' | |
886 | # | |
887 | ||
888 | INSERT INTO group_type VALUES (1,'Project'); | |
889 | INSERT INTO group_type VALUES (2,'Foundry'); | |
890 | ||
891 | # | |
892 | # Table structure for table 'groups' | |
893 | # | |
894 | ||
895 | CREATE TABLE groups ( | |
896 | group_id int(11) NOT NULL auto_increment, | |
897 | group_name varchar(40), | |
898 | homepage varchar(128), | |
899 | is_public int(11) DEFAULT '0' NOT NULL, | |
900 | status char(1) DEFAULT 'A' NOT NULL, | |
901 | unix_group_name varchar(30) DEFAULT '' NOT NULL, | |
902 | unix_box varchar(20) DEFAULT 'shell1' NOT NULL, | |
903 | http_domain varchar(80), | |
904 | short_description varchar(255), | |
905 | cvs_box varchar(20) DEFAULT 'cvs1' NOT NULL, | |
906 | license varchar(16), | |
907 | register_purpose text, | |
908 | license_other text, | |
909 | register_time int(11) DEFAULT '0' NOT NULL, | |
910 | use_bugs int(11) DEFAULT '1' NOT NULL, | |
911 | rand_hash text, | |
912 | use_mail int(11) DEFAULT '1' NOT NULL, | |
913 | use_survey int(11) DEFAULT '1' NOT NULL, | |
914 | use_patch int(11) DEFAULT '1' NOT NULL, | |
915 | use_forum int(11) DEFAULT '1' NOT NULL, | |
916 | use_pm int(11) DEFAULT '1' NOT NULL, | |
917 | use_cvs int(11) DEFAULT '1' NOT NULL, | |
918 | use_news int(11) DEFAULT '1' NOT NULL, | |
919 | use_support int(11) DEFAULT '1' NOT NULL, | |
920 | new_bug_address text DEFAULT '' NOT NULL, | |
921 | new_patch_address text DEFAULT '' NOT NULL, | |
922 | new_support_address text DEFAULT '' NOT NULL, | |
923 | type int(11) DEFAULT '1' NOT NULL, | |
924 | use_docman int(11) DEFAULT '1' NOT NULL, | |
925 | send_all_bugs int(11) DEFAULT '0' NOT NULL, | |
926 | send_all_patches int(11) DEFAULT '0' NOT NULL, | |
927 | send_all_support int(11) DEFAULT '0' NOT NULL, | |
928 | new_task_address text DEFAULT '' NOT NULL, | |
929 | send_all_tasks int(11) DEFAULT '0' NOT NULL, | |
930 | use_bug_depend_box int(11) DEFAULT '1' NOT NULL, | |
931 | use_pm_depend_box int(11) DEFAULT '1' NOT NULL, | |
932 | PRIMARY KEY (group_id), | |
933 | KEY idx_groups_status (status), | |
934 | KEY idx_groups_public (is_public), | |
935 | KEY idx_groups_unix (unix_group_name), | |
936 | KEY idx_groups_type (type) | |
937 | ); | |
938 | ||
939 | # | |
940 | # Dumping data for table 'groups' | |
941 | # | |
942 | ||
943 | # | |
944 | # Table structure for table 'intel_agreement' | |
945 | # | |
946 | ||
947 | CREATE TABLE intel_agreement ( | |
948 | user_id int(11) DEFAULT '0' NOT NULL, | |
949 | message text, | |
950 | is_approved int(11) DEFAULT '0' NOT NULL, | |
951 | PRIMARY KEY (user_id) | |
952 | ); | |
953 | ||
954 | # | |
955 | # Dumping data for table 'intel_agreement' | |
956 | # | |
957 | ||
958 | ||
959 | # | |
960 | # Table structure for table 'mail_group_list' | |
961 | # | |
962 | ||
963 | CREATE TABLE mail_group_list ( | |
964 | group_list_id int(11) NOT NULL auto_increment, | |
965 | group_id int(11) DEFAULT '0' NOT NULL, | |
966 | list_name text, | |
967 | is_public int(11) DEFAULT '0' NOT NULL, | |
968 | password varchar(16), | |
969 | list_admin int(11) DEFAULT '0' NOT NULL, | |
970 | status int(11) DEFAULT '0' NOT NULL, | |
971 | description text, | |
972 | PRIMARY KEY (group_list_id), | |
973 | KEY idx_mail_group_list_group (group_id) | |
974 | ); | |
975 | ||
976 | # | |
977 | # Dumping data for table 'mail_group_list' | |
978 | # | |
979 | ||
980 | ||
981 | # | |
982 | # Table structure for table 'news_bytes' | |
983 | # | |
984 | ||
985 | CREATE TABLE news_bytes ( | |
986 | id int(11) NOT NULL auto_increment, | |
987 | group_id int(11) DEFAULT '0' NOT NULL, | |
988 | submitted_by int(11) DEFAULT '0' NOT NULL, | |
989 | is_approved int(11) DEFAULT '0' NOT NULL, | |
990 | date int(11) DEFAULT '0' NOT NULL, | |
991 | forum_id int(11) DEFAULT '0' NOT NULL, | |
992 | summary text, | |
993 | details text, | |
994 | PRIMARY KEY (id), | |
995 | KEY idx_news_bytes_forum (forum_id), | |
996 | KEY idx_news_bytes_group (group_id), | |
997 | KEY idx_news_bytes_approved (is_approved) | |
998 | ); | |
999 | ||
1000 | # | |
1001 | # Dumping data for table 'news_bytes' | |
1002 | # | |
1003 | ||
1004 | ||
1005 | # | |
1006 | # Table structure for table 'patch' | |
1007 | # | |
1008 | ||
1009 | CREATE TABLE patch ( | |
1010 | patch_id int(11) NOT NULL auto_increment, | |
1011 | group_id int(11) DEFAULT '0' NOT NULL, | |
1012 | patch_status_id int(11) DEFAULT '0' NOT NULL, | |
1013 | patch_category_id int(11) DEFAULT '0' NOT NULL, | |
1014 | submitted_by int(11) DEFAULT '0' NOT NULL, | |
1015 | assigned_to int(11) DEFAULT '0' NOT NULL, | |
1016 | open_date int(11) DEFAULT '0' NOT NULL, | |
1017 | summary text, | |
1018 | code mediumtext, | |
1019 | close_date int(11) DEFAULT '0' NOT NULL, | |
1020 | PRIMARY KEY (patch_id), | |
1021 | KEY idx_patch_group_id (group_id) | |
1022 | ); | |
1023 | ||
1024 | # | |
1025 | # Dumping data for table 'patch' | |
1026 | # | |
1027 | ||
1028 | INSERT INTO patch VALUES (1,1,100,100,100,100,0,NULL,NULL,0); | |
1029 | ||
1030 | # | |
1031 | # Table structure for table 'patch_category' | |
1032 | # | |
1033 | ||
1034 | CREATE TABLE patch_category ( | |
1035 | patch_category_id int(11) NOT NULL auto_increment, | |
1036 | group_id int(11) DEFAULT '0' NOT NULL, | |
1037 | category_name text DEFAULT '' NOT NULL, | |
1038 | PRIMARY KEY (patch_category_id), | |
1039 | KEY idx_patch_group_group_id (group_id) | |
1040 | ); | |
1041 | ||
1042 | # | |
1043 | # Dumping data for table 'patch_category' | |
1044 | # | |
1045 | ||
1046 | INSERT INTO patch_category VALUES (100,1,'None'); | |
1047 | ||
1048 | # | |
1049 | # Table structure for table 'patch_history' | |
1050 | # | |
1051 | ||
1052 | CREATE TABLE patch_history ( | |
1053 | patch_history_id int(11) NOT NULL auto_increment, | |
1054 | patch_id int(11) DEFAULT '0' NOT NULL, | |
1055 | field_name text DEFAULT '' NOT NULL, | |
1056 | old_value text DEFAULT '' NOT NULL, | |
1057 | mod_by int(11) DEFAULT '0' NOT NULL, | |
1058 | date int(11), | |
1059 | PRIMARY KEY (patch_history_id), | |
1060 | KEY idx_patch_history_patch_id (patch_id) | |
1061 | ); | |
1062 | ||
1063 | # | |
1064 | # Dumping data for table 'patch_history' | |
1065 | # | |
1066 | ||
1067 | ||
1068 | # | |
1069 | # Table structure for table 'patch_status' | |
1070 | # | |
1071 | ||
1072 | CREATE TABLE patch_status ( | |
1073 | patch_status_id int(11) NOT NULL auto_increment, | |
1074 | status_name text, | |
1075 | PRIMARY KEY (patch_status_id) | |
1076 | ); | |
1077 | ||
1078 | # | |
1079 | # Dumping data for table 'patch_status' | |
1080 | # | |
1081 | ||
1082 | INSERT INTO patch_status VALUES (1,'Open'); | |
1083 | INSERT INTO patch_status VALUES (2,'Closed'); | |
1084 | INSERT INTO patch_status VALUES (3,'Deleted'); | |
1085 | INSERT INTO patch_status VALUES (4,'Postponed'); | |
1086 | INSERT INTO patch_status VALUES (100,'None'); | |
1087 | ||
1088 | # | |
1089 | # Table structure for table 'people_job' | |
1090 | # | |
1091 | ||
1092 | CREATE TABLE people_job ( | |
1093 | job_id int(11) NOT NULL auto_increment, | |
1094 | group_id int(11) DEFAULT '0' NOT NULL, | |
1095 | created_by int(11) DEFAULT '0' NOT NULL, | |
1096 | title text, | |
1097 | description text, | |
1098 | date int(11) DEFAULT '0' NOT NULL, | |
1099 | status_id int(11) DEFAULT '0' NOT NULL, | |
1100 | category_id int(11) DEFAULT '0' NOT NULL, | |
1101 | PRIMARY KEY (job_id) | |
1102 | ); | |
1103 | ||
1104 | # | |
1105 | # Dumping data for table 'people_job' | |
1106 | # | |
1107 | ||
1108 | ||
1109 | # | |
1110 | # Table structure for table 'people_job_category' | |
1111 | # | |
1112 | ||
1113 | CREATE TABLE people_job_category ( | |
1114 | category_id int(11) NOT NULL auto_increment, | |
1115 | name text, | |
1116 | PRIMARY KEY (category_id) | |
1117 | ); | |
1118 | ||
1119 | # | |
1120 | # Dumping data for table 'people_job_category' | |
1121 | # | |
1122 | ||
1123 | INSERT INTO people_job_category VALUES (1,'Developer'); | |
1124 | INSERT INTO people_job_category VALUES (2,'Project Manager'); | |
1125 | INSERT INTO people_job_category VALUES (3,'Unix Admin'); | |
1126 | INSERT INTO people_job_category VALUES (4,'Doc Writer'); | |
1127 | INSERT INTO people_job_category VALUES (5,'Tester'); | |
1128 | INSERT INTO people_job_category VALUES (6,'Support Manager'); | |
1129 | INSERT INTO people_job_category VALUES (7,'Graphic/Other Designer'); | |
1130 | ||
1131 | # | |
1132 | # Table structure for table 'people_job_inventory' | |
1133 | # | |
1134 | ||
1135 | CREATE TABLE people_job_inventory ( | |
1136 | job_inventory_id int(11) NOT NULL auto_increment, | |
1137 | job_id int(11) DEFAULT '0' NOT NULL, | |
1138 | skill_id int(11) DEFAULT '0' NOT NULL, | |
1139 | skill_level_id int(11) DEFAULT '0' NOT NULL, | |
1140 | skill_year_id int(11) DEFAULT '0' NOT NULL, | |
1141 | PRIMARY KEY (job_inventory_id) | |
1142 | ); | |
1143 | ||
1144 | # | |
1145 | # Dumping data for table 'people_job_inventory' | |
1146 | # | |
1147 | ||
1148 | ||
1149 | # | |
1150 | # Table structure for table 'people_job_status' | |
1151 | # | |
1152 | ||
1153 | CREATE TABLE people_job_status ( | |
1154 | status_id int(11) NOT NULL auto_increment, | |
1155 | name text, | |
1156 | PRIMARY KEY (status_id) | |
1157 | ); | |
1158 | ||
1159 | # | |
1160 | # Dumping data for table 'people_job_status' | |
1161 | # | |
1162 | ||
1163 | INSERT INTO people_job_status VALUES (1,'Open'); | |
1164 | INSERT INTO people_job_status VALUES (2,'Filled'); | |
1165 | INSERT INTO people_job_status VALUES (3,'Deleted'); | |
1166 | ||
1167 | # | |
1168 | # Table structure for table 'people_skill' | |
1169 | # | |
1170 | ||
1171 | CREATE TABLE people_skill ( | |
1172 | skill_id int(11) NOT NULL auto_increment, | |
1173 | name text, | |
1174 | PRIMARY KEY (skill_id) | |
1175 | ); | |
1176 | ||
1177 | # | |
1178 | # Dumping data for table 'people_skill' | |
1179 | # | |
1180 | ||
1181 | ||
1182 | # | |
1183 | # Table structure for table 'people_skill_inventory' | |
1184 | # | |
1185 | ||
1186 | CREATE TABLE people_skill_inventory ( | |
1187 | skill_inventory_id int(11) NOT NULL auto_increment, | |
1188 | user_id int(11) DEFAULT '0' NOT NULL, | |
1189 | skill_id int(11) DEFAULT '0' NOT NULL, | |
1190 | skill_level_id int(11) DEFAULT '0' NOT NULL, | |
1191 | skill_year_id int(11) DEFAULT '0' NOT NULL, | |
1192 | PRIMARY KEY (skill_inventory_id) | |
1193 | ); | |
1194 | ||
1195 | # | |
1196 | # Dumping data for table 'people_skill_inventory' | |
1197 | # | |
1198 | ||
1199 | ||
1200 | # | |
1201 | # Table structure for table 'people_skill_level' | |
1202 | # | |
1203 | ||
1204 | CREATE TABLE people_skill_level ( | |
1205 | skill_level_id int(11) NOT NULL auto_increment, | |
1206 | name text, | |
1207 | PRIMARY KEY (skill_level_id) | |
1208 | ); | |
1209 | ||
1210 | # | |
1211 | # Dumping data for table 'people_skill_level' | |
1212 | # | |
1213 | ||
1214 | INSERT INTO people_skill_level VALUES (1,'Want to Learn'); | |
1215 | INSERT INTO people_skill_level VALUES (2,'Competent'); | |
1216 | INSERT INTO people_skill_level VALUES (3,'Wizard'); | |
1217 | INSERT INTO people_skill_level VALUES (4,'Wrote The Book'); | |
1218 | INSERT INTO people_skill_level VALUES (5,'Wrote It'); | |
1219 | ||
1220 | # | |
1221 | # Table structure for table 'people_skill_year' | |
1222 | # | |
1223 | ||
1224 | CREATE TABLE people_skill_year ( | |
1225 | skill_year_id int(11) NOT NULL auto_increment, | |
1226 | name text, | |
1227 | PRIMARY KEY (skill_year_id) | |
1228 | ); | |
1229 | ||
1230 | # | |
1231 | # Dumping data for table 'people_skill_year' | |
1232 | # | |
1233 | ||
1234 | INSERT INTO people_skill_year VALUES (1,'< 6 Months'); | |
1235 | INSERT INTO people_skill_year VALUES (2,'6 Mo - 2 yr'); | |
1236 | INSERT INTO people_skill_year VALUES (3,'2 yr - 5 yr'); | |
1237 | INSERT INTO people_skill_year VALUES (4,'5 yr - 10 yr'); | |
1238 | INSERT INTO people_skill_year VALUES (5,'> 10 years'); | |
1239 | ||
1240 | # | |
1241 | # Table structure for table 'project_assigned_to' | |
1242 | # | |
1243 | ||
1244 | CREATE TABLE project_assigned_to ( | |
1245 | project_assigned_id int(11) NOT NULL auto_increment, | |
1246 | project_task_id int(11) DEFAULT '0' NOT NULL, | |
1247 | assigned_to_id int(11) DEFAULT '0' NOT NULL, | |
1248 | PRIMARY KEY (project_assigned_id), | |
1249 | KEY idx_project_assigned_to_task_id (project_task_id), | |
1250 | KEY idx_project_assigned_to_assigned_to (assigned_to_id) | |
1251 | ); | |
1252 | ||
1253 | # | |
1254 | # Dumping data for table 'project_assigned_to' | |
1255 | # | |
1256 | ||
1257 | ||
1258 | # | |
1259 | # Table structure for table 'project_counts_tmp' | |
1260 | # | |
1261 | ||
1262 | CREATE TABLE project_counts_tmp ( | |
1263 | group_id int(11), | |
1264 | type text, | |
1265 | count float(8,5) | |
1266 | ); | |
1267 | ||
1268 | # | |
1269 | # Dumping data for table 'project_counts_tmp' | |
1270 | # | |
1271 | ||
1272 | ||
1273 | # | |
1274 | # Table structure for table 'project_counts_weekly_tmp' | |
1275 | # | |
1276 | ||
1277 | CREATE TABLE project_counts_weekly_tmp ( | |
1278 | group_id int(11), | |
1279 | type text, | |
1280 | count float(8,5) | |
1281 | ); | |
1282 | ||
1283 | # | |
1284 | # Dumping data for table 'project_counts_weekly_tmp' | |
1285 | # | |
1286 | ||
1287 | ||
1288 | # | |
1289 | # Table structure for table 'project_dependencies' | |
1290 | # | |
1291 | ||
1292 | CREATE TABLE project_dependencies ( | |
1293 | project_depend_id int(11) NOT NULL auto_increment, | |
1294 | project_task_id int(11) DEFAULT '0' NOT NULL, | |
1295 | is_dependent_on_task_id int(11) DEFAULT '0' NOT NULL, | |
1296 | PRIMARY KEY (project_depend_id), | |
1297 | KEY idx_project_dependencies_task_id (project_task_id), | |
1298 | KEY idx_project_is_dependent_on_task_id (is_dependent_on_task_id) | |
1299 | ); | |
1300 | ||
1301 | # | |
1302 | # Dumping data for table 'project_dependencies' | |
1303 | # | |
1304 | ||
1305 | ||
1306 | # | |
1307 | # Table structure for table 'project_group_list' | |
1308 | # | |
1309 | ||
1310 | CREATE TABLE project_group_list ( | |
1311 | group_project_id int(11) NOT NULL auto_increment, | |
1312 | group_id int(11) DEFAULT '0' NOT NULL, | |
1313 | project_name text DEFAULT '' NOT NULL, | |
1314 | is_public int(11) DEFAULT '0' NOT NULL, | |
1315 | description text, | |
1316 | PRIMARY KEY (group_project_id), | |
1317 | KEY idx_project_group_list_group_id (group_id) | |
1318 | ); | |
1319 | ||
1320 | # | |
1321 | # Dumping data for table 'project_group_list' | |
1322 | # | |
1323 | ||
1324 | INSERT INTO project_group_list VALUES (1,1,'',0,NULL); | |
1325 | ||
1326 | # | |
1327 | # Table structure for table 'project_history' | |
1328 | # | |
1329 | ||
1330 | CREATE TABLE project_history ( | |
1331 | project_history_id int(11) NOT NULL auto_increment, | |
1332 | project_task_id int(11) DEFAULT '0' NOT NULL, | |
1333 | field_name text DEFAULT '' NOT NULL, | |
1334 | old_value text DEFAULT '' NOT NULL, | |
1335 | mod_by int(11) DEFAULT '0' NOT NULL, | |
1336 | date int(11) DEFAULT '0' NOT NULL, | |
1337 | PRIMARY KEY (project_history_id), | |
1338 | KEY idx_project_history_task_id (project_task_id) | |
1339 | ); | |
1340 | ||
1341 | # | |
1342 | # Dumping data for table 'project_history' | |
1343 | # | |
1344 | ||
1345 | ||
1346 | # | |
1347 | # Table structure for table 'project_metric' | |
1348 | # | |
1349 | ||
1350 | CREATE TABLE project_metric ( | |
1351 | ranking int(11) NOT NULL auto_increment, | |
1352 | percentile float(8,2), | |
1353 | group_id int(11) DEFAULT '0' NOT NULL, | |
1354 | PRIMARY KEY (ranking), | |
1355 | KEY idx_project_metric_group (group_id) | |
1356 | ); | |
1357 | ||
1358 | # | |
1359 | # Dumping data for table 'project_metric' | |
1360 | # | |
1361 | ||
1362 | ||
1363 | # | |
1364 | # Table structure for table 'project_metric_tmp1' | |
1365 | # | |
1366 | ||
1367 | CREATE TABLE project_metric_tmp1 ( | |
1368 | ranking int(11) NOT NULL auto_increment, | |
1369 | group_id int(11) DEFAULT '0' NOT NULL, | |
1370 | value float(8,5), | |
1371 | PRIMARY KEY (ranking) | |
1372 | ); | |
1373 | ||
1374 | # | |
1375 | # Dumping data for table 'project_metric_tmp1' | |
1376 | # | |
1377 | ||
1378 | ||
1379 | # | |
1380 | # Table structure for table 'project_metric_weekly_tmp1' | |
1381 | # | |
1382 | ||
1383 | CREATE TABLE project_metric_weekly_tmp1 ( | |
1384 | ranking int(11) NOT NULL auto_increment, | |
1385 | group_id int(11) DEFAULT '0' NOT NULL, | |
1386 | value float(8,5), | |
1387 | PRIMARY KEY (ranking) | |
1388 | ); | |
1389 | ||
1390 | # | |
1391 | # Dumping data for table 'project_metric_weekly_tmp1' | |
1392 | # | |
1393 | ||
1394 | ||
1395 | # | |
1396 | # Table structure for table 'project_status' | |
1397 | # | |
1398 | ||
1399 | CREATE TABLE project_status ( | |
1400 | status_id int(11) NOT NULL auto_increment, | |
1401 | status_name text DEFAULT '' NOT NULL, | |
1402 | PRIMARY KEY (status_id) | |
1403 | ); | |
1404 | ||
1405 | # | |
1406 | # Dumping data for table 'project_status' | |
1407 | # | |
1408 | ||
1409 | INSERT INTO project_status VALUES (1,'Open'); | |
1410 | INSERT INTO project_status VALUES (2,'Closed'); | |
1411 | INSERT INTO project_status VALUES (100,'None'); | |
1412 | INSERT INTO project_status VALUES (3,'Deleted'); | |
1413 | ||
1414 | # | |
1415 | # Table structure for table 'project_task' | |
1416 | # | |
1417 | ||
1418 | CREATE TABLE project_task ( | |
1419 | project_task_id int(11) NOT NULL auto_increment, | |
1420 | group_project_id int(11) DEFAULT '0' NOT NULL, | |
1421 | summary text DEFAULT '' NOT NULL, | |
1422 | details text DEFAULT '' NOT NULL, | |
1423 | percent_complete int(11) DEFAULT '0' NOT NULL, | |
1424 | priority int(11) DEFAULT '0' NOT NULL, | |
1425 | hours float(10,2) DEFAULT '0.00' NOT NULL, | |
1426 | start_date int(11) DEFAULT '0' NOT NULL, | |
1427 | end_date int(11) DEFAULT '0' NOT NULL, | |
1428 | created_by int(11) DEFAULT '0' NOT NULL, | |
1429 | status_id int(11) DEFAULT '0' NOT NULL, | |
1430 | PRIMARY KEY (project_task_id), | |
1431 | KEY idx_project_task_group_project_id (group_project_id) | |
1432 | ); | |
1433 | ||
1434 | # | |
1435 | # Dumping data for table 'project_task' | |
1436 | # | |
1437 | ||
1438 | INSERT INTO project_task VALUES (1,1,'','',0,0,0.00,0,0,100,100); | |
1439 | ||
1440 | # | |
1441 | # Table structure for table 'project_weekly_metric' | |
1442 | # | |
1443 | ||
1444 | CREATE TABLE project_weekly_metric ( | |
1445 | ranking int(11) NOT NULL auto_increment, | |
1446 | percentile float(8,2), | |
1447 | group_id int(11) DEFAULT '0' NOT NULL, | |
1448 | PRIMARY KEY (ranking), | |
1449 | KEY idx_project_metric_weekly_group (group_id) | |
1450 | ); | |
1451 | ||
1452 | # | |
1453 | # Dumping data for table 'project_weekly_metric' | |
1454 | # | |
1455 | ||
1456 | ||
1457 | # | |
1458 | # Table structure for table 'session' | |
1459 | # | |
1460 | ||
1461 | CREATE TABLE session ( | |
1462 | user_id int(11) DEFAULT '0' NOT NULL, | |
1463 | session_hash char(32) DEFAULT '' NOT NULL, | |
1464 | ip_addr char(15) DEFAULT '' NOT NULL, | |
1465 | time int(11) DEFAULT '0' NOT NULL, | |
1466 | PRIMARY KEY (session_hash), | |
1467 | KEY idx_session_user_id (user_id), | |
1468 | KEY time_idx (time), | |
1469 | KEY idx_session_time (time) | |
1470 | ); | |
1471 | ||
1472 | # | |
1473 | # Dumping data for table 'session' | |
1474 | # | |
1475 | ||
1476 | # | |
1477 | # Table structure for table 'snippet' | |
1478 | # | |
1479 | ||
1480 | CREATE TABLE snippet ( | |
1481 | snippet_id int(11) NOT NULL auto_increment, | |
1482 | created_by int(11) DEFAULT '0' NOT NULL, | |
1483 | name text, | |
1484 | description text, | |
1485 | type int(11) DEFAULT '0' NOT NULL, | |
1486 | language int(11) DEFAULT '0' NOT NULL, | |
1487 | license text DEFAULT '' NOT NULL, | |
1488 | category int(11) DEFAULT '0' NOT NULL, | |
1489 | PRIMARY KEY (snippet_id), | |
1490 | KEY idx_snippet_language (language), | |
1491 | KEY idx_snippet_category (category) | |
1492 | ); | |
1493 | ||
1494 | # | |
1495 | # Dumping data for table 'snippet' | |
1496 | # | |
1497 | ||
1498 | ||
1499 | # | |
1500 | # Table structure for table 'snippet_package' | |
1501 | # | |
1502 | ||
1503 | CREATE TABLE snippet_package ( | |
1504 | snippet_package_id int(11) NOT NULL auto_increment, | |
1505 | created_by int(11) DEFAULT '0' NOT NULL, | |
1506 | name text, | |
1507 | description text, | |
1508 | category int(11) DEFAULT '0' NOT NULL, | |
1509 | language int(11) DEFAULT '0' NOT NULL, | |
1510 | PRIMARY KEY (snippet_package_id), | |
1511 | KEY idx_snippet_package_language (language), | |
1512 | KEY idx_snippet_package_category (category) | |
1513 | ); | |
1514 | ||
1515 | # | |
1516 | # Dumping data for table 'snippet_package' | |
1517 | # | |
1518 | ||
1519 | ||
1520 | # | |
1521 | # Table structure for table 'snippet_package_item' | |
1522 | # | |
1523 | ||
1524 | CREATE TABLE snippet_package_item ( | |
1525 | snippet_package_item_id int(11) NOT NULL auto_increment, | |
1526 | snippet_package_version_id int(11) DEFAULT '0' NOT NULL, | |
1527 | snippet_version_id int(11) DEFAULT '0' NOT NULL, | |
1528 | PRIMARY KEY (snippet_package_item_id), | |
1529 | KEY idx_snippet_package_item_pkg_ver (snippet_package_version_id) | |
1530 | ); | |
1531 | ||
1532 | # | |
1533 | # Dumping data for table 'snippet_package_item' | |
1534 | # | |
1535 | ||
1536 | ||
1537 | # | |
1538 | # Table structure for table 'snippet_package_version' | |
1539 | # | |
1540 | ||
1541 | CREATE TABLE snippet_package_version ( | |
1542 | snippet_package_version_id int(11) NOT NULL auto_increment, | |
1543 | snippet_package_id int(11) DEFAULT '0' NOT NULL, | |
1544 | changes text, | |
1545 | version text, | |
1546 | submitted_by int(11) DEFAULT '0' NOT NULL, | |
1547 | date int(11) DEFAULT '0' NOT NULL, | |
1548 | PRIMARY KEY (snippet_package_version_id), | |
1549 | KEY idx_snippet_package_version_pkg_id (snippet_package_id) | |
1550 | ); | |
1551 | ||
1552 | # | |
1553 | # Dumping data for table 'snippet_package_version' | |
1554 | # | |
1555 | ||
1556 | ||
1557 | # | |
1558 | # Table structure for table 'snippet_version' | |
1559 | # | |
1560 | ||
1561 | CREATE TABLE snippet_version ( | |
1562 | snippet_version_id int(11) NOT NULL auto_increment, | |
1563 | snippet_id int(11) DEFAULT '0' NOT NULL, | |
1564 | changes text, | |
1565 | version text, | |
1566 | submitted_by int(11) DEFAULT '0' NOT NULL, | |
1567 | date int(11) DEFAULT '0' NOT NULL, | |
1568 | code text, | |
1569 | PRIMARY KEY (snippet_version_id), | |
1570 | KEY idx_snippet_version_snippet_id (snippet_id) | |
1571 | ); | |
1572 | ||
1573 | # | |
1574 | # Dumping data for table 'snippet_version' | |
1575 | # | |
1576 | ||
1577 | ||
1578 | # | |
1579 | # Table structure for table 'stats_agg_logo_by_day' | |
1580 | # | |
1581 | ||
1582 | CREATE TABLE stats_agg_logo_by_day ( | |
1583 | day int(11), | |
1584 | count int(11) | |
1585 | ); | |
1586 | ||
1587 | # | |
1588 | # Dumping data for table 'stats_agg_logo_by_day' | |
1589 | # | |
1590 | ||
1591 | ||
1592 | # | |
1593 | # Table structure for table 'stats_agg_logo_by_group' | |
1594 | # | |
1595 | ||
1596 | CREATE TABLE stats_agg_logo_by_group ( | |
1597 | day int(11), | |
1598 | group_id int(11), | |
1599 | count int(11) | |
1600 | ); | |
1601 | ||
1602 | # | |
1603 | # Dumping data for table 'stats_agg_logo_by_group' | |
1604 | # | |
1605 | ||
1606 | ||
1607 | # | |
1608 | # Table structure for table 'stats_agg_pages_by_browser' | |
1609 | # | |
1610 | ||
1611 | CREATE TABLE stats_agg_pages_by_browser ( | |
1612 | browser varchar(8), | |
1613 | count int(11) | |
1614 | ); | |
1615 | ||
1616 | # | |
1617 | # Dumping data for table 'stats_agg_pages_by_browser' | |
1618 | # | |
1619 | ||
1620 | ||
1621 | # | |
1622 | # Table structure for table 'stats_agg_pages_by_day' | |
1623 | # | |
1624 | ||
1625 | CREATE TABLE stats_agg_pages_by_day ( | |
1626 | day int(11) DEFAULT '0' NOT NULL, | |
1627 | count int(11) DEFAULT '0' NOT NULL, | |
1628 | KEY idx_pages_by_day_day (day) | |
1629 | ); | |
1630 | ||
1631 | # | |
1632 | # Dumping data for table 'stats_agg_pages_by_day' | |
1633 | # | |
1634 | ||
1635 | ||
1636 | # | |
1637 | # Table structure for table 'stats_agg_pages_by_day_old' | |
1638 | # | |
1639 | ||
1640 | CREATE TABLE stats_agg_pages_by_day_old ( | |
1641 | day int(11), | |
1642 | count int(11) | |
1643 | ); | |
1644 | ||
1645 | # | |
1646 | # Dumping data for table 'stats_agg_pages_by_day_old' | |
1647 | # | |
1648 | ||
1649 | ||
1650 | # | |
1651 | # Table structure for table 'stats_agg_site_by_day' | |
1652 | # | |
1653 | ||
1654 | CREATE TABLE stats_agg_site_by_day ( | |
1655 | day int(11) DEFAULT '0' NOT NULL, | |
1656 | count int(11) DEFAULT '0' NOT NULL | |
1657 | ); | |
1658 | ||
1659 | # | |
1660 | # Dumping data for table 'stats_agg_site_by_day' | |
1661 | # | |
1662 | ||
1663 | ||
1664 | # | |
1665 | # Table structure for table 'stats_agg_site_by_group' | |
1666 | # | |
1667 | ||
1668 | CREATE TABLE stats_agg_site_by_group ( | |
1669 | day int(11) DEFAULT '0' NOT NULL, | |
1670 | group_id int(11) DEFAULT '0' NOT NULL, | |
1671 | count int(11) DEFAULT '0' NOT NULL | |
1672 | ); | |
1673 | ||
1674 | # | |
1675 | # Dumping data for table 'stats_agg_site_by_group' | |
1676 | # | |
1677 | ||
1678 | ||
1679 | # | |
1680 | # Table structure for table 'stats_agr_filerelease' | |
1681 | # | |
1682 | ||
1683 | CREATE TABLE stats_agr_filerelease ( | |
1684 | filerelease_id int(11) DEFAULT '0' NOT NULL, | |
1685 | group_id int(11) DEFAULT '0' NOT NULL, | |
1686 | downloads int(11) DEFAULT '0' NOT NULL, | |
1687 | KEY idx_stats_agr_tmp_fid (filerelease_id), | |
1688 | KEY idx_stats_agr_tmp_gid (group_id) | |
1689 | ); | |
1690 | ||
1691 | # | |
1692 | # Dumping data for table 'stats_agr_filerelease' | |
1693 | # | |
1694 | ||
1695 | ||
1696 | # | |
1697 | # Table structure for table 'stats_agr_project' | |
1698 | # | |
1699 | ||
1700 | CREATE TABLE stats_agr_project ( | |
1701 | group_id int(11) DEFAULT '0' NOT NULL, | |
1702 | group_ranking int(11) DEFAULT '0' NOT NULL, | |
1703 | group_metric float(8,5) DEFAULT '0.00000' NOT NULL, | |
1704 | developers smallint(6) DEFAULT '0' NOT NULL, | |
1705 | file_releases smallint(6) DEFAULT '0' NOT NULL, | |
1706 | downloads int(11) DEFAULT '0' NOT NULL, | |
1707 | site_views int(11) DEFAULT '0' NOT NULL, | |
1708 | logo_views int(11) DEFAULT '0' NOT NULL, | |
1709 | msg_posted smallint(6) DEFAULT '0' NOT NULL, | |
1710 | msg_uniq_auth smallint(6) DEFAULT '0' NOT NULL, | |
1711 | bugs_opened smallint(6) DEFAULT '0' NOT NULL, | |
1712 | bugs_closed smallint(6) DEFAULT '0' NOT NULL, | |
1713 | support_opened smallint(6) DEFAULT '0' NOT NULL, | |
1714 | support_closed smallint(6) DEFAULT '0' NOT NULL, | |
1715 | patches_opened smallint(6) DEFAULT '0' NOT NULL, | |
1716 | patches_closed smallint(6) DEFAULT '0' NOT NULL, | |
1717 | tasks_opened smallint(6) DEFAULT '0' NOT NULL, | |
1718 | tasks_closed smallint(6) DEFAULT '0' NOT NULL, | |
1719 | help_requests smallint(6) DEFAULT '0' NOT NULL, | |
1720 | cvs_checkouts smallint(6) DEFAULT '0' NOT NULL, | |
1721 | cvs_commits smallint(6) DEFAULT '0' NOT NULL, | |
1722 | cvs_adds smallint(6) DEFAULT '0' NOT NULL, | |
1723 | KEY idx_project_agr_log_group (group_id) | |
1724 | ); | |
1725 | ||
1726 | # | |
1727 | # Dumping data for table 'stats_agr_project' | |
1728 | # | |
1729 | ||
1730 | ||
1731 | # | |
1732 | # Table structure for table 'stats_ftp_downloads' | |
1733 | # | |
1734 | ||
1735 | CREATE TABLE stats_ftp_downloads ( | |
1736 | day int(11) DEFAULT '0' NOT NULL, | |
1737 | filerelease_id int(11) DEFAULT '0' NOT NULL, | |
1738 | group_id int(11) DEFAULT '0' NOT NULL, | |
1739 | downloads int(11) DEFAULT '0' NOT NULL, | |
1740 | KEY idx_ftpdl_day (day), | |
1741 | KEY idx_ftpdl_fid (filerelease_id), | |
1742 | KEY idx_ftpdl_group_id (group_id) | |
1743 | ); | |
1744 | ||
1745 | # | |
1746 | # Dumping data for table 'stats_ftp_downloads' | |
1747 | # | |
1748 | ||
1749 | ||
1750 | # | |
1751 | # Table structure for table 'stats_http_downloads' | |
1752 | # | |
1753 | ||
1754 | CREATE TABLE stats_http_downloads ( | |
1755 | day int(11) DEFAULT '0' NOT NULL, | |
1756 | filerelease_id int(11) DEFAULT '0' NOT NULL, | |
1757 | group_id int(11) DEFAULT '0' NOT NULL, | |
1758 | downloads int(11) DEFAULT '0' NOT NULL, | |
1759 | KEY idx_httpdl_day (day), | |
1760 | KEY idx_httpdl_fid (filerelease_id), | |
1761 | KEY idx_httpdl_group_id (group_id) | |
1762 | ); | |
1763 | ||
1764 | # | |
1765 | # Dumping data for table 'stats_http_downloads' | |
1766 | # | |
1767 | ||
1768 | ||
1769 | # | |
1770 | # Table structure for table 'stats_project' | |
1771 | # | |
1772 | ||
1773 | CREATE TABLE stats_project ( | |
1774 | month int(11) DEFAULT '0' NOT NULL, | |
1775 | week int(11) DEFAULT '0' NOT NULL, | |
1776 | day int(11) DEFAULT '0' NOT NULL, | |
1777 | group_id int(11) DEFAULT '0' NOT NULL, | |
1778 | group_ranking int(11) DEFAULT '0' NOT NULL, | |
1779 | group_metric float(8,5) DEFAULT '0.00000' NOT NULL, | |
1780 | developers smallint(6) DEFAULT '0' NOT NULL, | |
1781 | file_releases smallint(6) DEFAULT '0' NOT NULL, | |
1782 | downloads int(11) DEFAULT '0' NOT NULL, | |
1783 | site_views int(11) DEFAULT '0' NOT NULL, | |
1784 | subdomain_views int(11) DEFAULT '0' NOT NULL, | |
1785 | msg_posted smallint(6) DEFAULT '0' NOT NULL, | |
1786 | msg_uniq_auth smallint(6) DEFAULT '0' NOT NULL, | |
1787 | bugs_opened smallint(6) DEFAULT '0' NOT NULL, | |
1788 | bugs_closed smallint(6) DEFAULT '0' NOT NULL, | |
1789 | support_opened smallint(6) DEFAULT '0' NOT NULL, | |
1790 | support_closed smallint(6) DEFAULT '0' NOT NULL, | |
1791 | patches_opened smallint(6) DEFAULT '0' NOT NULL, | |
1792 | patches_closed smallint(6) DEFAULT '0' NOT NULL, | |
1793 | tasks_opened smallint(6) DEFAULT '0' NOT NULL, | |
1794 | tasks_closed smallint(6) DEFAULT '0' NOT NULL, | |
1795 | help_requests smallint(6) DEFAULT '0' NOT NULL, | |
1796 | cvs_checkouts smallint(6) DEFAULT '0' NOT NULL, | |
1797 | cvs_commits smallint(6) DEFAULT '0' NOT NULL, | |
1798 | cvs_adds smallint(6) DEFAULT '0' NOT NULL, | |
1799 | KEY idx_project_log_group (group_id), | |
1800 | KEY idx_archive_project_month (month), | |
1801 | KEY idx_archive_project_week (week), | |
1802 | KEY idx_archive_project_day (day), | |
1803 | KEY idx_archive_project_monthday (month,day) | |
1804 | ); | |
1805 | ||
1806 | # | |
1807 | # Dumping data for table 'stats_project' | |
1808 | # | |
1809 | ||
1810 | ||
1811 | # | |
1812 | # Table structure for table 'stats_project_tmp' | |
1813 | # | |
1814 | ||
1815 | CREATE TABLE stats_project_tmp ( | |
1816 | month int(11) DEFAULT '0' NOT NULL, | |
1817 | week int(11) DEFAULT '0' NOT NULL, | |
1818 | day int(11) DEFAULT '0' NOT NULL, | |
1819 | group_id int(11) DEFAULT '0' NOT NULL, | |
1820 | group_ranking int(11) DEFAULT '0' NOT NULL, | |
1821 | group_metric float(8,5) DEFAULT '0.00000' NOT NULL, | |
1822 | developers smallint(6) DEFAULT '0' NOT NULL, | |
1823 | file_releases smallint(6) DEFAULT '0' NOT NULL, | |
1824 | downloads int(11) DEFAULT '0' NOT NULL, | |
1825 | site_views int(11) DEFAULT '0' NOT NULL, | |
1826 | subdomain_views int(11) DEFAULT '0' NOT NULL, | |
1827 | msg_posted smallint(6) DEFAULT '0' NOT NULL, | |
1828 | msg_uniq_auth smallint(6) DEFAULT '0' NOT NULL, | |
1829 | bugs_opened smallint(6) DEFAULT '0' NOT NULL, | |
1830 | bugs_closed smallint(6) DEFAULT '0' NOT NULL, | |
1831 | support_opened smallint(6) DEFAULT '0' NOT NULL, | |
1832 | support_closed smallint(6) DEFAULT '0' NOT NULL, | |
1833 | patches_opened smallint(6) DEFAULT '0' NOT NULL, | |
1834 | patches_closed smallint(6) DEFAULT '0' NOT NULL, | |
1835 | tasks_opened smallint(6) DEFAULT '0' NOT NULL, | |
1836 | tasks_closed smallint(6) DEFAULT '0' NOT NULL, | |
1837 | help_requests smallint(6) DEFAULT '0' NOT NULL, | |
1838 | cvs_checkouts smallint(6) DEFAULT '0' NOT NULL, | |
1839 | cvs_commits smallint(6) DEFAULT '0' NOT NULL, | |
1840 | cvs_adds smallint(6) DEFAULT '0' NOT NULL, | |
1841 | KEY idx_project_log_group (group_id), | |
1842 | KEY idx_project_stats_day (day), | |
1843 | KEY idx_project_stats_week (week), | |
1844 | KEY idx_project_stats_month (month) | |
1845 | ); | |
1846 | ||
1847 | # | |
1848 | # Dumping data for table 'stats_project_tmp' | |
1849 | # | |
1850 | ||
1851 | ||
1852 | # | |
1853 | # Table structure for table 'stats_site' | |
1854 | # | |
1855 | ||
1856 | CREATE TABLE stats_site ( | |
1857 | month int(11) DEFAULT '0' NOT NULL, | |
1858 | week int(11) DEFAULT '0' NOT NULL, | |
1859 | day int(11) DEFAULT '0' NOT NULL, | |
1860 | site_views int(11) DEFAULT '0' NOT NULL, | |
1861 | subdomain_views int(11) DEFAULT '0' NOT NULL, | |
1862 | downloads int(11) DEFAULT '0' NOT NULL, | |
1863 | uniq_users int(11) DEFAULT '0' NOT NULL, | |
1864 | sessions int(11) DEFAULT '0' NOT NULL, | |
1865 | total_users int(11) DEFAULT '0' NOT NULL, | |
1866 | new_users int(11) DEFAULT '0' NOT NULL, | |
1867 | new_projects int(11) DEFAULT '0' NOT NULL, | |
1868 | KEY idx_stats_site_month (month), | |
1869 | KEY idx_stats_site_week (week), | |
1870 | KEY idx_stats_site_day (day), | |
1871 | KEY idx_stats_site_monthday (month,day) | |
1872 | ); | |
1873 | ||
1874 | # | |
1875 | # Dumping data for table 'stats_site' | |
1876 | # | |
1877 | ||
1878 | ||
1879 | # | |
1880 | # Table structure for table 'support' | |
1881 | # | |
1882 | ||
1883 | CREATE TABLE support ( | |
1884 | support_id int(11) NOT NULL auto_increment, | |
1885 | group_id int(11) DEFAULT '0' NOT NULL, | |
1886 | support_status_id int(11) DEFAULT '0' NOT NULL, | |
1887 | support_category_id int(11) DEFAULT '0' NOT NULL, | |
1888 | priority int(11) DEFAULT '0' NOT NULL, | |
1889 | submitted_by int(11) DEFAULT '0' NOT NULL, | |
1890 | assigned_to int(11) DEFAULT '0' NOT NULL, | |
1891 | open_date int(11) DEFAULT '0' NOT NULL, | |
1892 | summary text, | |
1893 | close_date int(11) DEFAULT '0' NOT NULL, | |
1894 | PRIMARY KEY (support_id), | |
1895 | KEY idx_support_group_id (group_id) | |
1896 | ); | |
1897 | ||
1898 | # | |
1899 | # Dumping data for table 'support' | |
1900 | # | |
1901 | ||
1902 | ||
1903 | # | |
1904 | # Table structure for table 'support_canned_responses' | |
1905 | # | |
1906 | ||
1907 | CREATE TABLE support_canned_responses ( | |
1908 | support_canned_id int(11) NOT NULL auto_increment, | |
1909 | group_id int(11) DEFAULT '0' NOT NULL, | |
1910 | title text, | |
1911 | body text, | |
1912 | PRIMARY KEY (support_canned_id), | |
1913 | KEY idx_support_canned_response_group_id (group_id) | |
1914 | ); | |
1915 | ||
1916 | # | |
1917 | # Dumping data for table 'support_canned_responses' | |
1918 | # | |
1919 | ||
1920 | ||
1921 | # | |
1922 | # Table structure for table 'support_category' | |
1923 | # | |
1924 | ||
1925 | CREATE TABLE support_category ( | |
1926 | support_category_id int(11) NOT NULL auto_increment, | |
1927 | group_id int(11) DEFAULT '0' NOT NULL, | |
1928 | category_name text DEFAULT '' NOT NULL, | |
1929 | PRIMARY KEY (support_category_id), | |
1930 | KEY idx_support_group_group_id (group_id) | |
1931 | ); | |
1932 | ||
1933 | # | |
1934 | # Dumping data for table 'support_category' | |
1935 | # | |
1936 | ||
1937 | INSERT INTO support_category VALUES (100,1,'None'); | |
1938 | ||
1939 | # | |
1940 | # Table structure for table 'support_history' | |
1941 | # | |
1942 | ||
1943 | CREATE TABLE support_history ( | |
1944 | support_history_id int(11) NOT NULL auto_increment, | |
1945 | support_id int(11) DEFAULT '0' NOT NULL, | |
1946 | field_name text DEFAULT '' NOT NULL, | |
1947 | old_value text DEFAULT '' NOT NULL, | |
1948 | mod_by int(11) DEFAULT '0' NOT NULL, | |
1949 | date int(11), | |
1950 | PRIMARY KEY (support_history_id), | |
1951 | KEY idx_support_history_support_id (support_id) | |
1952 | ); | |
1953 | ||
1954 | # | |
1955 | # Dumping data for table 'support_history' | |
1956 | # | |
1957 | ||
1958 | ||
1959 | # | |
1960 | # Table structure for table 'support_messages' | |
1961 | # | |
1962 | ||
1963 | CREATE TABLE support_messages ( | |
1964 | support_message_id int(11) NOT NULL auto_increment, | |
1965 | support_id int(11) DEFAULT '0' NOT NULL, | |
1966 | from_email text, | |
1967 | date int(11) DEFAULT '0' NOT NULL, | |
1968 | body text, | |
1969 | PRIMARY KEY (support_message_id), | |
1970 | KEY idx_support_messages_support_id (support_id) | |
1971 | ); | |
1972 | ||
1973 | # | |
1974 | # Dumping data for table 'support_messages' | |
1975 | # | |
1976 | ||
1977 | ||
1978 | # | |
1979 | # Table structure for table 'support_status' | |
1980 | # | |
1981 | ||
1982 | CREATE TABLE support_status ( | |
1983 | support_status_id int(11) NOT NULL auto_increment, | |
1984 | status_name text, | |
1985 | PRIMARY KEY (support_status_id) | |
1986 | ); | |
1987 | ||
1988 | # | |
1989 | # Dumping data for table 'support_status' | |
1990 | # | |
1991 | ||
1992 | INSERT INTO support_status VALUES (1,'Open'); | |
1993 | INSERT INTO support_status VALUES (2,'Closed'); | |
1994 | INSERT INTO support_status VALUES (3,'Deleted'); | |
1995 | ||
1996 | # | |
1997 | # Table structure for table 'supported_languages' | |
1998 | # | |
1999 | ||
2000 | CREATE TABLE supported_languages ( | |
2001 | language_id int(11) NOT NULL auto_increment, | |
2002 | name text, | |
2003 | filename text, | |
2004 | classname text, | |
2005 | language_code char(2), | |
2006 | PRIMARY KEY (language_id), | |
2007 | KEY idx_supported_languages_code (language_code) | |
2008 | ); | |
2009 | ||
2010 | # | |
2011 | # Dumping data for table 'supported_languages' | |
2012 | # | |
2013 | ||
2014 | INSERT INTO supported_languages VALUES (1,'English','English.class','English','en'); | |
2015 | INSERT INTO supported_languages VALUES (2,'Japanese','Japanese.class','Japanese','ja'); | |
2016 | INSERT INTO supported_languages VALUES (3,'Hebrew','Hebrew.class','Hebrew','ir'); | |
2017 | INSERT INTO supported_languages VALUES (4,'Spanish','Spanish.class','Spanish','es'); | |
2018 | INSERT INTO supported_languages VALUES (5,'Thai','Thai.class','Thai','th'); | |
2019 | INSERT INTO supported_languages VALUES (6,'German','German.class','German','de'); | |
2020 | INSERT INTO supported_languages VALUES (7,'French','French.class','French','fr'); | |
2021 | INSERT INTO supported_languages VALUES (8,'Italian','Italian.class','Italian','it'); | |
2022 | INSERT INTO supported_languages VALUES (9,'Norwegian','Norwegian.class','Norwegian','no'); | |
2023 | INSERT INTO supported_languages VALUES (10,'Swedish','Swedish.class','Swedish','sv'); | |
2024 | INSERT INTO supported_languages VALUES (11,'Chinese','Chinese.class','Chinese','zh'); | |
2025 | INSERT INTO supported_languages VALUES (12,'Dutch','Dutch.class','Dutch','nl'); | |
2026 | INSERT INTO supported_languages VALUES (13,'Esperanto','Esperanto.class','Esperanto','eo'); | |
2027 | INSERT INTO supported_languages VALUES (14,'Catalan','Catalan.class','Catalan','ca'); | |
2028 | INSERT INTO supported_languages VALUES (15,'Polish','Polish.class','Polish','pl'); | |
2029 | INSERT INTO supported_languages VALUES (16,'Portuguese (Brazillian)','PortugueseBrazillian.class','PortugueseBrazillian','pt'); | |
2030 | INSERT INTO supported_languages VALUES (17,'Russian','Russian.class','Russian','ru'); | |
2031 | INSERT INTO supported_languages VALUES (18,'Portuguese','Portuguese.class','Portuguese','pt'); | |
2032 | INSERT INTO supported_languages VALUES (19,'Greek','Greek.class','Greek','el'); | |
2033 | INSERT INTO supported_languages VALUES (20,'Bulgarian','Bulgarian.class','Bulgarian','bg'); | |
2034 | INSERT INTO supported_languages VALUES (21,'Indonesian','Indonesian.class','Indonesian','id'); | |
2035 | ||
2036 | # | |
2037 | # Table structure for table 'survey_question_types' | |
2038 | # | |
2039 | ||
2040 | CREATE TABLE survey_question_types ( | |
2041 | id int(11) NOT NULL auto_increment, | |
2042 | type text DEFAULT '' NOT NULL, | |
2043 | PRIMARY KEY (id) | |
2044 | ); | |
2045 | ||
2046 | # | |
2047 | # Dumping data for table 'survey_question_types' | |
2048 | # | |
2049 | ||
2050 | INSERT INTO survey_question_types VALUES (1,'Radio Buttons 1-5'); | |
2051 | INSERT INTO survey_question_types VALUES (2,'Text Area'); | |
2052 | INSERT INTO survey_question_types VALUES (3,'Radio Buttons Yes/No'); | |
2053 | INSERT INTO survey_question_types VALUES (4,'Comment Only'); | |
2054 | INSERT INTO survey_question_types VALUES (5,'Text Field'); | |
2055 | INSERT INTO survey_question_types VALUES (100,'None'); | |
2056 | ||
2057 | # | |
2058 | # Table structure for table 'survey_questions' | |
2059 | # | |
2060 | ||
2061 | CREATE TABLE survey_questions ( | |
2062 | question_id int(11) NOT NULL auto_increment, | |
2063 | group_id int(11) DEFAULT '0' NOT NULL, | |
2064 | question text DEFAULT '' NOT NULL, | |
2065 | question_type int(11) DEFAULT '0' NOT NULL, | |
2066 | PRIMARY KEY (question_id), | |
2067 | KEY idx_survey_questions_group (group_id) | |
2068 | ); | |
2069 | ||
2070 | # | |
2071 | # Dumping data for table 'survey_questions' | |
2072 | # | |
2073 | ||
2074 | ||
2075 | # | |
2076 | # Table structure for table 'survey_rating_aggregate' | |
2077 | # | |
2078 | ||
2079 | CREATE TABLE survey_rating_aggregate ( | |
2080 | type int(11) DEFAULT '0' NOT NULL, | |
2081 | id int(11) DEFAULT '0' NOT NULL, | |
2082 | response float DEFAULT '0' NOT NULL, | |
2083 | count int(11) DEFAULT '0' NOT NULL, | |
2084 | KEY idx_survey_rating_aggregate_type_id (type,id) | |
2085 | ); | |
2086 | ||
2087 | # | |
2088 | # Dumping data for table 'survey_rating_aggregate' | |
2089 | # | |
2090 | ||
2091 | ||
2092 | # | |
2093 | # Table structure for table 'survey_rating_response' | |
2094 | # | |
2095 | ||
2096 | CREATE TABLE survey_rating_response ( | |
2097 | user_id int(11) DEFAULT '0' NOT NULL, | |
2098 | type int(11) DEFAULT '0' NOT NULL, | |
2099 | id int(11) DEFAULT '0' NOT NULL, | |
2100 | response int(11) DEFAULT '0' NOT NULL, | |
2101 | date int(11) DEFAULT '0' NOT NULL, | |
2102 | KEY idx_survey_rating_responses_user_type_id (user_id,type,id), | |
2103 | KEY idx_survey_rating_responses_type_id (type,id) | |
2104 | ); | |
2105 | ||
2106 | # | |
2107 | # Dumping data for table 'survey_rating_response' | |
2108 | # | |
2109 | ||
2110 | ||
2111 | # | |
2112 | # Table structure for table 'survey_responses' | |
2113 | # | |
2114 | ||
2115 | CREATE TABLE survey_responses ( | |
2116 | user_id int(11) DEFAULT '0' NOT NULL, | |
2117 | group_id int(11) DEFAULT '0' NOT NULL, | |
2118 | survey_id int(11) DEFAULT '0' NOT NULL, | |
2119 | question_id int(11) DEFAULT '0' NOT NULL, | |
2120 | response text DEFAULT '' NOT NULL, | |
2121 | date int(11) DEFAULT '0' NOT NULL, | |
2122 | KEY idx_survey_responses_user_survey (user_id,survey_id), | |
2123 | KEY idx_survey_responses_user_survey_question (user_id,survey_id,question_id), | |
2124 | KEY idx_survey_responses_survey_question (survey_id,question_id), | |
2125 | KEY idx_survey_responses_group_id (group_id) | |
2126 | ); | |
2127 | ||
2128 | # | |
2129 | # Dumping data for table 'survey_responses' | |
2130 | # | |
2131 | ||
2132 | ||
2133 | # | |
2134 | # Table structure for table 'surveys' | |
2135 | # | |
2136 | ||
2137 | CREATE TABLE surveys ( | |
2138 | survey_id int(11) NOT NULL auto_increment, | |
2139 | group_id int(11) DEFAULT '0' NOT NULL, | |
2140 | survey_title text DEFAULT '' NOT NULL, | |
2141 | survey_questions text DEFAULT '' NOT NULL, | |
2142 | is_active int(11) DEFAULT '1' NOT NULL, | |
2143 | PRIMARY KEY (survey_id), | |
2144 | KEY idx_surveys_group (group_id) | |
2145 | ); | |
2146 | ||
2147 | # | |
2148 | # Dumping data for table 'surveys' | |
2149 | # | |
2150 | ||
2151 | ||
2152 | # | |
2153 | # Table structure for table 'system_history' | |
2154 | # | |
2155 | ||
2156 | CREATE TABLE system_history ( | |
2157 | id int(11) NOT NULL auto_increment, | |
2158 | system_news_id int(11) DEFAULT '0' NOT NULL, | |
2159 | field_name text, | |
2160 | old_value text, | |
2161 | PRIMARY KEY (id) | |
2162 | ); | |
2163 | ||
2164 | # | |
2165 | # Dumping data for table 'system_history' | |
2166 | # | |
2167 | ||
2168 | ||
2169 | # | |
2170 | # Table structure for table 'system_machines' | |
2171 | # | |
2172 | ||
2173 | CREATE TABLE system_machines ( | |
2174 | id int(11) NOT NULL auto_increment, | |
2175 | machine_name text, | |
2176 | description text, | |
2177 | PRIMARY KEY (id) | |
2178 | ); | |
2179 | ||
2180 | # | |
2181 | # Dumping data for table 'system_machines' | |
2182 | # | |
2183 | ||
2184 | ||
2185 | # | |
2186 | # Table structure for table 'system_news' | |
2187 | # | |
2188 | ||
2189 | CREATE TABLE system_news ( | |
2190 | id int(11) NOT NULL auto_increment, | |
2191 | status_id int(11) DEFAULT '0' NOT NULL, | |
2192 | service_id int(11) DEFAULT '0' NOT NULL, | |
2193 | machine_id int(11) DEFAULT '0' NOT NULL, | |
2194 | priority int(11) DEFAULT '0' NOT NULL, | |
2195 | posted_by int(11) DEFAULT '0' NOT NULL, | |
2196 | summary text, | |
2197 | details text, | |
2198 | PRIMARY KEY (id) | |
2199 | ); | |
2200 | ||
2201 | # | |
2202 | # Dumping data for table 'system_news' | |
2203 | # | |
2204 | ||
2205 | ||
2206 | # | |
2207 | # Table structure for table 'system_services' | |
2208 | # | |
2209 | ||
2210 | CREATE TABLE system_services ( | |
2211 | id int(11) NOT NULL auto_increment, | |
2212 | service_name text, | |
2213 | PRIMARY KEY (id) | |
2214 | ); | |
2215 | ||
2216 | # | |
2217 | # Dumping data for table 'system_services' | |
2218 | # | |
2219 | ||
2220 | ||
2221 | # | |
2222 | # Table structure for table 'system_status' | |
2223 | # | |
2224 | ||
2225 | CREATE TABLE system_status ( | |
2226 | id int(11) NOT NULL auto_increment, | |
2227 | status_name text, | |
2228 | PRIMARY KEY (id) | |
2229 | ); | |
2230 | ||
2231 | # | |
2232 | # Dumping data for table 'system_status' | |
2233 | # | |
2234 | ||
2235 | ||
2236 | # | |
2237 | # Table structure for table 'theme_prefs' | |
2238 | # | |
2239 | ||
2240 | CREATE TABLE theme_prefs ( | |
2241 | user_id int(11) DEFAULT '0' NOT NULL, | |
2242 | user_theme int(8) DEFAULT '0' NOT NULL, | |
2243 | BODY_font char(80) DEFAULT '', | |
2244 | BODY_size char(5) DEFAULT '', | |
2245 | TITLEBAR_font char(80) DEFAULT '', | |
2246 | TITLEBAR_size char(5) DEFAULT '', | |
2247 | COLOR_TITLEBAR_BACK char(7) DEFAULT '', | |
2248 | COLOR_LTBACK1 char(7) DEFAULT '', | |
2249 | PRIMARY KEY (user_id) | |
2250 | ); | |
2251 | ||
2252 | # | |
2253 | # Dumping data for table 'theme_prefs' | |
2254 | # | |
2255 | ||
2256 | # | |
2257 | # Table structure for table 'themes' | |
2258 | # | |
2259 | ||
2260 | CREATE TABLE themes ( | |
2261 | theme_id int(11) NOT NULL auto_increment, | |
2262 | dirname varchar(80), | |
2263 | fullname varchar(80), | |
2264 | PRIMARY KEY (theme_id) | |
2265 | ); | |
2266 | ||
2267 | # | |
2268 | # Dumping data for table 'themes' | |
2269 | # | |
2270 | ||
2271 | INSERT INTO themes VALUES (1,'forged','Forged Metal'); | |
2272 | INSERT INTO themes VALUES (2,'classic','Classic Sourceforge'); | |
2273 | ||
2274 | # | |
2275 | # Table structure for table 'tmp_projs_releases_tmp' | |
2276 | # | |
2277 | ||
2278 | CREATE TABLE tmp_projs_releases_tmp ( | |
2279 | year int(11) DEFAULT '0' NOT NULL, | |
2280 | month int(11) DEFAULT '0' NOT NULL, | |
2281 | total_proj int(11) DEFAULT '0' NOT NULL, | |
2282 | total_releases int(11) DEFAULT '0' NOT NULL | |
2283 | ); | |
2284 | ||
2285 | # | |
2286 | # Dumping data for table 'tmp_projs_releases_tmp' | |
2287 | # | |
2288 | ||
2289 | ||
2290 | # | |
2291 | # Table structure for table 'top_group' | |
2292 | # | |
2293 | ||
2294 | CREATE TABLE top_group ( | |
2295 | group_id int(11) DEFAULT '0' NOT NULL, | |
2296 | group_name varchar(40), | |
2297 | downloads_all int(11) DEFAULT '0' NOT NULL, | |
2298 | rank_downloads_all int(11) DEFAULT '0' NOT NULL, | |
2299 | rank_downloads_all_old int(11) DEFAULT '0' NOT NULL, | |
2300 | downloads_week int(11) DEFAULT '0' NOT NULL, | |
2301 | rank_downloads_week int(11) DEFAULT '0' NOT NULL, | |
2302 | rank_downloads_week_old int(11) DEFAULT '0' NOT NULL, | |
2303 | userrank int(11) DEFAULT '0' NOT NULL, | |
2304 | rank_userrank int(11) DEFAULT '0' NOT NULL, | |
2305 | rank_userrank_old int(11) DEFAULT '0' NOT NULL, | |
2306 | forumposts_week int(11) DEFAULT '0' NOT NULL, | |
2307 | rank_forumposts_week int(11) DEFAULT '0' NOT NULL, | |
2308 | rank_forumposts_week_old int(11) DEFAULT '0' NOT NULL, | |
2309 | pageviews_proj int(11) DEFAULT '0' NOT NULL, | |
2310 | rank_pageviews_proj int(11) DEFAULT '0' NOT NULL, | |
2311 | rank_pageviews_proj_old int(11) DEFAULT '0' NOT NULL, | |
2312 | KEY rank_downloads_all_idx (rank_downloads_all), | |
2313 | KEY rank_downloads_week_idx (rank_downloads_week), | |
2314 | KEY rank_userrank_idx (rank_userrank), | |
2315 | KEY rank_forumposts_week_idx (rank_forumposts_week), | |
2316 | KEY pageviews_proj_idx (pageviews_proj) | |
2317 | ); | |
2318 | ||
2319 | # | |
2320 | # Dumping data for table 'top_group' | |
2321 | # | |
2322 | ||
2323 | ||
2324 | # | |
2325 | # Table structure for table 'trove_cat' | |
2326 | # | |
2327 | ||
2328 | CREATE TABLE trove_cat ( | |
2329 | trove_cat_id int(11) NOT NULL auto_increment, | |
2330 | version int(11) DEFAULT '0' NOT NULL, | |
2331 | parent int(11) DEFAULT '0' NOT NULL, | |
2332 | root_parent int(11) DEFAULT '0' NOT NULL, | |
2333 | shortname varchar(80), | |
2334 | fullname varchar(80), | |
2335 | description varchar(255), | |
2336 | count_subcat int(11) DEFAULT '0' NOT NULL, | |
2337 | count_subproj int(11) DEFAULT '0' NOT NULL, | |
2338 | fullpath text DEFAULT '' NOT NULL, | |
2339 | fullpath_ids text, | |
2340 | PRIMARY KEY (trove_cat_id), | |
2341 | KEY parent_idx (parent), | |
2342 | KEY root_parent_idx (root_parent), | |
2343 | KEY version_idx (version) | |
2344 | ); | |
2345 | ||
2346 | # | |
2347 | # Dumping data for table 'trove_cat' | |
2348 | # | |
2349 | ||
2350 | INSERT INTO trove_cat VALUES (1,2000031601,0,0,'audience','Intended Audience','The main class of people likely to be interested in this resource.',0,0,'Intended Audience','1'); | |
2351 | INSERT INTO trove_cat VALUES (2,2000032401,1,1,'endusers','End Users/Desktop','Programs and resources for software end users. Software for the desktop.',0,0,'Intended Audience :: End Users/Desktop','1 :: 2'); | |
2352 | INSERT INTO trove_cat VALUES (3,2000041101,1,1,'developers','Developers','Programs and resources for software developers, to include libraries.',0,0,'Intended Audience :: Developers','1 :: 3'); | |
2353 | INSERT INTO trove_cat VALUES (4,2000031601,1,1,'sysadmins','System Administrators','Programs and resources for people who administer computers and networks.',0,0,'Intended Audience :: System Administrators','1 :: 4'); | |
2354 | INSERT INTO trove_cat VALUES (5,2000040701,1,1,'other','Other Audience','Programs and resources for an unlisted audience.',0,0,'Intended Audience :: Other Audience','1 :: 5'); | |
2355 | INSERT INTO trove_cat VALUES (6,2000031601,0,0,'developmentstatus','Development Status','An indication of the development status of the software or resource.',0,0,'Development Status','6'); | |
2356 | INSERT INTO trove_cat VALUES (7,2000040701,6,6,'planning','1 - Planning','This resource is in the planning stages only. There is no code.',0,0,'Development Status :: 1 - Planning','6 :: 7'); | |
2357 | INSERT INTO trove_cat VALUES (8,2000040701,6,6,'prealpha','2 - Pre-Alpha','There is code for this project, but it is not usable except for further development.',0,0,'Development Status :: 2 - Pre-Alpha','6 :: 8'); | |
2358 | INSERT INTO trove_cat VALUES (9,2000041101,6,6,'alpha','3 - Alpha','Resource is in early development, and probably incomplete and/or extremely buggy.',0,0,'Development Status :: 3 - Alpha','6 :: 9'); | |
2359 | INSERT INTO trove_cat VALUES (10,2000040701,6,6,'beta','4 - Beta','Resource is in late phases of development. Deliverables are essentially complete, but may still have significant bugs.',0,0,'Development Status :: 4 - Beta','6 :: 10'); | |
2360 | INSERT INTO trove_cat VALUES (11,2000040701,6,6,'production','5 - Production/Stable','Deliverables are complete and usable by the intended audience.',0,0,'Development Status :: 5 - Production/Stable','6 :: 11'); | |
2361 | INSERT INTO trove_cat VALUES (12,2000040701,6,6,'mature','6 - Mature','This resource has an extensive history of successful use and has probably undergone several stable revisions.',0,0,'Development Status :: 6 - Mature','6 :: 12'); | |
2362 | INSERT INTO trove_cat VALUES (13,2000031601,0,0,'license','License','License terms under which the resource is distributed.',0,0,'License','13'); | |
2363 | INSERT INTO trove_cat VALUES (14,2000032401,13,13,'osi','OSI Approved','Licenses that have been approved by OSI as approved',0,0,'License :: OSI Approved','13 :: 14'); | |
2364 | INSERT INTO trove_cat VALUES (15,2000032001,14,13,'gpl','GNU General Public License (GPL)','GNU General Public License.',0,0,'License :: OSI Approved :: GNU General Public License (GPL)','13 :: 14 :: 15'); | |
2365 | INSERT INTO trove_cat VALUES (16,2000050801,14,13,'lgpl','GNU Lesser General Public License (LGPL)','GNU Lesser General Public License',0,0,'License :: OSI Approved :: GNU Lesser General Public License (LGPL)','13 :: 14 :: 16'); | |
2366 | INSERT INTO trove_cat VALUES (17,2000032001,14,13,'artistic','Artistic License','The Perl Artistic License',0,0,'License :: OSI Approved :: Artistic License','13 :: 14 :: 17'); | |
2367 | INSERT INTO trove_cat VALUES (18,2000031601,0,0,'topic','Topic','Topic categorization.',0,0,'Topic','18'); | |
2368 | INSERT INTO trove_cat VALUES (19,2000032001,136,18,'archiving','Archiving','Tools for maintaining and searching software or document archives.',0,0,'Topic :: System :: Archiving','18 :: 136 :: 19'); | |
2369 | INSERT INTO trove_cat VALUES (20,2000032401,18,18,'communications','Communications','Programs intended to facilitate communication between people.',0,0,'Topic :: Communications','18 :: 20'); | |
2370 | INSERT INTO trove_cat VALUES (21,2000031601,20,18,'bbs','BBS','Bulletin Board systems.',0,0,'Topic :: Communications :: BBS','18 :: 20 :: 21'); | |
2371 | INSERT INTO trove_cat VALUES (22,2000031601,20,18,'chat','Chat','Programs to support real-time communication over the Internet.',0,0,'Topic :: Communications :: Chat','18 :: 20 :: 22'); | |
2372 | INSERT INTO trove_cat VALUES (23,2000031601,22,18,'icq','ICQ','Programs to support ICQ.',0,0,'Topic :: Communications :: Chat :: ICQ','18 :: 20 :: 22 :: 23'); | |
2373 | INSERT INTO trove_cat VALUES (24,2000041101,22,18,'irc','Internet Relay Chat','Programs to support Internet Relay Chat.',0,0,'Topic :: Communications :: Chat :: Internet Relay Chat','18 :: 20 :: 22 :: 24'); | |
2374 | INSERT INTO trove_cat VALUES (25,2000031601,22,18,'talk','Unix Talk','Programs to support Unix Talk protocol.',0,0,'Topic :: Communications :: Chat :: Unix Talk','18 :: 20 :: 22 :: 25'); | |
2375 | INSERT INTO trove_cat VALUES (26,2000031601,22,18,'aim','AOL Instant Messanger','Programs to support AOL Instant Messanger.',0,0,'Topic :: Communications :: Chat :: AOL Instant Messanger','18 :: 20 :: 22 :: 26'); | |
2376 | INSERT INTO trove_cat VALUES (27,2000031601,20,18,'conferencing','Conferencing','Software to support real-time conferencing over the Internet.',0,0,'Topic :: Communications :: Conferencing','18 :: 20 :: 27'); | |
2377 | INSERT INTO trove_cat VALUES (28,2000031601,20,18,'email','Email','Programs for sending, processing, and handling electronic mail.',0,0,'Topic :: Communications :: Email','18 :: 20 :: 28'); | |
2378 | INSERT INTO trove_cat VALUES (29,2000031601,28,18,'filters','Filters','Content-driven filters and dispatchers for Email.',0,0,'Topic :: Communications :: Email :: Filters','18 :: 20 :: 28 :: 29'); | |
2379 | INSERT INTO trove_cat VALUES (30,2000031601,28,18,'listservers','Mailing List Servers','Tools for managing electronic mailing lists.',0,0,'Topic :: Communications :: Email :: Mailing List Servers','18 :: 20 :: 28 :: 30'); | |
2380 | INSERT INTO trove_cat VALUES (31,2000031601,28,18,'mua','Email Clients (MUA)','Programs for interactively reading and sending Email.',0,0,'Topic :: Communications :: Email :: Email Clients (MUA)','18 :: 20 :: 28 :: 31'); | |
2381 | INSERT INTO trove_cat VALUES (32,2000031601,28,18,'mta','Mail Transport Agents','Email transport and gatewaying software.',0,0,'Topic :: Communications :: Email :: Mail Transport Agents','18 :: 20 :: 28 :: 32'); | |
2382 | INSERT INTO trove_cat VALUES (33,2000031601,28,18,'postoffice','Post-Office','Programs to support post-office protocols, including POP and IMAP.',0,0,'Topic :: Communications :: Email :: Post-Office','18 :: 20 :: 28 :: 33'); | |
2383 | INSERT INTO trove_cat VALUES (34,2000031601,33,18,'pop3','POP3','Programs to support POP3 (Post-Office Protocol, version 3).',0,0,'Topic :: Communications :: Email :: Post-Office :: POP3','18 :: 20 :: 28 :: 33 :: 34'); | |
2384 | INSERT INTO trove_cat VALUES (35,2000031601,33,18,'imap','IMAP','Programs to support IMAP protocol (Internet Message Access Protocol).',0,0,'Topic :: Communications :: Email :: Post-Office :: IMAP','18 :: 20 :: 28 :: 33 :: 35'); | |
2385 | INSERT INTO trove_cat VALUES (36,2000031601,20,18,'fax','Fax','Tools for sending and receiving facsimile messages.',0,0,'Topic :: Communications :: Fax','18 :: 20 :: 36'); | |
2386 | INSERT INTO trove_cat VALUES (37,2000031601,20,18,'fido','FIDO','Tools for FIDOnet mail and echoes.',0,0,'Topic :: Communications :: FIDO','18 :: 20 :: 37'); | |
2387 | INSERT INTO trove_cat VALUES (38,2000031601,20,18,'hamradio','Ham Radio','Tools and resources for amateur radio.',0,0,'Topic :: Communications :: Ham Radio','18 :: 20 :: 38'); | |
2388 | INSERT INTO trove_cat VALUES (39,2000031601,20,18,'usenet','Usenet News','Software to support USENET news.',0,0,'Topic :: Communications :: Usenet News','18 :: 20 :: 39'); | |
2389 | INSERT INTO trove_cat VALUES (40,2000031601,20,18,'internetphone','Internet Phone','Software to support real-time speech communication over the Internet.',0,0,'Topic :: Communications :: Internet Phone','18 :: 20 :: 40'); | |
2390 | INSERT INTO trove_cat VALUES (41,2000031601,19,18,'packaging','Packaging','Tools for packing and unpacking multi-file formats. Includes data-only formats and software package systems.',0,0,'Topic :: System :: Archiving :: Packaging','18 :: 136 :: 19 :: 41'); | |
2391 | INSERT INTO trove_cat VALUES (42,2000031601,19,18,'compression','Compression','Tools and libraries for data compression.',0,0,'Topic :: System :: Archiving :: Compression','18 :: 136 :: 19 :: 42'); | |
2392 | INSERT INTO trove_cat VALUES (43,2000031601,18,18,'security','Security','Security-related software, to include system administration and cryptography.',0,0,'Topic :: Security','18 :: 43'); | |
2393 | INSERT INTO trove_cat VALUES (44,2000031601,43,18,'cryptography','Cryptography','Cryptography programs, algorithms, and libraries.',0,0,'Topic :: Security :: Cryptography','18 :: 43 :: 44'); | |
2394 | INSERT INTO trove_cat VALUES (45,2000031601,18,18,'development','Software Development','Software used to aid software development.',0,0,'Topic :: Software Development','18 :: 45'); | |
2395 | INSERT INTO trove_cat VALUES (46,2000031601,45,18,'build','Build Tools','Software for the build process.',0,0,'Topic :: Software Development :: Build Tools','18 :: 45 :: 46'); | |
2396 | INSERT INTO trove_cat VALUES (47,2000031601,45,18,'debuggers','Debuggers','Programs for controlling and monitoring the execution of compiled binaries.',0,0,'Topic :: Software Development :: Debuggers','18 :: 45 :: 47'); | |
2397 | INSERT INTO trove_cat VALUES (48,2000031601,45,18,'compilers','Compilers','Programs for compiling high-level languges into machine code.',0,0,'Topic :: Software Development :: Compilers','18 :: 45 :: 48'); | |
2398 | INSERT INTO trove_cat VALUES (49,2000031601,45,18,'interpreters','Interpreters','Programs for interpreting and executing high-level languages directly.',0,0,'Topic :: Software Development :: Interpreters','18 :: 45 :: 49'); | |
2399 | INSERT INTO trove_cat VALUES (50,2000031601,45,18,'objectbrokering','Object Brokering','Object brokering libraries and tools.',0,0,'Topic :: Software Development :: Object Brokering','18 :: 45 :: 50'); | |
2400 | INSERT INTO trove_cat VALUES (51,2000031601,50,18,'corba','CORBA','Tools for implementation and use of CORBA.',0,0,'Topic :: Software Development :: Object Brokering :: CORBA','18 :: 45 :: 50 :: 51'); | |
2401 | INSERT INTO trove_cat VALUES (52,2000031601,45,18,'versioncontrol','Version Control','Tools for managing multiple versions of evolving sources or documents.',0,0,'Topic :: Software Development :: Version Control','18 :: 45 :: 52'); | |
2402 | INSERT INTO trove_cat VALUES (53,2000031601,52,18,'cvs','CVS','Tools for CVS (Concurrent Versioning System).',0,0,'Topic :: Software Development :: Version Control :: CVS','18 :: 45 :: 52 :: 53'); | |
2403 | INSERT INTO trove_cat VALUES (54,2000031601,52,18,'rcs','RCS','Tools for RCS (Revision Control System).',0,0,'Topic :: Software Development :: Version Control :: RCS','18 :: 45 :: 52 :: 54'); | |
2404 | INSERT INTO trove_cat VALUES (55,2000031601,18,18,'desktop','Desktop Environment','Accessories, managers, and utilities for your GUI desktop.',0,0,'Topic :: Desktop Environment','18 :: 55'); | |
2405 | INSERT INTO trove_cat VALUES (56,2000031601,55,18,'windowmanagers','Window Managers','Programs that provide window control and application launching.',0,0,'Topic :: Desktop Environment :: Window Managers','18 :: 55 :: 56'); | |
2406 | INSERT INTO trove_cat VALUES (57,2000031601,55,18,'kde','K Desktop Environment (KDE)','Software for the KDE desktop.',0,0,'Topic :: Desktop Environment :: K Desktop Environment (KDE)','18 :: 55 :: 57'); | |
2407 | INSERT INTO trove_cat VALUES (58,2000031601,55,18,'gnome','Gnome','Software for the Gnome desktop.',0,0,'Topic :: Desktop Environment :: Gnome','18 :: 55 :: 58'); | |
2408 | INSERT INTO trove_cat VALUES (59,2000031601,56,18,'enlightenment','Enlightenment','Software for the Enlightenment window manager.',0,0,'Topic :: Desktop Environment :: Window Managers :: Enlightenment','18 :: 55 :: 56 :: 59'); | |
2409 | INSERT INTO trove_cat VALUES (60,2000031601,59,18,'themes','Themes','Themes for the Enlightenment window manager.',0,0,'Topic :: Desktop Environment :: Window Managers :: Enlightenment :: Themes','18 :: 55 :: 56 :: 59 :: 60'); | |
2410 | INSERT INTO trove_cat VALUES (61,2000031601,57,18,'themes','Themes','Themes for KDE.',0,0,'Topic :: Desktop Environment :: K Desktop Environment (KDE) :: Themes','18 :: 55 :: 57 :: 61'); | |
2411 | INSERT INTO trove_cat VALUES (62,2000031601,55,18,'screensavers','Screen Savers','Screen savers and lockers.',0,0,'Topic :: Desktop Environment :: Screen Savers','18 :: 55 :: 62'); | |
2412 | INSERT INTO trove_cat VALUES (63,2000032001,18,18,'editors','Text Editors','Programs for editing code and documents.',0,0,'Topic :: Text Editors','18 :: 63'); | |
2413 | INSERT INTO trove_cat VALUES (64,2000031601,63,18,'emacs','Emacs','GNU Emacs and its imitators and tools.',0,0,'Topic :: Text Editors :: Emacs','18 :: 63 :: 64'); | |
2414 | INSERT INTO trove_cat VALUES (65,2000031601,63,18,'ide','Integrated Development Environments (IDE)','Complete editing environments for code, including cababilities such as compilation and code building assistance.',0,0,'Topic :: Text Editors :: Integrated Development Environments (IDE)','18 :: 63 :: 65'); | |
2415 | INSERT INTO trove_cat VALUES (66,2000031601,18,18,'database','Database','Front ends, engines, and tools for database work.',0,0,'Topic :: Database','18 :: 66'); | |
2416 | INSERT INTO trove_cat VALUES (67,2000031601,66,18,'engines','Database Engines/Servers','Programs that manage data and provide control via some query language.',0,0,'Topic :: Database :: Database Engines/Servers','18 :: 66 :: 67'); | |
2417 | INSERT INTO trove_cat VALUES (68,2000031601,66,18,'frontends','Front-Ends','Clients and front-ends for generating queries to database engines.',0,0,'Topic :: Database :: Front-Ends','18 :: 66 :: 68'); | |
2418 | INSERT INTO trove_cat VALUES (69,2000031601,63,18,'documentation','Documentation','Tools for the creation and use of documentation.',0,0,'Topic :: Text Editors :: Documentation','18 :: 63 :: 69'); | |
2419 | INSERT INTO trove_cat VALUES (70,2000031601,63,18,'wordprocessors','Word Processors','WYSIWYG word processors.',0,0,'Topic :: Text Editors :: Word Processors','18 :: 63 :: 70'); | |
2420 | INSERT INTO trove_cat VALUES (71,2000031601,18,18,'education','Education','Programs and tools for educating yourself or others.',0,0,'Topic :: Education','18 :: 71'); | |
2421 | INSERT INTO trove_cat VALUES (72,2000031601,71,18,'cai','Computer Aided Instruction (CAI)','Programs for authoring or using Computer Aided Instrution courses.',0,0,'Topic :: Education :: Computer Aided Instruction (CAI)','18 :: 71 :: 72'); | |
2422 | INSERT INTO trove_cat VALUES (73,2000031601,71,18,'testing','Testing','Tools for testing someone\'s knowledge on a subject.',0,0,'Topic :: Education :: Testing','18 :: 71 :: 73'); | |
2423 | INSERT INTO trove_cat VALUES (74,2000042701,136,18,'emulators','Emulators','Emulations of foreign operating systme and machines.',0,0,'Topic :: System :: Emulators','18 :: 136 :: 74'); | |
2424 | INSERT INTO trove_cat VALUES (75,2000031701,129,18,'financial','Financial','Programs related to finance.',0,0,'Topic :: Office/Business :: Financial','18 :: 129 :: 75'); | |
2425 | INSERT INTO trove_cat VALUES (76,2000031601,75,18,'accounting','Accounting','Checkbook balancers and accounting programs.',0,0,'Topic :: Office/Business :: Financial :: Accounting','18 :: 129 :: 75 :: 76'); | |
2426 | INSERT INTO trove_cat VALUES (77,2000031601,75,18,'investment','Investment','Programs for assisting in financial investment.',0,0,'Topic :: Office/Business :: Financial :: Investment','18 :: 129 :: 75 :: 77'); | |
2427 | INSERT INTO trove_cat VALUES (78,2000031601,75,18,'spreadsheet','Spreadsheet','Spreadsheet applications.',0,0,'Topic :: Office/Business :: Financial :: Spreadsheet','18 :: 129 :: 75 :: 78'); | |
2428 | INSERT INTO trove_cat VALUES (79,2000031601,75,18,'pointofsale','Point-Of-Sale','Point-Of-Sale applications.',0,0,'Topic :: Office/Business :: Financial :: Point-Of-Sale','18 :: 129 :: 75 :: 79'); | |
2429 | INSERT INTO trove_cat VALUES (80,2000031601,18,18,'games','Games/Entertainment','Games and Entertainment software.',0,0,'Topic :: Games/Entertainment','18 :: 80'); | |
2430 | INSERT INTO trove_cat VALUES (81,2000031601,80,18,'realtimestrategy','Real Time Strategy','Real Time strategy games',0,0,'Topic :: Games/Entertainment :: Real Time Strategy','18 :: 80 :: 81'); | |
2431 | INSERT INTO trove_cat VALUES (82,2000031601,80,18,'firstpersonshooters','First Person Shooters','First Person Shooters.',0,0,'Topic :: Games/Entertainment :: First Person Shooters','18 :: 80 :: 82'); | |
2432 | INSERT INTO trove_cat VALUES (83,2000032401,80,18,'turnbasedstrategy','Turn Based Strategy','Turn Based Strategy',0,0,'Topic :: Games/Entertainment :: Turn Based Strategy','18 :: 80 :: 83'); | |
2433 | INSERT INTO trove_cat VALUES (84,2000031601,80,18,'rpg','Role-Playing','Role-Playing games',0,0,'Topic :: Games/Entertainment :: Role-Playing','18 :: 80 :: 84'); | |
2434 | INSERT INTO trove_cat VALUES (85,2000031601,80,18,'simulation','Simulation','Simulation games',0,0,'Topic :: Games/Entertainment :: Simulation','18 :: 80 :: 85'); | |
2435 | INSERT INTO trove_cat VALUES (86,2000031601,80,18,'mud','Multi-User Dungeons (MUD)','Massively-multiplayer text based games.',0,0,'Topic :: Games/Entertainment :: Multi-User Dungeons (MUD)','18 :: 80 :: 86'); | |
2436 | INSERT INTO trove_cat VALUES (87,2000031601,18,18,'internet','Internet','Tools to assist human access to the Internet.',0,0,'Topic :: Internet','18 :: 87'); | |
2437 | INSERT INTO trove_cat VALUES (88,2000031601,87,18,'finger','Finger','The Finger protocol for getting information about users.',0,0,'Topic :: Internet :: Finger','18 :: 87 :: 88'); | |
2438 | INSERT INTO trove_cat VALUES (89,2000031601,87,18,'ftp','File Transfer Protocol (FTP)','Programs and tools for file transfer via FTP.',0,0,'Topic :: Internet :: File Transfer Protocol (FTP)','18 :: 87 :: 89'); | |
2439 | INSERT INTO trove_cat VALUES (90,2000031601,87,18,'www','WWW/HTTP','Programs and tools for the World Wide Web.',0,0,'Topic :: Internet :: WWW/HTTP','18 :: 87 :: 90'); | |
2440 | INSERT INTO trove_cat VALUES (91,2000031601,90,18,'browsers','Browsers','Web Browsers',0,0,'Topic :: Internet :: WWW/HTTP :: Browsers','18 :: 87 :: 90 :: 91'); | |
2441 | INSERT INTO trove_cat VALUES (92,2000031601,90,18,'dynamic','Dynamic Content','Common Gateway Interface scripting and server-side parsing.',0,0,'Topic :: Internet :: WWW/HTTP :: Dynamic Content','18 :: 87 :: 90 :: 92'); | |
2442 | INSERT INTO trove_cat VALUES (93,2000031601,90,18,'indexing','Indexing/Search','Indexing and search tools for the Web.',0,0,'Topic :: Internet :: WWW/HTTP :: Indexing/Search','18 :: 87 :: 90 :: 93'); | |
2443 | INSERT INTO trove_cat VALUES (94,2000031601,92,18,'counters','Page Counters','Scripts to count numbers of pageviews.',0,0,'Topic :: Internet :: WWW/HTTP :: Dynamic Content :: Page Counters','18 :: 87 :: 90 :: 92 :: 94'); | |
2444 | INSERT INTO trove_cat VALUES (95,2000031601,92,18,'messageboards','Message Boards','Online message boards',0,0,'Topic :: Internet :: WWW/HTTP :: Dynamic Content :: Message Boards','18 :: 87 :: 90 :: 92 :: 95'); | |
2445 | INSERT INTO trove_cat VALUES (96,2000031601,92,18,'cgi','CGI Tools/Libraries','Tools for the Common Gateway Interface',0,0,'Topic :: Internet :: WWW/HTTP :: Dynamic Content :: CGI Tools/Libraries','18 :: 87 :: 90 :: 92 :: 96'); | |
2446 | INSERT INTO trove_cat VALUES (97,2000042701,18,18,'scientific','Scientific/Engineering','Scientific applications, to include research, applied and pure mathematics and sciences.',0,0,'Topic :: Scientific/Engineering','18 :: 97'); | |
2447 | INSERT INTO trove_cat VALUES (98,2000031601,97,18,'mathematics','Mathematics','Software to support pure and applied mathematics.',0,0,'Topic :: Scientific/Engineering :: Mathematics','18 :: 97 :: 98'); | |
2448 | INSERT INTO trove_cat VALUES (99,2000031601,18,18,'multimedia','Multimedia','Graphics, sound, video, and multimedia.',0,0,'Topic :: Multimedia','18 :: 99'); | |
2449 | INSERT INTO trove_cat VALUES (100,2000031601,99,18,'graphics','Graphics','Tools and resources for computer graphics.',0,0,'Topic :: Multimedia :: Graphics','18 :: 99 :: 100'); | |
2450 | INSERT INTO trove_cat VALUES (101,2000031601,100,18,'capture','Capture','Support for scanners, cameras, and screen capture.',0,0,'Topic :: Multimedia :: Graphics :: Capture','18 :: 99 :: 100 :: 101'); | |
2451 | INSERT INTO trove_cat VALUES (102,2000031601,101,18,'scanners','Scanners','Support for graphic scanners.',0,0,'Topic :: Multimedia :: Graphics :: Capture :: Scanners','18 :: 99 :: 100 :: 101 :: 102'); | |
2452 | INSERT INTO trove_cat VALUES (103,2000031601,101,18,'cameras','Digital Camera','Digital Camera',0,0,'Topic :: Multimedia :: Graphics :: Capture :: Digital Camera','18 :: 99 :: 100 :: 101 :: 103'); | |
2453 | INSERT INTO trove_cat VALUES (104,2000031601,101,18,'screencapture','Screen Capture','Screen capture tools and processors.',0,0,'Topic :: Multimedia :: Graphics :: Capture :: Screen Capture','18 :: 99 :: 100 :: 101 :: 104'); | |
2454 | INSERT INTO trove_cat VALUES (105,2000031701,100,18,'conversion','Graphics Conversion','Programs which convert between graphics formats.',0,0,'Topic :: Multimedia :: Graphics :: Graphics Conversion','18 :: 99 :: 100 :: 105'); | |
2455 | INSERT INTO trove_cat VALUES (106,2000031701,100,18,'editors','Editors','Drawing, painting, and structured editing programs.',0,0,'Topic :: Multimedia :: Graphics :: Editors','18 :: 99 :: 100 :: 106'); | |
2456 | INSERT INTO trove_cat VALUES (107,2000031701,106,18,'vector','Vector-Based','Vector-Based drawing programs.',0,0,'Topic :: Multimedia :: Graphics :: Editors :: Vector-Based','18 :: 99 :: 100 :: 106 :: 107'); | |
2457 | INSERT INTO trove_cat VALUES (108,2000031701,106,18,'raster','Raster-Based','Raster/Bitmap based drawing programs.',0,0,'Topic :: Multimedia :: Graphics :: Editors :: Raster-Based','18 :: 99 :: 100 :: 106 :: 108'); | |
2458 | INSERT INTO trove_cat VALUES (109,2000031701,100,18,'3dmodeling','3D Modeling','Programs for working with 3D Models.',0,0,'Topic :: Multimedia :: Graphics :: 3D Modeling','18 :: 99 :: 100 :: 109'); | |
2459 | INSERT INTO trove_cat VALUES (110,2000031701,100,18,'3drendering','3D Rendering','Programs which render 3D models.',0,0,'Topic :: Multimedia :: Graphics :: 3D Rendering','18 :: 99 :: 100 :: 110'); | |
2460 | INSERT INTO trove_cat VALUES (111,2000031701,100,18,'presentation','Presentation','Tools for generating presentation graphics and slides.',0,0,'Topic :: Multimedia :: Graphics :: Presentation','18 :: 99 :: 100 :: 111'); | |
2461 | INSERT INTO trove_cat VALUES (112,2000031701,100,18,'viewers','Viewers','Programs that can display various graphics formats.',0,0,'Topic :: Multimedia :: Graphics :: Viewers','18 :: 99 :: 100 :: 112'); | |
2462 | INSERT INTO trove_cat VALUES (113,2000031701,99,18,'sound','Sound/Audio','Tools for generating, editing, analyzing, and playing sound.',0,0,'Topic :: Multimedia :: Sound/Audio','18 :: 99 :: 113'); | |
2463 | INSERT INTO trove_cat VALUES (114,2000031701,113,18,'analysis','Analysis','Sound analysis tools, to include frequency analysis.',0,0,'Topic :: Multimedia :: Sound/Audio :: Analysis','18 :: 99 :: 113 :: 114'); | |
2464 | INSERT INTO trove_cat VALUES (115,2000031701,113,18,'capture','Capture/Recording','Sound capture and recording.',0,0,'Topic :: Multimedia :: Sound/Audio :: Capture/Recording','18 :: 99 :: 113 :: 115'); | |
2465 | INSERT INTO trove_cat VALUES (116,2000031701,113,18,'cdaudio','CD Audio','Programs to play and manipulate audio CDs.',0,0,'Topic :: Multimedia :: Sound/Audio :: CD Audio','18 :: 99 :: 113 :: 116'); | |
2466 | INSERT INTO trove_cat VALUES (117,2000031701,116,18,'cdplay','CD Playing','CD Playing software, to include jukebox software.',0,0,'Topic :: Multimedia :: Sound/Audio :: CD Audio :: CD Playing','18 :: 99 :: 113 :: 116 :: 117'); | |
2467 | INSERT INTO trove_cat VALUES (118,2000031701,116,18,'cdripping','CD Ripping','Software to convert CD Audio to other digital formats.',0,0,'Topic :: Multimedia :: Sound/Audio :: CD Audio :: CD Ripping','18 :: 99 :: 113 :: 116 :: 118'); | |
2468 | INSERT INTO trove_cat VALUES (119,2000031701,113,18,'conversion','Conversion','Programs to convert between audio formats.',0,0,'Topic :: Multimedia :: Sound/Audio :: Conversion','18 :: 99 :: 113 :: 119'); | |
2469 | INSERT INTO trove_cat VALUES (120,2000031701,113,18,'editors','Editors','Programs to edit/manipulate sound data.',0,0,'Topic :: Multimedia :: Sound/Audio :: Editors','18 :: 99 :: 113 :: 120'); | |
2470 | INSERT INTO trove_cat VALUES (121,2000031701,113,18,'mixers','Mixers','Programs to mix audio.',0,0,'Topic :: Multimedia :: Sound/Audio :: Mixers','18 :: 99 :: 113 :: 121'); | |
2471 | INSERT INTO trove_cat VALUES (122,2000031701,113,18,'players','Players','Programs to play audio files to a sound device.',0,0,'Topic :: Multimedia :: Sound/Audio :: Players','18 :: 99 :: 113 :: 122'); | |
2472 | INSERT INTO trove_cat VALUES (123,2000031701,122,18,'mp3','MP3','Programs to play MP3 audio files.',0,0,'Topic :: Multimedia :: Sound/Audio :: Players :: MP3','18 :: 99 :: 113 :: 122 :: 123'); | |
2473 | INSERT INTO trove_cat VALUES (124,2000031701,113,18,'speech','Speech','Speech manipulation and intepretation tools.',0,0,'Topic :: Multimedia :: Sound/Audio :: Speech','18 :: 99 :: 113 :: 124'); | |
2474 | INSERT INTO trove_cat VALUES (125,2000031701,99,18,'video','Video','Video capture, editing, and playback.',0,0,'Topic :: Multimedia :: Video','18 :: 99 :: 125'); | |
2475 | INSERT INTO trove_cat VALUES (126,2000031701,125,18,'capture','Capture','Video capture tools.',0,0,'Topic :: Multimedia :: Video :: Capture','18 :: 99 :: 125 :: 126'); | |
2476 | INSERT INTO trove_cat VALUES (127,2000031701,125,18,'conversion','Conversion','Programs which convert between video formats.',0,0,'Topic :: Multimedia :: Video :: Conversion','18 :: 99 :: 125 :: 127'); | |
2477 | INSERT INTO trove_cat VALUES (128,2000031701,125,18,'display','Display','Programs which display various video formats.',0,0,'Topic :: Multimedia :: Video :: Display','18 :: 99 :: 125 :: 128'); | |
2478 | INSERT INTO trove_cat VALUES (129,2000031701,18,18,'office','Office/Business','Software for assisting and organizing work at your desk.',0,0,'Topic :: Office/Business','18 :: 129'); | |
2479 | INSERT INTO trove_cat VALUES (130,2000031701,129,18,'scheduling','Scheduling','Projects for scheduling time, to include project management.',0,0,'Topic :: Office/Business :: Scheduling','18 :: 129 :: 130'); | |
2480 | INSERT INTO trove_cat VALUES (131,2000032001,129,18,'suites','Office Suites','Integrated office suites (word processing, presentation, spreadsheet, database, etc).',0,0,'Topic :: Office/Business :: Office Suites','18 :: 129 :: 131'); | |
2481 | INSERT INTO trove_cat VALUES (132,2000032001,18,18,'religion','Religion','Programs relating to religion and sacred texts.',0,0,'Topic :: Religion','18 :: 132'); | |
2482 | INSERT INTO trove_cat VALUES (133,2000032001,97,18,'ai','Artificial Intelligence','Artificial Intelligence.',0,0,'Topic :: Scientific/Engineering :: Artificial Intelligence','18 :: 97 :: 133'); | |
2483 | INSERT INTO trove_cat VALUES (134,2000032001,97,18,'astronomy','Astronomy','Software and tools related to astronomy.',0,0,'Topic :: Scientific/Engineering :: Astronomy','18 :: 97 :: 134'); | |
2484 | INSERT INTO trove_cat VALUES (135,2000032001,97,18,'visualization','Visualization','Software for scientific visualization.',0,0,'Topic :: Scientific/Engineering :: Visualization','18 :: 97 :: 135'); | |
2485 | INSERT INTO trove_cat VALUES (136,2000032001,18,18,'system','System','Operating system core and administration utilities.',0,0,'Topic :: System','18 :: 136'); | |
2486 | INSERT INTO trove_cat VALUES (137,2000032001,19,18,'backup','Backup','Programs to manage and sequence system backup.',0,0,'Topic :: System :: Archiving :: Backup','18 :: 136 :: 19 :: 137'); | |
2487 | INSERT INTO trove_cat VALUES (138,2000032001,136,18,'benchmark','Benchmark','Programs for benchmarking system performance.',0,0,'Topic :: System :: Benchmark','18 :: 136 :: 138'); | |
2488 | INSERT INTO trove_cat VALUES (139,2000032001,136,18,'boot','Boot','Programs for bootstrapping your OS.',0,0,'Topic :: System :: Boot','18 :: 136 :: 139'); | |
2489 | INSERT INTO trove_cat VALUES (140,2000032001,139,18,'init','Init','Init-time programs to start system services after boot.',0,0,'Topic :: System :: Boot :: Init','18 :: 136 :: 139 :: 140'); | |
2490 | INSERT INTO trove_cat VALUES (141,2000032001,136,18,'clustering','Clustering/Distributed Networks','Tools for automatically distributing computation across a network.',0,0,'Topic :: System :: Clustering/Distributed Networks','18 :: 136 :: 141'); | |
2491 | INSERT INTO trove_cat VALUES (142,2000032001,136,18,'filesystems','Filesystems','Support for creating, editing, reading, and writing file systems.',0,0,'Topic :: System :: Filesystems','18 :: 136 :: 142'); | |
2492 | INSERT INTO trove_cat VALUES (143,2000032001,144,18,'linux','Linux','The Linux kernel, patches, and modules.',0,0,'Topic :: System :: Operating System Kernels :: Linux','18 :: 136 :: 144 :: 143'); | |
2493 | INSERT INTO trove_cat VALUES (144,2000032001,136,18,'kernels','Operating System Kernels','OS Kernels, patches, modules, and tools.',0,0,'Topic :: System :: Operating System Kernels','18 :: 136 :: 144'); | |
2494 | INSERT INTO trove_cat VALUES (145,2000032001,144,18,'bsd','BSD','Code relating to any of the BSD kernels.',0,0,'Topic :: System :: Operating System Kernels :: BSD','18 :: 136 :: 144 :: 145'); | |
2495 | INSERT INTO trove_cat VALUES (146,2000032001,136,18,'hardware','Hardware','Tools for direct, non-kernel control and configuration of hardware.',0,0,'Topic :: System :: Hardware','18 :: 136 :: 146'); | |
2496 | INSERT INTO trove_cat VALUES (147,2000032001,136,18,'setup','Installation/Setup','Tools for installation and setup of the operating system and other programs.',0,0,'Topic :: System :: Installation/Setup','18 :: 136 :: 147'); | |
2497 | INSERT INTO trove_cat VALUES (148,2000032001,136,18,'logging','Logging','Utilities for clearing, rotating, and digesting system logs.',0,0,'Topic :: System :: Logging','18 :: 136 :: 148'); | |
2498 | INSERT INTO trove_cat VALUES (149,2000032001,87,18,'dns','Name Service (DNS)','Domain name system servers and utilities.',0,0,'Topic :: Internet :: Name Service (DNS)','18 :: 87 :: 149'); | |
2499 | INSERT INTO trove_cat VALUES (150,2000032001,136,18,'networking','Networking','Network configuration and administration.',0,0,'Topic :: System :: Networking','18 :: 136 :: 150'); | |
2500 | INSERT INTO trove_cat VALUES (151,2000032001,150,18,'firewalls','Firewalls','Firewalls and filtering systems.',0,0,'Topic :: System :: Networking :: Firewalls','18 :: 136 :: 150 :: 151'); | |
2501 | INSERT INTO trove_cat VALUES (152,2000032001,150,18,'monitoring','Monitoring','System monitoring, traffic analysis, and sniffers.',0,0,'Topic :: System :: Networking :: Monitoring','18 :: 136 :: 150 :: 152'); | |
2502 | INSERT INTO trove_cat VALUES (153,2000032001,136,18,'power','Power (UPS)','Code for communication with uninterruptible power supplies.',0,0,'Topic :: System :: Power (UPS)','18 :: 136 :: 153'); | |
2503 | INSERT INTO trove_cat VALUES (154,2000032001,18,18,'printing','Printing','Tools, daemons, and utilities for printer control.',0,0,'Topic :: Printing','18 :: 154'); | |
2504 | INSERT INTO trove_cat VALUES (155,2000032001,152,18,'watchdog','Hardware Watchdog','Software to monitor and perform actions or shutdown on hardware trouble detection.',0,0,'Topic :: System :: Networking :: Monitoring :: Hardware Watchdog','18 :: 136 :: 150 :: 152 :: 155'); | |
2505 | INSERT INTO trove_cat VALUES (156,2000032001,18,18,'terminals','Terminals','Terminal emulators, terminal programs, and terminal session utilities.',0,0,'Topic :: Terminals','18 :: 156'); | |
2506 | INSERT INTO trove_cat VALUES (157,2000032001,156,18,'serial','Serial','Dialup, terminal emulation, and file transfer over serial lines.',0,0,'Topic :: Terminals :: Serial','18 :: 156 :: 157'); | |
2507 | INSERT INTO trove_cat VALUES (158,2000032001,156,18,'virtual','Terminal Emulators/X Terminals','Programs to handle multiple terminal sessions. Includes terminal emulations for X and other window systems.',0,0,'Topic :: Terminals :: Terminal Emulators/X Terminals','18 :: 156 :: 158'); | |
2508 | INSERT INTO trove_cat VALUES (159,2000032001,156,18,'telnet','Telnet','Support for telnet; terminal sessions across Internet links.',0,0,'Topic :: Terminals :: Telnet','18 :: 156 :: 159'); | |
2509 | INSERT INTO trove_cat VALUES (160,2000032001,0,0,'language','Programming Language','Language in which this program was written, or was meant to support.',0,0,'Programming Language','160'); | |
2510 | INSERT INTO trove_cat VALUES (161,2000032001,160,160,'apl','APL','APL',0,0,'Programming Language :: APL','160 :: 161'); | |
2511 | INSERT INTO trove_cat VALUES (164,2000032001,160,160,'c','C','C',0,0,'Programming Language :: C','160 :: 164'); | |
2512 | INSERT INTO trove_cat VALUES (162,2000032001,160,160,'assembly','Assembly','Assembly-level programs. Platform specific.',0,0,'Programming Language :: Assembly','160 :: 162'); | |
2513 | INSERT INTO trove_cat VALUES (163,2000051001,160,160,'ada','Ada','Ada',0,0,'Programming Language :: Ada','160 :: 163'); | |
2514 | INSERT INTO trove_cat VALUES (165,2000032001,160,160,'cpp','C++','C++',0,0,'Programming Language :: C++','160 :: 165'); | |
2515 | INSERT INTO trove_cat VALUES (166,2000032401,160,160,'eiffel','Eiffel','Eiffel',0,0,'Programming Language :: Eiffel','160 :: 166'); | |
2516 | INSERT INTO trove_cat VALUES (167,2000032001,160,160,'euler','Euler','Euler',0,0,'Programming Language :: Euler','160 :: 167'); | |
2517 | INSERT INTO trove_cat VALUES (168,2000032001,160,160,'forth','Forth','Forth',0,0,'Programming Language :: Forth','160 :: 168'); | |
2518 | INSERT INTO trove_cat VALUES (169,2000032001,160,160,'fortran','Fortran','Fortran',0,0,'Programming Language :: Fortran','160 :: 169'); | |
2519 | INSERT INTO trove_cat VALUES (170,2000032001,160,160,'lisp','Lisp','Lisp',0,0,'Programming Language :: Lisp','160 :: 170'); | |
2520 | INSERT INTO trove_cat VALUES (171,2000041101,160,160,'logo','Logo','Logo',0,0,'Programming Language :: Logo','160 :: 171'); | |
2521 | INSERT INTO trove_cat VALUES (172,2000032001,160,160,'ml','ML','ML',0,0,'Programming Language :: ML','160 :: 172'); | |
2522 | INSERT INTO trove_cat VALUES (173,2000032001,160,160,'modula','Modula','Modula-2 or Modula-3',0,0,'Programming Language :: Modula','160 :: 173'); | |
2523 | INSERT INTO trove_cat VALUES (174,2000032001,160,160,'objectivec','Objective C','Objective C',0,0,'Programming Language :: Objective C','160 :: 174'); | |
2524 | INSERT INTO trove_cat VALUES (175,2000032001,160,160,'pascal','Pascal','Pascal',0,0,'Programming Language :: Pascal','160 :: 175'); | |
2525 | INSERT INTO trove_cat VALUES (176,2000032001,160,160,'perl','Perl','Perl',0,0,'Programming Language :: Perl','160 :: 176'); | |
2526 | INSERT INTO trove_cat VALUES (177,2000032001,160,160,'prolog','Prolog','Prolog',0,0,'Programming Language :: Prolog','160 :: 177'); | |
2527 | INSERT INTO trove_cat VALUES (178,2000032001,160,160,'python','Python','Python',0,0,'Programming Language :: Python','160 :: 178'); | |
2528 | INSERT INTO trove_cat VALUES (179,2000032001,160,160,'rexx','Rexx','Rexx',0,0,'Programming Language :: Rexx','160 :: 179'); | |
2529 | INSERT INTO trove_cat VALUES (180,2000032001,160,160,'simula','Simula','Simula',0,0,'Programming Language :: Simula','160 :: 180'); | |
2530 | INSERT INTO trove_cat VALUES (181,2000032001,160,160,'smalltalk','Smalltalk','Smalltalk',0,0,'Programming Language :: Smalltalk','160 :: 181'); | |
2531 | INSERT INTO trove_cat VALUES (182,2000032001,160,160,'tcl','Tcl','Tcl',0,0,'Programming Language :: Tcl','160 :: 182'); | |
2532 | INSERT INTO trove_cat VALUES (183,2000032001,160,160,'php','PHP','PHP',0,0,'Programming Language :: PHP','160 :: 183'); | |
2533 | INSERT INTO trove_cat VALUES (184,2000032001,160,160,'asp','ASP','Active Server Pages',0,0,'Programming Language :: ASP','160 :: 184'); | |
2534 | INSERT INTO trove_cat VALUES (185,2000032001,160,160,'shell','Unix Shell','Unix Shell',0,0,'Programming Language :: Unix Shell','160 :: 185'); | |
2535 | INSERT INTO trove_cat VALUES (186,2000032001,160,160,'visualbasic','Visual Basic','Visual Basic',0,0,'Programming Language :: Visual Basic','160 :: 186'); | |
2536 | INSERT INTO trove_cat VALUES (187,2000032001,14,13,'bsd','BSD License','BSD License',0,0,'License :: OSI Approved :: BSD License','13 :: 14 :: 187'); | |
2537 | INSERT INTO trove_cat VALUES (188,2000032001,14,13,'mit','MIT/X Consortium License','MIT License, also the X Consortium License.',0,0,'License :: OSI Approved :: MIT/X Consortium License','13 :: 14 :: 188'); | |
2538 | INSERT INTO trove_cat VALUES (189,2000032001,14,13,'mpl','Mozilla Public License (MPL)','Mozilla Public License (MPL)',0,0,'License :: OSI Approved :: Mozilla Public License (MPL)','13 :: 14 :: 189'); | |
2539 | INSERT INTO trove_cat VALUES (190,2000032001,14,13,'qpl','QT Public License (QPL)','QT Public License',0,0,'License :: OSI Approved :: QT Public License (QPL)','13 :: 14 :: 190'); | |
2540 | INSERT INTO trove_cat VALUES (191,2000032001,14,13,'ibm','IBM Public License','IBM Public License',0,0,'License :: OSI Approved :: IBM Public License','13 :: 14 :: 191'); | |
2541 | INSERT INTO trove_cat VALUES (192,2000032001,14,13,'cvw','MITRE Collaborative Virtual Workspace License (CVW)','MITRE Collaborative Virtual Workspace License (CVW)',0,0,'License :: OSI Approved :: MITRE Collaborative Virtual Workspace License (CVW)','13 :: 14 :: 192'); | |
2542 | INSERT INTO trove_cat VALUES (193,2000032001,14,13,'ricoh','Ricoh Source Code Public License','Ricoh Source Code Public License',0,0,'License :: OSI Approved :: Ricoh Source Code Public License','13 :: 14 :: 193'); | |
2543 | INSERT INTO trove_cat VALUES (194,2000032001,14,13,'python','Python License','Python License',0,0,'License :: OSI Approved :: Python License','13 :: 14 :: 194'); | |
2544 | INSERT INTO trove_cat VALUES (195,2000032001,14,13,'zlib','zlib/libpng License','zlib/libpng License',0,0,'License :: OSI Approved :: zlib/libpng License','13 :: 14 :: 195'); | |
2545 | INSERT INTO trove_cat VALUES (196,2000040701,13,13,'other','Other/Proprietary License','Non OSI-Approved/Proprietary license.',0,0,'License :: Other/Proprietary License','13 :: 196'); | |
2546 | INSERT INTO trove_cat VALUES (197,2000032001,13,13,'publicdomain','Public Domain','Public Domain. No author-retained rights.',0,0,'License :: Public Domain','13 :: 197'); | |
2547 | INSERT INTO trove_cat VALUES (198,2000032001,160,160,'java','Java','Java',0,0,'Programming Language :: Java','160 :: 198'); | |
2548 | INSERT INTO trove_cat VALUES (199,2000032101,0,0,'os','Operating System','What operating system the program requires to run, if any.',0,0,'Operating System','199'); | |
2549 | INSERT INTO trove_cat VALUES (200,2000032101,199,199,'posix','POSIX','POSIX plus standard Berkeley socket facilities. Don\'t list a more specific OS unless your program requires it.',0,0,'Operating System :: POSIX','199 :: 200'); | |
2550 | INSERT INTO trove_cat VALUES (201,2000032101,200,199,'linux','Linux','Any version of Linux. Don\'t specify a subcategory unless the program requires a particular distribution.',0,0,'Operating System :: POSIX :: Linux','199 :: 200 :: 201'); | |
2551 | INSERT INTO trove_cat VALUES (202,2000032101,200,199,'bsd','BSD','Any variant of BSD. Don\'t specify a subcategory unless the program requires a particular BSD flavor.',0,0,'Operating System :: POSIX :: BSD','199 :: 200 :: 202'); | |
2552 | INSERT INTO trove_cat VALUES (203,2000041101,202,199,'freebsd','FreeBSD','FreeBSD',0,0,'Operating System :: POSIX :: BSD :: FreeBSD','199 :: 200 :: 202 :: 203'); | |
2553 | INSERT INTO trove_cat VALUES (204,2000032101,202,199,'netbsd','NetBSD','NetBSD',0,0,'Operating System :: POSIX :: BSD :: NetBSD','199 :: 200 :: 202 :: 204'); | |
2554 | INSERT INTO trove_cat VALUES (205,2000032101,202,199,'openbsd','OpenBSD','OpenBSD',0,0,'Operating System :: POSIX :: BSD :: OpenBSD','199 :: 200 :: 202 :: 205'); | |
2555 | INSERT INTO trove_cat VALUES (206,2000032101,202,199,'bsdos','BSD/OS','BSD/OS',0,0,'Operating System :: POSIX :: BSD :: BSD/OS','199 :: 200 :: 202 :: 206'); | |
2556 | INSERT INTO trove_cat VALUES (207,2000032101,200,199,'sun','SunOS/Solaris','Any Sun Microsystems OS.',0,0,'Operating System :: POSIX :: SunOS/Solaris','199 :: 200 :: 207'); | |
2557 | INSERT INTO trove_cat VALUES (208,2000032101,200,199,'sco','SCO','SCO',0,0,'Operating System :: POSIX :: SCO','199 :: 200 :: 208'); | |
2558 | INSERT INTO trove_cat VALUES (209,2000032101,200,199,'hpux','HP-UX','HP-UX',0,0,'Operating System :: POSIX :: HP-UX','199 :: 200 :: 209'); | |
2559 | INSERT INTO trove_cat VALUES (210,2000032101,200,199,'aix','AIX','AIX',0,0,'Operating System :: POSIX :: AIX','199 :: 200 :: 210'); | |
2560 | INSERT INTO trove_cat VALUES (211,2000032101,200,199,'irix','IRIX','IRIX',0,0,'Operating System :: POSIX :: IRIX','199 :: 200 :: 211'); | |
2561 | INSERT INTO trove_cat VALUES (212,2000032101,200,199,'other','Other','Other specific POSIX OS, specified in description.',0,0,'Operating System :: POSIX :: Other','199 :: 200 :: 212'); | |
2562 | INSERT INTO trove_cat VALUES (213,2000032101,160,160,'other','Other','Other programming language, specified in description.',0,0,'Programming Language :: Other','160 :: 213'); | |
2563 | INSERT INTO trove_cat VALUES (214,2000032101,199,199,'microsoft','Microsoft','Microsoft operating systems.',0,0,'Operating System :: Microsoft','199 :: 214'); | |
2564 | INSERT INTO trove_cat VALUES (215,2000032101,214,199,'msdos','MS-DOS','Microsoft Disk Operating System (DOS)',0,0,'Operating System :: Microsoft :: MS-DOS','199 :: 214 :: 215'); | |
2565 | INSERT INTO trove_cat VALUES (216,2000032101,214,199,'windows','Windows','Windows software, not specific to any particular version of Windows.',0,0,'Operating System :: Microsoft :: Windows','199 :: 214 :: 216'); | |
2566 | INSERT INTO trove_cat VALUES (217,2000032101,216,199,'win31','Windows 3.1 or Earlier','Windows 3.1 or Earlier',0,0,'Operating System :: Microsoft :: Windows :: Windows 3.1 or Earlier','199 :: 214 :: 216 :: 217'); | |
2567 | INSERT INTO trove_cat VALUES (218,2000032101,216,199,'win95','Windows 95/98/2000','Windows 95, Windows 98, and Windows 2000.',0,0,'Operating System :: Microsoft :: Windows :: Windows 95/98/2000','199 :: 214 :: 216 :: 218'); | |
2568 | INSERT INTO trove_cat VALUES (219,2000041101,216,199,'winnt','Windows NT/2000','Windows NT and Windows 2000.',0,0,'Operating System :: Microsoft :: Windows :: Windows NT/2000','199 :: 214 :: 216 :: 219'); | |
2569 | INSERT INTO trove_cat VALUES (220,2000032101,199,199,'os2','OS/2','OS/2',0,0,'Operating System :: OS/2','199 :: 220'); | |
2570 | INSERT INTO trove_cat VALUES (221,2000032101,199,199,'macos','MacOS','MacOS',0,0,'Operating System :: MacOS','199 :: 221'); | |
2571 | INSERT INTO trove_cat VALUES (222,2000032101,216,199,'wince','Windows CE','Windows CE',0,0,'Operating System :: Microsoft :: Windows :: Windows CE','199 :: 214 :: 216 :: 222'); | |
2572 | INSERT INTO trove_cat VALUES (223,2000032101,199,199,'palmos','PalmOS','PalmOS (for Palm Pilot)',0,0,'Operating System :: PalmOS','199 :: 223'); | |
2573 | INSERT INTO trove_cat VALUES (224,2000032101,199,199,'beos','BeOS','BeOS',0,0,'Operating System :: BeOS','199 :: 224'); | |
2574 | INSERT INTO trove_cat VALUES (225,2000032101,0,0,'environment','Environment','Run-time environment required for this program.',0,0,'Environment','225'); | |
2575 | INSERT INTO trove_cat VALUES (226,2000041101,225,225,'console','Console (Text Based)','Console-based programs.',0,0,'Environment :: Console (Text Based)','225 :: 226'); | |
2576 | INSERT INTO trove_cat VALUES (227,2000032401,226,225,'curses','Curses','Curses-based software.',0,0,'Environment :: Console (Text Based) :: Curses','225 :: 226 :: 227'); | |
2577 | INSERT INTO trove_cat VALUES (228,2000040701,226,225,'newt','Newt','Newt',0,0,'Environment :: Console (Text Based) :: Newt','225 :: 226 :: 228'); | |
2578 | INSERT INTO trove_cat VALUES (229,2000040701,225,225,'x11','X11 Applications','Programs that run in an X windowing environment.',0,0,'Environment :: X11 Applications','225 :: 229'); | |
2579 | INSERT INTO trove_cat VALUES (230,2000040701,225,225,'win32','Win32 (MS Windows)','Programs designed to run in a graphical Microsoft Windows environment.',0,0,'Environment :: Win32 (MS Windows)','225 :: 230'); | |
2580 | INSERT INTO trove_cat VALUES (231,2000040701,229,225,'gnome','Gnome','Programs designed to run in a Gnome environment.',0,0,'Environment :: X11 Applications :: Gnome','225 :: 229 :: 231'); | |
2581 | INSERT INTO trove_cat VALUES (232,2000040701,229,225,'kde','KDE','Programs designed to run in a KDE environment.',0,0,'Environment :: X11 Applications :: KDE','225 :: 229 :: 232'); | |
2582 | INSERT INTO trove_cat VALUES (233,2000040701,225,225,'other','Other Environment','Programs designed to run in an environment other than one listed.',0,0,'Environment :: Other Environment','225 :: 233'); | |
2583 | INSERT INTO trove_cat VALUES (234,2000040701,18,18,'other','Other/Nonlisted Topic','Topic does not fit into any listed category.',0,0,'Topic :: Other/Nonlisted Topic','18 :: 234'); | |
2584 | INSERT INTO trove_cat VALUES (235,2000041001,199,199,'independent','OS Independent','This software does not depend on any particular operating system.',0,0,'Operating System :: OS Independent','199 :: 235'); | |
2585 | INSERT INTO trove_cat VALUES (236,2000040701,199,199,'other','Other OS','Program is designe for a nonlisted operating system.',0,0,'Operating System :: Other OS','199 :: 236'); | |
2586 | INSERT INTO trove_cat VALUES (237,2000041001,225,225,'web','Web Environment','This software is designed for a web environment.',0,0,'Environment :: Web Environment','225 :: 237'); | |
2587 | INSERT INTO trove_cat VALUES (238,2000041101,225,225,'daemon','No Input/Output (Daemon)','This program has no input or output, but is intended to run in the background as a daemon.',0,0,'Environment :: No Input/Output (Daemon)','225 :: 238'); | |
2588 | INSERT INTO trove_cat VALUES (239,2000041301,144,18,'gnuhurd','GNU Hurd','Kernel code and modules for GNU Hurd.',0,0,'Topic :: System :: Operating System Kernels :: GNU Hurd','18 :: 136 :: 144 :: 239'); | |
2589 | INSERT INTO trove_cat VALUES (240,2000041301,200,199,'gnuhurd','GNU Hurd','GNU Hurd',0,0,'Operating System :: POSIX :: GNU Hurd','199 :: 200 :: 240'); | |
2590 | INSERT INTO trove_cat VALUES (241,2000050101,251,18,'napster','Napster','Clients and servers for the Napster file sharing protocol.',0,0,'Topic :: Communications :: File Sharing :: Napster','18 :: 20 :: 251 :: 241'); | |
2591 | INSERT INTO trove_cat VALUES (242,2000042701,160,160,'scheme','Scheme','Scheme programming language.',0,0,'Programming Language :: Scheme','160 :: 242'); | |
2592 | INSERT INTO trove_cat VALUES (243,2000042701,90,18,'sitemanagement','Site Management','Tools for maintanance and management of web sites.',0,0,'Topic :: Internet :: WWW/HTTP :: Site Management','18 :: 87 :: 90 :: 243'); | |
2593 | INSERT INTO trove_cat VALUES (244,2000042701,243,18,'linkchecking','Link Checking','Tools to assist in checking for broken links.',0,0,'Topic :: Internet :: WWW/HTTP :: Site Management :: Link Checking','18 :: 87 :: 90 :: 243 :: 244'); | |
2594 | INSERT INTO trove_cat VALUES (245,2000042701,87,18,'loganalysis','Log Analysis','Software to help analyze various log files.',0,0,'Topic :: Internet :: Log Analysis','18 :: 87 :: 245'); | |
2595 | INSERT INTO trove_cat VALUES (246,2000042701,97,18,'eda','Electronic Design Automation (EDA)','Tools for circuit design, schematics, board layout, and more.',0,0,'Topic :: Scientific/Engineering :: Electronic Design Automation (EDA)','18 :: 97 :: 246'); | |
2596 | INSERT INTO trove_cat VALUES (247,2000042701,20,18,'telephony','Telephony','Telephony related applications, to include automated voice response systems.',0,0,'Topic :: Communications :: Telephony','18 :: 20 :: 247'); | |
2597 | INSERT INTO trove_cat VALUES (248,2000042801,113,18,'midi','MIDI','Software related to MIDI synthesis and playback.',0,0,'Topic :: Multimedia :: Sound/Audio :: MIDI','18 :: 99 :: 113 :: 248'); | |
2598 | INSERT INTO trove_cat VALUES (249,2000042801,113,18,'synthesis','Sound Synthesis','Software for creation and synthesis of sound.',0,0,'Topic :: Multimedia :: Sound/Audio :: Sound Synthesis','18 :: 99 :: 113 :: 249'); | |
2599 | INSERT INTO trove_cat VALUES (250,2000042801,90,18,'httpservers','HTTP Servers','Software designed to serve content via the HTTP protocol.',0,0,'Topic :: Internet :: WWW/HTTP :: HTTP Servers','18 :: 87 :: 90 :: 250'); | |
2600 | INSERT INTO trove_cat VALUES (251,2000050101,20,18,'filesharing','File Sharing','Software for person-to-person online file sharing.',0,0,'Topic :: Communications :: File Sharing','18 :: 20 :: 251'); | |
2601 | INSERT INTO trove_cat VALUES (252,2000071101,97,18,'bioinformatics','Bio-Informatics','Category for gene software (e.g. Gene Ontology)',0,0,'Topic :: Scientific/Engineering :: Bio-Informatics','18 :: 97 :: 252'); | |
2602 | INSERT INTO trove_cat VALUES (253,2000071101,136,18,'sysadministration','Systems Administration','Systems Administration Software (e.g. configuration apps.)',0,0,'Topic :: System :: Systems Administration','18 :: 136 :: 253'); | |
2603 | INSERT INTO trove_cat VALUES (254,2000071101,160,160,'plsql','PL/SQL','PL/SQL Programming Language',0,0,'Programming Language :: PL/SQL','160 :: 254'); | |
2604 | INSERT INTO trove_cat VALUES (255,2000071101,160,160,'progress','PROGRESS','PROGRESS Programming Language',0,0,'Programming Language :: PROGRESS','160 :: 255'); | |
2605 | INSERT INTO trove_cat VALUES (256,2000071101,125,18,'nonlineareditor','Non-Linear Editor','Video Non-Linear Editors',0,0,'Topic :: Multimedia :: Video :: Non-Linear Editor','18 :: 99 :: 125 :: 256'); | |
2606 | INSERT INTO trove_cat VALUES (257,2000071101,136,18,'softwaredist','Software Distribution','Systems software for distributing other software.',0,0,'Topic :: System :: Software Distribution','18 :: 136 :: 257'); | |
2607 | INSERT INTO trove_cat VALUES (258,2000071101,160,160,'objectpascal','Object Pascal','Object Pascal',0,0,'Programming Language :: Object Pascal','160 :: 258'); | |
2608 | INSERT INTO trove_cat VALUES (259,2000071401,45,18,'codegen','Code Generators','Code Generators',0,0,'Topic :: Software Development :: Code Generators','18 :: 45 :: 259'); | |
2609 | INSERT INTO trove_cat VALUES (260,2000071401,52,18,'SCCS','SCCS','SCCS',0,0,'Topic :: Software Development :: Version Control :: SCCS','18 :: 45 :: 52 :: 260'); | |
2610 | INSERT INTO trove_cat VALUES (261,2000072501,160,160,'xbasic','XBasic','XBasic programming language',0,0,'Programming Language :: XBasic','160 :: 261'); | |
2611 | INSERT INTO trove_cat VALUES (262,2000073101,160,160,'coldfusion','Cold Fusion','Cold Fusion Language',0,0,'Programming Language :: Cold Fusion','160 :: 262'); | |
2612 | INSERT INTO trove_cat VALUES (263,2000080401,160,160,'euphoria','Euphoria','Euphoria programming language - http://www.rapideuphoria.com/',0,0,'Programming Language :: Euphoria','160 :: 263'); | |
2613 | INSERT INTO trove_cat VALUES (264,2000080701,160,160,'erlang','Erlang','Erlang - developed by Ericsson - http://www.erlang.org/',0,0,'Programming Language :: Erlang','160 :: 264'); | |
2614 | INSERT INTO trove_cat VALUES (265,2000080801,160,160,'Delphi','Delphi','Borland/Inprise Delphi',0,0,'Programming Language :: Delphi','160 :: 265'); | |
2615 | INSERT INTO trove_cat VALUES (266,2000081601,97,18,'medical','Medical Science Apps.','Medical / BioMedical Science Apps.',0,0,'Topic :: Scientific/Engineering :: Medical Science Apps.','18 :: 97 :: 266'); | |
2616 | INSERT INTO trove_cat VALUES (267,2000082001,160,160,'zope','Zope','Zope Object Publishing',0,0,'Programming Language :: Zope','160 :: 267'); | |
2617 | INSERT INTO trove_cat VALUES (268,2000082101,80,18,'Puzzles','Puzzle Games','Puzzle Games',0,0,'Topic :: Games/Entertainment :: Puzzle Games','18 :: 80 :: 268'); | |
2618 | INSERT INTO trove_cat VALUES (269,2000082801,160,160,'asm','Assembly','ASM programming',0,0,'Programming Language :: Assembly','160 :: 269'); | |
2619 | ||
2620 | # | |
2621 | # Table structure for table 'trove_group_link' | |
2622 | # | |
2623 | ||
2624 | CREATE TABLE trove_group_link ( | |
2625 | trove_group_id int(11) NOT NULL auto_increment, | |
2626 | trove_cat_id int(11) DEFAULT '0' NOT NULL, | |
2627 | trove_cat_version int(11) DEFAULT '0' NOT NULL, | |
2628 | group_id int(11) DEFAULT '0' NOT NULL, | |
2629 | trove_cat_root int(11) DEFAULT '0' NOT NULL, | |
2630 | PRIMARY KEY (trove_group_id), | |
2631 | KEY idx_trove_group_link_group_id (group_id), | |
2632 | KEY idx_trove_group_link_cat_id (trove_cat_id) | |
2633 | ); | |
2634 | ||
2635 | # | |
2636 | # Dumping data for table 'trove_group_link' | |
2637 | # | |
2638 | ||
2639 | # | |
2640 | # Table structure for table 'trove_treesums' | |
2641 | # | |
2642 | ||
2643 | CREATE TABLE trove_treesums ( | |
2644 | trove_treesums_id int(11) NOT NULL auto_increment, | |
2645 | trove_cat_id int(11) DEFAULT '0' NOT NULL, | |
2646 | limit_1 int(11) DEFAULT '0' NOT NULL, | |
2647 | subprojects int(11) DEFAULT '0' NOT NULL, | |
2648 | PRIMARY KEY (trove_treesums_id) | |
2649 | ); | |
2650 | ||
2651 | # | |
2652 | # Dumping data for table 'trove_treesums' | |
2653 | # | |
2654 | ||
2655 | ||
2656 | # | |
2657 | # Table structure for table 'unix_uids' | |
2658 | # | |
2659 | ||
2660 | CREATE TABLE unix_uids ( | |
2661 | id int(11) NOT NULL auto_increment, | |
2662 | PRIMARY KEY (id) | |
2663 | ); | |
2664 | ||
2665 | # | |
2666 | # Dumping data for table 'unix_uids' | |
2667 | # | |
2668 | ||
2669 | INSERT INTO unix_uids VALUES (1); | |
2670 | ||
2671 | # | |
2672 | # Table structure for table 'user_bookmarks' | |
2673 | # | |
2674 | ||
2675 | CREATE TABLE user_bookmarks ( | |
2676 | bookmark_id int(11) NOT NULL auto_increment, | |
2677 | user_id int(11) DEFAULT '0' NOT NULL, | |
2678 | bookmark_url text, | |
2679 | bookmark_title text, | |
2680 | PRIMARY KEY (bookmark_id), | |
2681 | KEY idx_user_bookmark_user_id (user_id) | |
2682 | ); | |
2683 | ||
2684 | # | |
2685 | # Dumping data for table 'user_bookmarks' | |
2686 | # | |
2687 | ||
2688 | ||
2689 | # | |
2690 | # Table structure for table 'user_diary' | |
2691 | # | |
2692 | ||
2693 | CREATE TABLE user_diary ( | |
2694 | id int(11) NOT NULL auto_increment, | |
2695 | user_id int(11) DEFAULT '0' NOT NULL, | |
2696 | date_posted int(11) DEFAULT '0' NOT NULL, | |
2697 | summary text, | |
2698 | details text, | |
2699 | is_public int(11) DEFAULT '0' NOT NULL, | |
2700 | PRIMARY KEY (id), | |
2701 | KEY idx_user_diary_user_date (user_id,date_posted), | |
2702 | KEY idx_user_diary_date (date_posted), | |
2703 | KEY idx_user_diary_user (user_id) | |
2704 | ); | |
2705 | ||
2706 | # | |
2707 | # Dumping data for table 'user_diary' | |
2708 | # | |
2709 | ||
2710 | ||
2711 | # | |
2712 | # Table structure for table 'user_diary_monitor' | |
2713 | # | |
2714 | ||
2715 | CREATE TABLE user_diary_monitor ( | |
2716 | monitor_id int(11) NOT NULL auto_increment, | |
2717 | monitored_user int(11) DEFAULT '0' NOT NULL, | |
2718 | user_id int(11) DEFAULT '0' NOT NULL, | |
2719 | PRIMARY KEY (monitor_id), | |
2720 | KEY idx_user_diary_monitor_user (user_id), | |
2721 | KEY idx_user_diary_monitor_monitored_user (monitored_user) | |
2722 | ); | |
2723 | ||
2724 | # | |
2725 | # Dumping data for table 'user_diary_monitor' | |
2726 | # | |
2727 | ||
2728 | ||
2729 | # | |
2730 | # Table structure for table 'user_group' | |
2731 | # | |
2732 | ||
2733 | CREATE TABLE user_group ( | |
2734 | user_group_id int(11) NOT NULL auto_increment, | |
2735 | user_id int(11) DEFAULT '0' NOT NULL, | |
2736 | group_id int(11) DEFAULT '0' NOT NULL, | |
2737 | admin_flags char(16) DEFAULT '' NOT NULL, | |
2738 | bug_flags int(11) DEFAULT '0' NOT NULL, | |
2739 | forum_flags int(11) DEFAULT '0' NOT NULL, | |
2740 | project_flags int(11) DEFAULT '2' NOT NULL, | |
2741 | patch_flags int(11) DEFAULT '1' NOT NULL, | |
2742 | support_flags int(11) DEFAULT '1' NOT NULL, | |
2743 | doc_flags int(11) DEFAULT '0' NOT NULL, | |
2744 | cvs_flags int(11) DEFAULT '1' NOT NULL, | |
2745 | PRIMARY KEY (user_group_id), | |
2746 | KEY idx_user_group_user_id (user_id), | |
2747 | KEY idx_user_group_group_id (group_id), | |
2748 | KEY bug_flags_idx (bug_flags), | |
2749 | KEY forum_flags_idx (forum_flags), | |
2750 | KEY project_flags_idx (project_flags), | |
2751 | KEY admin_flags_idx (admin_flags) | |
2752 | ); | |
2753 | ||
2754 | # | |
2755 | # Dumping data for table 'user_group' | |
2756 | # | |
2757 | ||
2758 | INSERT INTO user_group VALUES (1,101,2,'A',2,2,2,1,1,0,1); | |
2759 | ||
2760 | # | |
2761 | # Table structure for table 'user_metric' | |
2762 | # | |
2763 | ||
2764 | CREATE TABLE user_metric ( | |
2765 | ranking int(11) NOT NULL auto_increment, | |
2766 | user_id int(11) DEFAULT '0' NOT NULL, | |
2767 | times_ranked int(11) DEFAULT '0' NOT NULL, | |
2768 | avg_raters_importance float(10,8) DEFAULT '0.00000000' NOT NULL, | |
2769 | avg_rating float(10,8) DEFAULT '0.00000000' NOT NULL, | |
2770 | metric float(10,8) DEFAULT '0.00000000' NOT NULL, | |
2771 | percentile float(10,8) DEFAULT '0.00000000' NOT NULL, | |
2772 | importance_factor float(10,8) DEFAULT '0.00000000' NOT NULL, | |
2773 | PRIMARY KEY (ranking) | |
2774 | ); | |
2775 | ||
2776 | # | |
2777 | # Dumping data for table 'user_metric' | |
2778 | # | |
2779 | ||
2780 | ||
2781 | # | |
2782 | # Table structure for table 'user_metric0' | |
2783 | # | |
2784 | ||
2785 | CREATE TABLE user_metric0 ( | |
2786 | ranking int(11) NOT NULL auto_increment, | |
2787 | user_id int(11) DEFAULT '0' NOT NULL, | |
2788 | times_ranked int(11) DEFAULT '0' NOT NULL, | |
2789 | avg_raters_importance float(10,8) DEFAULT '0.00000000' NOT NULL, | |
2790 | avg_rating float(10,8) DEFAULT '0.00000000' NOT NULL, | |
2791 | metric float(10,8) DEFAULT '0.00000000' NOT NULL, | |
2792 | percentile float(10,8) DEFAULT '0.00000000' NOT NULL, | |
2793 | importance_factor float(10,8) DEFAULT '0.00000000' NOT NULL, | |
2794 | PRIMARY KEY (ranking), | |
2795 | KEY idx_user_metric0_user_id (user_id) | |
2796 | ); | |
2797 | ||
2798 | # | |
2799 | # Dumping data for table 'user_metric0' | |
2800 | # | |
2801 | ||
2802 | ||
2803 | # | |
2804 | # Table structure for table 'user_metric_tmp1_1' | |
2805 | # | |
2806 | ||
2807 | CREATE TABLE user_metric_tmp1_1 ( | |
2808 | user_id int(11) DEFAULT '0' NOT NULL, | |
2809 | times_ranked int(11) DEFAULT '0' NOT NULL, | |
2810 | avg_raters_importance float(10,8) DEFAULT '0.00000000' NOT NULL, | |
2811 | avg_rating float(10,8) DEFAULT '0.00000000' NOT NULL, | |
2812 | metric float(10,8) DEFAULT '0.00000000' NOT NULL | |
2813 | ); | |
2814 | ||
2815 | # | |
2816 | # Dumping data for table 'user_metric_tmp1_1' | |
2817 | # | |
2818 | ||
2819 | ||
2820 | # | |
2821 | # Table structure for table 'user_preferences' | |
2822 | # | |
2823 | ||
2824 | CREATE TABLE user_preferences ( | |
2825 | user_id int(11) DEFAULT '0' NOT NULL, | |
2826 | preference_name varchar(20), | |
2827 | preference_value varchar(20), | |
2828 | set_date int(11) DEFAULT '0' NOT NULL, | |
2829 | KEY idx_user_pref_user_id (user_id) | |
2830 | ); | |
2831 | ||
2832 | # | |
2833 | # Dumping data for table 'user_preferences' | |
2834 | # | |
2835 | ||
2836 | ||
2837 | # | |
2838 | # Table structure for table 'user_ratings' | |
2839 | # | |
2840 | ||
2841 | CREATE TABLE user_ratings ( | |
2842 | rated_by int(11) DEFAULT '0' NOT NULL, | |
2843 | user_id int(11) DEFAULT '0' NOT NULL, | |
2844 | rate_field int(11) DEFAULT '0' NOT NULL, | |
2845 | rating int(11) DEFAULT '0' NOT NULL, | |
2846 | KEY idx_user_ratings_rated_by (rated_by), | |
2847 | KEY idx_user_ratings_user_id (user_id) | |
2848 | ); | |
2849 | ||
2850 | # | |
2851 | # Dumping data for table 'user_ratings' | |
2852 | # | |
2853 | ||
2854 | ||
2855 | # | |
2856 | # Table structure for table 'users' | |
2857 | # | |
2858 | ||
2859 | CREATE TABLE users ( | |
2860 | user_id int(11) NOT NULL auto_increment, | |
2861 | user_name text DEFAULT '' NOT NULL, | |
2862 | email text DEFAULT '' NOT NULL, | |
2863 | user_pw varchar(32) DEFAULT '' NOT NULL, | |
2864 | realname varchar(32) DEFAULT '' NOT NULL, | |
2865 | status char(1) DEFAULT 'A' NOT NULL, | |
2866 | shell varchar(20) DEFAULT '/bin/bash' NOT NULL, | |
2867 | unix_pw varchar(40) DEFAULT '' NOT NULL, | |
2868 | unix_status char(1) DEFAULT 'N' NOT NULL, | |
2869 | unix_uid int(11) DEFAULT '0' NOT NULL, | |
2870 | unix_box varchar(10) DEFAULT 'shell1' NOT NULL, | |
2871 | add_date int(11) DEFAULT '0' NOT NULL, | |
2872 | confirm_hash varchar(32), | |
2873 | mail_siteupdates int(11) DEFAULT '0' NOT NULL, | |
2874 | mail_va int(11) DEFAULT '0' NOT NULL, | |
2875 | authorized_keys text, | |
2876 | email_new text, | |
2877 | people_view_skills int(11) DEFAULT '0' NOT NULL, | |
2878 | people_resume text DEFAULT '' NOT NULL, | |
2879 | timezone varchar(64) DEFAULT 'GMT', | |
2880 | language int(11) DEFAULT '1' NOT NULL, | |
2881 | PRIMARY KEY (user_id), | |
2882 | KEY idx_user_user (status) | |
2883 | ); | |
2884 | ||
2885 | # | |
2886 | # Dumping data for table 'users' | |
2887 | # | |
2888 | ||
2889 | INSERT INTO users VALUES (100,'None','noreply@sourceforge.net','*********34343','','A','/bin/bash','','N',0,'shell1',0,NULL,0,0,NULL,NULL,0,'','GMT',1); |