Fork de wikipp, le moteur de wiki en c++, basé sur cppcms. Le fork ajoute la langue française
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

mysql.sql 1.1KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748
  1. drop table if exists history;
  2. drop table if exists pages;
  3. drop table if exists connections;
  4. drop table if exists users;
  5. drop table if exists options;
  6. create table options (
  7. lang varchar(16) not null,
  8. name varchar(32) not null,
  9. value text not null,
  10. constraint unique(lang,name)
  11. ) Engine = InnoDB;
  12. create table users (
  13. id integer auto_increment primary key not null,
  14. username varchar(32) unique not null,
  15. password varchar(32) not null
  16. ) Engine = InnoDB;
  17. create table pages (
  18. id integer auto_increment primary key not null,
  19. lang varchar(16) not null,
  20. slug varchar(128) not null,
  21. title varchar(256) not null,
  22. content text null,
  23. sidebar text not null,
  24. users_only integer not null,
  25. constraint unique (lang,slug),
  26. pad_url varchar(256) null
  27. ) Engine = InnoDB;
  28. create table history (
  29. id integer not null,
  30. version integer not null,
  31. created datetime not null,
  32. author varchar(32) not null,
  33. title varchar(256) not null,
  34. content text null,
  35. sidebar text not null,
  36. constraint unique(id,version),
  37. pad_url varchar(256) null,
  38. foreign key(id) references pages(id),
  39. primary key(id,version)
  40. ) Engine = InnoDB;
  41. create index history_timeline on history(created);