Stop saving submission as "XML" [#7999]

Stop saving submissions as XML in a table but instead save the submissions in a table where each element of the submission are saved as a singel row.
Example on sql scheme:
nid unsigned int(10) -- node id of the form
sid unsigned int(10) -- submission id
cid unsigned int(10) -- component id
uid unsigned int(10) -- user who made the submission
created date -- date of the submission
data varchar(255) -- value of the submission
PRIMARY KEY(nid, sid, cid)

This would make it easier to create reports and in other way gather information from the submissions.

Comments

Comment #1

ullgren CreditAttribution: ullgren commented 6 June 2004 at 12:25

Changing target release to CVS

Comment #2

ullgren CreditAttribution: ullgren commented 21 July 2004 at 15:46

Now saves the submited data as key-value pairs in the following table.

CREATE TABLE webform_submited_data
  ( nid int(10) unsigned not null,
    sid int(10) unsigned not null,
    name varchar(255),
    data blob,
    PRIMARY KEY(nid, sid));