API tools faq
paste
LeonMMS

VXA-OS PostgreSQL DB

LeonMMS
May 5th, 2025
94
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PostgreSQL 5.65 KB | None | 0 0
raw download clone embed print report
  1. BEGIN;
  2.  
  3. CREATE TABLE IF NOT EXISTS account_friends (
  4.     id SERIAL PRIMARY KEY,
  5.     account_id INTEGER NOT NULL,
  6.     name TEXT NOT NULL
  7. );
  8.  
  9. CREATE TABLE IF NOT EXISTS accounts (
  10.     id SERIAL PRIMARY KEY,
  11.     username TEXT NOT NULL,
  12.     password TEXT NOT NULL,
  13.     email TEXT NOT NULL,
  14.     "group" INTEGER NOT NULL DEFAULT 0,
  15.     creation_date INTEGER NOT NULL,
  16.     vip_time INTEGER NOT NULL,
  17.     cash TEXT NOT NULL
  18. );
  19.  
  20. CREATE TABLE IF NOT EXISTS actor_armors (
  21.     id SERIAL PRIMARY KEY,
  22.     actor_id INTEGER NOT NULL,
  23.     armor_id INTEGER NOT NULL,
  24.     amount INTEGER NOT NULL
  25. );
  26.  
  27. CREATE TABLE IF NOT EXISTS actor_equips (
  28.     id SERIAL PRIMARY KEY,
  29.     actor_id INTEGER NOT NULL,
  30.     slot_id INTEGER NOT NULL,
  31.     equip_id INTEGER NOT NULL
  32. );
  33.  
  34. CREATE TABLE IF NOT EXISTS actor_hotbars (
  35.     id SERIAL PRIMARY KEY,
  36.     actor_id INTEGER NOT NULL,
  37.     slot_id INTEGER NOT NULL,
  38.     type INTEGER NOT NULL DEFAULT 0,
  39.     item_id INTEGER NOT NULL DEFAULT 0
  40. );
  41.  
  42. CREATE TABLE IF NOT EXISTS actor_items (
  43.     id SERIAL PRIMARY KEY,
  44.     actor_id INTEGER NOT NULL,
  45.     item_id INTEGER NOT NULL,
  46.     amount INTEGER NOT NULL
  47. );
  48.  
  49. CREATE TABLE IF NOT EXISTS actor_quests (
  50.     id SERIAL PRIMARY KEY,
  51.     actor_id INTEGER NOT NULL,
  52.     quest_id INTEGER NOT NULL,
  53.     state INTEGER NOT NULL,
  54.     kills INTEGER NOT NULL
  55. );
  56.  
  57. CREATE TABLE IF NOT EXISTS actor_self_switches (
  58.     id SERIAL PRIMARY KEY,
  59.     actor_id INTEGER NOT NULL,
  60.     map_id INTEGER NOT NULL,
  61.     event_id INTEGER NOT NULL,
  62.     ch TEXT NOT NULL,
  63.     value INTEGER NOT NULL
  64. );
  65.  
  66. CREATE TABLE IF NOT EXISTS actor_skills (
  67.     id SERIAL PRIMARY KEY,
  68.     actor_id INTEGER NOT NULL,
  69.     skill_id INTEGER NOT NULL
  70. );
  71.  
  72. CREATE TABLE IF NOT EXISTS actor_states (
  73.     id SERIAL PRIMARY KEY,
  74.     actor_id INTEGER NOT NULL,
  75.     state_id INTEGER NOT NULL,
  76.     state_time REAL NOT NULL
  77. );
  78.  
  79. CREATE TABLE IF NOT EXISTS actor_switches (
  80.     id SERIAL PRIMARY KEY,
  81.     actor_id INTEGER NOT NULL,
  82.     switch_id INTEGER NOT NULL,
  83.     value INTEGER NOT NULL DEFAULT 0
  84. );
  85.  
  86. CREATE TABLE IF NOT EXISTS actor_variables (
  87.     id SERIAL PRIMARY KEY,
  88.     actor_id INTEGER NOT NULL,
  89.     variable_id INTEGER NOT NULL,
  90.     value INTEGER NOT NULL DEFAULT 0
  91. );
  92.  
  93. CREATE TABLE IF NOT EXISTS actor_weapons (
  94.     id SERIAL PRIMARY KEY,
  95.     actor_id INTEGER NOT NULL,
  96.     weapon_id INTEGER NOT NULL,
  97.     amount INTEGER NOT NULL
  98. );
  99.  
  100. CREATE TABLE IF NOT EXISTS actors (
  101.     id SERIAL PRIMARY KEY,
  102.     account_id INTEGER NOT NULL,
  103.     slot_id INTEGER NOT NULL,
  104.     name TEXT NOT NULL,
  105.     character_name TEXT NOT NULL,
  106.     character_index INTEGER NOT NULL,
  107.     face_name TEXT NOT NULL,
  108.     face_index INTEGER NOT NULL,
  109.     class_id INTEGER NOT NULL,
  110.     sex INTEGER NOT NULL,
  111.     level INTEGER NOT NULL,
  112.     exp INTEGER NOT NULL,
  113.     hp INTEGER NOT NULL,
  114.     mp INTEGER NOT NULL,
  115.     mhp INTEGER NOT NULL,
  116.     mmp INTEGER NOT NULL,
  117.     atk INTEGER NOT NULL,
  118.     def INTEGER NOT NULL,
  119.     int INTEGER NOT NULL,
  120.     res INTEGER NOT NULL,
  121.     agi INTEGER NOT NULL,
  122.     luk INTEGER NOT NULL,
  123.     points INTEGER NOT NULL,
  124.     guild_id INTEGER NOT NULL DEFAULT 0,
  125.     revive_map_id INTEGER NOT NULL,
  126.     revive_x INTEGER NOT NULL,
  127.     revive_y INTEGER NOT NULL,
  128.     map_id INTEGER NOT NULL,
  129.     x INTEGER NOT NULL,
  130.     y INTEGER NOT NULL,
  131.     direction INTEGER NOT NULL,
  132.     gold INTEGER NOT NULL DEFAULT 0,
  133.     online INTEGER NOT NULL DEFAULT 0,
  134.     creation_date INTEGER NOT NULL,
  135.     last_login INTEGER NOT NULL,
  136.     comment TEXT NOT NULL DEFAULT ''
  137. );
  138.  
  139. CREATE TABLE IF NOT EXISTS ban_list (
  140.     id SERIAL PRIMARY KEY,
  141.     account_id INTEGER NOT NULL,
  142.     ip TEXT NOT NULL,
  143.     time INTEGER NOT NULL,
  144.     ban_date INTEGER NOT NULL
  145. );
  146.  
  147. CREATE TABLE IF NOT EXISTS bank_armors (
  148.     id SERIAL PRIMARY KEY,
  149.     bank_id INTEGER NOT NULL,
  150.     armor_id INTEGER NOT NULL,
  151.     amount INTEGER NOT NULL
  152. );
  153.  
  154. CREATE TABLE IF NOT EXISTS bank_items (
  155.     id SERIAL PRIMARY KEY,
  156.     bank_id INTEGER NOT NULL,
  157.     item_id INTEGER NOT NULL,
  158.     amount INTEGER NOT NULL
  159. );
  160.  
  161. CREATE TABLE IF NOT EXISTS bank_weapons (
  162.     id SERIAL PRIMARY KEY,
  163.     bank_id INTEGER NOT NULL,
  164.     weapon_id INTEGER NOT NULL,
  165.     amount INTEGER NOT NULL
  166. );
  167.  
  168. CREATE TABLE IF NOT EXISTS banks (
  169.     id SERIAL PRIMARY KEY,
  170.     account_id INTEGER NOT NULL,
  171.     gold INTEGER NOT NULL DEFAULT 0
  172. );
  173.  
  174. CREATE TABLE IF NOT EXISTS configs (
  175.     id SERIAL PRIMARY KEY,
  176.     titlesite TEXT NOT NULL,
  177.     cashname TEXT NOT NULL,
  178.     maxrank INTEGER NOT NULL,
  179.     maxrankguild INTEGER NOT NULL,
  180.     maxitemstore INTEGER NOT NULL,
  181.     downloadlink TEXT NOT NULL,
  182.     discount TEXT NOT NULL,
  183.     languages TEXT NOT NULL,
  184.     langdefault TEXT NOT NULL,
  185.     ipserver TEXT NOT NULL,
  186.     portserver INTEGER NOT NULL,
  187.     maxnews INTEGER NOT NULL
  188. );
  189.  
  190. CREATE TABLE IF NOT EXISTS distributor (
  191.     id SERIAL PRIMARY KEY,
  192.     account_id INTEGER NOT NULL,
  193.     item_id INTEGER NOT NULL,
  194.     kind INTEGER NOT NULL,
  195.     amount INTEGER NOT NULL
  196. );
  197.  
  198. CREATE TABLE IF NOT EXISTS guilds (
  199.     id SERIAL PRIMARY KEY,
  200.     name TEXT NOT NULL,
  201.     leader TEXT NOT NULL,
  202.     notice TEXT NOT NULL DEFAULT '',
  203.     description TEXT NOT NULL DEFAULT '',
  204.     flag TEXT NOT NULL,
  205.     creation_date INTEGER NOT NULL
  206. );
  207.  
  208. CREATE TABLE IF NOT EXISTS news (
  209.     id SERIAL PRIMARY KEY,
  210.     title TEXT NOT NULL,
  211.     content TEXT NOT NULL,
  212.     date TEXT NOT NULL,
  213.     writer TEXT NOT NULL,
  214.     type INTEGER NOT NULL
  215. );
  216.  
  217. CREATE TABLE IF NOT EXISTS payment_voucher (
  218.     id SERIAL PRIMARY KEY,
  219.     account_id TEXT NOT NULL,
  220.     date INTEGER NOT NULL,
  221.     amount TEXT NOT NULL,
  222.     img TEXT NOT NULL,
  223.     reader INTEGER NOT NULL,
  224.     okay INTEGER NOT NULL
  225. );
  226.  
  227. CREATE TABLE IF NOT EXISTS records (
  228.     id SERIAL PRIMARY KEY,
  229.     text TEXT NOT NULL,
  230.     date TEXT NOT NULL,
  231.     account_id INTEGER NOT NULL,
  232.     purchase_id INTEGER NOT NULL
  233. );
  234.  
  235. CREATE TABLE IF NOT EXISTS store (
  236.     id SERIAL PRIMARY KEY,
  237.     category INTEGER NOT NULL,
  238.     name TEXT NOT NULL,
  239.     description TEXT NOT NULL,
  240.     price TEXT NOT NULL,
  241.     img TEXT NOT NULL,
  242.     amount TEXT NOT NULL,
  243.     purchased TEXT NOT NULL,
  244.     item_id TEXT NOT NULL
  245. );
  246.  
  247. COMMIT;
  248.  
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!