search for: schema1

Howdy, I just gem unpacked merb and have configured the sample_app to use an sqlite3 database. I see that the Rakefile has a task named "schema", but it points to /dist/schema/schema1.rb", which doesn''t exist. I copied /dist/schema/schema1.rb to /dist/schema/schema.rb then ran "rake schema". What''s the recommended way to create the database tables? Thanks, Ed

...able changes in one app to impact the other. Example: App 1 contains order entry. App 2 contains contact management. In App 2, I want to access the order history for a customer/contact. So, I create an order model in App 2 and set the table name to include the schema...e.g. set_table_name "schema1.orders". However, I want both apps to have their own migrations. How do I tell Rails to use a particular schema when doing migrations, fixture loads, etc.? Alternative(s): The other reasonable option seems to be multiple database connections in each app, which I haven''t investigate...

Hi, I''ve offered to make a web based studio booking system for the university I attended to replace their old pen and paper approach and I''m having some trouble deciding on the best way to organise the database. What will happen is the students (or tutors) will log in and be presented with a weekly calendar view of the studios, along with details of existing bookings. They