ext_tables.sql 633 B

123456789101112131415161718192021222324
  1. # ext_tables.sql contient les directives permettant d ajouter des tables et champs à la DB
  2. #
  3. # Table structure for table 'pages'
  4. # Possible values for ot_page_type are : ROOT, MANDATORY_EDITABLE, MANDATORY_NON_EDITABLE, NON_MANDATORY, USER_CREATED
  5. #
  6. CREATE TABLE pages (
  7. manually_deleted smallint(5) unsigned NOT NULL DEFAULT 0,
  8. ot_page_type text DEFAULT 'USER_CREATED'
  9. );
  10. #
  11. # Table structure for table 'tt_content'
  12. #
  13. CREATE TABLE tt_content (
  14. manually_deleted smallint(5) unsigned NOT NULL DEFAULT 0
  15. );
  16. #
  17. # Table structure for table 'sys_filemounts'
  18. #
  19. CREATE TABLE sys_filemounts (
  20. organization_id int unsigned
  21. );