backup.sql

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

  `zip` varchar(10) default NULL,
  `telephone` varchar(20) default NULL,
  `mobile` varchar(20) default NULL,
  PRIMARY KEY  (`username`),
  UNIQUE KEY `username` (`username`)
);

--
-- Dumping data for table `t_account`
--

INSERT INTO `t_account` VALUES ('admin','37562d86a3bb6cb6de79b6ceb3641a88','[e-mail]',255,'2007-01-01 00:00:00','系统管理员','北京市','100022',NULL,NULL);
INSERT INTO `t_account` VALUES ('live','2cc8767e16945b85317afb708f9e6fdd','[e-mail]',0,'2007-03-07 13:52:00',NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `t_book`
--

DROP TABLE IF EXISTS `t_book`;
CREATE TABLE `t_book` (
  `id` varchar(32) NOT NULL,
  `categoryId` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `originalName` varchar(50) default NULL,
  `language` varchar(10) NOT NULL,