Update of /cvsroot/openposs/Database
In directory usw-pr-cvs1:/tmp/cvs-serv7858
Modified Files:
MySQL_Creation_Script
Log Message:
Added default values for modules. Dummy Values. Must be removed when modules are actually build.
Index: MySQL_Creation_Script
===================================================================
RCS file: /cvsroot/openposs/Database/MySQL_Creation_Script,v
retrieving revision 1.9
retrieving revision 1.10
diff -C2 -d -r1.9 -r1.10
*** MySQL_Creation_Script 28 Jun 2002 10:03:23 -0000 1.9
--- MySQL_Creation_Script 29 Jun 2002 02:30:18 -0000 1.10
***************
*** 11,15 ****
# RDBMS : MySQL
#
-
################################################################################
# Last Update # Who # Changes Made #
--- 11,14 ----
***************
*** 24,28 ****
# # # 'openPOS.Customer'. #
# Jun 27,2002 # CWS # Added modules table. #
! # # # #
################################################################################
#
--- 23,28 ----
# # # 'openPOS.Customer'. #
# Jun 27,2002 # CWS # Added modules table. #
! # Jun 28,2002 # CWS # Primed modules table with generic values. once 'real' #
! # # # modules are avaiable, these need to be removed #
################################################################################
#
***************
*** 158,161 ****
--- 158,171 ----
menu enum('Y','N') NOT NULL default 'N',
UNIQUE KEY name (name)) TYPE=MyISAM;
+ # --------------------------------------------------------
+ #--------REMOVE ME ONCE REAL MODULES ARE AVAILBE!!!-------
+
+ INSERT INTO modules VALUES ('Transaction', 'The transaction module', 'A', 'Y');
+ INSERT INTO modules VALUES ('Inventory', 'The inventory management module', 'A', 'Y');
+ INSERT INTO modules VALUES ('Quote', NULL, 'A', 'Y');
+ INSERT INTO modules VALUES ('Scheduling', NULL, 'I', 'Y');
+
+ #**********************************************************
+ # --------------------------------------------------------
# --------------------------------------------------------
|
