typo3/sysext/workspaces/ext_tables.sql

   1 #
   2 # Table structure for table 'sys_preview'
   3 #
   4 CREATE TABLE sys_preview (
   5   keyword varchar(32) DEFAULT '' NOT NULL,
   6   tstamp int(11) DEFAULT '0' NOT NULL,
   7   endtime int(11) DEFAULT '0' NOT NULL,
   8   config text,
   9   PRIMARY KEY (keyword)
  10 );
  11
  12 #
  13 # Table structure for table 'sys_workspace'
  14 #
  15 CREATE TABLE sys_workspace (
  16         title varchar(30) DEFAULT '' NOT NULL,
  17         adminusers varchar(4000) DEFAULT '' NOT NULL,
  18         members varchar(4000) DEFAULT '' NOT NULL,
  19         reviewers varchar(4000) DEFAULT '' NOT NULL,
  20         db_mountpoints varchar(255) DEFAULT '' NOT NULL,
  21         file_mountpoints varchar(255) DEFAULT '' NOT NULL,
  22         publish_time int(11) DEFAULT '0' NOT NULL,
  23         unpublish_time int(11) DEFAULT '0' NOT NULL,
  24         freeze tinyint(3) DEFAULT '0' NOT NULL,
  25         live_edit tinyint(3) DEFAULT '0' NOT NULL,
  26         vtypes tinyint(3) DEFAULT '0' NOT NULL,
  27         swap_modes tinyint(3) DEFAULT '0' NOT NULL,
  28         publish_access tinyint(3) DEFAULT '0' NOT NULL,
  29         custom_stages int(11) DEFAULT '0' NOT NULL,
  30         stagechg_notification tinyint(3) DEFAULT '0' NOT NULL,
  31         edit_notification_defaults varchar(255) DEFAULT '' NOT NULL,
  32         edit_notification_preselection tinyint(3) DEFAULT '3' NOT NULL,
  33         edit_allow_notificaton_settings tinyint(3) DEFAULT '0' NOT NULL,
  34         publish_notification_defaults varchar(255) DEFAULT '' NOT NULL,
  35         publish_notification_preselection tinyint(3) DEFAULT '3' NOT NULL,
  36         publish_allow_notificaton_settings tinyint(3) DEFAULT '0' NOT NULL,
  37         execute_notification_defaults varchar(255) DEFAULT '' NOT NULL,
  38         execute_notification_preselection tinyint(3) DEFAULT '3' NOT NULL,
  39         execute_allow_notificaton_settings tinyint(3) DEFAULT '0' NOT NULL
  40 );
  41
  42
  43 #
  44 # Table structure for table 'sys_workspace_stage'
  45 #
  46 CREATE TABLE sys_workspace_stage (
  47         title varchar(30) DEFAULT '' NOT NULL,
  48         responsible_persons varchar(255) DEFAULT '' NOT NULL,
  49         default_mailcomment text,
  50         parentid int(11) DEFAULT '0' NOT NULL,
  51         parenttable tinytext NOT NULL,
  52         notification_defaults varchar(255) DEFAULT '' NOT NULL,
  53         allow_notificaton_settings tinyint(3) DEFAULT '0' NOT NULL,
  54         notification_preselection tinyint(3) DEFAULT '8' NOT NULL
  55 );