Also die Datei sieht so bei mir aus
[quote]# ViMP 2.0.6
ALTER TABLE user_facebook CHANGE fbuid fbuid VARCHAR( 255 ) NOT NULL;
ViMP 2.0.5
ALTER TABLE config DROP INDEX c_i_option;
ALTER TABLE user_friend DROP INDEX uf_i_fid;
ALTER TABLE user_invite DROP INDEX ui_i_fid;
ALTER TABLE forum_thread DROP INDEX ft_i_threadid;
ALTER TABLE activity DROP INDEX a_i_aid;
ALTER TABLE stopword DROP INDEX sw_i_sid;
ViMP 2.0
CREATE TABLE catalogue
(
cat_id INTEGER(11) NOT NULL AUTO_INCREMENT,
name VARCHAR(100),
source_lang VARCHAR(100),
target_lang VARCHAR(100),
date_created DATETIME,
date_modified DATETIME,
author VARCHAR(255),
PRIMARY KEY (cat_id)
)Type=InnoDB;
CREATE TABLE trans_unit
(
msg_id INTEGER(11) NOT NULL AUTO_INCREMENT,
cat_id INTEGER(11) NOT NULL,
id VARCHAR(255),
source TEXT,
target TEXT,
comments TEXT,
date_added DATETIME,
date_modified DATETIME,
author VARCHAR(255),
translated INTEGER(1) default 0 NOT NULL,
PRIMARY KEY (msg_id),
INDEX FI_fk_cat_id (cat_id),
CONSTRAINT tu_fk_cat_id
FOREIGN KEY (cat_id)
REFERENCES catalogue (cat_id)
)Type=InnoDB;
INSERT INTO catalogue (name, source_lang, target_lang, date_created, date_modified, author) VALUES
(‘messages.de’, ‘de’, ‘de’, NOW(), NOW(), ‘FRAMEWORK’),
(‘messages.en’, ‘de’, ‘en’, NOW(), NOW(), ‘FRAMEWORK’);
ALTER TABLE media ADD INDEX m_i_status (status);
ALTER TABLE media ADD INDEX m_i_status_created (status, created_at);
ALTER TABLE user ADD INDEX u_i_created_at (created_at);
ALTER TABLE user ADD INDEX u_i_status (status);
ALTER TABLE user ADD INDEX u_i_status_created (status, created_at);
ALTER TABLE channel ADD INDEX ch_i_created_at (created_at);
ALTER TABLE channel ADD INDEX ch_i_status (status);
ALTER TABLE channel ADD INDEX ch_i_status_created (status, created_at);
ALTER TABLE user_invite
DROP FOREIGN KEY ui_fk_fid,
DROP FOREIGN KEY ui_fk_message_sid,
DROP INDEX FI_fk_message_sid,
DROP INDEX ui_i_fid;
ALTER TABLE user_invite
MODIFY fid INTEGER(11) NOT NULL AUTO_INCREMENT,
ADD friend_uid INTEGER(11) NOT NULL AFTER fid,
CHANGE invite_name name VARCHAR(40) NOT NULL,
CHANGE invite_email email VARCHAR(255) NOT NULL,
CHANGE invite_message_sid message_sid INTEGER(11) NOT NULL,
CHANGE invite_validation_code validation_code VARCHAR(40) NOT NULL,
CHANGE invite_status status INTEGER(11) NOT NULL,
ADD CONSTRAINT ui_fk_friend_uid FOREIGN KEY (friend_uid) REFERENCES user (uid),
ADD CONSTRAINT ui_fk_message_sid FOREIGN KEY (message_sid) REFERENCES statictext (sid);
[/quote]
Das war diese Datei data/sql/updates.sql
communitybook.bplaced.net/data/sql/updates.sql
Bitte helf mir!