Сорри за длинный запрос, но может, кто шарит в sql синтаксисе, подскажет, чё ему не нравится?
Код: Выделить всё
CREATE DATABASE freenibs;
use freenibs;
GRANT USAGE ON freenibs.* to freenibs@localhost;
GRANT SELECT,UPDATE,INSERT,DELETE,CREATE,DROP,ALTER,INDEX ON freenibs.* to freenibs@localhost;
SET PASSWORD FOR "freenibs"@"localhost"=PASSWORD("** pass **");
CREATE TABLE `users` (
`user` varchar(64) binary NOT NULL default '', # User name (login)
`password` varchar(64) binary NOT NULL default '*', # User password
# not used when `auth_type` != '0' or `no_pass` set to '1'
# always used in user's web interface!
`auth_type` tinyint(1) unsigned NOT NULL default '0', # User authorization method:
# 0 - password
# 1 - Caller ID
# 2 - MAC address
# 3 - IP address
`auth_info` varchar(64) binary NOT NULL default '', # User authorization info (depends on `auth_type`):
# if auth_type = '1' - Caller ID
# if auth_type = '2' - hardware MAC address
# if auth_type = '3' - IP address
`uid` bigint(20) unsigned NOT NULL auto_increment, # Unique user identifier (number)
`master_uid` bigint(15) unsigned NOT NULL default '0', # Unique identifier of the owner of the given user record
`gid` bigint(15) unsigned NOT NULL default '1', # Group identifier (number) (group to which belongs the given user)
`deposit` double(16,6) NOT NULL default '0.000000', # Sum of the deposit (in currency of billing)
`credit` double(16,6) NOT NULL default '0.000000', # Maximal sum of the credit for current user record (in currency of billing)
`add_date` datetime NOT NULL default '0000-00-00 00:00:00', # Date when record was added
`tos` tinyint(1) unsigned default NULL, # Count money for:
# 0 - don't count
# 1 - time
# 2 - traffic
# 3 - time + traffic
# 4 - traffic with gradation of volume
`do_with_tos` tinyint(1) unsigned default NULL, # Remove money from the deposit and to check their presence:
# 0 - no, just write record to `actions` (used only with money limits)
# 1 - yes and write record to `actions`
`direction` tinyint(1) unsigned default NULL, # What traffic to count (relative to NAS! e.g. if you want count users incoming traffic you must select '1'):
# 0 - don't count
# 1 - outgoing
# 2 - incoming
# 3 - total (outgoing + incoming)
# 4 - max per connection
# 5 - min per connection
`fixed` tinyint(1) unsigned default NULL, # Removal of the fixed sum:
# 0 - don't remove
# 1 - once per day, if there was a connection
# 2 - every day including for previous
# 3 - on every connect
`fixed_cost` double(16,6) default NULL, # Quantity of money for removal
`activation_time` bigint(15) default NULL, # Activation time (in seconds) (in what current of time the user will have access(activated))
# Restrictions for current user on time:
`day_time_limit` bigint(15) NULL, # - in day
`week_time_limit` bigint(15) NULL, # - in week
`month_time_limit` bigint(15) NULL, # - in month
`total_time_limit` bigint(15), # - full
# Restrictions for current user on traffic:
`day_traffic_limit` bigint(15) NULL, # - in day
`week_traffic_limit` bigint(15) NULL, # - in week
`month_traffic_limit` bigint(15) NULL, # - in month
`total_traffic_limit` bigint(15) NULL, # - full
# Restrictions for current user on money:
`day_money_limit` double(16,6) NULL, # - in day
`week_money_limit` double(16,6) NULL, # - in week
`month_money_limit` double(16,6) NULL, # - in month
`total_money_limit` double(16,6) NULL, # - full
`login_time` varchar(254) default NULL, # Text string for definition of the resolved intervals of connection
# format - comma separated intervals, consisting from day and time (DDHHMM-HHMM) or day (DD)
# Supported days:
# Su - Sunday
# Mo - Monday
# Tu - Tuesday
# We - Wednesday
# Th - Thursday
# Fr - Friday
# Sa - Saturday
# Wk - Week-days (Mo, Tu, We, Th, Fr)
# Al - all days
# Hl - holydays
# for example, string 'Wk0000-0800,Sa,Su,Hl2200-1000' in human readable form means:
# "allow connection 'from monday to riday - from 00.00 to 08.00 (night), saturday and sunday - any time, holydays - from 22.00 to 10.00'"
`huntgroup_name` varchar(64) default NULL,
`simultaneous_use` smallint(3) unsigned default NULL,
`port_limit` smallint(3) unsigned default NULL,
`session_timeout` bigint(15) default NULL,
`idle_timeout` bigint(15) default NULL,
`no_pass` tinyint(1) unsigned default NULL,
`no_acct` tinyint(1) unsigned default NULL,
`allow_callback` tinyint(1) unsigned default NULL, # Allow callback for current user or not
`callback_number` varchar(64) NOT NULL default '', # Callback phone number
`other_params` varchar(254) default NULL,
`allowed_servers` varchar(254) default NULL,
`blocked` tinyint(1) unsigned NOT NULL default '1',
`activated` tinyint(1) unsigned NOT NULL default '0',
`expired` date NOT NULL default '0000-00-00',
`total_time` bigint(15) NOT NULL default '0',
`total_traffic` bigint(15) NOT NULL default '0',
`total_money` double(16,6) NOT NULL default '0.000000',
`last_connection` datetime NOT NULL default '0000-00-00 00:00:00',
`framed_ip` varchar(16) NOT NULL default '',
`framed_mask` varchar(15) NOT NULL default '',
`up` int(5) default NULL,
`down` int(5) default NULL,
`ippool_name` varchar(64) NULL,
PRIMARY KEY (`uid`)
) TYPE=MyISAM;
# N.B. Fields having names similar to the table users - are not described
CREATE TABLE `d_groups` (
`gid` bigint(15) unsigned NOT NULL auto_increment, # Unique grop identifier (number)
`packet` varchar(128) NOT NULL default '',
`deposit` double(16,6) NOT NULL default '0.000000',
`credit` double(16,6) NOT NULL default '0.000000',
`tos` tinyint(1) unsigned NOT NULL default '0',
`do_with_tos` tinyint(1) unsigned NOT NULL default '1',
`direction` tinyint(1) unsigned NOT NULL default '0',
`fixed` tinyint(1) unsigned NOT NULL default '0',
`fixed_cost` double(16,6) NOT NULL default '0.000000',
`activated` tinyint(1) unsigned NOT NULL default '1',
`activation_time` int(10) NOT NULL default '2678400',
`blocked` tinyint(1) unsigned NOT NULL default '0',
`total_time_limit` bigint(15) unsigned NOT NULL default '0',
`month_time_limit` bigint(15) unsigned NOT NULL default '0',
`week_time_limit` bigint(15) unsigned NOT NULL default '0',
`day_time_limit` bigint(15) unsigned NOT NULL default '0',
`total_traffic_limit` bigint(15) unsigned NOT NULL default '0',
`month_traffic_limit` bigint(15) unsigned NOT NULL default '0',
`week_traffic_limit` bigint(15) unsigned NOT NULL default '0',
`day_traffic_limit` bigint(15) unsigned NOT NULL default '0',
`total_money_limit` double(16,6) NOT NULL default '0.000000',
`month_money_limit` double(16,6) NOT NULL default '0.000000',
`week_money_limit` double(16,6) NOT NULL default '0.000000',
`day_money_limit` double(16,6) NOT NULL default '0.000000',
`login_time` varchar(254) NOT NULL default '',
`huntgroup_name` varchar(64) NOT NULL default '',
`simultaneous_use` smallint(3) unsigned NOT NULL default '0',
`port_limit` smallint(3) unsigned NOT NULL default '0',
`session_timeout` bigint(15) unsigned NOT NULL default '0',
`idle_timeout` bigint(15) unsigned NOT NULL default '0',
`framed_ip` varchar(16) NOT NULL default '',
`framed_mask` varchar(15) NOT NULL default '',
`no_pass` tinyint(1) unsigned NOT NULL default '0',
`no_acct` tinyint(1) unsigned NOT NULL default '0',
`allow_callback` tinyint(1) unsigned NOT NULL default '0',
`other_params` varchar(254) NOT NULL default 'Acct-Interim-Interval = 60, Service-Type = Framed-User, Framed-Protocol = PPP',
`allowed_servers` varchar(254) default NULL,
`up` int(5) default NULL,
`down` int(5) default NULL,
`ippool_name` varchar(64) NULL,
PRIMARY KEY (`gid`)
) TYPE=MyISAM;
CREATE TABLE `actions` (
`user` varchar(64) NOT NULL default '', # User name (login)
`uid` bigint(20) unsigned NOT NULL default '0', # Unique user identifier (number)
`gid` bigint(15) unsigned NOT NULL default '0', # Group identifier (number) (group to which belongs the given user)
`id` varchar(64) NOT NULL default '', # Session identifier
`unique_id` varchar(64) NOT NULL default '', # Unique session identifier
`connect_info` varchar(254) default NULL,
`time_on` bigint(15) unsigned NOT NULL default '0', # Duration of connection (in seconds)
`start_time` datetime NOT NULL default '2005-01-01 00:00:00', # Time when connection started
`stop_time` datetime NOT NULL default '0000-00-00 00:00:00', # Time when connection ended
`in_bytes` bigint(15) unsigned NOT NULL default '0',
`out_bytes` bigint(15) unsigned NOT NULL default '0',
`ip` int(10) unsigned NOT NULL default '0',
`server` int(10) unsigned NOT NULL default '0', # NAS IP address
`client_ip` int(10) unsigned NOT NULL default '0', # User IP address
`port` int(5) unsigned NOT NULL default '0',
`call_to` varchar(64) NOT NULL default '',
`call_from` varchar(64) NOT NULL default '',
`protocol` varchar(12) default NULL,
`terminate_cause` varchar(64) NOT NULL default '',
`hour_in_bytes` bigint(15) unsigned NOT NULL default '0',
`hour_out_bytes` bigint(15) unsigned NOT NULL default '0',
`hour_traffic_money` double(16,6) NOT NULL default '0.000000',
`last_change` int(10) unsigned NOT NULL default '0',
`before_billing` double(16,6) NOT NULL default '0.000000',
`billing_minus` double(16,6) NOT NULL default '0.000000',
PRIMARY KEY (`unique_id`)
) TYPE=MyISAM;
CREATE TABLE `prices` (
`gid` bigint(15) unsigned NOT NULL default '1',
`week_day` tinyint(1) unsigned NOT NULL default '0',
`h0` double(10,6) NOT NULL default '0.000000',
`input0` double(10,6) NOT NULL default '0.000000',
`output0` double(10,6) NOT NULL default '0.000000',
`h1` double(10,6) NOT NULL default '0.000000',
`input1` double(10,6) NOT NULL default '0.000000',
`output1` double(10,6) NOT NULL default '0.000000',
`h2` double(10,6) NOT NULL default '0.000000',
`input2` double(10,6) NOT NULL default '0.000000',
`output2` double(10,6) NOT NULL default '0.000000',
`h3` double(10,6) NOT NULL default '0.000000',
`input3` double(10,6) NOT NULL default '0.000000',
`output3` double(10,6) NOT NULL default '0.000000',
`h4` double(10,6) NOT NULL default '0.000000',
`input4` double(10,6) NOT NULL default '0.000000',
`output4` double(10,6) NOT NULL default '0.000000',
`h5` double(10,6) NOT NULL default '0.000000',
`input5` double(10,6) NOT NULL default '0.000000',
`output5` double(10,6) NOT NULL default '0.000000',
`h6` double(10,6) NOT NULL default '0.000000',
`input6` double(10,6) NOT NULL default '0.000000',
`output6` double(10,6) NOT NULL default '0.000000',
`h7` double(10,6) NOT NULL default '0.000000',
`input7` double(10,6) NOT NULL default '0.000000',
`output7` double(10,6) NOT NULL default '0.000000',
`h8` double(10,6) NOT NULL default '0.000000',
`input8` double(10,6) NOT NULL default '0.000000',
`output8` double(10,6) NOT NULL default '0.000000',
`h9` double(10,6) NOT NULL default '0.000000',
`input9` double(10,6) NOT NULL default '0.000000',
`output9` double(10,6) NOT NULL default '0.000000',
`h10` double(10,6) NOT NULL default '0.000000',
`input10` double(10,6) NOT NULL default '0.000000',
`output10` double(10,6) NOT NULL default '0.000000',
`h11` double(10,6) NOT NULL default '0.000000',
`input11` double(10,6) NOT NULL default '0.000000',
`output11` double(10,6) NOT NULL default '0.000000',
`h12` double(10,6) NOT NULL default '0.000000',
`input12` double(10,6) NOT NULL default '0.000000',
`output12` double(10,6) NOT NULL default '0.000000',
`h13` double(10,6) NOT NULL default '0.000000',
`input13` double(10,6) NOT NULL default '0.000000',
`output13` double(10,6) NOT NULL default '0.000000',
`h14` double(10,6) NOT NULL default '0.000000',
`input14` double(10,6) NOT NULL default '0.000000',
`output14` double(10,6) NOT NULL default '0.000000',
`h15` double(10,6) NOT NULL default '0.000000',
`input15` double(10,6) NOT NULL default '0.000000',
`output15` double(10,6) NOT NULL default '0.000000',
`h16` double(10,6) NOT NULL default '0.000000',
`input16` double(10,6) NOT NULL default '0.000000',
`output16` double(10,6) NOT NULL default '0.000000',
`h17` double(10,6) NOT NULL default '0.000000',
`input17` double(10,6) NOT NULL default '0.000000',
`output17` double(10,6) NOT NULL default '0.000000',
`h18` double(10,6) NOT NULL default '0.000000',
`input18` double(10,6) NOT NULL default '0.000000',
`output18` double(10,6) NOT NULL default '0.000000',
`h19` double(10,6) NOT NULL default '0.000000',
`input19` double(10,6) NOT NULL default '0.000000',
`output19` double(10,6) NOT NULL default '0.000000',
`h20` double(10,6) NOT NULL default '0.000000',
`input20` double(10,6) NOT NULL default '0.000000',
`output20` double(10,6) NOT NULL default '0.000000',
`h21` double(10,6) NOT NULL default '0.000000',
`input21` double(10,6) NOT NULL default '0.000000',
`output21` double(10,6) NOT NULL default '0.000000',
`h22` double(10,6) NOT NULL default '0.000000',
`input22` double(10,6) NOT NULL default '0.000000',
`output22` double(10,6) NOT NULL default '0.000000',
`h23` double(10,6) NOT NULL default '0.000000',
`input23` double(10,6) NOT NULL default '0.000000',
`output23` double(10,6) NOT NULL default '0.000000',
`servers` varchar(254) default NULL,
`type` tinyint(1) NOT NULL default '0',
`uid` bigint(20) unsigned default NULL
) TYPE=MyISAM;
CREATE TABLE `holidays` (
`holiday_date` date NOT NULL default '2005-01-01',
`comment` varchar(64) NOT NULL default '',
PRIMARY KEY (`holiday_date`)
) TYPE=MyISAM;
CREATE TABLE `blacklist` (
`id` int(10) unsigned NOT NULL auto_increment,
`uid` bigint(20) unsigned default NULL,
`gid` bigint(15) unsigned default NULL,
`phone` varchar(64) NOT NULL default '',
`permit` tinyint(1) unsigned NOT NULL default '1',
`comment` varchar(128) default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
В ругани он вот этот самый "TYPE=MyISAM" чё то там всё упоминает...