update_3.6.0-3.7.0.sql 541 B

1234567891011121314
  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. create table llx_entity_extrafields
  8. (
  9. rowid integer AUTO_INCREMENT PRIMARY KEY,
  10. tms timestamp,
  11. fk_object integer NOT NULL,
  12. import_key varchar(14)
  13. ) ENGINE=innodb;