File: upgrade_3.3.6.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 (16 lines) | stat: -rw-r--r-- 375 bytes parent folder | download | duplicates (4) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
 
ALTER TABLE `sitebar_user`
    CHANGE `email` `username` VARCHAR( 50 ) NOT NULL;

ALTER TABLE `sitebar_user`
    ADD `email` VARCHAR( 50 ) AFTER `pass`;

ALTER TABLE `sitebar_user`
    DROP INDEX `email` ,
    ADD UNIQUE `username` ( `username` );

UPDATE `sitebar_user`
SET email = username
WHERE username LIKE '%@%.%';

UPDATE `sitebar_config`
   SET `release` = '3.3.6a';