⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 install.sql

📁 PHP+IIS+MySQL开发物流管理系统
💻 SQL
字号:
🔍 
-- phpMyAdmin SQL Dump
-- version 2.9.1.1
-- http://www.phpmyadmin.net
-- 
-- 主机: localhost
-- 生成日期: 2007 年 09 月 06 日 16:00
-- 服务器版本: 4.1.20
-- PHP 版本: 4.4.0
-- 
-- 数据库: `dd`
-- 

-- --------------------------------------------------------

-- 
-- 表的结构 `chat`
-- 

CREATE TABLE `chat` (
  `cid` int(11) NOT NULL auto_increment,
  `author` varchar(50) NOT NULL default '',
  `create_time` time NOT NULL default '00:00:00',
  `text` blob NOT NULL,
  PRIMARY KEY  (`cid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=26 ;

-- 
-- 导出表中的数据 `chat`
-- 

INSERT INTO `chat` (`cid`, `author`, `create_time`, `text`) VALUES 
(19, 'shenxu', '08:55:20', 0xc3bbc8cb),
(18, 'jiafuchun', '03:47:10', 0xb4f3bcd2bac3b0a12cd4dac3a6cab2c3b4c4d80d0a),
(17, 'tanlibo', '07:48:07', 0xb4f3bcd2bac3),
(20, 'jiafuchun', '04:05:29', 0xb4f3bcd2bac3),
(21, 'jiafuchun', '04:05:42', 0xc0b4c8cbb0a10d0a),
(22, 'jiafuchun', '04:06:01', 0xd3d0c8cbc3bbd3d0),
(23, 'jiafuchun', '04:20:17', 0xb4f3bcd2bac3),
(24, 'tanlibo', '07:15:16', 0xc0dbb0a12ebac7bac7),
(25, 'jiafuchun', '09:28:56', 0xbfbf2cc3bbc8cb0d0a);

-- --------------------------------------------------------

-- 
-- 表的结构 `qinggan_admin`
-- 

CREATE TABLE `qinggan_admin` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `typer` enum('system','manager','editor') NOT NULL default 'editor',
  `user` varchar(100) NOT NULL default '',
  `pass` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=12 ;

-- 
-- 导出表中的数据 `qinggan_admin`
-- 

INSERT INTO `qinggan_admin` (`id`, `typer`, `user`, `pass`) VALUES 
(1, 'system', 'admin', '21232f297a57a5a743894a0e4a801fc3');

-- --------------------------------------------------------

-- 
-- 表的结构 `qinggan_caiwu`
-- 

CREATE TABLE `qinggan_caiwu` (
  `id` mediumint(8) unsigned NOT NULL default '0',
  `rq` varchar(255) NOT NULL default '',
  `xfr` varchar(255) NOT NULL default '',
  `xfxm` varchar(255) NOT NULL default '',
  `je` varchar(255) NOT NULL default '',
  `fzr` varchar(255) NOT NULL default '',
  `fp` varchar(255) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

-- 
-- 导出表中的数据 `qinggan_caiwu`
-- 


-- --------------------------------------------------------

-- 
-- 表的结构 `qinggan_cate`
-- 

CREATE TABLE `qinggan_cate` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `taxis` tinyint(3) unsigned NOT NULL default '255',
  `number` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `rootid` (`taxis`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=3 ;

-- 
-- 导出表中的数据 `qinggan_cate`
-- 

INSERT INTO `qinggan_cate` (`id`, `name`, `taxis`, `number`) VALUES 
(1, '蛋白糖', 255, 'A001'),
(2, '白糖', 255, 'A002');

-- --------------------------------------------------------

-- 
-- 表的结构 `qinggan_content`
-- 

CREATE TABLE `qinggan_content` (
  `id` mediumint(8) unsigned NOT NULL default '0',
  `content` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

-- 
-- 导出表中的数据 `qinggan_content`
-- 

INSERT INTO `qinggan_content` (`id`, `content`) VALUES 
(2, '这是产品简介噢～你可以留空的！');

-- --------------------------------------------------------

-- 
-- 表的结构 `qinggan_i`
-- 

CREATE TABLE `qinggan_i` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `proid` mediumint(8) unsigned NOT NULL default '0',
  `subject` varchar(255) NOT NULL default '',
  `number` varchar(100) NOT NULL default '',
  `pcount` int(10) unsigned NOT NULL default '0',
  `price` float unsigned NOT NULL default '0',
  `enterdate` int(10) unsigned NOT NULL default '0',
  `adminer` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `proid` (`proid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=1 ;

-- 
-- 导出表中的数据 `qinggan_i`
-- 


-- --------------------------------------------------------

-- 
-- 表的结构 `qinggan_o`
-- 

CREATE TABLE `qinggan_o` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `proid` mediumint(8) unsigned NOT NULL default '0',
  `number` varchar(100) NOT NULL default '',
  `pinming` varchar(100) NOT NULL default '',
  `subject` varchar(255) NOT NULL default '',
  `neibu` varchar(100) NOT NULL default '',
  `pcount` int(10) unsigned NOT NULL default '0',
  `guige` int(10) unsigned NOT NULL default '0',
  `price` float unsigned NOT NULL default '0',
  `selldate` int(10) unsigned NOT NULL default '0',
  `adminer` varchar(100) NOT NULL default '',
  `yunfei` varchar(100) NOT NULL default '',
  `shoukuan` varchar(100) NOT NULL default '',
  `note` varchar(255) NOT NULL default '',
  `shopid` mediumint(8) unsigned NOT NULL default '0',
  `userid` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `proid` (`proid`),
  KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=3 ;

-- 
-- 导出表中的数据 `qinggan_o`
-- 

INSERT INTO `qinggan_o` (`id`, `proid`, `number`, `pinming`, `subject`, `neibu`, `pcount`, `guige`, `price`, `selldate`, `adminer`, `yunfei`, `shoukuan`, `note`, `shopid`, `userid`) VALUES 
(2, 4, 'A002', '蛋白糖', 'HS-100', 'MD50-A', 1000, 25, 25000, 1189065548, 'tanlibo', '发货方付', '代收货款', '', 1, 1);

-- --------------------------------------------------------

-- 
-- 表的结构 `qinggan_oc`
-- 

CREATE TABLE `qinggan_oc` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `okey` varchar(100) NOT NULL default '',
  `name` varchar(100) NOT NULL default '',
  `taxis` tinyint(3) unsigned NOT NULL default '255',
  `typer` enum('ocount','oprice','fahuoren') NOT NULL default 'ocount',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=25 ;

-- 
-- 导出表中的数据 `qinggan_oc`
-- 

INSERT INTO `qinggan_oc` (`id`, `okey`, `name`, `taxis`, `typer`) VALUES 
(10, '1', '不打折', 10, 'oprice'),
(11, '0.95', '九五折', 20, 'oprice'),
(12, '0.9', '九折', 30, 'oprice'),
(13, '0.89', '八九折', 40, 'oprice'),
(14, '0.88', '八八折', 50, 'oprice'),
(15, '0.87', '八七折', 60, 'oprice'),
(16, '0.86', '八六折', 70, 'oprice'),
(17, '0.85', '八五折', 80, 'oprice'),
(18, '0.83', '八三折', 90, 'oprice'),
(19, '0.8', '八折', 100, 'oprice'),
(21, '深圳市思味特科技有限公司', '深圳市思味特科技有限公司', 255, 'ocount'),
(22, '深圳民康食用化工有限公司', '深圳民康食用化工有限公司', 255, 'ocount');

-- --------------------------------------------------------

-- 
-- 表的结构 `qinggan_product`
-- 

CREATE TABLE `qinggan_product` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `cateid` mediumint(8) unsigned NOT NULL default '0',
  `number` varchar(100) NOT NULL default '',
  `pinming` varchar(100) NOT NULL default '',
  `subject` varchar(255) NOT NULL default '',
  `neibu` varchar(100) NOT NULL default '',
  `price` float unsigned NOT NULL default '0',
  `picture` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `cateid` (`cateid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=5 ;

-- 
-- 导出表中的数据 `qinggan_product`
-- 

INSERT INTO `qinggan_product` (`id`, `cateid`, `number`, `pinming`, `subject`, `neibu`, `price`, `picture`) VALUES 
(4, 1, 'A002', '蛋白糖', 'HS-100', 'MD50-A', 25, ''),
(3, 2, 'A001', '白糖', 'BT001', 'QYY-001', 3, '');

-- --------------------------------------------------------

-- 
-- 表的结构 `qinggan_session`
-- 

CREATE TABLE `qinggan_session` (
  `id` varchar(100) NOT NULL default '',
  `data` text NOT NULL,
  `lasttime` int(10) unsigned NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

-- 
-- 导出表中的数据 `qinggan_session`
-- 

INSERT INTO `qinggan_session` (`id`, `data`, `lasttime`) VALUES 
('dd519a4a44f0e98fc9225fe7e588517c', 'admin|a:4:{s:2:"id";s:2:"11";s:5:"typer";s:6:"system";s:4:"user";s:8:"xiaoting";s:4:"pass";s:32:"e10adc3949ba59abbe56e057f20f883e";}', 1188542995),
('44178a8b33e4a6e75c3ba4da7d7f1045', 'admin|a:4:{s:2:"id";s:2:"11";s:5:"typer";s:6:"system";s:4:"user";s:8:"xiaoting";s:4:"pass";s:32:"e10adc3949ba59abbe56e057f20f883e";}', 1188545877),
('90a3ffdbb531def864a5a20725660b72', 'admin|a:4:{s:2:"id";s:2:"10";s:5:"typer";s:6:"system";s:4:"user";s:7:"tanlibo";s:4:"pass";s:32:"ad290a61fa7e30bcdb3029467a1d5c02";}', 1188545603),
('66a7958c997319f691c3936be5b251d6', 'admin|a:4:{s:2:"id";s:2:"10";s:5:"typer";s:6:"system";s:4:"user";s:7:"tanlibo";s:4:"pass";s:32:"ad290a61fa7e30bcdb3029467a1d5c02";}', 1188540953),
('66888331fd882233c39262bbf38a441f', 'admin|a:4:{s:2:"id";s:1:"3";s:5:"typer";s:6:"system";s:4:"user";s:9:"jiafuchun";s:4:"pass";s:32:"e10adc3949ba59abbe56e057f20f883e";}', 1188606609),
('ffea7dc023e39a3fbd59c7c04c1c4efb', 'admin|a:4:{s:2:"id";s:1:"4";s:5:"typer";s:6:"system";s:4:"user";s:9:"lucaiting";s:4:"pass";s:32:"e10adc3949ba59abbe56e057f20f883e";}', 1188613891),
('1fa9b93210d924f1fbc6d49a3371ba53', 'admin|a:4:{s:2:"id";s:2:"11";s:5:"typer";s:6:"system";s:4:"user";s:8:"xiaoting";s:4:"pass";s:32:"e10adc3949ba59abbe56e057f20f883e";}', 1188617747),
('bbbfbce46fcbc9fa806a0e1e0a9277ee', 'admin|a:4:{s:2:"id";s:2:"11";s:5:"typer";s:6:"system";s:4:"user";s:8:"xiaoting";s:4:"pass";s:32:"e10adc3949ba59abbe56e057f20f883e";}', 1188617965),
('54f324934312d724fd5a3275d748563f', 'admin|a:4:{s:2:"id";s:2:"11";s:5:"typer";s:6:"system";s:4:"user";s:8:"xiaoting";s:4:"pass";s:32:"e10adc3949ba59abbe56e057f20f883e";}', 1188972757),
('042bee743b568fddbacb6b7f183d91e5', 'admin|a:4:{s:2:"id";s:2:"11";s:5:"typer";s:6:"system";s:4:"user";s:8:"xiaoting";s:4:"pass";s:32:"e10adc3949ba59abbe56e057f20f883e";}', 1188973059),
('ced5dd5b639db2a6c639cfd378b60553', 'admin|a:4:{s:2:"id";s:2:"10";s:5:"typer";s:6:"system";s:4:"user";s:7:"tanlibo";s:4:"pass";s:32:"ad290a61fa7e30bcdb3029467a1d5c02";}', 1189065596);

-- --------------------------------------------------------

-- 
-- 表的结构 `qinggan_shop`
-- 

CREATE TABLE `qinggan_shop` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `ifdefault` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=5 ;

-- 
-- 导出表中的数据 `qinggan_shop`
-- 

INSERT INTO `qinggan_shop` (`id`, `name`, `ifdefault`) VALUES 
(1, '总公司', 1),
(2, '唐山办市处', 0),
(3, '南宁办事处', 0),
(4, '武汉办事处', 0);

-- --------------------------------------------------------

-- 
-- 表的结构 `qinggan_sysmenu`
-- 

CREATE TABLE `qinggan_sysmenu` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `rootid` mediumint(8) unsigned NOT NULL default '0',
  `name` varchar(100) NOT NULL default '',
  `url` varchar(255) NOT NULL default '',
  `images` varchar(100) NOT NULL default '',
  `taxis` tinyint(3) unsigned NOT NULL default '255',
  `ifview` tinyint(3) unsigned NOT NULL default '0',
  `adminer` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=31 ;

-- 
-- 导出表中的数据 `qinggan_sysmenu`
-- 

INSERT INTO `qinggan_sysmenu` (`id`, `rootid`, `name`, `url`, `images`, `taxis`, `ifview`, `adminer`) VALUES 
(1, 0, '管理设置', '', '', 1, 0, ','),
(2, 1, '办事处管理', 'admin.php?file=shopset&act=list', './admin/images/home.png', 10, 0, ','),
(3, 1, '管理员设置', 'admin.php?file=admin', './admin/images/hr.png', 20, 0, ','),
(4, 1, '管理员密码修改', 'admin.php?file=setpass', './admin/images/pass.png', 40, 0, ','),
(5, 1, '产品分类', 'admin.php?file=cate&act=list', './admin/images/js.gif', 30, 0, ','),
(6, 0, '产品管理', '', '', 20, 1, 'manager,editor'),
(7, 6, '添加新产品', 'admin.php?file=product&act=add', './admin/images/special.gif', 10, 0, 'manager,'),
(8, 6, '产品列表', 'admin.php?file=product&act=list', './admin/images/attach.gif', 20, 0, 'manager,editor'),
(10, 0, '销售管理', '', '', 30, 1, 'manager,editor'),
(11, 10, '销售统计', 'admin.php?file=sell&act=total&action=user', './admin/images/hr_yp.png', 10, 0, 'manager,editor'),
(20, 6, '产品入库', 'admin.php?file=product&act=layin', './admin/images/folder_open.png', 30, 0, 'manager,'),
(14, 10, '利润及成本计算', 'admin.php?file=count&act=list', './admin/images/list.png', 40, 0, 'manager,'),
(15, 0, '客户信息管理', '', '', 40, 1, 'manager,editor'),
(16, 15, '添加新客户', 'admin.php?file=user&act=add', './admin/images/hr.png', 10, 0, 'manager,editor'),
(17, 15, '客户列表信息', 'admin.php?file=user&act=list', './admin/images/friends.gif', 20, 0, 'manager,editor'),
(19, 1, '小工具管理', 'admin.php?file=tool&act=list', './admin/images/special.gif', 60, 0, 'manager,editor'),
(23, 10, '添加销售', 'admin.php?file=product&act=list', './admin/images/sysmenu_add.png', 255, 0, 'manager,editor'),
(24, 0, 'OA办公系统', '', '', 255, 1, 'manager,editor'),
(25, 24, '留言本', 'liuyan/index.php', './admin/images/js.gif', 255, 0, 'manager,editor'),
(26, 24, '会议室', 'admin.php?file=login&act=list', './admin/images/notice.gif', 255, 0, 'manager,editor'),
(28, 0, '物流部', '', '', 255, 1, 'manager,editor'),
(29, 28, '货运打单', 'admin.php?file=sell&act=total&action=list', './admin/images/copy.gif', 255, 0, 'manager,editor'),
(30, 28, '打印机设置说明', 'dayingji.html', './admin/images/article.gif', 255, 0, 'manager,editor');

-- --------------------------------------------------------

-- 
-- 表的结构 `qinggan_user`
-- 

CREATE TABLE `qinggan_user` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `number` varchar(100) NOT NULL default '',
  `user` varchar(100) NOT NULL default '',
  `gender` tinyint(3) unsigned NOT NULL default '0',
  `gongshi` varchar(255) NOT NULL default '',
  `phone` varchar(100) NOT NULL default '',
  `fax` varchar(100) NOT NULL default '',
  `pass` varchar(100) NOT NULL default '',
  `email` varchar(100) NOT NULL default '',
  `mobile` varchar(30) NOT NULL default '',
  `address` varchar(255) NOT NULL default '',
  `postmail` varchar(30) NOT NULL default '',
  `regdate` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `number` (`number`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=2 ;

-- 
-- 导出表中的数据 `qinggan_user`
-- 

INSERT INTO `qinggan_user` (`id`, `number`, `user`, `gender`, `gongshi`, `phone`, `fax`, `pass`, `email`, `mobile`, `address`, `postmail`, `regdate`) VALUES 
(1, 'A001', '谭立波', 1, '', '0755-26976076', '', 'e10adc3949ba59abbe56e057f20f883e', '0755-26976406', '13902957967', '深圳南山区安乐工业区15栋4楼', '深圳思味特科技有限公司', 1189064802);

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -