PHP7 fix

[Pman.Core] / sql / core_group.sql

diff --git a/sql/core_group.sql b/sql/core_group.sql
index a23a20d..05e0087 100644 (file)
--- a/sql/core_group.sql
+++ b/sql/core_group.sql
@@ -1,15 +1,17 @@
 
 
 
--- used to be Groups .... we will need to flip all old code to use this...
+-- IF you are working on an old system... - copy the changes to Groups.sql...
  
-CREATE TABLE core_groups (
+CREATE TABLE core_group (
   id int(11) NOT NULL auto_increment,  
   PRIMARY KEY   (id)
 );
 
-ALTER TABLE Groups ADD COLUMN name varchar(128)  NOT NULL DEFAULT '';
-ALTER TABLE Groups ADD COLUMN type  int(11)  NOT NULL DEFAULT 0;
-ALTER TABLE Groups ADD COLUMN leader int(11)  NOT NULL default 0;
-ALTER TABLE Groups ADD COLUMN is_system int(2) NOT NULL default 0;
+ALTER TABLE core_group ADD COLUMN name varchar(128)  NOT NULL DEFAULT '';
+ALTER TABLE core_group ADD COLUMN display_name varchar(128)  NOT NULL DEFAULT '';
+ALTER TABLE core_group ADD COLUMN type  int(11)  NOT NULL DEFAULT 0;
+ALTER TABLE core_group ADD COLUMN leader int(11)  NOT NULL default 0;
+ALTER TABLE core_group ADD COLUMN is_system int(2) NOT NULL default 0;
 
+ALTER TABLE core_group ADD INDEX lookup_leader (leader);
\ No newline at end of file