-
Notifications
You must be signed in to change notification settings - Fork 0
/
4.4-5.0-PostgreSQLUpdate
35 lines (26 loc) · 1.16 KB
/
4.4-5.0-PostgreSQLUpdate
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
SEAHUB_DB
CREATE TABLE IF NOT EXISTS `constance_config` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`key` varchar(255) NOT NULL,
`value` longtext NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key` (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS constance_config (
id BIGSERIAL PRIMARY KEY,
key varchar(255) NOT NULL,
value TEXT NOT NULL )
;
CREATE UNIQUE INDEX key ON constance_config (key);
ALTER TABLE `profile_profile` ADD `login_id` varchar(225) DEFAULT NULL;
ALTER TABLE `profile_profile` ADD `contact_email` varchar(225) DEFAULT NULL;
ALTER TABLE `profile_profile` ADD `institution` varchar(225) DEFAULT NULL;
ALTER TABLE profile_profile ADD login_id varchar(225) DEFAULT NULL;
ALTER TABLE profile_profile ADD contact_email varchar(225) DEFAULT NULL;
ALTER TABLE profile_profile ADD institution varchar(225) DEFAULT NULL;
ALTER TABLE `profile_profile` ADD UNIQUE INDEX (`login_id`);
ALTER TABLE `profile_profile` ADD INDEX (`contact_email`);
ALTER TABLE `profile_profile` ADD INDEX (`institution`);
CREATE UNIQUE INDEX ON profile_profile (login_id);
CREATE INDEX ON profile_profile (contact_email);
CREATE INDEX ON profile_profile (institution);