Home›Help›Trac

Ignore:
Timestamp:
04/06/09 03:52:46 (3 years ago)
Author:
Andrey Prikaznov
Message:
 
File:
1 edited

Legend:

Unmodified
Added
Removed

  • trunk/install/sql/v70.sql

    r9968 r9969  
    66 
    77SET NAMES 'utf8'; 
    8 DROP TABLE IF EXISTS `sys_account_custom_stat_elements`, `sys_admin_ban_list`, `sys_admin_links`, `sys_admin_menu`, `sys_admin_menu_categ`, `Admins`, `aff`, `sys_aff_banners`, `sys_aff_members`, `alerts`, `sys_albums`, `sys_albums_objects`,`sys_banners`, `sys_banners_clicks`, `sys_banners_shows`, `sys_block_list`, `sys_objects_browse`, `Categories`, `sys_objects_categories`, `sys_objects_cmts`, `sys_cmts_profile`, `sys_cmts_track`, `sys_color_base`, `sys_countries`, `sys_email_templates`, `sys_menu_member`, `sys_friend_list`, `GlParams`, `sys_options_cats`, `Groups`, `GroupsCateg`, `GroupsGallery`, `GroupsMembers`, `groups_rating`, `groups_voting_track`, `grp_forum`, `grp_forum_cat`, `grp_forum_flag`, `grp_forum_post`, `grp_forum_report`, `grp_forum_topic`, `grp_forum_user`, `grp_forum_user_activity`, `grp_forum_user_stat`, `grp_forum_vote`, `sys_fave_list`, `IPList`, `IPMembersVisits`, `Links`, `LocalizationCategories`, `LocalizationKeys`, `LocalizationLanguages`, `LocalizationStringParams`, `LocalizationStrings`, `MemActions`, `MemActionsTrack`, `members_as_aff`, `MemLevelActions`, `MemLevelPrices`, `MemLevels`, `Messages`, `moderators`, `Modules`, `News`, `NotifyEmails`, `NotifyMsgs`, `NotifyQueue`, `PageCompose`, `PageComposePages`, `PaymentParameters`, `PaymentProviders`, `PaymentSubscriptions`, `PQStatistics`, `PreValues`, `ProfileFields`, `ProfileMemLevels`, `Profiles`, `profile_views_track`, `ProfilesMatch`, `ProfilesSettings`, `ProfilesTrack`, `profile_rating`, `profile_voting_track`, `RayBoardCurrentUsers`, `RayBoardBoards`, `RayBoardUsers`, `RayChatCurrentUsers`, `RayChatMessages`, `RayChatProfiles`, `RayChatRooms`, `RayChatRoomsUsers`, `RayGlobalTrackUsers`, `RayImContacts`, `RayImMessages`, `RayImPendings`, `RayImProfiles`, `RayMp3Files`, `RayShoutboxMessages`, `RayVideoFiles`, `RayVideo_commentsFiles`, `SearchObjects`, `sharedSites`, `SiteStat`, `smiles`, `sys_alerts`, `sys_alerts_handlers`, `sys_injections`, `sys_injections_admin`, `sys_modules`, `sys_modules_file_tracks`, `sys_permalinks`, `Stories`, `Tags`, `TagObjects`, `TopMenu`, `Transactions`, `UsersActions`, `Greetings`, `Votes`, `ZIPCodes`, `VoteObjects`, `sys_objects_views`, `sys_box_download`; 
     8DROP TABLE IF EXISTS `sys_account_custom_stat_elements`, `sys_admin_ban_list`, `sys_admin_links`, `sys_admin_menu`, `sys_admin_menu_categ`, `Admins`, `aff`, `sys_aff_banners`, `sys_aff_members`, `alerts`, `sys_albums`, `sys_albums_objects`,`sys_banners`, `sys_banners_clicks`, `sys_banners_shows`, `sys_block_list`, `sys_objects_browse`, `Categories`, `sys_objects_categories`, `sys_objects_cmts`, `sys_cmts_profile`, `sys_cmts_track`, `sys_color_base`, `sys_countries`, `sys_email_templates`, `sys_menu_member`, `sys_friend_list`, `GlParams`, `sys_options_cats`, `Groups`, `GroupsCateg`, `GroupsGallery`, `GroupsMembers`, `groups_rating`, `groups_voting_track`, `grp_forum`, `grp_forum_cat`, `grp_forum_flag`, `grp_forum_post`, `grp_forum_report`, `grp_forum_topic`, `grp_forum_user`, `grp_forum_user_activity`, `grp_forum_user_stat`, `grp_forum_vote`, `sys_fave_list`, `IPList`, `IPMembersVisits`, `Links`, `LocalizationCategories`, `LocalizationKeys`, `LocalizationLanguages`, `LocalizationStringParams`, `LocalizationStrings`, `sys_acl_actions`, `sys_acl_actions_track`, `members_as_aff`, `sys_acl_matrix`, `sys_acl_level_prices`, `sys_acl_levels`, `Messages`, `moderators`, `Modules`, `News`, `sys_subscriptions`, `sys_mass_messages`, `sys_mail_queue`, `PageCompose`, `PageComposePages`, `PaymentParameters`, `PaymentProviders`, `PaymentSubscriptions`, `PQStatistics`, `PreValues`, `ProfileFields`, `ProfileMemLevels`, `Profiles`, `profile_views_track`, `ProfilesMatch`, `ProfilesSettings`, `ProfilesTrack`, `profile_rating`, `profile_voting_track`, `RayBoardCurrentUsers`, `RayBoardBoards`, `RayBoardUsers`, `RayChatCurrentUsers`, `RayChatMessages`, `RayChatProfiles`, `RayChatRooms`, `RayChatRoomsUsers`, `RayGlobalTrackUsers`, `RayImContacts`, `RayImMessages`, `RayImPendings`, `RayImProfiles`, `RayMp3Files`, `RayShoutboxMessages`, `RayVideoFiles`, `RayVideo_commentsFiles`, `SearchObjects`, `sharedSites`, `SiteStat`, `smiles`, `sys_alerts`, `sys_alerts_handlers`, `sys_injections`, `sys_injections_admin`, `sys_modules`, `sys_modules_file_tracks`, `sys_permalinks`, `Stories`, `Tags`, `TagObjects`, `TopMenu`, `Transactions`, `UsersActions`, `Greetings`, `Votes`, `ZIPCodes`, `VoteObjects`, `sys_objects_views`, `sys_box_download`; 
    99ALTER DATABASE DEFAULT CHARACTER SET 'utf8' COLLATE 'utf8_unicode_ci'; 
    1010 
    … …  
    18291829-- -------------------------------------------------------- 
    18301830-- 
    1831 -- Table structure for table `MemActions` 
    1832 -- 
    1833  
    1834 CREATE TABLE `MemActions` ( 
     1831-- Table structure for table `sys_acl_actions` 
     1832-- 
     1833 
     1834CREATE TABLE `sys_acl_actions` ( 
    18351835  `ID` smallint(5) unsigned NOT NULL auto_increment, 
    18361836  `Name` varchar(255) NOT NULL default '', 
    … …  
    18401840 
    18411841-- 
    1842 -- Dumping data for table `MemActions` 
    1843 -- 
    1844  
    1845 INSERT INTO `MemActions` VALUES(1, 'send greetings', NULL); 
    1846 INSERT INTO `MemActions` VALUES(4, 'view profiles', NULL); 
    1847 INSERT INTO `MemActions` VALUES(5, 'use forum', NULL); 
    1848 INSERT INTO `MemActions` VALUES(6, 'make search', 'Max. number of profiles shown in search result (0 = unlimited)'); 
    1849 INSERT INTO `MemActions` VALUES(7, 'vote', NULL); 
    1850 INSERT INTO `MemActions` VALUES(8, 'send messages', NULL); 
    1851 INSERT INTO `MemActions` VALUES(9, 'view photos', NULL); 
    1852 INSERT INTO `MemActions` VALUES(15, 'get other members'' emails', NULL); 
    1853 INSERT INTO `MemActions` VALUES(16, 'use gallery', NULL); 
    1854 INSERT INTO `MemActions` VALUES(17, 'view other members'' galleries', NULL); 
    1855 INSERT INTO `MemActions` VALUES(18, 'use Ray mp3 player', NULL); 
    1856 INSERT INTO `MemActions` VALUES(21, 'use Ray video player', NULL); 
    1857 INSERT INTO `MemActions` VALUES(24, 'rate photos', NULL); 
    1858 INSERT INTO `MemActions` VALUES(25, 'use Orca public forums', NULL); 
    1859 INSERT INTO `MemActions` VALUES(26, 'use Orca private forums', NULL); 
    1860 INSERT INTO `MemActions` VALUES(27, 'upload Music (Music Gallery)', NULL); 
    1861 INSERT INTO `MemActions` VALUES(28, 'upload Photos (Photo Gallery)', NULL); 
    1862 INSERT INTO `MemActions` VALUES(29, 'upload Video (Video Gallery)', NULL); 
    1863 INSERT INTO `MemActions` VALUES(30, 'play Music (Music Gallery)', NULL); 
    1864 INSERT INTO `MemActions` VALUES(31, 'view Photos (Photo Gallery)', NULL); 
    1865 INSERT INTO `MemActions` VALUES(32, 'play Video (Video Gallery)', NULL); 
    1866 INSERT INTO `MemActions` VALUES(33, 'comments post', NULL); 
    1867 INSERT INTO `MemActions` VALUES(34, 'comments vote', NULL); 
    1868 INSERT INTO `MemActions` VALUES(35, 'comments edit own', NULL); 
    1869 INSERT INTO `MemActions` VALUES(36, 'comments remove own', NULL); 
    1870  
    1871 -- -------------------------------------------------------- 
    1872  
    1873 -- 
    1874 -- Table structure for table `MemActionsTrack` 
    1875 -- 
    1876  
    1877 CREATE TABLE `MemActionsTrack` ( 
     1842-- Dumping data for table `sys_acl_actions` 
     1843-- 
     1844 
     1845INSERT INTO `sys_acl_actions` VALUES(1, 'send greetings', NULL); 
     1846INSERT INTO `sys_acl_actions` VALUES(4, 'view profiles', NULL); 
     1847INSERT INTO `sys_acl_actions` VALUES(5, 'use forum', NULL); 
     1848INSERT INTO `sys_acl_actions` VALUES(6, 'make search', 'Max. number of profiles shown in search result (0 = unlimited)'); 
     1849INSERT INTO `sys_acl_actions` VALUES(7, 'vote', NULL); 
     1850INSERT INTO `sys_acl_actions` VALUES(8, 'send messages', NULL); 
     1851INSERT INTO `sys_acl_actions` VALUES(9, 'view photos', NULL); 
     1852INSERT INTO `sys_acl_actions` VALUES(15, 'get other members'' emails', NULL); 
     1853INSERT INTO `sys_acl_actions` VALUES(16, 'use gallery', NULL); 
     1854INSERT INTO `sys_acl_actions` VALUES(17, 'view other members'' galleries', NULL); 
     1855INSERT INTO `sys_acl_actions` VALUES(18, 'use Ray mp3 player', NULL); 
     1856INSERT INTO `sys_acl_actions` VALUES(21, 'use Ray video player', NULL); 
     1857INSERT INTO `sys_acl_actions` VALUES(24, 'rate photos', NULL); 
     1858INSERT INTO `sys_acl_actions` VALUES(25, 'use Orca public forums', NULL); 
     1859INSERT INTO `sys_acl_actions` VALUES(26, 'use Orca private forums', NULL); 
     1860INSERT INTO `sys_acl_actions` VALUES(27, 'upload Music (Music Gallery)', NULL); 
     1861INSERT INTO `sys_acl_actions` VALUES(28, 'upload Photos (Photo Gallery)', NULL); 
     1862INSERT INTO `sys_acl_actions` VALUES(29, 'upload Video (Video Gallery)', NULL); 
     1863INSERT INTO `sys_acl_actions` VALUES(30, 'play Music (Music Gallery)', NULL); 
     1864INSERT INTO `sys_acl_actions` VALUES(31, 'view Photos (Photo Gallery)', NULL); 
     1865INSERT INTO `sys_acl_actions` VALUES(32, 'play Video (Video Gallery)', NULL); 
     1866INSERT INTO `sys_acl_actions` VALUES(33, 'comments post', NULL); 
     1867INSERT INTO `sys_acl_actions` VALUES(34, 'comments vote', NULL); 
     1868INSERT INTO `sys_acl_actions` VALUES(35, 'comments edit own', NULL); 
     1869INSERT INTO `sys_acl_actions` VALUES(36, 'comments remove own', NULL); 
     1870 
     1871-- -------------------------------------------------------- 
     1872 
     1873-- 
     1874-- Table structure for table `sys_acl_actions_track` 
     1875-- 
     1876 
     1877CREATE TABLE `sys_acl_actions_track` ( 
    18781878  `IDAction` smallint(5) unsigned NOT NULL default '0', 
    18791879  `IDMember` int(10) unsigned NOT NULL default '0', 
    … …  
    18841884 
    18851885-- 
    1886 -- Dumping data for table `MemActionsTrack` 
     1886-- Dumping data for table `sys_acl_actions_track` 
    18871887-- 
    18881888 
    … …  
    19101910 
    19111911-- 
    1912 -- Table structure for table `MemLevelActions` 
    1913 -- 
    1914  
    1915 CREATE TABLE `MemLevelActions` ( 
     1912-- Table structure for table `sys_acl_matrix` 
     1913-- 
     1914 
     1915CREATE TABLE `sys_acl_matrix` ( 
    19161916  `IDLevel` smallint(5) unsigned NOT NULL default '0', 
    19171917  `IDAction` smallint(5) unsigned NOT NULL default '0', 
    … …  
    19251925 
    19261926-- 
    1927 -- Dumping data for table `MemLevelActions` 
    1928 -- 
    1929  
    1930 INSERT INTO `MemLevelActions` VALUES(1, 6, NULL, NULL, NULL, NULL, '10'); 
    1931 INSERT INTO `MemLevelActions` VALUES(1, 7, NULL, NULL, NULL, NULL, NULL); 
    1932 INSERT INTO `MemLevelActions` VALUES(1, 14, NULL, NULL, NULL, NULL, NULL); 
    1933 INSERT INTO `MemLevelActions` VALUES(2, 1, 4, 24, NULL, NULL, NULL); 
    1934 INSERT INTO `MemLevelActions` VALUES(2, 4, 2, 24, NULL, NULL, NULL); 
    1935 INSERT INTO `MemLevelActions` VALUES(2, 6, 5, 24, NULL, NULL, '0'); 
    1936 INSERT INTO `MemLevelActions` VALUES(2, 7, 15, 24, NULL, NULL, NULL); 
    1937 INSERT INTO `MemLevelActions` VALUES(2, 8, 2, 24, NULL, NULL, NULL); 
    1938 INSERT INTO `MemLevelActions` VALUES(3, 1, NULL, NULL, NULL, NULL, NULL); 
    1939 INSERT INTO `MemLevelActions` VALUES(3, 2, NULL, NULL, NULL, NULL, NULL); 
    1940 INSERT INTO `MemLevelActions` VALUES(3, 3, NULL, NULL, NULL, NULL, NULL); 
    1941 INSERT INTO `MemLevelActions` VALUES(3, 4, NULL, NULL, NULL, NULL, NULL); 
    1942 INSERT INTO `MemLevelActions` VALUES(3, 5, NULL, NULL, NULL, NULL, NULL); 
    1943 INSERT INTO `MemLevelActions` VALUES(3, 6, NULL, NULL, NULL, NULL, NULL); 
    1944 INSERT INTO `MemLevelActions` VALUES(3, 7, NULL, NULL, NULL, NULL, NULL); 
    1945 INSERT INTO `MemLevelActions` VALUES(3, 8, NULL, NULL, NULL, NULL, NULL); 
    1946 INSERT INTO `MemLevelActions` VALUES(3, 9, NULL, NULL, NULL, NULL, NULL); 
    1947 INSERT INTO `MemLevelActions` VALUES(3, 10, NULL, NULL, NULL, NULL, NULL); 
    1948 INSERT INTO `MemLevelActions` VALUES(3, 11, NULL, NULL, NULL, NULL, NULL); 
    1949 INSERT INTO `MemLevelActions` VALUES(3, 12, NULL, NULL, NULL, NULL, NULL); 
    1950 INSERT INTO `MemLevelActions` VALUES(3, 13, NULL, NULL, NULL, NULL, NULL); 
    1951 INSERT INTO `MemLevelActions` VALUES(3, 14, NULL, NULL, NULL, NULL, NULL); 
    1952 INSERT INTO `MemLevelActions` VALUES(3, 15, NULL, NULL, NULL, NULL, NULL); 
    1953 INSERT INTO `MemLevelActions` VALUES(3, 16, NULL, NULL, NULL, NULL, NULL); 
    1954 INSERT INTO `MemLevelActions` VALUES(3, 17, NULL, NULL, NULL, NULL, NULL); 
    1955 INSERT INTO `MemLevelActions` VALUES(2, 9, NULL, NULL, NULL, NULL, NULL); 
    1956 INSERT INTO `MemLevelActions` VALUES(2, 23, NULL, NULL, NULL, NULL, NULL); 
    1957 INSERT INTO `MemLevelActions` VALUES(2, 24, NULL, NULL, NULL, NULL, NULL); 
    1958 INSERT INTO `MemLevelActions` VALUES(1, 25, NULL, NULL, NULL, NULL, NULL); 
    1959 INSERT INTO `MemLevelActions` VALUES(2, 25, NULL, NULL, NULL, NULL, NULL); 
    1960 INSERT INTO `MemLevelActions` VALUES(3, 25, NULL, NULL, NULL, NULL, NULL); 
    1961 INSERT INTO `MemLevelActions` VALUES(3, 26, NULL, NULL, NULL, NULL, NULL); 
    1962 INSERT INTO `MemLevelActions` VALUES(2, 33, NULL, NULL, NULL, NULL, NULL); 
    1963 INSERT INTO `MemLevelActions` VALUES(2, 34, NULL, NULL, NULL, NULL, NULL); 
    1964  
    1965 -- -------------------------------------------------------- 
    1966  
    1967 -- 
    1968 -- Table structure for table `MemLevelPrices` 
    1969 -- 
    1970  
    1971 CREATE TABLE `MemLevelPrices` ( 
     1927-- Dumping data for table `sys_acl_matrix` 
     1928-- 
     1929 
     1930INSERT INTO `sys_acl_matrix` VALUES(1, 6, NULL, NULL, NULL, NULL, '10'); 
     1931INSERT INTO `sys_acl_matrix` VALUES(1, 7, NULL, NULL, NULL, NULL, NULL); 
     1932INSERT INTO `sys_acl_matrix` VALUES(1, 14, NULL, NULL, NULL, NULL, NULL); 
     1933INSERT INTO `sys_acl_matrix` VALUES(2, 1, 4, 24, NULL, NULL, NULL); 
     1934INSERT INTO `sys_acl_matrix` VALUES(2, 4, 2, 24, NULL, NULL, NULL); 
     1935INSERT INTO `sys_acl_matrix` VALUES(2, 6, 5, 24, NULL, NULL, '0'); 
     1936INSERT INTO `sys_acl_matrix` VALUES(2, 7, 15, 24, NULL, NULL, NULL); 
     1937INSERT INTO `sys_acl_matrix` VALUES(2, 8, 2, 24, NULL, NULL, NULL); 
     1938INSERT INTO `sys_acl_matrix` VALUES(3, 1, NULL, NULL, NULL, NULL, NULL); 
     1939INSERT INTO `sys_acl_matrix` VALUES(3, 2, NULL, NULL, NULL, NULL, NULL); 
     1940INSERT INTO `sys_acl_matrix` VALUES(3, 3, NULL, NULL, NULL, NULL, NULL); 
     1941INSERT INTO `sys_acl_matrix` VALUES(3, 4, NULL, NULL, NULL, NULL, NULL); 
     1942INSERT INTO `sys_acl_matrix` VALUES(3, 5, NULL, NULL, NULL, NULL, NULL); 
     1943INSERT INTO `sys_acl_matrix` VALUES(3, 6, NULL, NULL, NULL, NULL, NULL); 
     1944INSERT INTO `sys_acl_matrix` VALUES(3, 7, NULL, NULL, NULL, NULL, NULL); 
     1945INSERT INTO `sys_acl_matrix` VALUES(3, 8, NULL, NULL, NULL, NULL, NULL); 
     1946INSERT INTO `sys_acl_matrix` VALUES(3, 9, NULL, NULL, NULL, NULL, NULL); 
     1947INSERT INTO `sys_acl_matrix` VALUES(3, 10, NULL, NULL, NULL, NULL, NULL); 
     1948INSERT INTO `sys_acl_matrix` VALUES(3, 11, NULL, NULL, NULL, NULL, NULL); 
     1949INSERT INTO `sys_acl_matrix` VALUES(3, 12, NULL, NULL, NULL, NULL, NULL); 
     1950INSERT INTO `sys_acl_matrix` VALUES(3, 13, NULL, NULL, NULL, NULL, NULL); 
     1951INSERT INTO `sys_acl_matrix` VALUES(3, 14, NULL, NULL, NULL, NULL, NULL); 
     1952INSERT INTO `sys_acl_matrix` VALUES(3, 15, NULL, NULL, NULL, NULL, NULL); 
     1953INSERT INTO `sys_acl_matrix` VALUES(3, 16, NULL, NULL, NULL, NULL, NULL); 
     1954INSERT INTO `sys_acl_matrix` VALUES(3, 17, NULL, NULL, NULL, NULL, NULL); 
     1955INSERT INTO `sys_acl_matrix` VALUES(2, 9, NULL, NULL, NULL, NULL, NULL); 
     1956INSERT INTO `sys_acl_matrix` VALUES(2, 23, NULL, NULL, NULL, NULL, NULL); 
     1957INSERT INTO `sys_acl_matrix` VALUES(2, 24, NULL, NULL, NULL, NULL, NULL); 
     1958INSERT INTO `sys_acl_matrix` VALUES(1, 25, NULL, NULL, NULL, NULL, NULL); 
     1959INSERT INTO `sys_acl_matrix` VALUES(2, 25, NULL, NULL, NULL, NULL, NULL); 
     1960INSERT INTO `sys_acl_matrix` VALUES(3, 25, NULL, NULL, NULL, NULL, NULL); 
     1961INSERT INTO `sys_acl_matrix` VALUES(3, 26, NULL, NULL, NULL, NULL, NULL); 
     1962INSERT INTO `sys_acl_matrix` VALUES(2, 33, NULL, NULL, NULL, NULL, NULL); 
     1963INSERT INTO `sys_acl_matrix` VALUES(2, 34, NULL, NULL, NULL, NULL, NULL); 
     1964 
     1965-- -------------------------------------------------------- 
     1966 
     1967-- 
     1968-- Table structure for table `sys_acl_level_prices` 
     1969-- 
     1970 
     1971CREATE TABLE `sys_acl_level_prices` ( 
    19721972  `IDLevel` smallint(5) unsigned NOT NULL default '0', 
    19731973  `Days` int(10) unsigned NOT NULL default '1', 
    … …  
    19771977 
    19781978-- 
    1979 -- Dumping data for table `MemLevelPrices` 
    1980 -- 
    1981  
    1982  
    1983 -- -------------------------------------------------------- 
    1984  
    1985 -- 
    1986 -- Table structure for table `MemLevels` 
    1987 -- 
    1988  
    1989 CREATE TABLE `MemLevels` ( 
     1979-- Dumping data for table `sys_acl_level_prices` 
     1980-- 
     1981 
     1982 
     1983-- -------------------------------------------------------- 
     1984 
     1985-- 
     1986-- Table structure for table `sys_acl_levels` 
     1987-- 
     1988 
     1989CREATE TABLE `sys_acl_levels` ( 
    19901990  `ID` smallint(6) NOT NULL auto_increment, 
    19911991  `Name` varchar(100) NOT NULL default '', 
    … …  
    19981998 
    19991999-- 
    2000 -- Dumping data for table `MemLevels` 
    2001 -- 
    2002  
    2003 INSERT INTO `MemLevels` VALUES(1, 'Non-member', 'yes', 'no', 'no'); 
    2004 INSERT INTO `MemLevels` VALUES(2, 'Standard', 'yes', 'no', 'no'); 
    2005 INSERT INTO `MemLevels` VALUES(3, 'Promotion', 'yes', 'no', 'no'); 
     2000-- Dumping data for table `sys_acl_levels` 
     2001-- 
     2002 
     2003INSERT INTO `sys_acl_levels` VALUES(1, 'Non-member', 'yes', 'no', 'no'); 
     2004INSERT INTO `sys_acl_levels` VALUES(2, 'Standard', 'yes', 'no', 'no'); 
     2005INSERT INTO `sys_acl_levels` VALUES(3, 'Promotion', 'yes', 'no', 'no'); 
    20062006 
    20072007-- -------------------------------------------------------- 
    … …  
    21042104 
    21052105-- 
    2106 -- Table structure for table `NotifyEmails` 
    2107 -- 
    2108  
    2109 CREATE TABLE `NotifyEmails` ( 
     2106-- Table structure for table `sys_subscriptions` 
     2107-- 
     2108 
     2109CREATE TABLE `sys_subscriptions` ( 
    21102110  `ID` int(10) unsigned NOT NULL auto_increment, 
    21112111  `Name` varchar(64) NOT NULL default '', 
    … …  
    21172117 
    21182118-- 
    2119 -- Dumping data for table `NotifyEmails` 
    2120 -- 
    2121  
    2122  
    2123 -- -------------------------------------------------------- 
    2124  
    2125 -- 
    2126 -- Table structure for table `NotifyMsgs` 
    2127 -- 
    2128  
    2129 CREATE TABLE `NotifyMsgs` ( 
     2119-- Dumping data for table `sys_subscriptions` 
     2120-- 
     2121 
     2122 
     2123-- -------------------------------------------------------- 
     2124 
     2125-- 
     2126-- Table structure for table `sys_mass_messages` 
     2127-- 
     2128 
     2129CREATE TABLE `sys_mass_messages` ( 
    21302130  `ID` int(10) unsigned NOT NULL auto_increment, 
    21312131  `Subj` varchar(128) NOT NULL default '', 
    … …  
    21362136 
    21372137-- 
    2138 -- Dumping data for table `NotifyMsgs` 
    2139 -- 
    2140  
    2141  
    2142 -- -------------------------------------------------------- 
    2143  
    2144 -- 
    2145 -- Table structure for table `NotifyQueue` 
    2146 -- 
    2147  
    2148 CREATE TABLE `NotifyQueue` ( 
     2138-- Dumping data for table `sys_mass_messages` 
     2139-- 
     2140 
     2141 
     2142-- -------------------------------------------------------- 
     2143 
     2144-- 
     2145-- Table structure for table `sys_mail_queue` 
     2146-- 
     2147 
     2148CREATE TABLE `sys_mail_queue` ( 
    21492149  `Email` int(10) unsigned NOT NULL auto_increment, 
    21502150  `Msg` int(10) unsigned NOT NULL default '0', 
    … …  
    21582158 
    21592159-- 
    2160 -- Dumping data for table `NotifyQueue` 
     2160-- Dumping data for table `sys_mail_queue` 
    21612161-- 
    21622162 
Note: See TracChangeset for help on using the changeset viewer.
 
 

Site Search

Market

Notes

Websites

About BoonEx• Contacts• © BoonEx (ACN 127966581)