Intpub —— DB design

/* MySQL Backup Source Server Version: 5.1.50 Source Database: IntpubDB Date: 2012-04-13 23:03:21 */ CREATE database IntpubDB; USE IntpubDB; CREATE USER 'intpub'@'127.0.0.1' IDENTIFIED BY 'intpub'; GRANT USAGE ON IntpubDB.* TO 'intpub'@'127.0.0.1' WITH MAX_QUERIES_PER_HOUR 20 MAX_UPDATES_PER_HOUR 20 MAX_CONNECTIONS_PER_HOUR 20 MAX_USER_CONNECTIONS 50; GRANT SELECT, INSERT, UPDATE, REFERENCES, DELETE, CREATE, DROP, ALTER, INDEX, TRIGGER, CREATE VIEW, SHOW VIEW, EXECUTE, ALTER ROUTINE, CREATE ROUTINE, CREATE TEMPORARY TABLES, LOCK TABLES, EVENT ON `IntpubDB`.* TO 'intpub'@'127.0.0.1'; GRANT GRANT OPTION ON `intpub`.* TO 'intpub'@'127.0.0.1'; SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `intpub_menu` -- ---------------------------- DROP TABLE IF EXISTS `intpub_menu`; CREATE TABLE `intpub_menu` ( `menuCode` int(11) NOT NULL, `menuName` varchar(20) NOT NULL, `menuURL` varchar(20) DEFAULT NULL, `parentCode` int(11) DEFAULT NULL, `sort` int(11) DEFAULT NULL, `createby` varchar(20) DEFAULT NULL, `createdate` varchar(20) DEFAULT NULL, `updateby` varchar(20) DEFAULT NULL, `updatedate` varchar(20) DEFAULT NULL, PRIMARY KEY (`menuCode`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for `intpub_menu_role` -- ---------------------------- DROP TABLE IF EXISTS `intpub_menu_role`; CREATE TABLE `intpub_menu_role` ( `menuCode` int(11) NOT NULL, `roleCode` int(11) NOT NULL, `parentCode` int(11) DEFAULT NULL, `menuName` varchar(20) DEFAULT NULL, PRIMARY KEY (`menuCode`,`roleCode`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for `intpub_moudle` -- ---------------------------- DROP TABLE IF EXISTS `intpub_moudle`; CREATE TABLE `intpub_moudle` ( `moudleCode` int(11) NOT NULL, `moudleName` varchar(20) NOT NULL, `status` int(11) NOT NULL,-- 1:display 2:hidden 3:deleted `profile` varchar(2000) DEFAULT NULL, `amount` int(11) DEFAULT NULL, `displayLen` int(11) DEFAULT NULL, `createby` varchar(20) DEFAULT NULL, `createdate` varchar(20) DEFAULT NULL, `updateby` varchar(20) DEFAULT NULL, `updatedate` varchar(20) DEFAULT NULL, PRIMARY KEY (`moudleCode`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for `intpub_moudle_part` -- ---------------------------- DROP TABLE IF EXISTS `intpub_moudle_part`; CREATE TABLE `intpub_moudle_part` ( `MODULECODE` int(11) NOT NULL, `PARTCODE` varchar(20) NOT NULL, PRIMARY KEY (`MODULECODE`,`PARTCODE`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for `intpub_part` -- ---------------------------- DROP TABLE IF EXISTS `intpub_part`; CREATE TABLE `intpub_part` ( `partCode` int(11) NOT NULL, `partName` varchar(20) NOT NULL, `status` int(11) NOT NULL, `backup` varchar(20) DEFAULT NULL, `sort` int(11) DEFAULT NULL, `createby` varchar(20) DEFAULT NULL, `createdate` varchar(20) DEFAULT NULL, `updateby` varchar(20) DEFAULT NULL, `updatedate` varchar(20) DEFAULT NULL, PRIMARY KEY (`partCode`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for `intpub_role` -- ---------------------------- DROP TABLE IF EXISTS `intpub_role`; CREATE TABLE `intpub_role` ( `roleCode` int(11) NOT NULL, `status` int(11) NOT NULL, `roleName` int(11) DEFAULT NULL, `createby` varchar(20) DEFAULT NULL, `createdate` varchar(20) DEFAULT NULL, `updateby` varchar(20) DEFAULT NULL, `updatedate` varchar(20) DEFAULT NULL, PRIMARY KEY (`roleCode`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for `intpub_user` -- ---------------------------- DROP TABLE IF EXISTS `intpub_user`; CREATE TABLE `intpub_user` ( `userCode` int(11) NOT NULL, `userid` varchar(20) NOT NULL, `password` varchar(20) NOT NULL, `username` varchar(20) NOT NULL, `status` int(11) NOT NULL, `rolecode` int(11) DEFAULT NULL, `createby` varchar(20) DEFAULT NULL, `createdate` varchar(20) DEFAULT NULL, `updateby` varchar(20) DEFAULT NULL, `updatedate` varchar(20) DEFAULT NULL, PRIMARY KEY (`userCode`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE `intpub_info` ( `infoId` int(11) NOT NULL , `code` int(11) NOT NULL , `title` varchar(50) NOT NULL , `content` varchar(2000) DEFAULT NULL , `publishTime` varchar(20) DEFAULT NULL , `status` int(2) NOT NULL , `createby` varchar(20) DEFAULT NULL , `createdate` varchar(20) DEFAULT NULL , `updateby` varchar(20) DEFAULT NULL , `updatedate` varchar(20) DEFAULT NULL , PRIMARY KEY (`infoId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records -- ----------------------------