Revision 3733,
435 bytes
checked in by gabriel.malheiros, 14 years ago
(diff) |
Ticket #1541 - <Davical customizado para o Expresso.Utiliza Caldav e CardDav?>
|
Rev | Line | |
---|
[3733] | 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.