|
From: | Florian HENRY |
Subject: | Re: [Dolibarr-dev] SQL guidelines into migration scirpt |
Date: | Fri, 6 Nov 2015 11:25:40 +0100 |
User-agent: | Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101 Thunderbird/38.3.0 |
Same things tinyint or TINYINT(1) => NO smallint => YES if llx_mytable.my_column varchar(30) (or int or whatever) allow null and we want to disallow null ALTER TABLE llx_mytable MODIFY COLUMN my_column varchar(30) NOT NULL => NO ALTER TABLE llx_mytable MODIFY COLUMN my_column varchar(30) NOT NULL DEFAULT '' => YES We can't specified NOT NULL on MODIFY COLUMN without specified DEFAULT values https://github.com/Dolibarr/dolibarr/pull/3918 Regards Florian Henry +33 6 03 76 48 07 address@hidden http://www.open-concept.pro Twitter : @_Open_Concept_ Google+ : https://www.google.com/+Open-conceptPro Le 06/11/2015 11:03, Florian HENRY a
écrit :
Hello All, |
[Prev in Thread] | Current Thread | [Next in Thread] |