-
Notifications
You must be signed in to change notification settings - Fork 28
Expand file tree
/
Copy pathinsert_default_admin.sql
More file actions
109 lines (104 loc) · 5.24 KB
/
Copy pathinsert_default_admin.sql
File metadata and controls
109 lines (104 loc) · 5.24 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
DROP TABLE IF EXISTS `Member`;
CREATE TABLE `Member` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`ClassName` enum('Member') CHARACTER SET utf8 DEFAULT 'Member',
`Created` datetime DEFAULT NULL,
`LastEdited` datetime DEFAULT NULL,
`FirstName` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
`Surname` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
`Email` varchar(254) CHARACTER SET utf8 DEFAULT NULL,
`Password` varchar(160) CHARACTER SET utf8 DEFAULT NULL,
`RememberLoginToken` varchar(160) CHARACTER SET utf8 DEFAULT NULL,
`NumVisit` int(11) NOT NULL DEFAULT '0',
`LastVisited` datetime DEFAULT NULL,
`Bounced` tinyint(1) unsigned NOT NULL DEFAULT '0',
`AutoLoginHash` varchar(160) CHARACTER SET utf8 DEFAULT NULL,
`AutoLoginExpired` datetime DEFAULT NULL,
`PasswordEncryption` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
`Salt` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
`PasswordExpiry` date DEFAULT NULL,
`LockedOutUntil` datetime DEFAULT NULL,
`Locale` varchar(6) CHARACTER SET utf8 DEFAULT NULL,
`FailedLoginCount` int(11) NOT NULL DEFAULT '0',
`DateFormat` varchar(30) CHARACTER SET utf8 DEFAULT NULL,
`TimeFormat` varchar(30) CHARACTER SET utf8 DEFAULT NULL,
`Address` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
`Suburb` varchar(64) CHARACTER SET utf8 DEFAULT NULL,
`State` varchar(64) CHARACTER SET utf8 DEFAULT NULL,
`Postcode` varchar(64) CHARACTER SET utf8 DEFAULT NULL,
`Country` varchar(2) CHARACTER SET utf8 DEFAULT NULL,
`SecondEmail` varchar(254) CHARACTER SET utf8 DEFAULT NULL,
`ThirdEmail` varchar(254) CHARACTER SET utf8 DEFAULT NULL,
`HasBeenEmailed` tinyint(1) unsigned NOT NULL DEFAULT '0',
`ShirtSize` enum('Extra Small','Small','Medium','Large','XL','XXL') CHARACTER SET utf8 DEFAULT 'Extra Small',
`CompanyAffliations` mediumtext CHARACTER SET utf8,
`StatementOfInterest` mediumtext CHARACTER SET utf8,
`FoodPreference` mediumtext CHARACTER SET utf8,
`OtherFood` mediumtext CHARACTER SET utf8,
`IRCHandle` mediumtext CHARACTER SET utf8,
`TwitterName` mediumtext CHARACTER SET utf8,
`Projects` mediumtext CHARACTER SET utf8,
`OtherProject` mediumtext CHARACTER SET utf8,
`SubscribedToNewsletter` tinyint(1) unsigned NOT NULL DEFAULT '0',
`City` varchar(64) CHARACTER SET utf8 DEFAULT NULL,
`Bio` mediumtext CHARACTER SET utf8,
`PhotoID` int(11) DEFAULT '0',
`OrgID` int(11) DEFAULT '0',
`CompanyID` int(11) NOT NULL DEFAULT '0',
`SortOrder` int(11) NOT NULL DEFAULT '0',
`JobTitle` mediumtext CHARACTER SET utf8,
`DisplayOnSite` tinyint(1) unsigned NOT NULL DEFAULT '0',
`Role` mediumtext CHARACTER SET utf8,
`LinkedInProfile` mediumtext CHARACTER SET utf8,
`Gender` varchar(32) CHARACTER SET utf8 DEFAULT NULL,
`TypeOfDirector` mediumtext CHARACTER SET utf8,
`PresentationList` mediumtext CHARACTER SET utf8,
`ActiveSummitID` int(11) NOT NULL DEFAULT '0',
`IdentityURL` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
`TempIDHash` varchar(160) CHARACTER SET utf8 DEFAULT NULL,
`TempIDExpired` datetime DEFAULT NULL,
`ShowDupesOnProfile` tinyint(1) unsigned NOT NULL DEFAULT '0',
`AuthenticationToken` varchar(128) CHARACTER SET utf8 DEFAULT NULL,
`AuthenticationTokenExpire` int(11) NOT NULL DEFAULT '0',
`Active` tinyint(1) unsigned NOT NULL DEFAULT '0',
`EmailVerified` tinyint(1) unsigned NOT NULL DEFAULT '0',
`EmailVerifiedTokenHash` mediumtext CHARACTER SET utf8,
`EmailVerifiedDate` datetime DEFAULT NULL,
`VotingListID` int(11) DEFAULT '0',
`LegacyMember` tinyint(1) unsigned NOT NULL DEFAULT '0',
`AskOpenStackUsername` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
`ResignDate` datetime DEFAULT NULL,
`ProfileLastUpdate` datetime DEFAULT NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `email_unique_idx` (`Email`),
KEY `Email` (`Email`),
KEY `ClassName` (`ClassName`),
KEY `Member_CompanyAffliations` (`CompanyAffliations`(32)),
KEY `PhotoID` (`PhotoID`),
KEY `OrgID` (`OrgID`),
KEY `CompanyID` (`CompanyID`),
KEY `ActiveSummitID` (`ActiveSummitID`),
KEY `AuthenticationToken` (`AuthenticationToken`),
KEY `VotingListID` (`VotingListID`),
KEY `SecondEmail` (`SecondEmail`) USING BTREE,
KEY `ThirdEmail` (`ThirdEmail`) USING BTREE,
KEY `FirstName` (`FirstName`) USING BTREE,
KEY `Surname` (`Surname`) USING BTREE,
KEY `FirstName_Surname` (`FirstName`,`Surname`) USING BTREE,
FULLTEXT KEY `SearchFields` (`FirstName`,`Surname`)
) ENGINE=InnoDB AUTO_INCREMENT=80922 DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `Group_Members`;
CREATE TABLE `Group_Members` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`GroupID` int(11) NOT NULL DEFAULT '0',
`MemberID` int(11) NOT NULL DEFAULT '0',
`SortIndex` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`),
KEY `GroupID` (`GroupID`),
KEY `MemberID` (`MemberID`)
) ENGINE=InnoDB AUTO_INCREMENT=220023 DEFAULT CHARSET=latin1;
INSERT INTO Member
(`ID`,`ClassName`,`Created`,`LastEdited`,`FirstName`,`Surname`,`Email`,`Password`,`PasswordEncryption`,`Active`,`EmailVerified`,`EmailVerifiedDate`)
VALUES (1,'Member',NOW(),NOW(),'admin','admin','admin@admin.com','1qaz2wsx','none',1,1,NOW());
INSERT INTO `Group_Members` (`ID`,`GroupID`,`MemberID`,`SortIndex`) VALUES (1,2,1,0);
UPDATE `File` SET CloudStatus='Live';