/[sumusu]/sumusu_db.sql
ViewVC logotype

Contents of /sumusu_db.sql

Parent Directory Parent Directory | Revision Log Revision Log

Revision 17 - (show annotations) (download)
Mon Dec 12 23:11:20 2005 UTC (7 years, 6 months ago) by bilbo
File size: 5859 byte(s) 
added database file
1 -- MySQL dump 10.10
2 --
3 -- Host: localhost Database: sumusudb
4 -- ------------------------------------------------------
5 -- Server version 5.0.13-rc-Debian_1-log
6
7 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10 /*!40101 SET NAMES utf8 */;
11 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
12 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
13 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
14 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
15
16 --
17 -- Table structure for table `authtypes`
18 --
19
20 DROP TABLE IF EXISTS `authtypes`;
21 CREATE TABLE `authtypes` (
22 `id` int(11) NOT NULL auto_increment,
23 `authtype` enum('AUTH_USER','AUTH_IP') NOT NULL,
24 `authtoken` varchar(255) NOT NULL,
25 `authextra` varchar(255) NOT NULL,
26 `provider` int(11) NOT NULL,
27 PRIMARY KEY (`id`),
28 KEY `authtypes_fk_provider` (`provider`),
29 CONSTRAINT `authtypes_fk_provider` FOREIGN KEY (`provider`) REFERENCES `provider` (`id`) ON DELETE CASCADE
30 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
31
32 --
33 -- Dumping data for table `authtypes`
34 --
35
36
37 /*!40000 ALTER TABLE `authtypes` DISABLE KEYS */;
38 LOCK TABLES `authtypes` WRITE;
39 INSERT INTO `authtypes` VALUES (1,'AUTH_IP','217.19.92.2','',1),(2,'AUTH_IP','212.205.81.12','',1),(3,'AUTH_IP','213.5.44.102','',1),(4,'AUTH_IP','83.235.227.173','',1),(5,'AUTH_IP','127.0.0.1','',1);
40 UNLOCK TABLES;
41 /*!40000 ALTER TABLE `authtypes` ENABLE KEYS */;
42
43 --
44 -- Table structure for table `messages`
45 --
46
47 DROP TABLE IF EXISTS `messages`;
48 CREATE TABLE `messages` (
49 `id` int(11) NOT NULL auto_increment,
50 `rc` int(11) NOT NULL,
51 `message` varchar(255) NOT NULL,
52 `provider` int(11) NOT NULL,
53 PRIMARY KEY (`id`),
54 KEY `messages_fk_provider` (`provider`),
55 CONSTRAINT `messages_fk_provider` FOREIGN KEY (`provider`) REFERENCES `provider` (`id`) ON DELETE CASCADE
56 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
57
58 --
59 -- Dumping data for table `messages`
60 --
61
62
63 /*!40000 ALTER TABLE `messages` DISABLE KEYS */;
64 LOCK TABLES `messages` WRITE;
65 UNLOCK TABLES;
66 /*!40000 ALTER TABLE `messages` ENABLE KEYS */;
67
68 --
69 -- Table structure for table `msisdnservice`
70 --
71
72 DROP TABLE IF EXISTS `msisdnservice`;
73 CREATE TABLE `msisdnservice` (
74 `id` int(11) NOT NULL auto_increment,
75 `charge` decimal(10,0) NOT NULL,
76 `provider` int(11) NOT NULL,
77 PRIMARY KEY (`id`),
78 KEY `msisdn_fk_provider` (`provider`),
79 CONSTRAINT `msisdn_fk_provider` FOREIGN KEY (`provider`) REFERENCES `provider` (`id`) ON DELETE CASCADE
80 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
81
82 --
83 -- Dumping data for table `msisdnservice`
84 --
85
86
87 /*!40000 ALTER TABLE `msisdnservice` DISABLE KEYS */;
88 LOCK TABLES `msisdnservice` WRITE;
89 UNLOCK TABLES;
90 /*!40000 ALTER TABLE `msisdnservice` ENABLE KEYS */;
91
92 --
93 -- Table structure for table `provider`
94 --
95
96 DROP TABLE IF EXISTS `provider`;
97 CREATE TABLE `provider` (
98 `name` varchar(255) character set utf8 NOT NULL,
99 `address` varchar(255) character set utf8 NOT NULL,
100 `contact` varchar(255) collate utf8_bin NOT NULL,
101 `email` varchar(255) collate utf8_bin NOT NULL,
102 `telephone` varchar(255) collate utf8_bin NOT NULL,
103 `id` int(11) NOT NULL auto_increment,
104 PRIMARY KEY (`id`,`name`)
105 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
106
107 --
108 -- Dumping data for table `provider`
109 --
110
111
112 /*!40000 ALTER TABLE `provider` DISABLE KEYS */;
113 LOCK TABLES `provider` WRITE;
114 INSERT INTO `provider` VALUES ('M-STAT','Αθήνα','Χριστίνα Μανουσάκη','c.manousaki@m-stat.gr','2103389590',1);
115 UNLOCK TABLES;
116 /*!40000 ALTER TABLE `provider` ENABLE KEYS */;
117
118 --
119 -- Table structure for table `smsfields`
120 --
121
122 DROP TABLE IF EXISTS `smsfields`;
123 CREATE TABLE `smsfields` (
124 `id` int(11) NOT NULL auto_increment,
125 `field` varchar(255) NOT NULL,
126 `regexp` varchar(255) NOT NULL,
127 `provider` int(11) NOT NULL,
128 `fieldtype` enum('MSGID','MSISDN','SIMCARDTYPE','CARRIER','SERVICE','SMSTEXT') NOT NULL,
129 PRIMARY KEY (`id`),
130 KEY `smsfields_fk_provider` (`provider`),
131 CONSTRAINT `smsfields_fk_provider` FOREIGN KEY (`provider`) REFERENCES `provider` (`id`) ON DELETE CASCADE
132 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
133
134 --
135 -- Dumping data for table `smsfields`
136 --
137
138
139 /*!40000 ALTER TABLE `smsfields` DISABLE KEYS */;
140 LOCK TABLES `smsfields` WRITE;
141 INSERT INTO `smsfields` VALUES (1,'msgid','[\\d]{6}',1,'MSGID'),(2,'msisdn','(|+)3069[\\d]{8}',1,'MSISDN'),(3,'simcardtype','(C|P)',1,'SIMCARDTYPE'),(4,'carrier','(C|V|T|Q)',1,'CARRIER'),(5,'service','[\\d]{4}',1,'SERVICE'),(6,'sms','.*',1,'SMSTEXT');
142 UNLOCK TABLES;
143 /*!40000 ALTER TABLE `smsfields` ENABLE KEYS */;
144
145 --
146 -- Table structure for table `smsservice`
147 --
148
149 DROP TABLE IF EXISTS `smsservice`;
150 CREATE TABLE `smsservice` (
151 `id` varchar(255) NOT NULL,
152 `begints` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
153 `endts` timestamp NOT NULL default '0000-00-00 00:00:00',
154 `provider` int(11) NOT NULL,
155 PRIMARY KEY (`id`),
156 KEY `smsservice_fk_provider` (`provider`),
157 CONSTRAINT `smsservice_fk_provider` FOREIGN KEY (`provider`) REFERENCES `provider` (`id`) ON DELETE CASCADE
158 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
159
160 --
161 -- Dumping data for table `smsservice`
162 --
163
164
165 /*!40000 ALTER TABLE `smsservice` DISABLE KEYS */;
166 LOCK TABLES `smsservice` WRITE;
167 UNLOCK TABLES;
168 /*!40000 ALTER TABLE `smsservice` ENABLE KEYS */;
169
170 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
171 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
172 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
173 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
174 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
175 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
176 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
177
  ViewVC Help
Powered by ViewVC 1.1.5