建表.sql

来自「很好地delphi书籍源码」· SQL 代码 · 共 64 行

/*
Alias: WORK
LiveAnswer: FALSE

*/

CREATE TABLE   "英语.dbf" (
	id int,
	MyTitle  char(20)  ,
	MyColumn char(20)  ,
	MyGroup  char(20)  ,
	Detail   blob(0,1)
)

CREATE TABLE   "英语插图.db"(
	id int,
	MyTitle  char(20)  ,
	MyColumn char(20)  ,
	MyGroup  char(20)  ,
	MyNo     char(6)  , 
	Picture  blob(0,5) ,
	PRIMARY KEY(ID)
)

CREATE TABLE   "语文.dbf" (
	id int,
	MyTitle  char(20)  ,
	MyColumn char(20)  ,
	MyGroup  char(20)  ,
	Detail   blob(0,1)
)

CREATE TABLE   "语文插图.db"(
	id int,
	MyTitle  char(20)  ,
	MyColumn char(20)  ,
	MyGroup  char(20)  ,
	MyNo     char(6)  , 
	Picture  blob(0,5) ,
	PRIMARY KEY(ID)
)

CREATE TABLE   "数学.dbf" (
	id int,
	MyTitle  char(20)  ,
	MyColumn char(20)  ,
	MyGroup  char(20)  ,
	Detail   blob(0,1)
)

CREATE TABLE   "数学插图.db"(
	id int,
	MyTitle  char(20)  ,
	MyColumn char(20)  ,
	MyGroup  char(20)  ,
	MyNo     char(6)  , 
	Picture  blob(0,5) ,
	PRIMARY KEY(ID)
)