私的kabojako Home | kabojako Home | kabojako BBS

kabojako 激しく試用版

kabojakoのとりあえず版のインターフェースです。あまりに乱暴な作りですが気にすんな。

DB作成日: 2025.04.25
Server: tokimiya.minibird.jp

お試し用サンプル：
SELECT c.name,c.cno,i.name,attack,ability1,ability2,ability3
FROM item i JOIN community c ON i.owner_cno = c.cno
WHERE i.type LIKE '斧%' AND i.price > 0 AND current_floor = 4

テーブル定義：

CREATE TABLE selfdate(
  selfdate TEXT
);

CREATE TABLE item(
  name TEXT,
  type TEXT,
  ability1 TEXT,
  ability2 TEXT,
  ability3 TEXT,
  initial_cost INT,
  burst   INT,
  attack  INT,
  hit     INT,
  defence INT,
  avoid   INT,
  regist  INT,
  magic   INT,
  description TEXT,
  durability         INT,
  durability_max     INT,
  durability_basemax INT,
  owner_eno INT,
  owner_cno INT,
  user_cno INT,
  price INT,
  count INT,
  having_slot INT,
  is_fusioned INT
);
CREATE INDEX item_owner_eno ON item (owner_eno);
CREATE INDEX item_owner_cno ON item (owner_cno);

CREATE TABLE plan(
  name TEXT,
  type TEXT,
  ability1 TEXT,
  ability2 TEXT,
  ability3 TEXT,
  initial_cost INT,
  burst   INT,
  attack  INT,
  hit     INT,
  defence INT,
  avoid   INT,
  regist  INT,
  magic   INT,
  description TEXT,
  durability_basemax INT,
  owner_eno INT,
  owner_cno INT,
  price INT,
  count INT,
  plan_no INT
);
CREATE INDEX plan_owner_eno ON plan (owner_eno);
CREATE INDEX plan_owner_cno ON plan (owner_cno);


CREATE TABLE community(
  cno INT PRIMARY KEY,
  name TEXT,
  type TEXT,
  CM_message    TEXT,
  capable_floor INT,
  count_member  INT,
  count_sell_items INT,
  current_floor INT,
  days_since_found INT,
  deepest_floor INT,
  en INT,
  fame INT,
  fee INT
);

CREATE TABLE plant(
  cno        INT,
  slot       INT,
  name       TEXT,
  type       TEXT,
  durability INT,
  def        INT,
  init_cost  INT,
  cost       INT,
  description TEXT,
  is_work    BOOL,
  PRIMARY KEY(cno,slot)
);

CREATE TABLE charinfo(
  eno      INT PRIMARY KEY,
  name     TEXT,
  nick     TEXT,
  class    TEXT,
  cno      INT,
  pos_in_com  INT,
  unit_in_com INT,
  exp      INT,
  en       INT,
  level    INT,
  lifedays INT,
  hp       INT,
  hpmax    INT,
  mp       INT,
  mpmax    INT,
  str      INT,
  agi      INT,
  dex      INT,
  pow      INT,
  vit      INT,
  sen      INT,
  adventure INT,
  defence   INT,
  develop   INT,
  diplomacy INT,
  fusion    INT,
  manage    INT,
  mechanic  INT,
  repair    INT,
  unlock    INT,
  work      INT
);
CREATE INDEX charinfo_cno ON charinfo (cno);