create.sql

Update of /var/cvs/Geeklog-2.x/Geeklog-2.x/sql/MySQL
In directory iowaoutdoors:/tmp/cvs-serv26057/sql/MySQL

Modified Files:
	create.sql 
Log Message:
Removed category_id.  This is now mapped to the link via the
category plugin 

Index: create.sql
============================================================
=======
RCS file:
/var/cvs/Geeklog-2.x/Geeklog-2.x/sql/MySQL/create.sql,v
retrieving revision 1.19
retrieving revision 1.20
diff -C2 -d -r1.19 -r1.20
*** create.sql	13 Jul 2006 16:08:33 -0000	1.19
--- create.sql	24 Jul 2006 14:11:30 -0000	1.20
***************
*** 79,82 ****
--- 79,83 ----
    last_name varchar(50),
    homepage varchar(255),
+   photo varchar(50),
    PRIMARY KEY(user_id),
    INDEX (user_name),
***************
*** 169,172 ****
--- 170,192 ----
  ) TYPE=INNODB;
  
+ CREATE TABLE gl2_catalog (
+   catalog_id int(10) unsigned NOT NULL auto_increment,
+   name varchar(75) NOT NULL default '',
+   description varchar(255) default NULL,
+   multiple_select tinyint(1) unsigned NOT NULL default 0,
+   required tinyint(1) unsigned NOT NULL default 0,
+   PRIMARY KEY (catalog_id)
+ ) TYPE=INNODB;
+ 
+ 
+ CREATE TABLE gl2_catalog_plugin (
+   plugin_id int unsigned NOT NULL default 0,
+   catalog_id int unsigned NOT NULL default 0,
+   PRIMARY KEY (plugin_id,catalog_id),
+   FOREIGN KEY (plugin_id) REFERENCES gl2_plugin
(plugin_id),
+   FOREIGN KEY (catalog_id) REFERENCES gl2_catalog
(catalog_id)
+ ) TYPE=INNODB;
+ 
+ 
  CREATE TABLE gl2_category (
    category_id int unsigned NOT NULL,
***************
*** 182,186 ****
    FOREIGN KEY(category_id) REFERENCES gl2_item(item_id),
    INDEX (catalog_id),
!   FOREIGN KEY (catalog_id) REFERENCES gl2_list_item (
list_item_id),
    INDEX (parent_id),
    FOREIGN KEY (parent_id) REFERENCES gl2_category
(category_id),
--- 202,206 ----
    FOREIGN KEY(category_id) REFERENCES gl2_item(item_id),
    INDEX (catalog_id),
!   FOREIGN KEY (catalog_id) REFERENCES gl2_catalog
(catalog_id),
    INDEX (parent_id),
    FOREIGN KEY (parent_id) REFERENCES gl2_category
(category_id),
***************
*** 188,192 ****
  ) TYPE=INNODB;
  
! CREATE TABLE gl2_item_category (
    item_id int unsigned NOT NULL,
    category_id int unsigned NOT NULL,
--- 208,212 ----
  ) TYPE=INNODB;
  
! CREATE TABLE gl2_category_item (
    item_id int unsigned NOT NULL,
    category_id int unsigned NOT NULL,
***************
*** 240,244 ****
  CREATE TABLE gl2_link (
    link_id int unsigned NOT NULL,
-   category_id int unsigned NOT NULL,
    url varchar(150) NOT NULL,
    description varchar(255) NOT NULL,
--- 260,263 ----
***************
*** 247,253 ****
    last_validated datetime,
    PRIMARY KEY (link_id),
!   FOREIGN KEY (link_id) REFERENCES gl2_item(item_id),
!   FOREIGN KEY (category_id) REFERENCES
gl2_category(category_id)
! ) TYPE=INNODB;
    
  CREATE TABLE gl2_block (
--- 266,271 ----
    last_validated datetime,
    PRIMARY KEY (link_id),
!   FOREIGN KEY (link_id) REFERENCES gl2_item(item_id)
!   TYPE=INNODB;
    
  CREATE TABLE gl2_block (
***************
*** 427,432 ****
  */
  
! INSERT INTO gl2_user VALUES (1,'2005-06-03
00:00:00','2005-06-03
00:00:00','default',0,20,25,4,'root','password',1,'r
ootexample.com',21,23,0,96000,18,1,'Got root?','Root
user bio goes here','Root First Name','Root Last
Name','http://www.geeklog.net');
! INSERT INTO gl2_user VALUES (2,'2005-06-03
00:00:00','2005-06-03
00:00:00','default',0,20,25,4,'anonymous',';lkja;dlfjo
',1,'anonymousgeeklog.net',21,23,0,96000,18,1,'Too
good to register','Anonymous user bio goes here','Anon
First Name','Anon Last Name','http://www.geeklog.net');
  
  INSERT INTO gl2_group_assignment VALUES (1,1,NULL);
--- 445,450 ----
  */
  
! INSERT INTO gl2_user VALUES (1,'2005-06-03
00:00:00','2005-06-03
00:00:00','default',0,20,25,4,'root','password',1,'r
ootexample.com',21,23,0,96000,18,1,'Got root?','Root
user bio goes here','Root First Name','Root Last
Name','http://www.geeklog.net',
null);
! INSERT INTO gl2_user VALUES (2,'2005-06-03
00:00:00','2005-06-03
00:00:00','default',0,20,25,4,'anonymous',';lkja;dlfjo
',1,'anonymousgeeklog.net',21,23,0,96000,18,1,'Too
good to register','Anonymous user bio goes here','Anon
First Name','Anon Last Name','http://www.geeklog.net',
null);
  
  INSERT INTO gl2_group_assignment VALUES (1,1,NULL);

_______________________________________________
geeklog2-cvs mailing list
geeklog2-cvslists.geeklog.net
http://lists.geeklog.net/mailman/listinfo/geeklog2-cvs