backup.sql

来自「spring+acegi编写的网上书城」· SQL 代码 · 共 125 行 · 第 1/5 页

-- MySQL dump 10.11
--
-- Host: localhost    Database: bookstore
-- ------------------------------------------------------
-- Server version	5.0.45-community-nt
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!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' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `t_account`
--

DROP TABLE IF EXISTS `t_account`;
CREATE TABLE `t_account` (
  `username` varchar(20) NOT NULL,
  `password` varchar(32) NOT NULL,
  `email` varchar(50) default NULL,
  `privilege` int(11) NOT NULL,
  `createdDate` datetime NOT NULL,
  `name` varchar(10) default NULL,
  `address` varchar(100) default NULL,