missing field in users_users table after upgrade from 1.9.11

• Error

After upgrading from 1.9.11 to 2.0 an error occurs with a missing field (email_confirm) when trying to add a new user as summarised at the end of this post. This seems to be repeatable across several sites that I have upgraded from 1.9.11 so I am assuming something wrong with the upgrade script. Have checked the database using phpMyAdmin and whilst the field is present on a brand new install it is consistently missing in all the upgrades. Manually adding the field from phpMyAdmin rectifies the problem.

Would be very useful to have the full 2.0 data structure documented since I am seeing inconsistencies between the the number of tables in an upgraded site versus a new 2.0 site (upgrade had more tables) - some sort of test utility to validate the data structure would also be very very useful.

ERRORS RECEIVED WHEN TRYING TO ADD A NEW USER:

An error occured in a database query!

Context:
File tiki-adminusers.php
Url tiki-adminusers.php
Query:
insert into `users_users`(`login`, `password`, `email`, `provpass`, `registrationDate`, `hash`, `pass_confirm`, `email_confirm`, `created`, `valid`, `openid_url`, `lastLogin`, `waiting`) values(?,?,?,?,?,?,?,?,?,?,?,?,?)
Values:
0 testuser
1 testuser99
2 admin@enmoreservices.com
3
4 1221214268
5 $1$9LOB42RB$ZHSl8Al4i9Aw4KcLnHlpa.
6 0
7 1221214268
8 1221214268
9 NULL
10 NULL
11 NULL
12 NULL
Message:
Unknown column 'email_confirm' in 'field list'
Built query was probably:
insert into `users_users`(`login`, `password`, `email`, `provpass`, `registrationDate`, `hash`, `pass_confirm`, `email_confirm`, `created`, `valid`, `openid_url`, `lastLogin`, `waiting`) values('testuser','testuser99','admin@enmoreservices.com','','1221214268','$1$9LOB42RB$ZHSl8Al4i9Aw4KcLnHlpa.','0','1221214268','1221214268',NULL,NULL,NULL,NULL)

This bug has been demonstrated on show2.tiki.org

Please demonstrate your bug on show2.tiki.org