Temos pavadinimas: WordPress, Shopify ir PHPFusion programuotojų bendruomenė :: Kaip sukurti table?

Parašė Kižas· 2011 Geg. 24 22:05:02
#6

Galiu duoti php-fusion v7 vartotojo profilio laukelių sukūrima, tiesiog nusikopijuok si koda i PMA i lauka SQL ir paspausk vykdyti, tokiu pat principu gali ir kitus laukelius susikurti tik nepamirsk pacio table susikurti jei jo dar nera.



CREATE TABLE IF NOT EXISTS `bbdNesakysiu_users` (
  `user_id` mediumint(8) unsigned NOT NULL auto_increment,
  `user_name` varchar(30) NOT NULL default '',
  `user_algo` varchar(10) NOT NULL default 'sha256',
  `user_salt` varchar(40) NOT NULL default '',
  `user_password` varchar(64) NOT NULL default '',
  `user_admin_algo` varchar(10) NOT NULL default 'sha256',
  `user_admin_salt` varchar(40) NOT NULL default '',
  `user_admin_password` varchar(64) NOT NULL default '',
  `user_email` varchar(100) NOT NULL default '',
  `user_hide_email` tinyint(1) unsigned NOT NULL default '1',
  `user_offset` char(5) NOT NULL default '0',
  `user_avatar` varchar(100) NOT NULL default '',
  `user_posts` smallint(5) unsigned NOT NULL default '0',
  `user_threads` text NOT NULL,
  `user_joined` int(10) unsigned NOT NULL default '0',
  `user_lastvisit` int(10) unsigned NOT NULL default '0',
  `user_ip` varchar(45) NOT NULL default '0.0.0.0',
  `user_ip_type` tinyint(1) unsigned NOT NULL default '4',
  `user_rights` text NOT NULL,
  `user_groups` text NOT NULL,
  `user_level` tinyint(3) unsigned NOT NULL default '101',
  `user_status` tinyint(1) unsigned NOT NULL default '0',
  `user_actiontime` int(10) unsigned NOT NULL default '0',
  `user_theme` varchar(100) NOT NULL default 'Default',
  `user_location` varchar(50) NOT NULL default '',
  `user_birthdate` date NOT NULL default '0000-00-00',
  `user_skype` varchar(100) NOT NULL default '',
  `user_aim` varchar(16) NOT NULL default '',
  `user_icq` varchar(15) NOT NULL default '',
  `user_msn` varchar(100) NOT NULL default '',
  `user_yahoo` varchar(100) NOT NULL default '',
  `user_web` varchar(200) NOT NULL default '',
  `user_sig` text NOT NULL,
  PRIMARY KEY  (`user_id`),
  KEY `user_name` (`user_name`),
  KEY `user_joined` (`user_joined`),
  KEY `user_lastvisit` (`user_lastvisit`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;