initdb.sql

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

DROP TABLE IF EXISTS tb_sell1;
CREATE TABLE tb_sell1 (
  SellSerial int(11) NOT NULL default '0',
  BookSerial char(30) NOT NULL default '',
  Count decimal(5,0) NOT NULL default '0',
  DisCount decimal(3,0) default '100',
  PRIMARY KEY  (SellSerial,BookSerial)
) TYPE=MyISAM;

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

--
-- Dumping data for table 'tb_sell1'
--


LOCK TABLES tb_sell1 WRITE;

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

--
-- Table structure for table 'tb_sell2'
--

DROP TABLE IF EXISTS tb_sell2;
CREATE TABLE tb_sell2 (
  SellSerial int(11) NOT NULL auto_increment,
  CustomerID varchar(20) NOT NULL default '',
  PayType int(11) NOT NULL default '0',
  OrderDate datetime default NULL,
  SellDate date default NULL,
  Memoir text,
  PRIMARY KEY  (SellSerial)
) TYPE=MyISAM;

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

--
-- Dumping data for table 'tb_sell2'
--


LOCK TABLES tb_sell2 WRITE;

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

--
-- Table structure for table 'tb_store'
--

DROP TABLE IF EXISTS tb_store;
CREATE TABLE tb_store (
  BookSerial varchar(30) NOT NULL default '',
  BookCount decimal(5,0) NOT NULL default '0',
  Memoir text,
  PRIMARY KEY  (BookSerial)
) TYPE=MyISAM;

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

--
-- Dumping data for table 'tb_store'
--


LOCK TABLES tb_store WRITE;
INSERT INTO tb_store VALUES ('7-5083-1485-9',9,NULL),('7-302-06249-8',54,NULL);

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

--
-- Table structure for table 'tb_user'
--

DROP TABLE IF EXISTS tb_user;
CREATE TABLE tb_user (
  ID char(20) NOT NULL default '',
  Passwd char(16) default NULL,
  Priv char(1) NOT NULL default '2',
  Name char(20) default NULL,
  Age decimal(3,0) default NULL,
  Gender char(1) default NULL,
  Address char(30) default NULL,
  Zip char(10) default NULL,
  Phone char(15) default NULL,
  Email char(30) default NULL,
  PRIMARY KEY  (ID)
) TYPE=MyISAM;

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

--
-- Dumping data for table 'tb_user'
--


LOCK TABLES tb_user WRITE;
INSERT INTO tb_user VALUES ('ganzhi','password','1',NULL,NULL,NULL,NULL,NULL,NULL,NULL),('cyk','123456','2',NULL,NULL,NULL,NULL,NULL,NULL,NULL),('dt','123456','2',NULL,NULL,NULL,NULL,NULL,NULL,NULL);

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