📄 minierp20060519.txt

📁 开源的库存管理系统 www.minierp.cn php+ mysql
💻 TXT
📖 第 1 页 / 共 5 页
字号:
12 3 4 5 下一页
-- phpMyAdmin SQL Dump
-- version 2.7.0-pl2
-- http://www.phpmyadmin.net
-- 
-- 主机: localhost:3305
-- 生成日期: 2006 年 05 月 19 日 09:12
-- 服务器版本: 5.0.21
-- PHP 版本: 5.1.2
-- 
-- 数据库: `minierp`
-- 

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

-- 
-- 表的结构 `accdelt`
-- 

CREATE TABLE `accdelt` (
  `AUTOID` bigint(20) NOT NULL,
  `ID` varchar(5) default NULL,
  `ACCID` varchar(5) default NULL,
  `CON01` varchar(16) NOT NULL default '',
  `CON02` varchar(15) default NULL,
  `CON03` varchar(15) default NULL,
  `CON04` varchar(10) default NULL,
  `CON05` varchar(8) default NULL,
  `CON06` varchar(8) default NULL,
  `CON07` date default NULL,
  `CON08` varchar(30) default NULL,
  `CON09` varchar(30) default NULL,
  `CON10` varchar(30) default NULL,
  `CON11` varchar(30) default NULL,
  `CON12` varchar(30) default NULL,
  `CON13` varchar(30) default NULL,
  `DT999` datetime default NULL,
  `DT998` tinyint(1) default '0',
  PRIMARY KEY  (`AUTOID`)
) TYPE=InnoDB COMMENT='联系人资料表' AUTO_INCREMENT=78 ;

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

INSERT INTO `accdelt` VALUES (1, '02', '01', 'ALLEN', '290', '13809638820', '', '经理', '开发课', '0000-00-00', '', '534581854', '', '', 'allen@jra.com.tw', '东莞清溪碧月湾', '2006-03-04 20:34:32', 0);
INSERT INTO `accdelt` VALUES (2, '', '01', '殷显英', '296', '87611871', '', '财务', '财务', '0000-00-00', '', '', '', '', '', '', '2006-03-04 20:35:41', 0);
INSERT INTO `accdelt` VALUES (3, '', '01', '黄茂榕', '298', '', '', '课长', '开发课', '0000-00-00', '', '43601554', '', '', '', '', '2006-03-04 20:38:09', 0);
INSERT INTO `accdelt` VALUES (4, '', '01', '杨碧', '291', '13560800182', '', '', '开发课', '0000-00-00', '', '', '', '', '', '', '2006-04-08 22:43:17', 0);
INSERT INTO `accdelt` VALUES (5, '', '01', '简副总', '295', '', '', '副总', '业务部', '0000-00-00', '', '', '', '', '', '', '2006-03-04 20:41:36', 0);
INSERT INTO `accdelt` VALUES (6, '', '02', '曾副理', '603', '', '', '副理', '业务部', '0000-00-00', '', '', '', '', '', '', '2006-03-04 20:43:02', 0);
INSERT INTO `accdelt` VALUES (7, '', '02', '财务', '609', '', '', '会计', '财务部', '0000-00-00', '', '', '', '', '', '', '2006-03-04 20:43:48', 0);
INSERT INTO `accdelt` VALUES (8, '', '03', '周小姐', '110', '', '', '采购', '采购部', '0000-00-00', '', '', '', '', '', '', '2006-03-04 20:44:38', 0);
INSERT INTO `accdelt` VALUES (9, '', '03', '韩小姐', '203', '', '', '会计', '财务部', '0000-00-00', '', '', '', '', '', '', '2006-03-04 20:45:21', 0);
INSERT INTO `accdelt` VALUES (10, '', '04', '唐丽文', '111', '13694911878', '87311075', '采购', '采购部', '0000-00-00', '', '', '', '', '', '', '2006-03-04 20:46:40', 0);
INSERT INTO `accdelt` VALUES (11, '', '04', '黄小姐', '151', '', '87382507', '会计', '财务部', '0000-00-00', '', '', '', '', '', '', '2006-03-04 20:47:36', 0);
INSERT INTO `accdelt` VALUES (12, '', '04', '孙小姐', '238', '', '', '出纳', '财务部', '0000-00-00', '', '', '', '', '', '', '2006-03-04 20:48:05', 0);
INSERT INTO `accdelt` VALUES (13, '', '05', '张小姐', '', '', '', '出纳', '财务部', '0000-00-00', '', '', '', '', '', '', '2006-03-04 20:49:09', 0);
INSERT INTO `accdelt` VALUES (14, '', '06', '李欣融', '', '13829133701', '', '经理', '', '0000-00-00', '', '', '', '', '', '', '2006-03-04 20:51:20', 0);
INSERT INTO `accdelt` VALUES (15, '', '06', '曾小姐', '', '', '', '出纳', '财务部', '0000-00-00', '', '', '', '', '', '', '2006-03-04 20:50:50', 0);
INSERT INTO `accdelt` VALUES (16, '', '06', '刘姿儿', '', '13751256099', '', '专员', '财务部', '0000-00-00', '', '', '', '', '', '', '2006-03-04 20:51:39', 0);
INSERT INTO `accdelt` VALUES (17, '', '01', '陈丽君', '87880085', '', '', '人事', '龙贝岭', '0000-00-00', '', '', '', '', '', '', '2006-03-04 20:53:25', 0);
INSERT INTO `accdelt` VALUES (18, '', '07', '张春和', '', '13829176321', '', '经理', '生产部', '0000-00-00', '', '', '', '', '', '', '2006-03-04 20:55:06', 0);
INSERT INTO `accdelt` VALUES (19, '', '07', '韩小姐', '', '', '', '出纳', '财务部', '0000-00-00', '', '', '', '', '', '', '2006-03-04 20:55:35', 0);
INSERT INTO `accdelt` VALUES (20, '', '08', '何先生', '', '13825784480', '', '', '', '0000-00-00', '', '', '', '', '', '', '2006-03-04 20:59:59', 0);
INSERT INTO `accdelt` VALUES (21, '', '09', '尹先生', '', '', '', '会计', '财务部', '0000-00-00', '', '', '', '', '', '', '2006-03-04 21:00:55', 0);
INSERT INTO `accdelt` VALUES (22, '', '09', '尹小姐', '', '', '', '出纳', '财务部', '0000-00-00', '', '', '', '', '', '', '2006-03-04 21:04:51', 0);
INSERT INTO `accdelt` VALUES (23, '', '09', '陈小姐', '', '', '', '采购', '采购部', '0000-00-00', '', '', '', '', '', '', '2006-03-04 21:05:20', 0);
INSERT INTO `accdelt` VALUES (24, '', '10', '袁小姐', '', '', '', '采购', '采购部', '0000-00-00', '', '', '', '', '', '', '2006-03-04 21:07:34', 0);
INSERT INTO `accdelt` VALUES (25, '', '10', '李小姐', '', '', '', '出纳', '财务部', '0000-00-00', '', '', '', '', '', '', '2006-03-04 21:07:46', 0);
INSERT INTO `accdelt` VALUES (26, '', '11', '林经理', '', '13580825628', '', '经理', '', '0000-00-00', '', '', '', '', '', '', '2006-03-04 21:09:16', 0);
INSERT INTO `accdelt` VALUES (27, '', '11', '杨小姐', '', '', '', '出纳', '财务部', '0000-00-00', '', '', '', '', '', '', '2006-03-04 21:10:10', 0);
INSERT INTO `accdelt` VALUES (28, '', '12', '林小姐', '', '', '', '财务', '财务部', '0000-00-00', '', '', '', '', '', '', '2006-03-04 21:10:47', 0);
INSERT INTO `accdelt` VALUES (29, '', '14', '刘小姐', '', '', '', '出纳', '财务部', '0000-00-00', '', '', '', '', '', '', '2006-03-04 21:12:59', 0);
INSERT INTO `accdelt` VALUES (30, '', '15', '杨小姐', '', '', '', '业务', '业务部', '0000-00-00', '', '', '', '', '', '', '2006-03-04 21:14:10', 0);
INSERT INTO `accdelt` VALUES (31, '', '15', '吴小姐', '', '', '', '出纳', '财务部', '0000-00-00', '', '', '', '', '', '', '2006-03-04 21:14:36', 0);
INSERT INTO `accdelt` VALUES (32, '', '16', '李小姐', '', '', '', '出纳', '财务部', '0000-00-00', '', '', '', '', '', '', '2006-03-04 21:15:08', 0);
INSERT INTO `accdelt` VALUES (33, '', '16', '郁先生', '', '13763107563', '', '', '', '0000-00-00', '', '', '', '', '', '', '2006-03-04 21:15:52', 0);
INSERT INTO `accdelt` VALUES (34, '', '17', '萧义', '', '', '', '', '', '0000-00-00', '', '', '', '', '', '', '2006-03-04 21:17:01', 0);
INSERT INTO `accdelt` VALUES (35, '', '18', '张小姐', '', '', '', '出纳', '财务部', '0000-00-00', '', '', '', '', '', '', '2006-03-04 21:17:37', 0);
INSERT INTO `accdelt` VALUES (36, '', '18', '陈小姐', '', '', '', '采购', '采购', '0000-00-00', '', '', '', '', '', '', '2006-03-04 21:18:17', 0);
INSERT INTO `accdelt` VALUES (37, '', '19', '李小姐', '', '', '', '出纳', '财务部', '0000-00-00', '', '', '', '', '', '', '2006-03-04 21:53:39', 0);
INSERT INTO `accdelt` VALUES (38, '', '19', '熊总', '', '', '', '总经理', '', '0000-00-00', '', '', '', '', '', '', '2006-03-04 21:54:01', 0);
INSERT INTO `accdelt` VALUES (39, '', '20', '李先生', '', '', '', '出纳', '财务部', '0000-00-00', '', '', '', '', '', '', '2006-03-04 21:54:30', 0);
INSERT INTO `accdelt` VALUES (40, '', '23', '张合朝', '', '13580824823', '', '', '', '0000-00-00', '', '', '', '', '', '', '2006-03-04 21:55:21', 0);
INSERT INTO `accdelt` VALUES (41, '', '24', '王金姣', '109', '84978825', '', '人事', '人事', '0000-00-00', '', '', '', '', '', '', '2006-03-04 21:56:37', 0);
INSERT INTO `accdelt` VALUES (42, '', '25', '谭小姐', '126', '', '87311664', '会计', '财务部', '0000-00-00', '', '', '', '', '', '', '2006-03-04 21:58:04', 0);
INSERT INTO `accdelt` VALUES (43, '', '25', '曾小姐', '', '', '87387676', '专员', '采购部', '0000-00-00', '', '', '', '', '', '', '2006-03-04 21:58:45', 0);
INSERT INTO `accdelt` VALUES (44, '', '26', '王小姐', '157', '', '87891111', '采购', '采购部', '0000-00-00', '', '', '', '', '', '', '2006-04-07 09:39:59', 0);
INSERT INTO `accdelt` VALUES (45, '', '26', '齐小姐', '', '', '87891111', '会计', '财务部', '0000-00-00', '', '', '', '', '', '', '2006-03-04 21:59:53', 0);
INSERT INTO `accdelt` VALUES (46, '', '29', '曾先生', '', '', '', '', '电脑部', '0000-00-00', '', '', '', '', '', '', '2006-03-04 22:00:44', 0);
INSERT INTO `accdelt` VALUES (47, '', '29', '李小姐', '236', '', '', '出纳', '财务部', '0000-00-00', '', '', '', '', '', '', '2006-03-04 22:01:19', 0);
INSERT INTO `accdelt` VALUES (48, '', '30', '万小姐', '', '', '', '', '', '0000-00-00', '', '', '', '', '', '', '2006-03-04 22:01:54', 0);
INSERT INTO `accdelt` VALUES (49, '', '31', '胡小姐', '', '', '', '采购', '', '0000-00-00', '', '', '', '', '', '', '2006-03-04 22:02:59', 0);
INSERT INTO `accdelt` VALUES (50, '', '32', '蔡小姐', '', '', '', '业务', '业务部', '0000-00-00', '', '', '', '', '', '', '2006-03-04 22:03:39', 0);
INSERT INTO `accdelt` VALUES (51, '', '32', '何小姐', '', '', '', '出纳', '财务部', '0000-00-00', '', '', '', '', '', '', '2006-03-04 22:03:58', 0);
INSERT INTO `accdelt` VALUES (52, '', '34', '梁小姐', '', '', '', '', '采购', '0000-00-00', '', '', '', '', '', '', '2006-03-04 22:04:31', 0);
INSERT INTO `accdelt` VALUES (53, '', '35', '黎先生', '', '', '', '', '电脑部', '0000-00-00', '', '', '', '', '', '', '2006-03-04 22:05:06', 0);
INSERT INTO `accdelt` VALUES (54, '', '36', '周小姐', '', '', '', '出纳', '财务部', '0000-00-00', '', '', '', '', '', '', '2006-03-04 22:05:54', 0);
INSERT INTO `accdelt` VALUES (55, '', '36', '史小姐', '', '', '', '', '', '0000-00-00', '', '', '', '', '', '', '2006-03-04 22:06:24', 0);
INSERT INTO `accdelt` VALUES (56, '', '999', '殷先生', '87731299', '87371083', '', '', '', '0000-00-00', '', '', '', '', '', '东莞清溪长山头', '2006-03-06 10:34:15', 0);
INSERT INTO `accdelt` VALUES (57, '', '999', '张小姐', '', '13058529121', '', '', '', '0000-00-00', '', '', '', '', '', '凯琳服饰', '2006-03-06 10:34:56', 0);
INSERT INTO `accdelt` VALUES (58, '', '999', '王国栋', '', '13751348356', '', '', '', '0000-00-00', '', '', '', '', '', '', '2006-03-06 10:35:32', 0);
INSERT INTO `accdelt` VALUES (59, '', '999', '杨仁凤', '87368178', '', '', '', '', '0000-00-00', '', '', '', '', '', '公务员小区', '2006-03-06 10:36:03', 0);
INSERT INTO `accdelt` VALUES (60, '', '999', '吉林吴生', '', '13843160903', '', '', '', '0000-00-00', '', '', '', '', '', '吉林', '2006-03-06 10:36:48', 0);
INSERT INTO `accdelt` VALUES (61, '', '999', '杜思克', '', '13071368858', '', '', '', '0000-00-00', '', '', '', '', '', '', '2006-03-06 10:37:12', 0);
INSERT INTO `accdelt` VALUES (62, '', '999', '杨先生', '', '13688903465', '', '', '', '0000-00-00', '', '', '', '', '', '东莞清溪老街茂记唱片旁', '2006-03-06 10:38:05', 0);
INSERT INTO `accdelt` VALUES (63, '', '999', '黄小姐', '', '13631788318', '', '', '', '0000-00-00', '', '', '', '', '', '东莞清溪供电大楼903#', '2006-03-06 10:38:53', 0);
INSERT INTO `accdelt` VALUES (64, '', '999', '万波', '', '13609692297', '', '', '', '0000-00-00', '', '', '', '', '', '东莞清溪大利', '2006-03-06 10:40:14', 0);
INSERT INTO `accdelt` VALUES (65, '', '999', '贾艳', '', '13113826179', '', '', '', '0000-00-00', '', '', '', '', '', '深圳圳方生', '2006-04-02 11:29:23', 0);
INSERT INTO `accdelt` VALUES (66, '', '999', '李生', '', '84379573', '', '', '', '0000-00-00', '', '', '', '', '', '东莞清溪大利厂', '2006-03-06 10:42:11', 0);
INSERT INTO `accdelt` VALUES (67, '', '999', '尹生', '', '87352808', '', '', '', '0000-00-00', '', '', '', '', '', '东莞清溪大利', '2006-03-06 10:42:43', 0);
INSERT INTO `accdelt` VALUES (68, '', '999', '蓝生', '', '13823556075', '', '', '', '0000-00-00', '', '', '', '', '', '东莞清溪大利', '2006-03-06 10:43:48', 0);
INSERT INTO `accdelt` VALUES (69, '', '999', '蓝文聪', '', '87353689', '', '', '', '0000-00-00', '', '', '', '', '', '东莞清溪大利茅村', '2006-03-06 10:44:29', 0);
INSERT INTO `accdelt` VALUES (70, '', '37', '林厂长', '', '076985748315', '', '厂长', '', '0000-00-00', '', '', '', '', '', '', '2006-03-07 23:00:23', 0);
INSERT INTO `accdelt` VALUES (71, '', '30', '林先生', '', '13829100355', '', '', '', '0000-00-00', '', '', '', '', '', '', '2006-03-09 17:14:41', 0);
INSERT INTO `accdelt` VALUES (72, '', '999', '江先生', '87389697', '', '', '', '', '0000-00-00', '', '', '', '', '', '清溪大利大荣厂旁', '2006-03-09 17:16:14', 0);
INSERT INTO `accdelt` VALUES (73, '', '999', '黄正天', '', '13926802697', '', '', '', '0000-00-00', '', '', '', '', '', '', '2006-03-09 17:16:55', 0);
INSERT INTO `accdelt` VALUES (74, '', '30', '黄建中', '', '13066165051', '', '', '', '0000-00-00', '', '', '', '', '', '东莞莞城(股票)', '2006-03-12 18:28:54', 0);
INSERT INTO `accdelt` VALUES (75, '', '999', '黄锦民', '', '13602368413', '', '厂长', '', '0000-00-00', '', '', '', '', '', '东莞清溪碧月湾', '2006-03-20 20:05:43', 0);
INSERT INTO `accdelt` VALUES (76, '', '38', '尹锐铭', '87324222', '13527932999', '87867772', '', '', '0000-00-00', '13809263381', '', '', '', '', '', '2006-03-28 14:44:34', 0);
INSERT INTO `accdelt` VALUES (77, '', '30', '余先生', '', '13332638178', '', '', '', '0000-00-00', '', '', '', '', '', '大利', '2006-03-28 23:17:27', 0);

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

-- 
-- 表的结构 `accounts`
-- 

CREATE TABLE `accounts` (
  `AUTOID` bigint(20) NOT NULL,
  `ID` varchar(5) NOT NULL default '',
  `ACC01` varchar(16) default NULL,
  `ACC02` varchar(50) default NULL,
  `ACC03` varchar(15) default NULL,
  `ACC03A` varchar(5) default '0769',
  `ACC04` varchar(15) default NULL,
  `ACC04A` varchar(5) default '0769',
  `ACC05` varchar(50) default NULL,
  `ACC06` int(10) default NULL,
  `ACC07` int(10) default NULL,
  `ACC08A` varchar(20) default NULL,
  `ACC08` varchar(20) default NULL,
  `ACC09` varchar(50) default NULL,
  `ACC10` varchar(50) default NULL,
  `ACC11` varchar(10) default NULL,
  `ACC12` varchar(40) default NULL,
  `ACC13` tinyint(1) default '1',
  `ACC13A` int(11) default NULL,
  `ACC13B` int(11) default NULL,
  `ACC14` tinyint(1) default '0',
  `DT999` datetime NOT NULL default '0000-00-00 00:00:00',
  `DT998` tinyint(1) default '0',
12 3 4 5 下一页
💿 文件大小 479 K
👤 上传用户 apsdn
📂 所属分类 MySQL数据库
🏷️ 相关标签

#minierp #mysql #www #php
⌨️ 快捷键说明

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