Jump to:

17452 Posts in 4473 Topics by 1971 members

Archive

SilverStripe Forums » Archive » table prefix in database

Our old forums are still available as a read-only archive.

Moderators: martimiz, Sean, biapar, Willr, Ingo, simon_w

Page: 1
Go to End
Author Topic: 1962 Views
  • neothinkx
    Avatar
    Community Member
    1 Post

    table prefix in database Link to this post

    Hi.i just downloaded silverstripe.It is good CMS.I installed it on my local system and it installed without any error.Now i want to install on my webhost but problem is that i am allowed only to have one database.I want to prefix silverstripe tables with ss_. i have done this with zencart because that had an option during installation.but there is no such option while installing silverstripe.I know it can be done by modifying some code but do not know exactly where.i tried to find but got confused.please help .
    thanks

  • Hamish
    Avatar
    Community Member
    712 Posts

    Re: table prefix in database Link to this post

    A hacky way of doing it might be to modify MySQLDatabase.php (sapphire/core/model/) - wherever there is an SQL query with $table or $tableName, prefix it with whatever you want. I haven't tried it and you'd have to be careful with future upgrades, but it might be a temporary fix for your situation.

    1962 Views
Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.