Revision 3733,
435 bytes
checked in by gabriel.malheiros, 14 years ago
(diff) |
Ticket #1541 - <Davical customizado para o Expresso.Utiliza Caldav e CardDav?>
|
Line | |
---|
1 | |
---|
2 | -- Adding freebusy tickets |
---|
3 | |
---|
4 | BEGIN; |
---|
5 | SELECT check_db_revision(1,1,7); |
---|
6 | |
---|
7 | CREATE TABLE freebusy_ticket ( |
---|
8 | ticket_id TEXT NOT NULL PRIMARY KEY, |
---|
9 | user_no integer NOT NULL REFERENCES usr(user_no) ON UPDATE CASCADE ON DELETE CASCADE, |
---|
10 | created timestamp with time zone DEFAULT current_timestamp NOT NULL |
---|
11 | ); |
---|
12 | |
---|
13 | GRANT INSERT,SELECT,UPDATE,DELETE ON TABLE freebusy_ticket TO general; |
---|
14 | |
---|
15 | SELECT new_db_revision(1,1,8, 'August' ); |
---|
16 | COMMIT; |
---|
17 | ROLLBACK; |
---|
18 | |
---|
Note: See
TracBrowser
for help on using the repository browser.