roller/metadata/database createdb-raw.sql,1.9,1.10 098-to-099-migration-raw.sql,1.4,1.5

Update of /cvsroot/roller/roller/metadata/database
In directory sc8-pr-cvs1:/tmp/cvs-serv30595/metadata/database

Modified Files:
        createdb-raw.sql 098-to-099-migration-raw.sql 
Log Message:
Beginnings of hierarchical categories

Index: createdb-raw.sql
===================================================================
RCS file: /cvsroot/roller/roller/metadata/database/createdb-raw.sql,v
retrieving revision 1.9
retrieving revision 1.10
diff -C2 -d -r1.9 -r1.10
*** createdb-raw.sql    18 Nov 2003 04:20:58 -0000      1.9
--- createdb-raw.sql    12 Dec 2003 02:57:24 -0000      1.10
***************
*** 83,90 ****
  
  create table weblogcategory (
!     id               varchar(48) not null primary key,
      name             varchar(255) not null,
      description      varchar(255) null,
!     websiteid        varchar(48) not null,
      image            varchar(255) null
  );
--- 83,91 ----
  
  create table weblogcategory (
!     id               varchar(48)  not null primary key,
      name             varchar(255) not null,
      description      varchar(255) null,
!     parentid         varchar(48)  null,
!     websiteid        varchar(48)  not null,
      image            varchar(255) null
  );

Index: 098-to-099-migration-raw.sql
===================================================================
RCS file: 
/cvsroot/roller/roller/metadata/database/098-to-099-migration-raw.sql,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** 098-to-099-migration-raw.sql        7 Dec 2003 16:38:08 -0000       1.4
--- 098-to-099-migration-raw.sql        12 Dec 2003 02:57:24 -0000      1.5
***************
*** 7,8 ****
--- 7,12 ----
  -- ensure that folder names unique within a folder
  alter table folder add unique folder_namefolderid_uq (parentid, name(20));
+ 
+ -- weblog categories are now hierarchical
+ alter table weblogcategory add column (parentid varchar(48) null);
+ 




-------------------------------------------------------
This SF.net email is sponsored by: IBM Linux Tutorials.
Become an expert in LINUX or just sharpen your skills.  Sign up for IBM's
Free Linux Tutorials.  Learn everything from the bash shell to sys admin.
Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click