<?php
class UserTable extends Table {
	
	const C_TABLE = "USERS" ;
	const C_ID = "USER_ID" ;
	const C_NAME = "USER_NAME";
	const C_FULL_NAME = "USER_FULL_NAME";
	const C_EMAIL = "USER_EMAIL" ;
	const C_PHONE = "USER_PHONE" ;
	const C_LAST_LOGIN = "USER_LAST_LOGIN";
	const C_PWD1 = "USER_PWD1" ;
	const C_PWD2 = "USER_PWD2";
	const C_GROUP = "USER_GROUP";
	const C_BLOCKED = "BLOCKED";
	const C_FAIL_COUNT = "USER_FAIL_COUNT";
	const C_COMMENTS = "USER_COMMENTS" ;
	const C_CHANGE_PWD = "USER_CHANGE_PWD";
	const C_START_DATE = "USER_START_DATE" ;
	const C_EXPIRY_DATE = "USER_EXPIRY_DATE" ;
	const C_SUBTITUTE = "USER_SUBTITUTE_ID" ;
	const C_DESIGNATION = "USER_DESIGNATION_ID";
	const C_DEPT = "USER_DEPT_ID" ;
	const C_COM_LOC = "DEFAULT_COMPANY_LOCATION" ;
}

class UserTableDetail extends TableDetail {

	const C_ID = "identity|||" ;
	const C_NAME = "nvarchar|20|NO|''";
	const C_FULL_NAME = "nvarchar|50|NO|''";
	const C_EMAIL = "nvarchar|80|NO|''" ;
	const C_PHONE = "nvarchar|15|NO|''" ;
	const C_LAST_LOGIN = "datetime||NO|getdate()";
	const C_PWD1 = "nvarchar|40|NO|''" ;
	const C_PWD2 = "nvarchar|40|NO|''";
	const C_GROUP = "int||NO|''";
	const C_BLOCKED = "bit||NO|(0)";
	const C_FAIL_COUNT = "tinyint||NO|(0)";
	const C_COMMENTS = "ntext||YES|" ;
	const C_CHANGE_PWD = "tinyint||NO|(0)";
	const C_START_DATE = "datetime||NO|getdate()" ;
	const C_EXPIRY_DATE = "datetime||NO|getdate()" ;
	const C_SUBTITUTE = "int||NO|(0)" ;
	const C_DESIGNATION = "int||NO|(0)" ;
	const C_DEPT = "int||NO|(0)" ;
	const C_COM_LOC = "int||NO|(0)" ;
}
?>