matrix-create.sql 371 B

123456789101112131415161718
  1. CREATE TABLE matrix (
  2. first NUMBER(10),
  3. second NUMBER(5),
  4. res NUMBER(10)
  5. );
  6. CREATE OR REPLACE TRIGGER matrix_tr
  7. before insert on matrix FOR EACH ROW
  8. BEGIN
  9. auto_id(:NEW.id);
  10. END matrix_tr;
  11. /
  12. BEGIN map2users('matrix'); END;
  13. /
  14. CREATE INDEX matrix_matrix_idx ON matrix (first, second);
  15. INSERT INTO version (table_name, table_version) values ('matrix','1');