svn commit: r1571897 - in /roller/trunk/app/src/main/resources/sql: createdb.vm droptables.sql

[gmazza]

Author: gmazza
Date: Wed Feb 26 01:41:04 2014
New Revision: 1571897

URL: http://svn.apache.org/r1571897
Log:
Drop unused folderassoc table.

Modified:
    roller/trunk/app/src/main/resources/sql/createdb.vm
    roller/trunk/app/src/main/resources/sql/droptables.sql

Modified: roller/trunk/app/src/main/resources/sql/createdb.vm
URL: 
http://svn.apache.org/viewvc/roller/trunk/app/src/main/resources/sql/createdb.vm?rev=1571897&r1=1571896&r2=1571897&view=diff
==============================================================================
--- roller/trunk/app/src/main/resources/sql/createdb.vm (original)
+++ roller/trunk/app/src/main/resources/sql/createdb.vm Wed Feb 26 01:41:04 2014
@@ -171,16 +171,6 @@ create index fo_websiteid_idx on folder(
 create index fo_parentid_idx on folder( parentid );
 create index fo_path_idx on folder( path );
 
-create table folderassoc (
-    id               varchar(48) not null primary key,
-    folderid         varchar(48) not null,
-    ancestorid       varchar(40),
-    relation         varchar(20) not null
-);
-create index fa_folderid_idx on folderassoc( folderid );
-create index fa_ancestorid_idx on folderassoc( ancestorid );
-create index fa_relation_idx on folderassoc( relation );
-
 create table bookmark (
     id               varchar(48) not null primary key,
     folderid         varchar(48) not null,

Modified: roller/trunk/app/src/main/resources/sql/droptables.sql
URL: 
http://svn.apache.org/viewvc/roller/trunk/app/src/main/resources/sql/droptables.sql?rev=1571897&r1=1571896&r2=1571897&view=diff
==============================================================================
--- roller/trunk/app/src/main/resources/sql/droptables.sql (original)
+++ roller/trunk/app/src/main/resources/sql/droptables.sql Wed Feb 26 01:41:04 
2014
@@ -37,7 +37,6 @@ drop table pingtarget;
 drop table referer;
 drop table bookmark;
 drop table folder;
-drop table folderassoc;
 drop table roller_userattribute;
 drop table roller_mediafiletag;
 drop table roller_mediafile;
@@ -51,7 +50,6 @@ drop table roller_weblogentrytag;
 drop table roller_weblogentrytagagg;
 drop table entryattribute;
 drop table weblogentry;
-drop table weblogcategoryassoc;
 drop table weblogcategory;
 drop table webpage;
 drop table rol_weblogtheme;