Bug #24632 ยป 17106.patch
t3lib/stddb/tables.sql (working copy) | ||
---|---|---|
);
|
||
#
|
||
# Table structure for table 'sys_workspace'
|
||
#
|
||
CREATE TABLE sys_workspace (
|
||
uid int(11) NOT NULL auto_increment,
|
||
pid int(11) DEFAULT '0' NOT NULL,
|
||
tstamp int(11) DEFAULT '0' NOT NULL,
|
||
deleted tinyint(1) DEFAULT '0' NOT NULL,
|
||
title varchar(30) DEFAULT '' NOT NULL,
|
||
description varchar(255) DEFAULT '' NOT NULL,
|
||
adminusers text,
|
||
members text,
|
||
reviewers text,
|
||
db_mountpoints varchar(255) DEFAULT '' NOT NULL,
|
||
file_mountpoints varchar(255) DEFAULT '' NOT NULL,
|
||
publish_time int(11) DEFAULT '0' NOT NULL,
|
||
unpublish_time int(11) DEFAULT '0' NOT NULL,
|
||
freeze tinyint(3) DEFAULT '0' NOT NULL,
|
||
live_edit tinyint(3) DEFAULT '0' NOT NULL,
|
||
review_stage_edit tinyint(3) DEFAULT '0' NOT NULL,
|
||
vtypes tinyint(3) DEFAULT '0' NOT NULL,
|
||
disable_autocreate tinyint(1) DEFAULT '0' NOT NULL,
|
||
swap_modes tinyint(3) DEFAULT '0' NOT NULL,
|
||
publish_access tinyint(3) DEFAULT '0' NOT NULL,
|
||
stagechg_notification tinyint(3) DEFAULT '0' NOT NULL,
|
||
PRIMARY KEY (uid),
|
||
KEY parent (pid)
|
||
);
|
||
#
|
||
# Table structure for table 'sys_history'
|
||
#
|
||
CREATE TABLE sys_history (
|