The website can create forms that take applications
for workshops, internships etc.

<p>To enable the facility, the configuration file
<code>~www/php/<i>servername</i>/config.php</code>
for the website
must have:
<pre>
// True if the site has forms for applying for superb etc.
$siteConfig['hasApply'] = 1;
</pre>

<p>In addition, the <code>auth_<i>N</i></code>
table must have a <code>hasApply</code> field that
is a tinyInt.  That field has been added to
<code>auth_4</code> (for TRUST) and
<code>auth_5</code> (for E3S).</p>

<p>In theory, checking "Application Form" should create
the <code>apply</code> table, but as of 10/11, it does
not.  The workaround is to export the structure only
of a preexisting <code>apply</code> table, such 
as the <code>wise_4</code> database -> <code>apply</code>
table. 
<ol>
<li> <a href="http://chess.eecs.berkeley.edu/mysql">http://chess.eecs.berkeley.edu/mysql</a>
<li> Go to <code>wise_4</code> and then
<code>apply</code>
<li>Select the "Export" tab at the top and unselect
"data" so that only the structure is exported.  Hit
OK and an <code>apply.sql</code> file is exported.

<li> Go to the database for the workgroup that wants
the apply facility.</li>
<li> Select "Import" and import the <code>apply.sql</code>
table.
<li> To get the facility to work, 
<code>~www/php/include/apply.inc.php</code> will
need to be updated:  
  <br/>$apply_positions: Add the new group and the acceptable positions
  <br/>$apply_citizenship: Add the new group and the
acceptable citizenship.
</li>
</ol>




<p>The file <code>~www/php/include/apply.inc.php</code>
controls what fields are present.  An admin must
edit that file by hand.

<p>If the user selects "Application Form" on the
group configuration page, then the database for the
applications is created.  Thus, to reset the application 
pool, use <code>http://<i>website</i>/mysql</code>
to drop the apply table for the group.
<b>note that this will lose the previous application data</b>

<p>Email notification goes to the people on the notify
list for the group.  If there is no notify group, then
it goes to the developers.  If there is no developer
list, then it goes to webmaster.

<p>To create a new application, try copying the structure,
not the data with:
<pre>
mysqldump -d reu_4 apply > apply.sql
mysql postdocs_7 < apply.sql
</pre>

<p>See also <a href="http://embedded.eecs.berkeley.edu/dopsysadmin/faq/57.html">How do I control access to the application forms?</a>