modules/g2/g2.mysql

#-------------------------------------------------
# New table for the G2 glossary module
# Currently defined for MySQL 4.1.x
# $Id: g2.mysql,v 1.3.2.1 2006/07/29 19:44:47 fgm Exp $
#-------------------------------------------------

CREATE TABLE `g2_node`
  (
  `nid`        INT( 11 ) DEFAULT '0' NOT NULL ,
  `period`     VARCHAR( 50 ) ,
  `complement` MEDIUMTEXT,
  `origin`     MEDIUMTEXT,
  PRIMARY KEY ( `nid` )
  ) COMMENT = 'Extensions to node for g2 module';

CREATE TABLE `g2_referer` (
  `nid` int(10) unsigned NOT NULL default '0',
  `referer` varchar(128) NOT NULL default '',
  `incoming` int(10) NOT NULL default '0',
  PRIMARY KEY  (`nid`,`referer`),
  KEY `referer` (`referer`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='G2 referer stats for link exchange';

1	#-------------------------------------------------
2	# New table for the G2 glossary module
3	# Currently defined for MySQL 4.1.x
4	# $Id: g2.mysql,v 1.3.2.1 2006/07/29 19:44:47 fgm Exp $
5	#-------------------------------------------------
6
7	CREATE TABLE `g2_node`
8	(
9	`nid` INT( 11 ) DEFAULT '0' NOT NULL ,
10	`period` VARCHAR( 50 ) ,
11	`complement` MEDIUMTEXT,
12	`origin` MEDIUMTEXT,
13	PRIMARY KEY ( `nid` )
14	) COMMENT = 'Extensions to node for g2 module';
15
16	CREATE TABLE `g2_referer` (
17	`nid` int(10) unsigned NOT NULL default '0',
18	`referer` varchar(128) NOT NULL default '',
19	`incoming` int(10) NOT NULL default '0',
20	PRIMARY KEY (`nid`,`referer`),
21	KEY `referer` (`referer`)
22	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='G2 referer stats for link exchange';
23