1, mysql -uroot -pxxxx //登陆数据库 2, show databases; //查看数据库,例如要在test库中建表 3, use test;//进入test 4, create table users（ //例如要建立users表,下面是建立字段 5, id int(10) unsigned not null auto_increment, 6, username varchar(20) not null, 7, userpassword varchar(20) not null, 8, email varchar(20) not null, 9, primary key (id));//这样就建立好了一个基本完整的表了在昨天所有配置环境搭建好后，开始把已有的sql表中的语句摘出来，建立表。此建表过程是从进入数据库开始的。<pre name="code" class="sql">/* Navicat MySQL Data Transfer Source Server : localhost Source Server Version : 50703 Source Host : localhost Source Database : zratest Target Server Type : MYSQL Target Server Version : 50703 File Encoding : 65001 Date: 2014-08-29 19:54:39 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `fhousetypeimg` -- ---------------------------- DROP TABLE IF EXISTS `fhousetypeimg`; CREATE TABLE `fhousetypeimg` ( `fid` varchar(50) NOT NULL DEFAULT '' COMMENT '主键', `housetypeid` varchar(50) DEFAULT '' COMMENT '外键户型id', `fhouseimage` blob COMMENT '房景图', `fimgdesc` text COMMENT '房景图描述', `projectid` varchar(50) DEFAULT '' COMMENT '项目ID', `cityid` varchar(50) DEFAULT 'BJ' COMMENT '城市ID', `fvalid` int(1) DEFAULT NULL, `fcreateime` datetime DEFAULT NULL, `createrid` varchar(50) DEFAULT NULL, `fupdatetime` datetime DEFAULT NULL, `updaterid` varchar(50) DEFAULT NULL, PRIMARY KEY (`fid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of fhousetypeimg -- ---------------------------- -- ---------------------------- -- Table structure for `tbuildinginfo` -- ---------------------------- DROP TABLE IF EXISTS `tbuildinginfo`; CREATE TABLE `tbuildinginfo` ( `fid` varchar(50) NOT NULL DEFAULT '' COMMENT '主键', `projectid` varchar(50) DEFAULT NULL COMMENT '项目ID', `fbuildingname` varchar(500) DEFAULT NULL COMMENT '楼栋名称', `fdirection` varchar(50) DEFAULT NULL COMMENT '朝向', `ffloornumber` int(11) DEFAULT NULL COMMENT '楼栋层数', `froomnumber` int(11) DEFAULT NULL COMMENT '楼栋房间数', `fbuildingarea` double DEFAULT NULL COMMENT '楼栋建筑面积', `foutsidearea` double DEFAULT NULL COMMENT '楼栋外墙面积', `felevatornumber` int(11) DEFAULT NULL COMMENT '电梯数', `cityid` varchar(50) DEFAULT NULL COMMENT '公司ID', `fvalid` int(1) DEFAULT NULL, `fcreateime` datetime DEFAULT NULL, `createrid` varchar(50) DEFAULT NULL, `fupdatetime` datetime DEFAULT NULL, `updaterid` varchar(50) DEFAULT NULL, PRIMARY KEY (`fid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of tbuildinginfo -- ---------------------------- -- ---------------------------- -- Table structure for `tcompany` -- ---------------------------- DROP TABLE IF EXISTS `tcompany`; CREATE TABLE `tcompany` ( `fid` varchar(50) NOT NULL COMMENT '主键', `fname` varchar(100) DEFAULT NULL, `fnameab` varchar(100) DEFAULT NULL, `fhint` varchar(10) DEFAULT NULL, `flinkman` varchar(30) DEFAULT NULL, `ftelno` varchar(30) DEFAULT NULL, `ffaxno` varchar(30) DEFAULT NULL, `faddress` varchar(100) DEFAULT NULL, `fzipcode` varchar(6) DEFAULT NULL, `fhttpaddress` varchar(50) DEFAULT NULL, `femail` varchar(50) DEFAULT NULL, `flogo` tinyblob, `dftmenuid` varchar(255) DEFAULT NULL, `fvalid` int(1) DEFAULT NULL, `createrid` varchar(50) DEFAULT NULL, `fcreatetime` datetime DEFAULT NULL, `updaterid` varchar(50) DEFAULT NULL, `fupdatetime` datetime DEFAULT NULL, PRIMARY KEY (`fid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of tcompany -- ---------------------------- -- ---------------------------- -- Table structure for `tdepartment` -- ---------------------------- DROP TABLE IF EXISTS `tdepartment`; CREATE TABLE `tdepartment` ( `fid` varchar(50) NOT NULL, `faddress` varchar(200) DEFAULT NULL, `fcompanyid` varchar(50) DEFAULT NULL, `fhint` varchar(10) DEFAULT NULL, `fname` varchar(30) DEFAULT NULL, `fresponsibility` varchar(150) DEFAULT NULL, `ftelno` varchar(50) DEFAULT NULL, `mainpostid` varchar(50) DEFAULT NULL, `deptid` varchar(50) DEFAULT NULL, `fvalid` int(1) DEFAULT NULL, `fcreateime` datetime DEFAULT NULL, `createrid` varchar(50) DEFAULT NULL, `fupdatetime` datetime DEFAULT NULL, `updaterid` varchar(50) DEFAULT NULL, PRIMARY KEY (`fid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of tdepartment -- ---------------------------- -- ---------------------------- -- Table structure for `tdeptstg` -- ---------------------------- DROP TABLE IF EXISTS `tdeptstg`; CREATE TABLE `tdeptstg` ( `fid` varchar(50) NOT NULL, `structureid` varchar(50) DEFAULT NULL, `fleaf` int(1) DEFAULT NULL, `hl_out_dt` datetime(6) DEFAULT NULL, `setid` varchar(50) DEFAULT NULL, `deptid` varchar(50) DEFAULT NULL, `fdescrshort` varchar(100) DEFAULT NULL, `fdescr` varchar(200) DEFAULT NULL, `feffdt` datetime DEFAULT NULL, `eff_status` varchar(50) DEFAULT NULL, `hl_dept_gra` varchar(50) DEFAULT NULL, `setid_location` varchar(50) DEFAULT NULL, `flocation` varchar(50) DEFAULT NULL, `hl_treepath` varchar(50) DEFAULT NULL, `company` varchar(50) DEFAULT NULL, `manager_id` varchar(50) DEFAULT NULL, `hl_treelevel` varchar(50) DEFAULT NULL, `parentid` varchar(10) DEFAULT NULL, `fvalid` int(1) DEFAULT NULL, `fcreateime` datetime DEFAULT NULL, `createrid` varchar(50) DEFAULT NULL, `fupdatetime` datetime DEFAULT NULL, `updaterid` varchar(50) DEFAULT NULL, PRIMARY KEY (`fid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of tdeptstg -- ---------------------------- -- ---------------------------- -- Table structure for `tdictionary` -- ---------------------------- DROP TABLE IF EXISTS `tdictionary`; CREATE TABLE `tdictionary` ( `fid` varchar(50) NOT NULL COMMENT '主键', `fkey` varchar(10) DEFAULT NULL, `fvalue` varchar(100) DEFAULT NULL, `fenum_name` varchar(100) DEFAULT NULL COMMENT '对应枚举类名', `fis_del` tinyint(4) DEFAULT '0', `findex` int(11) DEFAULT '0', `fcreate_time` datetime DEFAULT NULL, `fupdate_time` datetime DEFAULT NULL, `fparent_id` varchar(50) DEFAULT NULL, PRIMARY KEY (`fid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='数据字典'; -- ---------------------------- -- Records of tdictionary -- ---------------------------- INSERT INTO `tdictionary` VALUES ('2c909f064816139c0148161c37220003', '0', '朝阳区', 'RegionEnum', '0', '1', '2014-08-27 14:17:01', '2014-08-27 14:17:01', ''); INSERT INTO `tdictionary` VALUES ('2c909f064816139c0148161ce9e10004', '1', '丰台区', 'RegionEnum', '0', '2', '2014-08-27 14:17:47', '2014-08-27 14:17:47', ''); INSERT INTO `tdictionary` VALUES ('2c909f064816ac81014816b638dc0002', '0', '预付费', 'ElectricityTypeEnum', '0', '1', '2014-08-27 17:05:14', '2014-08-27 17:05:14', ''); INSERT INTO `tdictionary` VALUES ('2c909f064816ac81014816b67db20003', '1', '后付费', 'ElectricityTypeEnum', '0', '2', '2014-08-27 17:05:32', '2014-08-27 17:05:32', ''); INSERT INTO `tdictionary` VALUES ('2c909f064816ac81014816b6d3300004', '1', '后付费', 'WaterTypeEnum', '0', '2', '2014-08-27 17:05:53', '2014-08-27 17:05:53', ''); INSERT INTO `tdictionary` VALUES ('2c909f064816ac81014816b709d40005', '0', '预付费', 'WaterTypeEnum', '0', '1', '2014-08-27 17:06:07', '2014-08-27 17:06:07', ''); INSERT INTO `tdictionary` VALUES ('2c909f064816ac81014816c178b10006', '0', '电子锁', 'LockTypeEnum', '0', '1', '2014-08-27 17:17:31', '2014-08-27 17:17:31', ''); INSERT INTO `tdictionary` VALUES ('2c909f064816ac81014816c1a0cd0007', '1', '机械锁', 'LockTypeEnum', '0', '2', '2014-08-27 17:17:41', '2014-08-27 17:17:41', ''); INSERT INTO `tdictionary` VALUES ('2c909f064816ac81014816c1d0800008', '3', '密码锁', 'LockTypeEnum', '0', '3', '2014-08-27 17:17:54', '2014-08-27 17:17:54', ''); INSERT INTO `tdictionary` VALUES ('2c909f064816ac81014816c5b8940009', '0', '公司', 'OwnerTypeEnum', '0', '1', '2014-08-27 17:22:10', '2014-08-27 17:22:10', ''); INSERT INTO `tdictionary` VALUES ('2c909f064816ac81014816c5d9ae000a', '1', '个人', 'OwnerTypeEnum', '0', '2', '2014-08-27 17:22:18', '2014-08-27 17:22:18', ''); INSERT INTO `tdictionary` VALUES ('2c909f064816ac81014816ccfe57000b', '0', '商品房', 'PropertyTypeEnum', '0', '1', '2014-08-27 17:30:06', '2014-08-27 17:30:06', ''); INSERT INTO `tdictionary` VALUES ('2c909f064816ac81014816cd351e000c', '1', '房改房', 'PropertyTypeEnum', '0', '2', '2014-08-27 17:30:20', '2014-08-27 17:30:20', ''); INSERT INTO `tdictionary` VALUES ('2c909f064816ac81014816cd6d66000d', '2', '自建房', 'PropertyTypeEnum', '0', '3', '2014-08-27 17:30:35', '2014-08-27 17:30:35', ''); INSERT INTO `tdictionary` VALUES ('2c909f064816ac81014816cd9c55000e', '3', '小产权', 'PropertyTypeEnum', '0', '4', '2014-08-27 17:30:47', '2014-08-27 17:30:47', ''); INSERT INTO `tdictionary` VALUES ('2c909f064816ac81014816ea6bd9000f', '0', '框架结构', 'BuildingStructureEnum', '0', '1', '2014-08-27 18:02:15', '2014-08-27 18:02:15', ''); -- ---------------------------- -- Table structure for `temployee` -- ---------------------------- DROP TABLE IF EXISTS `temployee`; CREATE TABLE `temployee` ( `fid` varchar(255) NOT NULL, `fcode` varchar(10) DEFAULT NULL, `fname` varchar(50) DEFAULT NULL, `fsex` int(10) DEFAULT NULL, `fidcardno` varchar(18) DEFAULT NULL, `fbirthday` datetime DEFAULT NULL, `femail` varchar(30) DEFAULT NULL, `fmobile` varchar(15) DEFAULT NULL, `ftelno` varchar(20) DEFAULT NULL, `ffaxno` varchar(20) DEFAULT NULL, `fqqno` varchar(15) DEFAULT NULL, `fmsnno` varchar(30) DEFAULT NULL, `faddress` varchar(100) DEFAULT NULL, `fzipcode` varchar(6) DEFAULT NULL, `fmemo` varchar(100) DEFAULT NULL, `fcsrtype` int(10) DEFAULT '0', `fcicuserid` varchar(50) DEFAULT NULL, `fcicpwd` varchar(50) DEFAULT NULL, `departmentid` varchar(50) DEFAULT NULL, `fvalid` int(1) DEFAULT NULL, `fcreateime` datetime DEFAULT NULL, `createrid` varchar(50) DEFAULT NULL, `fupdatetime` datetime DEFAULT NULL, `updaterid` varchar(50) DEFAULT NULL, PRIMARY KEY (`fid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of temployee -- ---------------------------- -- ---------------------------- -- Table structure for `thouseitemsconfig` -- ---------------------------- DROP TABLE IF EXISTS `thouseitemsconfig`; CREATE TABLE `thouseitemsconfig` ( `fid` varchar(50) NOT NULL DEFAULT '', `fitemstype` varchar(100) DEFAULT '' COMMENT '物品分类', `fitemsname` varchar(255) DEFAULT '' COMMENT '物品名称', `fitemscode` char(6) DEFAULT '' COMMENT '物品编码', `fitemsnum` int(11) DEFAULT '0' COMMENT '物品数量', `finputoptions` tinyint(1) DEFAULT '0' COMMENT '输入选项', `finventorymanage` tinyint(3) DEFAULT '0' COMMENT '库存管理', `fnummodify` tinyint(3) DEFAULT '0' COMMENT '数量可修改', `projectid` varchar(50) DEFAULT NULL COMMENT '项目ID', `cityid` varchar(50) DEFAULT NULL COMMENT '城市ID', `fvalid` int(1) DEFAULT NULL, `fcreateime` datetime DEFAULT NULL, `createrid` varchar(50) DEFAULT NULL, `fupdatetime` datetime DEFAULT NULL, `updaterid` varchar(50) DEFAULT NULL, PRIMARY KEY (`fid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of thouseitemsconfig -- ---------------------------- -- ---------------------------- -- Table structure for `thousetype` -- ---------------------------- DROP TABLE IF EXISTS `thousetype`; CREATE TABLE `thousetype` ( `fid` varchar(50) NOT NULL DEFAULT '' COMMENT '主键', `fhousetypename` varchar(100) DEFAULT '' COMMENT '户型名称', `farea` double DEFAULT '0' COMMENT '面积', `ftotalroom` int(11) DEFAULT NULL COMMENT '总间数', `fhousetypedesc` varchar(500) DEFAULT '' COMMENT '户型说明', `fhousetypeimg` blob COMMENT '户型图', `fshoworder` int(11) DEFAULT NULL COMMENT '显示顺序', `froomintroduction` varchar(500) DEFAULT NULL COMMENT '房型介绍', `projectid` varchar(52) DEFAULT '' COMMENT '项目id', `cityid` varchar(50) DEFAULT 'BJ' COMMENT '城市ID', `fvalid` int(1) DEFAULT NULL, `fcreateime` datetime DEFAULT NULL, `createrid` varchar(50) DEFAULT NULL, `fupdatetime` datetime DEFAULT NULL, `updaterid` varchar(50) DEFAULT NULL, PRIMARY KEY (`fid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of thousetype -- ---------------------------- -- ---------------------------- -- Table structure for `titemlist` -- ---------------------------- DROP TABLE IF EXISTS `titemlist`; CREATE TABLE `titemlist` ( `fid` varchar(50) NOT NULL DEFAULT '' COMMENT '主键', `fitemtype` varchar(50) DEFAULT NULL COMMENT '物品分类', `fitemname` varchar(50) DEFAULT NULL COMMENT '物品名称', `fitemcode` varchar(50) DEFAULT NULL COMMENT '物品编码', `faccessories` tinyint(3) DEFAULT NULL COMMENT '是否配件', `fdamage` tinyint(3) DEFAULT NULL COMMENT '损坏赔偿', `fitemsprice` double DEFAULT NULL COMMENT '物品价格', `fbackupinventory` tinyint(3) DEFAULT NULL COMMENT '是否备库存', `fwebname` varchar(50) DEFAULT NULL COMMENT '网站显示名', `fshoworder` int(11) DEFAULT NULL COMMENT '显示顺序', `ficon` blob COMMENT '图标', `fhalfyearodds` double DEFAULT NULL COMMENT '半年内赔率', `foneyearodds` double DEFAULT NULL COMMENT '0.5-1年赔率', `ftwoyearodds` double DEFAULT NULL COMMENT '1-2年赔率', `fthreeyearodds` double DEFAULT NULL COMMENT '2-3年赔率', `ffouryearodds` double DEFAULT NULL COMMENT '3-4年赔率', `fiveyearodds` double DEFAULT NULL COMMENT '4-5年赔率', `fitemstate` tinyint(3) DEFAULT NULL COMMENT '物品状态', `cityid` varchar(50) DEFAULT 'BJ' COMMENT '城市ID', `fvalid` int(1) DEFAULT NULL, `fcreateime` datetime DEFAULT NULL, `createrid` varchar(50) DEFAULT NULL, `fupdatetime` datetime DEFAULT NULL, `updaterid` varchar(50) DEFAULT NULL, PRIMARY KEY (`fid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of titemlist -- ---------------------------- -- ---------------------------- -- Table structure for `tpost` -- ---------------------------- DROP TABLE IF EXISTS `tpost`; CREATE TABLE `tpost` ( `fid` varchar(50) NOT NULL, `companyid` varchar(50) DEFAULT NULL, `departmentid` varchar(50) DEFAULT NULL, `fname` varchar(50) DEFAULT NULL, `fhint` varchar(20) DEFAULT NULL, `fresponsibility` varchar(150) DEFAULT NULL, `dftmenuid` varchar(50) DEFAULT NULL, `fcode` varchar(50) DEFAULT NULL, `standpostid` varchar(50) DEFAULT NULL, `fvalid` int(1) DEFAULT NULL, `fcreateime` datetime DEFAULT NULL, `createrid` varchar(50) DEFAULT NULL, `fupdatetime` datetime DEFAULT NULL, `updaterid` varchar(50) DEFAULT NULL, PRIMARY KEY (`fid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of tpost -- ---------------------------- -- ---------------------------- -- Table structure for `tpostemployee` -- ---------------------------- DROP TABLE IF EXISTS `tpostemployee`; CREATE TABLE `tpostemployee` ( `fid` varchar(50) NOT NULL, `companyid` varchar(50) DEFAULT NULL, `departmentid` varchar(50) DEFAULT NULL, `postid` varchar(50) DEFAULT NULL, `employeeid` varchar(50) DEFAULT NULL, `fdeftpost` int(1) DEFAULT NULL, `fvalid` int(1) DEFAULT NULL, `fcreateime` datetime DEFAULT NULL, `createrid` varchar(50) DEFAULT NULL, `fupdatetime` datetime DEFAULT NULL, `updaterid` varchar(50) DEFAULT NULL, PRIMARY KEY (`fid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of tpostemployee -- ---------------------------- -- ---------------------------- -- Table structure for `tproject` -- ---------------------------- DROP TABLE IF EXISTS `tproject`; CREATE TABLE `tproject` ( `fId` varchar(50) NOT NULL COMMENT '主键', `fCode` varchar(50) DEFAULT NULL COMMENT '项目编号', `fCompanyId` varchar(50) DEFAULT 'BJ' COMMENT '公司ID', `fName` varchar(100) DEFAULT NULL COMMENT '项目名称', `fTitle` varchar(100) DEFAULT NULL COMMENT '副标题', `fDescribe` varchar(1000) DEFAULT NULL COMMENT '项目介绍', `fAddress` varchar(255) DEFAULT NULL COMMENT '项目地址', `fLon` double DEFAULT NULL COMMENT '经度', `fLat` double DEFAULT NULL COMMENT '纬度', `fBusinessDistrict` int(11) DEFAULT NULL COMMENT '项目所属商圈', `fRegion` varchar(50) DEFAULT NULL COMMENT '项目所属区域', `fArea` double DEFAULT NULL COMMENT '项目面积', `fBuildingNum` int(11) DEFAULT NULL COMMENT '楼栋数', `fCarPortNum` int(11) DEFAULT NULL COMMENT '车位数量', `fBuildingStructure` varchar(50) DEFAULT NULL COMMENT '楼体结构', `fRoomNum` int(11) DEFAULT NULL COMMENT '房间总数', `fHouseTypeNum` int(11) DEFAULT NULL COMMENT '户型数', `fPublicArea` int(11) DEFAULT NULL COMMENT '公区面积', `fElectricityType` varchar(50) DEFAULT NULL COMMENT '用电类别', `fWaterType` varchar(50) DEFAULT NULL COMMENT '用水类别', `fCooperationModel` varchar(50) DEFAULT NULL COMMENT '项目合作模式', `fOwnerType` varchar(50) DEFAULT NULL COMMENT '业主类型', `fOwnerName` varchar(50) DEFAULT NULL COMMENT '业主', `fPropertyType` varchar(50) DEFAULT NULL COMMENT '产权类型', `fFinishYear` int(11) DEFAULT NULL COMMENT '建成年代', `fContractBegin` date DEFAULT NULL COMMENT '项目收楼日期', `fContractCycle` int(11) DEFAULT NULL COMMENT '项目租赁年限', `fContractEnd` date DEFAULT NULL COMMENT '项目到期日期', `fOpeningTime` date DEFAULT NULL COMMENT '项目开业日期', `fVacancyDay` int(11) DEFAULT NULL COMMENT '项目空置总天数', `fProjectManager` varchar(50) DEFAULT NULL COMMENT '项目运营负责人/项目经理', `fMarketTel` varchar(50) DEFAULT NULL COMMENT '销售电话', `fLockType` varchar(50) DEFAULT NULL COMMENT '门锁类型', `fIsDel` tinyint(4) unsigned DEFAULT '0' COMMENT '是否删除', PRIMARY KEY (`fId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='项目'; -- ---------------------------- -- Records of tproject -- ---------------------------- INSERT INTO `tproject` VALUES ('2c909fac481b528101481b529db90002', '001', null, '上帝', '上帝11', '', '上帝啊 ', '111', '222', null, '1', '333', '1', null, '0', null, null, '11111', '0', '1', null, '0', '仙府饭店', '0', '1991', '2014-08-28', '12', '2014-08-05', '2014-08-23', '123', '1', '13888888888', '3', '0'); INSERT INTO `tproject` VALUES ('2c909fac481b528101481b52f6270003', '001', null, '上帝', '上帝11', '', '上帝啊 ', '111', '222', null, '1', '333', '1', null, '0', null, null, '11111', '0', '1', null, '0', '仙府饭店', '0', '1991', '2014-08-28', '12', '2014-08-05', '2014-08-23', '123', '1', '13888888888', '3', '0'); INSERT INTO `tproject` VALUES ('2c909fac481b528101481b56ce070005', '001', null, '上帝', '上帝11', '<ol>\r\n <li>\r\n <h2 style=\"font-style:italic;\">自己要什么，你身边没那么多熙熙攘攘的声音，你可以听到自己，你可以问问你自己到底要什么，到底不要什么。了解自己这回事，大多都留在了独处的时间里。<a href=\"http://www.duanwenxue.com/jingdian/ganwu/\" target=\"_blank\">人生</a>总有那么一段大片大片空白的时光。你在等待，你在坚忍，你在静默。你在等一场春华秋实，你在等新一轮的春暖花开，</h2>\r\n </li>\r\n</ol>\r\n\r\n<p>生命不是一场赛跑，而是一次旅行。比赛在乎终点，而旅行在乎沿途风景。常人说：不登山，不知山高；不涉水，不晓水深；不赏奇景，怎知其绝妙。读万卷书，还须行万里路。旅行，可以使你中断每天周而复始的凡人琐事，对平凡俗气的<strong>生活，是一种暂时的解脱，让自己的胸怀得以舒展，心灵得以净化！人的一生中至少要有两次冲动，一次为奋不顾身的爱情，一次为说走就走的旅行。我们上地凌云自如寓的极客们已经做好准备，上周六参加了自如寓的坝上草原行。大</strong>家提前一天就已经制定好行程<em>还有出门游玩所带的东西，</em>细心地台湾大叔还给同去的小伙伴制定了出游点检表供大家参考。早上五点半大家包车前往集合地点~~~</p>\r\n', '上帝啊 ', '111', '222', null, '1', '333', '1', null, '0', null, null, '11111', '0', '1', null, '0', '仙府饭店', '0', '1991', '2014-08-28', '12', '2014-08-05', '2014-08-23', '123', '1', '13888888888', '3', '0'); INSERT INTO `tproject` VALUES ('2c909fac481b745101481b7794590002', '0002', null, '西直门自如寓', '西直门', '', '西直门', '11.29', '222', null, '0', '33322', '1', null, '0', null, null, '200', '1', '0', null, '0', '西直门XXXX', '0', '1999', '2014-08-14', '2', '2014-08-24', '2014-08-20', '123', '汤海涛', '15999999999', '0', '0'); INSERT INTO `tproject` VALUES ('2c909fac481b745101481b85e04a0003', '0003', null, '将府自如寓', '将府自如寓', '<p> </p>\r\n\r\n<table border=\"0\" style=\"width:100%\">\r\n <tbody>\r\n <tr>\r\n <td>销售电话：</td>\r\n <td>*</td>\r\n </tr>\r\n </tbody>\r\n</table>\r\n', '将府自如寓', '1111', '2222', null, '1', '3333', '3', null, '0', null, null, '23', '0', '1', null, '0', '将府自如寓', '0', '1980', '2014-08-20', '23', '2014-08-27', '2014-08-14', '23', '将府自如寓', '13888888888', '1', '0'); INSERT INTO `tproject` VALUES ('2c909fac481b867c01481b86ac360002', '0003', null, '将府自如寓', '将府自如寓', '<p> </p>\r\n\r\n<table border=\"0\" style=\"width:100%\">\r\n <tbody>\r\n <tr>\r\n <td>销售电话：</td>\r\n <td>*</td>\r\n </tr>\r\n </tbody>\r\n</table>\r\n', '将府自如寓', '1111', '2222', null, '1', '3333', '3', null, '0', null, null, '23', '0', '1', null, '0', '将府自如寓', '0', '1980', '2014-08-20', '23', '2014-08-27', '2014-08-14', '23', '将府自如寓', '13888888888', '1', '0'); INSERT INTO `tproject` VALUES ('2c909fac481b867c01481b8719a60003', '0003', null, '将府自如寓', '将府自如寓', '<p> </p>\r\n\r\n<table border=\"0\" style=\"width:100%\">\r\n <tbody>\r\n <tr>\r\n <td>销售电话：</td>\r\n <td>*</td>\r\n </tr>\r\n </tbody>\r\n</table>\r\n', '将府自如寓', '1111', '2222', null, '1', '3333', '3', null, '0', null, null, '23', '0', '1', null, '0', '将府自如寓', '0', '1980', '2014-08-20', '23', '2014-08-27', '2014-08-14', '23', '将府自如寓', '13888888888', '1', '0'); INSERT INTO `tproject` VALUES ('2c909fac481b867c01481b875c530004', '0003', null, '将府自如寓', '将府自如寓', '<p> </p>\r\n\r\n<table border=\"0\" style=\"width:100%\">\r\n <tbody>\r\n <tr>\r\n <td>销售电话：</td>\r\n <td>*</td>\r\n </tr>\r\n </tbody>\r\n</table>\r\n', '将府自如寓', '1111', '2222', null, '1', '3333', '3', null, '0', null, null, '23', '0', '1', null, '0', '将府自如寓', '0', '1980', '2014-08-20', '23', '2014-08-27', '2014-08-14', '23', '将府自如寓', '13888888888', '1', '0'); INSERT INTO `tproject` VALUES ('2c909fac481b867c01481b8bfef50005', '0003', null, '将府自如寓', '将府自如寓', '<p> </p>\r\n\r\n<table border=\"0\" style=\"width:100%\">\r\n <tbody>\r\n <tr>\r\n <td>销售电话：</td>\r\n <td>*</td>\r\n </tr>\r\n </tbody>\r\n</table>\r\n', '将府自如寓', '1111', '2222', null, '1', '3333', '3', null, '0', null, null, '23', '0', '1', null, '0', '将府自如寓', '0', '1980', '2014-08-20', '23', '2014-08-27', '2014-08-14', '23', '将府自如寓', '13888888888', '1', '0'); INSERT INTO `tproject` VALUES ('2c909fac481b867c01481b8cc6670006', '2', null, '2', '2', '<p>3</p>\r\n', '2', '2', '2222', null, '0', '2', '2', null, '0', null, null, '2', '0', '1', null, '0', '3', '0', '1234', '2014-08-20', '3', '2014-07-29', '2014-08-14', '3', '3', '13888888888', '0', '0'); INSERT INTO `tproject` VALUES ('2c909fac481b867c01481b8e74630007', '44', null, '4', '1', '', '1', '1', '1', null, '0', '1', '1', null, '0', null, null, '1', '0', '0', null, '0', '2', '0', '1999', '2014-07-30', '12', '2014-08-05', '2014-08-19', '123', '将府自如寓', '13888888888', '0', '0'); INSERT INTO `tproject` VALUES ('2c909fac481ba68401481ba77b1b0002', '0004', null, '哈哈自如寓', '111', '', '333', '1', '1', null, '0', '2', '1', null, '0', null, null, '11111', '0', '0', null, '0', '仙府饭店', '0', '1999', '2014-08-06', '1', '2014-08-20', '2014-08-26', '123', '撒旦法', '13888888888', '0', '0'); INSERT INTO `tproject` VALUES ('2c909fac481ba68401481bae94380003', '2312', null, 'aaa', '上帝11', '', '上帝啊 ', '111', '222', null, '0', '333', '1', null, '0', null, null, '11111', '0', '0', null, '0', '仙府饭店', '0', '1999', '2014-08-05', '1', '2014-08-27', '2014-08-19', '123', '3', '15999999999', '0', '0'); INSERT INTO `tproject` VALUES ('2c909fac481ba68401481baec6b90004', '2312', null, 'aaa', '上帝11', '', '上帝啊 ', '111', '222', null, '0', '333', '1', null, '0', null, null, '11111', '0', '0', null, '0', '仙府饭店', '0', '1999', '2014-08-05', '1', '2014-08-27', '2014-08-19', '123', '3', '15999999999', '0', '0'); INSERT INTO `tproject` VALUES ('2c909fac481ba68401481bafaa380005', '2312', null, '1', '1', '', '上帝啊 ', '1', '1', null, '0', '10000', '1', null, '0', null, null, '1', '1', '0', null, '0', '仙府饭店', '0', '1999', '2014-08-21', '1', '2014-08-12', '2014-08-22', '123', '将府自如寓', '13888888888', '0', '0'); INSERT INTO `tproject` VALUES ('2c909fef481a5e2c01481a6633e90002', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '0'); INSERT INTO `tproject` VALUES ('2c909fef481ac1df01481ac301d00002', '001', null, '上帝', '上帝11', '', '上帝啊 ', '111', '222', null, '1', '333', '1', null, '0', null, null, '11111', '0', '1', null, '0', '仙府饭店', '0', '19990101', '2014-01-01', '12', '2014-01-01', '2014-01-01', '123', '1', '13888888888', '3', '0'); -- ---------------------------- -- Table structure for `tprojectimages` -- ---------------------------- DROP TABLE IF EXISTS `tprojectimages`; CREATE TABLE `tprojectimages` ( `fid` varchar(50) NOT NULL DEFAULT '' COMMENT '主键', `projectid` varchar(50) DEFAULT '' COMMENT '外键', `fimages` blob COMMENT '文件', `cityid` varchar(50) DEFAULT 'BJ' COMMENT '城市ID', `fvalid` int(1) DEFAULT NULL, `fcreateime` datetime DEFAULT NULL, `createrid` varchar(50) DEFAULT NULL, `fupdatetime` datetime DEFAULT NULL, `updaterid` varchar(50) DEFAULT NULL, PRIMARY KEY (`fid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of tprojectimages -- ---------------------------- -- ---------------------------- -- Table structure for `tprosurroundimg` -- ---------------------------- DROP TABLE IF EXISTS `tprosurroundimg`; CREATE TABLE `tprosurroundimg` ( `fid` varchar(50) NOT NULL DEFAULT '' COMMENT '主键', `projectid` varchar(50) DEFAULT '' COMMENT '外键', `fimagesdesc` varchar(100) DEFAULT '', `fimages` blob COMMENT '文件', `cityid` varchar(50) DEFAULT 'BJ' COMMENT '城市ID', `fvalid` int(1) DEFAULT NULL, `fcreateime` datetime DEFAULT NULL, `createrid` varchar(50) DEFAULT NULL, `fupdatetime` datetime DEFAULT NULL, `updaterid` varchar(50) DEFAULT NULL, PRIMARY KEY (`fid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of tprosurroundimg -- ---------------------------- -- ---------------------------- -- Table structure for `tpublicareaimg` -- ---------------------------- DROP TABLE IF EXISTS `tpublicareaimg`; CREATE TABLE `tpublicareaimg` ( `fid` varchar(50) NOT NULL DEFAULT '', `projectid` varchar(50) DEFAULT NULL COMMENT '项目ID', `fimages` blob COMMENT '图片文件', `fvalid` int(1) DEFAULT NULL, `fcreateime` datetime DEFAULT NULL, `createrid` varchar(50) DEFAULT NULL, `fupdatetime` datetime DEFAULT NULL, `updaterid` varchar(50) DEFAULT NULL, PRIMARY KEY (`fid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of tpublicareaimg -- ---------------------------- -- ---------------------------- -- Table structure for `tpublicareainfo` -- ---------------------------- DROP TABLE IF EXISTS `tpublicareainfo`; CREATE TABLE `tpublicareainfo` ( `fid` varchar(50) NOT NULL DEFAULT '', `fpublicareaname` varchar(100) DEFAULT NULL COMMENT '公区名称', `projectid` varchar(50) DEFAULT NULL COMMENT '项目ID', `buildingid` varchar(50) DEFAULT NULL COMMENT '所在楼栋ID', `fpublicarea` double DEFAULT NULL COMMENT '公区面积', `flocation` varchar(100) DEFAULT NULL COMMENT '位置', `fpublicareadesc` varchar(1000) DEFAULT NULL COMMENT '公区描述', `cityid` varchar(50) DEFAULT 'BJ' COMMENT '公司ID', `fvalid` int(1) DEFAULT NULL, `fcreateime` datetime DEFAULT NULL, `createrid` varchar(50) DEFAULT NULL, `fupdatetime` datetime DEFAULT NULL, `updaterid` varchar(50) DEFAULT NULL, PRIMARY KEY (`fid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of tpublicareainfo -- ---------------------------- -- ---------------------------- -- Table structure for `tresource` -- ---------------------------- DROP TABLE IF EXISTS `tresource`; CREATE TABLE `tresource` ( `fid` varchar(50) NOT NULL, `roleid` varchar(50) DEFAULT NULL, `resourceid` int(20) DEFAULT NULL, `parentid` varchar(50) DEFAULT NULL, `fismenu` int(1) DEFAULT NULL, `fname` varchar(200) DEFAULT NULL, `fvalid` int(1) DEFAULT NULL, `fcreateime` datetime DEFAULT NULL, `createrid` varchar(50) DEFAULT NULL, `fupdatetime` datetime DEFAULT NULL, `updaterid` varchar(50) DEFAULT NULL, PRIMARY KEY (`fid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of tresource -- ---------------------------- -- ---------------------------- -- Table structure for `trole` -- ---------------------------- DROP TABLE IF EXISTS `trole`; CREATE TABLE `trole` ( `fid` varchar(50) NOT NULL, `fname` varchar(200) DEFAULT NULL, `fdescription` varchar(300) DEFAULT NULL, `fvalid` int(1) DEFAULT NULL, `fcreateime` datetime DEFAULT NULL, `createrid` varchar(50) DEFAULT NULL, `fupdatetime` datetime DEFAULT NULL, `updaterid` varchar(50) DEFAULT NULL, PRIMARY KEY (`fid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of trole -- ---------------------------- -- ---------------------------- -- Table structure for `troleresource` -- ---------------------------- DROP TABLE IF EXISTS `troleresource`; CREATE TABLE `troleresource` ( `fid` varchar(50) NOT NULL, `resourceid` varchar(50) DEFAULT NULL, `roleid` varchar(50) DEFAULT NULL, `fismenu` int(1) DEFAULT NULL, `fvalid` int(1) DEFAULT NULL, `fcreateime` datetime DEFAULT NULL, `createrid` varchar(50) DEFAULT NULL, `fupdatetime` datetime DEFAULT NULL, `updaterid` varchar(50) DEFAULT NULL, PRIMARY KEY (`fid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of troleresource -- ---------------------------- -- ---------------------------- -- Table structure for `troominfo` -- ---------------------------- DROP TABLE IF EXISTS `troominfo`; CREATE TABLE `troominfo` ( `fid` varchar(50) NOT NULL DEFAULT '', `projectid` varchar(50) DEFAULT NULL COMMENT '项目ID', `buildingid` varchar(50) DEFAULT NULL COMMENT '楼栋ID', `ffloornumber` int(11) DEFAULT NULL COMMENT '层数', `froomnumber` int(11) DEFAULT NULL COMMENT '房间号', `froomarea` double DEFAULT NULL COMMENT '房间面积', `housetypeid` varchar(50) DEFAULT NULL COMMENT '户型ID', `froomtype` tinyint(1) DEFAULT NULL COMMENT '标间/套间', `fbedtype` tinyint(1) DEFAULT NULL COMMENT '床类型', `fdecorationstyle` varchar(50) DEFAULT NULL COMMENT '装修风格', `fdirection` varchar(50) DEFAULT NULL COMMENT '朝向', `fshortrent` tinyint(3) DEFAULT NULL COMMENT '是否可短租', `froomdesc` text COMMENT '房间描述', `fcurrentsate` varchar(50) DEFAULT NULL COMMENT '当前状态', `cityid` varchar(50) DEFAULT 'BJ', `fvalid` int(1) DEFAULT NULL, `fcreateime` datetime DEFAULT NULL, `createrid` varchar(50) DEFAULT NULL, `fupdatetime` datetime DEFAULT NULL, `updaterid` varchar(50) DEFAULT NULL, PRIMARY KEY (`fid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of troominfo -- ---------------------------- -- ---------------------------- -- Table structure for `troomitemsconfig` -- ---------------------------- DROP TABLE IF EXISTS `troomitemsconfig`; CREATE TABLE `troomitemsconfig` ( `fid` varchar(50) NOT NULL DEFAULT '', `roomid` varchar(50) DEFAULT NULL COMMENT '房间ID', `fitemcode` char(50) DEFAULT NULL COMMENT '单品编码', `itemid` varchar(50) DEFAULT NULL COMMENT '物品品类ID', `fbrand` varchar(50) DEFAULT NULL COMMENT '品牌', `fnumber` int(11) DEFAULT NULL COMMENT '数量', `supplierid` varchar(50) DEFAULT NULL COMMENT '供应商ID', `finstalltime` date DEFAULT NULL COMMENT '安装时间', `fqualityperiod` int(11) DEFAULT NULL COMMENT '质保期', `fcustomertel` varchar(50) DEFAULT NULL COMMENT '客服电话', `cityid` varchar(50) DEFAULT NULL COMMENT '公司ID', `fvalid` int(1) DEFAULT NULL, `fcreateime` datetime DEFAULT NULL, `createrid` varchar(50) DEFAULT NULL, `fupdatetime` datetime DEFAULT NULL, `updaterid` varchar(50) DEFAULT NULL, PRIMARY KEY (`fid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of troomitemsconfig -- ---------------------------- -- ---------------------------- -- Table structure for `tstandpost` -- ---------------------------- DROP TABLE IF EXISTS `tstandpost`; CREATE TABLE `tstandpost` ( `fid` varchar(50) NOT NULL, `fcode` varchar(50) DEFAULT NULL, `fname` varchar(100) DEFAULT NULL, `fdesc` varchar(200) DEFAULT NULL, `fvalid` int(1) DEFAULT '0', `fcreateime` datetime DEFAULT NULL, `createrid` varchar(50) DEFAULT NULL, `fupdatetime` datetime DEFAULT NULL, `updaterid` varchar(50) DEFAULT NULL, PRIMARY KEY (`fid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of tstandpost -- ---------------------------- -- ---------------------------- -- Table structure for `tsupplier` -- ---------------------------- DROP TABLE IF EXISTS `tsupplier`; CREATE TABLE `tsupplier` ( `fid` varchar(50) NOT NULL DEFAULT '' COMMENT '主键', `fsuppliercode` int(11) DEFAULT NULL COMMENT '供应商编码', `fsuppliertype` varchar(50) DEFAULT NULL COMMENT '供应商类别', `fsuppliername` varchar(100) DEFAULT NULL COMMENT '供应商名称', `fpurchasemanager` varchar(50) DEFAULT NULL COMMENT '采购负责人', `fmanager` varchar(50) DEFAULT NULL COMMENT '负责人', `fmanagerphone` varchar(50) DEFAULT NULL COMMENT '负责人电话', `fcontact` varchar(50) DEFAULT NULL COMMENT '联系人', `fcontactphone` varchar(50) DEFAULT NULL COMMENT '联系电话', `fcontactadd` varchar(50) DEFAULT NULL COMMENT '联系地址', `fprovideproduct` varchar(50) DEFAULT NULL COMMENT '提供的产品或服务', `fservicetime` varchar(50) DEFAULT NULL COMMENT '服务时效', `frepairmanager` varchar(50) DEFAULT NULL COMMENT '维修联系人', `fdeterminetime` datetime DEFAULT NULL COMMENT '供应商确定时间', `fsigntime` datetime DEFAULT NULL COMMENT '合同签订时间', `fvalid` int(1) DEFAULT NULL, `fcreateime` datetime DEFAULT NULL, `createrid` varchar(50) DEFAULT NULL, `fupdatetime` datetime DEFAULT NULL, `updaterid` varchar(50) DEFAULT NULL, PRIMARY KEY (`fid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of tsupplier -- ---------------------------- -- ---------------------------- -- Table structure for `tsysmenu` -- ---------------------------- DROP TABLE IF EXISTS `tsysmenu`; CREATE TABLE `tsysmenu` ( `fid` varchar(50) NOT NULL, `companyid` varchar(50) DEFAULT NULL, `fcode` varchar(20) DEFAULT NULL, `fname` varchar(50) DEFAULT NULL, `fdesc` varchar(200) DEFAULT NULL, `fvalid` int(1) DEFAULT NULL, `fcreateime` datetime DEFAULT NULL, `createrid` varchar(50) DEFAULT NULL, `fupdatetime` datetime DEFAULT NULL, `updaterid` varchar(50) DEFAULT NULL, PRIMARY KEY (`fid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of tsysmenu -- ---------------------------- -- ---------------------------- -- Table structure for `tuseraccount` -- ---------------------------- DROP TABLE IF EXISTS `tuseraccount`; CREATE TABLE `tuseraccount` ( `fid` varchar(50) NOT NULL, `fuseraccount` varchar(20) DEFAULT NULL, `fpassword` varchar(50) DEFAULT NULL, `fisadmin` int(1) DEFAULT NULL, `linkemployeeid` varchar(50) DEFAULT NULL, `fupdpswdate` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6), `frequireupdatepw` int(1) DEFAULT '0', `flastlogindate` timestamp(6) NOT NULL DEFAULT '0000-00-00 00:00:00.000000', `fdatabelong` varchar(255) DEFAULT NULL, `flastloginip` varchar(255) DEFAULT NULL, `floginfailtime` int(10) DEFAULT '0', `facctlocktime` timestamp(6) NOT NULL DEFAULT '0000-00-00 00:00:00.000000', `facctstatus` int(10) DEFAULT '0', `fproviderid` varchar(50) DEFAULT NULL, `ftempgjid` varchar(50) DEFAULT NULL, `fvalid` int(1) DEFAULT NULL, `fcreateime` datetime DEFAULT NULL, `createrid` varchar(50) DEFAULT NULL, `fupdatetime` datetime DEFAULT NULL, `updaterid` varchar(50) DEFAULT NULL, PRIMARY KEY (`fid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of tuseraccount -- ---------------------------- -- ---------------------------- -- Table structure for `tuserrole` -- ---------------------------- DROP TABLE IF EXISTS `tuserrole`; CREATE TABLE `tuserrole` ( `fid` varchar(50) NOT NULL, `fuserid` varchar(50) DEFAULT NULL, `froleid` varchar(50) DEFAULT NULL, `fvalid` int(1) DEFAULT '0', `fcreateime` datetime DEFAULT NULL, `createrid` varchar(50) DEFAULT NULL, `fupdatetime` datetime DEFAULT NULL, `updaterid` varchar(50) DEFAULT NULL, PRIMARY KEY (`fid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of tuserrole -- ----------------------------
12-15
08-04
12-15
04-07
4220
4220
04-15
“相关推荐”对你有帮助么？
-
非常没帮助 -
没帮助 -
一般 -
有帮助 -
非常有帮助
提交
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
