upgrade.sql
changeset 179 36b287f1d85c
parent 177 492510dddc34
child 180 c63c5ee6c6d6
--- a/upgrade.sql	Sun Oct 07 17:28:47 2007 -0400
+++ b/upgrade.sql	Sun Oct 07 21:28:36 2007 -0400
@@ -5,9 +5,10 @@
 DELETE FROM {{TABLE_PREFIX}}config WHERE config_name='enano_version' OR config_name='enano_beta_version' OR config_name='enano_alpha_version' OR config_name='enano_rc_version';
 INSERT INTO {{TABLE_PREFIX}}config (config_name, config_value) VALUES( 'enano_version', '1.1.1' );
 ---BEGIN Stable1.0ToUnstable1.1---
-UPDATE {{TABLE_PREFIX}}groups SET group_id=9998 WHERE group_id=4;
-UPDATE {{TABLE_PREFIX}}group_members SET group_id=9998 WHERE group_id=4;
-INSERT INTO {{TABLE_PREFIX}}groups(group_id,group_name,group_type,system_group) VALUES(4, 'Regular members', 3, 1);
+-- UPDATE {{TABLE_PREFIX}}groups SET group_id=9998 WHERE group_id=4;
+-- UPDATE {{TABLE_PREFIX}}group_members SET group_id=9998 WHERE group_id=4;
+-- INSERT INTO {{TABLE_PREFIX}}groups(group_id,group_name,group_type,system_group) VALUES(4, 'Regular members', 3, 1);
+CREATE TABLE {{TABLE_PREFIX}}lockout( id int(12) NOT NULL auto_increment, ipaddr varchar(40) NOT NULL, action ENUM('credential', 'level') NOT NULL DEFAULT 'credential', timestamp int(12) NOT NULL DEFAULT 0, PRIMARY KEY ( id ) ) CHARACTER SET `utf8`;
 ---END Stable1.0ToUnstable1.1---
 ---BEGIN 1.0.2---
 ---END 1.0.2---