Skip to content

Instantly share code, notes, and snippets.

View BenMatheja's full-sized avatar
🎯
Focusing

Ben Matheja BenMatheja

🎯
Focusing
  • Dr. ing. h.c. F. Porsche AG
  • Stuttgart
View GitHub Profile
@BenMatheja
BenMatheja / gist:9230138
Last active May 24, 2023 05:00
mopidy port 80 proxy pass with nginx on raspberry pi
sudo apt-get update
sudo apt-get install nginx
sudo service nginx start
sudo vi /etc/nginx/sites-enabled/default
##### VI output, oder nano jenachdem mit was du die ändern willst ###
server {
#listen 80; ## listen for ipv4; this line is default and implied
#listen [::]:80 default_server ipv6only=on; ## listen for ipv6
CREATE TABLE Infinity.activity_instance (oid BIGINT AUTO_INCREMENT PRIMARY KEY, state INT, startTime BIGINT, lastModificationTime BIGINT, model BIGINT, activity BIGINT, currentPerformer BIGINT, currentUserPerformer BIGINT, performedBy BIGINT, currentDepartment BIGINT, processInstance BIGINT) TYPE=InnoDB;
CREATE UNIQUE INDEX activity_inst_idx1 ON Infinity.activity_instance(oid);
CREATE INDEX activity_inst_idx2 ON Infinity.activity_instance(currentPerformer, currentDepartment);
CREATE INDEX activity_inst_idx3 ON Infinity.activity_instance(currentUserPerformer, currentPerformer, currentDepartment);
CREATE INDEX activity_inst_idx4 ON Infinity.activity_instance(performedBy);
CREATE INDEX activity_inst_idx5 ON Infinity.activity_instance(processInstance);
CREATE INDEX activity_inst_idx6 ON Infinity.activity_instance(startTime, activity, state);
CREATE INDEX activity_inst_idx7 ON Infinity.activity_instance(state);
CREATE INDEX activity_inst_idx8 ON Infinity.activity_instance(activity, processInstance);
@echo off
rem Carnot application launch script
rem (C) 2000-2011 SunGard CSA LLC
rem
rem You can affect the behaviour of this script with the following environment variables
rem described in the CARNOT documentation:
rem
rem CARNOT_HOME: The location of the carnot distribution
rem CARNOT_WORK: The location of your private settings
rem CARNOT_CLASSPATH: A fixed classpath to use if you want to prevent automatic classpath assembly
@BenMatheja
BenMatheja / gist:6149886
Created August 4, 2013 09:44
HSQL - Logfile for bodega - Inserts working
/*C2*/SET SCHEMA PUBLIC
DISCONNECT
/*C3*/SET SCHEMA PUBLIC
create table Edge (ID bigint generated by default as identity (start with 1), CAPTION varchar(255) not null, end_ID bigint, start_ID bigint, primary key (ID))
create table Language (ID bigint generated by default as identity (start with 1), DESC varchar(255) not null, TITLE varchar(255) not null, primary key (ID))
create table Language_MODEL (Language_ID bigint not null, models_ID bigint not null, primary key (Language_ID, models_ID), unique (models_ID))
create table MODEL (ID bigint generated by default as identity (start with 1), TITLE varchar(255), language_ID bigint, primary key (ID))
create table MODEL_Edge (Model_ID bigint not null, edges_ID bigint not null, primary key (Model_ID, edges_ID), unique (edges_ID))
create table Project (ID bigint generated by default as identity (start with 1), primary key (ID))
create table Vertex (ID bigint generated by default as identity (start with 1), caption varchar(255) not null, primary key (ID))