phpmp-commits

[Brian R. <hei...@us...>]

Update of /cvsroot/phpmp/phpMP/dba/sql
In directory sc8-pr-cvs1:/tmp/cvs-serv14820/dba/sql

Modified Files:
	mysql_default_vals.sql mysql_structure.sql 
Log Message:
Updated MySQL SQL insert files.


Index: mysql_default_vals.sql
===================================================================
RCS file: /cvsroot/phpmp/phpMP/dba/sql/mysql_default_vals.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -r1.2 -r1.3
*** mysql_default_vals.sql	3 Dec 2002 08:37:11 -0000	1.2
--- mysql_default_vals.sql	3 Dec 2002 12:35:56 -0000	1.3
***************
*** 4,8 ****
  #
  # Host: localhost
! # Generation Time: Dec 02, 2002 at 04:28 AM
  # Server version: 3.23.53
  # PHP Version: 4.2.3
--- 4,8 ----
  #
  # Host: localhost
! # Generation Time: Dec 03, 2002 at 05:32 AM
  # Server version: 3.23.53
  # PHP Version: 4.2.3
***************
*** 17,25 ****
  INSERT INTO phpmp_config VALUES ('default_tpl', 'TealMP');
  INSERT INTO phpmp_config VALUES ('override_usr_tpl', '0');
! INSERT INTO phpmp_config VALUES ('site_name', 'phpMP Development');
  INSERT INTO phpmp_config VALUES ('default_lang', 'english');
! INSERT INTO phpmp_config VALUES ('date_format', 'M j, Y h:iA');
  INSERT INTO phpmp_config VALUES ('enable_account_activation', '0');
! INSERT INTO phpmp_config VALUES ('system_timezone', '-5');  # -5 is EST.
! INSERT INTO phpmp_config VALUES ('version', '0.1a');  # Version 
! INSERT INTO phpmp_config VALUES ('use_perms', '0');  # Don't use Auth for now.
--- 17,31 ----
  INSERT INTO phpmp_config VALUES ('default_tpl', 'TealMP');
  INSERT INTO phpmp_config VALUES ('override_usr_tpl', '0');
! INSERT INTO phpmp_config VALUES ('site_name', 'phpMP');
  INSERT INTO phpmp_config VALUES ('default_lang', 'english');
! INSERT INTO phpmp_config VALUES ('default_date_format', 'M j, Y h:ia');
  INSERT INTO phpmp_config VALUES ('enable_account_activation', '0');
! INSERT INTO phpmp_config VALUES ('system_timezone', '-7');
! INSERT INTO phpmp_config VALUES ('version', '0.1a');
! INSERT INTO phpmp_config VALUES ('use_perms', '0');
! 
! #
! # Dumping data for table `phpmp_users`
! #
! 
! INSERT INTO phpmp_users VALUES (-1, 'Anonymous', '', 1, '', '', 0, 'M j, Y h:ia', '', '');
\ No newline at end of file

Index: mysql_structure.sql
===================================================================
RCS file: /cvsroot/phpmp/phpMP/dba/sql/mysql_structure.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -r1.1 -r1.2
*** mysql_structure.sql	2 Dec 2002 11:31:11 -0000	1.1
--- mysql_structure.sql	3 Dec 2002 12:35:56 -0000	1.2
***************
*** 4,8 ****
  #
  # Host: localhost
! # Generation Time: Dec 02, 2002 at 04:25 AM
  # Server version: 3.23.53
  # PHP Version: 4.2.3
--- 4,8 ----
  #
  # Host: localhost
! # Generation Time: Dec 03, 2002 at 05:30 AM
  # Server version: 3.23.53
  # PHP Version: 4.2.3
***************
*** 18,20 ****
--- 18,39 ----
    config_value varchar(255) NOT NULL default '',
    PRIMARY KEY  (config_key)
+ ) TYPE=MyISAM;
+ # --------------------------------------------------------
+ 
+ #
+ # Table structure for table `phpmp_users`
+ #
+ 
+ CREATE TABLE phpmp_users (
+   userid mediumint(8) NOT NULL auto_increment,
+   username varchar(24) NOT NULL default '',
+   passwd varchar(32) NOT NULL default '',
+   active tinyint(1) NOT NULL default '0',
+   email varchar(255) NOT NULL default '',
+   actkey varchar(32) NOT NULL default '',
+   auth_level tinyint(1) NOT NULL default '0',
+   date_format varchar(32) NOT NULL default '',
+   template varchar(32) NOT NULL default '',
+   signature varchar(255) NOT NULL default '',
+   PRIMARY KEY  (userid)
  ) TYPE=MyISAM;