it never had.....default use that value when you do inserts with forms or
directly with DAL, it doesn't enforce nothing on the db.
Il giorno giovedì 4 ottobre 2012 14:58:49 UTC+2, flando ha scritto:
>
> Dears
>
> I have an issue that the defined default value in db.py is not taken into
> the mysql table definition.
> E.g. I define in db.py:
>
> db.define_table('testcustomer',
> Field('country2','string', length=2, default='ch', label=T('Land')),
> Field('language2','string', length=2, default='de',
> label=T('Sprache')),
> Field('state_id',db.state, default=1, label=T('Status')),
> Field('company','string', length=75, default='', label=T('Firma')),
> Field('email','string', length=128, default='', label=T('E-Mail'),
> unique=True),
> format='%(email)s',
> migrate=True)
>
> This results in mysql (show create table testcustomer):
> | testcustomer | CREATE TABLE `testcustomer` (
> `id` int(11) NOT NULL AUTO_INCREMENT,
> `country2` varchar(2) DEFAULT NULL,
> `language2` varchar(2) DEFAULT NULL,
> `state_id` int(11) DEFAULT NULL,
> `company` varchar(75) DEFAULT NULL,
> `email` varchar(128) DEFAULT NULL,
> PRIMARY KEY (`id`),
> UNIQUE KEY `email` (`email`),
> ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 |
>
> As you can see, default does not get set in mysql as defined in db.py.
> What could be the cause?
> Also I wonder why auto_increment is set to "2" instead of "1"?
>
> Thank you and kind regards
> Fritz
>
--
