X-Git-Url: http://git.cyclocoop.org/?a=blobdiff_plain;f=schema.sql;h=f03e176fb83fb771abd9267e4e12f5e940362900;hb=b0b79d217bb08211defdaacb87946253e124310d;hp=c1805c4002b6bc76812ca81c979e2196c0d5d5c6;hpb=a2d3a797375c6e14889d89b975ee32e3068926b6;p=cavote.git diff --git a/schema.sql b/schema.sql index c1805c4..f03e176 100644 --- a/schema.sql +++ b/schema.sql @@ -1,6 +1,7 @@ drop table if exists choices; drop table if exists attachments; drop table if exists votes; +drop table if exists user_role; drop table if exists roles; drop table if exists users; @@ -62,7 +63,7 @@ create table choices ( -- Test data -insert into users (email, password, name, organization, is_admin, key) values ("admin@admin.fr", "admin", "Toto (admin) Tata", "World corp", 1, "test"); +insert into users (email, password, name, organization, is_admin, key) values ("admin@admin.fr", "d033e22ae348aeb5660fc2140aec35850c4da997", "Toto (admin) Tata", "World corp", 1, "test"); -- mdp = admin insert into roles (id, name, system) values (1, "Tous", 1); insert into roles (name) values ("CA"); insert into roles (name) values ("Members");