Edit File by line

[0] Fix | Delete

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

[1] Fix | Delete

SET time_zone = "+00:00";

[2] Fix | Delete

[3] Fix | Delete

[4] Fix | Delete

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

[5] Fix | Delete

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

[6] Fix | Delete

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

[7] Fix | Delete

/*!40101 SET NAMES utf8 */;

[8] Fix | Delete

[9] Fix | Delete

[10] Fix | Delete

-- Database: `soft_phpadr901`

[11] Fix | Delete

[12] Fix | Delete

[13] Fix | Delete

-- --------------------------------------------------------

[14] Fix | Delete

[15] Fix | Delete

[16] Fix | Delete

-- Table structure for table `addressbook`

[17] Fix | Delete

[18] Fix | Delete

[19] Fix | Delete

CREATE TABLE `addressbook` (

[20] Fix | Delete

`domain_id` int(9) unsigned NOT NULL DEFAULT '0',

[21] Fix | Delete

`id` int(9) unsigned NOT NULL,

[22] Fix | Delete

`firstname` varchar(255) NOT NULL,

[23] Fix | Delete

`middlename` varchar(255) NOT NULL,

[24] Fix | Delete

`lastname` varchar(255) NOT NULL,

[25] Fix | Delete

`nickname` varchar(255) NOT NULL,

[26] Fix | Delete

`company` varchar(255) NOT NULL,

[27] Fix | Delete

`title` varchar(255) NOT NULL,

[28] Fix | Delete

`address` text NOT NULL,

[29] Fix | Delete

`addr_long` text,

[30] Fix | Delete

`addr_lat` text,

[31] Fix | Delete

`addr_status` text,

[32] Fix | Delete

`home` text NOT NULL,

[33] Fix | Delete

`mobile` text NOT NULL,

[34] Fix | Delete

`work` text NOT NULL,

[35] Fix | Delete

`fax` text NOT NULL,

[36] Fix | Delete

`email` text NOT NULL,

[37] Fix | Delete

`email2` text NOT NULL,

[38] Fix | Delete

`email3` text NOT NULL,

[39] Fix | Delete

`im` text NOT NULL,

[40] Fix | Delete

`im2` text NOT NULL,

[41] Fix | Delete

`im3` text NOT NULL,

[42] Fix | Delete

`homepage` text NOT NULL,

[43] Fix | Delete

`bday` tinyint(2) NOT NULL,

[44] Fix | Delete

`bmonth` varchar(50) NOT NULL,

[45] Fix | Delete

`byear` varchar(4) NOT NULL,

[46] Fix | Delete

`aday` tinyint(2) NOT NULL,

[47] Fix | Delete

`amonth` varchar(50) NOT NULL,

[48] Fix | Delete

`ayear` varchar(4) NOT NULL,

[49] Fix | Delete

`address2` text NOT NULL,

[50] Fix | Delete

`phone2` text NOT NULL,

[51] Fix | Delete

`notes` text NOT NULL,

[52] Fix | Delete

`photo` mediumtext,

[53] Fix | Delete

`x_vcard` mediumtext,

[54] Fix | Delete

`x_activesync` mediumtext,

[55] Fix | Delete

`created` datetime DEFAULT NULL,

[56] Fix | Delete

`modified` datetime DEFAULT NULL,

[57] Fix | Delete

`deprecated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

[58] Fix | Delete

`password` varchar(256) DEFAULT NULL,

[59] Fix | Delete

`login` date DEFAULT NULL,

[60] Fix | Delete

`role` varchar(256) DEFAULT NULL,

[61] Fix | Delete

PRIMARY KEY (`id`,`deprecated`,`domain_id`),

[62] Fix | Delete

KEY `deprecated_domain_id_idx` (`deprecated`,`domain_id`)

[63] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

[64] Fix | Delete

[65] Fix | Delete

-- --------------------------------------------------------

[66] Fix | Delete

[67] Fix | Delete

[68] Fix | Delete

-- Table structure for table `address_in_groups`

[69] Fix | Delete

[70] Fix | Delete

[71] Fix | Delete

CREATE TABLE `address_in_groups` (

[72] Fix | Delete

`domain_id` int(9) unsigned NOT NULL DEFAULT '0',

[73] Fix | Delete

`id` int(9) unsigned NOT NULL DEFAULT '0',

[74] Fix | Delete

`group_id` int(9) unsigned NOT NULL DEFAULT '0',

[75] Fix | Delete

`created` datetime DEFAULT NULL,

[76] Fix | Delete

`modified` datetime DEFAULT NULL,

[77] Fix | Delete

`deprecated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

[78] Fix | Delete

PRIMARY KEY (`group_id`,`id`,`deprecated`)

[79] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

[80] Fix | Delete

[81] Fix | Delete

-- --------------------------------------------------------

[82] Fix | Delete

[83] Fix | Delete

[84] Fix | Delete

-- Table structure for table `group_list`

[85] Fix | Delete

[86] Fix | Delete

[87] Fix | Delete

CREATE TABLE `group_list` (

[88] Fix | Delete

`domain_id` int(9) unsigned NOT NULL DEFAULT '0',

[89] Fix | Delete

`group_id` int(9) unsigned NOT NULL AUTO_INCREMENT,

[90] Fix | Delete

`group_parent_id` int(9) DEFAULT NULL,

[91] Fix | Delete

`created` datetime DEFAULT NULL,

[92] Fix | Delete

`modified` datetime DEFAULT NULL,

[93] Fix | Delete

`deprecated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

[94] Fix | Delete

`group_name` varchar(255) NOT NULL DEFAULT '',

[95] Fix | Delete

`group_header` mediumtext NOT NULL,

[96] Fix | Delete

`group_footer` mediumtext NOT NULL,

[97] Fix | Delete

PRIMARY KEY (`group_id`,`deprecated`,`domain_id`)

[98] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

[99] Fix | Delete

[100] Fix | Delete

-- --------------------------------------------------------

[101] Fix | Delete

[102] Fix | Delete

[103] Fix | Delete

-- Table structure for table `month_lookup`

[104] Fix | Delete

[105] Fix | Delete

[106] Fix | Delete

CREATE TABLE `month_lookup` (

[107] Fix | Delete

`bmonth` varchar(50) NOT NULL DEFAULT '',

[108] Fix | Delete

`bmonth_short` char(3) NOT NULL DEFAULT '',

[109] Fix | Delete

`bmonth_num` int(2) unsigned NOT NULL DEFAULT '0',

[110] Fix | Delete

PRIMARY KEY (`bmonth_num`)

[111] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

[112] Fix | Delete

[113] Fix | Delete

[114] Fix | Delete

-- Dumping data for table `month_lookup`

[115] Fix | Delete

[116] Fix | Delete

[117] Fix | Delete

INSERT INTO `month_lookup` VALUES

[118] Fix | Delete

('', '', 0),

[119] Fix | Delete

('January', 'Jan', 1),

[120] Fix | Delete

('February', 'Feb', 2),

[121] Fix | Delete

('March', 'Mar', 3),

[122] Fix | Delete

('April', 'Apr', 4),

[123] Fix | Delete

('May', 'May', 5),

[124] Fix | Delete

('June', 'Jun', 6),

[125] Fix | Delete

('July', 'Jul', 7),

[126] Fix | Delete

('August', 'Aug', 8),

[127] Fix | Delete

('September', 'Sep', 9),

[128] Fix | Delete

('October', 'Oct', 10),

[129] Fix | Delete

('November', 'Nov', 11),

[130] Fix | Delete

('December', 'Dec', 12);

[131] Fix | Delete

[132] Fix | Delete

-- --------------------------------------------------------

[133] Fix | Delete

[134] Fix | Delete

[135] Fix | Delete

-- Table structure for table `users`

[136] Fix | Delete

[137] Fix | Delete

[138] Fix | Delete

CREATE TABLE `users` (

[139] Fix | Delete

`user_id` int(11) NOT NULL AUTO_INCREMENT,

[140] Fix | Delete

`domain_id` int(9) unsigned NOT NULL DEFAULT '0',

[141] Fix | Delete

`username` char(128) NOT NULL,

[142] Fix | Delete

`md5_pass` char(128) NOT NULL,

[143] Fix | Delete

`password_hint` varchar(255) NOT NULL DEFAULT '',

[144] Fix | Delete

`sso_facebook_uid` varchar(255) DEFAULT NULL,

[145] Fix | Delete

`sso_google_uid` varchar(255) DEFAULT NULL,

[146] Fix | Delete

`sso_live_uid` varchar(255) DEFAULT NULL,

[147] Fix | Delete

`sso_yahoo_uid` varchar(255) DEFAULT NULL,

[148] Fix | Delete

`lastname` varchar(50) NOT NULL DEFAULT '',

[149] Fix | Delete

`firstname` varchar(50) NOT NULL DEFAULT '',

[150] Fix | Delete

`email` varchar(100) NOT NULL DEFAULT '',

[151] Fix | Delete

`phone` varchar(50) NOT NULL DEFAULT '',

[152] Fix | Delete

`address1` varchar(100) NOT NULL DEFAULT '',

[153] Fix | Delete

`address2` varchar(100) NOT NULL DEFAULT '',

[154] Fix | Delete

`city` varchar(80) NOT NULL DEFAULT '',

[155] Fix | Delete

`state` varchar(20) NOT NULL DEFAULT '',

[156] Fix | Delete

`zip` varchar(20) NOT NULL DEFAULT '',

[157] Fix | Delete

`country` varchar(50) NOT NULL DEFAULT '',

[158] Fix | Delete

`master_code` char(128) NOT NULL,

[159] Fix | Delete

`confirmation_code` char(128) DEFAULT NULL,

[160] Fix | Delete

`pass_reset_code` char(128) DEFAULT NULL,

[161] Fix | Delete

`status` char(128) NOT NULL DEFAULT 'NEW' COMMENT 'New, Ready, Blocked',

[162] Fix | Delete

`trials` int(11) NOT NULL DEFAULT '0',

[163] Fix | Delete

`created` datetime DEFAULT NULL,

[164] Fix | Delete

`modified` datetime DEFAULT NULL,

[165] Fix | Delete

`deprecated` datetime DEFAULT NULL,

[166] Fix | Delete

PRIMARY KEY (`user_id`)

[167] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

[168] Fix | Delete

[169] Fix | Delete

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

[170] Fix | Delete

/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

[171] Fix | Delete

/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

[172] Fix | Delete

[173] Fix | Delete