Create CMSB Schema from mySQL table

3 posts by 2 authors in: Forums > CMS Builder
Last Post: March 26, 2012   (RSS)

Re: [rjbathgate] Create CMSB Schema from mySQL table

By (Deleted User) - March 26, 2012

Hi rjbathgate,

There is no easy way to build a schema from an extant mysql table created outside of CMSB.

One approach to try might be to manually create a schema file for the table in question by copying and pasting the various column entries from other CMSB tables (changing the column names where needed).

If you open a schema file (cmsAdmin/Data/schema/) to have a look at the structure you can then assemble a schema for your table.

Depending on how many columns you have in your table, this method could end up being pretty work intensive.

Let me know if this helps,

Tom

Re: [Tom P] Create CMSB Schema from mySQL table

Hey

Thanks for the info - yeah thought it would be a manual case like that.

Worth a try thou ;)

Cheers