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;
+ # --------------------------------------------------------
+
#
|
