#Main Database $maintablessql = array (); #user $deftab = " `user_pass` varchar(64) NOT NULL default '', `user_realname` varchar(80) NOT NULL default '', `user_nicename` varchar(50) NOT NULL default '', `user_photo` varchar(64) NOT NULL default '', `user_email` varchar(100) NOT NULL default '', `user_renewpass` INT(1) NOT NULL default '1', `user_renewpcode` varchar(64) NOT NULL default '', `user_multilogin` INT(1) NOT NULL default '2', `user_privilid` INT(11) UNSIGNED NOT NULL default 0, `user_status` INT(1) NOT NULL default '3', `user_cid` INT(11) UNSIGNED NOT NULL default 0, `user_cdate` DATETIME NULL default NULL, `user_cip` varchar(31) NOT NULL default '', `user_uid` INT(11) UNSIGNED NOT NULL default 0, `user_udate` DATETIME NULL default NULL, `user_uip` varchar(31) NOT NULL default '', `user_hiscol` TEXT, "; // additional user for deftab $deftab .= " "; $maintablessql["user"] = " CREATE TABLE `".$table_prefix."user` ( `user_id` INT(11) UNSIGNED NOT NULL auto_increment, `user_login` varchar(20) UNIQUE, $deftab PRIMARY KEY (`user_id`) ) ENGINE=INNODB character set utf8; "; $maintablessql["userhistory"] = " CREATE TABLE `".$table_prefix."userhistory` ( `userhistory_id` INT(11) UNSIGNED NOT NULL auto_increment, `user_id` INT(11) UNSIGNED NOT NULL, `user_login` varchar(20) NOT NULL default '', $deftab PRIMARY KEY (`userhistory_id`) ) ENGINE=INNODB character set utf8; "; #privil $deftab = " `privil_sort` INT(3) UNSIGNED NOT NULL default 0, `privil_name` varchar(50) NOT NULL default '', `privil_val` TEXT, `privil_status` INT(1) UNSIGNED NOT NULL default 3, `privil_cid` INT(11) UNSIGNED NOT NULL default 0, `privil_cdate` DATETIME NULL default NULL, `privil_cip` VARCHAR(31) NOT NULL default '', `privil_uid` INT(11) UNSIGNED NOT NULL default 0, `privil_udate` DATETIME NULL default NULL, `privil_uip` VARCHAR(31) NOT NULL default '', `privil_hiscol` TEXT, "; $maintablessql["privil"] = " CREATE TABLE `".$table_prefix."privil` ( `privil_id` INT(11) UNSIGNED NOT NULL auto_increment, $deftab PRIMARY KEY (`privil_id`) ) ENGINE=INNODB character set utf8; "; $maintablessql["privilhistory"] = " CREATE TABLE `".$table_prefix."privilhistory` ( `privilhistory_id` INT(11) UNSIGNED NOT NULL auto_increment, `privil_id` INT(11) UNSIGNED NOT NULL, $deftab PRIMARY KEY (`privilhistory_id`) ) ENGINE=INNODB character set utf8; "; #userloginhis $maintablessql["userloginhis"] = " CREATE TABLE `".$table_prefix."userloginhis` ( `userloginhis_id` bigint(20) NOT NULL auto_increment, `userloginhis_userid` int(10) NOT NULL DEFAULT '0', `userloginhis_ip` varchar(31) NOT NULL DEFAULT '', `userloginhis_agent` varchar(255) NOT NULL DEFAULT '', `userloginhis_sid` varchar(32) NOT NULL DEFAULT '', `userloginhis_inout` int(1) NOT NULL DEFAULT '0', `userloginhis_intime` datetime DEFAULT NULL, `userloginhis_lasttime` datetime DEFAULT NULL, `userloginhis_fcmid` varchar(255) DEFAULT '', `userloginhis_token` varchar(64) NOT NULL DEFAULT '', `userloginhis_chipher` varchar(32) NOT NULL DEFAULT '', `userloginhis_appver` varchar(10) NOT NULL DEFAULT '', `userloginhis_apptype` varchar(10) NOT NULL DEFAULT '', PRIMARY KEY (`userloginhis_id`) ) ENGINE=INNODB character set utf8; "; #var $deftab = " `var_group` varchar(10) NOT NULL default '', `var_value` TEXT, `var_uid` INT(11) UNSIGNED NOT NULL default 0, `var_udate` DATETIME NULL default NULL, `var_uip` varchar(31) NOT NULL default '', `var_hiscol` TEXT, "; # $maintablessql["var"] = " CREATE TABLE `".$table_prefix."var` ( `var_id` INT(11) UNSIGNED NOT NULL auto_increment, `var_name` varchar(255) NOT NULL UNIQUE, $deftab PRIMARY KEY (`var_id`) ) ENGINE=INNODB character set utf8; "; $maintablessql["varhistory"] = " CREATE TABLE `".$table_prefix."varhistory` ( `varhistory_id` INT(11) UNSIGNED NOT NULL auto_increment, `var_id` INT(11) UNSIGNED NOT NULL, `var_name` varchar(255) NOT NULL, $deftab PRIMARY KEY (`varhistory_id`) ) ENGINE=INNODB character set utf8; "; #uscook $deftab = " `uscook_userid` INT(11) UNSIGNED NOT NULL, `uscook_varname` varchar(64) NOT NULL default '', `uscook_varvalue` TEXT, "; $maintablessql["uscook"] = " CREATE TABLE `".$table_prefix."uscook` ( `uscook_id` INT(11) UNSIGNED NOT NULL auto_increment, $deftab PRIMARY KEY (`uscook_id`) ) ENGINE=INNODB character set utf8; "; #akey $deftab = " `akey_name` varchar(50) NOT NULL default '', `akey_val` varchar(64) NULL default NULL, `akey_chipher` varchar(64) NULL default NULL, `akey_defval` TEXT, `akey_dodecrypt` ENUM('1','0') NOT NULL DEFAULT '1', `akey_doencrypt` ENUM('1','0') NOT NULL DEFAULT '1', `akey_status` INT(1) UNSIGNED NOT NULL default 3, `akey_cid` INT(11) UNSIGNED NOT NULL default 0, `akey_cdate` DATETIME NULL default NULL, `akey_cip` VARCHAR(31) NOT NULL default '', `akey_uid` INT(11) UNSIGNED NOT NULL default 0, `akey_udate` DATETIME NULL default NULL, `akey_uip` VARCHAR(31) NOT NULL default '', `akey_hiscol` TEXT, "; $maintablessql["akey"] = " CREATE TABLE `".$table_prefix."akey` ( `akey_id` INT(11) UNSIGNED NOT NULL auto_increment, $deftab PRIMARY KEY (`akey_id`) ) ENGINE=INNODB character set utf8; "; $maintablessql["akeyhistory"] = " CREATE TABLE `".$table_prefix."akeyhistory` ( `akeyhistory_id` INT(11) UNSIGNED NOT NULL auto_increment, `akey_id` INT(11) UNSIGNED NOT NULL, $deftab PRIMARY KEY (`akeyhistory_id`) ) ENGINE=INNODB character set utf8; "; #alog $deftab = " `alog_url` TEXT, `alog_token` varchar(64) NOT NULL default '', `alog_agent` varchar(255) NOT NULL default '', `alog_method` varchar(10) NOT NULL default '', `alog_akeyid` INT(11) UNSIGNED NOT NULL, `alog_sid` varchar(32) NOT NULL default '', `alog_auth` TEXT, `alog_get` TEXT, `alog_post` TEXT, `alog_cdate` DATETIME NULL default NULL, `alog_cip` VARCHAR(31) NOT NULL default '', "; $maintablessql["alog"] = " CREATE TABLE `".$table_prefix."alog` ( `alog_id` BIGINT(20) UNSIGNED NOT NULL auto_increment, $deftab PRIMARY KEY (`alog_id`) ) ENGINE=INNODB character set utf8; "; #---------- End Main Tables SQL ?>