root/modules/branches/2.4/customerdb/install.sql

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);
Note: See TracBrowser for help on using the browser.