Bug #16255 ยป tables.sql.diff
| tables.sql.mediumtext 2006-12-11 10:47:41.000000000 +0100 | ||
|---|---|---|
|
ses_hashlock int(11) DEFAULT '0' NOT NULL,
|
||
|
ses_userid int(11) unsigned DEFAULT '0' NOT NULL,
|
||
|
ses_tstamp int(11) unsigned DEFAULT '0' NOT NULL,
|
||
|
ses_data mediumblob NOT NULL,
|
||
|
ses_data mediumtext NOT NULL,
|
||
|
ses_backuserid int(11) NOT NULL default '0',
|
||
|
PRIMARY KEY (ses_id,ses_name)
|
||
|
);
|
||
| ... | ... | |
|
#
|
||
|
CREATE TABLE cache_hash (
|
||
|
hash varchar(32) DEFAULT '' NOT NULL,
|
||
|
content mediumblob NOT NULL,
|
||
|
content mediumtext NOT NULL,
|
||
|
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
|
||
|
ident varchar(20) DEFAULT '' NOT NULL,
|
||
|
PRIMARY KEY (hash)
|
||
| ... | ... | |
|
CREATE TABLE sys_history (
|
||
|
uid int(11) unsigned NOT NULL auto_increment,
|
||
|
sys_log_uid int(11) DEFAULT '0' NOT NULL,
|
||
|
history_data mediumblob NOT NULL,
|
||
|
history_data mediumtext NOT NULL,
|
||
|
fieldlist blob NOT NULL,
|
||
|
recuid int(11) DEFAULT '0' NOT NULL,
|
||
|
tablename varchar(40) DEFAULT '' NOT NULL,
|
||
|
tstamp int(11) DEFAULT '0' NOT NULL,
|
||
|
history_files mediumblob NOT NULL,
|
||
|
history_files mediumtext NOT NULL,
|
||
|
snapshot tinyint(4) DEFAULT '0' NOT NULL,
|
||
|
PRIMARY KEY (uid),
|
||
|
KEY recordident (tablename,recuid),
|
||