Git Product home page Git Product logo

Comments (1)

rainerduffner avatar rainerduffner commented on September 26, 2024

This is the output I get from the upgrade script:

You made a backup already, right?
  # mysqldump -u root -p nictool > nictool-2011-11-16.sql
  # gzip nictool-2011-11-16.sql

Hit return to continue...

Skipping v2.00 SQL updates (already applied).
Skipping v2.05 SQL updates (already applied).
Skipping v2.08 SQL updates (already applied).
Skipping v2.09 SQL updates (already applied).
Skipping v2.10 SQL updates (already applied).
Skipping v2.11 SQL updates (already applied).
Skipping v2.14 SQL updates (already applied).
applying v 2.15 SQL updates
/* submitted by Arthur Gouros, remove legacy : chars */
UPDATE nt_zone_record SET address = REPLACE(address,'\072',':');

UPDATE nt_options SET option_value='2.15' WHERE option_name='db_version';

applying v 2.16 SQL updates
ALTER TABLE nt_perm ADD column usable_ns VARCHAR(50) AFTER self_write;

UPDATE nt_perm SET usable_ns=(CONCAT_WS(',', usable_ns0,usable_ns1,usable_ns2,usable_ns3,usable_ns4,usable_ns5,usable_ns6,usable_ns7,usable_ns8,usable_ns9));

ALTER TABLE nt_perm DROP column usable_ns0;

ALTER TABLE nt_perm DROP column usable_ns1;

ALTER TABLE nt_perm DROP column usable_ns2;

ALTER TABLE nt_perm DROP column usable_ns3;

ALTER TABLE nt_perm DROP column usable_ns4;

ALTER TABLE nt_perm DROP column usable_ns5;

ALTER TABLE nt_perm DROP column usable_ns6;

ALTER TABLE nt_perm DROP column usable_ns7;

ALTER TABLE nt_perm DROP column usable_ns8;

ALTER TABLE nt_perm DROP column usable_ns9;

ALTER TABLE nt_zone_record MODIFY address VARCHAR(512) NOT NULL;

ALTER TABLE nt_zone_record_log MODIFY address VARCHAR(512) NOT NULL;

UPDATE nt_options SET option_value='2.16' WHERE option_name='db_version';

applying v 2.17 SQL updates
ALTER TABLE nt_user ADD COLUMN is_admin TINYINT(1) UNSIGNED default '0' AFTER email;

Skipping v2.18 SQL updates (already applied).
Skipping v2.24 SQL updates (already applied).
Skipping v2.27 SQL updates (already applied).
Skipping v2.28 SQL updates (already applied).
Skipping v2.29 SQL updates (already applied).
Skipping v2.30 SQL updates (already applied).
Skipping v2.32 SQL updates (already applied).
Skipping v2.34 SQL updates (already applied).

from nictool.

Related Issues (20)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.