| 1234567891011121314 |
- --
- --
- -- To add a column: ALTER TABLE llx_table ADD COLUMN newcol varchar(60) NOT NULL DEFAULT '0' AFTER existingcol;
- -- To rename a column: ALTER TABLE llx_table CHANGE COLUMN oldname newname varchar(60);
- -- To change type of field: ALTER TABLE llx_table MODIFY name varchar(60);
- --
- create table llx_entity_extrafields
- (
- rowid integer AUTO_INCREMENT PRIMARY KEY,
- tms timestamp,
- fk_object integer NOT NULL,
- import_key varchar(14)
- ) ENGINE=innodb;
|