151 Posts
pixelpixel
7 years ago
4
Topic

Hi SEBLOD Team,


i need to change the primary key for some cck_store_form... tables. Default is ID (referencing to the joomla article id). Is it ok if i change it to another field/column? Or will anything bad happen? :)


Kind regards

Get a VIP membership
4229 Posts
Kadministrator
7 years ago
3
Level 1

Primary key for article object is always article id.

151 Posts
pixelpixel
7 years ago
2
Level 2

Hi Klas,

so should i leave the default setting (id)? I am asking because i need a unique (auto_increment) column in my cck_store_form table since the "normal" id gets his value from the joomla content table and therefore is not consecutive.


Best regards

Necati

4229 Posts
Kadministrator
7 years ago
1
Level 3

You should not alter cck_store_form tables, especially not primary key or Seblod won't work - ids need to match article ids for Article object. If you need different database structure you should use custom table with Free storage object.

151 Posts
pixelpixel
7 years ago
0
Level 4

Hi Klas,

thx a lot for the warning. I thougth about a custom table too. But i need the connection to a joomla article because i need joomlas access control. I guess i could construct a key, which behaves like primary key. BeforeStore Field with a simple +1 adding should do it :)

Update: My mistake. Since the id in the form tables is a primary key, but with no auto_increment, i can still define my key with auto_increment and unique. Thats all what i need. SEBLOD rocks! I rock too!

Best regards

Get a Book for SEBLOD