File: upgrade_3.0.2.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 (17 lines) | stat: -rw-r--r-- 411 bytes parent folder | download | duplicates (5) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
 
ALTER TABLE `sitebar_link`
    DROP INDEX `url`;

ALTER TABLE `sitebar_link`
    CHANGE `comment` `comment` LONGTEXT DEFAULT NULL;

ALTER TABLE `sitebar_link`
    CHANGE `url` `url` TEXT NOT NULL DEFAULT '';

ALTER TABLE `sitebar_link`
    CHANGE `name` `name` VARCHAR(255) NOT NULL;

ALTER TABLE `sitebar_node`
    CHANGE `name` `name` VARCHAR(255) NOT NULL;

UPDATE `sitebar_config`
   SET `release` = '3.1';