File: upgrade_3.3cvs5.sql

package info (click to toggle)
sitebar 3.3.8-7etch1
  • links: PTS
  • area: main
  • in suites: etch
  • size: 4,168 kB
  • ctags: 3,234
  • sloc: php: 52,374; sql: 570; sh: 331; makefile: 35
file content (13 lines) | stat: -rw-r--r-- 425 bytes parent folder | download | duplicates (4) 
1
2
3
4
5
6
7
8
9
10
11
12
13
 
ALTER TABLE `sitebar_user`
    DROP `code`;

CREATE TABLE `sitebar_token` (
  `uid` int(10) unsigned NOT NULL,
  `type` varchar(10) DEFAULT '',
  `issued` datetime NOT NULL default '0000-00-00 00:00:00',
  `expires` int(11) NOT NULL DEFAULT '0',
  `token` varchar(8) DEFAULT ''
) TYPE=MyISAM PACK_KEYS=0 COMMENT='Tokes for email validation, forgotten passwords, ...';

UPDATE `sitebar_config`
    SET `release` = '3.3 CVS6';