|
Revision 2003, 447 bytes
(checked in by qldrob, 7 years ago)
|
Add Customerdb Module
|
- Property svn:mime-type set to
text/plain
- Property svn:eol-style set to
native
|
| Line | |
|---|
| 1 |
CREATE TABLE IF NOT EXISTS customerdb (id int UNIQUE AUTO_INCREMENT, name varchar(45) not null, addr1 varchar(150) not null, addr2 varchar(150) null, city varchar(50) not null, state varchar(5) not null, zip varchar(12) null, sip varchar(20) null, did varchar(45) null, device varchar(50) null, ip varchar(20) null, serial varchar(50) null, account varchar(6) null, email varchar(150) null, username varchar(25) null, password varchar(25) null); |
|---|