- --
- --
- -- 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);
- --
- ALTER TABLE llx_entity ADD COLUMN options text AFTER fk_user_creat;
|