In Rails Migration scripts if a table column is defined as
t.column :my_decimal_column, :decimal, :precision =>8, :scale =>2, :default =>0.00, it would result with a column decimal(10,0) in Mysql db. The problem is with the current stable rails. With Edgerails, it will work.
Visit EdgeRails at http://wiki.rubyonrails.com/rails/pages/EdgeRails
A work aroung for this could be, in your migration script use:
execute "alter table my_table modify column my_decimal_column decimal(8,2)" instead.
Showing posts with label MySql. Show all posts
Showing posts with label MySql. Show all posts
Thursday, December 28, 2006
Monday, December 25, 2006
Parallels Windows TOAD + Ubuntu - MySql
1. Install SSH server for remote access
sudo apt-get install ssh
2. Install MySql database server
sudo apt-get install mysql-server
3. Install Apache HTTP Server(as super user, otherwise you might get into problem with domain name as at after installation it says:sudo apt-get install apache2
Could not determine the server's fully qualified domain name, using 127.0.1.1)
3.1 Test apache installation by pointing browser at http://localhost or http://yourcomputername
4. Install PHP for Apache HTTP server
sudo apt-get install php4
5. MySql for Apache HTTP server
sudo apt-get install libapache2-mod-auth-mysql
sudo apt-get install php4-mysql
Subscribe to:
Posts (Atom)
