aoberegg / ep_user_pad

User-Management System for etherpad-lite
Apache License 2.0
5 stars 8 forks source link

add sql file to initialize de db #2

Open sockenklaus opened 10 years ago

sockenklaus commented 10 years ago

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`) );

Crosspost from: aoberegg/ep_user_pad_frontend#2

aoberegg commented 10 years ago

Ok I'll add it during the course of next week

Bumblebee-Man commented 9 years ago

This is a really great project. Having the SQL file would make it a lot easier. Matter of fact, getting the info out of PDF and into a normal file would help too.