【SQL开源代码栏目提醒】:网学会员为广大网友收集整理了,ad.sql,希望对大家有所帮助!
锘?- MySQL dump 10.10
--
-- Host: localhost Database: ad
-- ------------------------------------------------------
-- Server version 5.0.22-community-nt
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `adclickinfo`
--
DROP TABLE IF EXISTS `adclickinfo`;
CREATE TABLE `adclickinfo` (
`cId` int(6) unsigned NOT NULL auto_increment,
`ADid` int(6) unsigned NOT NULL,
`clientIP` varchar(45) NOT NULL,
`clicktime` datetime NOT NULL,
PRIMARY KEY (`cId`),
KEY `NewIndex_1` (`ADid`),
CONSTRAINT `adclickinfo_ibfk_1` FOREIGN KEY (`ADid`) REFERENCES `adinfo` (`ADId`)
) ENGINE=InnoDB DEFAULT CHARSET=ucs2 COMMENT='录脟脗录鹿茫赂忙驴脥禄搂碌脛碌茫禄梅录脟脗录';
--
-- Dumping data for table `adclickinfo`
--
/*!40000 ALTER TABLE `adclickinfo` DISABLE KEYS */;
LOCK TABLES `adclickinfo` WRITE;
INSERT INTO `adclickinfo` VALUES (1,2,'127.0.0.1','2007-04-21 17:10:22'),(2,2,'127.0.0.1','2007-04-21 17:10:36'),(3,3,'127.0.0.1','2007-04-21 17:11:53'),(4,2,'127.0.0.1','2007-04-21 17:15:44'),(5,1,'127.0.0.1','2007-04-21 17:15:57'),(6,1,'127.0.0.1','2007-04-21 17:49:45'),(7,2,'127.0.0.1','2007-04-21 17:50:01'),(8,3,'127.0.0.1','2007-04-26 14:50:19'),(9,3,'127.0.0.1','2007-04-26 14:50:25'),(10,3,'127.0.0.1','2007-04-26 14:50:28'),(11,2,'127.0.0.1','2007-04-26 14:50:32'),(12,2,'127.0.0.1','2007-04-26 14:50:38'),(13,1,'127.0.0.1','2007-04-26 15:00:29'),(14,1,'127.0.0.1','2007-04-26 15:04:53');
UNLOCK TABLES;
/*!40000 ALTER TABLE `adclickinfo` ENABLE KEYS */;
--
-- Table structure for table `adinfo`
--
DROP TABLE IF EXISTS `adinfo`;
CREATE TABLE `adinfo` (
`ADId` int(6) unsigned NOT NULL auto_increment,
`url` varchar(45) NOT NULL,
`imgname` varchar(45) NOT NULL,
PRIMARY KEY (`ADId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='录脟脗录鹿茫赂忙脜盲脰脙脨脜脧垄';
--
-- Dumping data for table `adinfo`
--
/*!40000 ALTER TABLE `adinfo` DISABLE KEYS */;
LOCK TABLES `adinfo` WRITE;
INSERT INTO `adinfo` VALUES (1,'http://sun.csdn.net/solaris/','1.gif'),(2,'htti://www.263.net','2.gif'),(3,'http://www.eclipse.org','3.gif'),(4,'http://www.csdn.net','4.jpg');
UNLOCK TABLES;
/*!40000 ALTER TABLE `adinfo` ENABLE KEYS */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;