[geeklog-cvs] Geeklog-2.x/plugins/content/sql/MySQL create.sql, 1.1, 1.2

[Damien Hodgkin]

Update of /cvsroot/geeklog2/Geeklog-2.x/plugins/content/sql/MySQL
In directory qs1489.pair.com:/tmp/cvs-serv99130/plugins/content/sql/MySQL

Modified Files:
	create.sql 
Log Message:
changed the layout

Index: create.sql
===================================================================
RCS file: /cvsroot/geeklog2/Geeklog-2.x/plugins/content/sql/MySQL/create.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** create.sql	8 Aug 2007 20:23:45 -0000	1.1
--- create.sql	12 Sep 2007 18:21:49 -0000	1.2
***************
*** 1,11 ****
  CREATE TABLE gl2_content (
!   a_id int(10) unsigned NOT NULL auto_increment,
!   a_author varchar(150) NOT NULL,
!   a_title varchar(255) NOT NULL,
!   a_description text,
!   a_body text,
!   a_url varchar(255) NOT NULL,
!   a_num_clicks int(11) NOT NULL default '0',
!   PRIMARY KEY (a_id),
!   FOREIGN KEY (a_id) REFERENCES gl2_item(item_id)
! ) TYPE=INNODB1;
\ No newline at end of file
--- 1,19 ----
+ DROP TABLE IF EXISTS gl2_content;
  CREATE TABLE gl2_content (
!   item_id int unsigned NOT NULL,  
!   content_id int unsigned NOT NULL auto_increment,
!   content_author varchar(150) NOT NULL,
!   content_title varchar(255) NOT NULL,
!   description text,
!   content_body text,
!   content_url varchar(255) NOT NULL,
!   content_type int unsigned NOT NULL,
!   num_clicks int NOT NULL default '0',
!   PRIMARY KEY (content_id),
!   INDEX (item_id),
!   FOREIGN KEY (item_id) REFERENCES gl2_item(item_id) ON UPDATE CASCADE ON DELETE CASCADE,
!   INDEX (content_author),
!   INDEX (content_title),
!   INDEX (content_type),  
!   FOREIGN KEY (content_type) REFERENCES gl2_list_item(list_item_id) 
! ) TYPE=INNODB;
\ No newline at end of file