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!