3 # Host: localhost Database: sourceforge
4 #--------------------------------------------------------
5 # Server version 3.23.25-beta
8 # Table structure for table 'activity_log'
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,
20 type int(11) DEFAULT '0' NOT NULL
24 # Dumping data for table 'activity_log'
29 # Table structure for table 'activity_log_old'
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,
41 type int(11) DEFAULT '0' NOT NULL
45 # Dumping data for table 'activity_log_old'
50 # Table structure for table 'activity_log_old_old'
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,
62 type int(11) DEFAULT '0' NOT NULL
66 # Dumping data for table 'activity_log_old_old'
71 # Table structure for 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,
86 bug_group_id int(11) DEFAULT '0' NOT NULL,
87 resolution_id int(11) DEFAULT '0' NOT NULL,
89 KEY idx_bug_group_id (group_id)
93 # Dumping data for table 'bug'
96 INSERT INTO bug VALUES (100,1,100,0,100,100,100,0,NULL,NULL,NULL,100,100);
99 # Table structure for table 'bug_bug_dependencies'
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)
112 # Dumping data for table 'bug_bug_dependencies'
117 # Table structure for table 'bug_canned_responses'
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,
125 PRIMARY KEY (bug_canned_id),
126 KEY idx_bug_canned_response_group_id (group_id)
130 # Dumping data for table 'bug_canned_responses'
135 # Table structure for table 'bug_category'
138 CREATE TABLE bug_category (
139 bug_category_id int(11) NOT NULL auto_increment,
140 group_id int(11) DEFAULT '0' NOT NULL,
142 PRIMARY KEY (bug_category_id),
143 KEY idx_bug_category_group_id (group_id)
147 # Dumping data for table 'bug_category'
150 INSERT INTO bug_category VALUES (100,1,'None');
153 # Table structure for table 'bug_filter'
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)
166 # Dumping data for table 'bug_filter'
171 # Table structure for table 'bug_group'
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)
183 # Dumping data for table 'bug_group'
186 INSERT INTO bug_group VALUES (100,1,'None');
189 # Table structure for table 'bug_history'
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,
199 PRIMARY KEY (bug_history_id),
200 KEY idx_bug_history_bug_id (bug_id)
204 # Dumping data for table 'bug_history'
209 # Table structure for table 'bug_resolution'
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)
219 # Dumping data for table 'bug_resolution'
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');
232 # Table structure for table 'bug_status'
235 CREATE TABLE bug_status (
236 status_id int(11) NOT NULL auto_increment,
238 PRIMARY KEY (status_id)
242 # Dumping data for table 'bug_status'
245 INSERT INTO bug_status VALUES (1,'Open');
246 INSERT INTO bug_status VALUES (3,'Closed');
247 INSERT INTO bug_status VALUES (100,'None');
250 # Table structure for table 'bug_task_dependencies'
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)
263 # Dumping data for table 'bug_task_dependencies'
268 # Table structure for table 'canned_responses'
271 CREATE TABLE canned_responses (
272 response_id int(11) NOT NULL auto_increment,
273 response_title varchar(25),
275 PRIMARY KEY (response_id)
279 # Dumping data for table 'canned_responses'
284 # Table structure for table 'db_images'
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,
298 KEY idx_db_images_group (group_id)
302 # Dumping data for table 'db_images'
307 # Table structure for table 'doc_data'
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,
320 language_id int(11) DEFAULT '1' NOT NULL,
322 KEY idx_doc_group_doc_group (doc_group)
326 # Dumping data for table 'doc_data'
331 # Table structure for table 'doc_groups'
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)
343 # Dumping data for table 'doc_groups'
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);
358 # Table structure for table 'doc_states'
361 CREATE TABLE doc_states (
362 stateid int(11) NOT NULL auto_increment,
363 name varchar(255) DEFAULT '' NOT NULL,
364 PRIMARY KEY (stateid)
368 # Dumping data for table 'doc_states'
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');
378 # Table structure for table 'filemodule_monitor'
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)
388 # Dumping data for table 'filemodule_monitor'
393 # Table structure for 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)
417 # Dumping data for table 'forum'
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);
425 # Table structure for table 'forum_agg_msg_count'
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)
435 # Dumping data for table 'forum_agg_msg_count'
440 # Table structure for table 'forum_group_list'
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,
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)
456 # Dumping data for table 'forum_group_list'
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);
464 # Table structure for table 'forum_monitored_forums'
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)
477 # Dumping data for table 'forum_monitored_forums'
482 # Table structure for table 'forum_saved_place'
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)
494 # Dumping data for table 'forum_saved_place'
499 # Table structure for table 'forum_thread_id'
502 CREATE TABLE forum_thread_id (
503 thread_id int(11) NOT NULL auto_increment,
504 PRIMARY KEY (thread_id)
508 # Dumping data for table 'forum_thread_id'
511 INSERT INTO forum_thread_id VALUES (1);
512 INSERT INTO forum_thread_id VALUES (2);
513 INSERT INTO forum_thread_id VALUES (3);
516 # Table structure for table 'foundry_data'
519 CREATE TABLE foundry_data (
520 foundry_id int(11) NOT NULL auto_increment,
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)
532 # Dumping data for table 'foundry_data'
537 # Table structure for table 'foundry_news'
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)
553 # Dumping data for table 'foundry_news'
558 # Table structure for table 'foundry_preferred_projects'
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)
572 # Dumping data for table 'foundry_preferred_projects'
577 # Table structure for table 'foundry_projects'
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,
585 KEY idx_foundry_projects_foundry (foundry_id)
589 # Dumping data for table 'foundry_projects'
594 # Table structure for table 'frs_dlstats_agg'
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),
604 KEY downloads_http_idx (downloads_http),
605 KEY downloads_ftp_idx (downloads_ftp)
609 # Dumping data for table 'frs_dlstats_agg'
614 # Table structure for table 'frs_dlstats_file_agg'
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)
627 # Dumping data for table 'frs_dlstats_file_agg'
632 # Table structure for table 'frs_dlstats_filetotal_agg'
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)
642 # Dumping data for table 'frs_dlstats_filetotal_agg'
647 # Table structure for table 'frs_dlstats_filetotal_agg_old'
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)
657 # Dumping data for table 'frs_dlstats_filetotal_agg_old'
662 # Table structure for table 'frs_dlstats_group_agg'
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),
671 KEY downloads_idx (downloads)
675 # Dumping data for table 'frs_dlstats_group_agg'
680 # Table structure for table 'frs_dlstats_grouptotal_agg'
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)
690 # Dumping data for table 'frs_dlstats_grouptotal_agg'
695 # Table structure for table 'frs_file'
698 CREATE TABLE frs_file (
699 file_id int(11) NOT NULL auto_increment,
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))
716 # Dumping data for table 'frs_file'
721 # Table structure for table 'frs_filetype'
724 CREATE TABLE frs_filetype (
725 type_id int(11) NOT NULL auto_increment,
727 PRIMARY KEY (type_id)
731 # Dumping data for table 'frs_filetype'
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');
751 # Table structure for table 'frs_package'
754 CREATE TABLE frs_package (
755 package_id int(11) NOT NULL auto_increment,
756 group_id int(11) DEFAULT '0' NOT NULL,
758 status_id int(11) DEFAULT '0' NOT NULL,
759 PRIMARY KEY (package_id),
760 KEY idx_package_group_id (group_id)
764 # Dumping data for table 'frs_package'
769 # Table structure for table 'frs_processor'
772 CREATE TABLE frs_processor (
773 processor_id int(11) NOT NULL auto_increment,
775 PRIMARY KEY (processor_id)
779 # Dumping data for table 'frs_processor'
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');
793 # Table structure for table 'frs_release'
796 CREATE TABLE frs_release (
797 release_id int(11) NOT NULL auto_increment,
798 package_id int(11) DEFAULT '0' NOT NULL,
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)
813 # Dumping data for table 'frs_release'
818 # Table structure for table 'frs_status'
821 CREATE TABLE frs_status (
822 status_id int(11) NOT NULL auto_increment,
824 PRIMARY KEY (status_id)
828 # Dumping data for table 'frs_status'
831 INSERT INTO frs_status VALUES (1,'Active');
832 INSERT INTO frs_status VALUES (3,'Hidden');
835 # Table structure for table 'group_cvs_history'
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)
850 # Dumping data for table 'group_cvs_history'
855 # Table structure for table 'group_history'
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,
865 PRIMARY KEY (group_history_id),
866 KEY idx_group_history_group_id (group_id)
870 # Dumping data for table 'group_history'
875 # Table structure for table 'group_type'
878 CREATE TABLE group_type (
879 type_id int(11) NOT NULL auto_increment,
881 PRIMARY KEY (type_id)
885 # Dumping data for table 'group_type'
888 INSERT INTO group_type VALUES (1,'Project');
889 INSERT INTO group_type VALUES (2,'Foundry');
892 # Table structure for table 'groups'
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,
907 register_purpose text,
909 register_time int(11) DEFAULT '0' NOT NULL,
910 use_bugs int(11) DEFAULT '1' NOT NULL,
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)
940 # Dumping data for table 'groups'
944 # Table structure for table 'intel_agreement'
947 CREATE TABLE intel_agreement (
948 user_id int(11) DEFAULT '0' NOT NULL,
950 is_approved int(11) DEFAULT '0' NOT NULL,
951 PRIMARY KEY (user_id)
955 # Dumping data for table 'intel_agreement'
960 # Table structure for table 'mail_group_list'
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,
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,
972 PRIMARY KEY (group_list_id),
973 KEY idx_mail_group_list_group (group_id)
977 # Dumping data for table 'mail_group_list'
982 # Table structure for table 'news_bytes'
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,
995 KEY idx_news_bytes_forum (forum_id),
996 KEY idx_news_bytes_group (group_id),
997 KEY idx_news_bytes_approved (is_approved)
1001 # Dumping data for table 'news_bytes'
1006 # Table structure for table 'patch'
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,
1019 close_date int(11) DEFAULT '0' NOT NULL,
1020 PRIMARY KEY (patch_id),
1021 KEY idx_patch_group_id (group_id)
1025 # Dumping data for table 'patch'
1028 INSERT INTO patch VALUES (1,1,100,100,100,100,0,NULL,NULL,0);
1031 # Table structure for table 'patch_category'
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)
1043 # Dumping data for table 'patch_category'
1046 INSERT INTO patch_category VALUES (100,1,'None');
1049 # Table structure for table 'patch_history'
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,
1059 PRIMARY KEY (patch_history_id),
1060 KEY idx_patch_history_patch_id (patch_id)
1064 # Dumping data for table 'patch_history'
1069 # Table structure for table 'patch_status'
1072 CREATE TABLE patch_status (
1073 patch_status_id int(11) NOT NULL auto_increment,
1075 PRIMARY KEY (patch_status_id)
1079 # Dumping data for table 'patch_status'
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');
1089 # Table structure for table 'people_job'
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,
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)
1105 # Dumping data for table 'people_job'
1110 # Table structure for table 'people_job_category'
1113 CREATE TABLE people_job_category (
1114 category_id int(11) NOT NULL auto_increment,
1116 PRIMARY KEY (category_id)
1120 # Dumping data for table 'people_job_category'
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');
1132 # Table structure for table 'people_job_inventory'
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)
1145 # Dumping data for table 'people_job_inventory'
1150 # Table structure for table 'people_job_status'
1153 CREATE TABLE people_job_status (
1154 status_id int(11) NOT NULL auto_increment,
1156 PRIMARY KEY (status_id)
1160 # Dumping data for table 'people_job_status'
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');
1168 # Table structure for table 'people_skill'
1171 CREATE TABLE people_skill (
1172 skill_id int(11) NOT NULL auto_increment,
1174 PRIMARY KEY (skill_id)
1178 # Dumping data for table 'people_skill'
1183 # Table structure for table 'people_skill_inventory'
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)
1196 # Dumping data for table 'people_skill_inventory'
1201 # Table structure for table 'people_skill_level'
1204 CREATE TABLE people_skill_level (
1205 skill_level_id int(11) NOT NULL auto_increment,
1207 PRIMARY KEY (skill_level_id)
1211 # Dumping data for table 'people_skill_level'
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');
1221 # Table structure for table 'people_skill_year'
1224 CREATE TABLE people_skill_year (
1225 skill_year_id int(11) NOT NULL auto_increment,
1227 PRIMARY KEY (skill_year_id)
1231 # Dumping data for table 'people_skill_year'
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');
1241 # Table structure for table 'project_assigned_to'
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)
1254 # Dumping data for table 'project_assigned_to'
1259 # Table structure for table 'project_counts_tmp'
1262 CREATE TABLE project_counts_tmp (
1269 # Dumping data for table 'project_counts_tmp'
1274 # Table structure for table 'project_counts_weekly_tmp'
1277 CREATE TABLE project_counts_weekly_tmp (
1284 # Dumping data for table 'project_counts_weekly_tmp'
1289 # Table structure for table 'project_dependencies'
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)
1302 # Dumping data for table 'project_dependencies'
1307 # Table structure for table 'project_group_list'
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,
1316 PRIMARY KEY (group_project_id),
1317 KEY idx_project_group_list_group_id (group_id)
1321 # Dumping data for table 'project_group_list'
1324 INSERT INTO project_group_list VALUES (1,1,'',0,NULL);
1327 # Table structure for table 'project_history'
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)
1342 # Dumping data for table 'project_history'
1347 # Table structure for table 'project_metric'
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)
1359 # Dumping data for table 'project_metric'
1364 # Table structure for table 'project_metric_tmp1'
1367 CREATE TABLE project_metric_tmp1 (
1368 ranking int(11) NOT NULL auto_increment,
1369 group_id int(11) DEFAULT '0' NOT NULL,
1371 PRIMARY KEY (ranking)
1375 # Dumping data for table 'project_metric_tmp1'
1380 # Table structure for table 'project_metric_weekly_tmp1'
1383 CREATE TABLE project_metric_weekly_tmp1 (
1384 ranking int(11) NOT NULL auto_increment,
1385 group_id int(11) DEFAULT '0' NOT NULL,
1387 PRIMARY KEY (ranking)
1391 # Dumping data for table 'project_metric_weekly_tmp1'
1396 # Table structure for table 'project_status'
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)
1406 # Dumping data for table 'project_status'
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');
1415 # Table structure for table 'project_task'
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)
1435 # Dumping data for table 'project_task'
1438 INSERT INTO project_task VALUES (1,1,'','',0,0,0.00,0,0,100,100);
1441 # Table structure for table 'project_weekly_metric'
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)
1453 # Dumping data for table 'project_weekly_metric'
1458 # Table structure for table 'session'
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)
1473 # Dumping data for table 'session'
1477 # Table structure for table 'snippet'
1480 CREATE TABLE snippet (
1481 snippet_id int(11) NOT NULL auto_increment,
1482 created_by int(11) DEFAULT '0' NOT NULL,
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)
1495 # Dumping data for table 'snippet'
1500 # Table structure for table 'snippet_package'
1503 CREATE TABLE snippet_package (
1504 snippet_package_id int(11) NOT NULL auto_increment,
1505 created_by int(11) DEFAULT '0' NOT NULL,
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)
1516 # Dumping data for table 'snippet_package'
1521 # Table structure for table 'snippet_package_item'
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)
1533 # Dumping data for table 'snippet_package_item'
1538 # Table structure for table 'snippet_package_version'
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,
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)
1553 # Dumping data for table 'snippet_package_version'
1558 # Table structure for table 'snippet_version'
1561 CREATE TABLE snippet_version (
1562 snippet_version_id int(11) NOT NULL auto_increment,
1563 snippet_id int(11) DEFAULT '0' NOT NULL,
1566 submitted_by int(11) DEFAULT '0' NOT NULL,
1567 date int(11) DEFAULT '0' NOT NULL,
1569 PRIMARY KEY (snippet_version_id),
1570 KEY idx_snippet_version_snippet_id (snippet_id)
1574 # Dumping data for table 'snippet_version'
1579 # Table structure for table 'stats_agg_logo_by_day'
1582 CREATE TABLE stats_agg_logo_by_day (
1588 # Dumping data for table 'stats_agg_logo_by_day'
1593 # Table structure for table 'stats_agg_logo_by_group'
1596 CREATE TABLE stats_agg_logo_by_group (
1603 # Dumping data for table 'stats_agg_logo_by_group'
1608 # Table structure for table 'stats_agg_pages_by_browser'
1611 CREATE TABLE stats_agg_pages_by_browser (
1617 # Dumping data for table 'stats_agg_pages_by_browser'
1622 # Table structure for table 'stats_agg_pages_by_day'
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)
1632 # Dumping data for table 'stats_agg_pages_by_day'
1637 # Table structure for table 'stats_agg_pages_by_day_old'
1640 CREATE TABLE stats_agg_pages_by_day_old (
1646 # Dumping data for table 'stats_agg_pages_by_day_old'
1651 # Table structure for table 'stats_agg_site_by_day'
1654 CREATE TABLE stats_agg_site_by_day (
1655 day int(11) DEFAULT '0' NOT NULL,
1656 count int(11) DEFAULT '0' NOT NULL
1660 # Dumping data for table 'stats_agg_site_by_day'
1665 # Table structure for table 'stats_agg_site_by_group'
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
1675 # Dumping data for table 'stats_agg_site_by_group'
1680 # Table structure for table 'stats_agr_filerelease'
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)
1692 # Dumping data for table 'stats_agr_filerelease'
1697 # Table structure for table 'stats_agr_project'
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)
1727 # Dumping data for table 'stats_agr_project'
1732 # Table structure for table 'stats_ftp_downloads'
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)
1746 # Dumping data for table 'stats_ftp_downloads'
1751 # Table structure for table 'stats_http_downloads'
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)
1765 # Dumping data for table 'stats_http_downloads'
1770 # Table structure for table 'stats_project'
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)
1807 # Dumping data for table 'stats_project'
1812 # Table structure for table 'stats_project_tmp'
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)
1848 # Dumping data for table 'stats_project_tmp'
1853 # Table structure for table 'stats_site'
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)
1875 # Dumping data for table 'stats_site'
1880 # Table structure for table 'support'
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,
1893 close_date int(11) DEFAULT '0' NOT NULL,
1894 PRIMARY KEY (support_id),
1895 KEY idx_support_group_id (group_id)
1899 # Dumping data for table 'support'
1904 # Table structure for table 'support_canned_responses'
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,
1912 PRIMARY KEY (support_canned_id),
1913 KEY idx_support_canned_response_group_id (group_id)
1917 # Dumping data for table 'support_canned_responses'
1922 # Table structure for table 'support_category'
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)
1934 # Dumping data for table 'support_category'
1937 INSERT INTO support_category VALUES (100,1,'None');
1940 # Table structure for table 'support_history'
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,
1950 PRIMARY KEY (support_history_id),
1951 KEY idx_support_history_support_id (support_id)
1955 # Dumping data for table 'support_history'
1960 # Table structure for table 'support_messages'
1963 CREATE TABLE support_messages (
1964 support_message_id int(11) NOT NULL auto_increment,
1965 support_id int(11) DEFAULT '0' NOT NULL,
1967 date int(11) DEFAULT '0' NOT NULL,
1969 PRIMARY KEY (support_message_id),
1970 KEY idx_support_messages_support_id (support_id)
1974 # Dumping data for table 'support_messages'
1979 # Table structure for table 'support_status'
1982 CREATE TABLE support_status (
1983 support_status_id int(11) NOT NULL auto_increment,
1985 PRIMARY KEY (support_status_id)
1989 # Dumping data for table 'support_status'
1992 INSERT INTO support_status VALUES (1,'Open');
1993 INSERT INTO support_status VALUES (2,'Closed');
1994 INSERT INTO support_status VALUES (3,'Deleted');
1997 # Table structure for table 'supported_languages'
2000 CREATE TABLE supported_languages (
2001 language_id int(11) NOT NULL auto_increment,
2005 language_code char(2),
2006 PRIMARY KEY (language_id),
2007 KEY idx_supported_languages_code (language_code)
2011 # Dumping data for table 'supported_languages'
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');
2037 # Table structure for table 'survey_question_types'
2040 CREATE TABLE survey_question_types (
2041 id int(11) NOT NULL auto_increment,
2042 type text DEFAULT '' NOT NULL,
2047 # Dumping data for table 'survey_question_types'
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');
2058 # Table structure for table 'survey_questions'
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)
2071 # Dumping data for table 'survey_questions'
2076 # Table structure for table 'survey_rating_aggregate'
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)
2088 # Dumping data for table 'survey_rating_aggregate'
2093 # Table structure for table 'survey_rating_response'
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)
2107 # Dumping data for table 'survey_rating_response'
2112 # Table structure for table 'survey_responses'
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)
2129 # Dumping data for table 'survey_responses'
2134 # Table structure for table 'surveys'
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)
2148 # Dumping data for table 'surveys'
2153 # Table structure for table 'system_history'
2156 CREATE TABLE system_history (
2157 id int(11) NOT NULL auto_increment,
2158 system_news_id int(11) DEFAULT '0' NOT NULL,
2165 # Dumping data for table 'system_history'
2170 # Table structure for table 'system_machines'
2173 CREATE TABLE system_machines (
2174 id int(11) NOT NULL auto_increment,
2181 # Dumping data for table 'system_machines'
2186 # Table structure for table 'system_news'
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,
2202 # Dumping data for table 'system_news'
2207 # Table structure for table 'system_services'
2210 CREATE TABLE system_services (
2211 id int(11) NOT NULL auto_increment,
2217 # Dumping data for table 'system_services'
2222 # Table structure for table 'system_status'
2225 CREATE TABLE system_status (
2226 id int(11) NOT NULL auto_increment,
2232 # Dumping data for table 'system_status'
2237 # Table structure for table 'theme_prefs'
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)
2253 # Dumping data for table 'theme_prefs'
2257 # Table structure for table 'themes'
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)
2268 # Dumping data for table 'themes'
2271 INSERT INTO themes VALUES (1,'forged','Forged Metal');
2272 INSERT INTO themes VALUES (2,'classic','Classic Sourceforge');
2275 # Table structure for table 'tmp_projs_releases_tmp'
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
2286 # Dumping data for table 'tmp_projs_releases_tmp'
2291 # Table structure for table 'top_group'
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)
2320 # Dumping data for table 'top_group'
2325 # Table structure for table 'trove_cat'
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,
2340 PRIMARY KEY (trove_cat_id),
2341 KEY parent_idx (parent),
2342 KEY root_parent_idx (root_parent),
2343 KEY version_idx (version)
2347 # Dumping data for table 'trove_cat'
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');
2621 # Table structure for table 'trove_group_link'
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)
2636 # Dumping data for table 'trove_group_link'
2640 # Table structure for table 'trove_treesums'
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)
2652 # Dumping data for table 'trove_treesums'
2657 # Table structure for table 'unix_uids'
2660 CREATE TABLE unix_uids (
2661 id int(11) NOT NULL auto_increment,
2666 # Dumping data for table 'unix_uids'
2669 INSERT INTO unix_uids VALUES (1);
2672 # Table structure for table 'user_bookmarks'
2675 CREATE TABLE user_bookmarks (
2676 bookmark_id int(11) NOT NULL auto_increment,
2677 user_id int(11) DEFAULT '0' NOT NULL,
2679 bookmark_title text,
2680 PRIMARY KEY (bookmark_id),
2681 KEY idx_user_bookmark_user_id (user_id)
2685 # Dumping data for table 'user_bookmarks'
2690 # Table structure for table 'user_diary'
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,
2699 is_public int(11) DEFAULT '0' NOT NULL,
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)
2707 # Dumping data for table 'user_diary'
2712 # Table structure for table 'user_diary_monitor'
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)
2725 # Dumping data for table 'user_diary_monitor'
2730 # Table structure for table 'user_group'
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)
2755 # Dumping data for table 'user_group'
2758 INSERT INTO user_group VALUES (1,101,2,'A',2,2,2,1,1,0,1);
2761 # Table structure for table 'user_metric'
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)
2777 # Dumping data for table 'user_metric'
2782 # Table structure for table 'user_metric0'
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)
2799 # Dumping data for table 'user_metric0'
2804 # Table structure for table 'user_metric_tmp1_1'
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
2816 # Dumping data for table 'user_metric_tmp1_1'
2821 # Table structure for table 'user_preferences'
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)
2833 # Dumping data for table 'user_preferences'
2838 # Table structure for table 'user_ratings'
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)
2851 # Dumping data for table 'user_ratings'
2856 # Table structure for table 'users'
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,
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)
2886 # Dumping data for table 'users'
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);