Person
New Tables
two_firstname two_middlename two_lastname two_standardname two_street two_city two_state two_post two_country two_institution two_old_institution two_mainphone two_labphone two_officephone two_otherphone two_fax two_email two_old_email two_pis two_lab two_oldlab two_left_field two_unable_to_contact two_privacy two_aka_firstname two_aka_middlename two_aka_lastname two_webpage two_wormbase_comment two_hide two_status two_mergedinto two_acqmerge two_comment two_usefulwebpage
Changes between old and new tables
- Adding history tables as h_two_...
- Removing two_apu_ tables, two_groups
- Adding two_usefulwebpage
- Changing two_comment into normal table with order
- Changing old_timestamp column to two_curator (all values will be 'two1')
Questions
Please confirm that no one uses this form http://tazendra.caltech.edu/~azurebrd/cgi-bin/forms/confirm_paper.cgi In the last year 111 IPs have used it (mostly once) but a couple of them over 100 each. If you don't use it, is it in the emails you send out or in the submit forms in WormBase ?
1681 two_middlename without value, is that okay ? SELECT * FROM two_middlename WHERE two_middlename = ' '; <-- no space in between the singlequotes
1004 two_middlename with NULL order, value, old_timestamp, what should we do with that ? SELECT * FROM two_middlename WHERE two_order IS NULL;
To Do
Check these forms / scripts :
- /home/postgres/public_html/cgi-bin/cecilia/two_display.cgi
- /home/postgres/public_html/cgi-bin/cecilia/twoeditor.cgi
- /home/postgres/public_html/cgi-bin/paper_editor.cgi
- /home/azurebrd/public_html/cgi-bin/forms/paper_display.cgi
- /home/azurebrd/public_html/cgi-bin/forms/person.cgi
- /home/azurebrd/public_html/cgi-bin/forms/person_lineage.cgi
- /home/azurebrd/work/parsings/authorperson/citaceLineage/update_twos_in_two_lineage.pl
- /home/cecilia/UPLOAD/new-upload/connect_single_match_authors_and_get_histogram.pl
- /home/cecilia/UPLOAD/new-upload/verify_by_labs_or_lineage.pl
- /home/cecilia/UPLOAD/new-upload/email_connected_authors.pl
- /home/cecilia/work/gaps_in_twos/get_recent.pl
- /home/acedb/cecilia/citace_upload/get_pap_person_ace.pl
