Diffusion c4science (master) Browse

c4science/roles/mariadb/files/install_shib.sql
c4018e23e18fmaster

install_shib.sql
View Options

			CREATE TABLE version (
			major int NOT NULL,
			minor int NOT NULL
			);

			CREATE TABLE strings (
			context varchar(255) not null,
			id varchar(255) not null,
			expires datetime not null,
			version smallint not null,
			value varchar(255) not null,
			PRIMARY KEY (context, id)
			);

			CREATE TABLE texts (
			context varchar(255) not null,
			id varchar(255) not null,
			expires datetime not null,
			version smallint not null,
			value text not null,
			PRIMARY KEY (context, id)
			);

			insert into version values (1,0);