You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@struts.apache.org by dw...@apache.org on 2001/07/09 04:58:15 UTC

cvs commit: jakarta-struts/contrib/validator/sql/jdbc-example REGISTRATION.sql

dwinterfeldt    01/07/08 19:58:15

  Added:       contrib/validator/sql/jdbc-example REGISTRATION.sql
  Log:
  Adding Struts Validator.
  
  Revision  Changes    Path
  1.1                  jakarta-struts/contrib/validator/sql/jdbc-example/REGISTRATION.sql
  
  Index: REGISTRATION.sql
  ===================================================================
  create table REGISTRATION (
  
  	ID int not null primary key,
  	FIRST_NAME varchar(30) NOT NULL,
  	LAST_NAME varchar(60) NOT NULL unique,
  	ADDR varchar(120) NULL,
          CITY varchar(50) NULL,
          STATE_PROV varchar(50) NULL,
          ZIP_POSTAL varchar(20) NULL,
          PHONE varchar(30) NULL,
          EMAIL varchar(120) NOT NULL,
          B_ACTIVE NUMBER(1,0) NOT NULL,
  	DATE_CREATED datetime NULL,
  	DATE_MODIFIED datetime NULL, 
  	USER_NAME varchar(50) NULL 
  
  )