initdb.sql

这是一个DELPHI7应用案例开发篇有配套程序种子光盘

  PRIMARY KEY  (BuySerial)
) TYPE=MyISAM;

/*!40000 ALTER TABLE tb_buy2 DISABLE KEYS */;

--
-- Dumping data for table 'tb_buy2'
--


LOCK TABLES tb_buy2 WRITE;
INSERT INTO tb_buy2 VALUES (21,'2003-05-15',''),(20,'2003-05-15',''),(19,'2003-05-15','');

/*!40000 ALTER TABLE tb_buy2 ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table 'tb_customer'
--

DROP TABLE IF EXISTS tb_customer;
CREATE TABLE tb_customer (
  ID varchar(20) NOT NULL default '',
  Passwd varchar(16) NOT NULL default '',
  Name varchar(20) NOT NULL default '',
  Age decimal(3,0) default NULL,
  Gender int(11) default NULL,
  Address varchar(30) NOT NULL default '',
  Zip varchar(10) NOT NULL default '',
  Phone varchar(15) NOT NULL default '',
  Email varchar(30) NOT NULL default '',
  Mobile varchar(15) default NULL,
  BankCard varchar(20) default NULL,
  CardType varchar(5) default NULL,
  Memoir text,
  PRIMARY KEY  (ID)
) TYPE=MyISAM;

/*!40000 ALTER TABLE tb_customer DISABLE KEYS */;

--
-- Dumping data for table 'tb_customer'
--


LOCK TABLES tb_customer WRITE;
INSERT INTO tb_customer VALUES ('ganzhi1','password','甘志',99,-1,'123','234567','123456','gan@gan','123','123','123','jkljlk\r\n\0');

/*!40000 ALTER TABLE tb_customer ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table 'tb_order1'
--

DROP TABLE IF EXISTS tb_order1;
CREATE TABLE tb_order1 (
  OrderSerial int(11) NOT NULL default '0',
  BookSerial char(30) NOT NULL default '',
  BookCount decimal(5,0) NOT NULL default '0',
  Discount decimal(3,0) default '100',
  PRIMARY KEY  (OrderSerial,BookSerial)
) TYPE=MyISAM;

/*!40000 ALTER TABLE tb_order1 DISABLE KEYS */;

--
-- Dumping data for table 'tb_order1'
--


LOCK TABLES tb_order1 WRITE;
INSERT INTO tb_order1 VALUES (7,'7-900643-39-7',1,NULL),(8,'7-900643-39-7',1,NULL),(9,'7-5083-1485-9',1,NULL),(9,'7-900643-39-7',1,NULL),(10,'7-302-06249-8',1,100);

/*!40000 ALTER TABLE tb_order1 ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table 'tb_order2'
--

DROP TABLE IF EXISTS tb_order2;
CREATE TABLE tb_order2 (
  OrderSerial int(11) NOT NULL auto_increment,
  CustomerID varchar(20) NOT NULL default '',
  PayType int(11) NOT NULL default '0',
  OrderDate datetime default NULL,
  OrderState char(1) default NULL,
  Memoir text,
  PRIMARY KEY  (OrderSerial)
) TYPE=MyISAM;

/*!40000 ALTER TABLE tb_order2 DISABLE KEYS */;

--
-- Dumping data for table 'tb_order2'
--


LOCK TABLES tb_order2 WRITE;
INSERT INTO tb_order2 VALUES (2,'ganzhi1',0,'2003-05-26 00:00:00','0',NULL),(3,'ganzhi1',0,'2003-05-26 00:00:00','0',NULL),(4,'ganzhi1',0,'2003-05-26 00:00:00','0',NULL),(5,'ganzhi1',1,'2003-05-26 00:00:00','0',NULL),(6,'ganzhi1',1,'2003-05-26 00:00:00','0',NULL),(7,'ganzhi1',0,'2003-05-26 00:00:00','0',NULL),(8,'ganzhi1',0,'2003-05-26 00:00:00','0',NULL),(9,'ganzhi1',0,'2003-05-26 00:00:00','0',NULL),(10,'ganzhi1',0,'2003-05-26 00:00:00','0',NULL);

/*!40000 ALTER TABLE tb_order2 ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table 'tb_sell1'
--