import.sql

来自「anewssystem新闻发布系统集成使用了spring hibernate f」· SQL 代码 · 共 166 行 · 第 1/2 页

insert into A_NEWS_CATEGORY(id,bit_code,char_code,name,status,the_sort,parent_id) values(1,72057594037927936,'null','地方新闻',null,0,null);
insert into A_NEWS_CATEGORY(id,bit_code,char_code,name,status,the_sort,parent_id) values(2,72339069014638592,'null','河北新闻',null,1,1);
insert into A_NEWS_CATEGORY(id,bit_code,char_code,name,status,the_sort,parent_id) values(3,72340168526266368,'null','唐山新闻',null,2,2);

insert into A_NEWS(id,content,editor,hit,image,link,name,source,status,subtitle,summary,update_date,category_id) values(1,'dd','',null,'','/anews/html/3/2007/09/17/1.html','dd','【本站原创】',2,'ddd','dd','2007-09-17 00:00:00.000000000',3);
insert into A_NEWS(id,content,editor,hit,image,link,name,source,status,subtitle,summary,update_date,category_id) values(2,'sadf','',null,'','/anews/html/2/2007/10/06/2.html','tt','【本站原创】',3,'est','tset','2007-10-06 00:00:00.000000000',1);
insert into A_NEWS(id,content,editor,hit,image,link,name,source,status,subtitle,summary,update_date,category_id) values(3,' 654','',null,'null','','1454','【本站原创】',null,'45','4541','2007-10-06 00:00:00.000000000',null);
insert into A_NEWS(id,content,editor,hit,image,link,name,source,status,subtitle,summary,update_date,category_id) values(4,' 54','',null,'null','','12','【本站原创】',null,'1','564','2007-10-06 00:00:00.000000000',null);
insert into A_NEWS(id,content,editor,hit,image,link,name,source,status,subtitle,summary,update_date,category_id) values(5,' 656','',null,'null','','6','【本站原创】',3,'54','54','2007-10-06 00:00:00.000000000',1);
insert into A_NEWS(id,content,editor,hit,image,link,name,source,status,subtitle,summary,update_date,category_id) values(6,' 唐山特别特别好','',null,'null','/anews/html/3/2007/10/12/6.html','唐山好','【本站原创】',3,'唐山很好','唐山特别好','2007-10-12 00:00:00.000000000',3);
insert into A_NEWS(id,content,editor,hit,image,link,name,source,status,subtitle,summary,update_date,category_id) values(7,' tse','临远',null,'null','/anews/html/3/2007/10/12/7.html','test','【本站原创】',3,'tset','tset','2007-10-12 00:00:00.000000000',3);

insert into A_NEWS_CONFIG(id,category_strategy,comment_need_audit,could_comment,news_need_audit,template_name) values(1,0,0,0,0,'extjs');

insert into A_NEWS_TAG(id,name,the_sort) values(2,'222',null);
insert into A_NEWS_TAG(id,name,the_sort) values(3,'2',null);
insert into A_NEWS_TAG(id,name,the_sort) values(4,'444',null);
insert into A_NEWS_TAG(id,name,the_sort) values(5,'test',null);

insert into A_NEWS_NEWSTAG(newstag_id,news_id) values(2,2);
insert into A_NEWS_NEWSTAG(newstag_id,news_id) values(3,2);
insert into A_NEWS_NEWSTAG(newstag_id,news_id) values(4,2);
insert into A_NEWS_NEWSTAG(newstag_id,news_id) values(5,7);

insert into A_SECURITY_DEPT(id,descn,name,the_sort,parent_id) values(1,'','技术部',0,null);
insert into A_SECURITY_DEPT(id,descn,name,the_sort,parent_id) values(2,'市场','市场部',4,null);
insert into A_SECURITY_DEPT(id,descn,name,the_sort,parent_id) values(3,'销售的部门，卖不出去可不行啊','销售部',5,null);
insert into A_SECURITY_DEPT(id,descn,name,the_sort,parent_id) values(4,'null','研发部',2,1);
insert into A_SECURITY_DEPT(id,descn,name,the_sort,parent_id) values(5,'','产品部',1,1);

insert into A_SECURITY_MENU(id,descn,url,image,name,the_sort,qtip,parent_id) values(44,'11','./','set.gif','sandbox',13,'1',null);
insert into A_SECURITY_MENU(id,descn,url,image,name,the_sort,qtip,parent_id) values(45,'','../newstag2/dialogManage.htm','user.gif','体验dialog',24,'',44);
insert into A_SECURITY_MENU(id,descn,url,image,name,the_sort,qtip,parent_id) values(46,'','../newstag2/inlineManage.htm','user.gif','体验editor',23,'',44);
insert into A_SECURITY_MENU(id,descn,url,image,name,the_sort,qtip,parent_id) values(47,'','./','set.gif','新闻发布',0,'',null);
insert into A_SECURITY_MENU(id,descn,url,image,name,the_sort,qtip,parent_id) values(48,'','../newscategory/index.htm','user.gif','新闻分类管理',2,'',47);
insert into A_SECURITY_MENU(id,descn,url,image,name,the_sort,qtip,parent_id) values(50,'管理新闻','../news/index.htm','user.gif','管理新闻',3,'管理新闻',47);
insert into A_SECURITY_MENU(id,descn,url,image,name,the_sort,qtip,parent_id) values(52,'','../newstag/index.htm','user.gif','管理关键字',4,'',47);
insert into A_SECURITY_MENU(id,descn,url,image,name,the_sort,qtip,parent_id) values(53,'新闻属性设置','../newsconfig/index.htm','user.gif','新闻属性设置',5,'新闻属性设置',47);
insert into A_SECURITY_MENU(id,descn,url,image,name,the_sort,qtip,parent_id) values(54,'','../template/dd.htm','user.gif','设置模板',22,'',44);
insert into A_SECURITY_MENU(id,descn,url,image,name,the_sort,qtip,parent_id) values(56,'','./','set.gif','权限设置',6,'',null);
insert into A_SECURITY_MENU(id,descn,url,image,name,the_sort,qtip,parent_id) values(57,'','../user/index.htm','user.gif','管理用户',12,'',56);
insert into A_SECURITY_MENU(id,descn,url,image,name,the_sort,qtip,parent_id) values(58,'','../resource/index.htm','user.gif','管理资源',11,'',56);
insert into A_SECURITY_MENU(id,descn,url,image,name,the_sort,qtip,parent_id) values(59,'','../role/index.htm','user.gif','管理角色',10,'',56);
insert into A_SECURITY_MENU(id,descn,url,image,name,the_sort,qtip,parent_id) values(60,'','../menu/index.htm','user.gif','管理菜单',7,'',56);
insert into A_SECURITY_MENU(id,descn,url,image,name,the_sort,qtip,parent_id) values(61,'','../sandbox/datagrid.htm','user.gif','DataGrid',21,'',44);
insert into A_SECURITY_MENU(id,descn,url,image,name,the_sort,qtip,parent_id) values(62,'部门','../dept/index.htm','user.gif','管理部门',8,'部门',56);
insert into A_SECURITY_MENU(id,descn,url,image,name,the_sort,qtip,parent_id) values(63,'','../widgets/lingo/jsontree/Ext.lingo.JsonTree.html','user.gif','Ext.lingo.JsonTree',19,'',44);
insert into A_SECURITY_MENU(id,descn,url,image,name,the_sort,qtip,parent_id) values(64,'','../widgets/lingo/jsongrid/Ext.lingo.JsonGrid.html','user.gif','Ext.lingo.JsonGrid',18,'',44);
insert into A_SECURITY_MENU(id,descn,url,image,name,the_sort,qtip,parent_id) values(65,'带选择框的树','../widgets/lingo/checkboxtree/checkboxtree.html','user.gif','CheckBoxTree',20,'带选择框的树',44);
insert into A_SECURITY_MENU(id,descn,url,image,name,the_sort,qtip,parent_id) values(66,'两个表格间拖动','../widgets/lingo/form/ddgrid.html','user.gif','grid拖拽',17,'两个表格间拖动',44);
insert into A_SECURITY_MENU(id,descn,url,image,name,the_sort,qtip,parent_id) values(67,'切换输入框','../widgets/lingo/form/switchField.html','user.gif','切换输入框',16,'切换输入框',44);
insert into A_SECURITY_MENU(id,descn,url,image,name,the_sort,qtip,parent_id) values(68,'tree与grid拖拽','../widgets/lingo/form/ddtree2.html','user.gif','tree与grid拖拽',26,'tree与grid拖拽',44);
insert into A_SECURITY_MENU(id,descn,url,image,name,the_sort,qtip,parent_id) values(69,'tree与grid拖拽，不知道为啥失败','../widgets/lingo/form/ddtree.html','user.gif','tree与grid拖拽，不知道为啥失败',25,'tree与grid拖拽，不知道为啥失败',44);
insert into A_SECURITY_MENU(id,descn,url,image,name,the_sort,qtip,parent_id) values(70,'组织结构图','../dept/orgmap.htm','user.gif','组织结构图',9,'组织结构图',56);
insert into A_SECURITY_MENU(id,descn,url,image,name,the_sort,qtip,parent_id) values(71,'树形下拉框','../widgets/lingo/form/treeField.html','user.gif','树形下拉框',15,'树形下拉框',44);
insert into A_SECURITY_MENU(id,descn,url,image,name,the_sort,qtip,parent_id) values(72,'级联combobox','../widgets/lingo/form/room.html','user.gif','级联combobox',14,'级联combobox',44);
insert into A_SECURITY_MENU(id,descn,url,image,name,the_sort,qtip,parent_id) values(73,'审核新闻','../news/manage.htm','user.gif','审核新闻',1,'审核新闻',47);

insert into A_SECURITY_RESOURCE(id,descn,name,res_string,res_type) values(2,'后台管理','admin','/admin/**','URL');
insert into A_SECURITY_RESOURCE(id,descn,name,res_string,res_type) values(3,'资源管理','resource','/resource/**','URL');
insert into A_SECURITY_RESOURCE(id,descn,name,res_string,res_type) values(4,'用户管理','user','/user/**','URL');
insert into A_SECURITY_RESOURCE(id,descn,name,res_string,res_type) values(5,'角色管理','role','/role/**','URL');
insert into A_SECURITY_RESOURCE(id,descn,name,res_string,res_type) values(6,'菜单管理','menu','/menu/**','URL');
insert into A_SECURITY_RESOURCE(id,descn,name,res_string,res_type) values(7,'部门管理','dept','/dept/**','URL');

insert into A_SECURITY_ROLE(id,descn,name) values(2,'管理员','ROLE_ADMIN');
insert into A_SECURITY_ROLE(id,descn,name) values(3,'用户','ROLE_USER');
insert into A_SECURITY_ROLE(id,descn,name) values(4,'测试用户','ROLE_TEST');

insert into A_SECURITY_USER(id,birthday,code,descn,duty,email,mobile,password,sex,status,tel,truename,username,dept_id) values(22,'2007-09-23 00:00:00.000000000','null','test','无','[e-mail]','11111111111','098f6bcd4621d373cade4e832627b4f6','0','0','111111','test','test2',1);
insert into A_SECURITY_USER(id,birthday,code,descn,duty,email,mobile,password,sex,status,tel,truename,username,dept_id) values(23,'2007-09-27 00:00:00.000000000','null','test','sdf','test','sdfasdf','098f6bcd4621d373cade4e832627b4f6','0','0','asdfasdf','afdasdf','test1',3);
insert into A_SECURITY_USER(id,birthday,code,descn,duty,email,mobile,password,sex,status,tel,truename,username,dept_id) values(27,'2007-09-27 00:00:00.000000000','null','销售部的aaa','aa','aa','aaa','aa','0','0','d','aaa','aaa',3);
insert into A_SECURITY_USER(id,birthday,code,descn,duty,email,mobile,password,sex,status,tel,truename,username,dept_id) values(28,'2007-09-27 00:00:00.000000000','null','','222','222','22','2222222','1','0','222','22222','122222',5);
insert into A_SECURITY_USER(id,birthday,code,descn,duty,email,mobile,password,sex,status,tel,truename,username,dept_id) values(29,'2007-09-27 00:00:00.000000000','null','test','tset','test','test','098f6bcd4621d373cade4e832627b4f6','0','1','test','临远','test',1);
insert into A_SECURITY_USER(id,birthday,code,descn,duty,email,mobile,password,sex,status,tel,truename,username,dept_id) values(30,'2007-09-28 00:00:00.000000000','null','小兵','小兵','[e-mail]','11111111111','ee11cbb19052e40b07aac0ca060c23ee','null','1','11111111','user','user',2);

insert into A_SECURITY_RESOURCE_ROLE(resource_id,role_id) values(2,2);
insert into A_SECURITY_RESOURCE_ROLE(resource_id,role_id) values(3,2);
insert into A_SECURITY_RESOURCE_ROLE(resource_id,role_id) values(4,2);
insert into A_SECURITY_RESOURCE_ROLE(resource_id,role_id) values(5,2);
insert into A_SECURITY_RESOURCE_ROLE(resource_id,role_id) values(7,2);
insert into A_SECURITY_RESOURCE_ROLE(resource_id,role_id) values(2,4);
insert into A_SECURITY_RESOURCE_ROLE(resource_id,role_id) values(3,4);