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         db_mountpoints text,
  20         file_mountpoints text,
  21         publish_time int(11) DEFAULT '0' NOT NULL,
  22         freeze tinyint(3) DEFAULT '0' NOT NULL,
  23         live_edit tinyint(3) DEFAULT '0' NOT NULL,
  24         swap_modes tinyint(3) DEFAULT '0' NOT NULL,
  25         publish_access tinyint(3) DEFAULT '0' NOT NULL,
  26         custom_stages int(11) DEFAULT '0' NOT NULL,
  27         stagechg_notification tinyint(3) DEFAULT '0' NOT NULL,
  28         edit_notification_defaults varchar(255) DEFAULT '' NOT NULL,
  29         edit_notification_preselection tinyint(3) DEFAULT '3' NOT NULL,
  30         edit_allow_notificaton_settings tinyint(3) DEFAULT '0' NOT NULL,
  31         publish_notification_defaults varchar(255) DEFAULT '' NOT NULL,
  32         publish_notification_preselection tinyint(3) DEFAULT '3' NOT NULL,
  33         publish_allow_notificaton_settings tinyint(3) DEFAULT '0' NOT NULL,
  34         execute_notification_defaults varchar(255) DEFAULT '' NOT NULL,
  35         execute_notification_preselection tinyint(3) DEFAULT '3' NOT NULL,
  36         execute_allow_notificaton_settings tinyint(3) DEFAULT '0' NOT NULL
  37 );
  38
  39
  40 #
  41 # Table structure for table 'sys_workspace_stage'
  42 #
  43 CREATE TABLE sys_workspace_stage (
  44         title varchar(30) DEFAULT '' NOT NULL,
  45         responsible_persons varchar(255) DEFAULT '' NOT NULL,
  46         default_mailcomment text,
  47         parentid int(11) DEFAULT '0' NOT NULL,
  48         parenttable varchar(255) DEFAULT '' NOT NULL,
  49         notification_defaults varchar(255) DEFAULT '' NOT NULL,
  50         allow_notificaton_settings tinyint(3) DEFAULT '0' NOT NULL,
  51         notification_preselection tinyint(3) DEFAULT '8' NOT NULL
  52 );