diff options
author | Evan Prodromou <evan@status.net> | 2009-10-19 17:00:36 -0400 |
---|---|---|
committer | Evan Prodromou <evan@status.net> | 2009-10-19 17:00:36 -0400 |
commit | fe1ae3a47edb09e3fd144589f095bfc40637ca2a (patch) | |
tree | 8990cfccb7d8bcaa5635fcdc12513dcda76b55c7 /db/08to09.sql | |
parent | 9d0e37c4e847f312c39eaf15deb95ff3777c13a6 (diff) | |
parent | f049d669d95128741f9cb7b1604b758df0550360 (diff) |
Merge branch 'testing' of git@gitorious.org:statusnet/mainline into testing
Diffstat (limited to 'db/08to09.sql')
-rw-r--r-- | db/08to09.sql | 34 |
1 files changed, 34 insertions, 0 deletions
diff --git a/db/08to09.sql b/db/08to09.sql new file mode 100644 index 000000000..953e0e5f4 --- /dev/null +++ b/db/08to09.sql @@ -0,0 +1,34 @@ +alter table notice + modify column content text comment 'update content'; + +alter table message + modify column content text comment 'message content'; + +alter table profile + modify column bio text comment 'descriptive biography'; + +alter table user_group + modify column description text comment 'group description'; + +alter table file_oembed + add column mimetype varchar(50) comment 'mime type of resource'; + +create table config ( + + section varchar(32) comment 'configuration section', + setting varchar(32) comment 'configuration setting', + value varchar(255) comment 'configuration value', + + constraint primary key (section, setting) + +) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin; + +create table user_role ( + + user_id integer not null comment 'user having the role' references user (id), + role varchar(32) not null comment 'string representing the role', + created datetime not null comment 'date the role was granted', + + constraint primary key (user_id, role) + +) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin; |