[Openposs-cvs-commits] CVS: Database MySQL_Creation_Script,1.8,1.9

[<ope...@li...>]

Update of /cvsroot/openposs/Database
In directory usw-pr-cvs1:/tmp/cvs-serv15355

Modified Files:
	MySQL_Creation_Script 
Log Message:

Added Modules table.


Index: MySQL_Creation_Script
===================================================================
RCS file: /cvsroot/openposs/Database/MySQL_Creation_Script,v
retrieving revision 1.8
retrieving revision 1.9
diff -C2 -d -r1.8 -r1.9
*** MySQL_Creation_Script	26 Jun 2002 01:22:26 -0000	1.8
--- MySQL_Creation_Script	28 Jun 2002 10:03:23 -0000	1.9
***************
*** 23,26 ****
--- 23,27 ----
  #              #     # 'WorkPhone', and 'OtherPhone' to table                  #
  #              #     # 'openPOS.Customer'.                                     #
+ # Jun 27,2002  # CWS # Added modules table.                                    #
  #              #     #                                                         #
  ################################################################################
***************
*** 146,149 ****
--- 147,163 ----
                                     GroupName varchar(255) NOT NULL default "",
                                     Active tinyint NOT NULL default 1);
+ 
+ #
+ # Table structure for table `modules`
+ #
+ 
+ CREATE TABLE modules (
+                          name varchar(25) NOT NULL default '',
+                         desciption varchar(100) default NULL,
+                         status enum('A','I') NOT NULL default 'I',
+                          menu enum('Y','N') NOT NULL default 'N',
+                          UNIQUE KEY name (name)) TYPE=MyISAM;
+ # --------------------------------------------------------
+ 
  
  #