Location: PHPKode > projects > phpMyVisites > phpmv2/core/include/updates/update-2.0beta2.php
<?php

	// new user management system
	// erase old tables
	// create new ones
	// add anonymous user
	// add basic groups
	
$allQueries = array(
	'DROP TABLE IF EXISTS '.T_USERS,
	'DROP TABLE IF EXISTS '.T_GROUPS,
	'DROP TABLE IF EXISTS '.T_USERS_LINK_GROUPS,
	"CREATE TABLE ".T_USERS." (
		  `login` varchar(20) NOT NULL default '',
		  `password` varchar(255) default NULL,
		  `alias` varchar(45) default NULL,
		  `email` varchar(100) NOT NULL default '',
		  `rss_hash` varchar(100) NOT NULL default '',
		  `date_registered` int(11) default NULL,
		  PRIMARY KEY  (`login`)
		) TYPE=MyISAM
	",
	"CREATE TABLE ".T_USERS_LINK_GROUPS." (
		  `idsite` int(10) unsigned NOT NULL default '0',
		  `idgroups` int(10) unsigned NOT NULL default '0',
		  `login` varchar(20) NOT NULL default '0',
		  PRIMARY KEY  (`idsite`,`idgroups`,`login`)
		) TYPE=MyISAM
	",
	"CREATE TABLE ".T_GROUPS." (
		  `idgroups` int(10) unsigned NOT NULL auto_increment,
		  `name` varchar(20) default NULL,
		  `view` tinyint(1) unsigned default '0',
		  `admin` tinyint(3) unsigned default '0',
		  PRIMARY KEY  (`idgroups`)
		) TYPE=MyISAM 
	",
	"INSERT INTO ".T_GROUPS." VALUES (1, 'admin', 1, 1)",
	"INSERT INTO ".T_GROUPS." VALUES (2, 'view', 1, 0)",
	"INSERT INTO ".T_USERS." VALUES ('anonymous', NULL, 'Anonymous user', '', 'ffffffffffffff493e8d55a4a75de3f90a1', NULL)",
	
	);

foreach($allQueries as $query)
{
	query($query);
}	
	

	
?>
Return current item: phpMyVisites