schema.sql

来自「jdbc 的实例源码」· SQL 代码 · 共 23 行

#
# create a simple cardfile file

# just in case it already exists, drop the table. If it doesn't
# exist, this will produce an error...
#
drop table cardfile
\g

create table cardfile
   (name    char(20),
    address char(35),
    city    char(20),
    state   char(2),
    zip     char(11),
    country char(25),
    phone   char(20),
    id      int) 
\g
   
CREATE UNIQUE INDEX ix_id ON cardfile (id)
\g