2 function upgrade_do32() {
\r
4 if (upgrade_checkinstall(32))
\r
5 return 'already installed';
\r
7 // create nucleus_activation table
\r
8 $query = 'CREATE TABLE ' . sql_table('activation') . ' ('
\r
9 . ' vkey varchar(40) NOT NULL default \'\','
\r
10 . ' vtime datetime NOT NULL default \'0000-00-00 00:00:00\','
\r
11 . ' vmember int(11) NOT NULL default \'0\','
\r
12 . ' vtype varchar(15) NOT NULL default \'\','
\r
13 . ' vextra varchar(128) NOT NULL default \'\','
\r
14 . ' PRIMARY KEY (vkey) '
\r
16 upgrade_query('Creating account activation table', $query);
\r
18 // create CookiePrefix setting
\r
19 $query = 'INSERT INTO '.sql_table('config')." VALUES ('CookiePrefix','')";
\r
20 upgrade_query('Creating CookiePrefix config value',$query);
\r
22 // create nucleus_tickets table
\r
23 $query = 'CREATE TABLE ' . sql_table('tickets') . ' ('
\r
24 . ' ticket varchar(40) NOT NULL default \'\','
\r
25 . ' ctime datetime NOT NULL default \'0000-00-00 00:00:00\','
\r
26 . ' member int(11) NOT NULL default \'0\', '
\r
27 . ' PRIMARY KEY (ticket, member) '
\r
29 upgrade_query('Creating ticket table', $query);
\r
32 // update database version
\r
33 $query = 'UPDATE ' . sql_table('config') . ' set value=\'320\' where name=\'DatabaseVersion\'';
\r
34 upgrade_query('Updating DatabaseVersion in config table to 320', $query);
\r