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

[gmazza]

Author: gmazza
Date: Sat Sep  6 05:40:44 2014
New Revision: 1622829

URL: http://svn.apache.org/r1622829
Log:
drop unused usercookie 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=1622829&r1=1622828&r2=1622829&view=diff
==============================================================================
--- roller/trunk/app/src/main/resources/sql/createdb.vm (original)
+++ roller/trunk/app/src/main/resources/sql/createdb.vm Sat Sep  6 05:40:44 2014
@@ -60,15 +60,6 @@ create table roller_audit_log (
     change_time     $db.TIMESTAMP_SQL_TYPE              
 );
 
-create table usercookie (
-    id              varchar(48) not null primary key,
-    username        varchar(255) not null,
-    cookieid        varchar(100) not null,
-    datecreated     $db.TIMESTAMP_SQL_TYPE not null
-);
-create index uc_username_idx on usercookie( username$!db.INDEXSIZE );
-create index uc_cookieid_idx on usercookie( cookieid$!db.INDEXSIZE );
-
 create table weblog (
     id                varchar(48) not null primary key,
     name              varchar(255) 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=1622829&r1=1622828&r2=1622829&view=diff
==============================================================================
--- roller/trunk/app/src/main/resources/sql/droptables.sql (original)
+++ roller/trunk/app/src/main/resources/sql/droptables.sql Sat Sep  6 05:40:44 
2014
@@ -24,7 +24,6 @@ drop table rag_properties;
 
 -- non-associated tables
 drop table newsfeed;
-drop table usercookie;
 drop table roller_properties;
 drop table roller_audit_log;
 drop table roller_tasklock;