Create table (GNU Artanis web-framework Manual)

Next: Get columns from table, Previous: Map DB table, Up: FPRM (experimental) [Contents]

15.6.3 Create table ¶

(m 'create table-name defs #:if-exists? #f #:primary-keys '() #:engine #f)

table-name specifies the name of the DB table.

defs is a list to define the type of columns. For example:

'((name varchar 10) (age integer) (email varchar 20))

#:if-exists? has two kinds of possible options:
- ’overwrite and ’drop, which will overwrite the existing table.
- ’ignore means to ignore the table when it already exists.
#:primary-keys specifies the primary keys in the created table.

#:engine specifies the DB engine. It depends on what dbd you chose.