assets.sql

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

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

/*
SQLyog Community Edition- MySQL GUI v6.54
MySQL - 5.0.51a-community-nt : Database - assets
*********************************************************************
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

CREATE DATABASE /*!32312 IF NOT EXISTS*/`assets` /*!40100 DEFAULT CHARACTER SET gb2312 */;

USE `assets`;

/*Table structure for table `admin` */

DROP TABLE IF EXISTS `admin`;

CREATE TABLE `admin` (
  `id` int(4) NOT NULL auto_increment,
  `username` varchar(100) default NULL,
  `password` varchar(100) default NULL,
  `creattime` varchar(100) default NULL,
  `flag` int(4) default NULL,
  `isuse` int(4) default NULL,
  `logintimes` int(4) default NULL,
  `quanxian` varchar(100) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=gb2312;

/*Data for the table `admin` */

insert  into `admin`(`id`,`username`,`password`,`creattime`,`flag`,`isuse`,`logintimes`,`quanxian`) values (1,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2015-1-1',1,1,108,'1'),(3,'admin1','0b4e7a0e5fe84ad35fb5f95b9ceeac79','2012-02-24 09:29:10',2,1,5,'一级用户');

/*Table structure for table `adminlog` */

DROP TABLE IF EXISTS `adminlog`;

CREATE TABLE `adminlog` (
  `id` int(4) NOT NULL auto_increment,
  `username` varchar(100) default NULL,
  `password` varchar(100) default NULL,
  `logintime` varchar(100) default NULL,
  `loginip` varchar(100) default NULL,
  `useros` varchar(100) default NULL,
  `ok` varchar(50) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=135 DEFAULT CHARSET=gb2312;

/*Data for the table `adminlog` */

insert  into `adminlog`(`id`,`username`,`password`,`logintime`,`loginip`,`useros`,`ok`) values (85,'admin1','0b4e7a0e5fe84ad35fb5f95b9ceeac79','2012-02-24 09:29:58','Mozilla/4.0 (compatible','127.0.0.1','true'),(86,'admin1','0b4e7a0e5fe84ad35fb5f95b9ceeac79','2012-02-24 09:31:56','Mozilla/4.0 (compatible','127.0.0.1','true'),(87,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-02-24 09:32:04','Mozilla/4.0 (compatible','127.0.0.1','true'),(88,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-02-24 09:32:08','Mozilla/4.0 (compatible','127.0.0.1','true'),(89,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-02-24 09:32:55','Mozilla/4.0 (compatible','127.0.0.1','true'),(90,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-02-24 09:34:01','Mozilla/4.0 (compatible','127.0.0.1','true'),(91,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-02-24 09:34:40','Mozilla/4.0 (compatible','127.0.0.1','true'),(92,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-02-24 09:38:13','Mozilla/4.0 (compatible','127.0.0.1','true'),(93,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-02-24 09:39:55','Mozilla/4.0 (compatible','127.0.0.1','true'),(94,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-02-24 09:40:13','Mozilla/4.0 (compatible','127.0.0.1','true'),(95,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-02-24 10:27:29','Mozilla/4.0 (compatible','127.0.0.1','true'),(96,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-02-24 10:29:25','Mozilla/4.0 (compatible','127.0.0.1','true'),(97,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-02-24 10:36:35','Mozilla/4.0 (compatible','127.0.0.1','true'),(98,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-02-24 10:43:57','Mozilla/4.0 (compatible','127.0.0.1','true'),(99,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-02-24 11:07:06','Mozilla/4.0 (compatible','127.0.0.1','true'),(100,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-02-24 11:19:11','Mozilla/4.0 (compatible','127.0.0.1','true'),(101,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-02-24 11:57:19','Mozilla/4.0 (compatible','127.0.0.1','true'),(102,'admin3','0b4e7a0e5fe84ad35fb5f95b9ceeac79','2012-02-24 12:23:39','Mozilla/4.0 (compatible','127.0.0.1','true'),(103,'admin2','0b4e7a0e5fe84ad35fb5f95b9ceeac79','2012-02-24 12:25:51','Mozilla/4.0 (compatible','127.0.0.1','true'),(104,'admin2','0b4e7a0e5fe84ad35fb5f95b9ceeac79','2012-02-24 12:26:32','Mozilla/4.0 (compatible','127.0.0.1','true'),(105,'admin2','0b4e7a0e5fe84ad35fb5f95b9ceeac79','2012-02-24 12:26:41','Mozilla/4.0 (compatible','127.0.0.1','true'),(106,'admin3','0b4e7a0e5fe84ad35fb5f95b9ceeac79','2012-02-24 12:29:58','Mozilla/4.0 (compatible','127.0.0.1','true'),(107,'admin1','0b4e7a0e5fe84ad35fb5f95b9ceeac79','2012-02-24 12:30:17','Mozilla/4.0 (compatible','127.0.0.1','true'),(108,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-02-24 12:30:36','Mozilla/4.0 (compatible','127.0.0.1','true'),(109,'admin3','0b4e7a0e5fe84ad35fb5f95b9ceeac79','2012-02-24 12:32:33','Mozilla/4.0 (compatible','127.0.0.1','true'),(110,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-02-24 12:33:19','Mozilla/4.0 (compatible','127.0.0.1','true'),(111,'admin3','0b4e7a0e5fe84ad35fb5f95b9ceeac79','2012-02-24 12:34:30','Mozilla/4.0 (compatible','127.0.0.1','true'),(112,'admin2','0b4e7a0e5fe84ad35fb5f95b9ceeac79','2012-02-24 12:34:50','Mozilla/4.0 (compatible','127.0.0.1','true'),(113,'admin1','0b4e7a0e5fe84ad35fb5f95b9ceeac79','2012-02-24 12:35:27','Mozilla/4.0 (compatible','127.0.0.1','true'),(114,'admin1','0b4e7a0e5fe84ad35fb5f95b9ceeac79','2012-02-24 12:38:23','Mozilla/4.0 (compatible','127.0.0.1','true'),(115,'admin3','0b4e7a0e5fe84ad35fb5f95b9ceeac79','2012-02-24 12:43:39','Mozilla/4.0 (compatible','127.0.0.1','true'),(116,'admin2','0b4e7a0e5fe84ad35fb5f95b9ceeac79','2012-02-24 12:44:14','Mozilla/4.0 (compatible','127.0.0.1','true'),(117,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-02-24 12:45:18','Mozilla/4.0 (compatible','127.0.0.1','true'),(118,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-02-24 14:42:38','Mozilla/4.0 (compatible','127.0.0.1','true'),(119,'admin3','0b4e7a0e5fe84ad35fb5f95b9ceeac79','2012-02-24 14:43:58','Mozilla/4.0 (compatible','127.0.0.1','true'),(120,'admin2','0b4e7a0e5fe84ad35fb5f95b9ceeac79','2012-02-24 14:44:37','Mozilla/4.0 (compatible','127.0.0.1','true'),(121,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-02-25 11:21:16','Mozilla/4.0 (compatible','127.0.0.1','true'),(122,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-02-25 11:29:05','Mozilla/4.0 (compatible','127.0.0.1','true'),(123,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-02-25 11:29:45','Mozilla/4.0 (compatible','127.0.0.1','true'),(124,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-02-25 11:30:00','Mozilla/4.0 (compatible','127.0.0.1','true'),(125,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-02-25 12:02:54','Mozilla/4.0 (compatible','127.0.0.1','true'),(126,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-02-25 12:03:27','Mozilla/4.0 (compatible','127.0.0.1','true'),(127,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-02-25 13:04:59','Mozilla/4.0 (compatible','127.0.0.1','true'),(128,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-02-25 14:37:46','Mozilla/4.0 (compatible','127.0.0.1','true'),(129,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-02-25 14:42:32','Mozilla/4.0 (compatible','127.0.0.1','true'),(130,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-03-15 18:59:48','Mozilla/4.0 (compatible','127.0.0.1','true'),(131,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-03-15 19:28:28','Mozilla/4.0 (compatible','127.0.0.1','true'),(132,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-03-15 19:30:19','Mozilla/4.0 (compatible','127.0.0.1','true'),(133,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-03-15 19:31:53','Mozilla/4.0 (compatible','127.0.0.1','true'),(134,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-03-15 20:04:21','Mozilla/4.0 (compatible','127.0.0.1','true');

/*Table structure for table `bm` */

DROP TABLE IF EXISTS `bm`;