Re: [Gitstat-devel] How to deal with database changes between versions

[<jun...@gm...>]

Hi..

Actually, I made that script.
I forgot to upload that script :-)

1. Run Mysql and select your database.
2. type "ALTER TABLE `Memcategory` ADD `filename` VARCHAR( 80 ) NOT
NULL DEFAULT '0';"

or just use this script

[gitstat]# mysql -u username -p dbname < ./gitstat.update.sql


- gitstat.update.sql
-----------------------------------
use database; # your database name

ALTER TABLE `Memcategory` ADD `filename` VARCHAR( 80 ) NOT NULL DEFAULT '0';"
-----------------------------------

Thanks,


On 8/30/07, Paul Vriens <pau...@gm...> wrote:
> Hi,
>
> Thanks for 0.0.2 ! I'll have a go at it.
>
> The database layout changed (a bit) between 0.0.1 and 0.0.2 (addition of the
> filename field). It would be nice if documentation (or better yet a scripts) is
> provided to show how to amend the database.
>
>  From the above you can see I'm not a DB wizard.
>
> Cheers,
>
> Paul.
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >>  http://get.splunk.com/
> _______________________________________________
> Gitstat-devel mailing list
> Git...@li...
> https://lists.sourceforge.net/lists/listinfo/gitstat-devel
>