prompt PL/SQL Developer import file
prompt Created on 2008年10月23日 by ALO
set feedback off
set define off
prompt Creating TBLMENU_B...
create table TBLMENU_B
(
MENUCODE VARCHAR2(80) not null,
MDLCODE VARCHAR2(80),
PMENUCODE VARCHAR2(80),
MENUDESC VARCHAR2(240),
MENUSEQ NUMBER not null,
MENUTYPE VARCHAR2(80) not null,
MUSER VARCHAR2(80) not null,
MDATE NUMBER not null,
MTIME NUMBER not null,
EATTRIBUTE1 VARCHAR2(240),
VISIBILITY VARCHAR2(1),
CUSER VARCHAR2(80),
CDATE NUMBER,
CTIME NUMBER,
EATTRIBUTE2 VARCHAR2(240),
EATTRIBUTE3 VARCHAR2(240),
EATTRIBUTE4 VARCHAR2(240),
EATTRIBUTE5 VARCHAR2(240),
EATTRIBUTE6 VARCHAR2(240),
EATTRIBUTE7 VARCHAR2(240),
EATTRIBUTE8 VARCHAR2(240),
EATTRIBUTE9 VARCHAR2(240),
EATTRIBUTE10 VARCHAR2(240)
)
;
comment on table TBLMENU_B
is '菜单列表';
comment on column TBLMENU_B.MENUCODE
is '菜单代码';
comment on column TBLMENU_B.MDLCODE
is '功能代码';
comment on column TBLMENU_B.PMENUCODE
is '父菜单';
comment on column TBLMENU_B.MENUDESC
is '菜单描述';
comment on column TBLMENU_B.MENUSEQ
is '菜单次序';
comment on column TBLMENU_B.MENUTYPE
is '菜单类型';
comment on column TBLMENU_B.VISIBILITY
is '是否可见';
alter table TBLMENU_B
add constraint PK_TBLMENU_B primary key (MENUCODE);
prompt Loading TBLMENU_B...
insert into TBLMENU_B (MENUCODE, MDLCODE, PMENUCODE, MENUDESC, MENUSEQ, MENUTYPE, MUSER, MDATE, MTIME, EATTRIBUTE1, VISIBILITY, CUSER, CDATE, CTIME, EATTRIBUTE2, EATTRIBUTE3, EATTRIBUTE4, EATTRIBUTE5, EATTRIBUTE6, EATTRIBUTE7, EATTRIBUTE8, EATTRIBUTE9, EATTRIBUTE10)
values ('生产布局定义', 'PHYSICAL LAYOUT', '基础设置用户组', '生产布局定义', 20, 'B/S', 'SYS', 0, 0, null, '0', 'SYS', 0, 0, null, null, null, null, null, null, null, null, null);
insert into TBLMENU_B (MENUCODE, MDLCODE, PMENUCODE, MENUDESC, MENUSEQ, MENUTYPE, MUSER, MDATE, MTIME, EATTRIBUTE1, VISIBILITY, CUSER, CDATE, CTIME, EATTRIBUTE2, EATTRIBUTE3, EATTRIBUTE4, EATTRIBUTE5, EATTRIBUTE6, EATTRIBUTE7, EATTRIBUTE8, EATTRIBUTE9, EATTRIBUTE10)
values ('生产数据采集', null, '生产采集', '生产数据采集(上料采集)', 10, 'C/S', 'SYS', 20080802, 145754, null, '0', 'SYS', 0, 0, null, null, null, null, null, null, null, null, null);
insert into TBLMENU_B (MENUCODE, MDLCODE, PMENUCODE, MENUDESC, MENUSEQ, MENUTYPE, MUSER, MDATE, MTIME, EATTRIBUTE1, VISIBILITY, CUSER, CDATE, CTIME, EATTRIBUTE2, EATTRIBUTE3, EATTRIBUTE4, EATTRIBUTE5, EATTRIBUTE6, EATTRIBUTE7, EATTRIBUTE8, EATTRIBUTE9, EATTRIBUTE10)
values ('生产时间定义', 'SHIFTMODEL', '基础设置用户组', '生产时间定义', 10, 'B/S', 'SYS', 0, 0, null, '0', 'SYS', 0, 0, null, null, null, null, null, null, null, null, null);
insert into TBLMENU_B (MENUCODE, MDLCODE, PMENUCODE, MENUDESC, MENUSEQ, MENUTYPE, MUSER, MDATE, MTIME, EATTRIBUTE1, VISIBILITY, CUSER, CDATE, CTIME, EATTRIBUTE2, EATTRIBUTE3, EATTRIBUTE4, EATTRIBUTE5, EATTRIBUTE6, EATTRIBUTE7, EATTRIBUTE8, EATTRIBUTE9, EATTRIBUTE10)
values ('生产线排班', 'SSPLAN', '01:生产线排班', '生产线排班', 30, 'B/S', 'SYS', 20080710, 85900, null, '0', 'SYS', 0, 0, null, null, null, null, null, null, null, null, null);
insert into TBLMENU_B (MENUCODE, MDLCODE, PMENUCODE, MENUDESC, MENUSEQ, MENUTYPE, MUSER, MDATE, MTIME, EATTRIBUTE1, VISIBILITY, CUSER, CDATE, CTIME, EATTRIBUTE2, EATTRIBUTE3, EATTRIBUTE4, EATTRIBUTE5, EATTRIBUTE6, EATTRIBUTE7, EATTRIBUTE8, EATTRIBUTE9, EATTRIBUTE10)
values ('返修基本资料', null, '基础设置用户组', '返修基本资料', 70, 'B/S', 'SYS', 20080710, 134543, null, '0', 'SYS', 0, 0, null, null, null, null, null, null, null, null, null);
insert into TBLMENU_B (MENUCODE, MDLCODE, PMENUCODE, MENUDESC, MENUSEQ, MENUTYPE, MUSER, MDATE, MTIME, EATTRIBUTE1, VISIBILITY, CUSER, CDATE, CTIME, EATTRIBUTE2, EATTRIBUTE3, EATTRIBUTE4, EATTRIBUTE5, EATTRIBUTE6, EATTRIBUTE7, EATTRIBUTE8, EATTRIBUTE9, EATTRIBUTE10)
values ('返修集成作业', null, '生产采集', '返修集成作业', 40, 'C/S', 'SYS', 20080730, 155446, null, '0', 'SYS', 0, 0, null, null, null, null, null, null, null, null, null);
insert into TBLMENU_B (MENUCODE, MDLCODE, PMENUCODE, MENUDESC, MENUSEQ, MENUTYPE, MUSER, MDATE, MTIME, EATTRIBUTE1, VISIBILITY, CUSER, CDATE, CTIME, EATTRIBUTE2, EATTRIBUTE3, EATTRIBUTE4, EATTRIBUTE5, EATTRIBUTE6, EATTRIBUTE7, EATTRIBUTE8, EATTRIBUTE9, EATTRIBUTE10)
values ('员工信息维护', 'EMPMTSET', '基础设置用户组', '员工信息维护', 80, 'B/S', 'SYS', 0, 0, null, '0', 'SYS', 0, 0, null, null, null, null, null, null, null, null, null);
insert into TBLMENU_B (MENUCODE, MDLCODE, PMENUCODE, MENUDESC, MENUSEQ, MENUTYPE, MUSER, MDATE, MTIME, EATTRIBUTE1, VISIBILITY, CUSER, CDATE, CTIME, EATTRIBUTE2, EATTRIBUTE3, EATTRIBUTE4, EATTRIBUTE5, EATTRIBUTE6, EATTRIBUTE7, EATTRIBUTE8, EATTRIBUTE9, EATTRIBUTE10)
values ('尾数管理', 'MORESIDUAL', '01:尾数管理', '尾数管理', 40, 'B/S', 'SYS', 20080710, 85913, null, '0', 'SYS', 0, 0, null, null, null, null, null, null, null, null, null);
insert into TBLMENU_B (MENUCODE, MDLCODE, PMENUCODE, MENUDESC, MENUSEQ, MENUTYPE, MUSER, MDATE, MTIME, EATTRIBUTE1, VISIBILITY, CUSER, CDATE, CTIME, EATTRIBUTE2, EATTRIBUTE3, EATTRIBUTE4, EATTRIBUTE5, EATTRIBUTE6, EATTRIBUTE7, EATTRIBUTE8, EATTRIBUTE9, EATTRIBUTE10)
values ('库存组织物料维护', 'BASEMATERIALTYPE', '基础设置用户组', '库存组织物料维护', 50, 'B/S', 'SYS', 0, 0, null, '0', 'SYS', 0, 0, null, null, null, null, null, null, null, null, null);
insert into TBLMENU_B (MENUCODE, MDLCODE, PMENUCODE, MENUDESC, MENUSEQ, MENUTYPE, MUSER, MDATE, MTIME, EATTRIBUTE1, VISIBILITY, CUSER, CDATE, CTIME, EATTRIBUTE2, EATTRIBUTE3, EATTRIBUTE4, EATTRIBUTE5, EATTRIBUTE6, EATTRIBUTE7, EATTRIBUTE8, EATTRIBUTE9, EATTRIBUTE10)
values ('手工报检', 'IQCREQUEST', 'IQC管理', '手工报检', 1, 'B/S', 'SYS', 0, 0, null, '0', 'SYS', 0, 0, null, null, null, null, null, null, null, null, null);
insert into TBLMENU_B (MENUCODE, MDLCODE, PMENUCODE, MENUDESC, MENUSEQ, MENUTYPE, MUSER, MDATE, MTIME, EATTRIBUTE1, VISIBILITY, CUSER, CDATE, CTIME, EATTRIBUTE2, EATTRIBUTE3, EATTRIBUTE4, EATTRIBUTE5, EATTRIBUTE6, EATTRIBUTE7, EATTRIBUTE8, EATTRIBUTE9, EATTRIBUTE10)
values ('标准工艺路线', 'STANDARD ROUTE', '基础设置用户组', '工艺路线定义', 30, 'B/S', 'SYS', 0, 0, null, '0', 'SYS', 0, 0, null, null, null, null, null, null, null, null, null);
insert into TBLMENU_B (MENUCODE, MDLCODE, PMENUCODE, MENUDESC, MENUSEQ, MENUTYPE, MUSER, MDATE, MTIME, EATTRIBUTE1, VISIBILITY, CUSER, CDATE, CTIME, EATTRIBUTE2, EATTRIBUTE3, EATTRIBUTE4, EATTRIBUTE5, EATTRIBUTE6, EATTRIBUTE7, EATTRIBUTE8, EATTRIBUTE9, EATTRIBUTE10)
values ('检验周期查询', 'CHECKEDCYCLE', '质量基础数据', '检验周期查询', 7, 'B/S', 'SYS', 0, 0, null, '0', 'SYS', 0, 0, null, null, null, null, null, null, null, null, null);
insert into TBLMENU_B (MENUCODE, MDLCODE, PMENUCODE, MENUDESC, MENUSEQ, MENUTYPE, MUSER, MDATE, MTIME, EATTRIBUTE1, VISIBILITY, CUSER, CDATE, CTIME, EATTRIBUTE2, EATTRIBUTE3, EATTRIBUTE4, EATTRIBUTE5, EATTRIBUTE6, EATTRIBUTE7, EATTRIBUTE8, EATTRIBUTE9, EATTRIBUTE10)
values ('进货检验单管理', 'IQCTICKET', 'IQC管理', '进货检验单管理', 3, 'B/S', 'SYS', 0, 0, null, '0', 'SYS', 0, 0, null, null, null, null, null, null, null, null, null);
insert into TBLMENU_B (MENUCODE, MDLCODE, PMENUCODE, MENUDESC, MENUSEQ, MENUTYPE, MUSER, MDATE, MTIME, EATTRIBUTE1, VISIBILITY, CUSER, CDATE, CTIME, EATTRIBUTE2, EATTRIBUTE3, EATTRIBUTE4, EATTRIBUTE5, EATTRIBUTE6, EATTRIBUTE7, EATTRIBUTE8, EATTRIBUTE9, EATTRIBUTE10)
values ('物料批次信息查询', 'RECITEMINFO', '过程追溯', '物料批次信息查询', 45, 'B/S', 'SYS', 0, 0, null, '0', 'SYS', 0, 0, null, null, null, null, null, null, null, null, null);
insert into TBLMENU_B (MENUCODE, MDLCODE,
没有合适的资源?快使用搜索试试~ 我知道了~
java+js 经典菜单源代码下载
共19个文件
js:7个
gif:4个
bak:3个
需积分: 9 35 下载量 55 浏览量
2008-11-10
09:29:48
上传
评论 1
收藏 61KB RAR 举报
温馨提示
经典菜单源代码,包括创建数据库脚本和整个工程
资源推荐
资源详情
资源评论
收起资源包目录
menu.rar (19个子文件)
table.sql 166KB
menu
Image
TreeMenu
child.gif 48B
blank.gif 43B
opened.gif 83B
closed.gif 85B
menu.html 3KB
JS
calendar_ZH_CN_UTF-8.js 5KB
TreeMenu.js.bak 2KB
calendar.js 48KB
calendar-setup.js 9KB
TreeMenu.js 2KB
xajax.js 16KB
overlib.js 36KB
Main.js 36KB
Css
Basic.css 14KB
TreeMenu.css 873B
Basic.css.bak 0B
menu.html.bak 3KB
复件 menu.html 34KB
共 19 条
- 1
资源评论
lovealo
- 粉丝: 1
- 资源: 11
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功