Page MenuHomePhabricator

Create channelmgnt.db and tables
Closed, ResolvedPublic1 Estimated Story Points

Description

A new database storing the chanop tables is needed with the following schema

SQL to run:

CREATE TABLE chanops ( id INTEGER PRIMARY key autoincrement, nick VARCHAR(20), chan VARCHAR(20) );

Database:

/data/project/instance/.sopel/channelmgnt.db

Instance:

  • zppixbot
  • zppixbot-test

Details

Due Date
Jun 4 2020, 1:00 PM

Event Timeline

RhinosF1 triaged this task as Medium priority.Jun 1 2020, 4:42 PM
RhinosF1 moved this task from Radar to Deployment on the User-RhinosF1 board.
RhinosF1 moved this task from To Triage / Backlog to 2020 June - September on the ZppixBot board.
RhinosF1 renamed this task from Create Chanops Database file to Create channelmgnt.db and tables.Jun 1 2020, 4:50 PM
RhinosF1 updated the task description. (Show Details)
RhinosF1 set the point value for this task to 1.
RhinosF1 set Due Date to Jun 4 2020, 1:00 PM.
RhinosF1 updated the task description. (Show Details)

Mentioned in SAL (#wikimedia-cloud) [2020-06-01T21:13:37Z] <RhinosF1> .sopel/welcome.db>CREATE TABLE chanops ( id INTEGER PRIMARY key autoincrement, nick VARCHAR(20), chan VARCHAR(20) ); for T254166

Mentioned in SAL (#wikimedia-cloud) [2020-06-01T21:15:18Z] <RhinosF1> .sopel/welcome.db>CREATE TABLE chanops ( id INTEGER PRIMARY key autoincrement, nick VARCHAR(20), chan VARCHAR(20) ); for T254166

RhinosF1 set Final Story Points to 1.