[geeklog-cvs] Geeklog-2.x/plugins/content/sql/MySQL create.sql, 1.1, 1.2
Damien Hodgkin
dhodgkin at qs1489.pair.com
Wed Sep 12 14:21:52 EDT 2007
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
More information about the geeklog-cvs
mailing list