home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Chip 2003 July
/
CMCD0703.ISO
/
Software
/
Freeware
/
Programare
/
bugzero
/
WEB-INF
/
classes
/
sql
/
create_table_person.sql
< prev
next >
Encoding:
Amiga
Atari
Commodore
DOS
FM Towns/JPY
Macintosh
Macintosh JP
NeXTSTEP
RISC OS/Acorn
UTF-8
Wrap
Text File
|
2003-05-03
|
329 b
|
12 lines
# create the person table
CREATE TABLE person (
person_id INT NOT NULL,
group_code VARCHAR(50) NOT NULL,
username VARCHAR(50) NOT NULL,
password VARCHAR(50) NOT NULL,
fullname VARCHAR(64) NOT NULL,
email VARCHAR(50) NOT NULL,
default_project VARCHAR(50),
signature LONGTEXT,
PRIMARY KEY (person_id)
)