add sql file to initialize de db

[nicopace]

in the install documentation there is some sql code to initialize de project. Perhaps it is easier if you add it as an sql file:

create table if not exists `GroupPads` ( `groupID` int(11) not null, `PadName` varchar(255) collate utf8_bin not null, primary key (`GroupID`,`PadName`) );
create table if not exists `Groups` ( `groupID` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', PRIMARY KEY (`groupID`, `name`) );
create table if not exists `NotRegisteredUsersGroups` ( `email` varchar(255) not null, `groupID` int(11) not null);
create table if not exists `User` ( `userID` int(11) not null auto_increment, `name` varchar(255) collate utf8_bin not null default '', `pwd` varchar(255) collate utf8_bin default null, `considered` tinyint(11) default null, `sso` tinyint(4) default null, `FullName` varchar(255) collate utf8_bin default null, `considerationString` varchar(50) collate utf8_bin default null, `salt` varchar(255) collate utf8_bin default null, `active` int(1) default null, primary key (`userID`,`name`) );
create table if not exists `UserGroup` ( `userID` int(11) not null default '0', `groupID` int(11) not null default '0', `Role` int(11) default null, primary key (`userID`, `groupID`) );

[SkoricIT]

Sounds good.

[sockenklaus]

Doesn't this request should be posted in the core repository (aoberegg/ep_user_pad) instead of the frontend-rep, since this is a database-thing and not frontend-specific?

[nicopace]

I really don't know how to associate an issue with a repository, sorry for that!

[SkoricIT]

@nicopace go to https://github.com/aoberegg/ep_user_pad instead of https://github.com/aoberegg/ep_user_pad_frontend and open the issue there. :-)

[sockenklaus]

Done. :)

[nicopace]

mmm... doh' ... thanks!

[SkoricIT]

Nice.