Changeset 73 for trunk/sql/structure.sql


Ignore:
Timestamp:
Feb 7, 2009, 12:58:56 AM (16 years ago)
Author:
george
Message:
  • Opraveno: Generování kódu $g pro rody v addonu, nadbytečné mezery u generované anglické části addonu a správný překlad odřádkování na symboly \r\n.
File:
1 edited

Legend:

Unmodified
Added
Removed

  • trunk/sql/structure.sql

    r71 r73  
    2727  `File` int(11) NOT NULL default '0',
    2828  `Language` int(11) NOT NULL default '0',
    29   `Vote` float NOT NULL,
    30   `CountVote` int(11) NOT NULL,
    31   `User` int(11) NOT NULL,
    32   `Complete` int(11) NOT NULL,
    33   `Take` int(11) NOT NULL,
    34   `admin_check` int(11) NOT NULL,
     29  `User` int(11) NOT NULL,
     30  `Complete` int(11) NOT NULL,
     31  `Take` int(11) NOT NULL,
    3532  PRIMARY KEY  (`ID`),
    3633  KEY `entry` (`entry`),
    … …  
    9491  `castbarcaption` varchar(255) NOT NULL,
    9592  `Language` int(11) NOT NULL default '0',
    96   `Vote` float NOT NULL,
    97   `CountVote` int(11) NOT NULL,
    98   `User` int(11) NOT NULL,
    99   `Complete` int(11) NOT NULL,
    100   `Take` int(11) NOT NULL,
    101   `admin_check` int(11) NOT NULL default '0',
     93  `User` int(11) NOT NULL,
     94  `Complete` int(11) NOT NULL,
     95  `Take` int(11) NOT NULL,
    10296  PRIMARY KEY  (`ID`),
    10397  KEY `entry` (`entry`),
    … …  
    119113  `Text` text NOT NULL,
    120114  `Language` int(11) NOT NULL default '0',
    121   `Vote` float NOT NULL,
    122   `CountVote` int(11) NOT NULL,
    123   `User` int(11) NOT NULL,
    124   `Complete` int(11) NOT NULL,
    125   `Take` int(11) NOT NULL,
    126   `admin_check` int(11) NOT NULL default '0',
     115  `User` int(11) NOT NULL,
     116  `Complete` int(11) NOT NULL,
     117  `Take` int(11) NOT NULL,
    127118  PRIMARY KEY  (`ID`),
    128119  KEY `entry` (`entry`),
    … …  
    180171  `Description` varchar(255) NOT NULL,
    181172  `Language` int(11) NOT NULL default '0',
    182   `Vote` float NOT NULL,
    183   `CountVote` int(11) NOT NULL,
    184   `User` int(11) NOT NULL,
    185   `Complete` int(11) NOT NULL,
    186   `Take` int(11) NOT NULL,
    187   `admin_check` int(11) NOT NULL default '0',
     173  `User` int(11) NOT NULL,
     174  `Complete` int(11) NOT NULL,
     175  `Take` int(11) NOT NULL,
    188176  PRIMARY KEY  (`ID`),
    189177  KEY `entry` (`entry`),
    … …  
    209197  PRIMARY KEY  (`ID`),
    210198  KEY `user` (`user`)
    211 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12925 ;
     199) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12926 ;
    212200
    213201-- --------------------------------------------------------
    … …  
    222210  `help` varchar(255) NOT NULL,
    223211  `Language` int(11) NOT NULL default '0',
    224   `Vote` float NOT NULL,
    225   `CountVote` int(11) NOT NULL,
    226   `User` int(11) NOT NULL,
    227   `Complete` int(11) NOT NULL,
    228   `Take` int(11) NOT NULL,
    229   `admin_check` int(11) NOT NULL default '0',
     212  `User` int(11) NOT NULL,
     213  `Complete` int(11) NOT NULL,
     214  `Take` int(11) NOT NULL,
    230215  PRIMARY KEY  (`ID`),
    231216  KEY `entry` (`entry`),
    … …  
    247232  `content_default` varchar(255) NOT NULL,
    248233  `Language` int(11) NOT NULL default '0',
    249   `Vote` float NOT NULL,
    250   `CountVote` int(11) NOT NULL,
    251   `User` int(11) NOT NULL,
    252   `Complete` int(11) NOT NULL,
    253   `Take` int(11) NOT NULL,
    254   `admin_check` int(11) NOT NULL default '0',
     234  `User` int(11) NOT NULL,
     235  `Complete` int(11) NOT NULL,
     236  `Take` int(11) NOT NULL,
    255237  PRIMARY KEY  (`ID`),
    256238  KEY `entry` (`entry`),
    … …  
    301283  `Text7_1` text character set latin2 collate latin2_czech_cs,
    302284  `Language` int(11) NOT NULL default '0',
    303   `Vote` float NOT NULL,
    304   `CountVote` int(11) NOT NULL,
    305   `User` int(11) NOT NULL,
    306   `Complete` int(11) NOT NULL,
    307   `Take` int(11) NOT NULL,
    308   `admin_check` int(11) NOT NULL default '0',
     285  `User` int(11) NOT NULL,
     286  `Complete` int(11) NOT NULL,
     287  `Take` int(11) NOT NULL,
    309288  PRIMARY KEY  (`ID`),
    310289  KEY `entry` (`entry`),
    … …  
    326305  `Text` text character set latin2 collate latin2_czech_cs,
    327306  `Language` int(11) NOT NULL,
    328   `Vote` float NOT NULL,
    329   `CountVote` int(11) NOT NULL,
    330   `User` int(11) NOT NULL,
    331   `Complete` int(11) NOT NULL,
    332   `Take` int(11) NOT NULL,
    333   `admin_check` int(11) NOT NULL default '0',
     307  `User` int(11) NOT NULL,
     308  `Complete` int(11) NOT NULL,
     309  `Take` int(11) NOT NULL,
    334310  PRIMARY KEY  (`ID`),
    335311  KEY `entry` (`entry`),
    … …  
    360336  `ObjectiveText4` text character set latin2 collate latin2_czech_cs NOT NULL,
    361337  `Language` int(11) NOT NULL default '1',
    362   `Vote` float NOT NULL default '0',
    363   `CountVote` int(11) NOT NULL,
    364338  `User` int(11) NOT NULL,
    365339  `Complete` int(11) NOT NULL default '1',
    366340  `Take` int(11) NOT NULL,
    367   `admin_check` int(11) NOT NULL default '0',
    368341  PRIMARY KEY  (`ID`),
    369342  KEY `entry` (`entry`),
    … …  
    385358  `comment` text NOT NULL,
    386359  `Language` int(11) NOT NULL default '0',
    387   `Vote` float NOT NULL,
    388   `CountVote` int(11) NOT NULL,
    389   `User` int(11) NOT NULL,
    390   `Complete` int(11) NOT NULL,
    391   `Take` int(11) NOT NULL,
    392   `admin_check` int(11) NOT NULL default '0',
     360  `User` int(11) NOT NULL,
     361  `Complete` int(11) NOT NULL,
     362  `Take` int(11) NOT NULL,
    393363  PRIMARY KEY  (`ID`),
    394364  KEY `entry` (`entry`),
    … …  
    411381  `comment` text NOT NULL,
    412382  `Language` int(11) NOT NULL default '0',
    413   `Vote` float NOT NULL,
    414   `CountVote` int(11) NOT NULL,
    415   `User` int(11) NOT NULL,
    416   `Complete` int(11) NOT NULL,
    417   `Take` int(11) NOT NULL,
    418   `admin_check` int(11) NOT NULL default '0',
     383  `User` int(11) NOT NULL,
     384  `Complete` int(11) NOT NULL,
     385  `Take` int(11) NOT NULL,
    419386  PRIMARY KEY  (`ID`),
    420387  KEY `entry` (`entry`),
    … …  
    454421  `Description` text NOT NULL,
    455422  `Language` int(11) NOT NULL default '0',
    456   `Vote` float NOT NULL,
    457   `CountVote` int(11) NOT NULL,
    458   `User` int(11) NOT NULL,
    459   `Complete` int(11) NOT NULL,
    460   `Take` int(11) NOT NULL,
    461   `admin_check` int(11) NOT NULL default '0',
     423  `User` int(11) NOT NULL,
     424  `Complete` int(11) NOT NULL,
     425  `Take` int(11) NOT NULL,
    462426  PRIMARY KEY  (`ID`),
    463427  KEY `entry` (`entry`),
    … …  
    467431  KEY `Complete` (`Complete`)
    468432) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=42088 ;
    469 
    470 -- --------------------------------------------------------
    471 
    472 --
    473 -- Struktura tabulky `tag`
    474 --
    475 
    476 CREATE TABLE IF NOT EXISTS `tag` (
    477   `ID` int(11) NOT NULL auto_increment,
    478   `type_translation` int(11) NOT NULL,
    479   `ID_translation` int(11) NOT NULL,
    480   `ID_user` int(11) NOT NULL,
    481   `tag` int(11) NOT NULL,
    482   PRIMARY KEY  (`ID`)
    483 ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=335 ;
    484433
    485434-- --------------------------------------------------------
Note: See TracChangeset for help on using the changeset viewer.