【SQL开源代码栏目提醒】:网学会员为需要SQL开源代码的朋友们搜集整理了fams.sql相关资料,希望对各位网友有所帮助!
# phpMyAdmin SQL Dump
# version 2.5.6
# http://www.phpmyadmin.net
#
# 主机: localhost
# 建立日期: Jan 09, 2005, 08:50 PM
# 服务器版本: 4.0.18
#
PHP 版本: 4.3.6
#
# 数据库: `fams`
#
# --------------------------------------------------------
#
# 数据表格式: `abbreviation`
#
# 建立: Jan 06, 2005, 07:40 PM
# 最后更新: Jan 06, 2005, 07:40 PM
#
CREATE TABLE `abbreviation` (
`abbr_asset_no` int(8) NOT NULL default '0',
`abbr_cate` int(3) NOT NULL default '0',
`abbr_name` varchar(30) NOT NULL default '',
`abbr_amt` int(3) NOT NULL default '0',
`abbr_unit` char(3) NOT NULL default '',
`abbr_owner` varchar(10) NOT NULL default '',
`abbr_dep` int(7) NOT NULL default '0',
`abbr_location` varchar(10) NOT NULL default '',
`abbr_assort` int(4) NOT NULL default '0',
`abbr_status` int(1) NOT NULL default '0',
PRIMARY KEY (`abbr_status`),
KEY `abbr_name` (`abbr_name`)
) TYPE=MyISAM COMMENT='移转报表';
#
# 列出以下数据库的数据: `abbreviation`
#
# --------------------------------------------------------
#
# 数据表格式: `assort`
#
# 建立: Jan 06, 2005, 07:15 PM
# 最后更新: Jan 07, 2005, 10:38 PM
# 最后检查: Jan 07, 2005, 10:38 PM
#
CREATE TABLE `assort` (
`ast_no` int(4) NOT NULL default '0',
`ast_com` varchar(30) NOT NULL default '',
PRIMARY KEY (`ast_com`)
) TYPE=MyISAM COMMENT='财产分类';
#
# 列出以下数据库的数据: `assort`
#
INSERT INTO `assort` VALUES (1001, '土地');
INSERT INTO `assort` VALUES (1101, '办公大楼');
INSERT INTO `assort` VALUES (1102, '厂房');
INSERT INTO `assort` VALUES (1103, '仓库');
INSERT INTO `assort` VALUES (1104, '餐\厅');
INSERT INTO `assort` VALUES (1105, '厕所');
INSERT INTO `assort` VALUES (1106, '宿舍');
INSERT INTO `assort` VALUES (1107, '传达室');
INSERT INTO `assort` VALUES (1108, '建筑物附属设备');
INSERT INTO `assort` VALUES (1116, '其它建物及设备');
INSERT INTO `assort` VALUES (2105, '空压机');
INSERT INTO `assort` VALUES (2106, '冷冻干燥机');
INSERT INTO `assort` VALUES (2136, '吸尘器');
INSERT INTO `assort` VALUES (2137, '焚化炉');
INSERT INTO `assort` VALUES (2158, '太阳能热水器');
INSERT INTO `assort` VALUES (2161, '伸缩大门');
INSERT INTO `assort` VALUES (2173, '废水检验仪器');
INSERT INTO `assort` VALUES (2198, '双频无线电麦克风');
INSERT INTO `assort` VALUES (2201, '设备-其它');
INSERT INTO `assort` VALUES (3001, '传真机');
INSERT INTO `assort` VALUES (3003, '电话总机');
INSERT INTO `assort` VALUES (3004, '电话');
INSERT INTO `assort` VALUES (3006, '电报机');
INSERT INTO `assort` VALUES (3009, '护卡机');
INSERT INTO `assort` VALUES (3010, '打字机');
INSERT INTO `assort` VALUES (3012, '铁柜架子类');
INSERT INTO `assort` VALUES (3013, '办公桌');
INSERT INTO `assort` VALUES (3014, '会议桌');
INSERT INTO `assort` VALUES (3015, '计算机桌');
INSERT INTO `assort` VALUES (3016, '其它桌子类');
INSERT INTO `assort` VALUES (3018, '活动隔屏');
INSERT INTO `assort` VALUES (3024, '办公椅');
INSERT INTO `assort` VALUES (3026, '沙发组');
INSERT INTO `assort` VALUES (3029, '投影机');
INSERT INTO `assort` VALUES (3030, '电视机');
INSERT INTO `assort` VALUES (3031, '录放机');
INSERT INTO `assort` VALUES (3032, '照相机');
INSERT INTO `assort` VALUES (3033, '语音网关器');
INSERT INTO `assort` VALUES (3034, '计算机');
INSERT INTO `assort` VALUES (3035, '打印机');
INSERT INTO `assort` VALUES (3036, '不断电系统');
INSERT INTO `assort` VALUES (3039, '电压稳定器');
INSERT INTO `assort` VALUES (3040, '笔记型计算机');
INSERT INTO `assort` VALUES (3041, '集线器(HUB和SWITH)');
INSERT INTO `assort` VALUES (3042, '声讯会议系统');
INSERT INTO `assort` VALUES (3043, 'Server机柜');
INSERT INTO `assort` VALUES (3044, '计算机防火墙');
INSERT INTO `assort` VALUES (3049, '音响系统');
INSERT INTO `assort` VALUES (3050, '冷气机');
INSERT INTO `assort` VALUES (3051, '电扇');
INSERT INTO `assort` VALUES (3052, '饮水机');
INSERT INTO `assort` VALUES (3053, '冷冻机');
INSERT INTO `assort` VALUES (3054, '电冰箱');
INSERT INTO `assort` VALUES (3055, '蒸饭箱');
INSERT INTO `assort` VALUES (3059, '抽风机');
INSERT INTO `assort` VALUES (3067, '厨房用具');
INSERT INTO `assort` VALUES (3068, '网络主机');
INSERT INTO `assort` VALUES (3071, '时钟');
INSERT INTO `assort` VALUES (3073, '刷卡钟');
INSERT INTO `assort` VALUES (3074, '巡逻钟');
INSERT INTO `assort` VALUES (3078, '热水器');
INSERT INTO `assort` VALUES (3083, '灭火器(枪)');
INSERT INTO `assort` VALUES (3084, '停电照明灯');
INSERT IN