oa.sql

开源的OA系统

# phpMyAdmin SQL Dump
# version 2.5.7
# http://www.phpmyadmin.net
#
# 主机: localhost
# 生成日期: 2008 年 12 月 18 日 17:53
# 服务器版本: 3.23.55
# PHP 版本: 4.3.2
# 
# 数据库 : `oa`
# 
CREATE DATABASE `oa`;
USE oa;
set names gb2312;

# --------------------------------------------------------

#
# 表的结构 `cwgl`
#

CREATE TABLE `cwgl` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(30) default NULL,
  `zt` varchar(4) default NULL,
  `spmc` varchar(40) default NULL,
  `spjg` float default NULL,
  `spsl` int(4) default NULL,
  `sum` float NOT NULL default '0',
  `date` date default NULL,
  `tbr` varchar(6) default NULL,
  `body` text,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# 导出表中的数据 `cwgl`
#


# --------------------------------------------------------

#
# 表的结构 `department`
#

CREATE TABLE `department` (
  `id` int(10) NOT NULL auto_increment,
  `department` varchar(20) default NULL,
  `commet` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=10 ;

#
# 导出表中的数据 `department`
#

INSERT INTO `department` VALUES (3, '采购人员', '');
INSERT INTO `department` VALUES (2, '业务人员', '');
INSERT INTO `department` VALUES (5, '总经理', '');
INSERT INTO `department` VALUES (4, '采购助理', '');
INSERT INTO `department` VALUES (6, '总经理助理', '');

# --------------------------------------------------------

#
# 表的结构 `forum`
#

CREATE TABLE `forum` (
  `id` int(11) NOT NULL auto_increment,
  `forum_id` varchar(8) default NULL,
  `name` varchar(12) default NULL,
  `title` text,
  `commet` text,
  `datetime` datetime default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# 导出表中的数据 `forum`
#


# --------------------------------------------------------

#
# 表的结构 `forum_fl`
#

CREATE TABLE `forum_fl` (
  `id` int(11) NOT NULL auto_increment,
  `title` text,
  `body` text,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

#
# 导出表中的数据 `forum_fl`
#

INSERT INTO `forum_fl` VALUES (1, '内部交流区', '内部交流区');

# --------------------------------------------------------

#
# 表的结构 `forum_return`
#

CREATE TABLE `forum_return` (
  `id` int(11) NOT NULL auto_increment,
  `forum_id` varchar(10) default NULL,
  `name` varchar(120) default NULL,
  `commet` text,
  `datetime` datetime default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# 导出表中的数据 `forum_return`
#


# --------------------------------------------------------

#
# 表的结构 `inbox`
#

CREATE TABLE `inbox` (
  `id` int(11) NOT NULL auto_increment,
  `addresser` varchar(20) default NULL,
  `content` text,
  `addressee` varchar(20) default NULL,
  `read` int(2) default NULL,
  `time` varchar(11) default NULL,
  `job_path` varchar(60) default NULL,
  `title` varchar(40) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# 导出表中的数据 `inbox`
#


# --------------------------------------------------------

#
# 表的结构 `ip`
#

CREATE TABLE `ip` (
  `ip` varchar(24) default NULL
) TYPE=MyISAM;

#
# 导出表中的数据 `ip`
#

INSERT INTO `ip` VALUES ('166.111.79.128');
INSERT INTO `ip` VALUES ('85.145.65.128');
INSERT INTO `ip` VALUES ('15.250.182.64');
INSERT INTO `ip` VALUES ('192.117.222.0');
INSERT INTO `ip` VALUES ('32.128.28.224');
INSERT INTO `ip` VALUES ('66.23.78.0');
INSERT INTO `ip` VALUES ('16.126.140.0');
INSERT INTO `ip` VALUES ('33.96.213.16');
INSERT INTO `ip` VALUES ('82.82.113.226');
INSERT INTO `ip` VALUES ('222.117.0.240');
INSERT INTO `ip` VALUES ('63.212.100.208');
INSERT INTO `ip` VALUES ('61.181.165.0');
INSERT INTO `ip` VALUES ('59.41.82.224');
INSERT INTO `ip` VALUES ('32.236.213.64');
INSERT INTO `ip` VALUES ('58.92.20.64');
INSERT INTO `ip` VALUES ('35.93.140.64');
INSERT INTO `ip` VALUES ('159.87.42.64');
INSERT INTO `ip` VALUES ('55.192.89.64');
INSERT INTO `ip` VALUES ('214.81.140.128');
INSERT INTO `ip` VALUES ('81.238.71.224');
INSERT INTO `ip` VALUES ('155.191.136.224');
INSERT INTO `ip` VALUES ('152.101.139.68');
INSERT INTO `ip` VALUES ('193.40.91.96');
INSERT INTO `ip` VALUES ('209.147.0.224');
INSERT INTO `ip` VALUES ('85.137.32.8');
INSERT INTO `ip` VALUES ('160.126.20.128');
INSERT INTO `ip` VALUES ('220.175.18.224');
INSERT INTO `ip` VALUES ('33.22.255.64');
INSERT INTO `ip` VALUES ('80.156.89.192');
INSERT INTO `ip` VALUES ('209.11.26.96');
INSERT INTO `ip` VALUES ('143.77.120.0');
INSERT INTO `ip` VALUES ('53.126.73.240');
INSERT INTO `ip` VALUES ('72.96.237.232');
INSERT INTO `ip` VALUES ('166.87.197.48');
INSERT INTO `ip` VALUES ('82.91.0.64');
INSERT INTO `ip` VALUES ('3.59.43.224');
INSERT INTO `ip` VALUES ('3.101.85.224');
INSERT INTO `ip` VALUES ('82.245.134.104');
INSERT INTO `ip` VALUES ('202.118.202.224');
INSERT INTO `ip` VALUES ('32.197.116.254');
INSERT INTO `ip` VALUES ('80.40.89.192');
INSERT INTO `ip` VALUES ('158.106.63.240');
INSERT INTO `ip` VALUES ('193.249.170.176');
INSERT INTO `ip` VALUES ('220.132.123.224');
INSERT INTO `ip` VALUES ('192.20.125.208');
INSERT INTO `ip` VALUES ('57.68.147.0');
INSERT INTO `ip` VALUES ('67.123.220.16');
INSERT INTO `ip` VALUES ('38.58.251.192');
INSERT INTO `ip` VALUES ('207.170.48.64');
INSERT INTO `ip` VALUES ('72.244.153.128');
INSERT INTO `ip` VALUES ('16.13.195.0');
INSERT INTO `ip` VALUES ('193.156.91.64');
INSERT INTO `ip` VALUES ('164.153.248.128');
INSERT INTO `ip` VALUES ('222.187.51.0');
INSERT INTO `ip` VALUES ('82.253.167.224');
INSERT INTO `ip` VALUES ('169.84.115.96');
INSERT INTO `ip` VALUES ('163.235.30.224');
INSERT INTO `ip` VALUES ('33.27.125.0');
INSERT INTO `ip` VALUES ('202.18.52.0');
INSERT INTO `ip` VALUES ('38.58.251.192');
INSERT INTO `ip` VALUES ('38.58.251.192');
INSERT INTO `ip` VALUES ('193.79.78.160');
INSERT INTO `ip` VALUES ('155.253.153.160');
INSERT INTO `ip` VALUES ('20.22.45.96');
INSERT INTO `ip` VALUES ('15.91.69.128');
INSERT INTO `ip` VALUES ('203.242.227.32');
INSERT INTO `ip` VALUES ('201.200.94.32');
INSERT INTO `ip` VALUES ('160.130.37.64');
INSERT INTO `ip` VALUES ('70.11.100.236');
INSERT INTO `ip` VALUES ('201.6.10.208');
INSERT INTO `ip` VALUES ('84.206.238.32');
INSERT INTO `ip` VALUES ('38.194.226.32');
INSERT INTO `ip` VALUES ('194.234.165.192');
INSERT INTO `ip` VALUES ('130.56.191.128');
INSERT INTO `ip` VALUES ('160.64.3.224');
INSERT INTO `ip` VALUES ('4.70.123.0');
INSERT INTO `ip` VALUES ('45.221.218.192');
INSERT INTO `ip` VALUES ('57.154.46.0');
INSERT INTO `ip` VALUES ('40.210.166.0');
INSERT INTO `ip` VALUES ('138.80.219.192');
INSERT INTO `ip` VALUES ('200.56.95.64');
INSERT INTO `ip` VALUES ('70.217.125.128');
INSERT INTO `ip` VALUES ('160.114.188.96');
INSERT INTO `ip` VALUES ('207.224.140.128');
INSERT INTO `ip` VALUES ('217.120.209.192');
INSERT INTO `ip` VALUES ('163.1.216.60');
INSERT INTO `ip` VALUES ('12.161.37.192');
INSERT INTO `ip` VALUES ('200.242.145.40');
INSERT INTO `ip` VALUES ('82.207.0.32');
INSERT INTO `ip` VALUES ('135.92.79.0');
INSERT INTO `ip` VALUES ('135.92.79.0');
INSERT INTO `ip` VALUES ('84.125.99.220');
INSERT INTO `ip` VALUES ('80.36.73.32');
INSERT INTO `ip` VALUES ('64.119.121.88');
INSERT INTO `ip` VALUES ('159.133.210.0');
INSERT INTO `ip` VALUES ('71.50.188.32');
INSERT INTO `ip` VALUES ('55.200.13.176');
INSERT INTO `ip` VALUES ('37.181.123.180');
INSERT INTO `ip` VALUES ('59.18.53.128');
INSERT INTO `ip` VALUES ('86.86.203.144');
INSERT INTO `ip` VALUES ('15.164.174.96');
INSERT INTO `ip` VALUES ('133.72.122.96');
INSERT INTO `ip` VALUES ('71.112.95.212');
INSERT INTO `ip` VALUES ('194.83.86.96');
INSERT INTO `ip` VALUES ('212.209.99.128');
INSERT INTO `ip` VALUES ('192.32.67.0');
INSERT INTO `ip` VALUES ('84.75.133.96');
INSERT INTO `ip` VALUES ('12.254.8.32');
INSERT INTO `ip` VALUES ('59.115.40.176');
INSERT INTO `ip` VALUES ('152.28.34.112');
INSERT INTO `ip` VALUES ('131.227.127.128');
INSERT INTO `ip` VALUES ('131.227.127.128');
INSERT INTO `ip` VALUES ('155.202.225.32');
INSERT INTO `ip` VALUES ('63.57.222.192');
INSERT INTO `ip` VALUES ('144.15.94.92');
INSERT INTO `ip` VALUES ('33.209.49.40');
INSERT INTO `ip` VALUES ('134.158.121.96');
INSERT INTO `ip` VALUES ('147.240.213.128');
INSERT INTO `ip` VALUES ('4.31.244.192');
INSERT INTO `ip` VALUES ('164.196.34.144');
INSERT INTO `ip` VALUES ('18.37.59.96');
INSERT INTO `ip` VALUES ('201.14.44.64');
INSERT INTO `ip` VALUES ('53.91.103.96');
INSERT INTO `ip` VALUES ('68.101.34.192');
INSERT INTO `ip` VALUES ('158.52.80.192');
INSERT INTO `ip` VALUES ('149.144.61.64');
INSERT INTO `ip` VALUES ('64.243.154.160');
INSERT INTO `ip` VALUES ('209.42.89.64');
INSERT INTO `ip` VALUES ('149.167.199.160');
INSERT INTO `ip` VALUES ('63.169.205.208');
INSERT INTO `ip` VALUES ('17.56.80.248');
INSERT INTO `ip` VALUES ('86.160.161.96');
INSERT INTO `ip` VALUES ('217.31.147.0');
INSERT INTO `ip` VALUES ('209.248.4.192');
INSERT INTO `ip` VALUES ('80.164.123.64');
INSERT INTO `ip` VALUES ('166.134.108.224');
INSERT INTO `ip` VALUES ('212.53.150.104');
INSERT INTO `ip` VALUES ('213.217.14.224');
INSERT INTO `ip` VALUES ('208.247.160.192');
INSERT INTO `ip` VALUES ('207.192.224.160');
INSERT INTO `ip` VALUES ('68.42.72.192');
INSERT INTO `ip` VALUES ('152.152.176.160');
INSERT INTO `ip` VALUES ('209.22.223.160');
INSERT INTO `ip` VALUES ('131.80.173.192');
INSERT INTO `ip` VALUES ('131.96.22.192');
INSERT INTO `ip` VALUES ('62.154.219.0');
INSERT INTO `ip` VALUES ('35.108.245.64');
INSERT INTO `ip` VALUES ('167.169.70.112');
INSERT INTO `ip` VALUES ('35.163.81.96');
INSERT INTO `ip` VALUES ('136.177.115.254');
INSERT INTO `ip` VALUES ('32.89.150.128');
INSERT INTO `ip` VALUES ('17.21.110.112');
INSERT INTO `ip` VALUES ('205.223.196.112');
INSERT INTO `ip` VALUES ('164.80.34.192');
INSERT INTO `ip` VALUES ('220.245.68.224');
INSERT INTO `ip` VALUES ('57.134.180.64');
INSERT INTO `ip` VALUES ('222.112.240.48');
INSERT INTO `ip` VALUES ('15.234.224.96');
INSERT INTO `ip` VALUES ('214.30.212.0');
INSERT INTO `ip` VALUES ('81.222.5.17');
INSERT INTO `ip` VALUES ('138.49.156.248');
INSERT INTO `ip` VALUES ('15.215.102.192');
INSERT INTO `ip` VALUES ('130.130.149.96');
INSERT INTO `ip` VALUES ('146.23.109.200');
INSERT INTO `ip` VALUES ('17.91.160.128');
INSERT INTO `ip` VALUES ('213.23.40.128');
INSERT INTO `ip` VALUES ('192.47.171.232');
INSERT INTO `ip` VALUES ('134.188.222.50');
INSERT INTO `ip` VALUES ('65.170.40.208');
INSERT INTO `ip` VALUES ('193.74.208.252');
INSERT INTO `ip` VALUES ('18.83.227.0');
INSERT INTO `ip` VALUES ('85.90.229.64');
INSERT INTO `ip` VALUES ('138.190.1.32');
INSERT INTO `ip` VALUES ('57.37.193.32');
INSERT INTO `ip` VALUES ('65.46.7.128');
INSERT INTO `ip` VALUES ('214.150.228.144');
INSERT INTO `ip` VALUES ('86.125.190.208');
INSERT INTO `ip` VALUES ('38.252.226.32');
INSERT INTO `ip` VALUES ('212.143.66.32');
INSERT INTO `ip` VALUES ('60.165.216.32');
INSERT INTO `ip` VALUES ('35.252.144.32');
INSERT INTO `ip` VALUES ('152.179.222.192');
INSERT INTO `ip` VALUES ('168.14.74.80');
INSERT INTO `ip` VALUES ('15.168.191.16');
INSERT INTO `ip` VALUES ('65.57.95.182');
INSERT INTO `ip` VALUES ('159.48.164.0');
INSERT INTO `ip` VALUES ('40.8.49.68');
INSERT INTO `ip` VALUES ('57.14.54.192');
INSERT INTO `ip` VALUES ('195.5.211.224');
INSERT INTO `ip` VALUES ('137.14.195.112');
INSERT INTO `ip` VALUES ('159.238.121.160');
INSERT INTO `ip` VALUES ('166.149.213.208');
INSERT INTO `ip` VALUES ('192.32.176.0');
INSERT INTO `ip` VALUES ('168.173.187.32');
INSERT INTO `ip` VALUES ('32.182.12.16');
INSERT INTO `ip` VALUES ('214.170.94.48');
INSERT INTO `ip` VALUES ('62.29.223.168');
INSERT INTO `ip` VALUES ('133.192.247.240');
INSERT INTO `ip` VALUES ('150.198.253.96');
INSERT INTO `ip` VALUES ('65.50.24.64');
INSERT INTO `ip` VALUES ('195.129.136.32');
INSERT INTO `ip` VALUES ('83.187.234.128');
INSERT INTO `ip` VALUES ('152.210.67.160');
INSERT INTO `ip` VALUES ('214.220.169.164');
INSERT INTO `ip` VALUES ('163.130.119.64');
INSERT INTO `ip` VALUES ('83.48.96.64');