← Back to branch summary

~ubuntu-branches/debian/squeeze/sympa/squeeze

« back to all changes in this revision

Viewing changes to src/etc/script/create_db.mysql

  • Committer: Bazaar Package Importer
  • Author(s): Christian Perrier
  • Date: 2007-01-20 18:09:28 UTC
  • mfrom: (1.1.2 upstream)
  • Revision ID: james.westby@ubuntu.com-20070120180928-0e42mbwg87mlo44y
Tags: 5.2.3-1.2
* Non-maintainer upload to re-fix l10n issues
* As debconf-updatepo was not run in previous versions, the French
  translation was outdated. Hence fix it.
* Remove several duplicate spaces in the debconf templates

Show diffs side-by-side

added added

removed removed

Lines of Context:
src/etc/script/create_db.mysql
18
18
CREATE TABLE subscriber_table (
19
19
        list_subscriber         varchar (50) NOT NULL,
20
20
        user_subscriber         varchar (100) NOT NULL,
 
21
        robot_subscriber        varchar (80) NOT NULL,
21
22
        date_subscriber         datetime NOT NULL,
22
23
        update_subscriber       datetime,
23
24
        visibility_subscriber   varchar (20),
24
25
        reception_subscriber    varchar (20),
 
26
        topics_subscriber       varchar (200),
25
27
        bounce_subscriber       varchar (35),
 
28
        bounce_score_subscriber smallint (6),
 
29
        bounce_address_subscriber       varchar (100),
26
30
        comment_subscriber      varchar (150),
27
 
        subscribed_subscriber   enum ('0','1'),
28
 
        included_subscriber     enum ('0','1'),
 
31
        subscribed_subscriber   int(1),
 
32
        included_subscriber     int(1),
29
33
        include_sources_subscriber varchar(50),
30
 
        bounce_score_subscriber smallint (6),
31
 
        PRIMARY KEY (list_subscriber, user_subscriber),
32
 
        INDEX (user_subscriber,list_subscriber)
 
34
        PRIMARY KEY (list_subscriber, user_subscriber, robot_subscriber),
 
35
        INDEX (user_subscriber,list_subscriber,robot_subscriber)
 
36
);
 
37
 
 
38
CREATE TABLE admin_table (
 
39
        list_admin              varchar(50) NOT NULL,
 
40
        user_admin              varchar(100) NOT NULL,
 
41
        robot_admin             varchar(80) NOT NULL,
 
42
        role_admin              enum('listmaster','owner','editor') NOT NULL,
 
43
        date_admin              datetime NOT NULL,
 
44
        update_admin            datetime,
 
45
        reception_admin         varchar(20),
 
46
        comment_admin           varchar(150),
 
47
        subscribed_admin        int(1),
 
48
        included_admin          int(1),
 
49
        include_sources_admin   varchar(50),
 
50
        info_admin              varchar(150),
 
51
        profile_admin           enum('privileged','normal'),
 
52
        PRIMARY KEY (list_admin, user_admin, robot_admin, role_admin),
 
53
        INDEX (list_admin, user_admin,robot_admin,role_admin)
 
54
);
 
55
 
 
56
CREATE TABLE netidmap_table (
 
57
        netid_netidmap              varchar (100) NOT NULL,
 
58
        serviceid_netidmap          varchar (100) NOT NULL,
 
59
        robot_netidmap              varchar (80) NOT NULL,
 
60
        email_netidmap              varchar (100),
 
61
        PRIMARY KEY (netid_netidmap, serviceid_netidmap, robot_netidmap)
33
62
);
34
63
 
35
64
# CREATE TABLE log_table (