【SQL开源代码栏目提醒】:网学会员在SQL开源代码频道为大家收集整理了006_create_menu.sql提供大家参考,希望对大家有所帮助!
CREATE TABLE T_MENU(
ID BIGINT,
NAME VARCHAR(100),
IMAGE VARCHAR(100),
URL VARCHAR(100),
QTIP VARCHAR(100),
SORT_NUM INTEGER,
PARENT_ID BIGINT,
DESCRIPTION VARCHAR(200)
);
ALTER TABLE T_MENU ADD CONSTRAINT PK_MENU PRIMARY KEY(ID);
ALTER TABLE T_MENU ALTER COLUMN ID BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1);
ALTER TABLE T_MENU ADD CONSTRAINT FK_MENU FOREIGN KEY(PARENT_ID) REFERENCES T_MENU(ID);
INSERT INTO T_MENU(ID,NAME,IMAGE,URL,QTIP,SORT_NUM,PARENT_ID,DESCRIPTION) VALUES(1,'进仓管理','images/plugin.gif','StoreIn','进仓管理',1,NULL,'进仓管理');
INSERT INTO T_MENU(ID,NAME,IMAGE,URL,QTIP,SORT_NUM,PARENT_ID,DESCRIPTION) VALUES(5,'出仓管理','images/plugin.gif','StoreOut','出仓管理',2,NULL,'出仓管理');
INSERT INTO T_MENU(ID,NAME,IMAGE,URL,QTIP,SORT_NUM,PARENT_ID,DESCRIPTION) VALUES(7,'产品管理','images/plugin.gif','Products','产品管理',3,NULL,'产品管理');
INSERT INTO T_MENU(ID,NAME,IMAGE,URL,QTIP,SORT_NUM,PARENT_ID,DESCRIPTION) VALUES(8,'系统维护','images/plugin.gif','System','
系统维护',5,NULL,'系统维护');
INSERT INTO T_MENU(ID,NAME,IMAGE,URL,QTIP,SORT_NUM,PARENT_ID,DESCRIPTION) VALUES(10,'进仓单','images/plugin.gif','In','进仓单',1,1,'进仓单');
INSERT INTO T_MENU(ID,NAME,IMAGE,URL,QTIP,SORT_NUM,PARENT_ID,DESCRIPTION) VALUES(11,'出仓单','images/plugin.gif','Out','出仓单',1,5,'出仓单');
INSERT INTO T_MENU(ID,NAME,IMAGE,URL,QTIP,SORT_NUM,PARENT_ID,DESCRIPTION) VALUES(12,'查看产品','images/plugin.gif','Product','查看产品',1,7,'查看产品');
INSERT INTO T_MENU(ID,NAME,IMAGE,URL,QTIP,SORT_NUM,PARENT_ID,DESCRIPTION) VALUES(13,'用户管理','images/plugin.gif','User','用户管理',1,8,'用户管理');
INSERT INTO T_MENU(ID,NAME,IMAGE,URL,QTIP,SORT_NUM,PARENT_ID,DESCRIPTION) VALUES(14,'角色管理','images/plugin.gif','Role','角色管理',1,8,'角色管理');
INSERT INTO T_MENU(ID,NAME,IMAGE,URL,QTIP,SORT_NUM,PARENT_ID,DESCRIPTION) VALUES(15,'统计功能','images/plugin.gif','Statistic','统计功能',4,NULL,'统计功能');
INSERT INTO T_MENU(ID,NAME,IMAGE,URL,QTIP,SORT_NUM,PARENT_ID,DESCRIPTION) VALUES(18,'库存统计','images/plugin.gif','Stat','库存统计',3,15,'库存统计');
--//@UNDO
DROP TABLE T_MENU;