File: tools.msql

package info (click to toggle)
lg-issue31 5-1
  • links: PTS
  • area: main
  • in suites: sarge
  • size: 4,444 kB
  • ctags: 103
  • sloc: makefile: 34; sh: 34; perl: 31
file content (16 lines) | stat: -rw-r--r-- 481 bytes parent folder | download | duplicates (4) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
 
# drop existing table.  If it doesn't exist, msql will basically ignore
# this.
drop table tools
\g

# Create a new table in the database
create table tools (
   tooltype     int not null,                 # 0: hand tool;  1: power tool
   toolname     char(255) not null            # name of the tool
)
\p\g

# Insert a few entries into the table
insert into tools values (0, "hammer") \g
insert into tools values (0, "screwdriver") \g
insert into tools values (1, "table saw") \g