数据库/jxsystem.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

/*
MySQL Data Transfer
Source Host: localhost
Source Database: jxsystem
Target Host: localhost
Target Database: jxsystem
Date: 2013/4/5 21:53:55
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for car
-- ----------------------------
DROP TABLE IF EXISTS `car`;
CREATE TABLE `car` (
  `cstate` varchar(50) default NULL,
  `cprice` int(11) default NULL,
  `cdate` varchar(50) default NULL,
  `ctype` varchar(50) default NULL,
  `cnum` varchar(50) default NULL,
  `cid` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`cid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for license
-- ----------------------------
DROP TABLE IF EXISTS `license`;
CREATE TABLE `license` (
  `sname` varchar(55) default NULL,
  `lmark` varchar(55) default NULL,
  `lstate` varchar(55) default NULL,
  `ldate` varchar(55) default NULL,
  `sid` int(11) default NULL,
  `lid` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`lid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for record
-- ----------------------------
DROP TABLE IF EXISTS `record`;
CREATE TABLE `record` (
  `rdate` varchar(55) default NULL,
  `ctype` varchar(55) default NULL,
  `cnum` varchar(50) default NULL,
  `cid` int(11) default NULL,
  `tname` varchar(50) default NULL,
  `tid` int(11) default NULL,
  `rid` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`rid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for sadmin
-- ----------------------------
DROP TABLE IF EXISTS `sadmin`;
CREATE TABLE `sadmin` (
  `apass` varchar(50) default NULL,
  `aname` varchar(50) default NULL,