summaryrefslogtreecommitdiff
path: root/db
diff options
context:
space:
mode:
authorEvan Prodromou <evan@controlyourself.ca>2009-05-22 20:53:34 -0400
committerEvan Prodromou <evan@controlyourself.ca>2009-05-22 20:53:34 -0400
commit356022f45ccb92a157de30a5db8a9b94f9d7ceb5 (patch)
treef934bf7fb6fe593d8440f75496ba41d6128dc005 /db
parent3a44885b7ffcdcbb1b5cc8e972a3f89dd02b4c74 (diff)
parent9a7dbbc78118feb5266e78244258a2fbbcc2f405 (diff)
Merge branch '0.8.x' into userdesign
Diffstat (limited to 'db')
-rw-r--r--db/laconica.sql48
1 files changed, 23 insertions, 25 deletions
diff --git a/db/laconica.sql b/db/laconica.sql
index 344f0ff72..0b20bc172 100644
--- a/db/laconica.sql
+++ b/db/laconica.sql
@@ -426,12 +426,12 @@ create table group_inbox (
) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin;
create table file (
- id integer primary key auto_increment,
- url varchar(255), mimetype varchar(50),
- size integer,
- title varchar(255),
- date integer(11),
- protected integer(1),
+ id integer primary key auto_increment,
+ url varchar(255), mimetype varchar(50),
+ size integer,
+ title varchar(255),
+ date integer(11),
+ protected integer(1),
unique(url)
) ENGINE=MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci;
@@ -447,40 +447,38 @@ create table file_oembed (
height integer,
html text,
title varchar(255),
- author_name varchar(50),
- author_url varchar(255),
- url varchar(255),
+ author_name varchar(50),
+ author_url varchar(255),
+ url varchar(255),
unique(file_id)
) ENGINE=MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci;
create table file_redirection (
- id integer primary key auto_increment,
- url varchar(255),
- file_id integer,
- redirections integer,
- httpcode integer,
+ id integer primary key auto_increment,
+ url varchar(255),
+ file_id integer,
+ redirections integer,
+ httpcode integer,
unique(url)
) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin;
create table file_thumbnail (
- id integer primary key auto_increment,
- file_id integer,
- url varchar(255),
- width integer,
- height integer,
+ id integer primary key auto_increment,
+ file_id integer,
+ url varchar(255),
+ width integer,
+ height integer,
- unique(file_id),
+ unique(file_id),
unique(url)
) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin;
create table file_to_post (
- id integer primary key auto_increment,
- file_id integer,
- post_id integer,
+ id integer primary key auto_increment,
+ file_id integer,
+ post_id integer,
unique(file_id, post_id)
) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin;
-
-