Home Explore Help
Register Sign In
L2j
/
l2j-server-datapack
2
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Branch: datapack_development
Branches Tags
l2j-server-data...
/
sql
/
clanhall.sql

clanhall.sql 6.5 KB
Permalink History Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263 
  1. -- ---------------------------
    2. 

  2. -- Table structure for clanhall
    3. 

  3. -- ---------------------------
    4. 

  4. CREATE TABLE IF NOT EXISTS `clanhall` (
    5. 

  5.   `id` int(11) NOT NULL default '0',
    6. 

  6.   `name` varchar(40) NOT NULL default '',
    7. 

  7.   `ownerId` int(11) NOT NULL default '0',
    8. 

  8.   `lease` int(10) NOT NULL default '0',
    9. 

  9.   `desc` text NOT NULL,
    10. 

  10.   `location` varchar(15) NOT NULL default '',
    11. 

  11.   `paidUntil` decimal(20,0) NOT NULL default '0',
    12. 

  12.   `Grade` decimal(1,0) NOT NULL default '0',
    13. 

  13.   `paid` int( 1 ) NOT NULL default '0',
    14. 

  14.   PRIMARY KEY `id` (`id`)
    15. 

  15. );
    16. 

  16. 

  17. -- ----------------------------
    18. 

  18. -- Records 
    19. 

  19. -- ----------------------------
    20. 

  20. INSERT IGNORE INTO `clanhall` VALUES ('21','Fortress of Resistance','0','0','Ol Mahum Fortress of Resistance','Dion','0','0','0');
    21. 

  21. INSERT IGNORE INTO `clanhall` VALUES ('22','Moonstone Hall','0','500000','Clan hall located in the Town of Gludio','Gludio','0','2','0');
    22. 

  22. INSERT IGNORE INTO `clanhall` VALUES ('23','Onyx Hall','0','500000','Clan hall located in the Town of Gludio','Gludio','0','2','0');
    23. 

  23. INSERT IGNORE INTO `clanhall` VALUES ('24','Topaz Hall','0','500000','Clan hall located in the Town of Gludio','Gludio','0','2','0');
    24. 

  24. INSERT IGNORE INTO `clanhall` VALUES ('25','Ruby Hall','0','500000','Clan hall located in the Town of Gludio','Gludio','0','2','0');
    25. 

  25. INSERT IGNORE INTO `clanhall` VALUES ('26','Crystal Hall','0','500000','Clan hall located in Gludin Village','Gludin','0','2','0');
    26. 

  26. INSERT IGNORE INTO `clanhall` VALUES ('27','Onyx Hall','0','500000','Clan hall located in Gludin Village','Gludin','0','2','0');
    27. 

  27. INSERT IGNORE INTO `clanhall` VALUES ('28','Sapphire Hall','0','500000','Clan hall located in Gludin Village','Gludin','0','2','0');
    28. 

  28. INSERT IGNORE INTO `clanhall` VALUES ('29','Moonstone Hall','0','500000','Clan hall located in Gludin Village','Gludin','0','2','0');
    29. 

  29. INSERT IGNORE INTO `clanhall` VALUES ('30','Emerald Hall','0','500000','Clan hall located in Gludin Village','Gludin','0','2','0');
    30. 

  30. INSERT IGNORE INTO `clanhall` VALUES ('31','The Atramental Barracks','0','200000','Clan hall located in the Town of Dion','Dion','0','1','0');
    31. 

  31. INSERT IGNORE INTO `clanhall` VALUES ('32','The Scarlet Barracks','0','200000','Clan hall located in the Town of Dion','Dion','0','1','0');
    32. 

  32. INSERT IGNORE INTO `clanhall` VALUES ('33','The Viridian Barracks','0','200000','Clan hall located in the Town of Dion','Dion','0','1','0');
    33. 

  33. INSERT IGNORE INTO `clanhall` VALUES ('34','Devastated Castle','0','0','Contestable Clan Hall','Aden','0','0','0');
    34. 

  34. INSERT IGNORE INTO `clanhall` VALUES ('35','Bandit Stronghold','0','0','Contestable Clan Hall','Oren','0','0','0');
    35. 

  35. INSERT IGNORE INTO `clanhall` VALUES ('36','The Golden Chamber','0','1000000','Clan hall located in the Town of Aden','Aden','0','3','0');
    36. 

  36. INSERT IGNORE INTO `clanhall` VALUES ('37','The Silver Chamber','0','1000000','Clan hall located in the Town of Aden','Aden','0','3','0');
    37. 

  37. INSERT IGNORE INTO `clanhall` VALUES ('38','The Mithril Chamber','0','1000000','Clan hall located in the Town of Aden','Aden','0','3','0');
    38. 

  38. INSERT IGNORE INTO `clanhall` VALUES ('39','Silver Manor','0','1000000','Clan hall located in the Town of Aden','Aden','0','3','0');
    39. 

  39. INSERT IGNORE INTO `clanhall` VALUES ('40','Gold Manor','0','1000000','Clan hall located in the Town of Aden','Aden','0','3','0');
    40. 

  40. INSERT IGNORE INTO `clanhall` VALUES ('41','The Bronze Chamber','0','1000000','Clan hall located in the Town of Aden','Aden','0','3','0');
    41. 

  41. INSERT IGNORE INTO `clanhall` VALUES ('42','The Golden Chamber','0','1000000','Clan hall located in the Town of Giran','Giran','0','3','0');
    42. 

  42. INSERT IGNORE INTO `clanhall` VALUES ('43','The Silver Chamber','0','1000000','Clan hall located in the Town of Giran','Giran','0','3','0');
    43. 

  43. INSERT IGNORE INTO `clanhall` VALUES ('44','The Mithril Chamber','0','1000000','Clan hall located in the Town of Giran','Giran','0','3','0');
    44. 

  44. INSERT IGNORE INTO `clanhall` VALUES ('45','The Bronze Chamber','0','1000000','Clan hall located in the Town of Giran','Giran','0','3','0');
    45. 

  45. INSERT IGNORE INTO `clanhall` VALUES ('46','Silver Manor','0','1000000','Clan hall located in the Town of Giran','Giran','0','3','0');
    46. 

  46. INSERT IGNORE INTO `clanhall` VALUES ('47','Moonstone Hall','0','1000000','Clan hall located in the Town of Goddard','Goddard','0','3','0');
    47. 

  47. INSERT IGNORE INTO `clanhall` VALUES ('48','Onyx Hall','0','1000000','Clan hall located in the Town of Goddard','Goddard','0','3','0');
    48. 

  48. INSERT IGNORE INTO `clanhall` VALUES ('49','Emerald Hall','0','1000000','Clan hall located in the Town of Goddard','Goddard','0','3','0');
    49. 

  49. INSERT IGNORE INTO `clanhall` VALUES ('50','Sapphire Hall','0','1000000','Clan hall located in the Town of Goddard','Goddard','0','3','0');
    50. 

  50. INSERT IGNORE INTO `clanhall` VALUES ('51','Mont Chamber','0','1000000','An upscale Clan hall located in the Rune Township','Rune','0','3','0');
    51. 

  51. INSERT IGNORE INTO `clanhall` VALUES ('52','Astaire Chamber','0','1000000','An upscale Clan hall located in the Rune Township','Rune','0','3','0');
    52. 

  52. INSERT IGNORE INTO `clanhall` VALUES ('53','Aria Chamber','0','1000000','An upscale Clan hall located in the Rune Township','Rune','0','3','0');
    53. 

  53. INSERT IGNORE INTO `clanhall` VALUES ('54','Yiana Chamber','0','1000000','An upscale Clan hall located in the Rune Township','Rune','0','3','0');
    54. 

  54. INSERT IGNORE INTO `clanhall` VALUES ('55','Roien Chamber','0','1000000','An upscale Clan hall located in the Rune Township','Rune','0','3','0');
    55. 

  55. INSERT IGNORE INTO `clanhall` VALUES ('56','Luna Chamber','0','1000000','An upscale Clan hall located in the Rune Township','Rune','0','3','0');
    56. 

  56. INSERT IGNORE INTO `clanhall` VALUES ('57','Traban Chamber','0','1000000','An upscale Clan hall located in the Rune Township','Rune','0','3','0');
    57. 

  57. INSERT IGNORE INTO `clanhall` VALUES ('58','Eisen Hall','0','500000','Clan hall located in the Town of Schuttgart','Schuttgart','0','2','0');
    58. 

  58. INSERT IGNORE INTO `clanhall` VALUES ('59','Heavy Metal Hall','0','500000','Clan hall located in the Town of Schuttgart','Schuttgart','0','2','0');
    59. 

  59. INSERT IGNORE INTO `clanhall` VALUES ('60','Molten Ore Hall','0','500000','Clan hall located in the Town of Schuttgart','Schuttgart','0','2','0');
    60. 

  60. INSERT IGNORE INTO `clanhall` VALUES ('61','Titan Hall','0','500000','Clan hall located in the Town of Schuttgart','Schuttgart','0','2','0');
    61. 

  61. INSERT IGNORE INTO `clanhall` VALUES ('62','Rainbow Springs','0','0','','Goddard','0','0','0');
    62. 

  62. INSERT IGNORE INTO `clanhall` VALUES ('63','Beast Farm','0','0','','Rune','0','0','0');
    63. 

  63. INSERT IGNORE INTO `clanhall` VALUES ('64','Fortress of the Dead','0','0','','Rune','0','0','0');
    64.