remove obsolete .sql files

[quix0rs-gnu-social.git] / db / 074to080_pg.sql

diff --git a/db/074to080_pg.sql b/db/074to080_pg.sql
deleted file mode 100644 (file)
index 0a7171a..0000000
--- a/db/074to080_pg.sql
+++ /dev/null
@@ -1,108 +0,0 @@
-BEGIN;
-create sequence design_seq;
-create table design (
-    id bigint default nextval('design_seq') /* comment 'design ID'*/,
-    backgroundcolor integer /* comment 'main background color'*/ ,
-    contentcolor integer /*comment 'content area background color'*/ ,
-    sidebarcolor integer /*comment 'sidebar background color'*/ ,
-    textcolor integer /*comment 'text color'*/ ,
-    linkcolor integer /*comment 'link color'*/,
-    backgroundimage varchar(255) /*comment 'background image, if any'*/,
-    disposition int default 1 /*comment 'bit 1 = hide background image, bit 2 = display background image, bit 4 = tile background image'*/,
-    primary key (id)
-);
-alter table "user"
-     add column design_id integer references design(id);
-alter table "user"
-     add column viewdesigns integer default 1;
-
-alter table notice add column
-     conversation integer references notice (id);
-
-create index notice_conversation_idx on notice(conversation);
-
-alter table foreign_user
-     alter column id TYPE bigint;
-     
-alter table foreign_user alter column id set not null;
-
-alter table foreign_link
-     alter column foreign_id TYPE bigint;
-
-alter table user_group
-      add column design_id integer;
-
-/*attachments and URLs stuff */
-create sequence file_seq;
-create table file (
-    id bigint default nextval('file_seq') primary key /* comment 'unique identifier' */,
-    url varchar(255) unique, 
-    mimetype varchar(50), 
-    size integer, 
-    title varchar(255), 
-    date integer, 
-    protected integer,
-    filename text /* comment 'if a local file, name of the file' */,
-    modified timestamp default CURRENT_TIMESTAMP /* comment 'date this record was modified'*/
-);
-
-create sequence file_oembed_seq;
-create table file_oembed (
-    file_id bigint default nextval('file_oembed_seq') primary key /* comment 'unique identifier' */,
-    version varchar(20),
-    type varchar(20),
-    provider varchar(50),
-    provider_url varchar(255),
-    width integer,
-    height integer,
-    html text,
-    title varchar(255),
-    author_name varchar(50), 
-    author_url varchar(255), 
-    url varchar(255) 
-);
-
-create sequence file_redirection_seq;
-create table file_redirection (
-    url varchar(255) primary key, 
-    file_id bigint, 
-    redirections integer, 
-    httpcode integer
-);
-
-create sequence file_thumbnail_seq;
-create table file_thumbnail (
-    file_id bigint primary key, 
-    url varchar(255) unique, 
-    width integer, 
-    height integer 
-);
-create sequence file_to_post_seq;
-create table file_to_post (
-    file_id bigint, 
-    post_id bigint, 
-
-    primary key (file_id, post_id)
-);
-
-
-create table group_block (
-   group_id integer not null /* comment 'group profile is blocked from' */ references user_group (id),
-   blocked integer not null /* comment 'profile that is blocked' */references profile (id),
-   blocker integer not null /* comment 'user making the block'*/ references "user" (id),
-   modified timestamp /* comment 'date of blocking'*/ ,
-
-   primary key (group_id, blocked)
-);
-
-create table group_alias (
-
-   alias varchar(64) /* comment 'additional nickname for the group'*/ ,
-   group_id integer not null /* comment 'group profile is blocked from'*/ references user_group (id),
-   modified timestamp /* comment 'date alias was created'*/,
-   primary key (alias)
-
-);
-create index group_alias_group_id_idx on group_alias (group_id);
-
-COMMIT;
\ No newline at end of file