File: test.create

package info (click to toggle)
xmysql 1.8-1
  • links: PTS
  • area: contrib
  • in suites: hamm
  • size: 720 kB
  • ctags: 265
  • sloc: ansic: 2,602; makefile: 63; sql: 1
file content (10 lines) | stat: -rw-r--r-- 194 bytes parent folder | download | duplicates (2) 
1
2
3
4
5
6
7
8
9
10
 
CREATE TABLE RICK (
id INT AUTO_INCREMENT PRIMARY KEY  ,
name CHAR( 20),
name2 CHAR(30) NOT NULL ,
name3 CHAR(10) NULL,
ssn INTEGER(9) ZEROFILL ,
INDEX ssnIdx (ssn),
INDEX nameidx (name(5))
);