【SQL开源代码栏目提醒】:以下是网学会员为您推荐的SQL开源代码-admanager.sql,希望本篇文章对您学习有所帮助。
锘?- phpMyAdmin SQL Dump
-- version 2.7.0-pl1
-- http://www.phpmyadmin.net
--
-- 涓绘満: localhost
-- 鐢熸垚鏃ユ湡: 2007 骞?06 鏈?25 鏃?18:06
-- 鏈嶅姟鍣ㄧ増鏈? 5.0.17
--
PHP 鐗堟湰: 5.1.2
--
-- 鏁版嵁搴? `admanager`
--
CREATE DATABASE `admanager` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE admanager;
-- --------------------------------------------------------
--
-- 琛ㄧ殑缁撴瀯 `AdBanner`
--
CREATE TABLE `AdBanner` (
`BannerId` int(8) NOT NULL auto_increment,
`AdId` int(8) default NULL,
`HotelId` int(8) default NULL,
`PageLevle` varchar(30) default NULL,
`AdPosition` text,
`AdType` varchar(30) default NULL,
`Status` int(1) default '0',
`Memo` text,
PRIMARY KEY (`BannerId`),
KEY `AdId` (`AdId`),
KEY `HotelId` (`HotelId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='骞垮憡浣嶈〃' AUTO_INCREMENT=1 ;
--
-- 瀵煎嚭琛ㄤ腑鐨勬暟鎹?`AdBanner`
--
-- --------------------------------------------------------
--
-- 琛ㄧ殑缁撴瀯 `AdPayLog`
--
CREATE TABLE `AdPayLog` (
`LogId` int(8) NOT NULL auto_increment,
`AdId` int(8) NOT NULL,
`Amount` float default NULL,
`LogMan` varchar(30) default NULL,
`LogDate` datetime default NULL,
`Attribute` varchar(10) default NULL,
`Memo` text,
PRIMARY KEY (`LogId`),
KEY `AdId` (`AdId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- 瀵煎嚭琛ㄤ腑鐨勬暟鎹?`AdPayLog`
--
-- --------------------------------------------------------
--
-- 琛ㄧ殑缁撴瀯 `Advertiser`
--
CREATE TABLE `Advertiser` (
`AderId` int(11) NOT NULL auto_increment,
`AderName` varchar(50) default NULL,
`Position` varchar(50) default NULL,
`Fax` varchar(30) default NULL,
`Email` varchar(30) default NULL,
`LinkMan` varchar(30) default NULL,
`Place` varchar(30) default NULL,
`Telephone` varchar(30) default NULL,
`Memo` text,
PRIMARY KEY (`AderId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='骞垮憡瀹㈡埛' AUTO_INCREMENT=1 ;
--
-- 瀵煎嚭琛ㄤ腑鐨勬暟鎹?`Advertiser`
--
-- --------------------------------------------------------
--
-- 琛ㄧ殑缁撴瀯 `Advertisment`
--
CREATE TABLE `Advertisment` (
`AdId` int(8) NOT NULL auto_increment,
`AderId` int(8) default NULL,
`AdName` varchar(50) default NULL,
`AdKind` varchar(30) default NULL,
`CreateMan` varchar(30) default NULL,
`StartDate` date default NULL,
`EndDate` date default NULL,
`ReleaseMan` varchar(30) default NULL,
`ReleaseDate` date default NULL,
`AdType` varchar(30) default NULL,
`AdPath` varchar(100) default NULL,
`BannerContent` text,
`HotelContent` text,
`Status` varchar(10) default NULL,
`PayStatus` varchar(10) default NULL,
`Memo` text,
PRIMARY KEY (`AdId`),
KEY `AderId` (`AderId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='骞垮憡琛? AUTO_INCREMENT=1 ;
--
-- 瀵煎嚭琛ㄤ腑鐨勬暟鎹?`Advertisment`
--
-- --------------------------------------------------------
--
-- 琛ㄧ殑缁撴瀯 `Dept`
--
CREATE TABLE `Dept` (
`DeptId` int(8) NOT NULL auto_increment,
`DeptName` varchar(30) default NULL,
`UnitMaster` varchar(30) default NULL,
`Telephone` varchar(30) default NULL,
`Memo` text,
PRIMARY KEY (`DeptId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
-- --------------------------------------------------------
--
-- 琛ㄧ殑缁撴瀯 `Dictionary`
--
CREATE TABLE `Dictionary` (
`CodeId` int(8) NOT NULL auto_increment,
`CodeName` varchar(30) NOT NULL,
`Memo` text,
PRIMARY KEY (`CodeId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='瀛楀吀琛? AUTO_INCREMENT=1;
-- --------------------------------------------------------
--
-- 琛ㄧ殑缁撴瀯 `Hotel`
--
CREATE TABLE `Hotel` (
`HotelId` int(8) NOT NULL auto_increment,
`HotelName` varchar(40) default NULL,
`City` varchar(30) default NULL,
`Position` varchar(30) default NULL,
`Fax` varchar(30) default NULL,
`Email` varchar(30) default NULL,
`LinkMan` varchar(30) default NULL,
`Place` varchar(30) default NULL,
`Telephone` varchar(30) default NULL,
`Memo` text,
PRIMARY KEY (`HotelId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='閰掑簵淇℃伅琛? AUTO_INCREMENT=1;
--
-- 瀵煎嚭琛ㄤ腑鐨勬暟鎹?`Hotel`
--
-- --------------------------------------------------------
--
-- 琛ㄧ殑缁撴瀯 `Role`
--
CREATE TABLE `Role` (
`RoleId` int(8) NOT NULL auto_increment,
`RoleName` varchar(30) default NULL,
`Content` text,
`Memo` text,
PRIMARY KEY (`RoleId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_IN