Changeset 3413 for pykota/trunk/initscripts/postgresql/upgrade-to-1.23.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.23.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.23alpha30 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 -- Modify the old database schema 31 31 -- … … 49 49 UPDATE printers SET passthrough=FALSE; 50 50 51 -- 51 -- 52 52 -- Create the table for the billing codes 53 53 -- … … 59 59 ALTER TABLE billingcodes RENAME COLUMN label TO billingcode; 60 60 61 REVOKE ALL ON billingcodes FROM public; 61 REVOKE ALL ON billingcodes FROM public; 62 62 REVOKE ALL ON billingcodes_id_seq FROM public; 63 63 GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES ON billingcodes TO pykotaadmin;