Project

General

Profile

Download (5.09 KB)

Bug #15401 » ext_tables.sql.patch

Administrator Admin, 2006-01-13 02:36

View differences:

ext_tables.sql Thu Oct 11 16:16:26 2007
deleted tinyint(3) DEFAULT '0' NOT NULL,
hidden tinyint(3) DEFAULT '0' NOT NULL,
title varchar(255) DEFAULT '' NOT NULL,
KEY lang (sys_language_uid),
KEY parlang (l18n_parent),
KEY lang (sys_language_uid,l18n_parent),
KEY parent (pid),
PRIMARY KEY (uid)
PRIMARY KEY (uid)
);
#
......
attributesedit mediumtext NOT NULL,
uname varchar(80) DEFAULT '' NOT NULL,
relatedpage int(11) DEFAULT '0' NOT NULL,
KEY lang (sys_language_uid),
KEY langpar (l18n_parent),
KEY lang (sys_language_uid,l18n_parent),
PRIMARY KEY (uid),
KEY parent (pid)
);
#
# Table structure for table 'tx_commerce_articles_article_attributes_mm'
......
PRIMARY KEY (uid),
KEY parent (pid),
KEY lang (sys_language_uid),
KEY langpar (l18n_parent),
KEY lang (sys_language_uid,l18n_parent),
KEY uproduct (uid_product)
);
......
starttime int(11) DEFAULT '0' NOT NULL,
endtime int(11) DEFAULT '0' NOT NULL,
fe_group int(11) DEFAULT '0' NOT NULL,
uid_article int(11) DEFAULT '0' NOT NULL,
price_net int(11) DEFAULT '0',
price_gross int(11) DEFAULT '0',
......
price_scale_amount_end int(11) DEFAULT '1',
PRIMARY KEY (uid),
KEY parent (pid),
KEY lang (sys_language_uid),
KEY langpar (l18n_parent),
KEY lang (sys_language_uid,l18n_parent),
KEY uarticle (uid_article)
);
......
unit varchar(80) DEFAULT '' NOT NULL,
valueformat varchar(80) DEFAULT '' NOT NULL,
valuelist varchar(255) DEFAULT '' NOT NULL
icon blob NOT NULL,
icon blob NOT NULL,
PRIMARY KEY (uid),
KEY lang (sys_language_uid),
KEY langpar (l18n_parent),
KEY lang (sys_language_uid,l18n_parent),
KEY parent (pid)
);
......
endtime int(11) DEFAULT '0' NOT NULL,
value varchar(255) DEFAULT '' NOT NULL,
attributes_uid blob NOT NULL,
icon blob NOT NULL,
icon blob NOT NULL,
showvalue tinyint(4) DEFAULT '0' NOT NULL,
KEY lang (sys_language_uid),
KEY langpar (l18n_parent),
KEY lang (sys_language_uid,l18n_parent),
PRIMARY KEY (uid),
KEY parent (pid)
);
......
ts_config text NOT NULL,
PRIMARY KEY (uid),
KEY lang (sys_language_uid),
KEY langpar (l18n_parent),
KEY lang (sys_language_uid,l18n_parent),
KEY parent (pid)
);
......
description text NOT NULL,
PRIMARY KEY (uid),
KEY lang (sys_language_uid),
KEY langpar (l18n_parent),
KEY lang (sys_language_uid,l18n_parent),
KEY parent (pid)
);
......
title varchar(80) DEFAULT '' NOT NULL,
PRIMARY KEY (uid),
KEY lang (sys_language_uid),
KEY langpar (l18n_parent),
KEY lang (sys_language_uid,l18n_parent),
KEY parent (pid)
);
......
order_sys_language_uid int(11) DEFAULT '0' NOT NULL,
pricefromnet tinyint(4) DEFAULT '0' NOT NULL,
comment text,
PRIMARY KEY (uid),
KEY parent (pid),
KEY orderid (order_id)
......
price_gross int(10) DEFAULT '0' NOT NULL,
tax double(4,2) DEFAULT '0.00' NOT NULL,
amount int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid),
KEY orderid (order_id)
......
title varchar(80) DEFAULT '' NOT NULL,
PRIMARY KEY (uid),
KEY lang (sys_language_uid),
KEY langpar (l18n_parent),
KEY lang (sys_language_uid,l18n_parent),
KEY parent (pid)
);
......
senderemail varchar(255) DEFAULT '' NOT NULL,
otherreceiver varchar(255) DEFAULT '' NOT NULL,
BCC varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (uid),
KEY lang (sys_language_uid),
KEY langpar (l18n_parent),
KEY lang (sys_language_uid,l18n_parent),
KEY parent (pid)
);
......
pricenet int(11) DEFAULT '0' NOT NULL,
amount int(11) DEFAULT '0' NOT NULL,
orders int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
......
dow int(11) DEFAULT '0' NOT NULL,
hour int(11) DEFAULT '0' NOT NULL,
registration int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
......
pricenet int(11) DEFAULT '0' NOT NULL,
amount int(11) DEFAULT '0' NOT NULL,
orders int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
......
dow int(11) DEFAULT '0' NOT NULL,
hour int(11) DEFAULT '0' NOT NULL,
registration int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
(3-3/3)