llx_hrm_skilldet-hrm.sql 1.1 KB

1234567891011121314151617181920212223242526
  1. -- Copyright (C) 2021 Gauthier VERDOL <gauthier.verdol@atm-consulting.fr>
  2. -- Copyright (C) 2021 Greg Rastklan <greg.rastklan@atm-consulting.fr>
  3. -- Copyright (C) 2021 Jean-Pascal BOUDET <jean-pascal.boudet@atm-consulting.fr>
  4. --
  5. -- This program is free software: you can redistribute it and/or modify
  6. -- it under the terms of the GNU General Public License as published by
  7. -- the Free Software Foundation, either version 3 of the License, or
  8. -- (at your option) any later version.
  9. --
  10. -- This program is distributed in the hope that it will be useful,
  11. -- but WITHOUT ANY WARRANTY; without even the implied warranty of
  12. -- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
  13. -- GNU General Public License for more details.
  14. --
  15. -- You should have received a copy of the GNU General Public License
  16. -- along with this program. If not, see https://www.gnu.org/licenses/.
  17. CREATE TABLE llx_hrm_skilldet(
  18. rowid integer AUTO_INCREMENT PRIMARY KEY NOT NULL,
  19. fk_skill integer NOT NULL,
  20. rankorder integer NOT NULL DEFAULT '1',
  21. description text,
  22. fk_user_creat integer NOT NULL,
  23. fk_user_modif integer
  24. ) ENGINE=innodb;