Source of “create.txt”.
125 lines, 3.2 KBytes.   Last modified 9:36 pm, 22nd March 2014 PDT.
1 create table accts/USER/ ( 2 acctid int not null auto_increment, 3 acctname text, 4 user text, 5 pwd text, 6 pwdiv int, 7 server text, 8 type enum('POP3', 'IMAP', 'SIMAP', 'Pachylet', 'SPOP', 'SEND'), 9 dodelete enum('Y', 'N'), 10 msgfrom text, 11 person text, 12 displaytz int, 13 udate int not null, 14 cachedquery text, 15 unique key (acctid) ); 16 insert into accts/USER/ values ( 17 NULL, 18 '/USER/', 19 '/USER/', 20 NULL, 21 0, 22 'localhost', 23 'POP3', 24 'Y', 25 '/USER/@localhost', 26 '/USER/', 27 0, 28 0, 29 NULL ); 30 create table msgs/USER/ ( 31 id int not null auto_increment, 32 acctid int not null default 0, 33 md5 varchar(16), 34 msgid text, 35 udate int, 36 subject text, 37 msgfrom text, 38 msgto text, 39 msgcc text, 40 unread enum('Y', 'N') not null, 41 primary key (id), 42 unique key (md5) ); 43 create table parts/USER/ ( 44 id int not null, 45 part int not null auto_increment, 46 filekey binary(32), 47 mac binary(32), 48 imapnum text, 49 type text, 50 subtype text, 51 encoding text, 52 description text, 53 contentid text, 54 disposition text, 55 dparameters text, 56 parameters text, 57 children int, 58 length int, 59 content text, 60 primary key (id, part), 61 unique key (part) ); 62 create table labels/USER/ ( 63 id int not null, 64 label varchar(40) not null, 65 adding enum('Y', 'N') not null, 66 seq int not null, 67 udate int not null, 68 primary key (label, id), 69 index (id) ); 70 create table queries/USER/ ( 71 qid int not null auto_increment, 72 scan int not null default '999999', 73 name varchar(40) not null, 74 filter enum('Y', 'N') not null default 'Y', 75 f varchar(40) not null, 76 t text, 77 findin char(1) not null default 'A', 78 unread enum('Y', 'N'), 79 datefrom char(1) not null default 'B', 80 dateto char(1) not null default 'E', 81 acctid int not null default 0, 82 deleted enum('Y', 'N') not null default 'N', 83 udate int not null, 84 primary key(qid), 85 key(scan) ); 86 create table contacts/USER/ ( 87 id int not null auto_increment, 88 first text, 89 last text, 90 nickname text, 91 email text, 92 address text, 93 home text, 94 work text, 95 mobile text, 96 deleted enum('Y', 'N') not null default 'N', 97 udate int, 98 primary key(id) ); 99 create table hits/USER/ ( 100 id int not null, 101 udate int not null, 102 primary key (udate, id) ); 103 create table fthits/USER/ ( 104 id int not null, 105 primary key (id) ) engine = memory; 106 alter table labels/USER/ auto_increment = 2; 107 grant usage on *.* to /USER/ identified by '/PASSWORD/'; 108 grant lock tables on pachylet.* to /USER/; 109 grant select, insert, update, delete on pachylet.accts/USER/ 110 to /USER/; 111 grant select, insert, update, delete on pachylet.msgs/USER/ 112 to /USER/; 113 grant select, insert, update, delete on pachylet.parts/USER/ 114 to /USER/; 115 grant select on pachylet.parts/USER/ to sphinx; 116 grant select, insert, update, delete on pachylet.labels/USER/ 117 to /USER/; 118 grant select, insert, update, delete on pachylet.queries/USER/ 119 to /USER/; 120 grant select, insert, update, delete on pachylet.contacts/USER/ 121 to /USER/; 122 grant select, insert, update, delete on pachylet.hits/USER/ 123 to /USER/; 124 grant select, insert, update, delete on pachylet.fthits/USER/ 125 to /USER/
End of listing