20170822-init-branch-office.sql 2.5 KB

123456789101112131415161718192021222324252627282930313233
  1. #创建分公司管理表
  2. create table branch_office_info(
  3. id int(4) primary key auto_increment,
  4. name varchar(32) comment '分公司名字',
  5. website varchar(32) not null comment '分公司网络地址',
  6. contact_number varchar(11) comment '联系号码',
  7. contact_address varchar(64) comment '联系地址',
  8. logo_img varchar(64) comment 'LOGO图片',
  9. qr_img varchar(64) comment '二维码图片',
  10. province_id int(4) not null comment '所属省份'
  11. );
  12. #初始化数据
  13. insert into branch_office_info values(1,'南昌科德','nckd.jishutao.com',null,null,null,null,26);
  14. insert into branch_office_info values(2,'福州科宇','fzky.jishutao.com',null,null,null,null,25);
  15. insert into branch_office_info values(3,'贵州科德','gzkd.jishutao.com',null,null,null,null,6);
  16. insert into branch_office_info values(4,'大连科德','dlkd.jishutao.com',null,null,null,null,28);
  17. insert into branch_office_info values(5,'广州科中','gzkz.jishutao.com',null,null,null,null,12);
  18. insert into branch_office_info values(6,'河南科德','hnkd.jishutao.com',null,null,null,null,9);
  19. insert into branch_office_info values(7,'昆明科道','kmkd.jishutao.com',null,null,null,null,7);
  20. insert into branch_office_info values(8,'石家庄科中','sjzkz.jishutao.com',null,null,null,null,19);
  21. insert into branch_office_info values(9,'青岛科德','qdkd.jishutao.com',null,null,null,null,27);
  22. insert into branch_office_info values(10,'长春科德','cckd.jishutao.com',null,null,null,null,29);
  23. insert into branch_office_info values(11,'广州科丰','gzkf.jishutao.com',null,null,null,null,12);
  24. insert into branch_office_info values(12,'北京科德','bjkd.jishutao.com',null,null,null,null,1);
  25. insert into branch_office_info values(13,'山东科德','sdkd.jishutao.com',null,null,null,null,27);
  26. insert into branch_office_info values(14,'江苏科德','jskd.jishutao.com',null,null,null,null,22);
  27. insert into branch_office_info values(15,'武汉科汇','whkh.jishutao.com',null,null,null,null,10);
  28. insert into branch_office_info values(16,'合肥科稻','hfkd.jishutao.com',null,null,null,null,24);
  29. insert into branch_office_info values(17,'成都科德','cdkd.jishutao.com',null,null,null,null,5);
  30. insert into branch_office_info values(18,'内蒙古科发','nmgkf.jishutao.com',null,null,null,null,21);
  31. insert into branch_office_info values(19,'南宁科发','nnkf.jishutao.com',null,null,null,null,13);
  32. insert into branch_office_info values(20,'沈阳科德','sykd.jishutao.com',null,null,null,null,28);
  33. insert into branch_office_info values(21,'湖南科德','www.jishutao.com',null,null,null,null,11);