The Events team has done a thorough analysis of the table structure that is since long used by the Events module. And we have formulated plans for 04.01.00 to improve this structure: better declared referential integrity and column definitions. We will need this for further enhancements of the module. But before we can decide on every aspect we want to improve, we would be greatly helped by statistics of Events tables of production sites, DNN sites that really use (any version of) the Events module.
In order to get this data, we have created a SQL script that reads information form Events tables and shows them in a grid. The SQL does only reads and does not modify any data. So it should be safe to run it in a production environment. You can find the SQL script by clicking on this link.
We ask you to run this SQL script from the SQL option in the Host menu of your site. Just
- copy the SQL script to the clipboard
- paste it in the SQL textbox in the Host/SQL menu
- click execute
- copy the resulting SQL output
- paste it in en e-mail to ErnstPeter.Tamminga@dotnetnuke.com, the e-mail address of Events Team lead
Your results are valuable to us and will be to all other Events module users!