Check out the LimeSurvey source code on GitHub!
Welcome, Guest
Username: Password:

TOPIC: Modifying limesurvey database

Modifying limesurvey database 4 years 8 months ago #73511

  • javierab
  • javierab's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 4
  • Karma: 0
Hi everyone :) ,

I'm currently working on some modifications to limesurvey to fit our personal project, so I'd like to add new tables and columns to the limesurvey database, and be able to update those fields altogether with the "official" limesurvey ones. I realize this requires major modifications in the code, but I'm on it anyway.

The thing is, I was going through the code, and I'm having trouble finding some stuff I need to modify, namely
(1) the place where the database is created at first, so I can add the tables I need.
(2) the place where prefix_survey_surveyid table is created, so I can add a new column to it.

So, if someone could help me find this things i would be very very grateful!

Thanks in advance, and I promise I'll make a donation if the project works! :P
The administrator has disabled public write access.

Modifying limesurvey database 4 years 8 months ago #73592

  • Mazi
  • Mazi's Avatar
  • Offline
  • LimeSurvey Team
  • Posts: 6015
  • Thank you received: 372
  • Karma: 260
a) What modifications are you working on in detail?

b) Please have a look at

1. The main database is created during install, see /admin/install/...sql

2. When activating a survey, the "lime_survey_12345" table is created. Have a look at the "activate.php" scipt.

Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)'"
The administrator has disabled public write access.
Time to create page: 0.220 seconds
Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form