Skip to content
Snippets Groups Projects
Select Git revision
  • 586facb7240b07ec0f7e41a546cd6ede797d9cf3
  • 3.9 default
  • develop
  • 6.0
  • 5.0
  • 4.0
  • scrutinizer-patch-4
  • scrutinizer-patch-3
  • scrutinizer-patch-2
  • scrutinizer-patch-1
  • 3.7
  • 3.8
  • 3.6
  • 3.9_backported
  • 3.8_backported
  • 3.7_backported
  • 3.5
  • 3.6_backported
  • 3.5_backported
  • 3.4
  • 3.3_backported
  • 6.0.4
  • 6.0.3
  • 5.0.7
  • 6.0.2
  • 6.0.1
  • 5.0.6
  • 6.0.0
  • 5.0.5
  • 6.0.0-rc
  • 5.0.4
  • 6.0.0-beta
  • 5.0.3
  • 4.0.6
  • 5.0.2
  • 5.0.1
  • 4.0.5
  • 5.0.0
  • 4.0.4
  • 5.0.0-rc2
  • 5.0.0-rc1
41 results

3.1.0-3.2.0.sql

  • 3.1.0-3.2.0.sql 836 B
    --
    -- Be carefull to requests order.
    -- This file must be loaded by calling /install/index.php page
    -- when current version is 2.8.0 or higher. 
    --
    -- To rename a table:       ALTER TABLE llx_table RENAME TO llx_table_new;
    -- 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);
    --
    
    UPDATE llx_c_paper_format SET active=1 WHERE active=0;
    
    ALTER TABLE llx_product_fournisseur_price ADD COLUMN fk_availability integer AFTER fk_product_fournisseur;
    
    ALTER TABLE llx_element_element MODIFY COLUMN sourcetype varchar(32) NOT NULL;
    ALTER TABLE llx_element_element MODIFY COLUMN targettype varchar(32) NOT NULL;