Changeset 429 for trunk/sql


Ignore:
Timestamp:
Apr 8, 2010, 8:31:45 PM (15 years ago)
Author:
george
Message:
  • Opraveno: Ukládání nových textů do databáze nebylo převedeno na databázový lomítková řetězec.
Location:
trunk/sql
Files:
3 edited

Legend:

Unmodified
Added
Removed

  • trunk/sql/structure.sql

    r416 r429  
    44--
    55-- Počítač: localhost
    6 -- Vygenerováno: Úterý 06. dubna 2010, 06:55
     6-- Vygenerováno: Čtvrtek 08. dubna 2010, 20:17
    77-- Verze MySQL: 5.1.44
    88-- Verze PHP: 5.3.1
    … …  
    111111
    112112--
     113-- Struktura tabulky `DbVersion`
     114--
     115
     116CREATE TABLE IF NOT EXISTS `DbVersion` (
     117  `Id` int(11) NOT NULL AUTO_INCREMENT,
     118  `Version` varchar(255) NOT NULL,
     119  `Require_426` int(255) DEFAULT NULL,
     120  PRIMARY KEY (`Id`),
     121  UNIQUE KEY `Name` (`Version`)
     122) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
     123
     124-- --------------------------------------------------------
     125
     126--
    113127-- Struktura tabulky `Dictionary`
    114128--
    … …  
    267281  `Id` int(11) NOT NULL AUTO_INCREMENT,
    268282  `Group` int(11) NOT NULL,
     283  `Sequence` int(11) NOT NULL,
    269284  `Name` varchar(255) COLLATE utf8_czech_ci NOT NULL,
    270285  `Column` varchar(255) COLLATE utf8_czech_ci NOT NULL,
    … …  
    386401  `User` int(11) NOT NULL,
    387402  `Complete` int(11) NOT NULL,
     403  `CompleteParts` int(11) NOT NULL,
    388404  `Take` int(11) NOT NULL,
    389405  `Name` text NOT NULL,
    … …  
    392408  `VersionStart` int(11) NOT NULL DEFAULT '8606',
    393409  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
    394   PRIMARY KEY (`ID`),
    395   KEY `entry` (`Entry`),
    396   KEY `User` (`User`),
    397   KEY `Take` (`Take`),
    398   KEY `Language` (`Language`),
    399   KEY `Complete` (`Complete`),
    400   KEY `VersionStart` (`VersionStart`),
    401   KEY `VersionEnd` (`VersionEnd`)
     410  `ModifyTime` datetime NOT NULL,
     411  PRIMARY KEY (`ID`),
     412  KEY `entry` (`Entry`),
     413  KEY `User` (`User`),
     414  KEY `Take` (`Take`),
     415  KEY `Language` (`Language`),
     416  KEY `Complete` (`Complete`),
     417  KEY `VersionStart` (`VersionStart`),
     418  KEY `VersionEnd` (`VersionEnd`),
     419  KEY `ModifyTime` (`ModifyTime`)
    402420) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
    403421
    … …  
    414432  `User` int(11) NOT NULL,
    415433  `Complete` int(11) NOT NULL,
     434  `CompleteParts` int(11) NOT NULL,
    416435  `Take` int(11) NOT NULL,
    417436  `Name` text NOT NULL,
    418437  `VersionStart` int(11) NOT NULL DEFAULT '8606',
    419438  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
    420   PRIMARY KEY (`ID`),
    421   KEY `entry` (`Entry`),
    422   KEY `User` (`User`),
    423   KEY `Take` (`Take`),
    424   KEY `Language` (`Language`),
    425   KEY `Complete` (`Complete`),
    426   KEY `VersionStart` (`VersionStart`),
    427   KEY `VersionEnd` (`VersionEnd`)
     439  `ModifyTime` datetime NOT NULL,
     440  PRIMARY KEY (`ID`),
     441  KEY `entry` (`Entry`),
     442  KEY `User` (`User`),
     443  KEY `Take` (`Take`),
     444  KEY `Language` (`Language`),
     445  KEY `Complete` (`Complete`),
     446  KEY `VersionStart` (`VersionStart`),
     447  KEY `VersionEnd` (`VersionEnd`),
     448  KEY `ModifyTime` (`ModifyTime`)
    428449) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
    429450
    … …  
    440461  `User` int(11) NOT NULL,
    441462  `Complete` int(11) NOT NULL,
     463  `CompleteParts` int(11) NOT NULL,
    442464  `Take` int(11) NOT NULL,
    443465  `Text` text NOT NULL,
    444466  `VersionStart` int(11) NOT NULL DEFAULT '8606',
    445467  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
    446   PRIMARY KEY (`ID`),
    447   KEY `entry` (`Entry`),
    448   KEY `User` (`User`),
    449   KEY `Take` (`Take`),
    450   KEY `Language` (`Language`),
    451   KEY `Complete` (`Complete`),
    452   KEY `VersionStart` (`VersionStart`),
    453   KEY `VersionEnd` (`VersionEnd`)
     468  `ModifyTime` datetime NOT NULL,
     469  PRIMARY KEY (`ID`),
     470  KEY `entry` (`Entry`),
     471  KEY `User` (`User`),
     472  KEY `Take` (`Take`),
     473  KEY `Language` (`Language`),
     474  KEY `Complete` (`Complete`),
     475  KEY `VersionStart` (`VersionStart`),
     476  KEY `VersionEnd` (`VersionEnd`),
     477  KEY `ModifyTime` (`ModifyTime`)
    454478) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
    455479
    … …  
    466490  `User` int(11) NOT NULL,
    467491  `Complete` int(11) NOT NULL,
     492  `CompleteParts` int(11) NOT NULL,
    468493  `Take` int(11) NOT NULL,
    469494  `Name` text NOT NULL,
    470495  `VersionStart` int(11) NOT NULL DEFAULT '8606',
    471496  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
    472   PRIMARY KEY (`ID`),
    473   KEY `entry` (`Entry`),
    474   KEY `User` (`User`),
    475   KEY `Take` (`Take`),
    476   KEY `Language` (`Language`),
    477   KEY `Complete` (`Complete`),
    478   KEY `VersionStart` (`VersionStart`),
    479   KEY `VersionEnd` (`VersionEnd`)
     497  `ModifyTime` datetime NOT NULL,
     498  PRIMARY KEY (`ID`),
     499  KEY `entry` (`Entry`),
     500  KEY `User` (`User`),
     501  KEY `Take` (`Take`),
     502  KEY `Language` (`Language`),
     503  KEY `Complete` (`Complete`),
     504  KEY `VersionStart` (`VersionStart`),
     505  KEY `VersionEnd` (`VersionEnd`),
     506  KEY `ModifyTime` (`ModifyTime`)
    480507) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
    481508
    … …  
    492519  `User` int(11) NOT NULL,
    493520  `Complete` int(11) NOT NULL,
     521  `CompleteParts` int(11) NOT NULL,
    494522  `Take` int(11) NOT NULL,
    495523  `Name` text NOT NULL,
    496524  `VersionStart` int(11) NOT NULL DEFAULT '8606',
    497525  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
    498   PRIMARY KEY (`ID`),
    499   KEY `entry` (`Entry`),
    500   KEY `User` (`User`),
    501   KEY `Take` (`Take`),
    502   KEY `Language` (`Language`),
    503   KEY `Complete` (`Complete`),
    504   KEY `VersionStart` (`VersionStart`),
    505   KEY `VersionEnd` (`VersionEnd`)
     526  `ModifyTime` datetime NOT NULL,
     527  PRIMARY KEY (`ID`),
     528  KEY `entry` (`Entry`),
     529  KEY `User` (`User`),
     530  KEY `Take` (`Take`),
     531  KEY `Language` (`Language`),
     532  KEY `Complete` (`Complete`),
     533  KEY `VersionStart` (`VersionStart`),
     534  KEY `VersionEnd` (`VersionEnd`),
     535  KEY `ModifyTime` (`ModifyTime`)
    506536) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
    507537
    … …  
    515545  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
    516546  `Entry` int(11) NOT NULL,
    517   `name` text NOT NULL,
    518   `subname` text NOT NULL,
    519   `Language` int(11) NOT NULL DEFAULT '0',
    520   `User` int(11) NOT NULL,
    521   `Complete` int(11) NOT NULL,
    522   `Take` int(11) NOT NULL,
    523   `VersionStart` int(11) NOT NULL DEFAULT '8606',
    524   `VersionEnd` int(11) NOT NULL DEFAULT '8606',
    525   PRIMARY KEY (`ID`),
    526   KEY `entry` (`Entry`),
    527   KEY `User` (`User`),
    528   KEY `Take` (`Take`),
    529   KEY `Complete` (`Complete`),
    530   KEY `Language` (`Language`),
    531   KEY `VersionStart` (`VersionStart`),
    532   KEY `VersionEnd` (`VersionEnd`)
     547  `Name` text NOT NULL,
     548  `SubName` text NOT NULL,
     549  `Language` int(11) NOT NULL DEFAULT '0',
     550  `User` int(11) NOT NULL,
     551  `Complete` int(11) NOT NULL,
     552  `CompleteParts` int(11) NOT NULL,
     553  `Take` int(11) NOT NULL,
     554  `VersionStart` int(11) NOT NULL DEFAULT '8606',
     555  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
     556  `ModifyTime` datetime NOT NULL,
     557  PRIMARY KEY (`ID`),
     558  KEY `entry` (`Entry`),
     559  KEY `User` (`User`),
     560  KEY `Take` (`Take`),
     561  KEY `Complete` (`Complete`),
     562  KEY `Language` (`Language`),
     563  KEY `VersionStart` (`VersionStart`),
     564  KEY `VersionEnd` (`VersionEnd`),
     565  KEY `ModifyTime` (`ModifyTime`)
    533566) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
    534567
    … …  
    543576  `Entry` int(11) NOT NULL,
    544577  `Name` text NOT NULL,
    545   `castbarcaption` text NOT NULL,
    546   `Language` int(11) NOT NULL DEFAULT '0',
    547   `User` int(11) NOT NULL,
    548   `Complete` int(11) NOT NULL,
    549   `Take` int(11) NOT NULL,
    550   `VersionStart` int(11) NOT NULL DEFAULT '8606',
    551   `VersionEnd` int(11) NOT NULL DEFAULT '8606',
    552   PRIMARY KEY (`ID`),
    553   KEY `entry` (`Entry`),
    554   KEY `User` (`User`),
    555   KEY `Take` (`Take`),
    556   KEY `Complete` (`Complete`),
    557   KEY `Language` (`Language`),
    558   KEY `VersionStart` (`VersionStart`),
    559   KEY `VersionEnd` (`VersionEnd`)
     578  `CastBarCaption` text NOT NULL,
     579  `Language` int(11) NOT NULL DEFAULT '0',
     580  `User` int(11) NOT NULL,
     581  `Complete` int(11) NOT NULL,
     582  `CompleteParts` int(11) NOT NULL,
     583  `Take` int(11) NOT NULL,
     584  `VersionStart` int(11) NOT NULL DEFAULT '8606',
     585  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
     586  `ModifyTime` datetime NOT NULL,
     587  PRIMARY KEY (`ID`),
     588  KEY `entry` (`Entry`),
     589  KEY `User` (`User`),
     590  KEY `Take` (`Take`),
     591  KEY `Complete` (`Complete`),
     592  KEY `Language` (`Language`),
     593  KEY `VersionStart` (`VersionStart`),
     594  KEY `VersionEnd` (`VersionEnd`),
     595  KEY `ModifyTime` (`ModifyTime`)
    560596) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
    561597
    … …  
    573609  `User` int(11) NOT NULL,
    574610  `Complete` int(11) NOT NULL,
    575   `Take` int(11) NOT NULL,
    576   `VersionStart` int(11) NOT NULL DEFAULT '8606',
    577   `VersionEnd` int(11) NOT NULL DEFAULT '8606',
    578   PRIMARY KEY (`ID`),
    579   KEY `entry` (`Entry`),
    580   KEY `User` (`User`),
    581   KEY `Take` (`Take`),
    582   KEY `Language` (`Language`),
    583   KEY `Complete` (`Complete`),
    584   KEY `VersionStart` (`VersionStart`),
    585   KEY `VersionEnd` (`VersionEnd`)
     611  `CompleteParts` int(11) NOT NULL,
     612  `Take` int(11) NOT NULL,
     613  `VersionStart` int(11) NOT NULL DEFAULT '8606',
     614  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
     615  `ModifyTime` datetime NOT NULL,
     616  PRIMARY KEY (`ID`),
     617  KEY `entry` (`Entry`),
     618  KEY `User` (`User`),
     619  KEY `Take` (`Take`),
     620  KEY `Language` (`Language`),
     621  KEY `Complete` (`Complete`),
     622  KEY `VersionStart` (`VersionStart`),
     623  KEY `VersionEnd` (`VersionEnd`),
     624  KEY `ModifyTime` (`ModifyTime`)
    586625) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
    587626
    … …  
    598637  `User` int(11) NOT NULL,
    599638  `Complete` int(11) NOT NULL,
     639  `CompleteParts` int(11) NOT NULL,
    600640  `Take` int(11) NOT NULL,
    601641  `ShortCut` varchar(255) NOT NULL,
    … …  
    604644  `VersionStart` int(11) NOT NULL DEFAULT '8606',
    605645  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
     646  `ModifyTime` datetime NOT NULL,
    606647  PRIMARY KEY (`ID`),
    607648  KEY `entry` (`Entry`),
    … …  
    612653  KEY `ShortCut` (`ShortCut`),
    613654  KEY `VersionStart` (`VersionStart`),
    614   KEY `VersionEnd` (`VersionEnd`)
     655  KEY `VersionEnd` (`VersionEnd`),
     656  KEY `ModifyTime` (`ModifyTime`)
    615657) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
    616658
    … …  
    627669  `User` int(11) NOT NULL,
    628670  `Complete` int(11) NOT NULL,
     671  `CompleteParts` int(11) NOT NULL,
    629672  `Take` int(11) NOT NULL,
    630673  `ShortCut` varchar(255) NOT NULL,
    … …  
    633676  `VersionStart` int(11) NOT NULL DEFAULT '8606',
    634677  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
     678  `ModifyTime` datetime NOT NULL,
    635679  PRIMARY KEY (`ID`),
    636680  KEY `entry` (`Entry`),
    … …  
    641685  KEY `ShortCut` (`ShortCut`),
    642686  KEY `VersionStart` (`VersionStart`),
    643   KEY `VersionEnd` (`VersionEnd`)
     687  KEY `VersionEnd` (`VersionEnd`),
     688  KEY `ModifyTime` (`ModifyTime`)
    644689) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
    645690
    … …  
    656701  `User` int(11) NOT NULL,
    657702  `Complete` int(11) NOT NULL,
     703  `CompleteParts` int(11) NOT NULL,
    658704  `Take` int(11) NOT NULL,
    659705  `ShortCut` varchar(255) NOT NULL,
    … …  
    662708  `VersionStart` int(11) NOT NULL DEFAULT '8606',
    663709  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
     710  `ModifyTime` datetime NOT NULL,
    664711  PRIMARY KEY (`ID`),
    665712  KEY `entry` (`Entry`),
    … …  
    670717  KEY `ShortCut` (`ShortCut`),
    671718  KEY `VersionStart` (`VersionStart`),
    672   KEY `VersionEnd` (`VersionEnd`)
     719  KEY `VersionEnd` (`VersionEnd`),
     720  KEY `ModifyTime` (`ModifyTime`)
    673721) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
    674722
    … …  
    687735  `User` int(11) NOT NULL,
    688736  `Complete` int(11) NOT NULL,
    689   `Take` int(11) NOT NULL,
    690   `VersionStart` int(11) NOT NULL DEFAULT '8606',
    691   `VersionEnd` int(11) NOT NULL DEFAULT '8606',
    692   PRIMARY KEY (`ID`),
    693   KEY `entry` (`Entry`),
    694   KEY `User` (`User`),
    695   KEY `Take` (`Take`),
    696   KEY `Complete` (`Complete`),
    697   KEY `Language` (`Language`),
    698   KEY `VersionStart` (`VersionStart`),
    699   KEY `VersionEnd` (`VersionEnd`)
     737  `CompleteParts` int(11) NOT NULL,
     738  `Take` int(11) NOT NULL,
     739  `VersionStart` int(11) NOT NULL DEFAULT '8606',
     740  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
     741  `ModifyTime` datetime NOT NULL,
     742  PRIMARY KEY (`ID`),
     743  KEY `entry` (`Entry`),
     744  KEY `User` (`User`),
     745  KEY `Take` (`Take`),
     746  KEY `Complete` (`Complete`),
     747  KEY `Language` (`Language`),
     748  KEY `VersionStart` (`VersionStart`),
     749  KEY `VersionEnd` (`VersionEnd`),
     750  KEY `ModifyTime` (`ModifyTime`)
    700751) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
    701752
    … …  
    709760  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
    710761  `Entry` int(11) NOT NULL,
    711   `help` text NOT NULL,
    712   `Language` int(11) NOT NULL DEFAULT '0',
    713   `User` int(11) NOT NULL,
    714   `Complete` int(11) NOT NULL,
     762  `Help` text NOT NULL,
     763  `Language` int(11) NOT NULL DEFAULT '0',
     764  `User` int(11) NOT NULL,
     765  `Complete` int(11) NOT NULL,
     766  `CompleteParts` int(11) NOT NULL,
    715767  `Take` int(11) NOT NULL,
    716768  `Name` varchar(255) NOT NULL,
    717769  `VersionStart` int(11) NOT NULL DEFAULT '8606',
    718770  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
     771  `ModifyTime` datetime NOT NULL,
    719772  PRIMARY KEY (`ID`),
    720773  KEY `entry` (`Entry`),
    … …  
    725778  KEY `Name` (`Name`),
    726779  KEY `VersionStart` (`VersionStart`),
    727   KEY `VersionEnd` (`VersionEnd`)
     780  KEY `VersionEnd` (`VersionEnd`),
     781  KEY `ModifyTime` (`ModifyTime`)
    728782) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
    729783
    … …  
    737791  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
    738792  `Entry` int(11) NOT NULL,
    739   `content_default` text NOT NULL,
    740   `Language` int(11) NOT NULL DEFAULT '0',
    741   `User` int(11) NOT NULL,
    742   `Complete` int(11) NOT NULL,
    743   `Take` int(11) NOT NULL,
    744   `VersionStart` int(11) NOT NULL DEFAULT '8606',
    745   `VersionEnd` int(11) NOT NULL DEFAULT '8606',
    746   PRIMARY KEY (`ID`),
    747   KEY `entry` (`Entry`),
    748   KEY `User` (`User`),
    749   KEY `Take` (`Take`),
    750   KEY `Complete` (`Complete`),
    751   KEY `Language` (`Language`),
    752   KEY `VersionStart` (`VersionStart`),
    753   KEY `VersionEnd` (`VersionEnd`)
     793  `ContentDefault` text NOT NULL,
     794  `Language` int(11) NOT NULL DEFAULT '0',
     795  `User` int(11) NOT NULL,
     796  `Complete` int(11) NOT NULL,
     797  `CompleteParts` int(11) NOT NULL,
     798  `Take` int(11) NOT NULL,
     799  `VersionStart` int(11) NOT NULL DEFAULT '8606',
     800  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
     801  `ModifyTime` datetime NOT NULL,
     802  PRIMARY KEY (`ID`),
     803  KEY `entry` (`Entry`),
     804  KEY `User` (`User`),
     805  KEY `Take` (`Take`),
     806  KEY `Complete` (`Complete`),
     807  KEY `Language` (`Language`),
     808  KEY `VersionStart` (`VersionStart`),
     809  KEY `VersionEnd` (`VersionEnd`),
     810  KEY `ModifyTime` (`ModifyTime`)
    754811) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
    755812
    … …  
    782839  `User` int(11) NOT NULL,
    783840  `Complete` int(11) NOT NULL,
    784   `Take` int(11) NOT NULL,
    785   `VersionStart` int(11) NOT NULL DEFAULT '8606',
    786   `VersionEnd` int(11) NOT NULL DEFAULT '8606',
    787   PRIMARY KEY (`ID`),
    788   KEY `entry` (`Entry`),
    789   KEY `User` (`User`),
    790   KEY `Take` (`Take`),
    791   KEY `Complete` (`Complete`),
    792   KEY `Language` (`Language`),
    793   KEY `VersionStart` (`VersionStart`),
    794   KEY `VersionEnd` (`VersionEnd`)
     841  `CompleteParts` int(11) NOT NULL,
     842  `Take` int(11) NOT NULL,
     843  `VersionStart` int(11) NOT NULL DEFAULT '8606',
     844  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
     845  `ModifyTime` datetime NOT NULL,
     846  PRIMARY KEY (`ID`),
     847  KEY `entry` (`Entry`),
     848  KEY `User` (`User`),
     849  KEY `Take` (`Take`),
     850  KEY `Complete` (`Complete`),
     851  KEY `Language` (`Language`),
     852  KEY `VersionStart` (`VersionStart`),
     853  KEY `VersionEnd` (`VersionEnd`),
     854  KEY `ModifyTime` (`ModifyTime`)
    795855) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
    796856
    … …  
    807867  `User` int(11) NOT NULL,
    808868  `Complete` int(11) NOT NULL,
     869  `CompleteParts` int(11) NOT NULL,
    809870  `Take` int(11) NOT NULL,
    810871  `Index` varchar(255) NOT NULL,
    … …  
    812873  `VersionStart` int(11) NOT NULL DEFAULT '8606',
    813874  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
    814   PRIMARY KEY (`ID`),
    815   KEY `entry` (`Entry`),
    816   KEY `User` (`User`),
    817   KEY `Take` (`Take`),
    818   KEY `Language` (`Language`),
    819   KEY `Complete` (`Complete`),
    820   KEY `VersionStart` (`VersionStart`),
    821   KEY `VersionEnd` (`VersionEnd`)
     875  `ModifyTime` datetime NOT NULL,
     876  PRIMARY KEY (`ID`),
     877  KEY `entry` (`Entry`),
     878  KEY `User` (`User`),
     879  KEY `Take` (`Take`),
     880  KEY `Language` (`Language`),
     881  KEY `Complete` (`Complete`),
     882  KEY `VersionStart` (`VersionStart`),
     883  KEY `VersionEnd` (`VersionEnd`),
     884  KEY `ModifyTime` (`ModifyTime`)
    822885) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
    823886
    … …  
    835898  `User` int(11) NOT NULL,
    836899  `Complete` int(11) NOT NULL,
    837   `Take` int(11) NOT NULL,
    838   `VersionStart` int(11) NOT NULL DEFAULT '8606',
    839   `VersionEnd` int(11) NOT NULL DEFAULT '8606',
    840   PRIMARY KEY (`ID`),
    841   KEY `entry` (`Entry`),
    842   KEY `User` (`User`),
    843   KEY `Take` (`Take`),
    844   KEY `Complete` (`Complete`),
    845   KEY `Language` (`Language`),
    846   KEY `VersionStart` (`VersionStart`),
    847   KEY `VersionEnd` (`VersionEnd`)
     900  `CompleteParts` int(11) NOT NULL,
     901  `Take` int(11) NOT NULL,
     902  `VersionStart` int(11) NOT NULL DEFAULT '8606',
     903  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
     904  `ModifyTime` datetime NOT NULL,
     905  PRIMARY KEY (`ID`),
     906  KEY `entry` (`Entry`),
     907  KEY `User` (`User`),
     908  KEY `Take` (`Take`),
     909  KEY `Complete` (`Complete`),
     910  KEY `Language` (`Language`),
     911  KEY `VersionStart` (`VersionStart`),
     912  KEY `VersionEnd` (`VersionEnd`),
     913  KEY `ModifyTime` (`ModifyTime`)
    848914) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Item System';
    849915
    … …  
    870936  `User` int(11) NOT NULL,
    871937  `Complete` int(11) NOT NULL DEFAULT '1',
    872   `Take` int(11) NOT NULL,
    873   `VersionStart` int(11) NOT NULL DEFAULT '8606',
    874   `VersionEnd` int(11) NOT NULL DEFAULT '8606',
     938  `CompleteParts` int(11) NOT NULL,
     939  `Take` int(11) NOT NULL,
     940  `VersionStart` int(11) NOT NULL DEFAULT '8606',
     941  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
     942  `ModifyTime` datetime NOT NULL,
    875943  PRIMARY KEY (`ID`),
    876944  KEY `entry` (`Entry`),
    … …  
    879947  KEY `Language` (`Language`),
    880948  KEY `VersionStart` (`VersionStart`),
    881   KEY `VersionEnd` (`VersionEnd`)
    882 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1;
     949  KEY `VersionEnd` (`VersionEnd`),
     950  KEY `ModifyTime` (`ModifyTime`)
     951) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
    883952
    884953-- --------------------------------------------------------
    … …  
    891960  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
    892961  `Entry` int(11) NOT NULL,
    893   `content_default` text NOT NULL,
    894   `comment` text NOT NULL,
    895   `Language` int(11) NOT NULL DEFAULT '0',
    896   `User` int(11) NOT NULL,
    897   `Complete` int(11) NOT NULL,
    898   `Take` int(11) NOT NULL,
    899   `VersionStart` int(11) NOT NULL DEFAULT '8606',
    900   `VersionEnd` int(11) NOT NULL DEFAULT '8606',
    901   PRIMARY KEY (`ID`),
    902   KEY `entry` (`Entry`),
    903   KEY `User` (`User`),
    904   KEY `Take` (`Take`),
    905   KEY `Complete` (`Complete`),
    906   KEY `Language` (`Language`),
    907   KEY `VersionStart` (`VersionStart`),
    908   KEY `VersionEnd` (`VersionEnd`)
     962  `ContentDefault` text NOT NULL,
     963  `Comment` text NOT NULL,
     964  `Language` int(11) NOT NULL DEFAULT '0',
     965  `User` int(11) NOT NULL,
     966  `Complete` int(11) NOT NULL,
     967  `CompleteParts` int(11) NOT NULL,
     968  `Take` int(11) NOT NULL,
     969  `VersionStart` int(11) NOT NULL DEFAULT '8606',
     970  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
     971  `ModifyTime` datetime NOT NULL,
     972  PRIMARY KEY (`ID`),
     973  KEY `entry` (`Entry`),
     974  KEY `User` (`User`),
     975  KEY `Take` (`Take`),
     976  KEY `Complete` (`Complete`),
     977  KEY `Language` (`Language`),
     978  KEY `VersionStart` (`VersionStart`),
     979  KEY `VersionEnd` (`VersionEnd`),
     980  KEY `ModifyTime` (`ModifyTime`)
    909981) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
    910982
    … …  
    918990  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
    919991  `Entry` int(11) NOT NULL,
    920   `content_default` text NOT NULL,
    921   `comment` text NOT NULL,
    922   `Language` int(11) NOT NULL DEFAULT '0',
    923   `User` int(11) NOT NULL,
    924   `Complete` int(11) NOT NULL,
    925   `Take` int(11) NOT NULL,
    926   `VersionStart` int(11) NOT NULL DEFAULT '8606',
    927   `VersionEnd` int(11) NOT NULL DEFAULT '8606',
    928   PRIMARY KEY (`ID`),
    929   KEY `entry` (`Entry`),
    930   KEY `User` (`User`),
    931   KEY `Take` (`Take`),
    932   KEY `Complete` (`Complete`),
    933   KEY `Language` (`Language`),
    934   KEY `VersionStart` (`VersionStart`),
    935   KEY `VersionEnd` (`VersionEnd`)
     992  `ContentDefault` text NOT NULL,
     993  `Comment` text NOT NULL,
     994  `Language` int(11) NOT NULL DEFAULT '0',
     995  `User` int(11) NOT NULL,
     996  `Complete` int(11) NOT NULL,
     997  `CompleteParts` int(11) NOT NULL,
     998  `Take` int(11) NOT NULL,
     999  `VersionStart` int(11) NOT NULL DEFAULT '8606',
     1000  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
     1001  `ModifyTime` datetime NOT NULL,
     1002  PRIMARY KEY (`ID`),
     1003  KEY `entry` (`Entry`),
     1004  KEY `User` (`User`),
     1005  KEY `Take` (`Take`),
     1006  KEY `Complete` (`Complete`),
     1007  KEY `Language` (`Language`),
     1008  KEY `VersionStart` (`VersionStart`),
     1009  KEY `VersionEnd` (`VersionEnd`),
     1010  KEY `ModifyTime` (`ModifyTime`)
    9361011) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
    9371012
    … …  
    9521027  `User` int(11) NOT NULL,
    9531028  `Complete` int(11) NOT NULL,
    954   `Take` int(11) NOT NULL,
    955   `VersionStart` int(11) NOT NULL DEFAULT '8606',
    956   `VersionEnd` int(11) NOT NULL DEFAULT '8606',
    957   PRIMARY KEY (`ID`),
    958   KEY `entry` (`Entry`),
    959   KEY `User` (`User`),
    960   KEY `Take` (`Take`),
    961   KEY `Language` (`Language`),
    962   KEY `Complete` (`Complete`),
    963   KEY `VersionStart` (`VersionStart`),
    964   KEY `VersionEnd` (`VersionEnd`)
     1029  `CompleteParts` int(11) NOT NULL,
     1030  `Take` int(11) NOT NULL,
     1031  `VersionStart` int(11) NOT NULL DEFAULT '8606',
     1032  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
     1033  `ModifyTime` datetime NOT NULL,
     1034  PRIMARY KEY (`ID`),
     1035  KEY `entry` (`Entry`),
     1036  KEY `User` (`User`),
     1037  KEY `Take` (`Take`),
     1038  KEY `Language` (`Language`),
     1039  KEY `Complete` (`Complete`),
     1040  KEY `VersionStart` (`VersionStart`),
     1041  KEY `VersionEnd` (`VersionEnd`),
     1042  KEY `ModifyTime` (`ModifyTime`)
    9651043) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
    9661044
    … …  
    9771055  `User` int(11) NOT NULL,
    9781056  `Complete` int(11) NOT NULL,
     1057  `CompleteParts` int(11) NOT NULL,
    9791058  `Take` int(11) NOT NULL,
    9801059  `Name` text NOT NULL,
    9811060  `VersionStart` int(11) NOT NULL DEFAULT '8606',
    9821061  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
    983   PRIMARY KEY (`ID`),
    984   KEY `entry` (`Entry`),
    985   KEY `User` (`User`),
    986   KEY `Take` (`Take`),
    987   KEY `Language` (`Language`),
    988   KEY `Complete` (`Complete`),
    989   KEY `VersionStart` (`VersionStart`),
    990   KEY `VersionEnd` (`VersionEnd`)
     1062  `ModifyTime` datetime NOT NULL,
     1063  PRIMARY KEY (`ID`),
     1064  KEY `entry` (`Entry`),
     1065  KEY `User` (`User`),
     1066  KEY `Take` (`Take`),
     1067  KEY `Language` (`Language`),
     1068  KEY `Complete` (`Complete`),
     1069  KEY `VersionStart` (`VersionStart`),
     1070  KEY `VersionEnd` (`VersionEnd`),
     1071  KEY `ModifyTime` (`ModifyTime`)
    9911072) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
    9921073

  • trunk/sql/updates/426.php

    r426 r429  
    2020  $Lines[] = 'ALTER TABLE `'.$Group['TablePrefix'].'` ADD  `CompleteParts` INT NOT NULL AFTER  `Complete`;'; 
    2121  $Lines[] = 'ALTER TABLE `'.$Group['TablePrefix'].'` ADD  `ModifyTime` DATETIME NOT NULL;'; 
    22   $Lines[] = 'ALTER TABLE `'.$Group['TablePrefix'].'` INDEX (  `ModifyTime` );'; 
     22  $Lines[] = 'ALTER TABLE `'.$Group['TablePrefix'].'` ADD INDEX (  `ModifyTime` );'; 
    2323  $Lines[] = 'UPDATE `'.$Group['TablePrefix'].'` SET `ModifyTime` = NOW();'; 
    2424  $Lines[] = 'UPDATE `'.$Group['TablePrefix'].'` SET `CompleteParts` = '.((1 << $Group['ItemsCount']) - 1).' WHERE `Complete`=1;'; 

  • trunk/sql/updates/426.sql

    r426 r429  
    133133ALTER TABLE `TextQuest` ADD  `CompleteParts` INT NOT NULL AFTER  `Complete`;
    134134ALTER TABLE `TextQuest` ADD  `ModifyTime` DATETIME NOT NULL;
    135 ALTER TABLE `TextQuest` INDEX (  `ModifyTime` );
     135ALTER TABLE `TextQuest` ADD INDEX (  `ModifyTime` );
    136136UPDATE `TextQuest` SET `ModifyTime` = NOW();
    137137UPDATE `TextQuest` SET `CompleteParts` = 1023 WHERE `Complete`=1;
    138138ALTER TABLE `TextPage` ADD  `CompleteParts` INT NOT NULL AFTER  `Complete`;
    139139ALTER TABLE `TextPage` ADD  `ModifyTime` DATETIME NOT NULL;
    140 ALTER TABLE `TextPage` INDEX (  `ModifyTime` );
     140ALTER TABLE `TextPage` ADD INDEX (  `ModifyTime` );
    141141UPDATE `TextPage` SET `ModifyTime` = NOW();
    142142UPDATE `TextPage` SET `CompleteParts` = 1 WHERE `Complete`=1;
    143143ALTER TABLE `TextNPC` ADD  `CompleteParts` INT NOT NULL AFTER  `Complete`;
    144144ALTER TABLE `TextNPC` ADD  `ModifyTime` DATETIME NOT NULL;
    145 ALTER TABLE `TextNPC` INDEX (  `ModifyTime` );
     145ALTER TABLE `TextNPC` ADD INDEX (  `ModifyTime` );
    146146UPDATE `TextNPC` SET `ModifyTime` = NOW();
    147147UPDATE `TextNPC` SET `CompleteParts` = 65535 WHERE `Complete`=1;
    148148ALTER TABLE `TextItem` ADD  `CompleteParts` INT NOT NULL AFTER  `Complete`;
    149149ALTER TABLE `TextItem` ADD  `ModifyTime` DATETIME NOT NULL;
    150 ALTER TABLE `TextItem` INDEX (  `ModifyTime` );
     150ALTER TABLE `TextItem` ADD INDEX (  `ModifyTime` );
    151151UPDATE `TextItem` SET `ModifyTime` = NOW();
    152152UPDATE `TextItem` SET `CompleteParts` = 3 WHERE `Complete`=1;
    153153ALTER TABLE `TextGameObject` ADD  `CompleteParts` INT NOT NULL AFTER  `Complete`;
    154154ALTER TABLE `TextGameObject` ADD  `ModifyTime` DATETIME NOT NULL;
    155 ALTER TABLE `TextGameObject` INDEX (  `ModifyTime` );
     155ALTER TABLE `TextGameObject` ADD INDEX (  `ModifyTime` );
    156156UPDATE `TextGameObject` SET `ModifyTime` = NOW();
    157157UPDATE `TextGameObject` SET `CompleteParts` = 3 WHERE `Complete`=1;
    158158ALTER TABLE `TextCreature` ADD  `CompleteParts` INT NOT NULL AFTER  `Complete`;
    159159ALTER TABLE `TextCreature` ADD  `ModifyTime` DATETIME NOT NULL;
    160 ALTER TABLE `TextCreature` INDEX (  `ModifyTime` );
     160ALTER TABLE `TextCreature` ADD INDEX (  `ModifyTime` );
    161161UPDATE `TextCreature` SET `ModifyTime` = NOW();
    162162UPDATE `TextCreature` SET `CompleteParts` = 3 WHERE `Complete`=1;
    163163ALTER TABLE `TextMangosString` ADD  `CompleteParts` INT NOT NULL AFTER  `Complete`;
    164164ALTER TABLE `TextMangosString` ADD  `ModifyTime` DATETIME NOT NULL;
    165 ALTER TABLE `TextMangosString` INDEX (  `ModifyTime` );
     165ALTER TABLE `TextMangosString` ADD INDEX (  `ModifyTime` );
    166166UPDATE `TextMangosString` SET `ModifyTime` = NOW();
    167167UPDATE `TextMangosString` SET `CompleteParts` = 1 WHERE `Complete`=1;
    168168ALTER TABLE `TextMangosCommand` ADD  `CompleteParts` INT NOT NULL AFTER  `Complete`;
    169169ALTER TABLE `TextMangosCommand` ADD  `ModifyTime` DATETIME NOT NULL;
    170 ALTER TABLE `TextMangosCommand` INDEX (  `ModifyTime` );
     170ALTER TABLE `TextMangosCommand` ADD INDEX (  `ModifyTime` );
    171171UPDATE `TextMangosCommand` SET `ModifyTime` = NOW();
    172172UPDATE `TextMangosCommand` SET `CompleteParts` = 3 WHERE `Complete`=1;
    173173ALTER TABLE `TextSD2Script` ADD  `CompleteParts` INT NOT NULL AFTER  `Complete`;
    174174ALTER TABLE `TextSD2Script` ADD  `ModifyTime` DATETIME NOT NULL;
    175 ALTER TABLE `TextSD2Script` INDEX (  `ModifyTime` );
     175ALTER TABLE `TextSD2Script` ADD INDEX (  `ModifyTime` );
    176176UPDATE `TextSD2Script` SET `ModifyTime` = NOW();
    177177UPDATE `TextSD2Script` SET `CompleteParts` = 3 WHERE `Complete`=1;
    178178ALTER TABLE `TextSD2EventAI` ADD  `CompleteParts` INT NOT NULL AFTER  `Complete`;
    179179ALTER TABLE `TextSD2EventAI` ADD  `ModifyTime` DATETIME NOT NULL;
    180 ALTER TABLE `TextSD2EventAI` INDEX (  `ModifyTime` );
     180ALTER TABLE `TextSD2EventAI` ADD INDEX (  `ModifyTime` );
    181181UPDATE `TextSD2EventAI` SET `ModifyTime` = NOW();
    182182UPDATE `TextSD2EventAI` SET `CompleteParts` = 3 WHERE `Complete`=1;
    183183ALTER TABLE `TextGameTip` ADD  `CompleteParts` INT NOT NULL AFTER  `Complete`;
    184184ALTER TABLE `TextGameTip` ADD  `ModifyTime` DATETIME NOT NULL;
    185 ALTER TABLE `TextGameTip` INDEX (  `ModifyTime` );
     185ALTER TABLE `TextGameTip` ADD INDEX (  `ModifyTime` );
    186186UPDATE `TextGameTip` SET `ModifyTime` = NOW();
    187187UPDATE `TextGameTip` SET `CompleteParts` = 1 WHERE `Complete`=1;
    188188ALTER TABLE `TextSpell` ADD  `CompleteParts` INT NOT NULL AFTER  `Complete`;
    189189ALTER TABLE `TextSpell` ADD  `ModifyTime` DATETIME NOT NULL;
    190 ALTER TABLE `TextSpell` INDEX (  `ModifyTime` );
     190ALTER TABLE `TextSpell` ADD INDEX (  `ModifyTime` );
    191191UPDATE `TextSpell` SET `ModifyTime` = NOW();
    192192UPDATE `TextSpell` SET `CompleteParts` = 15 WHERE `Complete`=1;
    193193ALTER TABLE `TextGlobalString` ADD  `CompleteParts` INT NOT NULL AFTER  `Complete`;
    194194ALTER TABLE `TextGlobalString` ADD  `ModifyTime` DATETIME NOT NULL;
    195 ALTER TABLE `TextGlobalString` INDEX (  `ModifyTime` );
     195ALTER TABLE `TextGlobalString` ADD INDEX (  `ModifyTime` );
    196196UPDATE `TextGlobalString` SET `ModifyTime` = NOW();
    197197UPDATE `TextGlobalString` SET `CompleteParts` = 7 WHERE `Complete`=1;
    198198ALTER TABLE `TextGlueString` ADD  `CompleteParts` INT NOT NULL AFTER  `Complete`;
    199199ALTER TABLE `TextGlueString` ADD  `ModifyTime` DATETIME NOT NULL;
    200 ALTER TABLE `TextGlueString` INDEX (  `ModifyTime` );
     200ALTER TABLE `TextGlueString` ADD INDEX (  `ModifyTime` );
    201201UPDATE `TextGlueString` SET `ModifyTime` = NOW();
    202202UPDATE `TextGlueString` SET `CompleteParts` = 7 WHERE `Complete`=1;
    203203ALTER TABLE `TextNPCOption` ADD  `CompleteParts` INT NOT NULL AFTER  `Complete`;
    204204ALTER TABLE `TextNPCOption` ADD  `ModifyTime` DATETIME NOT NULL;
    205 ALTER TABLE `TextNPCOption` INDEX (  `ModifyTime` );
     205ALTER TABLE `TextNPCOption` ADD INDEX (  `ModifyTime` );
    206206UPDATE `TextNPCOption` SET `ModifyTime` = NOW();
    207207UPDATE `TextNPCOption` SET `CompleteParts` = 3 WHERE `Complete`=1;
    208208ALTER TABLE `TextTransport` ADD  `CompleteParts` INT NOT NULL AFTER  `Complete`;
    209209ALTER TABLE `TextTransport` ADD  `ModifyTime` DATETIME NOT NULL;
    210 ALTER TABLE `TextTransport` INDEX (  `ModifyTime` );
     210ALTER TABLE `TextTransport` ADD INDEX (  `ModifyTime` );
    211211UPDATE `TextTransport` SET `ModifyTime` = NOW();
    212212UPDATE `TextTransport` SET `CompleteParts` = 1 WHERE `Complete`=1;
    213213ALTER TABLE `TextAreaTriggerTavern` ADD  `CompleteParts` INT NOT NULL AFTER  `Complete`;
    214214ALTER TABLE `TextAreaTriggerTavern` ADD  `ModifyTime` DATETIME NOT NULL;
    215 ALTER TABLE `TextAreaTriggerTavern` INDEX (  `ModifyTime` );
     215ALTER TABLE `TextAreaTriggerTavern` ADD INDEX (  `ModifyTime` );
    216216UPDATE `TextAreaTriggerTavern` SET `ModifyTime` = NOW();
    217217UPDATE `TextAreaTriggerTavern` SET `CompleteParts` = 1 WHERE `Complete`=1;
    218218ALTER TABLE `TextAreaTriggerTeleport` ADD  `CompleteParts` INT NOT NULL AFTER  `Complete`;
    219219ALTER TABLE `TextAreaTriggerTeleport` ADD  `ModifyTime` DATETIME NOT NULL;
    220 ALTER TABLE `TextAreaTriggerTeleport` INDEX (  `ModifyTime` );
     220ALTER TABLE `TextAreaTriggerTeleport` ADD INDEX (  `ModifyTime` );
    221221UPDATE `TextAreaTriggerTeleport` SET `ModifyTime` = NOW();
    222222UPDATE `TextAreaTriggerTeleport` SET `CompleteParts` = 1 WHERE `Complete`=1;
    223223ALTER TABLE `TextAchievement` ADD  `CompleteParts` INT NOT NULL AFTER  `Complete`;
    224224ALTER TABLE `TextAchievement` ADD  `ModifyTime` DATETIME NOT NULL;
    225 ALTER TABLE `TextAchievement` INDEX (  `ModifyTime` );
     225ALTER TABLE `TextAchievement` ADD INDEX (  `ModifyTime` );
    226226UPDATE `TextAchievement` SET `ModifyTime` = NOW();
    227227UPDATE `TextAchievement` SET `CompleteParts` = 7 WHERE `Complete`=1;
    228228ALTER TABLE `TextAchievementCategory` ADD  `CompleteParts` INT NOT NULL AFTER  `Complete`;
    229229ALTER TABLE `TextAchievementCategory` ADD  `ModifyTime` DATETIME NOT NULL;
    230 ALTER TABLE `TextAchievementCategory` INDEX (  `ModifyTime` );
     230ALTER TABLE `TextAchievementCategory` ADD INDEX (  `ModifyTime` );
    231231UPDATE `TextAchievementCategory` SET `ModifyTime` = NOW();
    232232UPDATE `TextAchievementCategory` SET `CompleteParts` = 1 WHERE `Complete`=1;
    233233ALTER TABLE `TextAchievementCriteria` ADD  `CompleteParts` INT NOT NULL AFTER  `Complete`;
    234234ALTER TABLE `TextAchievementCriteria` ADD  `ModifyTime` DATETIME NOT NULL;
    235 ALTER TABLE `TextAchievementCriteria` INDEX (  `ModifyTime` );
     235ALTER TABLE `TextAchievementCriteria` ADD INDEX (  `ModifyTime` );
    236236UPDATE `TextAchievementCriteria` SET `ModifyTime` = NOW();
    237237UPDATE `TextAchievementCriteria` SET `CompleteParts` = 1 WHERE `Complete`=1;
    238238ALTER TABLE `TextGlueLocalization` ADD  `CompleteParts` INT NOT NULL AFTER  `Complete`;
    239239ALTER TABLE `TextGlueLocalization` ADD  `ModifyTime` DATETIME NOT NULL;
    240 ALTER TABLE `TextGlueLocalization` INDEX (  `ModifyTime` );
     240ALTER TABLE `TextGlueLocalization` ADD INDEX (  `ModifyTime` );
    241241UPDATE `TextGlueLocalization` SET `ModifyTime` = NOW();
    242242UPDATE `TextGlueLocalization` SET `CompleteParts` = 7 WHERE `Complete`=1;
     243
    243244CREATE TABLE IF NOT EXISTS `DbVersion` (
    244245  `Id` int(11) NOT NULL AUTO_INCREMENT,
Note: See TracChangeset for help on using the changeset viewer.