Changeset 21519 for extensions/UserAdvManager/trunk/maintain.inc.php
- Timestamp:
- Mar 12, 2013, 6:54:01 PM (11 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
extensions/UserAdvManager/trunk/maintain.inc.php
r21075 r21519 172 172 // Create USER_CONFIRM_MAIL_TABLE 173 173 // ------------------------------ 174 $q = "175 CREATE TABLE IF NOT EXISTS ".USER_CONFIRM_MAIL_TABLE."(176 id varchar(50) NOT NULL default '',177 user_id smallint(5) NOT NULL default '0',174 $q = ' 175 CREATE TABLE IF NOT EXISTS '.USER_CONFIRM_MAIL_TABLE.' ( 176 id varchar(50) NOT NULL default "", 177 user_id smallint(5) NOT NULL default "0", 178 178 mail_address varchar(255) default NULL, 179 status enum( 'webmaster','admin','normal','generic','guest') default NULL,179 status enum("webmaster","admin","normal","generic","guest") default NULL, 180 180 date_check datetime default NULL, 181 reminder ENUM( 'true','false') NULL,181 reminder ENUM("true","false") NULL, 182 182 PRIMARY KEY (id) 183 183 ) 184 ENGINE=MyISAM; ";184 ENGINE=MyISAM;'; 185 185 pwg_query($q); 186 186 187 187 // Create USER_LASTVISIT_TABLE 188 188 // --------------------------- 189 $q = "190 CREATE TABLE IF NOT EXISTS ".USER_LASTVISIT_TABLE."(191 user_id SMALLINT(5) NOT NULL DEFAULT '0',189 $q = ' 190 CREATE TABLE IF NOT EXISTS '.USER_LASTVISIT_TABLE.' ( 191 user_id SMALLINT(5) NOT NULL DEFAULT "0", 192 192 lastvisit DATETIME NULL DEFAULT NULL, 193 reminder ENUM( 'true','false') NULL,193 reminder ENUM("true","false") NULL, 194 194 PRIMARY KEY (`user_id`) 195 195 ) 196 ENGINE=MyISAM; ";196 ENGINE=MyISAM;'; 197 197 pwg_query($q); 198 198
Note: See TracChangeset
for help on using the changeset viewer.