You can always define other tables before the call to auth.define_tables().
Unless they have dependencies on other auth_* tables, that is. On Wednesday, October 23, 2013 8:50:39 AM UTC-4, Alfonso de la Guarda Reyes wrote: > > Hi, > > The problem is in the auth custom fields because they are created > before any other table and the extra fields add some relations. At > first time, i need create the basic auth table and after that just add > the extra fields, then for the deployment is a 2 step process. > Maybe the extra fileds should be created after the other tables. > Saludos, > > -------------------------------- > Alfonso de la Guarda > Twitter: @alfonsodg > Redes sociales: alfonsodg > Telef. 991935157 > 1024D/B23B24A4 > 5469 ED92 75A3 BBDB FD6B 58A5 54A1 851D B23B 24A4 > > > On Tue, Oct 22, 2013 at 3:45 PM, Cliff Kachinske > <cjk...@gmail.com<javascript:>> > wrote: > > Are you using lazy tables? > > > > Do your models define the referenced tables before they define the > referrer? > > > > > > On Tuesday, October 22, 2013 2:14:22 PM UTC-4, Alfonso de la Guarda > Reyes > > wrote: > >> > >> Hi, > >> > >> For the first time i have found a problem between web2py and mysql in > >> two Linux flavors: Ubuntu and Arch. > >> > >> When i try to simply change the database from sqlite to mysql (and > >> after delete all inside databases) the mysql shows me an error: > >> > >> <class '_mysql_exceptions.OperationalError'> (1005, "Can't create > >> table 'bassistant.auth_user' (errno: 150)") > >> > >> Obviosuly my ba-users has the right permissions, but when i check for > >> the log in databases i notice this: > >> > >> > >> CREATE TABLE auth_user( > >> id INT AUTO_INCREMENT NOT NULL, > >> first_name VARCHAR(128), > >> last_name VARCHAR(128), > >> email VARCHAR(512), > >> password VARCHAR(512), > >> registration_key VARCHAR(512), > >> reset_password_key VARCHAR(512), > >> registration_id VARCHAR(512), > >> phone VARCHAR(512), > >> company INT, INDEX company__idx (company), FOREIGN KEY (company) > >> REFERENCES companies (id) ON DELETE CASCADE, > >> place INT, INDEX place__idx (place), FOREIGN KEY (place) > >> REFERENCES places (id) ON DELETE CASCADE, > >> PRIMARY KEY(id) > >> ) ENGINE=InnoDB CHARACTER SET utf8; > >> > >> Which references to foreign keys which obviously aren't created yet, > >> also in Arch i am using MariaDB (which doesn't uses InnoDB) with the > >> same driver. > >> > >> Any consideration for this? If not i will try to fix in the dal source > >> and put the changes. > >> > >> > >> Saludos, > >> > >> -------------------------------- > >> Alfonso de la Guarda > >> Twitter: @alfonsodg > >> Redes sociales: alfonsodg > >> Telef. 991935157 > >> 1024D/B23B24A4 > >> 5469 ED92 75A3 BBDB FD6B 58A5 54A1 851D B23B 24A4 > > > > -- > > Resources: > > - http://web2py.com > > - http://web2py.com/book (Documentation) > > - http://github.com/web2py/web2py (Source code) > > - https://code.google.com/p/web2py/issues/list (Report Issues) > > --- > > You received this message because you are subscribed to the Google > Groups > > "web2py-users" group. > > To unsubscribe from this group and stop receiving emails from it, send > an > > email to web2py+un...@googlegroups.com <javascript:>. > > For more options, visit https://groups.google.com/groups/opt_out. > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
