Changeset View
Changeset View
Standalone View
Standalone View
resources/sql/patches/006.repository.sql
| create table {$NAMESPACE}_repository.repository_commitdata ( | create table {$NAMESPACE}_repository.repository_commitdata ( | ||||
| id int unsigned not null auto_increment primary key, | id int unsigned not null auto_increment primary key, | ||||
| commitID int unsigned not null, | commitID int unsigned not null, | ||||
| authorName varchar(255) not null, | authorName varchar(255) not null, | ||||
| commitMessage longblob not null, | commitMessage longblob not null, | ||||
| unique key (commitID), | unique key (commitID), | ||||
| key (authorName) | key (authorName(128)) | ||||
| ); | ); | ||||
| ALTER TABLE {$NAMESPACE}_worker.worker_task drop priority; | ALTER TABLE {$NAMESPACE}_worker.worker_task drop priority; | ||||
| ALTER TABLE {$NAMESPACE}_worker.worker_task drop key leaseOwner; | ALTER TABLE {$NAMESPACE}_worker.worker_task drop key leaseOwner; | ||||
| ALTER TABLE {$NAMESPACE}_worker.worker_task add key (leaseOwner(16)); | ALTER TABLE {$NAMESPACE}_worker.worker_task add key (leaseOwner(16)); | ||||
| create table {$NAMESPACE}_repository.repository_path ( | create table {$NAMESPACE}_repository.repository_path ( | ||||
| id int unsigned not null auto_increment primary key, | id int unsigned not null auto_increment primary key, | ||||
| ▲ Show 20 Lines • Show All 41 Lines • Show Last 20 Lines | |||||