Changeset 3413 for pykota/trunk/initscripts/postgresql/upgrade-to-1.21.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.21.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.21 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 -- … … 51 51 CREATE INDEX jobhistory_u_id_ix ON jobhistory (userid); 52 52 53 -- 53 -- 54 54 -- Create the table for coefficients wrt paper sizes and the like 55 55 -- 56 CREATE TABLE coefficients (id SERIAL PRIMARY KEY NOT NULL, 57 printerid INTEGER NOT NULL REFERENCES printers(id), 58 label TEXT NOT NULL, 59 coefficient FLOAT DEFAULT 1.0, 56 CREATE TABLE coefficients (id SERIAL PRIMARY KEY NOT NULL, 57 printerid INTEGER NOT NULL REFERENCES printers(id), 58 label TEXT NOT NULL, 59 coefficient FLOAT DEFAULT 1.0, 60 60 CONSTRAINT coeffconstraint UNIQUE (printerid, label)); 61 62 REVOKE ALL ON coefficients FROM public; 61 62 REVOKE ALL ON coefficients FROM public; 63 63 REVOKE ALL ON coefficients_id_seq FROM public; 64 64 GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES ON coefficients TO pykotaadmin;