update_3.1.0-3.2.0.sql 365 B

12345678
  1. --
  2. --
  3. -- To add a column: ALTER TABLE llx_table ADD COLUMN newcol varchar(60) NOT NULL DEFAULT '0' AFTER existingcol;
  4. -- To rename a column: ALTER TABLE llx_table CHANGE COLUMN oldname newname varchar(60);
  5. -- To change type of field: ALTER TABLE llx_table MODIFY name varchar(60);
  6. --
  7. ALTER TABLE llx_entity ADD COLUMN options text AFTER fk_user_creat;