Changeset 3413 for pykota/trunk/initscripts/postgresql/upgrade-to-1.19.sql
- Timestamp:
- 09/27/08 22:02:37 (16 years ago)
- Files:
-
- 1 modified
Legend:
- Unmodified
- Added
- Removed
-
pykota/trunk/initscripts/postgresql/upgrade-to-1.19.sql
r3259 r3413 7 7 -- the Free Software Foundation, either version 3 of the License, or 8 8 -- (at your option) any later version. 9 -- 9 -- 10 10 -- This program is distributed in the hope that it will be useful, 11 11 -- but WITHOUT ANY WARRANTY; without even the implied warranty of 12 12 -- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 13 13 -- GNU General Public License for more details. 14 -- 14 -- 15 15 -- You should have received a copy of the GNU General Public License 16 16 -- along with this program. If not, see <http://www.gnu.org/licenses/>. … … 22 22 -- This script has to be used if you already 23 23 -- have a pre-1.19 version of PyKota to upgrade 24 -- your database schema. 24 -- your database schema. 25 25 -- 26 26 -- YOU DON'T NEED TO USE IT IF YOU'VE JUST INSTALLED PYKOTA 27 27 -- 28 29 -- 28 29 -- 30 30 -- WARNING : YOU NEED A RECENT VERSION OF POSTGRESQL FOR THE ALTER COLUMN STATEMENT TO WORK ! 31 31 -- 32 32 33 -- 33 -- 34 34 -- Modify the old database schema 35 35 -- … … 45 45 CREATE INDEX payments_date_ix ON payments (date); 46 46 47 REVOKE ALL ON payments FROM public; 47 REVOKE ALL ON payments FROM public; 48 48 REVOKE ALL ON payments_id_seq FROM public; 49 49 GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES ON payments TO pykotaadmin;