[Á°][¼¡][ÈÖ¹æ½ç°ìÍ÷][¥¹¥ì¥Ã¥É°ìÍ÷]

mysql:12061

From: "safe" <"safe" <geohase@xxxxxxxxxx>>
Date: Sat, 3 Sep 2005 11:34:03 +0900
Subject: [mysql 12061] Re: SQL¥À¥ó¥×¥Ç¡¼¥¿¤Î½èÍý¤Î·ï

Ω¾¾ÍÍ
ºÆ¡¹¤Î¥ì¥¹¤ò¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤¹¡£

Ä̾ï¤Îcreate database,table¤äinsert,load¤Ç¤Î
¥Ç¡¼¥¿¥Ù¡¼¥¹¤ÏºîÀ®½ÐÍè¤Þ¤¹¤Î¤Ç¡¢¥Ñ¥¹¤ÏÄ̤äÆ
¤¤¤Þ¤¹¤·¡¢¥¯¥é¥¤¥¢¥ó¥È¤â¥¤¥ó¥¹¥È¡¼¥ë¤µ¤ì¤Æ¤¤¤ë¤È
»×¤¤¤Þ¤¹¡ÊMySQL4..0.20a-nt¤ÇWinMySQLadmin1.4
¤Ç¸«¤¿¤ê¤·¤Æ¤¤¤Þ¤¹¡Ë¡£

¤´¶µ¼¨Äº¤¤¤¿URL¤Ï»²¹Í¤Ë¤·¤Æ¤ª¤ê¡¢¥Ç¡¼¥¿¥Ù¡¼¥¹
´ÉÍý¤Î¹àÌܤǡ¢dump¤Ï¿§¡¹¤È¤¢¤ë¤Î¤Ç¤¹¤¬¡¢¤½¤ÎµÕ
¤ò¤ä¤ê¤¿¤¤¤È»×¤Ã¤Æ¤ª¤ê¡¢import¤ò»î¤¹¤Î¤Ç¤¹¤¬¾å¼ê¤¯
¤¤¤­¤Þ¤»¤ó¡Êmysqlimport ¥Ç¡¼¥¿¥Ù¡¼¥¹Ì¾¡¡geohase.sql)¡£

geohase.sql¤Î¥Ç¡¼¥¿¤ÏXOOPS¤Î¥Ç¡¼¥¿¤Ç¤¹¤¬¡¢°ìÉô
²¼µ­¤Î¤è¤¦¤Ë¤Ê¤Ã¤Æ¤¤¤Þ¤¹¡¨

"-- 
-- ¥Æ¡¼¥Ö¥ë¤Î¹½Â¤ `xoops_banner`
-- 

DROP TABLE IF EXISTS `xoops_banner`;
CREATE TABLE `xoops_banner` (
  `bid` smallint(5) unsigned NOT NULL auto_increment,
  `cid` tinyint(3) unsigned NOT NULL default '0',
  `imptotal` mediumint(8) unsigned NOT NULL default '0',
  `impmade` mediumint(8) unsigned NOT NULL default '0',
  `clicks` mediumint(8) unsigned NOT NULL default '0',
  `imageurl` varchar(255) NOT NULL default '',
  `clickurl` varchar(255) NOT NULL default '',
  `date` int(10) NOT NULL default '0',
  `htmlbanner` tinyint(1) NOT NULL default '0',
  `htmlcode` text NOT NULL,
  PRIMARY KEY  (`bid`),
  KEY `idxbannercid` (`cid`),
  KEY `idxbannerbidcid` (`bid`,`cid`)
) TYPE=MyISAM AUTO_INCREMENT=4 ;

-- 
-- ¥Æ¡¼¥Ö¥ë¤Î¥À¥ó¥×¥Ç¡¼¥¿ `xoops_banner`
-- 

INSERT INTO `xoops_banner` (`bid`, `cid`, `imptotal`, `impmade`, `clicks`, 
`imageurl`, `clickurl`, `date`, `htmlbanner`, `htmlcode`)
VALUES (1, 1, 0, 1205, 2, 
'http://7.pro.tok2.com/~geohase/xoops/images/banners/xoops_banner.gif', 
'http://jp.xoops.org/', 1008813250, 0, '');
INSERT INTO `xoops_banner` (`bid`, `cid`, `imptotal`, `impmade`, `clicks`, 
`imageurl`, `clickurl`, `date`, `htmlbanner`, `htmlcode`)
VALUES (2, 1, 0, 1219, 2, 
'http://7.pro.tok2.com/~geohase/xoops/images/banners/xoops_banner_2.gif', 
'http://jp.xoops.org/', 1008813250, 0, '');
INSERT INTO `xoops_banner` (`bid`, `cid`, `imptotal`, `impmade`, `clicks`, 
`imageurl`, `clickurl`, `date`, `htmlbanner`, `htmlcode`)
VALUES (3, 1, 0, 1234, 0, 
'http://7.pro.tok2.com/~geohase/xoops/images/banners/banner.swf', 
'http://jp.xoops.org/', 1008813250, 0, '');
"
°ì¤Ä°ì¤Ä¤ò¥³¥Þ¥ó¥É¤«¤éÆþÎϤ·¤Æ¥×¥í¥Ð¥¤¥À¤Ë¤¢¤ë¥Ç¡¼¥¿¥Ù¡¼¥¹¤ÈƱ¤¸¤â¤Î¤ò
¥í¡¼¥«¥ë¤Ç¹½ÃÛ¤¹¤ë¤³¤È¤Ï²Äǽ¤È¹Í¤¨¤Æ¤¤¤Þ¤¹¤¬¡¢¥µ¥¤¥È¤Î¥Ð¥Ã¥¯¥¢¥Ã¥×¤Ç
Ʊ¤¸ºî¶È¤¬ÉÑÈˤËÀ¸¤¸¤ë¤È»×¤ï¤ì¤ëÅÀ¤È¡¢¼ÂºÝ¤Ë»ÈÍѤò»Ï¤á¤¿ºÝ¤Ï¥¹¥¿¥Ã¥Õ
¤Ë¤³¤Îºî¶È¤ò¤ä¤Ã¤ÆÌ㤦ͽÄê¤Ê¤Î¤Ç¡¢½ÐÍè¤ë¸Â¤ê¼ê´Ö¤ò¾Ê¤¤¤Æ¡¢´Êñ¤Ë½ÐÍè¤ë
ÊýË¡¤ò¤È»×¤Ã¤Æ¤ª¤ê¤Þ¤¹¡£

¹¹¤Ë¥¢¥É¥Ð¥¤¥¹Äº¤±¤ì¤ÐÂçÊѹ¬¿Ó¤Ë¸¤¸¤Þ¤¹¡£¡¡¡¡£Ç£Å£Ï£È£Á£Ó£ÅÇÒ


----- Original Message ----- 
From: "tatematsu" <tatemax@xxxxxxxxxx>
To: <ml@xxxxxxxxxx>
Sent: Saturday, September 03, 2005 9:30 AM
Subject: [mysql 12059] Re: SQL¥À¥ó¥×¥Ç¡¼¥¿¤Î½èÍý¤Î·ï


> ¤ª¤Ï¤è¤¦¤´¤¶¤¤¤Þ¤¹¡£Î©¾¾¤Ç¤¹¡£
>
>> ¥³¥Þ¥ó¥É¤«¤é¡¡mysql<geohase.sql¡¡¤ÏÀ®¸ù¤·¤Þ¤»¤ó¡ÊÉÔÌÀ¤Î¥³¥Þ¥ó¥É¤È
>> ¥¨¥é¡¼¤¬Ìá¤ê¤Þ¤¹¡Ë¡£¡¡
>
> ¥Ñ¥¹¤¬Ä̤äƤʤ¤¤Î¤Ç¤Ï¡©¼ã¤·¤¯¤Ï¡¢mysql¥¯¥é¥¤¥¢¥ó¥È¤¬¥¤¥ó¥¹¥È¡¼¥ë
> ¤µ¤ì¤Æ¤¤¤Ê¤¤¤Î¤Ç¤Ï¡©
>
> http://dev.mysql.com/doc/mysql/ja/windows-installation.html
> ¾åµ­¤Î¥ê¥ó¥¯¤¬»²¹Í¤Ë¤Ê¤ê¤Þ¤»¤ó¤«¤Í¡£


[Á°][¼¡][ÈÖ¹æ½ç°ìÍ÷][¥¹¥ì¥Ã¥É°ìÍ÷]

     12055 2005-09-02 18:48 ["safe" <geohase@xxxx] SQL¥À¥ó¥×¥Ç¡¼¥¿¤Î½èÍý¤Î·ï               
     12056 2005-09-02 19:08 ¨±[tatematsu <tatemax@x]                                       
     12057 2005-09-02 19:28 ¡¡¨±[tatematsu <tatemax@x]                                     
     12058 2005-09-02 23:19 ¡¡¡¡¨±["safe" <geohase@xxxx]                                   
     12059 2005-09-03 09:30 ¡¡¡¡¡¡¨±[tatematsu <tatemax@x]                                 
->   12061 2005-09-03 11:34 ¡¡¡¡¡¡¡¡¨±["safe" <geohase@xxxx]                               
     12066 2005-09-03 12:26 ¡¡¡¡¡¡¡¡¡¡¨±[tatematsu <tatemax@x]                             
     12067 2005-09-03 15:23 ¡¡¡¡¡¡¡¡¡¡¡¡¨±["safe" <geohase@xxxx]                           
     12068 2005-09-03 16:11 ¡¡¡¡¡¡¡¡¡¡¡¡¡¡¨²[SUGIMURA Takashi ¿ùÂ]                         
     12069 2005-09-03 16:24 ¡¡¡¡¡¡¡¡¡¡¡¡¡¡¨±[tatematsu <tatemax@x]